The Asset Book file stores the asset book records used to depreciate assets.
Each asset book record describes the depreciation parameters needed to
depreciate an asset, based on a specific depreciation book assigned to the
asset.
Each Asset file record may have one or more related records in the Asset Book
file, one for each book assigned to the asset.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
ASB-ASSET
Element: Asset | Numeric 10
The asset number associated with the
asset book record.
The asset number contains up to ten
numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
|
|
ASB-BOOK
Element: Book | Alpha 10
A book name assigned to the asset.
Books are user-defined and are used by
assets for calculating depreciation,
replacement cost, and insurance values,
and for reporting.
|
|
ASB-BOOK-STATUS
Element: Book Status | Alpha 1
This field identifies the status of the
book. Valid values are:
A = Active
I = Inactive
|
|
ASB-LIFE
Element: Life | Numeric 4
The life value of the asset, expressed
in months.
Note: The asset life can be different
for each depreciation book used.
|
|
ASB-LIFE-REM
Element: Life Remaining | Signed 7.3
The asset life remaining, expressed in
months. This value represents the number
of months the Asset Management system
will continue to depreciate the asset.
|
|
ASB-BOOK-BASIS
Element: Book Basis | Signed 18.2
The amount on which the depreciation
calculations are based.
Note: The depreciation basis amount
can be different for each depreciation
book used.
|
|
ASB-METHOD
Element: Method | Alpha 10
The method the book uses to calculate
depreciation for the asset. Standard
depreciation methods are predefined.
Additional methods can be user defined
for the following kinds of methods:
compute statements, annual percent
tables, and annual and period units of
production tables. Valid predefined
values are:
SL = Straight Line.
200DB = 200 percent declining balance.
175DB = 175 percent declining balance.
150DB = 150 percent declining balance.
125DB = 125 percent declining balance.
SYD = Sum of the year's digits.
|
|
ASB-METH-SWITCHED
Element: Method Switched | Alpha 1
This field indicates whether the Asset
Management system has switched the
depreciation method to the optimizing
method. Valid values are:
N = No.
Y = Yes.
|
|
ASB-INSRV-DATE
Element: In Service Date | Numeric 8 (yyyymmdd)
The date the asset was placed in
service.
Note: The in-service date can be
different for each depreciation book
used.
|
|
ASB-METH-TABLE-YR
Element: Method Table Year | Numeric 2
The year the asset was placed in
service.
|
|
ASB-CONVENTION
Element: Convention | Alpha 2
The depreciation convention assigned to
the book. This value is used to
determine the first and last years'
depreciation amounts to take. Valid
values are:
FM = Full Month.
HM = Modified Half Month.
MM = Mid Month.
NM = Next Month.
HY = Half Year.
MY = Modified Half Year.
FY = Full Year.
AD = Actual Days.
MQ = Mid Quarter.
Note: See data file text for the Method
file for more information on each
convention.
|
|
ASB-DEPR-STARTDATE
Depreciation Start
Date | Numeric 8 (yyyymmdd)
The date depreciation calculations
began or will begin for the asset.
|
|
ASB-LIFE-YEARS
Element: Life Years | Signed 5.2
The total life value of the asset,
expressed in years. This value is
calculated by dividing the Life value by
12.
|
|
ASB-STATUS-CP-CALC
Calc Status Current
Period | Alpha 1
This field indicates whether
depreciation has been calculated for the
current period.
|
|
ASB-LIFE-CP
Element: Current Period Life | Signed 5.3
This is the current period portion of
the asset life.
|
|
ASB-TRAN-ND
Transaction Number
of Decimals | Numeric 1
The number of decimal positions defined
for the transaction currency.
|
|
ASB-DEPR-CP
Current Period
Depreciation | Signed 18.2
This is the current period depreciation
for this book. This amount includes only
the business use, not the personal use,
portion of the depreciation
|
|
ASB-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.
|
|
ASB-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.
|
|
ASB-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.
|
|
ASB-DEPR-YTD-OVRRD
Year-to-Date Depr
Override | Signed 18.2
This is the year-to-date depreciation
override amount.
|
|
ASB-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.
|
|
ASB-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.
|
|
ASB-LAST-CLOSE
Element: Last Close | Signed 18.2
This is the balance in the last-closed
period for this book.
|
|
ASB-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.
|
|
ASB-INACT-YTD
Inactive
Year-to-Date | Signed 5.3
This is the number of inactive months
for the book year-to-date.
|
|
ASB-INACT-LTD
Inactive
Life-to-Date | Signed 7.3
This is the number of inactive months
for the book life-to-date.
|
|
ASB-SALVAGE-VALUE
Element: Salvage Value | Signed 18.2
The 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), 150 (150%
Declining Balance), or 175 (175%
Declining Balance), the basis used for
the depreciation calculation is the
asset cost. Depreciation will be taken
until the total amount taken is equal to
the asset cost less this salvage value.
|
|
ASB-BUS-PERCENT
Element: Business Percent | Signed 5.2
The business percent usage of the
asset. If this value is less than 100
percent, the value is used in
depreciation calculations.
|
|
ASB-PERSONAL-USE
Element: Personal Use | Alpha 10
The personal use code assigned to the
asset. A personal use code defines the
personal use options that asset books
use to calculate depreciation, tax
credits, and annual depreciation limits
up to twenty years. The code is user
definable.
|
|
ASB-YR1-EXP
Element: First Year Expense | Signed 18.2
This is the new first year expense
amount. It represents the 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.
|
|
ASB-TC-TABLE
Element: Tax Credit Table | Alpha 10
A user-defined tax credit table, which
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.
|
|
ASB-TC-PROPERTY
Element: Tax Credit Property | Signed 18.2
If you are taking a tax credit for used
property, this field contains the amount
that qualifies for the credit.
|
|
ASB-TAX-CREDIT
Element: Tax Credit | Signed 18.2
This is the amount of tax credit taken
for this asset.
|
|
ASB-INS-METHOD
Element: Insurance Method | Alpha 10
The method used to calculate insurance
values for the asset.
|
|
ASB-INS-ACT-VAL
Insurance Actual
Value | Signed 18.2
The actual insurance value of the
asset.
|
|
ASB-INS-CMPTD-VAL
Insurance Computed
Value | Signed 18.2
The calculated insurance value for the
asset.
|
|
ASB-RPL-METHOD
Element: Replacement Method | Alpha 10
The method used to calculate
replacement values for the asset.
|
|
ASB-RPL-CMPTD-VAL
Replacement
Computed Value | Signed 18.2
The calculated replacement value for
the asset.
|
|
ASB-CREATION-DATE
Element: Creation Date | Numeric 8 (yyyymmdd)
The date the asset book record was
created.
|
|
ASB-CREATION-TIME
Element: Creation Time | Numeric 6 (hhmmss)
The time the asset book record was
created.
|
|
ASB-CREATOR-ID
Element: Creator ID | Alpha 10
This field identifies the operator who
created the asset book record.
|
|
ASB-BOOK-DESC
Element: Book Description | Derived
The book description.
|
|
ASB-BOOK-VALUE
Element: Book Value | Derived
The book value is calculated as
follows: Book Basis - Life-to-date
Depreciation.
|
|
ASB-SALVAGE-PCT
Element: Salvage Percentage | Derived
Salvage percentage is calculated as
follows: Salvage Value / Book Basis.
|
|
ASB-BK-YR-END-DATE
Element: Book Year-End Date | Derived
The last date of the fiscal year.
|
|
ASB-BK-YR-BEG-DATE
Element: Book Year-Begin Date | Derived
The first date of the fiscal year.
|
|
ASB-BK-PD-PER-YR
Book Periods Per
Year | Derived
The number of periods defined for the
fiscal year.
|
|
ASB-BK-DEPR-PD-CLS
Book Depreciation
Period Close | Derived
This field identifies the number of
depreciation periods that are closed in
the fiscal year.
|
|
ASB-BK-PD-CLOSE-DT
Book Period Close
Date | Derived
The last date of the current period.
|
|
ASB-BK-PD-CURR-DT
Book Current Period
Close Date | Derived
This field identifies the closing date
of the current period.
|
|
ASB-BK-REQ
Element: Book Required | Derived
This field indicates whether the book
is a required book to be used by all new
assets being added.
|
|
ASB-BK-POSTING
Element: Posting Book | Derived
This field identifies whether the book
is a posting book that posts journal
entries to the general ledger.
|
|
ASB-BK-BOOK-STATUS
Element: Book Status | Derived
The status of the book.
|
|
ASB-BK-CURRENCY-CD
Element: Currency Code | Derived
The currency code assigned to the book.
|
|
ASB-BK-METH-SWITCH
Element: Method Switch | Derived
This field identifies whether the
depreciation method can be switched for
the book.
|
|
ASB-BK-DEPR-TYPE
Element: Bk Depr Type | Derived
This field allows for a drill-around to
AMBOOK to diplay the values in the
DEPR-TYPE-FLAG (Asset or Class).
|
|
ASB-BK-HISTORY
Element: Bk History | Derived
|
|
ASB-TAG
Element: Tag | Derived
The tag number assigned to the asset.
|
|
ASB-ASSET-GRP
Element: Asset Group | Derived
The asset group assigned to the asset.
|
|
ASB-DEPR-YTD-OVER
Year-to-Date Deprec
Override | Derived
The word "OVERRIDE" displays if there
is a year-to-date depreciation override
amount.
|
|
ASB-AST-DESC
Element: Asset Description | Derived
This is the asset description.
|
|
ASB-AST-STATUS
Element: Asset Status | Derived
This is the asset status.
|
|
ASB-AST-LOCATION
Element: Ast Location | Derived
|
|
ASB-AST-DIVISION
Element: Ast Division | Derived
|
|
ASB-AST-TYPE
Element: Ast Type | Derived
|
|
ASB-AST-SUBTYPE
Element: Ast Subtype | Derived
|
|
ASB-DSP-YTD
Element: Dsp Ytd | Signed 5.3
This is the number of months that the
asset has been disposed in the current
year. This field gets cleared when the
year rolls over.
|
|
ASB-RVL-LTD
Element: Intl Amt | Signed 18.2
|
|
ASB-RVL-DATE
Element: Date | Numeric 8 (yyyymmdd)
|
|
