AMASSETTRF – Asset Transfer

System
Asset Management (AM)
Prefix
ATF
Primary key
ASSET, PROCESS-SEQ
Fields
73
Updated by
269 programs
Referenced by
16 programs

AMASSETTRF is the Asset Transfer table in Lawson Asset Management (prefix ATF). It is indexed by ASSET, PROCESS-SEQ (ATFSET1); alternate indexes: ATFSET2, ATFSET3, ATFSET4, ATFSET5, ATFSET6, ATFSET7, ATFSET8 and ATFSET9. It is related 1:1 to AMASSET, AMASTTYPE, AMCONTROL, AMDIVISION and AMLOCATION and 1:M to AMASTBKTRF. It is updated by AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 and 261 more and referenced by AM145, AM155, AM190, AM192, AM230, AM235, AM281, AM40.1 and 8 more. The table has 73 fields, 9 indexes and 8 documented relations.

About AMASSETTRF

This file contains historical asset information related to transfers. It is updated by AM30.1 (Transfers) and AM30.2 (Items).

Fields (73)

Column = COBOL field name without the ATF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ATF-ASSET PK
ASSET
Numeric 10Required. The asset number contains up to ten numeric characters that uniquely identify a transfer-from asset. Assets are automatically numbered system-wide.AM135, AM154, AM30.1
ATF-PROCESS-SEQ PK
PROCESS_SEQ
Numeric 6Key field. This is the sequence number for the process.AM135, AM154, AM30.1
ATF-TO-ASSET
TO_ASSET
Numeric 10This is the to-asset for the transfer.AM135, AM154, AM30.1, AM30.2
ATF-TRF-STATUS
TRF_STATUS
Alpha 1This is the status of the transfer. Valid values are:
  • R Released
  • N Not Released
AM135, AM154, AM170, AM30.1
ATF-TRANSFER-DATE
TRANSFER_DATE
Numeric 8 (yyyymmdd)This is the date the asset was transferred.AM135, AM154, AM30.1
ATF-TRANSFER-TYPE
TRANSFER_TYPE
Alpha 1This is the type of the transfer. Valid values are:
  • T Intracompany
  • I Intercompany
AM135, AM154, AM30.1
ATF-TRF-QUANTITY
TRF_QUANTITY
Numeric 10This is the asset quantity transferred.AM135, AM154, AM30.1, AM30.2
ATF-FULL-PARTIAL
FULL_PARTIAL
Alpha 1This field indicates whether the transfer is full (including all asset items) or partial (including only some asset items). Valid values are:
  • F Full
  • P Partial
AM135, AM154, AM30.1
ATF-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the transfer description.AM135, AM154, AM30.1
ATF-TAG-NBR
TAG_NBR
Alpha 12This is the tag number, a user-definable identifier, for the transfer-from asset.AM135, AM154, AM30.1
ATF-TO-TAG-NBR
TO_TAG_NBR
Alpha 12This is the tag number for the to-asset.AM135, AM154, AM30.1
ATF-LEASE-COMPANY
LEASE_COMPANY
Numeric 4The lessor company for the transferred leased asset.AM135, AM154, AM30.1
ATF-LEASE
LEASE
Alpha 19The lease number with which a transferred leased asset is associated.AM135, AM154, AM30.1
ATF-CLASSIFICATION
CLASSIFICATION
Alpha 1AM135, AM154, AM30.1
ATF-ASSET-GROUP
ASSET_GROUP
Alpha 10This is the asset group for the transferred asset. An asset group represents a parent asset used for reporting purposes.AM135, AM154, AM30.1
ATF-TO-ASSET-GROUP
TO_ASSET_GROUP
Alpha 10This is the asset group, if any, for the to-asset.AM135, AM154, AM30.1
ATF-OBJ-ID
OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AM135, AM154, AM30.1
ATF-TO-OBJ-ID
TO_OBJ_ID
Numeric 12This is the object identifier for the to-asset. The object identifier is a unique key used to attach a list of user-defined attributes.AM135, AM154, AM30.1, AM30.2
ATF-ASSET-CATEGORY
ASSET_CATEGORY
Alpha 1This is the category for the asset. Valid values are:
  • D Depreciable
  • N Non Depreciable
AM135, AM154, AM30.1
ATF-SIMULATED
SIMULATED
Alpha 1This field indicates whether the asset is simulated.AM135, AM154, AM30.1
ATF-WORK-IN-PROC
WORK_IN_PROC
Alpha 1This field indicates whether the asset is a work-in-process asset.AM135, AM154, AM30.1
ATF-TAX-EXEMPT
TAX_EXEMPT
Alpha 1This field indicates whether the asset is tax exempt.AM135, AM154, AM30.1
ATF-USED
USED
Alpha 1This field indicates whether the asset is used. Valid values are
  • Y Yes
  • N No
