Lawson Insight Technical Documentation |
|
AMBKHISTX
AMBKHISTX FILE
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
AM115 AM125 AM135 AM145 AM15.1 AM15.2
AM15.3 AM15.4 AM154 AM170 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 AM551 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABX-ASSET Numeric 10 AM115 AM125
Element: 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 AM192
identify an asset. Assets are AM20.1 AM20.2
automatically numbered system-wide. 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
AM551 AM96.1
AM98.1
ABX-BOOK Alpha 10 AM115 AM125
Element: Book The book associated with the asset for AM135 AM145
which depreciation is tracked. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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
AM551 AM96.1
AM98.1
ABX-COMPANY Numeric 4 AM115 AM125
Element: Company The company associated with the asset AM135 AM145
and book. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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
AM551 AM96.1
AM98.1
ABX-YR-END-DATE Numeric 8 (yyyymmdd) AM115 AM125
Element: Date The end date of the fiscal year for AM135 AM145
which depreciation is tracked. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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
AM551 AM96.1
AM98.1
ABX-PERIOD Numeric 2 AM115 AM125
Element: Current PeriodThe period for which depreciation is AM135 AM145
stored. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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
AM551 AM96.1
AM98.1
ABX-DEPR-CP Signed 15.2 AM115 AM125
Element: Depr Ytd The deprecciation calculated for the AM135 AM145
period. Includes only the business use, AM15.1 AM15.2
not the personal use. AM15.3 AM15.4
AM154 AM170
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
AM551 AM96.1
AM98.1
ABX-LIFE-REM Signed 7.3 AM115 AM125
Element: Life Rem The remaining life of the asset in AM135 AM145
months. This value represents the number AM15.1 AM15.2
of months for which Asset Management AM15.3 AM15.4
will continue to calculate depreciation. AM154 AM170
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 AM551
AM96.1 AM98.1
ABX-METH-SWITCHED Alpha 1 AM320 AM501
Element: All Flag Indicates whether the method swich was
used.
Valid values are:
N = No
Y = Yes
ABX-BOOK-BASIS Signed 15.2 AM115 AM125
Element: Book Basis The amount on which the depreciation AM135 AM145
calculations are based. AM15.1 AM15.2
AM15.3 AM15.4
Note: The depreciation basis amount can AM154 AM170
be different for each depreciation book AM190 AM192
used. 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
AM551 AM96.1
AM98.1
ABX-PD-DEPR-YTD Signed 15.2 AM115 AM125
Element: Pd Depr Ytd The year-to-date (YTD) depreciation AM135 AM145
amount for the specified period. AM15.1 AM15.2
Includes only the business use, not the AM15.3 AM15.4
personal use. AM154 AM170
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
AM551 AM96.1
AM98.1
ABX-PD-DEPR-LTD Derived
Element: Pd Depr Ltd The life-to-date (LTD) depreciation
amount for the specified period.
Includes only the business use, not the
personal use.
ABX-BOOK-VALUE Derived
Element: Book Value 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 AM115 AM125
BOOK AM135 AM145
COMPANY AM15.1 AM15.2
YR-END-DATE AM15.3 AM15.4
PERIOD AM154 AM170
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 AM30.3
AM310 AM320
...
ABXSET2 BOOK AM320 AM91.2
ASSET AM91.5
COMPANY
YR-END-DATE
PERIOD
ABXSET3 ASSET AM90.2 AM90.5
BOOK
YR-END-DATE
PERIOD
COMPANY
AMBKHISTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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-YR-END-DATE -> ABH-YR-END-DATE
AMBKHISTX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|