|
|
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 AM330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RIB-ASSET Numeric 10 AM41.1
Element: 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
Element: 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
Element: Actual Cost This is the cost of sale for the asset
disposal.
RIB-CST-SALE-OVRRD Signed 15.2 AM41.1
Element: Actual Sales This is the overriding amount for the
book cost of sale.
RIB-BOOK-PROCEEDS Signed 15.2 AM41.1
Element: Price This field contains the proceeds for
the asset disposal.
RIB-PROCEEDS-OVRRD Signed 15.2 AM41.1
Element: Price This is the overriding amount for the
book proceeds from the disposal.
RIB-GAIN-LOSS Signed 15.2 AM41.1
Element: Gain Loss This field contains the gain or loss
for the asset disposal.
RIB-GN-LS-OVERRIDE Signed 15.2 AM41.1
Element: Gain Loss This field contains the gain or loss
override for the asset disposal.
RIB-DEFER-GN-LS Signed 15.2 AM41.1
Element: Gain Loss This field contains the deferred gain
or loss for the asset disposal.
RIB-DEFER-OVERRIDE Signed 15.2 AM41.1
Element: Defer OverrideThis field contains the deferred gain
or loss override for the asset disposal.
RIB-TC-RECAPTURE Signed 15.2 AM41.1
Element: Tc Property This is the tax credit recapture amount
for the asset disposal.
RIB-TC-OVERRIDE Signed 15.2 AM41.1
Element: Tc Property This is the tax credit recapture
override for the asset disposal.
RIB-BOOK-BASIS Signed 15.2 AM41.1
Element: 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
Account Currency The number of decimal positions defined
Code for the transaction currency.
RIB-DSP-DEPR Signed 15.2 AM41.1
Element: Depr Ytd This is the depreciation expense
associated with the disposal.
RIB-DSP-DEPR-OVRRD Signed 15.2 AM41.1
Element: Depr Ytd This is the depreciation expense
override amount associated with the
disposal.
RIB-DEPR-YTD Signed 15.2 AM41.1
Element: Depr Ytd This is the year-to-date depreciation
for the disposed asset.
RIB-DEPR-YTD-ALLOW Signed 15.2 AM41.1
Element: Depr Ytd This is the year-to-date depreciation
allowance for the disposed asset.
RIB-DEPR-YTD-OVRRD Signed 15.2
Element: Depr Ytd This is the year-to-date depreciation
override for the disposed asset..
RIB-DEPR-LTD Signed 15.2 AM41.1
Element: Depr Ytd This is the life-to-date depreciation
for the disposed-of asset.
RIB-DEPR-LTD-ALLOW Signed 15.2 AM41.1
Element: Depr Ytd This is the life-to-date depreciation
allowance for the disposed asset.
RIB-SALVAGE-VALUE Signed 15.2 AM41.1
Element: Actual 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
Element: To 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
Element: 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
Element: Auto Credits This is the tax credit amount for the
asset.
RIB-INS-ACT-VAL Signed 15.2 AM41.1
Element: Actual This is the actual insurance value for
the asset.
RIB-INS-CMPTD-VAL Signed 15.2 AM41.1
Element: To Rpl Cmptd This is the computed replacement value
for the asset.
RIB-RPL-CMPTD-VAL Signed 15.2 AM41.1
Element: To Rpl Cmptd This is the computed replacement value
for the asset.
RIB-NEW-AST-BASIS Signed 15.2 AM41.1
Element: Book 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
Element: Current Cash This is the amount of cash paid in the
asset disposal.
RIB-OLD-AST-ADJ-BS Signed 15.2 AM41.1
Element: Book Basis This is the adjusted basis for the old
asset.
RIB-AMT-REALIZED Signed 15.2 AM41.1
Element: Adj Amt This is the amount realized through the
disposal.
RIB-AMT-GIVEN-UP Signed 15.2 AM41.1
Element: Adj Amt This is the amount of depreciation
given up as a result of the disposal.
RIB-NEW-AST-ADJ-BS Signed 15.2 AM41.1
Element: Book Basis 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
Element: Asset Number If the disposal was partial disposal, a
new asset was defined. This is the new
asset number.
RIB-AST-DSP-ASSET Derived
Element: Ast Dsp Asset This is the number of the disposed-of
asset.
RIB-AST-ASSET-GRP Derived
Element: Ast Asset Grp This is the asset group for the new
asset.
RIB-AST-TAG-NBR Derived
Element: Ast Tag Nbr This is the tag for the new asset.
RIB-AST-DESCRIP Derived
Element: Ast Descrip This is the new asset description.
RIB-ASD-DSP-DATE Derived
Element: Asd Dsp Date This is the effective date for the
asset disposal.
RIB-ASD-FULL-PART Derived
Element: Asd Full Part This field indicates whether the
disposal was a full or partial disposal.
RIB-ASD-DSP-METH Derived
Element: Asd Dsp Meth This is the way in which the asset was
disposed of.
RIB-ASD-DSP-PROP Derived
Element: 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
Element: Book Currency This is the currency for the book.
RIB-DSP-CREAT-DATE Derived
Element: Dsp Creat DateThis is the creation date for the
disposal.
RIB-DSP-CREAT-TIME Derived
Element: Dsp Creat TimeThis is the creation time for the
disposal.
RIB-DSP-CREATOR-ID Derived
Element: Dsp Creator IdThis is the ID of the person who
created the disposal.
RIB-AMB-DESC Derived
Element: Amb Desc This is the description of the book.
RIB-ASB-BOOK-BASIS Derived
Element: Asb Book BasisThis field contains the amount on which
the depreciation calculations for the
book are based.
RIB-ASB-METHOD Derived
Element: Asb Method This is the asset book depreciation
method.
RIB-ASB-LIFE Derived
Element: Asb Life This is the life of the asset.
RIB-ASB-LIFE-REM Derived
Element: Asb Life Rem This is the remaining life for the
asset.
RIB-ASB-INSRV-DATE Derived
Element: Asb Insrv DateThis is the in-service date for the
asset.
RIB-ASB-CONVENTION Derived
Element: Asb ConventionThis is the in-service convention for
the asset.
RIB-DSP-OVERRIDE Derived
Element: Dsp Override The word "OVERRIDE" displays if the
disposal amount has been overridden.
RIB-PROC-OVERRIDE Derived
Element: Proc Override The word "OVERRIDE" displays if the
proceeds amount has been overridden.
RIB-COS-OVERRIDE Derived
Element: Cos Override The word "OVERRIDE" displays if the
expense amount has been overridden.
RIB-DEFR-OVERRIDE Derived
Element: Defr Override The word "OVERRIDE" displays if the
deferred gain or loss amount has been
overridden.
RIB-TCRECAP-OVERRD Derived
Element: Tcrecap OverrdThe word "OVERRIDE" displays if the tax
credit recapture amount has been
overridden.
RIB-CALC-DEPR-LTD Derived
Element: Calc Depr Ltd This is the life-to-date calculated
depreciation
RIB-DSP-NET-VALUE Derived
Element: Dsp Net Value The Disposal Net Value is calculated as
follows: Book Basis - Life-to-Date
Depreciation.
RIB-AST-LOCATION Derived
Element: Ast Location This is the location associated with
the asset.
RIB-AST-DIVISION Derived
Element: Ast Division This is the division associated with
the asset.
RIB-AST-TYPE Derived
Element: Ast Type This is the type associated with the
asset.
RIB-AST-SUBTYPE Derived
Element: Ast Subtype This is the subtype associated with the
asset.
RIB-CREATION-DATE Numeric 8 (yyyymmdd) AM41.1
Element: Date This is the record creation date
RIB-CREATION-TIME Numeric 6 (hhmmss) AM41.1
Element: Sys Time This is the record creation time
RIB-CREATOR-ID Alpha 10 AM41.1
Authorization This is the login ID of the person
Identification creating the record.
RIB-REINSTATE-DATE Numeric 8 (yyyymmdd) AM41.1
Element: Reinstate DateThis 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. AM330
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
|
