AMTRANS – Asset Transaction

System
Asset Management (AM)
Prefix
AMT
Primary key
ASSET, TRANS-STATUS, COMPANY, BOOK, SEQ-NUMBER
Fields
37
Updated by
284 programs
Referenced by
9 programs

AMTRANS is the Asset Transaction table in Lawson Asset Management (prefix AMT). It is indexed by ASSET, TRANS-STATUS, COMPANY, BOOK, SEQ-NUMBER (AMTSET1); alternate indexes: AMTSET10, AMTSET2, AMTSET3, AMTSET4, AMTSET5, AMTSET6, AMTSET8 and AMTSET9. It is related 1:1 to AMASSET, AMBOOK, AMTRANSBOD, GLNAMES and GLTRANS and 1:M to AMASTMXVAL, AMBKTRANS and SLTRANS. It is updated by AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 and 276 more and referenced by AM270, AM275, AM277, AM75.1, AM75.2, AM85.1, AM85.2, AMBD.1 and 1 more. The table has 37 fields, 9 indexes and 9 documented relations.

About AMTRANS

The Asset Transaction file stores detailed records of asset transactions that update the general ledger. A record is created or updated in this file each time an asset is added, transferred, disposed of, or retired, or when depreciation is calculated. When they are posted, records in this file are updated to a posted status and are used for reporting in the Asset Management system.

Fields (37)

Column = COBOL field name without the AMT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AMT-ASSET PK
ASSET		Numeric 10The asset number associated with the asset transaction. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-COMPANY PK
COMPANY		Numeric 4The general ledger company number used for posting the asset transaction.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-BOOK PK
BOOK		Alpha 10The posting book associated with the asset transaction. 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)
#AMT-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to the asset transaction to keep records unique.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-LEASE-COMPANY
LEASE_COMPANY		Numeric 4The lessor company for a leased asset.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-LEASE
LEASE		Alpha 19The lease number associated with a leased asset.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ASSET-GROUP
ASSET_GROUP		Alpha 10The asset group with which the asset is associated.AM20.2, AM20.4, AM20.5, AM40.1, AM40.3, AM40.4, AM41.2
#AMT-TRANS-DATE SET5
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction. Used for posting the asset transaction to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-PROCESS-DATE
PROCESS_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-REFERENCE
REFERENCE		Alpha 10 (Lower Case)The reference number associated with the transaction.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)A description of the asset transaction.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-TRANS-STATUS PK
TRANS_STATUS		Alpha 1The status of the asset transaction. Transactions must have a Released status before they can be posted to the general ledger. Valid values are:
  • M Memo
  • U Unreleased
  • R Released
  • H Historical
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ACCT-GRP
ACCT_GRP		Alpha 10—AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ASSET-TYPE
ASSET_TYPE		Alpha 10An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-SUB-TYPE
SUB_TYPE		Alpha 10An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. Subtypes must be unique within an asset type.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ACCT-TYPE
ACCT_TYPE		Alpha 3—AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ACCT-UNIT SET5
ACCT_UNIT		Alpha 15The accounting unit used for posting the asset transaction to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ACCOUNT SET5
ACCOUNT		Numeric 6The account number used for posting the asset transaction to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-SUB-ACCT SET5
SUB_ACCT		Numeric 4The subaccount number used for posting the asset transaction to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ASSET-PROCESS SET2 SET6
ASSET_PROCESS		Alpha 3This field identifies the type of Asset Management process that caused this record to be created. Valid values are:
  • ADD Addition
  • ADJ Adjustment
  • DPR Depreciation
  • DSP Disposal
  • TRF Transfer
  • RIN Reinstate
  • RAD Readd
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ATN-OBJ-ID SET9
ATN_OBJ_ID		Numeric 12A subsystem activity interface identification number. Used for Drill Around purposes.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ACTIVITY SET3
ACTIVITY		Alpha 15The activity assigned to the asset transaction. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-ACCT-CATEGORY SET3
ACCT_CATEGORY		Alpha 5The account category assigned to the asset transaction. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-TRANS-AMOUNT
TRANS_AMOUNT		Signed 18.2The amount of the asset transaction in the currency of the posting book transaction.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-PROCESS-ASSET SET4
PROCESS_ASSET		Numeric 10This field identifies the asset record that caused the transaction to be created. This field contains the same value as the Asset field in this file, except in the case of a partial transfer.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-PROCESS-SEQ SET4
PROCESS_SEQ		Numeric 6A system-generated number that is assigned to all asset transactions for a given process.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-GLT-OBJ-ID SET8
GLT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)The date the asset transaction was created.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The time the asset transaction was created.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-CREATOR-ID
CREATOR_ID		Alpha 10The operator responsible for creating the asset transaction.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#AMT-TAG
TAG		DerivedThe tag number associated with the asset transaction.—
#AMT-BOOK-CURRENCY
BOOK_CURRENCY		DerivedThe currency assigned to the posting book.—
#AMT-AST-LOCATION
AST_LOCATION		Derived——
#AMT-AST-DIVISION
AST_DIVISION		Derived——
#AMT-AST-TYPE
AST_TYPE		Derived——
#AMT-AST-SUBTYPE
AST_SUBTYPE		Derived——

