AMBOOKTYPE – This file contains the class depreciation file rate table for a book, type, or type and subtype.

System
Asset Management (AM)
Prefix
ADR
Primary key
BOOK, ASSET-TYPE, SUB-TYPE
Fields
4
Updated by
2 programs
Referenced by
2 programs

AMBOOKTYPE is the This file contains the class depreciation file rate table for a book, type, or type and subtype. table in Lawson Asset Management (prefix ADR). It is indexed by BOOK, ASSET-TYPE, SUB-TYPE (ADRSET1); alternate indexes: ADRSET2. It is related 1:M to AMBKTYPEX. It is updated by AM06.4 and AM06.5 and referenced by AM180 and AM214. The table has 4 fields, 2 indexes and 1 documented relation.

About AMBOOKTYPE

This file contains the class depreciation file rate table for a book, type, or type and subtype. It is populated by Asset Class Depreciation Rates (AM06.4).

Fields (4)

Column = COBOL field name without the ADR- 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
#ADR-BOOK PK
BOOK		Alpha 10This file contains the book for which the class depreciation rate is defined.AM06.4, AM06.5
#ADR-ASSET-TYPE PK
ASSET_TYPE		Alpha 10This file contains the asset type for which the class depreciation rate is defined.AM06.4, AM06.5
#ADR-SUB-TYPE PK
SUB_TYPE		Alpha 10This field contains the subtype for which the class depreciation rate is defined.AM06.4, AM06.5
#ADR-DEPR-RATE
DEPR_RATE		Percent 6.3 (Percent)This field contains the depreciation rate percentage assigned to the assets associated with the book, type, and (optional) subtype.AM06.4, AM06.5

Indexes (2)

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
ADRSET1
  1. BOOK
  2. ASSET-TYPE
  3. SUB-TYPE
PrimaryAM06.4, AM06.5, AM180, AM214
ADRSET2
  1. ASSET-TYPE
  2. SUB-TYPE
  3. BOOK
AM214

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
AmbktypexAMBKTYPEX
ADR-BOOK→ADX-BOOK
ADR-ASSET-TYPE→ADX-ASSET-TYPE
ADR-SUB-TYPE→ADX-SUB-TYPE
—→ADX-COMPANY
—→ADX-ACCT-UNIT

Programs

Updated by (2)

Referenced by (2)