AMBKTYPEX – Asset Book Type Rate Detail

System
Asset Management (AM)
Prefix
ADX
Primary key
BOOK, ASSET-TYPE, SUB-TYPE, COMPANY, ACCT-UNIT
Fields
6
Updated by
1 program
Referenced by
2 programs

AMBKTYPEX is the Asset Book Type Rate Detail table in Lawson Asset Management (prefix ADX). It is indexed by BOOK, ASSET-TYPE, SUB-TYPE, COMPANY, ACCT-UNIT (ADXSET1); alternate indexes: ADXSET2. It is related 1:1 to AMBOOKTYPE. It is updated by AM06.5 and referenced by AM180 and AM214. The table has 6 fields, 2 indexes and 1 documented relation.

About AMBKTYPEX

This file contains the class depreciation rate table detail information. It is populated by Asset Class Depreciation Rate Detail (AM06.5).

Fields (6)

Column = COBOL field name without the ADX- 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
#ADX-BOOK PK
BOOK		Alpha 10This field contains the book for which class depreciation rates are defined..AM06.5
#ADX-ASSET-TYPE PK
ASSET_TYPE		Alpha 10This field contains the asset type for which the class depreciation rate is defined.AM06.5
#ADX-SUB-TYPE PK
SUB_TYPE		Alpha 10This field contains the subtype for which class a class depreciation rate is defined.AM06.5
#ADX-ACCT-UNIT PK
ACCT_UNIT		Alpha 15This field contains the accounting unit for which the class depreciation rate is defined.AM06.5
#ADX-COMPANY PK
COMPANY		Numeric 4This field contains the company for which the class depreciation rate is defined.AM06.5
#ADX-DEPR-RATE
DEPR_RATE		Percent 6.3 (Percent)This field contains the class depreciation percentage rate.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
ADXSET1
  1. BOOK
  2. ASSET-TYPE
  3. SUB-TYPE
  4. COMPANY
  5. ACCT-UNIT
PrimaryAM06.4, AM06.5, AM180, AM214
ADXSET2
  1. ASSET-TYPE
  2. SUB-TYPE
  3. BOOK
  4. COMPANY
  5. ACCT-UNIT
AM214

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmbooktypeAMBOOKTYPERequired
ADX-BOOK→ADR-BOOK
ADX-ASSET-TYPE→ADR-ASSET-TYPE
ADX-SUB-TYPE→ADR-SUB-TYPE

Programs

Updated by (1)

Referenced by (2)