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 AM21.1 AM21.2 AM21.3 AM21.4 AM21.5
AM21.6 AM230 AM235 AM40.1 AM40.2 AM41.1
AM500 AM551 AM96.1 AM98.1 AMDL.1
UPDATED BY
AM135 AM154 AM170 AM30.1 AM30.2 AM300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATF-ASSET Numeric 10 AM135 AM154
Asset Required. The asset number contains up AM30.1
to ten numeric characters that uniquely
identify a transfer-from asset. Assets
are automatically numbered system-wide.
ATF-PROCESS-SEQ Numeric 4 AM135 AM154
Process Sequence Key field. This is the sequence number AM30.1
for the process.
ATF-TO-ASSET Numeric 10 AM135 AM154
To Asset This is the to-asset for the transfer. AM30.1 AM30.2
ATF-TRF-STATUS Alpha 1 AM135 AM154
Transfer Status This is the status of the transfer. AM170 AM30.1
Valid values are:
R = Released
N = Not Released
ATF-TRANSFER-DATE Numeric 8 (yyyymmdd) AM135 AM154
Transfer Date This is the date the asset was AM30.1
transferred.
ATF-TRANSFER-TYPE Alpha 1 AM135 AM154
Transfer Type This is the type of the transfer. Valid AM30.1
values are:
T = Intracompany
I = Intercompany
ATF-TRF-QUANTITY Numeric 10 AM135 AM154
Transfer Quantity This is the asset quantity transferred. AM30.1
ATF-FULL-PARTIAL Alpha 1 AM135 AM154
Full Partial This field indicates whether the AM30.1
transfer is full (including all asset
items) or partial (including only some
asset items). Valid values are:
F = Full
P = Partial
ATF-DESCRIPTION Alpha 30 (Lower Case) AM135 AM154
Description This is the transfer description. AM30.1
ATF-TAG-NBR Alpha 12 AM135 AM154
Tag Number This is the tag number, a AM30.1
user-definable identifier, for the
transfer-from asset.
ATF-TO-TAG-NBR Alpha 12 AM135 AM154
To Tag Number This is the tag number for the to-asset. AM30.1
ATF-LEASE-COMPANY Numeric 4 AM135 AM154
Lease Company The lessor company for the transferred AM30.1
leased asset.
ATF-LEASE Alpha 19 AM135 AM154
Lease The lease number with which a AM30.1
transferred leased asset is associated.
ATF-CLASSIFICATION Alpha 1 AM135 AM154
Classification AM30.1
ATF-ASSET-GROUP Alpha 10 AM135 AM154
Asset Group This is the asset group for the AM30.1
transferred asset. An asset group
represents a parent asset used for
reporting purposes.
ATF-TO-ASSET-GROUP Alpha 10 AM135 AM154
To Asset Group This is the asset group, if any, for AM30.1
the to-asset.
ATF-OBJ-ID Numeric 12 AM135 AM154
Object ID This is the object identifier. It is AM30.1
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 AM154
To Object ID This is the object identifier for the AM30.1 AM30.2
to-asset. The object identifier is a
unique key used to attach a list of
user-defined attributes.
ATF-ASSET-CATEGORY Alpha 1 AM135 AM154
Asset Category This is the category for the asset. AM30.1
Valid values are:
D = Depreciable
N = Non Depreciable
ATF-SIMULATED Alpha 1 AM135 AM154
Simulated This field indicates whether the asset AM30.1
is simulated.
ATF-WORK-IN-PROC Alpha 1 AM135 AM154
Work-in-Process This field indicates whether the asset AM30.1
is a work-in-process asset.
ATF-TAX-EXEMPT Alpha 1 AM135 AM154
Tax Exempt This field indicates whether the asset AM30.1
is tax exempt.
ATF-USED Alpha 1 AM135 AM154
Used This field indicates whether the asset AM30.1
is used. Valid values are
Y = Yes
N = No
ATF-ITEM-TOT-QTY Numeric 10 AM135 AM154
Item Total Quantity This is the total item quantity for the AM30.1
from-asset.
ATF-TO-IT-TOT-QTY Numeric 10 AM135 AM154
To Item Total This is the total item quantity for the AM30.1 AM30.2
Quantity to-asset.
ATF-IT-TOT-CSTBASE Signed 15.2 AM135 AM154
Item Total Cost Base This is the total item cost for the AM30.1
from-asset in the base currency.
ATF-TO-IT-TOTCSTBS Signed 15.2 AM135 AM154
To Item Total Cost This is the total item cost for the AM30.1 AM30.2
Base to-asset in the base currency.
ATF-IT-TOT-TAXBASE Signed 15.2 AM135 AM154
Item Total Tax Base This is the total item tax in the base AM30.1
currency for the from-asset.
ATF-TO-IT-TOTTAXBS Signed 15.2 AM135 AM154
To Item Total Tax This is the total item tax in the base AM30.1 AM30.2
Base currency for the to-asset.
ATF-IT-TOT-CSTTRAN Signed 15.2 AM135 AM154
Item Total Cost Tran This is the total item cost in the AM30.1
transaction currency for the from-asset.
ATF-TO-IT-TOTCSTTR Signed 15.2 AM135 AM154
To Item Total Cost This is the total item cost in the AM30.1 AM30.2
Tran transaction currency for the to-asset.
ATF-IT-TOT-TAXTRAN Signed 15.2 AM135 AM154
Item Total Tax Tran This is the total item tax in the AM30.1
transaction currency for the from-asset.
ATF-TO-IT-TOTTAXTR Signed 15.2 AM135 AM154
To Item Total Tax This is the total item tax in the AM30.1 AM30.2
Tran transaction currency for the to-asset.
ATF-BASE-ND Numeric 1 AM135 AM154
Base Number of The number of decimal positions defined AM30.1
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 AM154
Tran Number of The number of decimal positions defined AM30.1
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 AM154
Currency Code This field contains the company base AM30.1
currency code established in Company
(GL10.1 ).
ATF-TO-CURR-CODE Alpha 5 AM135 AM154
To Currency Code This is the company base currency code AM30.1
for the to-asset.
ATF-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM135 AM154
Item Last Date This is the last changed date for the AM30.1
item.
ATF-TO-IT-LAST-DT Numeric 8 (yyyymmdd) AM135 AM154
To Item Last Date This is the last changed date for the AM30.1 AM30.2
to-asset item.
ATF-ITEM-LAST-SEQ Numeric 6 AM135 AM154
Item Last Sequence This is the last sequence number for AM30.1
the last change to the item.
ATF-TO-IT-LAST-SEQ Numeric 6 AM135 AM154
To Item Last This is the last sequence number for AM30.1 AM30.2
Sequence the last change to the to-asset item.
ATF-COMPANY Numeric 4 AM135 AM154
Company The company number represents an AM30.1
established company and is entered on
all function codes.
ATF-TO-COMPANY Numeric 4 AM135 AM154
To Company This is the company number for the AM30.1
to-asset.
ATF-LOCATION-NAME Alpha 15 AM135 AM154
Location Name This is a user-defined location name AM30.1
for the from-asset.
ATF-TO-LOCATION Alpha 15 AM135 AM154
To Location This is the location for the to-asset. AM30.1
ATF-DIVISION Alpha 15 AM135 AM154
Division This is a user-defined division name AM30.1
for the from-asset. Divisions can be
used in reporting on assets.
ATF-TO-DIVISION Alpha 15 AM135 AM154
To Division This is the division name for the AM30.1
to-asset.
ATF-ASSET-TYPE Alpha 10 AM135 AM154
Asset Type An asset type represents a grouping of AM30.1
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 AM154
To Asset Type This is the type for the to-asset. An AM30.1
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 AM154
Asset Subtype An asset subtype represents a more AM30.1
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 AM154
To Asset Subtype This is the to-asset subtype. An asset AM30.1
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 AM154
Account Group This is the user-defined account group AM30.1
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 AM154
To Account Group This is the account group for the AM30.1
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 AM154
Accounting Unit This is the accounting unit for the AM30.1
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 AM154
To Accounting Unit This is the accounting unit for the AM30.1
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 AM154
Accounting Unit Accounting unit groups group and AM30.1
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 AM154
To Accounting Unit This is the accounting unit group for AM30.1
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 AM154
Original Company This field contains the original AM30.1
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-TO-LOC-DTL Alpha 14 AM154 AM30.1
To Loc Dtl This is the location detail to which the
item is being transferred.
ATF-CREATION-DATE Numeric 8 (yyyymmdd) AM135 AM154
Creation Date This is the date that this transfer was AM30.1
created.
ATF-CREATION-TIME Numeric 6 (hhmmss) AM135 AM154
Creation Time This is the time that the transfer was AM30.1
created.
ATF-CREATOR-ID Alpha 10 AM135 AM154
Creator ID This is the ID of the person who AM30.1
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
AM154 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 AM235
AM30.1 AM30.2
AM300 AM40.1
AM40.2 AM41.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
PROCESS-SEQ 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
|
