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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ADX-BOOK PKBOOK | Alpha 10 | This field contains the book for which class depreciation rates are defined.. | AM06.5 |
ADX-ASSET-TYPE PKASSET_TYPE | Alpha 10 | This field contains the asset type for which the class depreciation rate is defined. | AM06.5 |
ADX-SUB-TYPE PKSUB_TYPE | Alpha 10 | This field contains the subtype for which class a class depreciation rate is defined. | AM06.5 |
ADX-ACCT-UNIT PKACCT_UNIT | Alpha 15 | This field contains the accounting unit for which the class depreciation rate is defined. | AM06.5 |
ADX-COMPANY PKCOMPANY | Numeric 4 | This field contains the company for which the class depreciation rate is defined. | AM06.5 |
ADX-DEPR-RATEDEPR_RATE | Percent 6.3 (Percent) | This field contains the class depreciation percentage rate. | AM06.5 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ADXSET1 | BOOK, ASSET-TYPE, SUB-TYPE, COMPANY, ACCT-UNIT | Primary | AM06.4, AM06.5, AM180, AM214 | |
ADXSET2 | ASSET-TYPE, SUB-TYPE, BOOK, COMPANY, ACCT-UNIT | AM214 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ambooktype | AMBOOKTYPE | Required | ADX-BOOK → ADR-BOOK, ADX-ASSET-TYPE → ADR-ASSET-TYPE, ADX-SUB-TYPE → ADR-SUB-TYPE |
Programs
Updated by (1)
- AM06.5 Asset Class Depreciation Rate Detail