|
|
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
AM520 AM98.1 AM500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABC-CONVERSION-NBR Alpha 22 AM98.1
Element: Conversion NumRequired key. This is the number for
the asset to be converted.
ABC-BOOK Alpha 10 AM520 AM98.1
Element: Book Required key. This is the asset book to
be converted.
ABC-BOOK-STATUS Alpha 1 AM98.1
Element: Book Status This is the status of the asset book to
be converted: active or inactive.
ABC-LIFE Numeric 4 AM98.1
Element: Life This is the asset life in months.
ABC-LIFE-REM Signed 7.3 AM98.1
Element: Life RemainingThis is the life remaining for the
asset in months.
ABC-BOOK-BASIS Signed 18.2 AM98.1
Element: 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
Element: Method This is the depreciation method. It can
be a predefined or a user-defined
method.
ABC-INSRV-DATE Numeric 8 (yyyymmdd) AM98.1
Element: In-Service DatThis 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
Element: Method Table YThis 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
Element: Convention This is the convention for depreciation
calculation.
ABC-LIFE-YEARS Signed 5.2 AM98.1
Element: 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 18.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 18.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 18.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 18.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 18.2 AM98.1
Element: 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
Element: Business PerceThis 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
Element: 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-YR1-EXP Signed 18.2 AM98.1
Element: First Year ExpThis 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.
ABC-TC-TABLE Alpha 10 AM98.1
Element: Tax Credit TabThis is the tax credit table for the
asset.
ABC-TC-PROPERTY Signed 18.2 AM98.1
Element: Tax Credit ProIf 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 18.2 AM98.1
Element: Tax Credit This is the amount of tax credit taken
for this asset.
ABC-INS-METHOD Alpha 10 AM98.1
Element: Insurance MethThis is the method used to compute the
insurance value of the asset.
ABC-INS-ACT-VAL Signed 18.2 AM98.1
Insurance Actual This is the actual insurance value of
Value the asset.
ABC-INS-CMPTD-VAL Signed 18.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
Element: Replace MethodThis is the method used to compute the
replacement value of the asset.
ABC-RPL-CMPTD-VAL Signed 18.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 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
Amasttrcnv AMASTTRCNV
ABC-CONVERSION-NBR -> TNC-CONVERSION-NBR
TNC-SEQ-NUMBER
|
