Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             AMBKHIST FILE

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     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
AM551     AM96.1    AM98.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ABH-ASSET            Numeric 10                                  AM115   AM125
Asset Number         The asset number for which depreciation     AM135   AM145
                     is tracked.                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                     The asset number contains up to ten         AM154   AM170
                     numeric characters that uniquely            AM190   AM192
                     identify an asset. Assets are               AM20.1  AM20.2
                     automatically numbered system-wide.         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   AM551
                                                                 AM96.1  AM98.1

ABH-BOOK             Alpha 10                                    AM115   AM125
Book                 The book assigned to the asset for which    AM135   AM145
                     depreciation is tracked.                    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   AM551
                                                                 AM96.1  AM98.1

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

ABH-YR-END-DATE      Numeric 8  (yyyymmdd)                       AM115   AM125
Yr End Date          The end date of the fiscal year.            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   AM551
                                                                 AM96.1  AM98.1

ABH-DEPR-YTD         Signed 15.2                                 AM115   AM125
Depr Ytd             the year-to-date (YTD) depreciation         AM135   AM145
                     amount.  Includes only the business use,    AM15.1  AM15.2
                     not the  personal use.                      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   AM551
                                                                 AM96.1  AM98.1

ABH-DEPR-LTD         Signed 15.2                                 AM320   AM500
Depr Ltd             The life-to-date (LTD) depreciation
                     amount.

ABH-BEG-DEPR-LTD     Signed 15.2                                 AM115   AM125
Beg Depr Ltd         The life-to-date (LTD) accumulated          AM135   AM145
                     depreciation at the  start of the fiscal    AM15.1  AM15.2
                     year.                                       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   AM551
                                                                 AM96.1  AM98.1

ABH-LIFE             Numeric 4                                   AM115   AM125
Life                 The life of the asset in months.            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
                                                                 AM551   AM96.1
                                                                 AM98.1

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

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

                         AMBKHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

ABHSET2   BOOK                                                   AM90.2  AM90.5
          ASSET                                                  AM91.2  AM91.5
          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