AMASTBKRIN FILE
This file contains audit asset book information related to reinstated
disposals. It contains a copy of the disposal information contained in
AMASTBKDSP, plus reinstatement information.
REFERENCED BY
AM241
UPDATED BY
AM300 AM310 AM41.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RIB-ASSET Numeric 10 AM41.1
Asset Number Key field. The asset number contains up
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
RIB-BOOK Alpha 10 AM41.1
Book Key field. This field contains a
user-defined book name. Books are used
by assets for calculating depreciation,
replacement cost, and insurance values,
and for reporting.
RIB-BOOK-COST-SALE Signed 15.2 AM41.1
Book Cost Sale This is the cost of sale for the asset
disposal.
RIB-CST-SALE-OVRRD Signed 15.2 AM41.1
Cst Sale Ovrrd This is the overriding amount for the
book cost of sale.
RIB-BOOK-PROCEEDS Signed 15.2 AM41.1
Book Proceeds This field contains the proceeds for
the asset disposal.
RIB-PROCEEDS-OVRRD Signed 15.2 AM41.1
Proceeds Ovrrd This is the overriding amount for the
book proceeds from the disposal.
RIB-GAIN-LOSS Signed 15.2 AM41.1
Gain Loss This field contains the gain or loss
for the asset disposal.
RIB-GN-LS-OVERRIDE Signed 15.2 AM41.1
Gn Ls Override This field contains the gain or loss
override for the asset disposal.
RIB-DEFER-GN-LS Signed 15.2 AM41.1
Defer Gn Ls This field contains the deferred gain
or loss for the asset disposal.
RIB-DEFER-OVERRIDE Signed 15.2 AM41.1
Defer Override This field contains the deferred gain
or loss override for the asset disposal.
RIB-TC-RECAPTURE Signed 15.2 AM41.1
Tc Recapture This is the tax credit recapture amount
for the asset disposal.
RIB-TC-OVERRIDE Signed 15.2 AM41.1
Tc Override This is the tax credit recapture
override for the asset disposal.
RIB-BOOK-BASIS Signed 15.2 AM41.1
Book Basis This field contains the book basis
amount on which the depreciation
calculations for the disposed asset are
based.
Note: The depreciation basis amount can
be different for each depreciation book
used.
RIB-TRAN-ND Numeric 1 AM41.1
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
RIB-DSP-DEPR Signed 15.2 AM41.1
Dsp Depr This is the depreciation expense
associated with the disposal.
RIB-DSP-DEPR-OVRRD Signed 15.2 AM41.1
Dsp Depr Ovrrd This is the depreciation expense
override amount associated with the
disposal.
RIB-DEPR-YTD Signed 15.2 AM41.1
Depr Ytd This is the year-to-date depreciation
for the disposed asset.
RIB-DEPR-YTD-ALLOW Signed 15.2 AM41.1
Depr Ytd Allow This is the year-to-date depreciation
allowance for the disposed asset.
RIB-DEPR-YTD-OVRRD Signed 15.2
Depr Ytd Ovrrd This is the year-to-date depreciation
override for the disposed asset..
RIB-DEPR-LTD Signed 15.2 AM41.1
Depr Ltd This is the life-to-date depreciation
for the disposed-of asset.
RIB-DEPR-LTD-ALLOW Signed 15.2 AM41.1
Depr Ltd Allow This is the life-to-date depreciation
allowance for the disposed asset.
RIB-SALVAGE-VALUE Signed 15.2 AM41.1
Salvage Value This is the salvage value of the asset,
or value remaining, at the end of the
asset's life. It can be zero.
If the depreciation method is SL
(Straight Line), the basis used for the
depreciation calculation is the asset
cost less this salvage value.
If the depreciation method is 200DB
(Double Declining Balance), 125DB (125%
Declining Balance), 150 (150% Declining
Balance), or 175 (175% Declining
Balance), the basis used for the
depreciation calculation is the asset
cost. Depreciation is taken until the
total amount taken is equal to the asset
cost less this salvage value.
RIB-YR1-EXP Signed 15.2 AM41.1
Yr1 Exp This is the new first year expense
amount for the asset. 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.
RIB-TC-PROPERTY Signed 15.2 AM41.1
Tc Property This is the tax credit amount for the
asset, if you are taking a tax credit
for used property.
RIB-TAX-CREDIT Signed 15.2 AM41.1
Tax Credit This is the tax credit amount for the
asset.
RIB-INS-ACT-VAL Signed 15.2 AM41.1
Ins Act Val This is the actual insurance value for
the asset.
RIB-INS-CMPTD-VAL Signed 15.2 AM41.1
Ins Cmptd Val This is the computed replacement value
for the asset.
RIB-RPL-CMPTD-VAL Signed 15.2 AM41.1
Rpl Cmptd Val This is the computed replacement value
for the asset.
RIB-NEW-AST-BASIS Signed 15.2 AM41.1
New Ast Basis If the disposal was a partial disposal,
a new asset was defined. This field
contains the new asset basis, or the
amount on which depreciation
calculations for the new asset are
based.
RIB-CASH-PAID Signed 15.2 AM41.1
Cash Paid This is the amount of cash paid in the
asset disposal.
RIB-OLD-AST-ADJ-BS Signed 15.2 AM41.1
Old Ast Adj Bs This is the adjusted basis for the old
asset.
RIB-AMT-REALIZED Signed 15.2 AM41.1
Amt Realized This is the amount realized through the
disposal.
RIB-AMT-GIVEN-UP Signed 15.2 AM41.1
Amt Given Up This is the amount of depreciation
given up as a result of the disposal.
RIB-NEW-AST-ADJ-BS Signed 15.2 AM41.1
New Ast Adj Bs If the disposal was a partial disposal,
a new asset was defined. This is the
adjusted basis for the new asset.
RIB-NEW-ASSET Numeric 10 AM41.1
New Asset If the disposal was partial disposal, a
new asset was defined. This is the new
asset number.
RIB-AST-DSP-ASSET Derived
Ast Dsp Asset This is the number of the disposed-of
asset.
RIB-AST-ASSET-GRP Derived
Ast Asset Grp This is the asset group for the new
asset.
RIB-AST-TAG-NBR Derived
Ast Tag Nbr This is the tag for the new asset.
RIB-AST-DESCRIP Derived
Ast Descrip This is the new asset description.
RIB-ASD-DSP-DATE Derived
Asd Dsp Date This is the effective date for the
asset disposal.
RIB-ASD-FULL-PART Derived
Asd Full Part This field indicates whether the
disposal was a full or partial disposal.
RIB-ASD-DSP-METH Derived
Asd Dsp Meth This is the way in which the asset was
disposed of.
RIB-ASD-DSP-PROP Derived
Asd Dsp Prop This is the user-defined name of a
disposal property. It represents a kind
of disposed-of asset.
RIB-BOOK-CURRENCY Derived
Book Currency This is the currency for the book.
RIB-DSP-CREAT-DATE Derived
Dsp Creat Date This is the creation date for the
disposal.
RIB-DSP-CREAT-TIME Derived
Dsp Creat Time This is the creation time for the
disposal.
RIB-DSP-CREATOR-ID Derived
Dsp Creator Id This is the ID of the person who
created the disposal.
RIB-AMB-DESC Derived
Amb Desc This is the description of the book.
RIB-ASB-BOOK-BASIS Derived
Asb Book Basis This field contains the amount on which
the depreciation calculations for the
book are based.
RIB-ASB-METHOD Derived
Asb Method This is the asset book depreciation
method.
RIB-ASB-LIFE Derived
Asb Life This is the life of the asset.
RIB-ASB-LIFE-REM Derived
Asb Life Rem This is the remaining life for the
asset.
RIB-ASB-INSRV-DATE Derived
Asb Insrv Date This is the in-service date for the
asset.
RIB-ASB-CONVENTION Derived
Asb Convention This is the in-service convention for
the asset.
RIB-DSP-OVERRIDE Derived
Dsp Override The word "OVERRIDE" displays if the
disposal amount has been overridden.
RIB-PROC-OVERRIDE Derived
Proc Override The word "OVERRIDE" displays if the
proceeds amount has been overridden.
RIB-COS-OVERRIDE Derived
Cos Override The word "OVERRIDE" displays if the
expense amount has been overridden.
RIB-DEFR-OVERRIDE Derived
Defr Override The word "OVERRIDE" displays if the
deferred gain or loss amount has been
overridden.
RIB-TCRECAP-OVERRD Derived
Tcrecap Overrd The word "OVERRIDE" displays if the tax
credit recapture amount has been
overridden.
RIB-CALC-DEPR-LTD Derived
Calc Depr Ltd This is the life-to-date calculated
depreciation
RIB-DSP-NET-VALUE Derived
Dsp Net Value The Disposal Net Value is calculated as
follows: Book Basis - Life-to-Date
Depreciation.
RIB-AST-LOCATION Derived
Ast Location This is the location associated with
the asset.
RIB-AST-DIVISION Derived
Ast Division This is the division associated with
the asset.
RIB-AST-TYPE Derived
Ast Type This is the type associated with the
asset.
RIB-AST-SUBTYPE Derived
Ast Subtype This is the subtype associated with the
asset.
RIB-CREATION-DATE Numeric 8 (yyyymmdd) AM41.1
Creation Date This is the record creation date
RIB-CREATION-TIME Numeric 6 (hhmmss) AM41.1
Creation Time This is the record creation time
RIB-CREATOR-ID Alpha 10 AM41.1
Creator Id This is the login ID of the person
creating the record.
RIB-REINSTATE-DATE Numeric 8 (yyyymmdd) AM41.1
Reinstate Date This is the reinstatement date for the
disposed asset.
AMASTBKRIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RIBSET1 ASSET This index accesses information by AM241 AM300
BOOK asset and book.
CREATION-DATE KeyChange
CREATION-TIME
RIBSET2 BOOK This index accesses information by book AM310
ASSET and asset.
CREATION-DATE
CREATION-TIME
RIBSET3 ASSET This index accesses information by AM41.1
REINSTATE-DATEasset and reinstatement date.
BOOK
CREATION-DATE
CREATION-TIME
AMASTBKRIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
Valid When RIB-ASSET != Zeroes
RIB-ASSET -> AST-ASSET
Amassetrin AMASSETRIN Not Required
RIB-ASSET -> RIN-ASSET
RIB-CREATION-DATE -> RIN-CREATION-DATE
RIB-CREATION-TIME -> RIN-CREATION-TIME
Amastbook AMASTBOOK Not Required
RIB-ASSET -> ASB-ASSET
RIB-BOOK -> ASB-BOOK
Amasttype AMASTTYPE Not Required
AST-COMPANY -> ATP-COMPANY
AST-ASSET-TYPE -> ATP-ASSET-TYPE
AST-SUB-TYPE -> ATP-SUB-TYPE
Ambook AMBOOK Not Required
RIB-BOOK -> AMB-BOOK
Amdivision AMDIVISION Not Required
AST-DIVISION -> DIV-DIVISION
Amlocation AMLOCATION Not Required
AST-LOCATION-NAME -> LOC-LOCATION-NAME
|
