Lawson Insight Technical Documentation |
|
AMTRANSUMM
AMTRANSUMM FILE
Asset Transaction Summary
The Asset Transaction Summary file stores summary records of asset activity
by general ledger account for a fiscal year. Each record represents a summary
of asset activity associated with a specific posting book for a specific year.
These records are created by AM190 (Period Closing) and are used for history
reporting.
REFERENCED BY
AM270
UPDATED BY
AC160 AM01.1 AM01.2 AM01.3 AM115 AM117
AM125 AM135 AM145 AM15.1 AM15.2 AM15.3
AM15.4 AM154 AM170 AM19.1 AM19.2 AM190
AM192 AM195 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 AM520 AM551 AM92.1 AM96.1 AM98.1
AM99.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
ATS-COMPANY Numeric 4 AC160 AM115
Element: Company This is the general ledger company AM117 AM125
number. This is the general ledger AM135 AM145
posting company associated with the AM15.1 AM15.2
book. AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM195 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
AM99.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
...
ATS-BOOK Alpha 10 AC160 AM115
Element: Book The book name associated with the asset AM117 AM125
transaction summary record, representing AM135 AM145
a general ledger posting book. Books are AM15.1 AM15.2
used by assets for calculating AM15.3 AM15.4
depreciation, replacement cost, and AM154 AM170
insurance values, and for reporting. AM19.1 AM19.2
AM190 AM192
AM195 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
AM520 AM551
AM92.1 AM96.1
AM98.1 AM99.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
...
ATS-ACCT-UNIT Alpha 15 AC160 AM115
Element: Accounting UniThe general ledger accounting unit for AM117 AM125
the amount on this record. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM195 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
AM99.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
...
ATS-ACCOUNT Numeric 6 AC160 AM115
Element: Account The general ledger account number for AM117 AM125
the amount on this record. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM195 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
AM99.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
...
ATS-SUB-ACCOUNT Numeric 4 AC160 AM115
Element: Subaccount The general ledger subaccount number AM117 AM125
for the amount on this record. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM195 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
AM99.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
...
ATS-YR-END-DATE Numeric 8 (yyyymmdd) AC160 AM01.1
Element: Year-End Date The year-ending date defined for the AM01.2 AM01.3
calendar associated with the posting AM115 AM117
book. AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 AM19.1
AM19.2 AM190
AM192 AM195
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 AM99.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
...
ATS-BASE-ND Numeric 1 AC160 AM115
Base Number of The number of decimal positions defined AM117 AM125
Decimals for the company base currency. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM195 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
AM99.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
...
ATS-TRANS-BALANCE Signed 18.2 AC160 AM115
Element: Transaction BaThe balance for the accounting unit, AM117 AM125
account, and subaccount defined for this AM135 AM145
record. This amount is in the currency AM15.1 AM15.2
of the posting book. AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM195 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
AM99.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
...
AMTRANSUMM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATSSET1 COMPANY AC160 AM115
BOOK AM117 AM125
ACCT-UNIT AM135 AM145
ACCOUNT AM15.1 AM15.2
SUB-ACCOUNT AM15.3 AM15.4
YR-END-DATE* AM154 AM170
AM19.1 AM19.2
AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM270
...
ATSSET2 COMPANY AM01.1 AM01.2
BOOK AM01.3 AM195
YR-END-DATE AM99.1
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
|