Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTBKCNV


                            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 15.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 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
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 15.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 15.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 15.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 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
Element: Replace MethodThis 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                                                   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