AMBKHIST

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 AM22.1 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 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC140 IC66.1 IC83.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.1
MA42.2 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA44.1 MA44.2 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA69.1
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABH-ASSET
Element: Asset
Numeric 10
The asset number for which depreciation is tracked. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.
...
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
AM22.1 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
ABH-BOOK
Element: Book
Alpha 10
The book assigned to the asset for which depreciation is tracked.
...
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
AM22.1 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
ABH-COMPANY
Element: Company
Numeric 4
The company associated with the asset and book.
...
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
AM22.1 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
ABH-YR-END-DATE
Element: Yr End Date
Numeric 8 (yyyymmdd)
The end date of the fiscal year.
...
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
AM22.1 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
ABH-DEPR-YTD
Element: Intl Amt
Signed 18.2
the year-to-date (YTD) depreciation amount. Includes only the business use, not the personal use.
...
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
AM22.1 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
ABH-DEPR-LTD
Element: Intl Amt
Signed 18.2
The life-to-date (LTD) depreciation amount.
...
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
AM22.1 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
ABH-BEG-DEPR-LTD
Element: Intl Amt
Signed 18.2
The life-to-date (LTD) accumulated depreciation at the start of the fiscal year.
...
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
AM22.1 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
ABH-LIFE
Element: Life
Numeric 4
The life of the asset in months.
...
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
AM22.1 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
ABH-METH-SW-DATE
Element: Meth Sw Date
Numeric 8 (yyyymmdd)
The date on which the depreciation method was switched.
AM190 AM192
AM501
ABH-CALC-DEPR-LTD
Element: Calc Depr Ltd
Derived
The calculated life-to-date depreciation amount (Depr-YTD + Beg-Depr-LTD). Used for real-time Drill Around operations.
ABH-BALANCE-FLAG
Element: All Flag
Alpha 1
AM501


AMBKHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABHSET1 ASSET
BOOK
COMPANY
YR-END-DATE
...
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
AM22.1 AM281
ABHSET2 BOOK
ASSET
YR-END-DATE
COMPANY
AM01.1 AM01.2
AM01.3 AM192
AM281 AM310
AM90.2 AM90.5
AM91.2 AM91.5
ABHSET3 ASSET
BOOK
COMPANY
YR-END-DATE*
AM190 AM192
AM320 AM500


AMBKHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Required
ABH-ASSET->AST-ASSET


AMBKHIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:05:54 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.