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 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 AM520 AM551 AM96.1 AM98.1
AM99.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATS-COMPANY Numeric 4 AM115 AM125
Element: 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM96.1 AM98.1
AM99.1
ATS-BOOK Alpha 10 AM115 AM125
Element: 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM520
AM551 AM96.1
AM98.1 AM99.1
ATS-ACCT-UNIT Alpha 15 AM115 AM125
Element: Accounting UniThe 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM96.1 AM98.1
AM99.1
ATS-ACCOUNT Numeric 6 AM115 AM125
Element: 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM96.1 AM98.1
AM99.1
ATS-SUB-ACCOUNT Numeric 4 AM115 AM125
Element: 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
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 AM125 AM135
book. 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
AM551 AM96.1
AM98.1 AM99.1
ATS-BASE-ND Numeric 1 AM115 AM125
Base Number of AM135 AM145
Decimals 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 AM551
AM96.1 AM98.1
AM99.1
ATS-TRANS-BALANCE Signed 15.2 AM115 AM125
Element: Transaction BaThe 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
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
AM30.3 AM40.1
...
ATSSET2 COMPANY AM01.1 AM01.2
BOOK AM01.3 AM99.1
YR-END-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
|