AMBKHISTX

Period Asset Book History

The Asset Management Book History by Period file stores the depreciation information for an asset within a book for each period of depreciation.

REFERENCED BY
AM281 AMDL.1 AM91.2 AM91.5 AM90.2 AM90.5


UPDATED BY
AC160 AM115 AM117 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM155
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
AM22.2 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 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
MA126 MA180 MA278 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 MA53.1
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 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.3 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABX-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 AM155
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
AM22.2 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
ABX-BOOK
Element: Book
Alpha 10
The book associated with the asset for which depreciation is tracked.
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.2 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
ABX-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 AM155
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
AM22.2 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
ABX-YR-END-DATE
Element: Yr End Date
Numeric 8 (yyyymmdd)
The end date of the fiscal year for which depreciation is tracked.
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.2 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
ABX-PERIOD
Element: Period
Numeric 2
The period for which depreciation is stored.
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.2 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
ABX-DEPR-CP
Element: Intl Amt
Signed 18.2
The deprecciation calculated for the period. Includes only the business use, not the personal use.
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.2 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
ABX-LIFE-REM
Element: Life Rem
Signed 7.3
The remaining life of the asset in months. This value represents the number of months for which Asset Management will continue to calculate depreciation.
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.2 AM30.1
AM30.2 AM30.3
AM320 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
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
ABX-METH-SWITCHED
Element: All Flag
Alpha 1
Indicates whether the method swich was used. Valid values are: N = No Y = Yes
AM190 AM192
AM320 AM501
ABX-BOOK-BASIS
Element: Intl Amt
Signed 18.2
The amount on which the depreciation calculations are based. Note: The depreciation basis amount can be different for each depreciation book used.
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.2 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
ABX-PD-DEPR-YTD
Element: Intl Amt
Signed 18.2
The year-to-date (YTD) depreciation amount for the specified period. Includes only the business use, not the personal use.
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.2 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
ABX-PD-DEPR-LTD
Element: Pd Depr Ltd
Derived
The life-to-date (LTD) depreciation amount for the specified period. Includes only the business use, not the personal use.
ABX-BOOK-VALUE
Element: Book Value
Derived
The book value is calculated as follows: Book basis - Life-to-date period depreciation.


AMBKHISTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABXSET1 ASSET
BOOK
COMPANY
YR-END-DATE
PERIOD
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
ABXSET2 BOOK
ASSET
COMPANY
YR-END-DATE
PERIOD
AM192 AM320
AM91.2 AM91.5
ABXSET3 ASSET
BOOK
YR-END-DATE
PERIOD
COMPANY
AM90.2 AM90.5
ABXSET4 ASSET
BOOK
COMPANY
YR-END-DATE
PERIOD*
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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


AMBKHISTX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Required
ABX-ASSET->AST-ASSET
Amastbook AMASTBOOK Required
ABX-ASSET->ASB-ASSET
ABX-BOOK->ASB-BOOK
Ambkhist AMBKHIST Required
ABX-ASSET->ABH-ASSET
ABX-BOOK->ABH-BOOK
ABX-COMPANY->ABH-COMPANY
ABX-YR-END-DATE->ABH-YR-END-DATE


AMBKHISTX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ambktrans AMBKTRANS
ABX-ASSET->ABK-ASSET
ABX-BOOK->ABK-BOOK
ABX-COMPANY->ABK-COMPANY
  ABK-TRANS-STATUS
  ABK-SEQ-NUMBER
Amtrans AMTRANS
ABX-ASSET->AMT-ASSET
Spaces->AMT-TRANS-STATUS
ABX-COMPANY->AMT-COMPANY
ABX-BOOK->AMT-BOOK
  AMT-SEQ-NUMBER


File created: Thu Jun 09 02:05:17 2016

Home
Contact Us



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