AMASTBKCNV – Asset Book Conversion
- System
- Asset Management (AM)
- Prefix
ABC- Primary key
CONVERSION-NBR,BOOK- Fields
- 29
- Updated by
- 3 programs
- Referenced by
- 1 program
AMASTBKCNV is the Asset Book Conversion table in Lawson Asset Management (prefix ABC). It is indexed by CONVERSION-NBR, BOOK (ABCSET1). It is related 1:1 to AMASSETCNV and AMCNVASSET and 1:M to AMASTITCNV, AMASTMXCNV and AMASTTRCNV. It is updated by AM500, AM520 and AM98.1 and referenced by AM96.1. The table has 29 fields, 1 index and 5 documented relations.
About AMASTBKCNV
This file contains non-Lawson asset book information to be converted to asset books in the Lawson Asset Management system.
Fields (29)
Column = COBOL field name without the ABC- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#ABC-CONVERSION-NBR PKCONVERSION_NBR | Alpha 22 | Required key. This is the number for the asset to be converted. | AM98.1 |
#ABC-BOOK PKBOOK | Alpha 10 | Required key. This is the asset book to be converted. | AM520, AM98.1 |
#ABC-BOOK-STATUSBOOK_STATUS | Alpha 1 | This is the status of the asset book to be converted: active or inactive. | AM98.1 |
#ABC-LIFELIFE | Numeric 4 | This is the asset life in months. | AM98.1 |
#ABC-LIFE-REMLIFE_REM | Signed 7.3 | This is the life remaining for the asset in months. | AM98.1 |
#ABC-BOOK-BASISBOOK_BASIS | Signed 18.2 | This field contains the amount on which the depreciation calculations are based. NOTE The depreciation basis amount can be different for each depreciation book used. | AM98.1 |
#ABC-METHODMETHOD | Alpha 10 | This is the depreciation method. It can be a predefined or a user-defined method. | AM98.1 |
#ABC-INSRV-DATEINSRV_DATE | Numeric 8 (yyyymmdd) | This is the in-service date for the asset. NOTE The in-service date can be different for each depreciation book used. | AM98.1 |
#ABC-METH-TABLE-YRMETH_TABLE_YR | Numeric 2 | This field indicates what year of its life an asset is in. Various tables use this year in their calculations. | AM98.1 |
#ABC-CONVENTIONCONVENTION | Alpha 2 | This is the convention for depreciation calculation. | AM98.1 |
#ABC-LIFE-YEARSLIFE_YEARS | Signed 5.2 | This is the total life value of the asset, expressed in years. If you leave this field blank, the system computes asset life in years based on the Life field, which contains asset life in months. | AM98.1 |
#ABC-DEPR-YTDDEPR_YTD | Signed 18.2 | This is the year-to-date depreciation amount for this book. This amount includes only the business use, not the personal use, portion of the depreciation. | AM98.1 |
#ABC-DEPR-YTD-ALLOWDEPR_YTD_ALLOW | Signed 18.2 | This is the year-to-date depreciation allowed for the book. This amount is equivalent to the full depreciation, including business and personal use. | AM98.1 |
#ABC-DEPR-LTDDEPR_LTD | Signed 18.2 | This is the life-to-date depreciation for the book. This amount includes only the business use, not the personal use, portion of the depreciation. | AM98.1 |
#ABC-DEPR-LTD-ALLOWDEPR_LTD_ALLOW | Signed 18.2 | This is the life-to-date depreciation allowed for the book. This amount is equivalent to the full depreciation, including business and personal use. | AM98.1 |
#ABC-INACT-YTDINACT_YTD | Signed 5.3 | This is the number of inactive months for the book year-to-date. | AM98.1 |
#ABC-INACT-LTDINACT_LTD | Signed 7.3 | This is the number of inactive months for the book life-to-date. | AM98.1 |
#ABC-SALVAGE-VALUESALVAGE_VALUE | Signed 18.2 | This is the book salvage value for the asset at the end of the asset's life. It can be zero. | AM98.1 |
#ABC-BUS-PERCENTBUS_PERCENT | Signed 5.2 | This is the business usage percentage for the asset. If the percentage is less than 100%, this is the value to be used during depreciation calculations. If this field is left blank in the asset record, the system assumes 100%. | AM98.1 |
#ABC-PERSONAL-USEPERSONAL_USE | Alpha 10 | Personal use is a name for depreciation limits defined to account for personal use of an asset. When an asset has a personal use code, the Asset Management system uses those limits in the depreciation calculations. | AM98.1 |
#ABC-YR1-EXPYR1_EXP | Signed 18.2 | This is the new first year expense amount. It represents the amount to expense for the First Year Expense option. This U.S. tax option allows you to expense and not depreciate a total dollar amount for the assets of each eligible company. | AM98.1 |
#ABC-TC-TABLETC_TABLE | Alpha 10 | This is the tax credit table for the asset. | AM98.1 |
#ABC-TC-PROPERTYTC_PROPERTY | Signed 18.2 | If the tax credit is to be taken for used property, the amount that qualifies for the tax credit appears in this field. | AM98.1 |
#ABC-TAX-CREDITTAX_CREDIT | Signed 18.2 | This is the amount of tax credit taken for this asset. | AM98.1 |
#ABC-INS-METHODINS_METHOD | Alpha 10 | This is the method used to compute the insurance value of the asset. | AM98.1 |
#ABC-INS-ACT-VALINS_ACT_VAL | Signed 18.2 | This is the actual insurance value of the asset. | AM98.1 |
#ABC-INS-CMPTD-VALINS_CMPTD_VAL | Signed 18.2 | This is the insurance value for the asset, computed using the asset's insurance method. | AM98.1 |
#ABC-RPL-METHODRPL_METHOD | Alpha 10 | This is the method used to compute the replacement value of the asset. | AM98.1 |
#ABC-RPL-CMPTD-VALRPL_CMPTD_VAL | Signed 18.2 | This is the replacement value for the asset, computed using the asset's replacement method. | AM98.1 |
Indexes (1)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ABCSET1 |
| Primary | AM500, AM520, AM96.1, AM98.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Amassetcnv | AMASSETCNV | Not Required |
| ||||
| Amcnvasset | AMCNVASSET | Not Required |
|
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Amastitcnv | AMASTITCNV |
| ||||||||
| Amastmxcnv | AMASTMXCNV |
| ||||||||
| Amasttrcnv | AMASTTRCNV |
|
Programs
Updated by (3)
Referenced by (1)
- AM96.1 Asset Interface Adjustment