AMTRANSUMM – Asset Transaction Summary

System
Asset Management (AM)
Prefix
ATS
Primary key
COMPANY, BOOK, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YR-END-DATE
Fields
8
Updated by
285 programs
Referenced by
1 program

AMTRANSUMM is the Asset Transaction Summary table in Lawson Asset Management (prefix ATS). It is indexed by COMPANY, BOOK, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YR-END-DATE (ATSSET1); alternate indexes: ATSSET2. It is updated by AC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM125, AM135 and 277 more and referenced by AM270. The table has 8 fields, 2 indexes and 0 documented relations.

About AMTRANSUMM

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.

Fields (8)

Column = COBOL field name without the ATS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ATS-COMPANY PK
COMPANY		Numeric 4This is the general ledger company number. This is the general ledger posting company associated with the book.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ATS-BOOK PK
BOOK		Alpha 10The book name associated with the asset transaction summary record, representing a general ledger posting book. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ATS-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The general ledger accounting unit for the amount on this record.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ATS-ACCOUNT PK
ACCOUNT		Numeric 6The general ledger account number for the amount on this record.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ATS-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4The general ledger subaccount number for the amount on this record.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ATS-YR-END-DATE PK
YR_END_DATE		Numeric 8 (yyyymmdd)The year-ending date defined for the calendar associated with the posting book.AC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM125, AM135 +52 more (list truncated in source)
ATS-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ATS-TRANS-BALANCE
TRANS_BALANCE		Signed 18.2The balance for the accounting unit, account, and subaccount defined for this record. This amount is in the currency of the posting book.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATSSET1COMPANY, BOOK, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YR-END-DATE*PrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ATSSET2COMPANY, BOOK, YR-END-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTAM01.1, AM01.2, AM01.3, AM195, AM99.1

Programs

Updated by (285)

Referenced by (1)