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
AM01.1 AM01.2 AM01.3 AM115 AM117 AM125
AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4
AM154 AM170 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATS-COMPANY Numeric 4 AM115 AM117
Element: Company This is the general ledger company AM125 AM135
number. This is the general ledger AM145 AM15.1
posting company associated with the AM15.2 AM15.3
book. AM15.4 AM154
AM170 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
ATS-BOOK Alpha 10 AM115 AM117
Element: Book The book name associated with the asset AM125 AM135
transaction summary record, representing AM145 AM15.1
a general ledger posting book. Books are AM15.2 AM15.3
used by assets for calculating AM15.4 AM154
depreciation, replacement cost, and AM170 AM190
insurance values, and for reporting. 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
ATS-ACCT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe general ledger accounting unit for AM125 AM135
the amount on this record. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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
ATS-ACCOUNT Numeric 6 AM115 AM117
Element: Account The general ledger account number for AM125 AM135
the amount on this record. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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
ATS-SUB-ACCOUNT Numeric 4 AM115 AM117
Element: Subaccount The general ledger subaccount number AM125 AM135
for the amount on this record. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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
ATS-YR-END-DATE Numeric 8 (yyyymmdd) AM01.1 AM01.2
Element: Year-End Date The year-ending date defined for the AM01.3 AM115
calendar associated with the posting AM117 AM125
book. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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
ATS-BASE-ND Numeric 1 AM115 AM117
Base Number of The number of decimal positions defined AM125 AM135
Decimals for the company base currency. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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
ATS-TRANS-BALANCE Signed 18.2 AM115 AM117
Element: Transaction BaThe balance for the accounting unit, AM125 AM135
account, and subaccount defined for this AM145 AM15.1
record. This amount is in the currency AM15.2 AM15.3
of the posting book. AM15.4 AM154
AM170 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
AMTRANSUMM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATSSET1 COMPANY AM115 AM117
BOOK AM125 AM135
ACCT-UNIT AM145 AM15.1
ACCOUNT AM15.2 AM15.3
SUB-ACCOUNT AM15.4 AM154
YR-END-DATE* AM170 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 AM30.1
AM30.2 AM30.3
...
ATSSET2 COMPANY AM01.1 AM01.2
BOOK AM01.3 AM99.1
YR-END-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
|