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.

Field / columnTypeDescription & valuesUpdated by
ABC-CONVERSION-NBR PK
CONVERSION_NBR		Alpha 22Required key. This is the number for the asset to be converted.AM98.1
ABC-BOOK PK
BOOK		Alpha 10Required key. This is the asset book to be converted.AM520, AM98.1
ABC-BOOK-STATUS
BOOK_STATUS		Alpha 1This is the status of the asset book to be converted: active or inactive.AM98.1
ABC-LIFE
LIFE		Numeric 4This is the asset life in months.AM98.1
ABC-LIFE-REM
LIFE_REM		Signed 7.3This is the life remaining for the asset in months.AM98.1
ABC-BOOK-BASIS
BOOK_BASIS		Signed 18.2This 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-METHOD
METHOD		Alpha 10This is the depreciation method. It can be a predefined or a user-defined method.AM98.1
ABC-INSRV-DATE
INSRV_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-YR
METH_TABLE_YR		Numeric 2This field indicates what year of its life an asset is in. Various tables use this year in their calculations.AM98.1
ABC-CONVENTION
CONVENTION		Alpha 2This is the convention for depreciation calculation.AM98.1
ABC-LIFE-YEARS
LIFE_YEARS		Signed 5.2This 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-YTD
DEPR_YTD		Signed 18.2This 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-ALLOW
DEPR_YTD_ALLOW		Signed 18.2This 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-LTD
DEPR_LTD		Signed 18.2This 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-ALLOW
DEPR_LTD_ALLOW		Signed 18.2This 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-YTD
INACT_YTD		Signed 5.3This is the number of inactive months for the book year-to-date.AM98.1
ABC-INACT-LTD
INACT_LTD		Signed 7.3This is the number of inactive months for the book life-to-date.AM98.1
ABC-SALVAGE-VALUE
SALVAGE_VALUE		Signed 18.2This is the book salvage value for the asset at the end of the asset's life. It can be zero.AM98.1
ABC-BUS-PERCENT
BUS_PERCENT		Signed 5.2This 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-USE
PERSONAL_USE		Alpha 10Personal 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-EXP
YR1_EXP		Signed 18.2This 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-TABLE
TC_TABLE		Alpha 10This is the tax credit table for the asset.AM98.1
ABC-TC-PROPERTY
TC_PROPERTY		Signed 18.2If 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-CREDIT
TAX_CREDIT		Signed 18.2This is the amount of tax credit taken for this asset.AM98.1
ABC-INS-METHOD
INS_METHOD		Alpha 10This is the method used to compute the insurance value of the asset.AM98.1
ABC-INS-ACT-VAL
INS_ACT_VAL		Signed 18.2This is the actual insurance value of the asset.AM98.1
ABC-INS-CMPTD-VAL
INS_CMPTD_VAL		Signed 18.2This is the insurance value for the asset, computed using the asset's insurance method.AM98.1
ABC-RPL-METHOD
RPL_METHOD		Alpha 10This is the method used to compute the replacement value of the asset.AM98.1
ABC-RPL-CMPTD-VAL
RPL_CMPTD_VAL		Signed 18.2This is the replacement value for the asset, computed using the asset's replacement method.AM98.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ABCSET1CONVERSION-NBR, BOOKPrimaryAM500, AM520, AM96.1, AM98.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmassetcnvAMASSETCNVNot RequiredABC-CONVERSION-NBR → ACN-CONVERSION-NBR
AmcnvassetAMCNVASSETNot RequiredABC-CONVERSION-NBR → CVA-CONVERSION-NBR

One to many (3) — child tables

RelationTableRulesConditionField map
AmastitcnvAMASTITCNVABC-CONVERSION-NBR → ITC-CONVERSION-NBR, → ITC-SEQ-NUMBER
AmastmxcnvAMASTMXCNVABC-CONVERSION-NBR → MCV-CONVERSION-NBR, → MCV-MATRIX-CAT
AmasttrcnvAMASTTRCNVABC-CONVERSION-NBR → TNC-CONVERSION-NBR, → TNC-SEQ-NUMBER

Programs

Updated by (3)

Referenced by (1)