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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 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
ABXSET1
  1. ASSET
  2. BOOK
  3. COMPANY
  4. YR-END-DATE
  5. PERIOD
PrimaryAC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)
ABXSET2
  1. BOOK
  2. ASSET
  3. COMPANY
  4. YR-END-DATE
  5. PERIOD
AM192, AM320, AM91.2, AM91.5
ABXSET3
  1. ASSET
  2. BOOK
  3. YR-END-DATE
  4. PERIOD
  5. COMPANY
AM90.2, AM90.5
ABXSET4
  1. ASSET
  2. BOOK
  3. COMPANY
  4. YR-END-DATE
  5. PERIOD ↓
AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source)

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETRequired
ABX-ASSET→AST-ASSET
AmastbookAMASTBOOKRequired
ABX-ASSET→ASB-ASSET
ABX-BOOK→ASB-BOOK
AmbkhistAMBKHISTRequired
ABX-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
AmbktransAMBKTRANS
ABX-ASSET→ABK-ASSET
ABX-BOOK→ABK-BOOK
ABX-COMPANY→ABK-COMPANY
—→ABK-TRANS-STATUS
—→ABK-SEQ-NUMBER
AmtransAMTRANS
ABX-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)