AMASSETTRF FILE Asset Transfer This file contains historical asset information related to transfers. It is updated by AM30.1 (Transfers) and AM30.2 (Items). REFERENCED BY AM115 AM125 AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM230 AM235 AM40.1 AM40.2 AM500 AM96.1 AM98.1 UPDATED BY AM135 AM170 AM30.1 AM30.2 AM300 AM956 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ATF-ASSET Numeric 10 AM135 AM30.1 Asset Required. The asset number contains up AM956 to ten numeric characters that uniquely identify a transfer-from asset. Assets are automatically numbered system-wide. ATF-PROCESS-SEQ Numeric 4 AM135 AM30.1 Process Sequence Key field. This is the sequence number AM956 for the process. ATF-TO-ASSET Numeric 10 AM135 AM30.1 To Asset This is the to-asset for the transfer. AM30.2 AM956 ATF-TRF-STATUS Alpha 1 AM135 AM170 Transfer Status This is the status of the transfer: AM30.1 AM956 released or not released. N = Not Released R = Released ATF-TRANSFER-DATE Numeric 8 (yyyymmdd) AM135 AM30.1 Transfer Date This is the date the asset was AM956 transferred. ATF-TRANSFER-TYPE Alpha 1 AM135 AM30.1 Transfer Type This is the type of the transfer: AM956 intracompany or intercompany (interdivision). T = Intracompany I = Intercompany ATF-TRF-QUANTITY Numeric 10 AM135 AM30.1 Transfer Quantity This is the asset quantity transferred. AM956 ATF-FULL-PARTIAL Alpha 1 AM135 AM30.1 Full Partial This field indicates whether the AM956 transfer is full (including all asset items) or partial (including only some asset items). F = Full P = Partial ATF-DESCRIPTION Alpha 30 (Lower Case) AM135 AM30.1 Description This is the transfer description. AM956 ATF-TAG-NBR Alpha 12 AM135 AM30.1 Tag Number This is the tag number, a user-definable identifier, for the transfer-from asset. ATF-TO-TAG-NBR Alpha 12 AM135 AM30.1 To Tag Number This is the tag number for the to-asset. AM956 ATF-ASSET-GROUP Alpha 10 AM135 AM30.1 Asset Group This is the asset group for the AM956 transferred asset. An asset group represents a parent asset used for reporting purposes. ATF-TO-ASSET-GROUP Alpha 10 AM135 AM30.1 To Asset Group This is the asset group, if any, for AM956 the to-asset. ATF-OBJ-ID Numeric 12 AM135 AM30.1 Object ID This is the object identifier. It is AM956 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. ATF-TO-OBJ-ID Numeric 12 AM135 AM30.1 To Object ID This is the object identifier for the AM30.2 AM956 to-asset. The object identifier is a unique key used to attach a list of user-defined attributes. ATF-ASSET-CATEGORY Alpha 1 AM135 AM30.1 Asset Category This is the category for the asset: AM956 depreciable or nondepreciable. D = Depreciable N = Non Depreciable ATF-SIMULATED Alpha 1 AM135 AM30.1 Simulated This field indicates whether the asset AM956 is simulated. ATF-WORK-IN-PROC Alpha 1 AM135 AM30.1 Work-in-Process This field indicates whether the asset AM956 is a work-in-process asset. ATF-TAX-EXEMPT Alpha 1 AM135 AM30.1 Tax Exempt This field indicates whether the asset AM956 is tax exempt. ATF-USED Alpha 1 AM135 AM30.1 Used This field indicates whether the asset AM956 is used. Valid values are Y = Yes N = No ATF-ITEM-TOT-QTY Numeric 10 AM135 AM30.1 Item Total Quantity This is the total item quantity for the AM956 from-asset. ATF-TO-IT-TOT-QTY Numeric 10 AM135 AM30.1 To Item Total This is the total item quantity for the AM30.2 AM956 Quantity to-asset. ATF-IT-TOT-CSTBASE Signed 15.2 AM135 AM30.1 Item Total Cost Base This is the total item cost for the AM956 from-asset in the base currency. ATF-TO-IT-TOTCSTBS Signed 15.2 AM135 AM30.1 To Item Total Cost This is the total item cost for the AM30.2 AM956 Base to-asset in the base currency. ATF-IT-TOT-TAXBASE Signed 15.2 AM135 AM30.1 Item Total Tax Base This is the total item tax in the base AM956 currency for the from-asset. ATF-TO-IT-TOTTAXBS Signed 15.2 AM135 AM30.1 To Item Total Tax This is the total item tax in the base AM30.2 AM956 Base currency for the to-asset. ATF-IT-TOT-CSTTRAN Signed 15.2 AM135 AM30.1 Item Total Cost Tran This is the total item cost in the AM956 transaction currency for the from-asset. ATF-TO-IT-TOTCSTTR Signed 15.2 AM135 AM30.1 To Item Total Cost This is the total item cost in the AM30.2 AM956 Tran transaction currency for the to-asset. ATF-IT-TOT-TAXTRAN Signed 15.2 AM135 AM30.1 Item Total Tax Tran This is the total item tax in the AM956 transaction currency for the from-asset. ATF-TO-IT-TOTTAXTR Signed 15.2 AM135 AM30.1 To Item Total Tax This is the total item tax in the AM30.2 AM956 Tran transaction currency for the to-asset. ATF-BASE-ND Numeric 1 AM135 AM30.1 Base Number of The number of decimal positions defined AM956 Decimals for the company base currency. ATF-TO-BASE-ND Numeric 1 AM135 To Base Number of This is the number of decimal positions Decimals defined in the company base currency for the to-asset. ATF-TRAN-ND Numeric 1 AM135 AM30.1 Tran Number of The number of decimal positions defined AM956 Decimals for the transaction currency. ATF-TO-TRAN-ND Numeric 1 AM135 To Tran Number of The number of decimal positions defined Decimals in the transaction currency for the to-asset. ATF-CURRENCY-CODE Alpha 5 AM135 AM30.1 Currency Code This field contains the company base AM956 currency code established in GL10.1 (Company). ATF-TO-CURR-CODE Alpha 5 AM135 AM30.1 To Currency Code This is the company base currency code AM956 for the to-asset. ATF-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM135 AM30.1 Item Last Date This is the last changed date for the AM956 item. ATF-TO-IT-LAST-DT Numeric 8 (yyyymmdd) AM135 AM30.1 To Item Last Date This is the last changed date for the AM30.2 AM956 to-asset item. ATF-ITEM-LAST-SEQ Numeric 6 AM135 AM30.1 Item Last Sequence This is the last sequence number for the last change to the item. ATF-TO-IT-LAST-SEQ Numeric 6 AM135 AM30.1 To Item Last This is the last sequence number for AM30.2 Sequence the last change to the to-asset item. ATF-COMPANY Numeric 4 AM135 AM30.1 Company The company number represents an AM956 established company and is entered on all function codes. ATF-TO-COMPANY Numeric 4 AM135 AM30.1 To Company This is the company number for the AM956 to-asset. ATF-LOCATION-NAME Alpha 15 AM135 AM30.1 Location Name This is a user-defined location name AM956 for the from-asset. ATF-TO-LOCATION Alpha 15 AM135 AM30.1 To Location This is the location for the to-asset. AM956 ATF-DIVISION Alpha 15 AM135 AM30.1 Division This is a user-defined division name AM956 for the from-asset. Divisions can be used in reporting on assets. ATF-TO-DIVISION Alpha 15 AM135 AM30.1 To Division This is the division name for the AM956 to-asset. ATF-ASSET-TYPE Alpha 10 AM135 AM30.1 Asset Type An asset type represents a grouping of AM956 like assets. Asset types are used to group assets into reporting classes and to default common asset definition data. ATF-TO-ASSET-TYPE Alpha 10 AM135 AM30.1 To Asset Type This is the type for the to-asset. An AM956 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. ATF-SUB-TYPE Alpha 10 AM135 AM30.1 Asset Subtype An asset subtype represents a more AM956 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. ATF-TO-SUB-TYPE Alpha 10 AM135 AM30.1 To Asset Subtype This is the to-asset subtype. An asset AM956 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. ATF-ACCT-GRP Alpha 10 AM135 AM30.1 Account Group This is the user-defined account group AM956 for the from-asset, identifying the general ledger accounts used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of). ATF-TO-ACCT-GRP Alpha 10 AM135 AM30.1 To Account Group This is the account group for the AM956 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). ATF-ACCT-UNIT Alpha 15 AM135 AM30.1 Accounting Unit This is the accounting unit for the AM956 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. ATF-TO-ACCT-UNIT Alpha 15 AM135 AM30.1 To Accounting Unit This is the accounting unit for the AM956 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. ATF-AU-GROUP Alpha 10 AM135 AM30.1 Accounting Unit Accounting unit groups group and AM956 Group 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. ATF-TO-AU-GROUP Alpha 10 AM135 AM30.1 To Accounting Unit This is the accounting unit group for AM956 Group the to-asset. Accounting 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. ATF-ORIG-CO Numeric 4 AM135 AM30.1 Original Company This field contains the original AM956 company number when the asset record was added to this file. This field is never changed after being added. ATF-SELECT-NAME Alpha 15 AM135 Selection Name This is the name of the selection for the mass transfer. ATF-CREATION-DATE Numeric 8 (yyyymmdd) AM135 AM30.1 Creation Date This is the date that this transfer was AM956 created. ATF-CREATION-TIME Numeric 6 (hhmmss) AM135 AM30.1 Creation Time This is the time that the transfer was AM956 created. ATF-CREATOR-ID Alpha 10 AM135 AM30.1 Creator ID This is the ID of the person who AM956 created the transfer. ATF-AST-DESCRIP Derived Description This is the description of the transferred asset. ATF-BLANKAM Derived Blank This field consists of blank spaces. It is used to provide column headings on Drill Arounds. AMASSETTRF FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ATFSET1 ASSET AM115 AM125 PROCESS-SEQ AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM230 AM235 AM30.1 AM30.2 AM300 AM40.1 AM40.2 AM500 AM956 AM96.1 AM98.1 ATFSET2 COMPANY KeyChange, Subset AM230 AM235 ASSET Where TRF-STATUS = "R" PROCESS-SEQ ATFSET3 LOCATION-NAME KeyChange, Subset ASSET Where TRF-STATUS = "R" PROCESS-SEQ ATFSET4 DIVISION KeyChange, Subset ASSET Where TRF-STATUS = "R" PROCESS-SEQ ATFSET5 COMPANY KeyChange, Subset ASSET-TYPE Where TRF-STATUS = "R" SUB-TYPE ASSET PROCESS-SEQ ATFSET6 TO-COMPANY KeyChange, Subset AM135 AM230 TO-ASSET Where TRF-STATUS = "N" ASSET PROCESS-SEQ ATFSET7 ASSET Subset AM135 AM170 Where TRF-STATUS = "N" AM230 AM235 AM30.1 AM30.2 AM30.3 ATFSET8 ASSET Subset PROCESS-SEQ Where TRF-STATUS = "R" ATFSET9 TO-COMPANY KeyChange, Subset AM230 AM235 TO-ASSET Where TRF-STATUS = "R" ASSET PROCESS-SEQ AMASSETTRF FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Amasset AMASSET Not Required ATF-ASSET -> AST-ASSET Amassetto AMASSET Not Required ATF-TO-ASSET -> AST-ASSET Amasttype AMASTTYPE Not Required ATF-COMPANY -> ATP-COMPANY ATF-ASSET-TYPE -> ATP-ASSET-TYPE ATF-SUB-TYPE -> ATP-SUB-TYPE Amcontrol AMCONTROL Not Required ATF-COMPANY -> CTL-COMPANY Amcontrolto AMCONTROL Not Required ATF-TO-COMPANY -> CTL-COMPANY Amdivision AMDIVISION Not Required ATF-DIVISION -> DIV-DIVISION Amlocation AMLOCATION Not Required ATF-LOCATION-NAME -> LOC-LOCATION-NAME AMASSETTRF FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Amastbktrf AMASTBKTRF ATF-ASSET -> ABT-ASSET ATF-PROCESS-SEQ -> ABT-PROCESS-SEQ ABT-BOOK |