AMASTBKINV – Asset Book Item Adjustment
- System
- Asset Management (AM)
- Prefix
IBK- Primary key
RUN-GROUP,BOOK,ASSET- Fields
- 30
- Updated by
- 2 programs
- Referenced by
- 0 programs
AMASTBKINV is the Asset Book Item Adjustment table in Lawson Asset Management (prefix IBK). It is indexed by RUN-GROUP, BOOK, ASSET (IBKSET1). It is updated by AM502 and AM92.1. The table has 30 fields, 1 index and 0 documented relations.
About AMASTBKINV
No description in the Lawson data dictionary.
Fields (30)
Column = COBOL field name without the IBK- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IBK-RUN-GROUP PKRUN_GROUP | Alpha 15 | Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing. | AM92.1 |
IBK-ASSET PKASSET | Numeric 10 | The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. | AM92.1 |
IBK-BOOK PKBOOK | Alpha 10 | A user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting. | AM92.1 |
IBK-BOOK-STATUSBOOK_STATUS | Alpha 1 | Status Code. | AM502, AM92.1 |
IBK-LIFELIFE | Numeric 4 | — | AM92.1 |
IBK-LIFE-REMLIFE_REM | Signed 7.3 | — | AM502, AM92.1 |
IBK-BOOK-BASISBOOK_BASIS | Signed 18.2 | — | AM92.1 |
IBK-METHODMETHOD | Alpha 10 | The method. | AM92.1 |
IBK-INSRV-DATEINSRV_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AM502, AM92.1 |
IBK-METH-TABLE-YRMETH_TABLE_YR | Numeric 2 | — | AM502, AM92.1 |
IBK-CONVENTIONCONVENTION | Alpha 2 | — | AM502, AM92.1 |
IBK-LIFE-YEARSLIFE_YEARS | Signed 5.2 | — | AM502, AM92.1 |
IBK-DEPR-YTDDEPR_YTD | Signed 18.2 | — | AM92.1 |
IBK-DEPR-YTD-ALLOWDEPR_YTD_ALLOW | Signed 18.2 | — | AM92.1 |
IBK-DEPR-LTDDEPR_LTD | Signed 18.2 | — | AM92.1 |
IBK-DEPR-LTD-ALLOWDEPR_LTD_ALLOW | Signed 18.2 | — | AM92.1 |
IBK-INACT-YTDINACT_YTD | Signed 5.3 | — | AM92.1 |
IBK-INACT-LTDINACT_LTD | Signed 7.3 | — | AM92.1 |
IBK-SALVAGE-VALUESALVAGE_VALUE | Signed 18.2 | — | AM92.1 |
IBK-BUS-PERCENTBUS_PERCENT | Signed 5.2 | — | AM502, AM92.1 |
IBK-PERSONAL-USEPERSONAL_USE | Alpha 10 | A personal use code defines the personal use options that asset books use to calculate depreciation, tax credits, and annual depreciation limits up to twenty years. The code is user-definable. | AM92.1 |
IBK-YR1-EXPYR1_EXP | Signed 18.2 | — | AM92.1 |
IBK-TC-TABLETC_TABLE | Alpha 10 | A user-defined tax credit table, which defines tax credit percentages and annual tax credit recapture percentages for up to twenty years. Asset books use tax credit tables to calculate tax credits. | AM92.1 |
IBK-TC-PROPERTYTC_PROPERTY | Signed 18.2 | — | AM92.1 |
IBK-TC-CREDITTC_CREDIT | Signed 18.2 | — | AM92.1 |
IBK-INS-METHODINS_METHOD | Alpha 10 | The method. | AM92.1 |
IBK-INS-ACT-VALINS_ACT_VAL | Signed 18.2 | — | AM92.1 |
IBK-INS-CMPTD-VALINS_CMPTD_VAL | Signed 18.2 | — | AM92.1 |
IBK-RPL-METHODRPL_METHOD | Alpha 10 | The method. | AM92.1 |
IBK-RPL-CMPTD-VALRPL_CMPTD_VAL | Signed 18.2 | — | AM92.1 |
Indexes (1)
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 |
|---|---|---|---|---|
IBKSET1 | RUN-GROUP, BOOK, ASSET | Primary | AM502, AM92.1 |