AM135, AM154, AM30.1
ATF-ITEM-TOT-QTY
ITEM_TOT_QTY
Numeric 10This is the total item quantity for the from-asset.AM135, AM154, AM30.1
ATF-TO-IT-TOT-QTY
TO_IT_TOT_QTY
Numeric 10This is the total item quantity for the to-asset.AM135, AM154, AM30.1, AM30.2
ATF-IT-TOT-CSTBASE
IT_TOT_CSTBASE
Signed 18.2This is the total item cost for the from-asset in the base currency.AM135, AM154, AM30.1
ATF-FR-IT-TOTCSTBS
FR_IT_TOTCSTBS
Signed 18.2AM135, AM154, AM30.1, AM30.2
ATF-TO-IT-TOTCSTBS
TO_IT_TOTCSTBS
Signed 18.2This is the total item cost for the to-asset. If the from-company and the to-company have different base currencies, the from-company currency is used.AM135, AM154, AM30.1, AM30.2
ATF-IT-TOT-TAXBASE
IT_TOT_TAXBASE
Signed 18.2This is the total item tax in the base currency for the from-asset.AM135, AM154, AM30.1
ATF-FR-IT-TOTTAXBS
FR_IT_TOTTAXBS
Signed 18.2AM135, AM154, AM30.1, AM30.2
ATF-TO-IT-TOTTAXBS
TO_IT_TOTTAXBS
Signed 18.2This is the total item tax for the to-asset.If the from-company and to-company have different currencies, the from-company currency is used.AM135, AM154, AM30.1, AM30.2
ATF-IT-TOT-CSTTRAN
IT_TOT_CSTTRAN
Signed 18.2This is the total item cost in the transaction currency for the from-asset.AM135, AM154, AM30.1
ATF-TO-IT-TOTCSTTR
TO_IT_TOTCSTTR
Signed 18.2This is the total item cost in the transaction currency for the to-asset.AM135, AM154, AM30.1, AM30.2
ATF-IT-TOT-TAXTRAN
IT_TOT_TAXTRAN
Signed 18.2This is the total item tax in the transaction currency for the from-asset.AM135, AM154, AM30.1
ATF-TO-IT-TOTTAXTR
TO_IT_TOTTAXTR
Signed 18.2This is the total item tax in the transaction currency for the to-asset.AM135, AM154, AM30.1, AM30.2
ATF-BASE-ND
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.AM135, AM154, AM30.1
ATF-TO-BASE-ND
TO_BASE_ND
Numeric 1This is the number of decimal positions defined in the company base currency for the to-asset.AM135, AM154, AM30.1, AM30.2
ATF-TRAN-ND
TRAN_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AM135, AM154, AM30.1
ATF-TO-TRAN-ND
TO_TRAN_ND
Numeric 1The number of decimal positions defined in the transaction currency for the to-asset.AM135, AM30.1
ATF-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AM135, AM154, AM30.1
ATF-TO-CURR-CODE
TO_CURR_CODE
Alpha 5This is the company base currency code for the to-asset.AM135, AM154, AM30.1
ATF-ITEM-LAST-DATE
ITEM_LAST_DATE
Numeric 8 (yyyymmdd)This is the last changed date for the item.AM135, AM154, AM30.1
ATF-TO-IT-LAST-DT
TO_IT_LAST_DT
Numeric 8 (yyyymmdd)This is the last changed date for the to-asset item.AM135, AM154, AM30.1, AM30.2
ATF-ITEM-LAST-SEQ
ITEM_LAST_SEQ
Numeric 6This is the last sequence number for the last change to the item.AM135, AM154, AM30.1
ATF-TO-IT-LAST-SEQ
TO_IT_LAST_SEQ
Numeric 6This is the last sequence number for the last change to the to-asset item.AM135, AM154, AM30.1, AM30.2
ATF-COMPANY
COMPANY
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AM135, AM154, AM30.1
ATF-TO-COMPANY
TO_COMPANY
Numeric 4This is the company number for the to-asset.AM135, AM154, AM30.1
ATF-LOCATION-NAME
LOCATION_NAME
Alpha 15This is a user-defined location name for the from-asset.AM135, AM154, AM30.1
ATF-TO-LOCATION
TO_LOCATION
Alpha 15This is the location for the to-asset.AM135, AM154, AM30.1
ATF-DIVISION
DIVISION
Alpha 15This is a user-defined division name for the from-asset. Divisions can be used in reporting on assets.AM135, AM154, AM30.1
ATF-TO-DIVISION
TO_DIVISION
Alpha 15This is the division name for the to-asset.AM135, AM154, AM30.1
ATF-ASSET-TYPE
ASSET_TYPE
Alpha 10An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data.AM135, AM154, AM30.1
ATF-TO-ASSET-TYPE
TO_ASSET_TYPE
Alpha 10This is the type for the to-asset. An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data.AM135, AM154, AM30.1
ATF-SUB-TYPE
SUB_TYPE
Alpha 10An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. Subtypes must be unique within an asset type.AM135, AM154, AM30.1
ATF-TO-SUB-TYPE
TO_SUB_TYPE
Alpha 10This is the to-asset subtype. An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. Subtypes must be unique within an asset type.AM135, AM154, AM30.1
ATF-ACCT-GRP
ACCT_GRP
Alpha 10This is the user-defined account group for the from-asset, identifying the general ledger accounts used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of).AM135, AM154, AM30.1
ATF-TO-ACCT-GRP
TO_ACCT_GRP
Alpha 10This is the account group for the to-asset. An account group is a user-defined grouping of accounts, identifying the general ledger accounts used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of).AM135, AM154, AM30.1
ATF-ACCT-UNIT
ACCT_UNIT
Alpha 15This is the accounting unit for the from-asset. An accounting unit is a shorthand notation representing a variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AM135, AM154, AM30.1
ATF-TO-ACCT-UNIT
TO_ACCT_UNIT
Alpha 15This is the accounting unit for the to-asset. An accounting unit is a shorthand notation representing a variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AM135, AM154, AM30.1
ATF-AU-GROUP
AU_GROUP
Alpha 10Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company.AM135, AM154, AM30.1
ATF-TO-AU-GROUP
TO_AU_GROUP
Alpha 10Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company.AM135, AM154, AM30.1
ATF-ORIG-CO
ORIG_CO
Numeric 4This field contains the original company number when the asset record was added to this file. This field is never changed after being added.AM135, AM154, AM30.1
ATF-SELECT-NAME
SELECT_NAME
Alpha 15This is the name of the selection for the mass transfer.AM135
ATF-TO-LOC-DTL
TO_LOC_DTL
Alpha 14This is the location detail to which the item is being transferred.AM154, AM30.1
ATF-CREATION-DATE
CREATION_DATE
Numeric 8 (yyyymmdd)This is the date that this transfer was created.AM135, AM154, AM30.1
ATF-CREATION-TIME
CREATION_TIME
Numeric 6 (hhmmss)This is the time that the transfer was created.AM135, AM154, AM30.1
ATF-CREATOR-ID
CREATOR_ID
Alpha 10This is the ID of the person who created the transfer.AM135, AM154, AM30.1
ATF-AST-DESCRIP
AST_DESCRIP
DerivedThis is the description of the transferred asset.
ATF-BLANKAM
BLANKAM
DerivedThis field consists of blank spaces. It is used to provide column headings on Drill Arounds.
ATF-ACTIVITY
ACTIVITY
Alpha 15
ATF-TO-ACTIVITY
TO_ACTIVITY
Alpha 15
ATF-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5
ATF-TO-ACCT-CAT
TO_ACCT_CAT
Alpha 5

