Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTBKINV


                            AMASTBKINV FILE

UPDATED BY

AM502     AM92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IBK-RUN-GROUP          Alpha 15                                  AM92.1
Element: Run Group     Run Group and Seq Number are the keys
                       to the file.  They should be used to
                       group records together for interfacing.

IBK-ASSET              Numeric 10                                AM92.1
Element: Asset Number  The asset number contains up to ten
                       numeric characters that uniquely
                       identify an asset. Assets are
                       automatically numbered system-wide.

IBK-BOOK               Alpha 10                                  AM92.1
Element: Book          A user-defined book name. Books are
                       used by assets for calculating
                       depreciation, replacement cost, and
                       insurance values, and for reporting.

IBK-BOOK-STATUS        Alpha 1                                   AM502   AM92.1
Element: Status Cd

IBK-LIFE               Numeric 4                                 AM92.1
Element: Life

IBK-LIFE-REM           Signed 7.3                                AM502   AM92.1
Element: Life Rem

IBK-BOOK-BASIS         Signed 18.2                               AM92.1
Element: Intl Amt      The GL BOOK basis field contains the
                       amount on which the depreciation
                       calculations are based.

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

IBK-METHOD             Alpha 10                                  AM92.1
Element: Method Code   The method.

IBK-INSRV-DATE         Numeric 8  (yyyymmdd)                     AM502   AM92.1
Element: Date          The book in-service date for the asset.

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

IBK-METH-TABLE-YR      Numeric 2                                 AM502   AM92.1
Element: Meth Table Yr

IBK-CONVENTION         Alpha 2                                   AM502   AM92.1
Element: Convention

IBK-LIFE-YEARS         Signed 5.2                                AM502   AM92.1
Element: Life Years

IBK-DEPR-YTD           Signed 18.2                               AM92.1
Element: Intl Amt

IBK-DEPR-YTD-ALLOW     Signed 18.2                               AM92.1
Element: Intl Amt

IBK-DEPR-LTD           Signed 18.2                               AM92.1
Element: Intl Amt

IBK-DEPR-LTD-ALLOW     Signed 18.2                               AM92.1
Element: Intl Amt

IBK-INACT-YTD          Signed 5.3                                AM92.1
Element: Inact Ytd

IBK-INACT-LTD          Signed 7.3                                AM92.1
Element: Inact Ltd

IBK-SALVAGE-VALUE      Signed 18.2                               AM92.1
Element: Intl Amt      This is the GL BOOK salvage value of
                       the 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 DDB
                       (Double Declining Balance), 150 (150%
                       Declining Balance), or 175 (175%
                       Declining Balance), the basis used for
                       the depreciation calculation is the
                       asset cost. Depreciation will be taken
                       until the total amount taken is equal to
                       the asset cost less this salvage value.

IBK-BUS-PERCENT        Signed 5.2                                AM502   AM92.1
Element: Bus Percent

IBK-PERSONAL-USE       Alpha 10                                  AM92.1
Element: Personal Use  A personal use code defines the
                       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.


IBK-YR1-EXP            Signed 18.2                               AM92.1
Element: Intl Amt      This is 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.

IBK-TC-TABLE           Alpha 10                                  AM92.1
Element: Tc Table      A user-defined tax credit table, which
                       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.

IBK-TC-PROPERTY        Signed 18.2                               AM92.1
Element: Intl Amt

IBK-TC-CREDIT          Signed 18.2                               AM92.1
Element: Intl Amt

IBK-INS-METHOD         Alpha 10                                  AM92.1
Element: Method Code

IBK-INS-ACT-VAL        Signed 18.2                               AM92.1
Element: Intl Amt

IBK-INS-CMPTD-VAL      Signed 18.2                               AM92.1
Element: Intl Amt

IBK-RPL-METHOD         Alpha 10                                  AM92.1
Element: Method Code

IBK-RPL-CMPTD-VAL      Signed 18.2                               AM92.1
Element: Intl Amt

                         AMASTBKINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IBKSET1   RUN-GROUP                                              AM502   AM92.1
          BOOK
          ASSET

IBKSET2   ASSET                                                  AM92.1
          BOOK