AMBKTRANS – Asset Book Transactions

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

AMBKTRANS is the Asset Book Transactions table in Lawson Asset Management (prefix ABK). It is indexed by ASSET, BOOK, COMPANY, TRANS-STATUS, SEQ-NUMBER (ABKSET1); alternate indexes: ABKSET2, ABKSET3, ABKSET4, ABKSET5 and ABKSET6. It is related 1:1 to AMASSET and AMBOOK and 1:M to AMBKHISTX. It is updated by AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 and 275 more and referenced by AM270, AM275, AM277, AM75.1, AM75.2, AM80.1, AM80.2, AM85.1 and 1 more. The table has 21 fields, 6 indexes and 3 documented relations.

About AMBKTRANS

The Asset Book Transaction file stores a copy of each transaction transactions for each asset and each book.

Fields (21)

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

Field / columnTypeDescription & valuesUpdated by
ABK-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)
ABK-BOOK PK
BOOK		Alpha 10The 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)
ABK-COMPANY PK
COMPANY		Numeric 4The general ledger company number associated with the book and asset.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-TRANS-STATUS PK
TRANS_STATUS		Alpha 1This field identifies the status of the asset transaction. The status can be:
  • U Unreleased
  • R Released
  • H Historical
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-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)
ABK-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2The amount of the asset transaction in book currency.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-TRAN-ND
TRAN_ND		Numeric 1The number of decimal positions defined for the book currency.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-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)
ABK-REFERENCE
REFERENCE		Alpha 10 (Lower Case)The program number that created the transaction.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-ACC-TYPE
ACC_TYPE		Alpha 3For posting books, this field contains the type of account to which the transaction will be posted. Values are:
  • AST Asset
  • ACM Accumulated Depreciation
  • EXP Depreciation Expense
  • PRO Proceeds
  • GAN Gain
  • LOS Loss
  • CLR Clearing
  • COS Disposal Expense
  • DGN Deferred Gain
  • DLS Deferred Loss
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit used to post the transaction to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-ACCOUNT
ACCOUNT		Numeric 6The account used to post the transaction to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-SUB-ACCT
SUB_ACCT		Numeric 4The subaccount used to post the transaction to the general ledger.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-ASSET-PROCESS
ASSET_PROCESS		Alpha 3This field identifies the 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)
ABK-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12The object ID used for Driall Around operations.—
ABK-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)
ABK-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)
ABK-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)The record's creation date.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The record's creation time.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABK-CREATOR-ID
CREATOR_ID		Alpha 10The user that created the record.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)

Indexes (6)

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

IndexKeysFlagsConditionUsed in
ABKSET1ASSET, BOOK, COMPANY, TRANS-STATUS, SEQ-NUMBERPrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABKSET2COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCT, TRANS-DATE, BOOK, ASSET, SEQ-NUMBERKeyChangeAM270, AM300, AM75.1, AM75.2
ABKSET3COMPANY, TRANS-STATUS, ASSET-PROCESS, BOOK, ASSET, SEQ-NUMBERKeyChangeAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABKSET4COMPANY, TRANS-STATUS, ACTIVITY, ACCT-CATEGORY, BOOK, ASSET, SEQ-NUMBERKeyChangeAM85.1, AM85.2
ABKSET5ASSET, SEQ-NUMBER*, COMPANY, BOOK, TRANS-STATUSKeyChangeAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABKSET6TRANS-STATUS, ASSET-PROCESS, ASSET, BOOK, SEQ-NUMBER, COMPANYAC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETRequiredABK-ASSET → AST-ASSET
AmbookAMBOOKRequiredABK-BOOK → AMB-BOOK

One to many (1) — child tables

RelationTableRulesConditionField map
AmbkhistxAMBKHISTXABK-ASSET → ABX-ASSET, ABK-BOOK → ABX-BOOK, ABK-COMPANY → ABX-COMPANY, → ABX-YR-END-DATE, → ABX-PERIOD

Programs

Updated by (283)

Referenced by (9)