Indexes (9)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATFSET1ASSET, PROCESS-SEQPrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ATFSET2COMPANY, ASSET, PROCESS-SEQKeyChange, SubsetWhere TRF-STATUS = "R"AM230, AM235, AM281, AM300, AM320
ATFSET3LOCATION-NAME, ASSET, PROCESS-SEQKeyChange, SubsetWhere TRF-STATUS = "R"
ATFSET4DIVISION, ASSET, PROCESS-SEQKeyChange, SubsetWhere TRF-STATUS = "R"
ATFSET5COMPANY, ASSET-TYPE, SUB-TYPE, ASSET, PROCESS-SEQKeyChange, SubsetWhere TRF-STATUS = "R"
ATFSET6TO-COMPANY, TO-ASSET, ASSET, PROCESS-SEQKeyChange, SubsetWhere TRF-STATUS = "N"AM135, AM230
ATFSET7ASSET, PROCESS-SEQSubsetWhere TRF-STATUS = "N"AM135, AM170, AM230, AM235, AM30.1, AM30.2, AM30.3
ATFSET8ASSET, PROCESS-SEQSubsetWhere TRF-STATUS = "R"
ATFSET9TO-COMPANY, TO-ASSET, ASSET, PROCESS-SEQKeyChange, SubsetWhere TRF-STATUS = "R"AM170, AM230, AM235

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot RequiredATF-ASSETAST-ASSET
AmassettoAMASSETNot RequiredATF-TO-ASSETAST-ASSET
AmasttypeAMASTTYPENot RequiredATF-COMPANYATP-COMPANY, ATF-ASSET-TYPEATP-ASSET-TYPE, ATF-SUB-TYPEATP-SUB-TYPE
AmcontrolAMCONTROLNot RequiredATF-COMPANYCTL-COMPANY
AmcontroltoAMCONTROLNot RequiredATF-TO-COMPANYCTL-COMPANY
AmdivisionAMDIVISIONNot RequiredATF-DIVISIONDIV-DIVISION
AmlocationAMLOCATIONNot RequiredATF-LOCATION-NAMELOC-LOCATION-NAME

One to many (1) — child tables

RelationTableRulesConditionField map
AmastbktrfAMASTBKTRFATF-ASSETABT-ASSET, ATF-PROCESS-SEQABT-PROCESS-SEQ, ABT-BOOK

Programs

Updated by (269)

Referenced by (16)