Lawson Insight Technical Documentation |
|
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
|