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
AMDL.1 AM91.2 AM91.5


UPDATED BY
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 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POII.1 POIJ.1 AM281 AM90.2 AM90.5

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.
...
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
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 AP26.1
ABX-BOOK
Element: Book
Alpha 10
The book associated with the asset for which depreciation is tracked.
...
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
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 AP26.1
ABX-COMPANY
Element: Company
Numeric 4
The company associated with the asset and book.
...
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
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 AP26.1
ABX-YR-END-DATE
Element: Yr End Date
Numeric 8 (yyyymmdd)
The end date of the fiscal year for which depreciation is tracked.
...
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
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 AP26.1
ABX-PERIOD
Element: Period
Numeric 2
The period for which depreciation is stored.
...
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
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 AP26.1
ABX-DEPR-CP
Element: Intl Amt
Signed 18.2
The deprecciation calculated for the period. Includes only the business use, not the personal use.
...
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
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 AP26.1
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.
...
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
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
AP25.1 AP25.2
AP26.1 AP27.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.
...
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
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 AP26.1
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.
...
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
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 AP26.1
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
...
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 AM281
AM30.1 AM30.2
ABXSET2 BOOK
ASSET
COMPANY
YR-END-DATE
PERIOD
AM192 AM91.2
AM91.5
ABXSET3 ASSET
BOOK
YR-END-DATE
PERIOD
COMPANY
AM90.2 AM90.5
ABXSET4 ASSET
BOOK
COMPANY
YR-END-DATE
PERIOD*
...
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


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: Wed Jun 08 20:47:08 2016

Home
Contact Us



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