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