|
|
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
AM145 AM190 AM192 AM230 AM235 AM40.1
AM40.2 AM40.3 AM40.4 AM41.1 AM41.2 AMDL.1
UPDATED BY
AM135 AM154 AM170 AM30.1 AM30.2 AM300
AM115 AM125 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
AM330 AM500 AM551 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATF-ASSET Numeric 10 AM135 AM154
Element: 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
Element: Process SequenKey field. This is the sequence number AM30.1
for the process.
ATF-TO-ASSET Numeric 10 AM135 AM154
Element: To Asset This is the to-asset for the transfer. AM30.1 AM30.2
ATF-TRF-STATUS Alpha 1 AM135 AM154
Element: Transfer StatuThis 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
Element: Transfer Date This is the date the asset was AM30.1
transferred.
ATF-TRANSFER-TYPE Alpha 1 AM135 AM154
Element: 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
Element: Transfer QuantThis is the asset quantity transferred. AM30.2
ATF-FULL-PARTIAL Alpha 1 AM135 AM154
Element: 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
Element: Description This is the transfer description. AM30.1
ATF-TAG-NBR Alpha 12 AM135 AM154
Element: 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
Element: To Tag Number This is the tag number for the to-asset. AM30.1
ATF-LEASE-COMPANY Numeric 4 AM135 AM154
Element: Lease Company The lessor company for the transferred AM30.1
leased asset.
ATF-LEASE Alpha 19 AM135 AM154
Element: Lease The lease number with which a AM30.1
transferred leased asset is associated.
ATF-CLASSIFICATION Alpha 1 AM135 AM154
Element: Classification AM30.1
ATF-ASSET-GROUP Alpha 10 AM135 AM154
Element: 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
Element: To Asset GroupThis is the asset group, if any, for AM30.1
the to-asset.
ATF-OBJ-ID Numeric 12 AM135 AM154
Element: 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
Element: 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
Element: Asset CategoryThis is the category for the asset. AM30.1
Valid values are:
D = Depreciable
N = Non Depreciable
ATF-SIMULATED Alpha 1 AM135 AM154
Element: Simulated This field indicates whether the asset AM30.1
is simulated.
ATF-WORK-IN-PROC Alpha 1 AM135 AM154
Element: Work-in-ProcesThis field indicates whether the asset AM30.1
is a work-in-process asset.
ATF-TAX-EXEMPT Alpha 1 AM135 AM154
Element: Tax Exempt This field indicates whether the asset AM30.1
is tax exempt.
ATF-USED Alpha 1 AM135 AM154
Element: 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
Element: Item Total QuaThis 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.2
Quantity to-asset.
ATF-IT-TOT-CSTBASE Signed 15.2 AM135 AM154
Element: Item Total CosThis 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
Element: Item Total TaxThis 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
Element: Item Total CosThis 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
Element: Item Total TaxThis 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 AM30.1
Decimals
ATF-TO-BASE-ND Numeric 1 AM135 AM30.1
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 AM30.1
Decimals
ATF-TO-TRAN-ND Numeric 1 AM135 AM30.1
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
Element: 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
Element: To Currency CoThis is the company base currency code AM30.1
for the to-asset.
ATF-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM135 AM154
Element: Item Last DateThis is the last changed date for the AM30.1
item.
ATF-TO-IT-LAST-DT Numeric 8 (yyyymmdd) AM135 AM154
Element: To Item Last DThis is the last changed date for the AM30.1 AM30.2
to-asset item.
ATF-ITEM-LAST-SEQ Numeric 6 AM135 AM154
Element: Item Last SequThis 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
Element: Company The company number represents an AM30.1
established company and is entered on
all function codes.
ATF-TO-COMPANY Numeric 4 AM135 AM154
Element: To Company This is the company number for the AM30.1
to-asset.
ATF-LOCATION-NAME Alpha 15 AM135 AM154
Element: Location Name This is a user-defined location name AM30.1
for the from-asset.
ATF-TO-LOCATION Alpha 15 AM135 AM154
Element: To Location This is the location for the to-asset. AM30.1
ATF-DIVISION Alpha 15 AM135 AM154
Element: 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
Element: To Division This is the division name for the AM30.1
to-asset.
ATF-ASSET-TYPE Alpha 10 AM135 AM154
Element: 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
Element: 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
Element: 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
Element: To Asset SubtyThis 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
Element: 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
Element: To Account GroThis 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
Element: Accounting UniThis 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
Element: To Accounting 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 AM30.1
Group
ATF-ORIG-CO Numeric 4 AM135 AM154
Element: Original CompaThis 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
Element: Selection NameThis is the name of the selection for
the mass transfer.
ATF-TO-LOC-DTL Alpha 14 AM154 AM30.1
Element: To Loc Dtl This is the location detail to which the
item is being transferred.
ATF-CREATION-DATE Numeric 8 (yyyymmdd) AM135 AM154
Element: Creation Date This is the date that this transfer was AM30.1
created.
ATF-CREATION-TIME Numeric 6 (hhmmss) AM135 AM154
Element: Creation Time This is the time that the transfer was AM30.1
created.
ATF-CREATOR-ID Alpha 10 AM135 AM154
Element: Creator ID This is the ID of the person who AM30.1
created the transfer.
ATF-AST-DESCRIP Derived
Element: Description This is the description of the
transferred asset.
ATF-BLANKAM Derived
Element: 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
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
AM230 AM235
AM30.1 AM30.2
AM30.3 AM300
...
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 AM115 AM125
TO-ASSET Where TRF-STATUS = "N" AM135 AM145
ASSET AM15.1 AM15.2
PROCESS-SEQ AM15.3 AM15.4
AM154 AM170
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
AM230 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
...
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 AM170 AM230
TO-ASSET Where TRF-STATUS = "R" AM235
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
|
