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
AM115 AM117 AM125 AM15.1 AM15.2 AM15.3
AM15.4 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 AM300 AM310 AM500 AM502
AM520 AM551 AM92.1 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABA-ASSET Numeric 10 AM115 AM117
Element: Asset Key field. The asset number contains up AM125 AM15.1
to ten numeric characters that uniquely AM15.2 AM15.3
identify an asset. Assets are AM15.4 AM20.1
automatically numbered system-wide. AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-BOOK Alpha 10 AM115 AM117
Element: Book Key field. A user-defined book name. AM125 AM15.1
Books are used by assets for calculating AM15.2 AM15.3
depreciation, replacement cost, and AM15.4 AM20.1
insurance values, and for reporting. AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM520
AM551 AM92.1
AM98.1
ABA-PROCESS-SEQ Numeric 6 AM115 AM117
Element: Process SequenKey field. This is the process sequence AM125 AM15.1
number for the asset book adjustment. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-ADJUST-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Adjustment DatThis is the effective date for the AM125 AM15.1
adjustment. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-COMPUTE Alpha 1 AM115 AM117
Element: Compute This option determines how an AM125 AM15.1
adjustment affects depreciation in the AM15.2 AM15.3
period of adjustment, in prior periods AM15.4 AM20.1
of the same year, and in future years. AM20.2 AM20.4
Valid values are: AM21.1 AM21.2
AM21.4 AM500
N = Any difference between the AM502 AM551
year-to-date depreciation taken and the AM92.1 AM98.1
annual amount that should be taken based
on the change is spread over the
remaining depreciation periods in the
current year.
Y = Any difference between the
year-to-date depreciation taken and the
amount that should be taken based on the
change is charged to the current
depreciation period.
P = The net asset value as of the
adjustment date is allocated over the
assets remaining life. No current period
adjustment is applicable and no annual
limits are applied to the current year
depreciation calculation.
ABA-BOOK-STATUS Alpha 1 AM115 AM117
Element: Book Status This field indicates the book status. AM125 AM15.1
Valid values are: AM15.2 AM15.3
A = Active AM15.4 AM20.1
I = Inactive AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-BOOK-STATUS Alpha 1 AM115 AM117
Element: To Book StatusThis is the book status for the AM125 AM15.1
transfer-to asset. Valid values are: AM15.2 AM15.3
A = Active AM15.4 AM20.1
I = Inactive AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-LIFE Numeric 4 AM115 AM117
Element: Life This is the asset life in months. AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-LIFE Numeric 4 AM115 AM117
Element: To Life This is the life in months for the AM125 AM15.1
transfer-to asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-LIFE-REM Signed 7.3 AM115 AM117
Element: Life RemainingThis is the asset life remaining in AM125 AM15.1
months. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-LIFE-REM Signed 7.3 AM115 AM117
Element: To Life RemainThis is the asset life remaining in AM125 AM15.1
months for the transfer-to asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-BOOK-BASIS Signed 18.2 AM115 AM117
Element: Book Basis This field contains the amount on which AM125 AM15.1
the depreciation calculations are based. AM15.2 AM15.3
AM15.4 AM20.1
Note: The depreciation basis amount can AM20.2 AM20.4
be different for each depreciation book. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-BOOK-BASIS Signed 18.2 AM115 AM117
Element: To Book Basis This field contains the amount on which AM125 AM15.1
depreciation calculations for the AM15.2 AM15.3
to-asset are based. AM15.4 AM20.1
AM20.2 AM20.4
Note: The depreciation basis amount can AM21.1 AM21.2
be different for each depreciation book. AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-METHOD Alpha 10 AM115 AM117
Element: Method This is the method. It can be a AM125 AM15.1
predefined or a user-defined method. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-METHOD Alpha 10 AM115 AM117
Element: To Method This is the method for the to-asset. It AM125 AM15.1
can be a predefined or a user-defined AM15.2 AM15.3
method. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-METH-SWITCHED Alpha 1 AM115 AM117
Element: Method SwitcheThis is the switch used to indicate AM125 AM15.1
when the Asset Management system has AM15.2 AM15.3
switched the depreciation method. It AM15.4 AM20.1
remains blank until the switch occurs. AM20.2 AM20.4
The system then fills in an asterisk AM21.1 AM21.2
("*"). AM21.4 AM500
AM502 AM551
Valid values are: AM92.1 AM98.1
# = (Blank); the switch is not in use.
* = (Asterisk); the depreciation method
has been switched to the optimizing
method.
ABA-TO-METH-SWITCH Alpha 1 AM115 AM117
Element: To Method SwitThis field indicates for the to-asset AM125 AM15.1
whether the Asset Management system has AM15.2 AM15.3
switched the depreciation method. It AM15.4 AM20.1
remains blank until the switch occurs; AM20.2 AM20.4
then the system fills in an asterisk in AM21.1 AM21.2
the field. AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-INSRV-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: In Service DatThe book in-service date for the asset. AM125 AM15.1
AM15.2 AM15.3
Note: The in-service date can be AM15.4 AM20.1
different for each depreciation book AM20.2 AM20.4
used. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-INSRV-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: To In Service The book in-service date for the AM125 AM15.1
to-asset. AM15.2 AM15.3
AM15.4 AM20.1
Note: The in-service date can be AM20.2 AM20.4
different for each depreciation book. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-METH-TABLE-YR Numeric 2 AM115 AM117
Element: Method Table YThis field indicates what year of its AM125 AM15.1
life the asset is in. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-METH-TBL-YR Numeric 2 AM115 AM117
Element: To Method TablThis field indicates what year of its AM125 AM15.1
the to-asset is in. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-CONVENTION Alpha 2 AM115 AM117
Element: Convention This is the convention for depreciation AM125 AM15.1
calculation. Valid values are: AM15.2 AM15.3
AM15.4 AM20.1
Full Month = The asset receives a full AM20.2 AM20.4
month of depreciation during the month AM21.1 AM21.2
it is placed in service. The asset does AM21.4 AM500
not receive any depreciation for the AM502 AM551
month in which it is disposed of. AM92.1 AM98.1
Modified Half Month = If the asset is
placed in service during the first half
of the month, it receives one full month
of depreciation for its first month. In
this case, it receives no depreciation
for the month in which it is disposed
of. If the asset is placed in service
during the last half of the month,
depreciation calculations begin the
following month. In this case, the asset
receives a full month during the month
in which it is disposed of.
Mid Month = The asset receives one-half
of one month's depreciation for the
month in which it is placed in service,
and one-half of one month's depreciation
for the month in which it is disposed
of.
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 AM115 AM117
Element: To Convention This is the convention for depreciation AM125 AM15.1
calculation for the to-asset . Valid AM15.2 AM15.3
values are: AM15.4 AM20.1
AM20.2 AM20.4
Full Month = The asset receives a full AM21.1 AM21.2
month of depreciation during the month AM21.4 AM500
it is placed in service. The asset does AM502 AM551
not receive any depreciation for the AM92.1 AM98.1
month in which it is disposed of.
Modified Half Month = If the asset is
placed in service during the first half
of the month, it receives one full month
of depreciation for its first month. In
this case, it receives no depreciation
for the month in which it is disposed
of. If the asset is placed in service
during the last half of the month,
depreciation calculations begin the
following month. In this case, the asset
receives a full month during the month
in which it is disposed of.
Mid Month = The asset receives one-half
of one months depreciation for the month
in which it is placed in service, and
one-half of one month's depreciation for
the month in which it is disposed of.
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) AM115 AM117
Depreciation Start This is the date with which AM125 AM15.1
Date depreciation calculation begins. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-LIFE-YEARS Signed 5.2 AM115 AM117
Element: Life Years This is the asset life in years. AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-LIFE-YEARS Signed 5.2 AM115 AM117
Element: To Life Years This is the to-asset life in years. AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-STATUS-CP-CALC Alpha 1 AM115 AM117
Current Period Calc This field indicates whether AM125 AM15.1
Status depreciation has been calculated for the AM15.2 AM15.3
current period. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-LIFE-CP Signed 5.3 AM115 AM117
Element: Current PeriodThis field indicates the portion of the AM125 AM15.1
asset life for the current period. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TRAN-ND Numeric 1 AM115 AM117
Transaction Number The number of decimal positions defined AM125 AM15.1
of Decimals for the transaction currency. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DEPR-CP Signed 18.2 AM115 AM117
Current Period This is the current period depreciation AM125 AM15.1
Depreciation amount for the book. This amount AM15.2 AM15.3
includes only the business use, not the AM15.4 AM20.1
personal use, portion of the AM20.2 AM20.4
depreciation. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DEPR-CP-ALLOW Signed 18.2 AM115 AM117
Current Period Depr This is the current period depreciation AM125 AM15.1
Allowed allowed for the book. This amount is AM15.2 AM15.3
equivalent to the full depreciation, AM15.4 AM20.1
including business and personal use. AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DEPR-YTD Signed 18.2 AM115 AM117
Year-to-Date This is the year-to-date depreciation AM125 AM15.1
Depreciation amount for the book. This amount AM15.2 AM15.3
includes only the business use, not the AM15.4 AM20.1
personal use, portion of the AM20.2 AM20.4
depreciation. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-DEPR-YTD Signed 18.2 AM115 AM117
To Year-to-Date This is the year-to-date depreciation AM125 AM15.1
Depreciation amount for the to-asset book. This AM15.2 AM15.3
amount includes only the business use, AM15.4 AM20.1
not the personal use, portion of the AM20.2 AM20.4
depreciation. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DEPR-YTD-ALLOW Signed 18.2 AM115 AM117
Year-to-Date Depr This is the year-to-date depreciation AM125 AM15.1
Allowed allowed for the book. This amount is AM15.2 AM15.3
equivalent to the full depreciation, AM15.4 AM20.1
including business and personal use. AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DEPR-YTD-OVRRD Signed 18.2 AM115 AM117
Year-to-Date Depr This is the depreciation year-to-date AM125 AM15.1
Override override amount. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-DP-YTD-OVRD Signed 18.2 AM115 AM117
To Year-to-Date This is the depreciation year-to-date AM125 AM15.1
Depr Override override amount for the transfer-to AM15.2 AM15.3
asset. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DEPR-LTD Signed 18.2 AM115 AM117
Life-to-Date This is the life-to-date depreciation AM125 AM15.1
Depreciation amount for the book. This amount AM15.2 AM15.3
includes only the business use, not the AM15.4 AM20.1
personal use, portion of the AM20.2 AM20.4
depreciation. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-DEPR-LTD Signed 18.2 AM115 AM117
To Life-to-Date This is the life-to-date depreciation AM125 AM15.1
Depreciation amount for the to-asset book. This AM15.2 AM15.3
amount includes only the business use, AM15.4 AM20.1
not the personal use, portion of the AM20.2 AM20.4
depreciation. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DEPR-LTD-ALLOW Signed 18.2 AM115 AM117
Life-to-Date Depr This is the life-to-date depreciation AM125 AM15.1
Allowed allowed for the book. This amount is AM15.2 AM15.3
equivalent to the full depreciation, AM15.4 AM20.1
including business and personal use. AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-LAST-CLOSE Signed 18.2 AM115 AM117
Element: Last Close This is the last closed balance for the AM125 AM15.1
asset book. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-FIRST-LAST-FL Alpha 1 AM115 AM117
Element: First or Last This field is an internal, AM125 AM15.1
system-maintained value used to control AM15.2 AM15.3
depreciation calculations during the AM15.4 AM20.1
first and last years of an asset's life. AM20.2 AM20.4
Valid values are: AM21.1 AM21.2
AM21.4 AM500
F = First. This is the first in-service AM502 AM551
year for the asset. AM92.1 AM98.1
M = Middle. The asset is in a year other
than the first or last.
L = Last. This is the last in-service
year for the asset.
C = Completely Depreciated. The asset no
longer participates in depreciation
calculations.
P = Post Recovery. The system will
continue to depreciate the asset beyond
the original asset life.
ABA-INACT-CHG-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Date AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-INACT-YTD Signed 5.3 AM115 AM117
Year-to-Date This is the number of inactive months AM125 AM15.1
Inactivity for the book year-to-date. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-INACT-LTD Signed 7.3 AM115 AM117
Life-to-Date This is the number of inactive months AM125 AM15.1
Inactivity for the book life-to-date. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-SALVAGE-VALUE Signed 18.2 AM115 AM117
Element: Salvage Value This is the book salvage value of the AM125 AM15.1
asset at the end of the asset's life. It AM15.2 AM15.3
can be zero. AM15.4 AM20.1
AM20.2 AM20.4
If the depreciation method is STL AM21.1 AM21.2
(Straight Line), the basis used for the AM21.4 AM500
depreciation calculation is the asset AM502 AM551
cost less this salvage value. AM92.1 AM98.1
If the depreciation method is DDB
(Double Declining Balance), 125DB (125%
Declining Balance), 150DB (150%
Declining Balance), or 175DB (175%
Declining Balance), the basis used for
the depreciation calculation is the
asset cost. Depreciation is taken until
the total amount is equal to the asset
cost less this salvage value.
ABA-TO-SALV-VALUE Signed 18.2 AM115 AM117
Element: To Salvage ValThis is the salvage value for the AM125 AM15.1
to-asset at the end of the asset's life. AM15.2 AM15.3
It can be zero. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-BUS-PERCENT Signed 5.2 AM115 AM117
Element: Business PerceThis is the business use percentage for AM125 AM15.1
the asset. If the percentage is less AM15.2 AM15.3
than 100%, this is the value to be used AM15.4 AM20.1
during depreciation calculations. If AM20.2 AM20.4
this field is left blank in the asset AM21.1 AM21.2
record, the system defaults 100%. AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-BUS-PERCENT Signed 5.2 AM115 AM117
Element: To Business PeThis is the business use percentage for AM125 AM15.1
the to-asset. If the percentage is less AM15.2 AM15.3
than 100%, this is the value to be used AM15.4 AM20.1
during depreciation calculations. If AM20.2 AM20.4
this field is left blank in the asset AM21.1 AM21.2
record, the system defaults 100%. AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-PERSONAL-USE Alpha 10 AM115 AM117
Element: Personal Use Personal use is a name for depreciation AM125 AM15.1
limits defined to account for the AM15.2 AM15.3
personal use of an asset. AM15.4 AM20.1
AM20.2 AM20.4
A personal use code defines the personal AM21.1 AM21.2
use options that asset books use to AM21.4 AM500
calculate depreciation, tax credits, and AM502 AM551
annual depreciation limits for up to 20 AM92.1 AM98.1
years. The code is user-definable.
ABA-TO-PERSONL-USE Alpha 10 AM115 AM117
Element: To Personal UsThis is the personal use code for the AM125 AM15.1
to-asset. Personal use is a name for AM15.2 AM15.3
depreciation limits defined to account AM15.4 AM20.1
for the personal use of an asset. AM20.2 AM20.4
AM21.1 AM21.2
A personal use code defines the personal AM21.4 AM500
use options that asset books use to AM502 AM551
calculate depreciation, tax credits, and AM92.1 AM98.1
annual depreciation limits for up to 20
years. The code is user-definable.
ABA-YR1-EXP Signed 18.2 AM115 AM117
Element: First Year ExpThis is the new amount to expense for AM125 AM15.1
the First Year Expense option. This U.S. AM15.2 AM15.3
tax option allows you to expense and not AM15.4 AM20.1
depreciate a total dollar amount for the AM20.2 AM20.4
assets of each eligible company. AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-YR1-EXP Signed 18.2 AM115 AM117
To First Year This is the new first year expense AM125 AM15.1
Expense amount for the to-asset for the First AM15.2 AM15.3
Year Expense option. This U.S. tax AM15.4 AM20.1
option allows you to expense and not AM20.2 AM20.4
depreciate a total amount for the assets AM21.1 AM21.2
of each eligible company. AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TC-TABLE Alpha 10 AM115 AM117
Element: Tax Credit TabThis is a user-defined tax credit table AM125 AM15.1
for the asset that defines tax credit AM15.2 AM15.3
percentages and annual tax credit AM15.4 AM20.1
recapture percentages for up to twenty AM20.2 AM20.4
years. Asset books use tax credit tables AM21.1 AM21.2
to calculate tax credits. AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-TC-TABLE Alpha 10 AM115 AM117
Element: To Tax Credit This is a user-defined tax credit AM125 AM15.1
table for the to-asset that defines tax AM15.2 AM15.3
credit percentages and annual tax credit AM15.4 AM20.1
recapture percentages for up to twenty AM20.2 AM20.4
years. Asset books use tax credit tables AM21.1 AM21.2
to calculate tax credits. AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TC-PROPERTY Signed 18.2 AM115 AM117
Element: Tax Credit ProIf you are taking the tax credit for AM125 AM15.1
used property, this field contains the AM15.2 AM15.3
amount that qualifies for the tax AM15.4 AM20.1
credit. AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-TC-PROPERTY Signed 18.2 AM115 AM117
To Tax Credit If you are taking the tax credit for AM125 AM15.1
Property used property for the to-asset, this AM15.2 AM15.3
field contains the amount that qualifies AM15.4 AM20.1
for the tax credit. AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TAX-CREDIT Signed 18.2 AM115 AM117
Element: Tax Credit This is the amount of tax credit taken AM125 AM15.1
for the asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-TAX-CREDIT Signed 18.2 AM115 AM117
Element: To Tax Credit This is the amount of tax credit taken AM125 AM15.1
for the to-asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-INS-METHOD Alpha 10 AM115 AM117
Element: Insurance MethThis is the method used to compute the AM125 AM15.1
insurance value of the asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-INS-METHOD Alpha 10 AM115 AM117
Element: To Insurance MThis is the method used to compute the AM125 AM15.1
insurance value of the to-asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-INS-ACT-VAL Signed 18.2 AM115 AM117
Insurance Actual This is the actual insurance value of AM125 AM15.1
Value the asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-INS-ACT-VAL Signed 18.2 AM115 AM117
To Insurance Actual This is the actual insurance value of AM125 AM15.1
Value the to-asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-INS-CMPTD-VAL Signed 18.2 AM115 AM117
Insurance Computed This is the insurance value as computed AM125 AM15.1
Value by the insurance method. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-INS-CMPTD Signed 18.2 AM115 AM117
To Insurance This is the insurance value for the AM125 AM15.1
Computed Value transfer-to asset, as computed by the AM15.2 AM15.3
insurance method. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-RPL-METHOD Alpha 10 AM115 AM117
Element: Replacement MeThis is the method to use in computing AM125 AM15.1
the replacement value for the asset. AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-RPL-METHOD Alpha 10 AM115 AM117
To Replacement This is the method to use in computing AM125 AM15.1
Method the replacement value for the AM15.2 AM15.3
transfer-to asset. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-RPL-CMPTD-VAL Signed 18.2 AM115 AM117
Replacement This is the replacement value for the AM125 AM15.1
Computed Value asset, computed by the replacement AM15.2 AM15.3
method. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-TO-RPL-CMPTD Signed 18.2 AM115 AM117
To Replacement This is the replacement value for the AM125 AM15.1
Computed Value to-asset, computed by the replacement AM15.2 AM15.3
method. AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
ABA-DSP-YTD Signed 5.3 AM115 AM117
Element: Dsp Ytd AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.2 AM20.4
AM21.1 AM21.2
AM21.4 AM500
AM502 AM551
AM92.1 AM98.1
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 AM115 AM117
PROCESS-SEQ AM125 AM135
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 AM225
AM30.1 AM30.2
AM30.3 AM300
...
ABASET2 ASSET AM310 AMDL.1
BOOK
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
|