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 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 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 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABX-ASSET Numeric 10 AC160 AM115
Element: Asset The asset number for which depreciation AM117 AM125
is tracked. AM135 AM145
AM15.1 AM15.2
The asset number contains up to ten AM15.3 AM15.4
numeric characters that uniquely AM154 AM170
identify an asset. Assets are AM19.1 AM19.2
automatically numbered system-wide. 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
...
ABX-BOOK Alpha 10 AC160 AM115
Element: Book The book associated with the asset for AM117 AM125
which depreciation is tracked. 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
...
ABX-COMPANY Numeric 4 AC160 AM115
Element: Company The company associated with the asset AM117 AM125
and book. 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
...
ABX-YR-END-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Yr End Date The end date of the fiscal year for AM117 AM125
which depreciation is tracked. 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
...
ABX-PERIOD Numeric 2 AC160 AM115
Element: Period The period for which depreciation is AM117 AM125
stored. 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
...
ABX-DEPR-CP Signed 18.2 AC160 AM115
Element: Intl Amt The deprecciation calculated for the AM117 AM125
period. Includes only the business use, AM135 AM145
not the personal use. 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
...
ABX-LIFE-REM Signed 7.3 AC160 AM115
Element: Life Rem The remaining life of the asset in AM117 AM125
months. This value represents the number AM135 AM145
of months for which Asset Management AM15.1 AM15.2
will continue to calculate depreciation. 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
...
ABX-METH-SWITCHED Alpha 1 AM190 AM320
Element: All Flag Indicates whether the method swich was AM501
used.
Valid values are:
N = No
Y = Yes
ABX-BOOK-BASIS Signed 18.2 AC160 AM115
Element: Intl Amt The amount on which the depreciation AM117 AM125
calculations are based. AM135 AM145
AM15.1 AM15.2
Note: The depreciation basis amount can AM15.3 AM15.4
be different for each depreciation book AM154 AM170
used. 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
...
ABX-PD-DEPR-YTD Signed 18.2 AC160 AM115
Element: Intl Amt The year-to-date (YTD) depreciation AM117 AM125
amount for the specified period. AM135 AM145
Includes only the business use, not the AM15.1 AM15.2
personal use. 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
...
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 AC160 AM115
BOOK AM117 AM125
COMPANY AM135 AM145
YR-END-DATE AM15.1 AM15.2
PERIOD 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
...
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
ABXSET4 ASSET AC160 AM115
BOOK AM117 AM125
COMPANY AM135 AM145
YR-END-DATE AM15.1 AM15.2
PERIOD* 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
...
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
|