Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMBKHIST


                             AMBKHIST FILE

                           Asset Book History

The Asset Management Book History file stores the depreciation information for
an asset within a book for each year of depreciation.

REFERENCED BY

AM281     AMDL.1    AM90.2    AM90.5    AM91.2    AM91.5

UPDATED BY

AM115     AM117     AM125     AM135     AM145     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    AM30.1    AM30.2    AM30.3    AM310     AM320
AM40.1    AM40.2    AM40.3    AM40.4    AM41.1    AM41.2
AM500     AM501     AM502     AM551     AM92.1    AM96.1
AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ABH-ASSET              Numeric 10                                AM115   AM117
Element: Asset Number  The asset number for which depreciation   AM125   AM135
                       is tracked.                               AM145   AM15.1
                                                                 AM15.2  AM15.3
                       The asset number contains up to ten       AM15.4  AM154
                       numeric characters that uniquely          AM170   AM190
                       identify an asset. Assets are             AM192   AM20.1
                       automatically numbered system-wide.       AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM320   AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM501   AM502
                                                                 AM551   AM92.1
                                                                 AM96.1  AM98.1

ABH-BOOK               Alpha 10                                  AM115   AM117
Element: Book          The book assigned to the asset for which  AM125   AM135
                       depreciation is tracked.                  AM145   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  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM320   AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM501   AM502
                                                                 AM551   AM92.1
                                                                 AM96.1  AM98.1

ABH-COMPANY            Numeric 4                                 AM115   AM117
Element: Company       The company associated with the asset     AM125   AM135
                       and book.                                 AM145   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  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM320   AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM501   AM502
                                                                 AM551   AM92.1
                                                                 AM96.1  AM98.1

ABH-YR-END-DATE        Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Yr End Date   The end date of the fiscal year.          AM125   AM135
                                                                 AM145   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  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM320   AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM501   AM502
                                                                 AM551   AM92.1
                                                                 AM96.1  AM98.1

ABH-DEPR-YTD           Signed 18.2                               AM115   AM117
Element: Intl Amt      the year-to-date (YTD) depreciation       AM125   AM135
                       amount.  Includes only the business use,  AM145   AM15.1
                       not the  personal use.                    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  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM320   AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM501   AM502
                                                                 AM551   AM92.1
                                                                 AM96.1  AM98.1

ABH-DEPR-LTD           Signed 18.2                               AM115   AM117
Element: Intl Amt      The life-to-date (LTD) depreciation       AM125   AM135
                       amount.                                   AM145   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  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM320   AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM501   AM502
                                                                 AM551   AM92.1
                                                                 AM96.1  AM98.1

ABH-BEG-DEPR-LTD       Signed 18.2                               AM115   AM117
Element: Intl Amt      The life-to-date (LTD) accumulated        AM125   AM135
                       depreciation at the  start of the fiscal  AM145   AM15.1
                       year.                                     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  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM320   AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.1
                                                                 AM41.2  AM500
                                                                 AM501   AM502
                                                                 AM551   AM92.1
                                                                 AM96.1  AM98.1

ABH-LIFE               Numeric 4                                 AM115   AM117
Element: Life          The life of the asset in months.          AM125   AM135
                                                                 AM145   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  AM30.1
                                                                 AM30.2  AM30.3
                                                                 AM40.1  AM40.2
                                                                 AM40.3  AM40.4
                                                                 AM41.1  AM41.2
                                                                 AM500   AM501
                                                                 AM502   AM551
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ABH-METH-SW-DATE       Numeric 8  (yyyymmdd)                     AM501
Element: Meth Sw Date  The date on which the depreciation
                       method was switched.

ABH-CALC-DEPR-LTD      Derived
Element: Calc Depr Ltd The calculated life-to-date depreciation
                       amount (Depr-YTD + Beg-Depr-LTD). Used
                       for real-time Drill Around operations.

ABH-BALANCE-FLAG       Alpha 1                                   AM501
Element: All Flag

                         AMBKHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ABHSET1   ASSET                                                  AM115   AM117
          BOOK                                                   AM125   AM135
          COMPANY                                                AM145   AM15.1
          YR-END-DATE                                            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  AM281
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM310
                                                                 ...

ABHSET2   BOOK                                                   AM90.2  AM90.5
          ASSET                                                  AM91.2  AM91.5
          YR-END-DATE
          COMPANY

ABHSET3   ASSET                                                  AM190   AM320
          BOOK                                                   AM500
          COMPANY
          YR-END-DATE*

                         AMBKHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Required

                            ABH-ASSET          -> AST-ASSET

                         AMBKHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambkhistx      AMBKHISTX

                            ABH-ASSET          -> ABX-ASSET
                            ABH-BOOK           -> ABX-BOOK
                            ABH-YR-END-DATE    -> ABX-YR-END-DATE
                                                  ABX-PERIOD
                                                  ABX-COMPANY