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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
ABA-ASSET
Element: Asset | Numeric 10
Key field. The asset number contains up
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
|
|
ABA-BOOK
Element: Book | Alpha 10
Key field. A user-defined book name.
Books are used by assets for calculating
depreciation, replacement cost, and
insurance values, and for reporting.
|
|
ABA-PROCESS-SEQ
Element: Process Sequence | Numeric 6
Key field. This is the process sequence
number for the asset book adjustment.
|
|
ABA-ADJUST-DATE
Element: Adjustment Date | Numeric 8 (yyyymmdd)
This is the effective date for the
adjustment.
|
|
ABA-COMPUTE
Element: Compute | Alpha 1
This option determines how an
adjustment affects depreciation in the
period of adjustment, in prior periods
of the same year, and in future years.
Valid values are:
N = Any difference between the
year-to-date depreciation taken and the
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
Element: Book Status | Alpha 1
This field indicates the book status.
Valid values are:
A = Active
I = Inactive
|
|
ABA-TO-BOOK-STATUS
Element: To Book Status | Alpha 1
This is the book status for the
transfer-to asset. Valid values are:
A = Active
I = Inactive
|
|
ABA-LIFE
Element: Life | Numeric 4
This is the asset life in months.
|
|
ABA-TO-LIFE
Element: To Life | Numeric 4
This is the life in months for the
transfer-to asset.
|
|
ABA-LIFE-REM
Element: Life Remaining | Signed 7.3
This is the asset life remaining in
months.
|
|
ABA-TO-LIFE-REM
Element: To Life Remaining | Signed 7.3
This is the asset life remaining in
months for the transfer-to asset.
|
|
ABA-BOOK-BASIS
Element: Book Basis | Signed 18.2
This field contains the amount on which
the depreciation calculations are based.
Note: The depreciation basis amount can
be different for each depreciation book.
|
|
ABA-TO-BOOK-BASIS
Element: To Book Basis | Signed 18.2
This field contains the amount on which
depreciation calculations for the
to-asset are based.
Note: The depreciation basis amount can
be different for each depreciation book.
|
|
ABA-METHOD
Element: Method | Alpha 10
This is the method. It can be a
predefined or a user-defined method.
|
|
ABA-TO-METHOD
Element: To Method | Alpha 10
This is the method for the to-asset. It
can be a predefined or a user-defined
method.
|
|
ABA-METH-SWITCHED
Element: Method Switched | Alpha 1
This is the switch used to indicate
when the Asset Management system has
switched the depreciation method. It
remains blank until the switch occurs.
The system then fills in an asterisk
("*").
Valid values are:
# = (Blank); the switch is not in use.
* = (Asterisk); the depreciation method
has been switched to the optimizing
method.
|
|
ABA-TO-METH-SWITCH
Element: To Method Switch | Alpha 1
This field indicates for the to-asset
whether the Asset Management system has
switched the depreciation method. It
remains blank until the switch occurs;
then the system fills in an asterisk in
the field.
|
|
ABA-INSRV-DATE
Element: In Service Date | Numeric 8 (yyyymmdd)
The book in-service date for the asset.
Note: The in-service date can be
different for each depreciation book
used.
|
|
ABA-TO-INSRV-DATE
Element: To In Service Date | Numeric 8 (yyyymmdd)
The book in-service date for the
to-asset.
Note: The in-service date can be
different for each depreciation book.
|
|
ABA-METH-TABLE-YR
Element: Method Table Year | Numeric 2
This field indicates what year of its
life the asset is in.
|
|
ABA-TO-METH-TBL-YR
Element: To Method Table Year | Numeric 2
This field indicates what year of its
the to-asset is in.
|
|
ABA-CONVENTION
Element: Convention | Alpha 2
This is the convention for depreciation
calculation. Valid values are:
Full Month = The asset receives a full
month of depreciation during the month
it is placed in service. The asset does
not receive any depreciation for the
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 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
Element: To Convention | Alpha 2
This is the convention for depreciation
calculation for the to-asset . Valid
values are:
Full Month = The asset receives a full
month of depreciation during the month
it is placed in service. The asset does
not receive any depreciation for the
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
Depreciation Start
Date | Numeric 8 (yyyymmdd)
This is the date with which
depreciation calculation begins.
|
|
ABA-LIFE-YEARS
Element: Life Years | Signed 5.2
This is the asset life in years.
|
|
ABA-TO-LIFE-YEARS
Element: To Life Years | Signed 5.2
This is the to-asset life in years.
|
|
ABA-STATUS-CP-CALC
Current Period Calc
Status | Alpha 1
This field indicates whether
depreciation has been calculated for the
current period.
|
|
ABA-LIFE-CP
Element: Current Period Life | Signed 5.3
This field indicates the portion of the
asset life for the current period.
|
|
ABA-TRAN-ND
Transaction Number
of Decimals | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
ABA-DEPR-CP
Current Period
Depreciation | Signed 18.2
This is the current period depreciation
amount for the book. This amount
includes only the business use, not the
personal use, portion of the
depreciation.
|
|
ABA-DEPR-CP-ALLOW
Current Period Depr
Allowed | Signed 18.2
This is the current period depreciation
allowed for the book. This amount is
equivalent to the full depreciation,
including business and personal use.
|
|
ABA-DEPR-YTD
Year-to-Date
Depreciation | Signed 18.2
This is the year-to-date depreciation
amount for the book. This amount
includes only the business use, not the
personal use, portion of the
depreciation.
|
|
ABA-TO-DEPR-YTD
To Year-to-Date
Depreciation | Signed 18.2
This is the year-to-date depreciation
amount for the to-asset book. This
amount includes only the business use,
not the personal use, portion of the
depreciation.
|
|
ABA-DEPR-YTD-ALLOW
Year-to-Date Depr
Allowed | Signed 18.2
This is the year-to-date depreciation
allowed for the book. This amount is
equivalent to the full depreciation,
including business and personal use.
|
|
ABA-DEPR-YTD-OVRRD
Year-to-Date Depr
Override | Signed 18.2
This is the depreciation year-to-date
override amount.
|
|
ABA-TO-DP-YTD-OVRD
To Year-to-Date
Depr Override | Signed 18.2
This is the depreciation year-to-date
override amount for the transfer-to
asset.
|
|
ABA-DEPR-LTD
Life-to-Date
Depreciation | Signed 18.2
This is the life-to-date depreciation
amount for the book. This amount
includes only the business use, not the
personal use, portion of the
depreciation.
|
|
ABA-TO-DEPR-LTD
To Life-to-Date
Depreciation | Signed 18.2
This is the life-to-date depreciation
amount for the to-asset book. This
amount includes only the business use,
not the personal use, portion of the
depreciation.
|
|
ABA-DEPR-LTD-ALLOW
Life-to-Date Depr
Allowed | Signed 18.2
This is the life-to-date depreciation
allowed for the book. This amount is
equivalent to the full depreciation,
including business and personal use.
|
|
ABA-LAST-CLOSE
Element: Last Close | Signed 18.2
This is the last closed balance for the
asset book.
|
|
ABA-FIRST-LAST-FL
Element: First or Last Flag | Alpha 1
This field is an internal,
system-maintained value used to control
depreciation calculations during the
first and last years of an asset's life.
Valid values are:
F = First. This is the first in-service
year for the asset.
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
Element: Date | Numeric 8 (yyyymmdd)
This field displays the system date
when this was created.
|
|
ABA-INACT-YTD
Year-to-Date
Inactivity | Signed 5.3
This is the number of inactive months
for the book year-to-date.
|
|
ABA-INACT-LTD
Life-to-Date
Inactivity | Signed 7.3
This is the number of inactive months
for the book life-to-date.
|
|
ABA-SALVAGE-VALUE
Element: Salvage Value | Signed 18.2
This is the book salvage value of the
asset at the end of the asset's life. It
can be zero.
If the depreciation method is STL
(Straight Line), the basis used for the
depreciation calculation is the asset
cost less this salvage value.
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
Element: To Salvage Value | Signed 18.2
This is the salvage value for the
to-asset at the end of the asset's life.
It can be zero.
|
|
ABA-BUS-PERCENT
Element: Business Percent | Signed 5.2
This is the business use percentage for
the asset. If the percentage is less
than 100%, this is the value to be used
during depreciation calculations. If
this field is left blank in the asset
record, the system defaults 100%.
|
|
ABA-TO-BUS-PERCENT
Element: To Business Percent | Signed 5.2
This is the business use percentage for
the to-asset. If the percentage is less
than 100%, this is the value to be used
during depreciation calculations. If
this field is left blank in the asset
record, the system defaults 100%.
|
|
ABA-PERSONAL-USE
Element: Personal Use | Alpha 10
Personal use is a name for depreciation
limits defined to account for the
personal use of an asset.
A personal use code defines the personal
use options that asset books use to
calculate depreciation, tax credits, and
annual depreciation limits for up to 20
years. The code is user-definable.
|
|
ABA-TO-PERSONL-USE
Element: To Personal Use | Alpha 10
This is the personal use code for the
to-asset. Personal use is a name for
depreciation limits defined to account
for the personal use of an asset.
A personal use code defines the personal
use options that asset books use to
calculate depreciation, tax credits, and
annual depreciation limits for up to 20
years. The code is user-definable.
|
|
ABA-YR1-EXP
Element: First Year Expense | Signed 18.2
This is the new amount to expense for
the First Year Expense option. This U.S.
tax option allows you to expense and not
depreciate a total dollar amount for the
assets of each eligible company.
|
|
ABA-TO-YR1-EXP
To First Year
Expense | Signed 18.2
This is the new first year expense
amount for the to-asset for the First
Year Expense option. This U.S. tax
option allows you to expense and not
depreciate a total amount for the assets
of each eligible company.
|
|
ABA-TC-TABLE
Element: Tax Credit Table | Alpha 10
This is a user-defined tax credit table
for the asset that defines tax credit
percentages and annual tax credit
recapture percentages for up to twenty
years. Asset books use tax credit tables
to calculate tax credits.
|
|
ABA-TO-TC-TABLE
Element: To Tax Credit Table | Alpha 10
This is a user-defined tax credit
table for the to-asset that defines tax
credit percentages and annual tax credit
recapture percentages for up to twenty
years. Asset books use tax credit tables
to calculate tax credits.
|
|
ABA-TC-PROPERTY
Element: Tax Credit Property | Signed 18.2
If you are taking the tax credit for
used property, this field contains the
amount that qualifies for the tax
credit.
|
|
ABA-TO-TC-PROPERTY
To Tax Credit
Property | Signed 18.2
If you are taking the tax credit for
used property for the to-asset, this
field contains the amount that qualifies
for the tax credit.
|
|
ABA-TAX-CREDIT
Element: Tax Credit | Signed 18.2
This is the amount of tax credit taken
for the asset.
|
|
ABA-TO-TAX-CREDIT
Element: To Tax Credit | Signed 18.2
This is the amount of tax credit taken
for the to-asset.
|
|
ABA-INS-METHOD
Element: Insurance Method | Alpha 10
This is the method used to compute the
insurance value of the asset.
|
|
ABA-TO-INS-METHOD
Element: To Insurance Method | Alpha 10
This is the method used to compute the
insurance value of the to-asset.
|
|
ABA-INS-ACT-VAL
Insurance Actual
Value | Signed 18.2
This is the actual insurance value of
the asset.
|
|
ABA-TO-INS-ACT-VAL
To Insurance Actual
Value | Signed 18.2
This is the actual insurance value of
the to-asset.
|
|
ABA-INS-CMPTD-VAL
Insurance Computed
Value | Signed 18.2
This is the insurance value as computed
by the insurance method.
|
|
ABA-TO-INS-CMPTD
To Insurance
Computed Value | Signed 18.2
This is the insurance value for the
transfer-to asset, as computed by the
insurance method.
|
|
ABA-RPL-METHOD
Element: Replacement Method | Alpha 10
This is the method to use in computing
the replacement value for the asset.
|
|
ABA-TO-RPL-METHOD
To Replacement
Method | Alpha 10
This is the method to use in computing
the replacement value for the
transfer-to asset.
|
|
ABA-RPL-CMPTD-VAL
Replacement
Computed Value | Signed 18.2
This is the replacement value for the
asset, computed by the replacement
method.
|
|
ABA-TO-RPL-CMPTD
To Replacement
Computed Value | Signed 18.2
This is the replacement value for the
to-asset, computed by the replacement
method.
|
|
ABA-DSP-YTD
Element: Dsp Ytd | Signed 5.3
|
|
ABA-BOOK-CURRENCY
Element: Book Currency | Derived
This is the currency for the book.
|
|
ABA-AST-TAG-NBR
Element: Tag Number | Derived
This is the asset tag, a user-defined
identifier.
|
|
ABA-AST-ASSET-GRP
Element: Asset Group | Derived
This is the asset group to which the
asset belongs.
|
|
ABA-AST-DESCRIP
Element: Asset Description | Derived
This is the asset description.
|
|
ABA-ADJ-CREAT-DATE
Element: Creation Date | Derived
This is the adjustment creation date.
|
|
ABA-ADJ-CREAT-TIME
Element: Creation Time | Derived
This is the time the adjustment was
created.
|
|
ABA-ADJ-CREATOR-ID
Element: Creator ID | Derived
This is the ID of the person who
created the adjustment.
|
|
