AMASSETTRF

Asset Transfer

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

REFERENCED BY
AM145 AM190 AM192 AM320 AM40.1 AM40.2
AM40.3 AM40.4 AM41.1 AM41.2 AM502 AM92.1
AMDL.1


UPDATED BY
AC160 AM115 AM117 AM125 AM135 AM15.1
AM15.2 AM15.3 AM15.4 AM154 AM170 AM19.1
AM19.2 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5
AM20.6 AM21.1 AM21.2 AM21.3 AM21.4 AM21.5
AM21.6 AM22.1 AM230 AM235 AM281 AM30.1
AM30.2 AM30.3 AM300 AM330 AM500 AM551
AM96.1 AM98.1 AP115 AP125 AP126 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC66.1 IC83.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA44.1 MA44.2 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIF.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATF-ASSET
Element: Asset
Numeric 10
Required. 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
Element: Process Sequence
Numeric 6
Key field. This is the sequence number for the process.
AM135 AM154
AM30.1
ATF-TO-ASSET
Element: To Asset
Numeric 10
This is the to-asset for the transfer.
AM135 AM154
AM30.1 AM30.2
ATF-TRF-STATUS
Element: Transfer Status
Alpha 1
This is the status of the transfer. Valid values are: R = Released N = Not Released
AM135 AM154
AM170 AM30.1
ATF-TRANSFER-DATE
Element: Transfer Date
Numeric 8 (yyyymmdd)
This is the date the asset was transferred.
AM135 AM154
AM30.1
ATF-TRANSFER-TYPE
Element: Transfer Type
Alpha 1
This is the type of the transfer. Valid values are: T = Intracompany I = Intercompany
AM135 AM154
AM30.1
ATF-TRF-QUANTITY
Element: Transfer Quantity
Numeric 10
This is the asset quantity transferred.
AM135 AM154
AM30.1 AM30.2
ATF-FULL-PARTIAL
Element: Full Partial
Alpha 1
This 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
Element: Description
Alpha 30 (Lower Case)
This is the transfer description.
AM135 AM154
AM30.1
ATF-TAG-NBR
Element: Tag Number
Alpha 12
This is the tag number, a user-definable identifier, for the transfer-from asset.
AM135 AM154
AM30.1
ATF-TO-TAG-NBR
Element: To Tag Number
Alpha 12
This is the tag number for the to-asset.
AM135 AM154
AM30.1
ATF-LEASE-COMPANY
Element: Company
Numeric 4
The lessor company for the transferred leased asset.
AM135 AM154
AM30.1
ATF-LEASE
Element: Lease
Alpha 19
The lease number with which a transferred leased asset is associated.
AM135 AM154
AM30.1
ATF-CLASSIFICATION
Element: Classification
Alpha 1
AM135 AM154
AM30.1
ATF-ASSET-GROUP
Element: Asset Group
Alpha 10
This 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
Element: To Asset Group
Alpha 10
This is the asset group, if any, for the to-asset.
AM135 AM154
AM30.1
ATF-OBJ-ID
Element: Object ID
Numeric 12
This 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
Element: To Object ID
Numeric 12
This 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
Element: Asset Category
Alpha 1
This is the category for the asset. Valid values are: D = Depreciable N = Non Depreciable
AM135 AM154
AM30.1
ATF-SIMULATED
Element: Simulated
Alpha 1
This field indicates whether the asset is simulated.
AM135 AM154
AM30.1
ATF-WORK-IN-PROC
Element: Work-in-Process
Alpha 1
This field indicates whether the asset is a work-in-process asset.
AM135 AM154
AM30.1
ATF-TAX-EXEMPT
Element: Tax Exempt
Alpha 1
This field indicates whether the asset is tax exempt.
AM135 AM154
AM30.1
ATF-USED
Element: Used
Alpha 1
This field indicates whether the asset is used. Valid values are Y = Yes N = No
AM135 AM154
AM30.1
ATF-ITEM-TOT-QTY
Element: Item Total Quantity
Numeric 10
This is the total item quantity for the from-asset.
AM135 AM154
AM30.1
ATF-TO-IT-TOT-QTY
To Item Total
Quantity
Numeric 10
This is the total item quantity for the to-asset.
AM135 AM154
AM30.1 AM30.2
ATF-IT-TOT-CSTBASE
Element: Item Total Cost Base
Signed 18.2
This is the total item cost for the from-asset in the base currency.
AM135 AM154
AM30.1
ATF-FR-IT-TOTCSTBS
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ATF-TO-IT-TOTCSTBS
To Item Total Cost
Base
Signed 18.2
This 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
Element: Item Total Tax Base
Signed 18.2
This is the total item tax in the base currency for the from-asset.
AM135 AM154
AM30.1
ATF-FR-IT-TOTTAXBS
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ATF-TO-IT-TOTTAXBS
To Item Total Tax
Base
Signed 18.2
This 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
Element: Item Total Cost Tran
Signed 18.2
This is the total item cost in the transaction currency for the from-asset.
AM135 AM154
AM30.1
ATF-TO-IT-TOTCSTTR
To Item Total Cost
Tran
Signed 18.2
This is the total item cost in the transaction currency for the to-asset.
AM135 AM154
AM30.1 AM30.2
ATF-IT-TOT-TAXTRAN
Element: Item Total Tax Tran
Signed 18.2
This is the total item tax in the transaction currency for the from-asset.
AM135 AM154
AM30.1
ATF-TO-IT-TOTTAXTR
To Item Total Tax
Tran
Signed 18.2
This is the total item tax in the transaction currency for the to-asset.
AM135 AM154
AM30.1 AM30.2
ATF-BASE-ND
Base Number of
Decimals
Numeric 1
The number of decimal positions defined for the company base currency.
AM135 AM154
AM30.1
ATF-TO-BASE-ND
To Base Number of
Decimals
Numeric 1
This 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 Number of
Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AM135 AM154
AM30.1
ATF-TO-TRAN-ND
To Tran Number of
Decimals
Numeric 1
The number of decimal positions defined in the transaction currency for the to-asset.
AM135 AM30.1
ATF-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AM135 AM154
AM30.1
ATF-TO-CURR-CODE
Element: To Currency Code
Alpha 5
This is the company base currency code for the to-asset.
AM135 AM154
AM30.1
ATF-ITEM-LAST-DATE
Element: Item Last Date
Numeric 8 (yyyymmdd)
This is the last changed date for the item.
AM135 AM154
AM30.1
ATF-TO-IT-LAST-DT
Element: To Item Last Date
Numeric 8 (yyyymmdd)
This is the last changed date for the to-asset item.
AM135 AM154
AM30.1 AM30.2
ATF-ITEM-LAST-SEQ
Element: Item Last Sequence
Numeric 6
This is the last sequence number for the last change to the item.
AM135 AM154
AM30.1
ATF-TO-IT-LAST-SEQ
To Item Last
Sequence
Numeric 6
This is the last sequence number for the last change to the to-asset item.
AM135 AM154
AM30.1 AM30.2
ATF-COMPANY
Element: Company
Numeric 4
Identifies 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
Element: To Company
Numeric 4
This is the company number for the to-asset.
AM135 AM154
AM30.1
ATF-LOCATION-NAME
Element: Location Name
Alpha 15
This is a user-defined location name for the from-asset.
AM135 AM154
AM30.1
ATF-TO-LOCATION
Element: To Location
Alpha 15
This is the location for the to-asset.
AM135 AM154
AM30.1
ATF-DIVISION
Element: Division
Alpha 15
This 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
Element: To Division
Alpha 15
This is the division name for the to-asset.
AM135 AM154
AM30.1
ATF-ASSET-TYPE
Element: Asset Type
Alpha 10
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-TO-ASSET-TYPE
Element: To Asset Type
Alpha 10
This 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
Element: Asset Subtype
Alpha 10
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-TO-SUB-TYPE
Element: To Asset Subtype
Alpha 10
This 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
Element: Account Group
Alpha 10
This 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
Element: To Account Group
Alpha 10
This 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
Element: Accounting Unit
Alpha 15
This 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
Element: To Accounting Unit
Alpha 15
This 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
Accounting Unit
Group
Alpha 10
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.
AM135 AM154
AM30.1
ATF-TO-AU-GROUP
To Accounting Unit
Group
Alpha 10
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.
AM135 AM154
AM30.1
ATF-ORIG-CO
Element: Original Company
Numeric 4
This 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
Element: Selection Name
Alpha 15
This is the name of the selection for the mass transfer.
AM135
ATF-TO-LOC-DTL
Element: To Loc Dtl
Alpha 14
This is the location detail to which the item is being transferred.
AM154 AM30.1
ATF-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date that this transfer was created.
AM135 AM154
AM30.1
ATF-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
This is the time that the transfer was created.
AM135 AM154
AM30.1
ATF-CREATOR-ID
Element: Creator ID
Alpha 10
This is the ID of the person who created the transfer.
AM135 AM154
AM30.1
ATF-AST-DESCRIP
Element: Description
Derived
This is the description of the transferred asset.
ATF-BLANKAM
Element: Blank
Derived
This field consists of blank spaces. It is used to provide column headings on Drill Arounds.
ATF-ACTIVITY
Element: Activity
Alpha 15
ATF-TO-ACTIVITY
Element: Activity
Alpha 15
ATF-ACCT-CATEGORY
Element: Acct Category
Alpha 5
ATF-TO-ACCT-CAT
Element: Acct Category
Alpha 5


