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.

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
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
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
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
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
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
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
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
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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AMTSET1ASSET, TRANS-STATUS, COMPANY, BOOK, SEQ-NUMBERPrimary, KeyChangeAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
AMTSET10ASSET, SEQ-NUMBER*, COMPANY, BOOK, TRANS-STATUSKeyChangeAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
AMTSET2COMPANY, TRANS-STATUS, ASSET-PROCESS, ASSET, SEQ-NUMBERKeyChangeAM135, AM170, AM192, AM20.4, AM20.5, AM21.4, AM21.5, AM22.2 +7 more
AMTSET3COMPANY, TRANS-STATUS, ACTIVITY, ACCT-CATEGORY, ASSET, SEQ-NUMBERKeyChangeAM85.1, AM85.2
AMTSET4PROCESS-ASSET, PROCESS-SEQ, TRANS-STATUS, ASSET, SEQ-NUMBERKeyChange, SubsetWhere TRANS-STATUS = "M" Or TRANS-STATUS = "U"AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
AMTSET5TRANS-STATUS, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCT, TRANS-DATE, ASSET, SEQ-NUMBERKeyChangeAM270, AM275, AM75.1, AM75.2
AMTSET6TRANS-STATUS, COMPANY, ASSET-PROCESS, ASSET, SEQ-NUMBERKeyChangeAM80.1, AM80.2
AMTSET8GLT-OBJ-ID, ASSET, SEQ-NUMBERKeyChange, SubsetWhere GLT-OBJ-ID != Zeroes—
AMTSET9ATN-OBJ-ID, ASSET, SEQ-NUMBER, COMPANYKeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—

Relations

One to one (6) — lookups and parents

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

One to many (3) — child tables

RelationTableRulesConditionField map
AmastmxvalAMASTMXVALAST-OBJ-ID → MXT-OBJ-ID, → MXT-MATRIX-CAT
AmbktransAMBKTRANSAMT-ASSET → ABK-ASSET, AMT-BOOK → ABK-BOOK, AMT-COMPANY → ABK-COMPANY, → ABK-TRANS-STATUS, → ABK-SEQ-NUMBER
SltransSLTRANSAMT-GLT-OBJ-ID → SLT-GLT-OBJ-ID, → SLT-OBJ-ID

Programs

Updated by (284)

Referenced by (9)