 |
Lawson Insight Technical Documentation |
|
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 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 AM310 AM320 AM40.1 AM40.2 AM41.1
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 AM20.1
identify an asset. Assets are AM20.2 AM20.3
automatically numbered system-wide. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM320
AM40.1 AM40.2
AM41.1 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 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 AM320
AM40.1 AM40.2
AM41.1 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 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 AM320
AM40.1 AM40.2
AM41.1 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 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 AM320
AM40.1 AM40.2
AM41.1 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 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 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABH-DEPR-LTD Signed 15.2
Depr Ltd The life-to-date (LTD) depreciation
amount.
ABH-BEG-DEPR-LTD Signed 15.2 AM190 AM320
Beg Depr Ltd The life-to-date (LTD) accumulated AM500
depreciation at the start of the fiscal
year.
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 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 AM40.1
AM40.2 AM41.1
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 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
AM310 AM320
AM40.1 AM40.2
...
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-COMPANY -> ABX-COMPANY
ABH-YR-END-DATE -> ABX-YR-END-DATE
ABX-PERIOD
|