Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTBKTRF


                            AMASTBKTRF FILE

                          Asset Book Transfer

This file contains historical asset book information related to transfers.

REFERENCED BY

AM145     AM190     AM192     AM230     AM40.1    AM40.2
AM40.3    AM40.4    AM41.1    AM41.2    AMDL.1

UPDATED BY

AM135     AM154     AM30.1    AM30.2    AM300     AM310
AM520     AM115     AM125     AM15.1    AM15.2    AM15.3
AM15.4    AM170     AM20.1    AM20.2    AM20.3    AM20.4
AM20.5    AM20.6    AM21.1    AM21.2    AM21.3    AM21.4
AM21.5    AM21.6    AM330     AM500     AM551     AM96.1
AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ABT-ASSET              Numeric 10                                AM135   AM154
Element: Asset         Key field. The asset number contains up   AM30.1  AM30.2
                       to ten numeric characters that uniquely
                       identify an asset. Assets are
                       automatically numbered system-wide.


ABT-TO-ASSET           Numeric 10                                AM135   AM154
Element: To Asset      This is the to-asset for the transfer.    AM30.1  AM30.2

ABT-BOOK               Alpha 10                                  AM135   AM154
Element: Book          Key field. This is a user-defined book    AM30.1  AM30.2
                       name. Books are used by assets for        AM520
                       calculating depreciation, replacement
                       cost, and insurance values, and for
                       reporting.


ABT-PROCESS-SEQ        Numeric 4                                 AM135   AM154
Element: Process SequenKey field. This is the sequence number    AM30.1  AM30.2
                       for the transfer process.


ABT-BOOK-STATUS        Alpha 1                                   AM135   AM154
Element: Book Status   This field indicates the status of the    AM30.1  AM30.2
                       book. Valid values are:
                       A = Active
                       I = Inactive

ABT-LIFE               Numeric 4                                 AM135   AM154
Element: Life          This is the asset life in months.         AM30.1  AM30.2

ABT-LIFE-REM           Signed 7.3                                AM135   AM154
Element: Life RemainingThis is the remaining life for the        AM30.1  AM30.2
                       asset.


ABT-BOOK-BASIS         Signed 15.2                               AM135   AM154
Element: Book Basis    This field contains the amount on which   AM30.1  AM30.2
                       the depreciation calculations for the
                       book are based.

                       Note: The depreciation basis amount can
                       be different for each depreciation book
                       used.



ABT-TO-BOOK-BASIS      Signed 15.2                               AM30.1  AM30.2
Element: To Book Basis This field contains the amount on which
                       the depreciation calculations for the
                       transfer-to asset book are based.


ABT-METHOD             Alpha 10                                  AM135   AM154
Element: Method        This is the asset book depreciation       AM30.1  AM30.2
                       method.


ABT-METH-SWITCHED      Alpha 1                                   AM135   AM154
Element: Method Switched                                         AM30.1  AM30.2

ABT-INSRV-DATE         Numeric 8  (yyyymmdd)                     AM135   AM154
Element: In Service DatThis is the in-service date for the       AM30.1  AM30.2
                       asset.

                       Note:  The in-service date can be
                       different for each depreciation book
                       used.



ABT-METH-TABLE-YR      Numeric 2                                 AM135   AM154
Element: Method Table YThis field indicates what year of its     AM30.1  AM30.2
                       life an asset is in. Various tables use
                       this year in their calculations.


ABT-CONVENTION         Alpha 2                                   AM135   AM154
Element: Convention    This is the in-service convention for     AM30.1  AM30.2
                       the asset, which determines the amount
                       of depreciation it receives in its first
                       and last years in service. Valid values
                       are:
                       FM = Full Month
                       HM = Modified Half Month
                       AD = Actual Days
                       HY = Half Year
                       MY = Modified Half Year
                       MQ = Mid Quarter
                       MM = Mid Month
                       FY = Full Month
                       NM = Next Month

ABT-DEPR-STARTDATE     Numeric 8  (yyyymmdd)                     AM135   AM154
Depreciation Start     This is the date from which               AM30.1  AM30.2
Date                   depreciation calculation begins.