AMASSETTRF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATFSET1 ASSET
PROCESS-SEQ
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM22.1 AM230
ATFSET2 COMPANY
ASSET
PROCESS-SEQ
KeyChange, Subset
WhereTRF-STATUS ="R"
AM230 AM235
AM281 AM300
AM320
ATFSET3 LOCATION-NAME
ASSET
PROCESS-SEQ
KeyChange, Subset
WhereTRF-STATUS ="R"
ATFSET4 DIVISION
ASSET
PROCESS-SEQ
KeyChange, Subset
WhereTRF-STATUS ="R"
ATFSET5 COMPANY
ASSET-TYPE
SUB-TYPE
ASSET
PROCESS-SEQ
KeyChange, Subset
WhereTRF-STATUS ="R"
ATFSET6 TO-COMPANY
TO-ASSET
ASSET
PROCESS-SEQ
KeyChange, Subset
WhereTRF-STATUS ="N"
AM135 AM230
ATFSET7 ASSET
PROCESS-SEQ
Subset
WhereTRF-STATUS ="N"
AM135 AM170
AM230 AM235
AM30.1 AM30.2
AM30.3
ATFSET8 ASSET
PROCESS-SEQ
Subset
WhereTRF-STATUS ="R"
ATFSET9 TO-COMPANY
TO-ASSET
ASSET
PROCESS-SEQ
KeyChange, Subset
WhereTRF-STATUS ="R"
AM170 AM230
AM235


AMASSETTRF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amastbktrf AMASTBKTRF
ATF-ASSET->ABT-ASSET
ATF-PROCESS-SEQ->ABT-PROCESS-SEQ
  ABT-BOOK


File created: Thu Jun 09 11:05:35 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.