Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMBKHISTX


                             AMBKHISTX FILE

                       Period Asset Book History

The Asset Management Book History by Period file stores the depreciation
information for an asset within a book for each period 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

ABX-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

ABX-BOOK               Alpha 10                                  AM115   AM117
Element: Book          The book associated with the asset for    AM125   AM135
                       which 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

ABX-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

ABX-YR-END-DATE        Numeric 8  (yyyymmdd)                     AM115   AM117
Element: Yr End Date   The end date of the fiscal year for       AM125   AM135
                       which 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

ABX-PERIOD             Numeric 2                                 AM115   AM117
Element: Last Closed PeThe period for which depreciation is      AM125   AM135
                       stored.                                   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

ABX-DEPR-CP            Signed 18.2                               AM115   AM117
Element: Intl Amt      The deprecciation calculated for the      AM125   AM135
                       period. 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

ABX-LIFE-REM           Signed 7.3                                AM115   AM117
Element: Life Rem      The remaining life of the asset in        AM125   AM135
                       months. This value represents the number  AM145   AM15.1
                       of months for which Asset Management      AM15.2  AM15.3
                       will continue to calculate depreciation.  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
                                                                 AM502   AM551
                                                                 AM92.1  AM96.1
                                                                 AM98.1

ABX-METH-SWITCHED      Alpha 1                                   AM320   AM501
Element: All Flag      Indicates whether the method swich was
                       used.

                       Valid values are:

                       N = No
                       Y = Yes

ABX-BOOK-BASIS         Signed 18.2                               AM115   AM117
Element: Intl Amt      The amount on which the depreciation      AM125   AM135
                       calculations are based.                   AM145   AM15.1
                                                                 AM15.2  AM15.3
                       Note:  The depreciation basis amount can  AM15.4  AM154
                       be different for each depreciation book   AM170   AM190
                       used.                                     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

ABX-PD-DEPR-YTD        Signed 18.2                               AM115   AM117
Element: Intl Amt      The year-to-date (YTD) depreciation       AM125   AM135
                       amount for the specified period.          AM145   AM15.1
                       Includes only the business use, not the   AM15.2  AM15.3
                       personal use.                             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

ABX-PD-DEPR-LTD        Derived
Element: Pd Depr Ltd   The life-to-date (LTD) depreciation
                       amount for the specified period.
                       Includes only the business use, not the
                       personal use.

ABX-BOOK-VALUE         Derived
Element: Book Value    The book value is calculated as follows:
                       Book basis - Life-to-date period
                       depreciation.

                         AMBKHISTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

ABXSET2   BOOK                                                   AM320   AM90.2
          ASSET                                                  AM90.5  AM91.2
          COMPANY                                                AM91.5
          YR-END-DATE
          PERIOD

ABXSET3   ASSET
          BOOK
          YR-END-DATE
          PERIOD
          COMPANY

ABXSET4   ASSET                                                  AM115   AM117
          BOOK                                                   AM125   AM135
          COMPANY                                                AM145   AM15.1
          YR-END-DATE                                            AM15.2  AM15.3
          PERIOD*                                                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
                                                                 ...

                         AMBKHISTX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Required

                            ABX-ASSET          -> AST-ASSET

Amastbook      AMASTBOOK    Required

                            ABX-ASSET          -> ASB-ASSET
                            ABX-BOOK           -> ASB-BOOK

Ambkhist       AMBKHIST     Required

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

                         AMBKHISTX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambktrans      AMBKTRANS

                            ABX-ASSET          -> ABK-ASSET
                            ABX-BOOK           -> ABK-BOOK
                            ABX-COMPANY        -> ABK-COMPANY
                                                  ABK-TRANS-STATUS
                                                  ABK-SEQ-NUMBER

Amtrans        AMTRANS

                            ABX-ASSET          -> AMT-ASSET
                            Spaces             -> AMT-TRANS-STATUS
                            ABX-COMPANY        -> AMT-COMPANY
                            ABX-BOOK           -> AMT-BOOK
                                                  AMT-SEQ-NUMBER