ABT-LIFE-YEARS         Signed 5.2                                AM135   AM154
Element: Life Years    This is the asset life in years.          AM30.1  AM30.2

ABT-STATUS-CP-CALC     Alpha 1                                   AM135   AM154
Calculate Curr         This field indicates whether              AM30.1  AM30.2
Period Status          depreciation has been calculated for the
                       current period.


ABT-LIFE-CP            Signed 5.3                                AM135   AM154
Element: Life          This is the portion of the asset life     AM30.1  AM30.2
                       for the current period.


ABT-TRAN-ND            Numeric 1                                 AM135   AM154
Transaction Number                                               AM30.1  AM30.2
of Decimals

ABT-DEPR-CP            Signed 15.2                               AM135   AM154
Current Period         This is the depreciation amount for the   AM30.1  AM30.2
Depreciation           current period for the from-asset.


ABT-TO-DEPR-CP         Signed 15.2                               AM135   AM154
To Current Period      This is the current period depreciation   AM30.1  AM30.2
Depreciation           amount for the to-asset.


ABT-DEPR-CP-ALLOW      Signed 15.2                               AM135   AM154
Curr Period Deprec     This is the depreciation allowed for      AM30.1  AM30.2
Allowed                the from-asset in the current period.


ABT-TO-DP-CP-ALLOW     Signed 15.2                               AM135   AM154
To Current Period      This is the depreciation allowed in the   AM30.1  AM30.2
Depr Allowed           current period for the to-asset.


ABT-DEPR-YTD           Signed 15.2                               AM135   AM154
Year-to-Date           This is the year-to-date depreciation     AM30.1  AM30.2
Depreciation           for the from-asset.


ABT-TO-DEPR-YTD        Signed 15.2                               AM135   AM154
Element: To YTD DepreciThis is the year-to-date depreciation     AM30.1  AM30.2
                       for the to-asset.


ABT-DEPR-YTD-ALLOW     Signed 15.2                               AM135   AM154
Year-to-Date Depr      This is the year-to-date depreciation     AM30.1  AM30.2
Allowed                allowance for the from-asset.


ABT-TO-DP-YTD-ALLO     Signed 15.2                               AM135   AM154
To YTD Depreciation    This is the year-to-date depreciation     AM30.1  AM30.2
Allowed                allowance for the to-asset.


ABT-DEPR-YTD-OVRRD     Signed 15.2                               AM135   AM154
Year-to-Date Deprec    This is the year-to-date depreciation     AM30.1  AM30.2
Override               override amount for the from-asset.


ABT-TO-DP-YTD-OVRD     Signed 15.2                               AM135   AM154
To YTD Depreciation    This is the year-to-date depreciation     AM30.1  AM30.2
Override               override amount for the to-asset.


ABT-DEPR-LTD           Signed 15.2                               AM135   AM154
Life-to-Date           This is the life-to-date depreciation     AM30.1  AM30.2
Depreciation           for the from-asset.


ABT-TO-DEPR-LTD        Signed 15.2                               AM135   AM154
Element: To LTD DepreciThis is the life-to-date depreciation     AM30.1  AM30.2
                       for the to-asset.


ABT-DEPR-LTD-ALLOW     Signed 15.2                               AM135   AM154
Life-to-Date Deprec    This is the life-to-date depreciation     AM30.1  AM30.2
Allowed                allowance for the from-asset.


ABT-TO-DP-LTD-ALLO     Signed 15.2                               AM135   AM154
To LTD Depreciation    This is the life-to-date depreciation     AM30.1  AM30.2
Allowed                allowance for the to-asset.


ABT-LAST-CLOSE         Signed 15.2                               AM135   AM154
Element: Last Close    This is the last closed balance for the   AM30.1  AM30.2
                       from-asset.


ABT-TO-LAST-CLOSE      Signed 15.2                               AM135   AM154
Element: To-Asset Last This is the last closed balance for the   AM30.1  AM30.2
                       to-asset.


