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 AM01.1 AM01.2 AM01.3 AM90.2
AM90.5 AM91.2 AM91.5
UPDATED BY
AC160 AM115 AM117 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM170
AM19.1 AM19.2 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 AM330 AM40.1 AM40.2
AM40.3 AM40.4 AM41.1 AM41.2 AM500 AM501
AM502 AM551 AM92.1 AM96.1 AM98.1 AP115
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP305 API1.1 API2.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABH-ASSET Numeric 10 AC160 AM115
Element: Asset The asset number for which depreciation AM117 AM125
is tracked. AM135 AM145
AM15.1 AM15.2
The asset number contains up to ten AM15.3 AM15.4
numeric characters that uniquely AM154 AM170
identify an asset. Assets are AM19.1 AM19.2
automatically numbered system-wide. 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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
...
ABH-BOOK Alpha 10 AC160 AM115
Element: Book The book assigned to the asset for which AM117 AM125
depreciation is tracked. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
...
ABH-COMPANY Numeric 4 AC160 AM115
Element: Company The company associated with the asset AM117 AM125
and book. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
...
ABH-YR-END-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Yr End Date The end date of the fiscal year. AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
...
ABH-DEPR-YTD Signed 18.2 AC160 AM115
Element: Intl Amt the year-to-date (YTD) depreciation AM117 AM125
amount. Includes only the business use, AM135 AM145
not the personal use. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
...
ABH-DEPR-LTD Signed 18.2 AC160 AM115
Element: Intl Amt The life-to-date (LTD) depreciation AM117 AM125
amount. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
...
ABH-BEG-DEPR-LTD Signed 18.2 AC160 AM115
Element: Intl Amt The life-to-date (LTD) accumulated AM117 AM125
depreciation at the start of the fiscal AM135 AM145
year. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
...
ABH-LIFE Numeric 4 AC160 AM115
Element: Life The life of the asset in months. AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
...
ABH-METH-SW-DATE Numeric 8 (yyyymmdd) AM190 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 AC160 AM115
BOOK AM117 AM125
COMPANY AM135 AM145
YR-END-DATE AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM19.1 AM19.2
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
...
ABHSET2 BOOK AM01.1 AM01.2
ASSET AM01.3 AM90.2
YR-END-DATE AM90.5 AM91.2
COMPANY AM91.5
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
|