Asset Book Conversion

This file contains non-Lawson asset book information to be converted to asset books in the Lawson Asset Management system.
UPDATED BY

AM500

AM520

AM96.1

AM98.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ABC-CONVERSION-NBR Element: Conversion Number	Alpha 22 Required key. This is the number for the asset to be converted.	AM98.1
ABC-BOOK Element: Book	Alpha 10 Required key. This is the asset book to be converted.	AM520 AM98.1
ABC-BOOK-STATUS Element: Book Status	Alpha 1 This is the status of the asset book to be converted: active or inactive.	AM98.1
ABC-LIFE Element: Life	Numeric 4 This is the asset life in months.	AM98.1
ABC-LIFE-REM Element: Life Remaining	Signed 7.3 This is the life remaining for the asset in months.	AM98.1
ABC-BOOK-BASIS Element: Book 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-METHOD Element: Method	Alpha 10 This is the depreciation method. It can be a predefined or a user-defined method.	AM98.1
ABC-INSRV-DATE Element: In-Service 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 Element: Method Table Year	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-CONVENTION Element: Convention	Alpha 2 This is the convention for depreciation calculation.	AM98.1
ABC-LIFE-YEARS Element: Life 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-YTD Depreciation Year-to-Date	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-ALLOW Depreciation YTD Allowed	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-LTD Depreciation Life-to-Date	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-ALLOW Depreciation LTD Allowed	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-YTD Inactive Year-to-Date	Signed 5.3 This is the number of inactive months for the book year-to-date.	AM98.1
ABC-INACT-LTD Inactive Life-to-Date	Signed 7.3 This is the number of inactive months for the book life-to-date.	AM98.1
ABC-SALVAGE-VALUE Element: Salvage 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-PERCENT Element: Business 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-USE Element: Personal 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-EXP Element: First Year Expense	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-TABLE Element: Tax Credit Table	Alpha 10 This is the tax credit table for the asset.	AM98.1
ABC-TC-PROPERTY Element: Tax Credit 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-CREDIT Element: Tax Credit	Signed 18.2 This is the amount of tax credit taken for this asset.	AM98.1
ABC-INS-METHOD Element: Insurance Method	Alpha 10 This is the method used to compute the insurance value of the asset.	AM98.1
ABC-INS-ACT-VAL Insurance Actual Value	Signed 18.2 This is the actual insurance value of the asset.	AM98.1
ABC-INS-CMPTD-VAL Insurance Computed Value	Signed 18.2 This is the insurance value for the asset, computed using the asset's insurance method.	AM98.1
ABC-RPL-METHOD Element: Replace Method	Alpha 10 This is the method used to compute the replacement value of the asset.	AM98.1
ABC-RPL-CMPTD-VAL Replace Computed Value	Signed 18.2 This is the replacement value for the asset, computed using the asset's replacement method.	AM98.1

AMASTBKCNV FILE INDEX

AMASTBKCNV FILE RELATIONS

ONE TO ONE RELATIONS

AMASTBKCNV FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.