Indexes (9)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AMTSET1
  1. ASSET
  2. TRANS-STATUS
  3. COMPANY
  4. BOOK
  5. SEQ-NUMBER
Primary, KeyChangeAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
AMTSET10
  1. ASSET
  2. SEQ-NUMBER ↓
  3. COMPANY
  4. BOOK
  5. TRANS-STATUS
KeyChangeAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
AMTSET2
  1. COMPANY
  2. TRANS-STATUS
  3. ASSET-PROCESS
  4. ASSET
  5. SEQ-NUMBER
KeyChangeAM135, AM170, AM192, AM20.4, AM20.5, AM21.4, AM21.5, AM22.2 +7 more
AMTSET3
  1. COMPANY
  2. TRANS-STATUS
  3. ACTIVITY
  4. ACCT-CATEGORY
  5. ASSET
  6. SEQ-NUMBER
KeyChangeAM85.1, AM85.2
AMTSET4
  1. PROCESS-ASSET
  2. PROCESS-SEQ
  3. TRANS-STATUS
  4. ASSET
  5. SEQ-NUMBER
KeyChange, SubsetWhere TRANS-STATUS = "M" Or TRANS-STATUS = "U"AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
AMTSET5
  1. TRANS-STATUS
  2. COMPANY
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCT
  6. TRANS-DATE
  7. ASSET
  8. SEQ-NUMBER
KeyChangeAM270, AM275, AM75.1, AM75.2
AMTSET6
  1. TRANS-STATUS
  2. COMPANY
  3. ASSET-PROCESS
  4. ASSET
  5. SEQ-NUMBER
KeyChangeAM80.1, AM80.2
AMTSET8
  1. GLT-OBJ-ID
  2. ASSET
  3. SEQ-NUMBER
KeyChange, SubsetWhere GLT-OBJ-ID != Zeroes—
AMTSET9
  1. ATN-OBJ-ID
  2. ASSET
  3. SEQ-NUMBER
  4. COMPANY
KeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AMASSETAMBOOKAMTRANSBODGLNAMESGLTRANSAMASTMXVALAMBKTRANSSLTRANSAMTRANS

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot Required
AMT-ASSET→AST-ASSET (ASTSET1)
AmassetpartialAMASSETNot Required
AMT-PROCESS-ASSET→AST-ASSET
AmbookAMBOOKRequired
AMT-BOOK→AMB-BOOK
AmtransbodAMTRANSBODNot Required, Delete Cascades
AMT-ASSET→YAW-ASSET
AMT-TRANS-STATUS→YAW-TRANS-STATUS
AMT-COMPANY→YAW-COMPANY
AMT-BOOK→YAW-BOOK
AMT-SEQ-NUMBER→YAW-SEQ-NUMBER
GlnamesGLNAMESRequired
AMT-COMPANY→GLN-COMPANY
AMT-ACCT-UNIT→GLN-ACCT-UNIT
GltransGLTRANSNot Required
AMT-GLT-OBJ-ID→GLT-OBJ-ID

One to many (3) — child tables

RelationTableRulesConditionField map
AmastmxvalAMASTMXVAL
AST-OBJ-ID→MXT-OBJ-ID
—→MXT-MATRIX-CAT
AmbktransAMBKTRANS
AMT-ASSET→ABK-ASSET
AMT-BOOK→ABK-BOOK
AMT-COMPANY→ABK-COMPANY
—→ABK-TRANS-STATUS
—→ABK-SEQ-NUMBER
SltransSLTRANS
AMT-GLT-OBJ-ID→SLT-GLT-OBJ-ID
—→SLT-OBJ-ID

Programs

Updated by (284)

Referenced by (9)