|
AMASTBKINV FILE
UPDATED BY
AM502 AM92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IBK-RUN-GROUP Alpha 15 AM92.1
Element: Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
IBK-ASSET Numeric 10 AM92.1
Element: Asset Number The asset number contains up to ten
numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
IBK-BOOK Alpha 10 AM92.1
Element: Book A user-defined book name. Books are
used by assets for calculating
depreciation, replacement cost, and
insurance values, and for reporting.
IBK-BOOK-STATUS Alpha 1 AM502 AM92.1
Element: Status Cd
IBK-LIFE Numeric 4 AM92.1
Element: Life
IBK-LIFE-REM Signed 7.3 AM502 AM92.1
Element: Life Rem
IBK-BOOK-BASIS Signed 18.2 AM92.1
Element: Intl Amt The GL BOOK basis field contains the
amount on which the depreciation
calculations are based.
Note: The depreciation basis amount
can be different for each depreciation
book used.
IBK-METHOD Alpha 10 AM92.1
Element: Method Code The method.
IBK-INSRV-DATE Numeric 8 (yyyymmdd) AM502 AM92.1
Element: Date The book in-service date for the asset.
Note: The in-service date can be
different for each depreciation book
used.
IBK-METH-TABLE-YR Numeric 2 AM502 AM92.1
Element: Meth Table Yr
IBK-CONVENTION Alpha 2 AM502 AM92.1
Element: Convention
IBK-LIFE-YEARS Signed 5.2 AM502 AM92.1
Element: Life Years
IBK-DEPR-YTD Signed 18.2 AM92.1
Element: Intl Amt
IBK-DEPR-YTD-ALLOW Signed 18.2 AM92.1
Element: Intl Amt
IBK-DEPR-LTD Signed 18.2 AM92.1
Element: Intl Amt
IBK-DEPR-LTD-ALLOW Signed 18.2 AM92.1
Element: Intl Amt
IBK-INACT-YTD Signed 5.3 AM92.1
Element: Inact Ytd
IBK-INACT-LTD Signed 7.3 AM92.1
Element: Inact Ltd
IBK-SALVAGE-VALUE Signed 18.2 AM92.1
Element: Intl Amt This is the GL 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), 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.
IBK-BUS-PERCENT Signed 5.2 AM502 AM92.1
Element: Bus Percent
IBK-PERSONAL-USE Alpha 10 AM92.1
Element: Personal Use 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.
IBK-YR1-EXP Signed 18.2 AM92.1
Element: Intl Amt This is 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.
IBK-TC-TABLE Alpha 10 AM92.1
Element: Tc Table 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.
IBK-TC-PROPERTY Signed 18.2 AM92.1
Element: Intl Amt
IBK-TC-CREDIT Signed 18.2 AM92.1
Element: Intl Amt
IBK-INS-METHOD Alpha 10 AM92.1
Element: Method Code
IBK-INS-ACT-VAL Signed 18.2 AM92.1
Element: Intl Amt
IBK-INS-CMPTD-VAL Signed 18.2 AM92.1
Element: Intl Amt
IBK-RPL-METHOD Alpha 10 AM92.1
Element: Method Code
IBK-RPL-CMPTD-VAL Signed 18.2 AM92.1
Element: Intl Amt
AMASTBKINV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IBKSET1 RUN-GROUP AM502 AM92.1
BOOK
ASSET
IBKSET2 ASSET AM92.1
BOOK
|