AMCTLTRANS – Asset Control Transaction

System
Asset Management (AM)
Prefix
ACT
Primary key
ASSET
Fields
6
Updated by
279 programs
Referenced by
0 programs

AMCTLTRANS is the Asset Control Transaction table in Lawson Asset Management (prefix ACT). It is indexed by ASSET (ACTSET1). It is updated by AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 and 271 more. The table has 6 fields, 1 index and 0 documented relations.

About AMCTLTRANS

No description in the Lawson data dictionary.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
ACT-ASSET PK
ASSET		Numeric 10The asset number associated with the control record. 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)
ACT-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction. This date is used for posting transactions to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ACT-REFERENCE
REFERENCE		Alpha 10 (Lower Case)The general ledger reference number assigned to associated transactions when they are released.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ACT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description assigned to associated transactions when they are released.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ACT-DEBIT-BALANCE
DEBIT_BALANCE		Signed 18.2This field stores the total debit amount for the batch of asset transactions. The debit balance must equal the credit balance before asset transactions can be released.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ACT-CREDIT-BALANCE
CREDIT_BALANCE		Signed 18.2This field stores the total credit amount for the batch of asset transactions. The credit balance must equal the debit balance before asset transactions can be released.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ACTSET1ASSETPrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)

Programs

Updated by (279)