|
|
AMASTBKCNV FILE
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 AM700 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABC-CONVERSION-NBR Alpha 10 AM98.1
Conversion Number Required key. This is the number for
the asset to be converted.
ABC-BOOK Alpha 10 AM520 AM98.1
Book Required key. This is the asset book to
be converted.
ABC-BOOK-STATUS Alpha 1 AM98.1
Book Status This is the status of the asset book to
be converted: active or inactive.
ABC-LIFE Numeric 4 AM98.1
Life This is the asset life in months.
ABC-LIFE-REM Signed 7.3 AM98.1
Life Remaining This is the life remaining for the
asset in months.
ABC-BOOK-BASIS Signed 15.2 AM98.1
Book Basis 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.
ABC-METHOD Alpha 10 AM98.1
Method This is the depreciation method. It can
be a predefined or a user-defined
method.
ABC-INSRV-DATE Numeric 8 (yyyymmdd) AM98.1
In-Service Date This is the in-service date for the
asset.
Note: The in-service date can be
different for each depreciation book
used.
ABC-METH-TABLE-YR Numeric 2 AM98.1
Method Table Year This field indicates what year of its
life an asset is in. Various tables use
this year in their calculations.
ABC-CONVENTION Alpha 2 AM98.1
Convention This is the convention for depreciation
calculation.
ABC-LIFE-YEARS Signed 5.2 AM98.1
Life Years 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.
ABC-DEPR-YTD Signed 15.2 AM98.1
Depreciation This is the year-to-date depreciation
Year-to-Date amount for this book. This amount
includes only the business use, not the
personal use, portion of the
depreciation.
ABC-DEPR-YTD-ALLOW Signed 15.2 AM98.1
Depreciation YTD This is the year-to-date depreciation
Allowed allowed for the book. This amount is
equivalent to the full depreciation,
including business and personal use.
ABC-DEPR-LTD Signed 15.2 AM98.1
Depreciation This is the life-to-date depreciation
Life-to-Date for the book. This amount includes only
the business use, not the personal use,
portion of the depreciation.
ABC-DEPR-LTD-ALLOW Signed 15.2 AM98.1
Depreciation LTD This is the life-to-date depreciation
Allowed allowed for the book. This amount is
equivalent to the full depreciation,
including business and personal use.
ABC-INACT-YTD Signed 5.3 AM98.1
Inactive This is the number of inactive months
Year-to-Date for the book year-to-date.
ABC-INACT-LTD Signed 7.3 AM98.1
Inactive This is the number of inactive months
Life-to-Date for the book life-to-date.
ABC-SALVAGE-VALUE Signed 15.2 AM98.1
Salvage Value This is the book salvage value for the
asset at the end of the asset's life. It
can be zero.
ABC-BUS-PERCENT Signed 5.2 AM98.1
Business Percent 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%.
ABC-PERSONAL-USE Alpha 10 AM98.1
Personal Use 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.
ABC-1YR-EXP Signed 15.2 AM700
Old First Year This is the old first year expense
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.
ABC-YR1-EXP Signed 15.2 AM700 AM98.1
New First Year This is the new first year expense
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.
ABC-TC-TABLE Alpha 10 AM98.1
Tax Credit Table This is the tax credit table for the
asset.
ABC-TC-PROPERTY Signed 15.2 AM98.1
Tax Credit Property If the tax credit is to be taken for
used property, the amount that qualifies
for the tax credit appears in this
field.
ABC-TAX-CREDIT Signed 15.2 AM98.1
Tax Credit This is the amount of tax credit taken
for this asset.
ABC-INS-METHOD Alpha 10 AM98.1
Insurance Method This is the method used to compute the
insurance value of the asset.
ABC-INS-ACT-VAL Signed 15.2 AM98.1
Insurance Actual This is the actual insurance value of
Value the asset.
ABC-INS-CMPTD-VAL Signed 15.2 AM98.1
Insurance Computed This is the insurance value for the
Value asset, computed using the asset's
insurance method.
ABC-RPL-METHOD Alpha 10 AM98.1
Replace Method This is the method used to compute the
replacement value of the asset.
ABC-RPL-CMPTD-VAL Signed 15.2 AM98.1
Replace Computed This is the replacement value for the
Value asset, computed using the asset's
replacement method.
AMASTBKCNV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABCSET1 CONVERSION-NBR AM500 AM520
BOOK AM700 AM98.1
AMASTBKCNV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|