 |
Lawson Insight Technical Documentation |
|
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 AM90.2 AM90.5 AM91.2 AM91.5
UPDATED BY
AM115 AM125 AM135 AM145 AM15.1 AM15.2
AM15.3 AM15.4 AM154 AM170 AM190 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 AM310 AM320 AM40.1 AM40.2 AM41.1
AM500 AM551 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABX-ASSET Numeric 10 AM115 AM125
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 AM20.1
identify an asset. Assets are AM20.2 AM20.3
automatically numbered system-wide. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABX-BOOK Alpha 10 AM115 AM125
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 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 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABX-COMPANY Numeric 4 AM115 AM125
Company The company associated with the asset AM135 AM145
and book. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM190 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 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABX-YR-END-DATE Numeric 8 (yyyymmdd) AM115 AM125
Yr End 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 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 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABX-PERIOD Numeric 2 AM115 AM125
Last Closed Period The period for which depreciation is AM135 AM145
stored. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
AM190 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 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABX-DEPR-CP Signed 15.2 AM115 AM125
Depr Cp 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 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 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABX-LIFE-REM Signed 7.3 AM190 AM320
Life Rem The remaining life of the asset in
months. This value represents the number
of months for which Asset Management
will continue to calculate depreciation.
ABX-METH-SWITCHED Alpha 1 AM320
Meth Switched Indicates whether the method swich was
used.
Valid values are:
N = No
Y = Yes
ABX-BOOK-BASIS Signed 15.2 AM115 AM125
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 AM20.1
used. 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 AM320
AM40.1 AM40.2
AM41.1 AM500
AM551 AM96.1
AM98.1
ABX-PD-DEPR-YTD Signed 15.2 AM115 AM125
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
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
AM320 AM40.1
AM40.2 AM41.1
AM500 AM551
AM96.1 AM98.1
ABX-PD-DEPR-LTD Derived
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
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 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
AM310 AM320
AM40.1 AM40.2
...
ABXSET2 BOOK AM90.2 AM90.5
ASSET AM91.2 AM91.5
COMPANY
YR-END-DATE
PERIOD
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
|