AMBKHIST – Asset Book History

System
Asset Management (AM)
Prefix
ABH
Primary key
ASSET, BOOK, COMPANY, YR-END-DATE
Fields
11
Updated by
286 programs
Referenced by
6 programs

AMBKHIST is the Asset Book History table in Lawson Asset Management (prefix ABH). It is indexed by ASSET, BOOK, COMPANY, YR-END-DATE (ABHSET1); alternate indexes: ABHSET2 and ABHSET3. It is related 1:1 to AMASSET and 1:M to AMBKHISTX. It is updated by AC160, AM01.1, AM01.2, AM01.3, AM115, AM117, AM125, AM135 and 278 more and referenced by AM281, AM90.2, AM90.5, AM91.2, AM91.5 and AMDL.1. The table has 11 fields, 3 indexes and 2 documented relations.

About AMBKHIST

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

Fields (11)

Column = COBOL field name without the ABH- 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
#ABH-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)
#ABH-BOOK PK
BOOK		Alpha 10The book assigned to the asset for which depreciation is tracked.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#ABH-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)
#ABH-YR-END-DATE PK
YR_END_DATE		Numeric 8 (yyyymmdd)The end date of the fiscal year.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#ABH-DEPR-YTD
DEPR_YTD		Signed 18.2the year-to-date (YTD) depreciation amount. 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)
#ABH-DEPR-LTD
DEPR_LTD		Signed 18.2The life-to-date (LTD) depreciation amount.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#ABH-BEG-DEPR-LTD
BEG_DEPR_LTD		Signed 18.2The life-to-date (LTD) accumulated depreciation at the start of the fiscal year.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#ABH-LIFE
LIFE		Numeric 4The life of the asset in months.AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +52 more (list truncated in source)
#ABH-METH-SW-DATE
METH_SW_DATE		Numeric 8 (yyyymmdd)The date on which the depreciation method was switched.AM190, AM192, AM501
#ABH-CALC-DEPR-LTD
CALC_DEPR_LTD		DerivedThe calculated life-to-date depreciation amount (Depr-YTD + Beg-Depr-LTD). Used for real-time Drill Around operations.—
#ABH-BALANCE-FLAG
BALANCE_FLAG		Alpha 1—AM501

Indexes (3)

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
ABHSET1
  1. ASSET
  2. BOOK
  3. COMPANY
  4. YR-END-DATE
PrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABHSET2
  1. BOOK
  2. ASSET
  3. YR-END-DATE
  4. COMPANY
AM01.1, AM01.2, AM01.3, AM192, AM281, AM310, AM90.2, AM90.5 +2 more
ABHSET3
  1. ASSET
  2. BOOK
  3. COMPANY
  4. YR-END-DATE ↓
AM190, AM192, AM320, AM500

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETRequired
ABH-ASSET→AST-ASSET

One to many (1) — child tables

RelationTableRulesConditionField map
AmbkhistxAMBKHISTX
ABH-ASSET→ABX-ASSET
ABH-BOOK→ABX-BOOK
ABH-YR-END-DATE→ABX-YR-END-DATE
—→ABX-PERIOD
—→ABX-COMPANY

Programs

Updated by (286)

Referenced by (6)