AMBKHISTX – Period Asset Book History

System
Asset Management (AM)
Prefix
ABX
Primary key
ASSET, BOOK, COMPANY, YR-END-DATE, PERIOD
Fields
12
Updated by
283 programs
Referenced by
6 programs

AMBKHISTX is the Period Asset Book History table in Lawson Asset Management (prefix ABX). It is indexed by ASSET, BOOK, COMPANY, YR-END-DATE, PERIOD (ABXSET1); alternate indexes: ABXSET2, ABXSET3 and ABXSET4. It is related 1:1 to AMASSET, AMASTBOOK and AMBKHIST and 1:M to AMBKTRANS and AMTRANS. It is updated by AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 and 275 more and referenced by AM281, AM90.2, AM90.5, AM91.2, AM91.5 and AMDL.1. The table has 12 fields, 4 indexes and 5 documented relations.

About AMBKHISTX

The Asset Management Book History by Period file stores the depreciation information for an asset within a book for each period of depreciation.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
ABX-ASSET PK
ASSET		Numeric 10The asset number for which depreciation is tracked. 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)
ABX-BOOK PK
BOOK		Alpha 10The book associated with the asset for which depreciation is tracked.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-COMPANY PK
COMPANY		Numeric 4The company associated with the asset and book.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-YR-END-DATE PK
YR_END_DATE		Numeric 8 (yyyymmdd)The end date of the fiscal year for which depreciation is tracked.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-PERIOD PK
PERIOD		Numeric 2The period for which depreciation is stored.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-DEPR-CP
DEPR_CP		Signed 18.2The deprecciation calculated for the period. Includes only the business use, not the personal use.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-LIFE-REM
LIFE_REM		Signed 7.3The remaining life of the asset in months. This value represents the number of months for which Asset Management will continue to calculate depreciation.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-METH-SWITCHED
METH_SWITCHED		Alpha 1Indicates whether the method swich was used. Valid values are:
  • N No
  • Y Yes
AM190, AM192, AM320, AM501
ABX-BOOK-BASIS
BOOK_BASIS		Signed 18.2The amount on which the depreciation calculations are based. Note: The depreciation basis amount can be different for each depreciation book used.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-PD-DEPR-YTD
PD_DEPR_YTD		Signed 18.2The year-to-date (YTD) depreciation amount for the specified period. Includes only the business use, not the personal use.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
ABX-PD-DEPR-LTD
PD_DEPR_LTD		DerivedThe life-to-date (LTD) depreciation amount for the specified period. Includes only the business use, not the personal use.—
ABX-BOOK-VALUE
BOOK_VALUE		DerivedThe book value is calculated as follows: Book basis - Life-to-date period depreciation.—

Indexes (4)

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

IndexKeysFlagsConditionUsed in
ABXSET1ASSET, BOOK, COMPANY, YR-END-DATE, PERIODPrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABXSET2BOOK, ASSET, COMPANY, YR-END-DATE, PERIODAM192, AM320, AM91.2, AM91.5
ABXSET3ASSET, BOOK, YR-END-DATE, PERIOD, COMPANYAM90.2, AM90.5
ABXSET4ASSET, BOOK, COMPANY, YR-END-DATE, PERIOD*AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETRequiredABX-ASSET → AST-ASSET
AmastbookAMASTBOOKRequiredABX-ASSET → ASB-ASSET, ABX-BOOK → ASB-BOOK
AmbkhistAMBKHISTRequiredABX-ASSET → ABH-ASSET, ABX-BOOK → ABH-BOOK, ABX-COMPANY → ABH-COMPANY, ABX-YR-END-DATE → ABH-YR-END-DATE

One to many (2) — child tables

RelationTableRulesConditionField map
AmbktransAMBKTRANSABX-ASSET → ABK-ASSET, ABX-BOOK → ABK-BOOK, ABX-COMPANY → ABK-COMPANY, → ABK-TRANS-STATUS, → ABK-SEQ-NUMBER
AmtransAMTRANSABX-ASSET → AMT-ASSET, Spaces → AMT-TRANS-STATUS, ABX-COMPANY → AMT-COMPANY, ABX-BOOK → AMT-BOOK, → AMT-SEQ-NUMBER

Programs

Updated by (283)

Referenced by (6)