AMASTBKCNV

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
AM520 AM98.1 AM500 AM96.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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABCSET1 CONVERSION-NBR
BOOK
AM500 AM520
AM96.1 AM98.1


AMASTBKCNV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amassetcnv AMASSETCNV Not Required
ABC-CONVERSION-NBR->ACN-CONVERSION-NBR
Amcnvasset AMCNVASSET Not Required
ABC-CONVERSION-NBR->CVA-CONVERSION-NBR


AMASTBKCNV FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amastitcnv AMASTITCNV
ABC-CONVERSION-NBR->ITC-CONVERSION-NBR
  ITC-SEQ-NUMBER
Amastmxcnv AMASTMXCNV
ABC-CONVERSION-NBR->MCV-CONVERSION-NBR
  MCV-MATRIX-CAT
Amasttrcnv AMASTTRCNV
ABC-CONVERSION-NBR->TNC-CONVERSION-NBR
  TNC-SEQ-NUMBER


File created: Wed Jun 08 20:47:04 2016

Home
Contact Us



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