ABT-FIRST-LAST-FL      Alpha 1                                   AM135   AM154
Element: First/Last FlaThis field is an internal,                AM30.1  AM30.2
                       system-maintained value used to control
                       depreciation calculations during the
                       first and last years of an asset's life.

                       Valid values are:

                       F = First. This is the first in-service
                       year for the asset.

                       M = Middle. The asset is in a year other
                       than the first or last.

                       L = Last. This is the last in-service
                       year for the asset.

                       C = Completely Depreciated. The asset no
                       longer participates in depreciation
                       calculations.

                       P = Post Recovery. The system continues
                       to depreciate the asset beyond the
                       original asset life.







ABT-INACT-YTD          Signed 5.3                                AM135   AM154
Year-to-Date           This is the length of time an asset has   AM30.1  AM30.2
Inactivity             been inactive year-to-date.


ABT-INACT-LTD          Signed 7.3                                AM135   AM154
Life-to-Date            This is the time an asset has been       AM30.1  AM30.2
Inactivity             inactive life-to-date.


ABT-SALVAGE-VALUE      Signed 15.2                               AM135   AM154
Element: Salvage Value This is the salvage value of the          AM30.1  AM30.2
                       from-asset at the end of the asset's
                       life. It can be zero.

                       If the depreciation method is STL
                       (Straight Line), the basis used for the
                       depreciation calculation is the asset
                       cost less this salvage value.

                       If the depreciation method is 200DB
                       (Double Declining Balance), 125 (125%
                       Declining Balance), 150 (150% Declining
                       Balance), or 175 (175% Declining
                       Balance), the basis used for the
                       depreciation calculation is the asset
                       cost. Depreciation is taken until the
                       total amount taken is equal to the asset
                       cost less this salvage value.




ABT-TO-SALV-VALUE      Signed 15.2                               AM135   AM154
Element: To Salvage ValThis is the salvage value for the         AM30.1  AM30.2
                       to-asset.

                       If the depreciation method is Straight
                       Line, the basis used for the
                       depreciation calculation is the asset
                       cost less this salvage value.

                       If the depreciation method is 200DB
                       (Double Declining Balance), 125 (125%
                       Declining Balance), 150 (150% Declining
                       Balance), or 175 (175% Declining
                       Balance), the basis used for the
                       depreciation calculation is the asset
                       cost. Depreciation is taken until the
                       total amount taken is equal to the asset
                       cost less this salvage value.




ABT-BUS-PERCENT        Signed 5.2                                AM135   AM154
Element: Business PerceThis is the business use percentage for   AM30.1  AM30.2
                       the asset.


ABT-PERSONAL-USE       Alpha 10                                  AM135   AM154
Element: Personal Use  A personal use code defines the           AM30.1  AM30.2
                       personal use options that asset books
                       use to calculate depreciation, tax
                       credits, and annual depreciation limits
                       up to twenty years. The code is
                       user-definable.


ABT-YR1-EXP            Signed 15.2                               AM135   AM154
Element: First Year ExpThis is the new first year expense for    AM30.1  AM30.2
                       the from-asset. 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.


ABT-TO-YR1-EXP         Signed 15.2                               AM30.1  AM30.2
To First Year          This is the new first year expense for
Expense                the to-asset. This is the first year
                       expense amount for the to-asset for the
                       First Year Expense option. This U.S. tax
                       option allows you to expense and not
                       depreciate a total amount for the assets
                       of each eligible company.


ABT-TC-TABLE           Alpha 10                                  AM135   AM154
Element: Tax Credit TabA user-defined tax credit table, which    AM30.1  AM30.2
                       defines tax credit percentages and
                       annual tax credit recapture percentages
                       for up to twenty years. Asset books use
                       tax credit tables to calculate tax
                       credits.

ABT-TC-PROPERTY        Signed 15.2                               AM135   AM154
Element: Property Tax CThis is the tax credit amount for the     AM30.1  AM30.2
                       from-asset, if you are taking a tax
                       credit for used property.


ABT-TO-TC-PROPERTY     Signed 15.2                               AM30.1  AM30.2
To Property Tax         This is the tax credit amount for the
Credit                 to-asset, if you are taking a tax credit
                       for used property.


