Lawson Insight Technical Documentation |
|
AMTRANS
AMTRANS FILE
Asset Transaction
The Asset Transaction file stores detailed records of asset transactions that
update the general ledger. A record is created or updated in this file each
time an asset is added, transferred, disposed of, or retired, or when
depreciation is calculated.
When they are posted, records in this file are updated to a posted status and
are used for reporting in the Asset Management system.
REFERENCED BY
AM75.1 AM75.2 AM80.1 AM80.2 AM85.1 AM85.2
AM320 AM275 AM277 AM270
UPDATED BY
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 AM30.1 AM30.2
AM30.3 AM300 AM330 AM40.1 AM40.2 AM40.3
AM40.4 AM41.1 AM41.2 AM500 AM502 AM520
AM551 AM92.1 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 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
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
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMT-ASSET Numeric 10 AC160 AM115
Element: Asset The asset number associated with the AM117 AM125
asset transaction. AM135 AM145
AM15.1 AM15.2
The asset number contains up to ten AM15.3 AM15.4
numeric characters that uniquely AM154 AM170
identify an asset. Assets are AM19.1 AM19.2
automatically numbered system-wide. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-COMPANY Numeric 4 AC160 AM115
Element: Company The general ledger company number used AM117 AM125
for posting the asset transaction. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-BOOK Alpha 10 AC160 AM115
Element: Book The posting book associated with the AM117 AM125
asset transaction. Books are used by AM135 AM145
assets for calculating depreciation, AM15.1 AM15.2
replacement cost, and insurance values, AM15.3 AM15.4
and for reporting. AM154 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM520 AM551
AM92.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
...
AMT-SEQ-NUMBER Numeric 6 AC160 AM115
Element: Sequence NumbeA unique number assigned to the asset AM117 AM125
transaction to keep records unique. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-LEASE-COMPANY Numeric 4 AC160 AM115
Element: Company The lessor company for a leased asset. AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-LEASE Alpha 19 AC160 AM115
Element: Lease The lease number associated with a AM117 AM125
leased asset. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-ASSET-GROUP Alpha 10
Element: Asset Group The asset group with which the asset is
associated.
AMT-TRANS-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Transaction DaThe date of the transaction. Used for AM117 AM125
posting the asset transaction to the AM135 AM145
general ledger. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-PROCESS-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Date This field displays the system date AM117 AM125
when this was created. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-REFERENCE Alpha 10 (Lower Case) AC160 AM115
Element: Reference The reference number associated with AM117 AM125
the transaction. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Element: Description A description of the asset transaction. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-TRANS-STATUS Alpha 1 AC160 AM115
Element: Transaction StThe status of the asset transaction. AM117 AM125
Transactions must have a Released status AM135 AM145
before they can be posted to the general AM15.1 AM15.2
ledger. Valid values are: AM15.3 AM15.4
AM154 AM170
M = Memo AM19.1 AM19.2
U = Unreleased AM190 AM192
R = Released AM20.1 AM20.2
H = Historical AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-ACCT-GRP Alpha 10 AC160 AM115
Element: Acct Grp Am AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-ASSET-TYPE Alpha 10 AC160 AM115
Element: Asset Type An asset type represents a grouping of AM117 AM125
like assets. Asset types are used to AM135 AM145
group assets into reporting classes and AM15.1 AM15.2
to default common asset definition data. AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-SUB-TYPE Alpha 10 AC160 AM115
Element: Sub Type An asset subtype represents a more AM117 AM125
detailed grouping of assets within an AM135 AM145
asset type grouping. Asset subtypes are AM15.1 AM15.2
used to group assets into reporting AM15.3 AM15.4
classes and allow common asset AM154 AM19.1
definition data to default. Subtypes AM19.2 AM190
must be unique within an asset type. AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-ACCT-TYPE Alpha 3 AC160 AM115
Element: Acct Type 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-ACCT-UNIT Alpha 15 AC160 AM115
Element: Accounting UniThe accounting unit used for posting AM117 AM125
the asset transaction to the general AM135 AM145
ledger. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-ACCOUNT Numeric 6 AC160 AM115
Element: Account The account number used for posting the AM117 AM125
asset transaction to the general ledger. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-SUB-ACCT Numeric 4 AC160 AM115
Element: Subaccount The subaccount number used for posting AM117 AM125
the asset transaction to the general AM135 AM145
ledger. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-ASSET-PROCESS Alpha 3 AC160 AM115
Element: Asset Process This field identifies the type of Asset AM117 AM125
Management process that caused this AM135 AM145
record to be created. Valid values are: AM15.1 AM15.2
AM15.3 AM15.4
ADD = Addition AM154 AM19.1
ADJ = Adjustment AM19.2 AM190
DPR = Depreciation AM192 AM20.1
DSP = Disposal AM20.2 AM20.4
TRF = Transfer AM20.5 AM21.1
AM21.2 AM21.4
RIN = Reinstate AM21.5 AM30.1
RAD = Readd AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-ATN-OBJ-ID Numeric 12 AC160 AM115
Element: Object ID A subsystem activity interface AM117 AM125
identification number. Used for Drill AM135 AM145
Around purposes. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-ACTIVITY Alpha 15 AC160 AM115
Element: Activity The activity assigned to the asset AM117 AM125
transaction. AM135 AM145
AM15.1 AM15.2
Activities are the processes or AM15.3 AM15.4
procedures that produce work. Cost AM154 AM170
objects (products, services, customers, AM19.1 AM19.2
and so on) are the reasons for AM190 AM192
performing the activity. Activities and AM20.1 AM20.2
cost object activities are used AM20.3 AM20.4
synonymously in the Lawson Activity AM20.5 AM20.6
Management system. AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-ACCT-CATEGORY Alpha 5 AC160 AM115
Element: Account CategoThe account category assigned to the AM117 AM125
asset transaction. AM135 AM145
AM15.1 AM15.2
Account categories are groupings of AM15.3 AM15.4
costs, revenues, or a combination of AM154 AM170
both used for reporting and inquiries AM19.1 AM19.2
for activities in the Lawson Activity AM190 AM192
Management system. All transactions are AM20.1 AM20.2
posted to an account category within an AM20.3 AM20.4
activity. AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-TRAN-ND Numeric 1 AC160 AM115
Transaction Number The number of decimals assigned to a AM117 AM125
of Decimals particular account as determined by the AM135 AM145
account currency. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-TRANS-AMOUNT Signed 18.2 AC160 AM115
Element: Transaction AmThe amount of the asset transaction in AM117 AM125
the currency of the posting book AM135 AM145
transaction. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-PROCESS-ASSET Numeric 10 AC160 AM115
Element: Process Asset This field identifies the asset record AM117 AM125
that caused the transaction to be AM135 AM145
created. This field contains the same AM15.1 AM15.2
value as the Asset field in this file, AM15.3 AM15.4
except in the case of a partial AM154 AM19.1
transfer. AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-PROCESS-SEQ Numeric 6 AC160 AM115
Element: Process SequenA system-generated number that is AM117 AM125
assigned to all asset transactions for a AM135 AM145
given process. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM92.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 BL120
...
AMT-GLT-OBJ-ID Numeric 12 AC160 AM115
Element: Object ID This is the object identifier. It is AM117 AM125
used to relate commitments or posted AM135 AM145
transactions back to the originating AM15.1 AM15.2
subsystems. Each subsystem record that AM15.3 AM15.4
is updated as a commitment or posted AM154 AM170
transaction is assigned an object AM19.1 AM19.2
identifier. The object identifier is AM190 AM192
maintained in the subsystem files and in AM20.1 AM20.2
the Activity Commitments Detail and AM20.3 AM20.4
Activity Transaction files. The object AM20.5 AM20.6
identifier is a unique key used to drill AM21.1 AM21.2
back from Activity Management to the AM21.3 AM21.4
subsystems. AM21.5 AM21.6
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date The date the asset transaction was AM117 AM125
created. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time The time the asset transaction was AM117 AM125
created. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-CREATOR-ID Alpha 10 AC160 AM115
Element: Creator ID The operator responsible for creating AM117 AM125
the asset transaction. 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
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 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
...
AMT-TAG Derived
Element: Tag The tag number associated with the
asset transaction.
AMT-BOOK-CURRENCY Derived
Element: Book Currency The currency assigned to the posting
book.
AMT-AST-LOCATION Derived
Element: Ast Location
AMT-AST-DIVISION Derived
Element: Ast Division
AMT-AST-TYPE Derived
Element: Ast Type
AMT-AST-SUBTYPE Derived
Element: Ast Subtype
AMTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMTSET1 ASSET KeyChange AC160 AM115
TRANS-STATUS AM117 AM125
COMPANY AM135 AM145
BOOK AM15.1 AM15.2
SEQ-NUMBER 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
AM30.1 AM30.2
...
AMTSET10 ASSET KeyChange AC160 AM115
SEQ-NUMBER* AM117 AM125
COMPANY AM135 AM145
BOOK AM15.1 AM15.2
TRANS-STATUS 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
AM30.1 AM30.2
...
AMTSET2 COMPANY KeyChange AM135 AM170
TRANS-STATUS AM192 AM20.4
ASSET-PROCESS AM20.5 AM21.4
ASSET AM21.5 AM275
SEQ-NUMBER AM277 AM300
AM40.4 AM41.1
AM41.2 AM520
AMTSET3 COMPANY KeyChange AM85.1 AM85.2
TRANS-STATUS
ACTIVITY
ACCT-CATEGORY
ASSET
SEQ-NUMBER
AMTSET4 PROCESS-ASSET KeyChange, Subset AC160 AM115
PROCESS-SEQ Where TRANS-STATUS = "M" AM117 AM125
TRANS-STATUS Or TRANS-STATUS = "U" AM135 AM145
ASSET AM15.1 AM15.2
SEQ-NUMBER 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
AM30.1 AM30.2
...
AMTSET5 TRANS-STATUS KeyChange AM270 AM75.1
COMPANY AM75.2
ACCT-UNIT
ACCOUNT
SUB-ACCT
TRANS-DATE
ASSET
SEQ-NUMBER
AMTSET6 TRANS-STATUS KeyChange AM80.1 AM80.2
COMPANY
ASSET-PROCESS
ASSET
SEQ-NUMBER
AMTSET8 GLT-OBJ-ID KeyChange, Subset
ASSET Where GLT-OBJ-ID != Zeroes
SEQ-NUMBER
AMTSET9 ATN-OBJ-ID KeyChange, Subset
ASSET Where ATN-OBJ-ID != Zeroes
SEQ-NUMBER
COMPANY
AMTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
AMT-ASSET -> AST-ASSET (ASTSET1)
Amassetpartial AMASSET Not Required
AMT-PROCESS-ASSET -> AST-ASSET
Ambook AMBOOK Required
AMT-BOOK -> AMB-BOOK
Gltrans GLTRANS Not Required
AMT-GLT-OBJ-ID -> GLT-OBJ-ID
AMTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastmxval AMASTMXVAL
AST-OBJ-ID -> MXT-OBJ-ID
MXT-MATRIX-CAT
Ambktrans AMBKTRANS
AMT-ASSET -> ABK-ASSET
AMT-BOOK -> ABK-BOOK
AMT-COMPANY -> ABK-COMPANY
ABK-TRANS-STATUS
ABK-SEQ-NUMBER
Sltrans SLTRANS
AMT-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|