Lawson Insight Technical Documentation |
|
AMBKHISTX
AMBKHISTX FILE
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 AM90.2 AM90.5 AM91.2 AM91.5
UPDATED BY
AM115 AM117 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
AM40.1 AM40.2 AM40.3 AM40.4 AM41.1 AM41.2
AM500 AM501 AM502 AM551 AM92.1 AM96.1
AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABX-ASSET Numeric 10 AM115 AM117
Element: Asset Number The asset number for which depreciation AM125 AM135
is tracked. AM145 AM15.1
AM15.2 AM15.3
The asset number contains up to ten AM15.4 AM154
numeric characters that uniquely AM170 AM190
identify an asset. Assets are AM192 AM20.1
automatically numbered system-wide. 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
ABX-BOOK Alpha 10 AM115 AM117
Element: Book The book associated with the asset for AM125 AM135
which depreciation is tracked. 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
AM320 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM501 AM502
AM551 AM92.1
AM96.1 AM98.1
ABX-COMPANY Numeric 4 AM115 AM117
Element: Company The company associated with the asset AM125 AM135
and book. 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
AM320 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM501 AM502
AM551 AM92.1
AM96.1 AM98.1
ABX-YR-END-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Yr End Date The end date of the fiscal year for AM125 AM135
which depreciation is tracked. 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
AM320 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM501 AM502
AM551 AM92.1
AM96.1 AM98.1
ABX-PERIOD Numeric 2 AM115 AM117
Element: Last Closed PeThe period for which depreciation is AM125 AM135
stored. 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
AM320 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM501 AM502
AM551 AM92.1
AM96.1 AM98.1
ABX-DEPR-CP Signed 18.2 AM115 AM117
Element: Intl Amt The deprecciation calculated for the AM125 AM135
period. Includes only the business use, AM145 AM15.1
not the personal use. 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 AM502
AM551 AM92.1
AM96.1 AM98.1
ABX-LIFE-REM Signed 7.3 AM115 AM117
Element: Life Rem The remaining life of the asset in AM125 AM135
months. This value represents the number AM145 AM15.1
of months for which Asset Management AM15.2 AM15.3
will continue to calculate depreciation. 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
AM502 AM551
AM92.1 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 18.2 AM115 AM117
Element: Intl Amt The amount on which the depreciation AM125 AM135
calculations are based. AM145 AM15.1
AM15.2 AM15.3
Note: The depreciation basis amount can AM15.4 AM154
be different for each depreciation book AM170 AM190
used. 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
ABX-PD-DEPR-YTD Signed 18.2 AM115 AM117
Element: Intl Amt The year-to-date (YTD) depreciation AM125 AM135
amount for the specified period. AM145 AM15.1
Includes only the business use, not the AM15.2 AM15.3
personal use. 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 AM502
AM551 AM92.1
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 AM117
BOOK AM125 AM135
COMPANY AM145 AM15.1
YR-END-DATE AM15.2 AM15.3
PERIOD 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 AM281
AM30.1 AM30.2
AM30.3 AM310
...
ABXSET2 BOOK AM320 AM90.2
ASSET AM90.5 AM91.2
COMPANY AM91.5
YR-END-DATE
PERIOD
ABXSET3 ASSET
BOOK
YR-END-DATE
PERIOD
COMPANY
ABXSET4 ASSET AM115 AM117
BOOK AM125 AM135
COMPANY AM145 AM15.1
YR-END-DATE AM15.2 AM15.3
PERIOD* 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
...
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-COMPANY -> ABH-COMPANY
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
|