ABT-TAX-CREDIT         Signed 15.2                               AM135   AM154
Element: Tax Credit    This is the tax credit amount for the     AM30.1  AM30.2
                       from-asset.


ABT-TO-TAX-CREDIT      Signed 15.2                               AM30.1  AM30.2
Element: To Tax Credit This is the tax credit amount for the
                       to-asset.


ABT-INS-METHOD         Alpha 10                                  AM135   AM154
Element: Insurance MethThis is the insurance method for the      AM30.1  AM30.2
                       asset.


ABT-INS-ACT-VAL        Signed 15.2                               AM135   AM154
Actual Insurance       This is the actual insurance value for    AM30.1  AM30.2
Value                  the from-asset.


ABT-TO-INS-ACT-VAL     Signed 15.2                               AM30.1  AM30.2
To Actual Insurance    This is the actual insurance value for
Value                  the to-asset.


ABT-INS-CMPTD-VAL      Signed 15.2                               AM135   AM154
Computed Insurance     This is the computed insurance value      AM30.1  AM30.2
Value                  for the from-asset.


ABT-TO-INS-CMPTD       Signed 15.2                               AM30.1  AM30.2
To Computed            This is the computed insurance value
Insurance Value        for the to-asset.


ABT-RPL-METHOD         Alpha 10                                  AM135   AM154
Element: Replacement MeThis is the replacement method for the    AM30.1  AM30.2
                       asset.


ABT-RPL-CMPTD-VAL      Signed 15.2                               AM135   AM154
Computed               This is the computed replacement value    AM30.1  AM30.2
Replacement Value      for the from-asset.


ABT-TO-RPL-CMPTD       Signed 15.2                               AM30.1  AM30.2
To Computed            This is the computed replacement value
Replacement Value      for the to-asset.


ABT-TRF-TRF-DATE       Derived
Element: Transfer Date This is the date of the transfer.

ABT-TRF-FULL-PART      Derived
Full or Partial        This field shows whether the transfer
Transfer               is a full transfer (including all items)
                       or a partial transfer (including only
                       some items).


ABT-TRF-TRF-TYPE       Derived
Element: Transfer Type This field indicates the type of the
                       transfer.


ABT-AST-TAG-NBR        Derived
Element: Tag Number    This is the tag, a user-definable
                       identifier, for the asset.


ABT-TO-AST-TAG         Derived
Element: To Tag Number This is the tag for the to-asset.

ABT-AST-ASSET-GRP      Derived
Element: Asset Group   This is the asset group for the
                       from-asset.


ABT-TO-AST-GROUP       Derived
Element: To Asset GroupThis is the asset group for the
                       to-asset.


ABT-BOOK-CURRENCY      Derived
Element: Book Currency This is the currency for the book.

ABT-TRF-CREAT-DATE     Derived
Element: Creation Date This is the date the transfer was
                       created.


ABT-TRF-CREAT-TIME     Derived
Element: Creation Time This is the time the transfer was
                       created.


ABT-TRF-CREATOR-ID     Derived
Element: Creator ID    This is the ID of the person who
                       created the transfer.


                         AMASTBKTRF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABTSET1   ASSET                                                  AM115   AM125
          PROCESS-SEQ                                            AM135   AM145
          BOOK                                                   AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM230   AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM300   AM330
                                                                 ...

ABTSET2   ASSET                                                  AM230   AM310
          BOOK                                                   AMDL.1
          PROCESS-SEQ

                         AMASTBKTRF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required
                            Valid When ABT-ASSET != Zeroes

                            ABT-ASSET          -> AST-ASSET

Amassettrf     AMASSETTRF   Not Required

                            ABT-ASSET          -> ATF-ASSET
                            ABT-PROCESS-SEQ    -> ATF-PROCESS-SEQ

Amastbook      AMASTBOOK    Required

                            ABT-ASSET          -> ASB-ASSET
                            ABT-BOOK           -> ASB-BOOK

Ambook         AMBOOK       Not Required

                            ABT-BOOK           -> AMB-BOOK