AMASTBKRIN

Asset Book Reinstatement

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
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.
AM41.1
RIB-BOOK
Element: Book
Alpha 10
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.
AM41.1
RIB-BOOK-COST-SALE
Element: Intl Amt
Signed 18.2
This is the cost of sale for the asset disposal.
AM41.1
RIB-CST-SALE-OVRRD
Element: Intl Amt
Signed 18.2
This is the overriding amount for the book cost of sale.
AM41.1
RIB-BOOK-PROCEEDS
Element: Intl Amt
Signed 18.2
This field contains the proceeds for the asset disposal.
AM41.1
RIB-PROCEEDS-OVRRD
Element: Intl Amt
Signed 18.2
This is the overriding amount for the book proceeds from the disposal.
AM41.1
RIB-GAIN-LOSS
Element: Intl Amt
Signed 18.2
This field contains the gain or loss for the asset disposal.
AM41.1
RIB-GN-LS-OVERRIDE
Element: Intl Amt
Signed 18.2
This field contains the gain or loss override for the asset disposal.
AM41.1
RIB-DEFER-GN-LS
Element: Intl Amt
Signed 18.2
This field contains the deferred gain or loss for the asset disposal.
AM41.1
RIB-DEFER-OVERRIDE
Element: Intl Amt
Signed 18.2
This field contains the deferred gain or loss override for the asset disposal.
AM41.1
RIB-TC-RECAPTURE
Element: Intl Amt
Signed 18.2
This is the tax credit recapture amount for the asset disposal.
AM41.1
RIB-TC-OVERRIDE
Element: Intl Amt
Signed 18.2
This is the tax credit recapture override for the asset disposal.
AM41.1
RIB-BOOK-BASIS
Element: Intl Amt
Signed 18.2
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.
AM41.1
RIB-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal positions defined for the transaction currency.
AM41.1
RIB-DSP-DEPR
Element: Intl Amt
Signed 18.2
This is the depreciation expense associated with the disposal.
AM41.1
RIB-DSP-DEPR-OVRRD
Element: Intl Amt
Signed 18.2
This is the depreciation expense override amount associated with the disposal.
AM41.1
RIB-DEPR-YTD
Element: Intl Amt
Signed 18.2
This is the year-to-date depreciation for the disposed asset.
AM41.1
RIB-DEPR-YTD-ALLOW
Element: Intl Amt
Signed 18.2
This is the year-to-date depreciation allowance for the disposed asset.
AM41.1
RIB-DEPR-YTD-OVRRD
Element: Intl Amt
Signed 18.2
This is the year-to-date depreciation override for the disposed asset..
RIB-DEPR-LTD
Element: Intl Amt
Signed 18.2
This is the life-to-date depreciation for the disposed-of asset.
AM41.1
RIB-DEPR-LTD-ALLOW
Element: Intl Amt
Signed 18.2
This is the life-to-date depreciation allowance for the disposed asset.
AM41.1
RIB-SALVAGE-VALUE
Element: Intl Amt
Signed 18.2
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.
AM41.1
RIB-YR1-EXP
Element: Intl Amt
Signed 18.2
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.
AM41.1
RIB-TC-PROPERTY
Element: Intl Amt
Signed 18.2
This is the tax credit amount for the asset, if you are taking a tax credit for used property.
AM41.1
RIB-TAX-CREDIT
Element: Intl Amt
Signed 18.2
This is the tax credit amount for the asset.
AM41.1
RIB-INS-ACT-VAL
Element: Intl Amt
Signed 18.2
This is the actual insurance value for the asset.
AM41.1
RIB-INS-CMPTD-VAL
Element: Intl Amt
Signed 18.2
This is the computed replacement value for the asset.
AM41.1
RIB-RPL-CMPTD-VAL
Element: Intl Amt
Signed 18.2
This is the computed replacement value for the asset.
AM41.1
RIB-NEW-AST-BASIS
Element: Intl Amt
Signed 18.2
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.
AM41.1
RIB-CASH-PAID
Element: Intl Amt
Signed 18.2
This is the amount of cash paid in the asset disposal.
AM41.1
RIB-OLD-AST-ADJ-BS
Element: Intl Amt
Signed 18.2
This is the adjusted basis for the old asset.
AM41.1
RIB-AMT-REALIZED
Element: Intl Amt
Signed 18.2
This is the amount realized through the disposal.
AM41.1
RIB-AMT-GIVEN-UP
Element: Intl Amt
Signed 18.2
This is the amount of depreciation given up as a result of the disposal.
AM41.1
RIB-NEW-AST-ADJ-BS
Element: Intl Amt
Signed 18.2
If the disposal was a partial disposal, a new asset was defined. This is the adjusted basis for the new asset.
AM41.1
RIB-NEW-ASSET
Element: Asset
Numeric 10
If the disposal was partial disposal, a new asset was defined. This is the new asset number.
AM41.1
RIB-AST-DSP-ASSET
Element: Ast Dsp Asset
Derived
This is the number of the disposed-of asset.
RIB-AST-ASSET-GRP
Element: Ast Asset Grp
Derived
This is the asset group for the new asset.
RIB-AST-TAG-NBR
Element: Ast Tag Nbr
Derived
This is the tag for the new asset.
RIB-AST-DESCRIP
Element: Ast Descrip
Derived
This is the new asset description.
RIB-ASD-DSP-DATE
Element: Asd Dsp Date
Derived
This is the effective date for the asset disposal.
RIB-ASD-FULL-PART
Element: Asd Full Part
Derived
This field indicates whether the disposal was a full or partial disposal.
RIB-ASD-DSP-METH
Element: Asd Dsp Meth
Derived
This is the way in which the asset was disposed of.
RIB-ASD-DSP-PROP
Element: Asd Dsp Prop
Derived
This is the user-defined name of a disposal property. It represents a kind of disposed-of asset.
RIB-BOOK-CURRENCY
Element: Book Currency
Derived
This is the currency for the book.
RIB-DSP-CREAT-DATE
Element: Dsp Creat Date
Derived
This is the creation date for the disposal.
RIB-DSP-CREAT-TIME
Element: Dsp Creat Time
Derived
This is the creation time for the disposal.
RIB-DSP-CREATOR-ID
Element: Dsp Creator Id
Derived
This is the ID of the person who created the disposal.
RIB-AMB-DESC
Element: Amb Desc
Derived
This is the description of the book.
RIB-ASB-BOOK-BASIS
Element: Asb Book Basis
Derived
This field contains the amount on which the depreciation calculations for the book are based.
RIB-ASB-METHOD
Element: Asb Method
Derived
This is the asset book depreciation method.
RIB-ASB-LIFE
Element: Asb Life
Derived
This is the life of the asset.
RIB-ASB-LIFE-REM
Element: Asb Life Rem
Derived
This is the remaining life for the asset.
RIB-ASB-INSRV-DATE
Element: Asb Insrv Date
Derived
This is the in-service date for the asset.
RIB-ASB-CONVENTION
Element: Asb Convention
Derived
This is the in-service convention for the asset.
RIB-DSP-OVERRIDE
Element: Dsp Override
Derived
The word "OVERRIDE" displays if the disposal amount has been overridden.
RIB-PROC-OVERRIDE
Element: Proc Override
Derived
The word "OVERRIDE" displays if the proceeds amount has been overridden.
RIB-COS-OVERRIDE
Element: Cos Override
Derived
The word "OVERRIDE" displays if the expense amount has been overridden.
RIB-DEFR-OVERRIDE
Element: Defr Override
Derived
The word "OVERRIDE" displays if the deferred gain or loss amount has been overridden.
RIB-TCRECAP-OVERRD
Element: Tcrecap Overrd
Derived
The word "OVERRIDE" displays if the tax credit recapture amount has been overridden.
RIB-CALC-DEPR-LTD
Element: Calc Depr Ltd
Derived
This is the life-to-date calculated depreciation
RIB-DSP-NET-VALUE
Element: Dsp Net Value
Derived
The Disposal Net Value is calculated as follows: Book Basis - Life-to-Date Depreciation.
RIB-AST-LOCATION
Element: Ast Location
Derived
This is the location associated with the asset.
RIB-AST-DIVISION
Element: Ast Division
Derived
This is the division associated with the asset.
RIB-AST-TYPE
Element: Ast Type
Derived
This is the type associated with the asset.
RIB-AST-SUBTYPE
Element: Ast Subtype
Derived
This is the subtype associated with the asset.
RIB-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the record creation date
AM41.1
RIB-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
This is the record creation time
AM41.1
RIB-CREATOR-ID
Element: Operator
Alpha 10
This is the login ID of the person creating the record.
AM41.1
RIB-REINSTATE-DATE
Element: Reinstate Date
Numeric 8 (yyyymmdd)
This is the reinstatement date for the disposed asset.
AM41.1


AMASTBKRIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RIBSET1 ASSET
BOOK
CREATION-DATE
CREATION-TIME
KeyChange
AM241 AM300
AM330 AM41.1
RIBSET2 BOOK
ASSET
CREATION-DATE
CREATION-TIME
AM310
RIBSET3 ASSET
REINSTATE-DATE
BOOK
CREATION-DATE
CREATION-TIME
AM41.1


AMASTBKRIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:04:59 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.