Lawson Insight Technical Documentation |
|
AMASTBKADJ
AMASTBKADJ FILE
Asset Book Adjustment
The Asset Book Adjustment file is an audit file that stores records of
changes that are made to Asset Book file records. Each asset book adjustment
record describes the before and after values of asset book fields that were
changed, as well as the date and time of the change and the operator who made
the changes.
REFERENCED BY
AM135 AM145 AM154 AM190 AM192 AM225
AM30.1 AM30.2 AM30.3 AM40.1 AM40.2 AM40.3
AM40.4 AM41.1 AM41.2 AMDL.1
UPDATED BY
AC160 AM115 AM117 AM125 AM15.1 AM15.2
AM15.3 AM15.4 AM170 AM19.1 AM19.2 AM20.1
AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM21.1
AM21.2 AM21.3 AM21.4 AM21.5 AM21.6 AM300
AM310 AM500 AM502 AM520 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
AM330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABA-ASSET Numeric 10 AC160 AM115
Element: Asset Key field. The asset number contains up AM117 AM125
to ten numeric characters that uniquely AM15.1 AM15.2
identify an asset. Assets are AM15.3 AM15.4
automatically numbered system-wide. AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-BOOK Alpha 10 AC160 AM115
Element: Book Key field. A user-defined book name. AM117 AM125
Books are used by assets for calculating AM15.1 AM15.2
depreciation, replacement cost, and AM15.3 AM15.4
insurance values, and for reporting. AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM520 AM551
AM92.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
...
ABA-PROCESS-SEQ Numeric 6 AC160 AM115
Element: Process SequenKey field. This is the process sequence AM117 AM125
number for the asset book adjustment. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-ADJUST-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Adjustment DatThis is the effective date for the AM117 AM125
adjustment. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-COMPUTE Alpha 1 AC160 AM115
Element: Compute This option determines how an AM117 AM125
adjustment affects depreciation in the AM15.1 AM15.2
period of adjustment, in prior periods AM15.3 AM15.4
of the same year, and in future years. AM19.1 AM19.2
Valid values are: AM20.1 AM20.2
AM20.4 AM21.1
N = Any difference between the AM21.2 AM21.4
year-to-date depreciation taken and the AM500 AM502
annual amount that should be taken based AM551 AM92.1
on the change is spread over the AM98.1 AP115
remaining depreciation periods in the AP125 AP126
current year. AP131 AP20.1
AP20.2 AP20.3
Y = Any difference between the AP20.4 AP20.5
year-to-date depreciation taken and the AP20.7 AP21.1
amount that should be taken based on the AP220 AP23.1
change is charged to the current AP25.1 AP25.2
depreciation period. AP26.1 AP27.1
AP30.2 AP30.4
P = The net asset value as of the AP305 API1.1
adjustment date is allocated over the API2.1 BL120
assets remaining life. No current period BL122 BL130
adjustment is applicable and no annual BL20.1 BL20.3
limits are applied to the current year BL21.2 BL21.5
depreciation calculation. BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
...
ABA-BOOK-STATUS Alpha 1 AC160 AM115
Element: Book Status This field indicates the book status. AM117 AM125
Valid values are: AM15.1 AM15.2
A = Active AM15.3 AM15.4
I = Inactive AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-BOOK-STATUS Alpha 1 AC160 AM115
Element: To Book StatusThis is the book status for the AM117 AM125
transfer-to asset. Valid values are: AM15.1 AM15.2
A = Active AM15.3 AM15.4
I = Inactive AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-LIFE Numeric 4 AC160 AM115
Element: Life This is the asset life in months. AM117 AM125
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-LIFE Numeric 4 AC160 AM115
Element: To Life This is the life in months for the AM117 AM125
transfer-to asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-LIFE-REM Signed 7.3 AC160 AM115
Element: Life RemainingThis is the asset life remaining in AM117 AM125
months. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-LIFE-REM Signed 7.3 AC160 AM115
Element: To Life RemainThis is the asset life remaining in AM117 AM125
months for the transfer-to asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-BOOK-BASIS Signed 18.2 AC160 AM115
Element: Book Basis This field contains the amount on which AM117 AM125
the depreciation calculations are based. AM15.1 AM15.2
AM15.3 AM15.4
Note: The depreciation basis amount can AM19.1 AM19.2
be different for each depreciation book. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-BOOK-BASIS Signed 18.2 AC160 AM115
Element: To Book Basis This field contains the amount on which AM117 AM125
depreciation calculations for the AM15.1 AM15.2
to-asset are based. AM15.3 AM15.4
AM19.1 AM19.2
Note: The depreciation basis amount can AM20.1 AM20.2
be different for each depreciation book. AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-METHOD Alpha 10 AC160 AM115
Element: Method This is the method. It can be a AM117 AM125
predefined or a user-defined method. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-METHOD Alpha 10 AC160 AM115
Element: To Method This is the method for the to-asset. It AM117 AM125
can be a predefined or a user-defined AM15.1 AM15.2
method. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-METH-SWITCHED Alpha 1 AC160 AM115
Element: Method SwitcheThis is the switch used to indicate AM117 AM125
when the Asset Management system has AM15.1 AM15.2
switched the depreciation method. It AM15.3 AM15.4
remains blank until the switch occurs. AM19.1 AM19.2
The system then fills in an asterisk AM20.1 AM20.2
("*"). AM20.4 AM21.1
AM21.2 AM21.4
Valid values are: AM500 AM502
AM551 AM92.1
# = (Blank); the switch is not in use. AM98.1 AP115
AP125 AP126
* = (Asterisk); the depreciation method AP131 AP20.1
has been switched to the optimizing AP20.2 AP20.3
method. 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
...
ABA-TO-METH-SWITCH Alpha 1 AC160 AM115
Element: To Method SwitThis field indicates for the to-asset AM117 AM125
whether the Asset Management system has AM15.1 AM15.2
switched the depreciation method. It AM15.3 AM15.4
remains blank until the switch occurs; AM19.1 AM19.2
then the system fills in an asterisk in AM20.1 AM20.2
the field. AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-INSRV-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: In Service DatThe book in-service date for the asset. AM117 AM125
AM15.1 AM15.2
Note: The in-service date can be AM15.3 AM15.4
different for each depreciation book AM19.1 AM19.2
used. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-INSRV-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: To In Service The book in-service date for the AM117 AM125
to-asset. AM15.1 AM15.2
AM15.3 AM15.4
Note: The in-service date can be AM19.1 AM19.2
different for each depreciation book. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-METH-TABLE-YR Numeric 2 AC160 AM115
Element: Method Table YThis field indicates what year of its AM117 AM125
life the asset is in. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-METH-TBL-YR Numeric 2 AC160 AM115
Element: To Method TablThis field indicates what year of its AM117 AM125
the to-asset is in. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-CONVENTION Alpha 2 AC160 AM115
Element: Convention This is the convention for depreciation AM117 AM125
calculation. Valid values are: AM15.1 AM15.2
AM15.3 AM15.4
Full Month = The asset receives a full AM19.1 AM19.2
month of depreciation during the month AM20.1 AM20.2
it is placed in service. The asset does AM20.4 AM21.1
not receive any depreciation for the AM21.2 AM21.4
month in which it is disposed of. AM500 AM502
AM551 AM92.1
Modified Half Month = If the asset is AM98.1 AP115
placed in service during the first half AP125 AP126
of the month, it receives one full month AP131 AP20.1
of depreciation for its first month. In AP20.2 AP20.3
this case, it receives no depreciation AP20.4 AP20.5
for the month in which it is disposed AP20.7 AP21.1
of. If the asset is placed in service AP220 AP23.1
during the last half of the month, AP25.1 AP25.2
depreciation calculations begin the AP26.1 AP27.1
following month. In this case, the asset AP30.2 AP30.4
receives a full month during the month AP305 API1.1
in which it is disposed of. API2.1 BL120
BL122 BL130
Mid Month = The asset receives one-half BL20.1 BL20.3
of one month's depreciation for the BL21.2 BL21.5
month in which it is placed in service, BL29.1 BL29.2
and one-half of one month's depreciation BL520 BL820
for the month in which it is disposed BL92.1 MA180
of. MA41.1 MA41.2
MA41.4 MA41.7
Next Month = The asset receives one full ...
month of depreciation in the month after
it is placed in service and one full
month of depreciation in the month it is
disposed of.
Full Year = The asset receives a full
year's depreciation the year it is
placed in service and no depreciation
the year it is disposed of.
Half Year = The asset receives one half
of a year's depreciation for the first
year and the year it is disposed of.
Modified Half Year = If the asset is in
service before the middle of the year,
it receives a full year's depreciation
during its first year, and no
depreciation during the year it is
disposed of. If the asset is placed in
service after the midpoint of the year,
depreciation begins the following year,
and the asset receives a full year's
depreciation during the year it is
disposed of.
Mid Quarter = The asset receives
one-half of one quarter's depreciation
for the quarter in which it is placed in
service, and one-half of one quarter's
depreciation for the quarter in which it
is disposed of.
Actual Days = The asset receives
depreciation for each day it is in
service during the fiscal year,
beginning with the in-service date.
ABA-TO-CONVENTION Alpha 2 AC160 AM115
Element: To Convention This is the convention for depreciation AM117 AM125
calculation for the to-asset . Valid AM15.1 AM15.2
values are: AM15.3 AM15.4
AM19.1 AM19.2
Full Month = The asset receives a full AM20.1 AM20.2
month of depreciation during the month AM20.4 AM21.1
it is placed in service. The asset does AM21.2 AM21.4
not receive any depreciation for the AM500 AM502
month in which it is disposed of. AM551 AM92.1
AM98.1 AP115
Modified Half Month = If the asset is AP125 AP126
placed in service during the first half AP131 AP20.1
of the month, it receives one full month AP20.2 AP20.3
of depreciation for its first month. In AP20.4 AP20.5
this case, it receives no depreciation AP20.7 AP21.1
for the month in which it is disposed AP220 AP23.1
of. If the asset is placed in service AP25.1 AP25.2
during the last half of the month, AP26.1 AP27.1
depreciation calculations begin the AP30.2 AP30.4
following month. In this case, the asset AP305 API1.1
receives a full month during the month API2.1 BL120
in which it is disposed of. BL122 BL130
BL20.1 BL20.3
Mid Month = The asset receives one-half BL21.2 BL21.5
of one months depreciation for the month BL29.1 BL29.2
in which it is placed in service, and BL520 BL820
one-half of one month's depreciation for BL92.1 MA180
the month in which it is disposed of. MA41.1 MA41.2
MA41.4 MA41.7
Next Month = The asset receives one full ...
month of depreciation in the month after
it is placed in service and one full
month of depreciation in the month it is
disposed of.
Full Year = The asset receives a full
year's depreciation the year it is
placed in service and no depreciation
the year it is disposed of.
Half Year = The asset receives one half
of a year's depreciation for the first
year and the year it is disposed of.
Modified Half Year = If the asset is in
service before the middle of the year,
it receives a full year's depreciation
during its first year, and no
depreciation during the year it is
disposed of. If the asset is placed in
service after the midpoint of the year,
depreciation begins the following year,
and the asset receives a full year's
depreciation during the year it is
disposed of.
Mid Quarter = The asset receives
one-half of one quarter's depreciation
for the quarter in which it is placed in
service, and one-half of one quarter's
depreciation for the quarter in which it
is disposed of.
Actual Days = The asset receives
depreciation for each day it is in
service during the fiscal year,
beginning with the in-service date.
ABA-DEPR-STARTDATE Numeric 8 (yyyymmdd) AC160 AM115
Depreciation Start This is the date with which AM117 AM125
Date depreciation calculation begins. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-LIFE-YEARS Signed 5.2 AC160 AM115
Element: Life Years This is the asset life in years. AM117 AM125
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-LIFE-YEARS Signed 5.2 AC160 AM115
Element: To Life Years This is the to-asset life in years. AM117 AM125
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-STATUS-CP-CALC Alpha 1 AC160 AM115
Current Period Calc This field indicates whether AM117 AM125
Status depreciation has been calculated for the AM15.1 AM15.2
current period. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-LIFE-CP Signed 5.3 AC160 AM115
Element: Current PeriodThis field indicates the portion of the AM117 AM125
asset life for the current period. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TRAN-ND Numeric 1 AC160 AM115
Transaction Number The number of decimals assigned to a AM117 AM125
of Decimals particular account as determined by the AM15.1 AM15.2
account currency. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DEPR-CP Signed 18.2 AC160 AM115
Current Period This is the current period depreciation AM117 AM125
Depreciation amount for the book. This amount AM15.1 AM15.2
includes only the business use, not the AM15.3 AM15.4
personal use, portion of the AM19.1 AM19.2
depreciation. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DEPR-CP-ALLOW Signed 18.2 AC160 AM115
Current Period Depr This is the current period depreciation AM117 AM125
Allowed allowed for the book. This amount is AM15.1 AM15.2
equivalent to the full depreciation, AM15.3 AM15.4
including business and personal use. AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DEPR-YTD Signed 18.2 AC160 AM115
Year-to-Date This is the year-to-date depreciation AM117 AM125
Depreciation amount for the book. This amount AM15.1 AM15.2
includes only the business use, not the AM15.3 AM15.4
personal use, portion of the AM19.1 AM19.2
depreciation. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-DEPR-YTD Signed 18.2 AC160 AM115
To Year-to-Date This is the year-to-date depreciation AM117 AM125
Depreciation amount for the to-asset book. This AM15.1 AM15.2
amount includes only the business use, AM15.3 AM15.4
not the personal use, portion of the AM19.1 AM19.2
depreciation. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DEPR-YTD-ALLOW Signed 18.2 AC160 AM115
Year-to-Date Depr This is the year-to-date depreciation AM117 AM125
Allowed allowed for the book. This amount is AM15.1 AM15.2
equivalent to the full depreciation, AM15.3 AM15.4
including business and personal use. AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DEPR-YTD-OVRRD Signed 18.2 AC160 AM115
Year-to-Date Depr This is the depreciation year-to-date AM117 AM125
Override override amount. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-DP-YTD-OVRD Signed 18.2 AC160 AM115
To Year-to-Date This is the depreciation year-to-date AM117 AM125
Depr Override override amount for the transfer-to AM15.1 AM15.2
asset. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DEPR-LTD Signed 18.2 AC160 AM115
Life-to-Date This is the life-to-date depreciation AM117 AM125
Depreciation amount for the book. This amount AM15.1 AM15.2
includes only the business use, not the AM15.3 AM15.4
personal use, portion of the AM19.1 AM19.2
depreciation. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-DEPR-LTD Signed 18.2 AC160 AM115
To Life-to-Date This is the life-to-date depreciation AM117 AM125
Depreciation amount for the to-asset book. This AM15.1 AM15.2
amount includes only the business use, AM15.3 AM15.4
not the personal use, portion of the AM19.1 AM19.2
depreciation. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DEPR-LTD-ALLOW Signed 18.2 AC160 AM115
Life-to-Date Depr This is the life-to-date depreciation AM117 AM125
Allowed allowed for the book. This amount is AM15.1 AM15.2
equivalent to the full depreciation, AM15.3 AM15.4
including business and personal use. AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-LAST-CLOSE Signed 18.2 AC160 AM115
Element: Last Close This is the last closed balance for the AM117 AM125
asset book. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-FIRST-LAST-FL Alpha 1 AC160 AM115
Element: First or Last This field is an internal, AM117 AM125
system-maintained value used to control AM15.1 AM15.2
depreciation calculations during the AM15.3 AM15.4
first and last years of an asset's life. AM19.1 AM19.2
Valid values are: AM20.1 AM20.2
AM20.4 AM21.1
F = First. This is the first in-service AM21.2 AM21.4
year for the asset. AM500 AM502
AM551 AM92.1
M = Middle. The asset is in a year other AM98.1 AP115
than the first or last. AP125 AP126
AP131 AP20.1
L = Last. This is the last in-service AP20.2 AP20.3
year for the asset. AP20.4 AP20.5
AP20.7 AP21.1
C = Completely Depreciated. The asset no AP220 AP23.1
longer participates in depreciation AP25.1 AP25.2
calculations. AP26.1 AP27.1
AP30.2 AP30.4
P = Post Recovery. The system will AP305 API1.1
continue to depreciate the asset beyond API2.1 BL120
the original asset life. 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
...
ABA-INACT-CHG-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Date This field displays the system date AM117 AM125
when this was created. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-INACT-YTD Signed 5.3 AC160 AM115
Year-to-Date This is the number of inactive months AM117 AM125
Inactivity for the book year-to-date. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-INACT-LTD Signed 7.3 AC160 AM115
Life-to-Date This is the number of inactive months AM117 AM125
Inactivity for the book life-to-date. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-SALVAGE-VALUE Signed 18.2 AC160 AM115
Element: Salvage Value This is the book salvage value of the AM117 AM125
asset at the end of the asset's life. It AM15.1 AM15.2
can be zero. AM15.3 AM15.4
AM19.1 AM19.2
If the depreciation method is STL AM20.1 AM20.2
(Straight Line), the basis used for the AM20.4 AM21.1
depreciation calculation is the asset AM21.2 AM21.4
cost less this salvage value. AM500 AM502
AM551 AM92.1
If the depreciation method is DDB AM98.1 AP115
(Double Declining Balance), 125DB (125% AP125 AP126
Declining Balance), 150DB (150% AP131 AP20.1
Declining Balance), or 175DB (175% AP20.2 AP20.3
Declining Balance), the basis used for AP20.4 AP20.5
the depreciation calculation is the AP20.7 AP21.1
asset cost. Depreciation is taken until AP220 AP23.1
the total amount is equal to the asset AP25.1 AP25.2
cost less this salvage value. 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
...
ABA-TO-SALV-VALUE Signed 18.2 AC160 AM115
Element: To Salvage ValThis is the salvage value for the AM117 AM125
to-asset at the end of the asset's life. AM15.1 AM15.2
It can be zero. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-BUS-PERCENT Signed 5.2 AC160 AM115
Element: Business PerceThis is the business use percentage for AM117 AM125
the asset. If the percentage is less AM15.1 AM15.2
than 100%, this is the value to be used AM15.3 AM15.4
during depreciation calculations. If AM19.1 AM19.2
this field is left blank in the asset AM20.1 AM20.2
record, the system defaults 100%. AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-BUS-PERCENT Signed 5.2 AC160 AM115
Element: To Business PeThis is the business use percentage for AM117 AM125
the to-asset. If the percentage is less AM15.1 AM15.2
than 100%, this is the value to be used AM15.3 AM15.4
during depreciation calculations. If AM19.1 AM19.2
this field is left blank in the asset AM20.1 AM20.2
record, the system defaults 100%. AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-PERSONAL-USE Alpha 10 AC160 AM115
Element: Personal Use Personal use is a name for depreciation AM117 AM125
limits defined to account for the AM15.1 AM15.2
personal use of an asset. AM15.3 AM15.4
AM19.1 AM19.2
A personal use code defines the personal AM20.1 AM20.2
use options that asset books use to AM20.4 AM21.1
calculate depreciation, tax credits, and AM21.2 AM21.4
annual depreciation limits for up to 20 AM500 AM502
years. The code is user-definable. AM551 AM92.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
...
ABA-TO-PERSONL-USE Alpha 10 AC160 AM115
Element: To Personal UsThis is the personal use code for the AM117 AM125
to-asset. Personal use is a name for AM15.1 AM15.2
depreciation limits defined to account AM15.3 AM15.4
for the personal use of an asset. AM19.1 AM19.2
AM20.1 AM20.2
A personal use code defines the personal AM20.4 AM21.1
use options that asset books use to AM21.2 AM21.4
calculate depreciation, tax credits, and AM500 AM502
annual depreciation limits for up to 20 AM551 AM92.1
years. The code is user-definable. 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
...
ABA-YR1-EXP Signed 18.2 AC160 AM115
Element: First Year ExpThis is the new amount to expense for AM117 AM125
the First Year Expense option. This U.S. AM15.1 AM15.2
tax option allows you to expense and not AM15.3 AM15.4
depreciate a total dollar amount for the AM19.1 AM19.2
assets of each eligible company. AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-YR1-EXP Signed 18.2 AC160 AM115
To First Year This is the new first year expense AM117 AM125
Expense amount for the to-asset for the First AM15.1 AM15.2
Year Expense option. This U.S. tax AM15.3 AM15.4
option allows you to expense and not AM19.1 AM19.2
depreciate a total amount for the assets AM20.1 AM20.2
of each eligible company. AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TC-TABLE Alpha 10 AC160 AM115
Element: Tax Credit TabThis is a user-defined tax credit table AM117 AM125
for the asset that defines tax credit AM15.1 AM15.2
percentages and annual tax credit AM15.3 AM15.4
recapture percentages for up to twenty AM19.1 AM19.2
years. Asset books use tax credit tables AM20.1 AM20.2
to calculate tax credits. AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-TC-TABLE Alpha 10 AC160 AM115
Element: To Tax Credit This is a user-defined tax credit AM117 AM125
table for the to-asset that defines tax AM15.1 AM15.2
credit percentages and annual tax credit AM15.3 AM15.4
recapture percentages for up to twenty AM19.1 AM19.2
years. Asset books use tax credit tables AM20.1 AM20.2
to calculate tax credits. AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TC-PROPERTY Signed 18.2 AC160 AM115
Element: Tax Credit ProIf you are taking the tax credit for AM117 AM125
used property, this field contains the AM15.1 AM15.2
amount that qualifies for the tax AM15.3 AM15.4
credit. AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-TC-PROPERTY Signed 18.2 AC160 AM115
To Tax Credit If you are taking the tax credit for AM117 AM125
Property used property for the to-asset, this AM15.1 AM15.2
field contains the amount that qualifies AM15.3 AM15.4
for the tax credit. AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TAX-CREDIT Signed 18.2 AC160 AM115
Element: Tax Credit This is the amount of tax credit taken AM117 AM125
for the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-TAX-CREDIT Signed 18.2 AC160 AM115
Element: To Tax Credit This is the amount of tax credit taken AM117 AM125
for the to-asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-INS-METHOD Alpha 10 AC160 AM115
Element: Insurance MethThis is the method used to compute the AM117 AM125
insurance value of the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-INS-METHOD Alpha 10 AC160 AM115
Element: To Insurance MThis is the method used to compute the AM117 AM125
insurance value of the to-asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-INS-ACT-VAL Signed 18.2 AC160 AM115
Insurance Actual This is the actual insurance value of AM117 AM125
Value the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-INS-ACT-VAL Signed 18.2 AC160 AM115
To Insurance Actual This is the actual insurance value of AM117 AM125
Value the to-asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-INS-CMPTD-VAL Signed 18.2 AC160 AM115
Insurance Computed This is the insurance value as computed AM117 AM125
Value by the insurance method. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-INS-CMPTD Signed 18.2 AC160 AM115
To Insurance This is the insurance value for the AM117 AM125
Computed Value transfer-to asset, as computed by the AM15.1 AM15.2
insurance method. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-RPL-METHOD Alpha 10 AC160 AM115
Element: Replacement MeThis is the method to use in computing AM117 AM125
the replacement value for the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-RPL-METHOD Alpha 10 AC160 AM115
To Replacement This is the method to use in computing AM117 AM125
Method the replacement value for the AM15.1 AM15.2
transfer-to asset. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-RPL-CMPTD-VAL Signed 18.2 AC160 AM115
Replacement This is the replacement value for the AM117 AM125
Computed Value asset, computed by the replacement AM15.1 AM15.2
method. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-TO-RPL-CMPTD Signed 18.2 AC160 AM115
To Replacement This is the replacement value for the AM117 AM125
Computed Value to-asset, computed by the replacement AM15.1 AM15.2
method. AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-DSP-YTD Signed 5.3 AC160 AM115
Element: Dsp Ytd AM117 AM125
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.2
AM20.4 AM21.1
AM21.2 AM21.4
AM500 AM502
AM551 AM92.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
...
ABA-BOOK-CURRENCY Derived
Element: Book Currency This is the currency for the book.
ABA-AST-TAG-NBR Derived
Element: Tag Number This is the asset tag, a user-defined
identifier.
ABA-AST-ASSET-GRP Derived
Element: Asset Group This is the asset group to which the
asset belongs.
ABA-AST-DESCRIP Derived
Element: Asset DescriptThis is the asset description.
ABA-ADJ-CREAT-DATE Derived
Element: Creation Date This is the adjustment creation date.
ABA-ADJ-CREAT-TIME Derived
Element: Creation Time This is the time the adjustment was
created.
ABA-ADJ-CREATOR-ID Derived
Element: Creator ID This is the ID of the person who
created the adjustment.
AMASTBKADJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABASET1 ASSET AC160 AM115
PROCESS-SEQ AM117 AM125
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
AM225 AM30.1
...
ABASET2 ASSET AM225 AM310
BOOK AMDL.1
PROCESS-SEQ
AMASTBKADJ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
Valid When ABA-ASSET != Zeroes
ABA-ASSET -> AST-ASSET
Amassetadj AMASSETADJ Not Required
ABA-ASSET -> ASA-ASSET
ABA-PROCESS-SEQ -> ASA-PROCESS-SEQ
Amastbook AMASTBOOK Required
ABA-ASSET -> ASB-ASSET
ABA-BOOK -> ASB-BOOK
Ambook AMBOOK Not Required
ABA-BOOK -> AMB-BOOK
|