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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ADR-BOOK PKBOOK | Alpha 10 | This file contains the book for which the class depreciation rate is defined. | AM06.4, AM06.5 |
ADR-ASSET-TYPE PKASSET_TYPE | Alpha 10 | This file contains the asset type for which the class depreciation rate is defined. | AM06.4, AM06.5 |
ADR-SUB-TYPE PKSUB_TYPE | Alpha 10 | This field contains the subtype for which the class depreciation rate is defined. | AM06.4, AM06.5 |
ADR-DEPR-RATEDEPR_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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ADRSET1 | BOOK, ASSET-TYPE, SUB-TYPE | Primary | AM06.4, AM06.5, AM180, AM214 | |
ADRSET2 | ASSET-TYPE, SUB-TYPE, BOOK | AM214 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ambktypex | AMBKTYPEX | ADR-BOOK → ADX-BOOK, ADR-ASSET-TYPE → ADX-ASSET-TYPE, ADR-SUB-TYPE → ADX-SUB-TYPE, ADX-COMPANY, ADX-ACCT-UNIT |