DW_FA_MC_RETIREMENTS_D

This is the FA dimension table for Fixed asset retirements details

Details

Module: Assets

Key Columns

LEDGER_ID, RETIREMENT_ID, MC_FLAG

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RETIREMENT_ID NUMBER 38 0 True Identifier of the asset retirement transaction.
LEDGER_ID NUMBER 38 0 True Identifier of the accounting ledger
MC_FLAG VARCHAR2 16 True Flag to indicate the source of data is MC or Regular dataset
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Retirement identifier.
BOOK_TYPE_CODE VARCHAR2 32 Unique book identification name.
ASSET_ID NUMBER 38 0 Identifier of the asset number.
TRANSACTION_HEADER_ID_IN NUMBER 38 0 Identifier of the transaction that created the row.
TRANSACTION_HEADER_ID_OUT NUMBER 38 0 Identifier of the transaction that terminated the row.
RETIREMENT_CONVENTION_TYPE_ID NUMBER 38 0 Identifier of the prorate convention.
STATUS VARCHAR2 16 Status of the retirement transaction.
COST_RETIRED NUMBER Amount of cost retired from the asset.
GLOBAL_COST_RETIRED NUMBER Amount of cost retired from the asset in Global Currency
DATE_RETIRED DATE Date on which an asset was retired.
UNITS NUMBER Number of units retired in the transaction.
GAIN_LOSS_AMOUNT NUMBER Gain or loss amount from retiring an asset.
GLOBAL_GAIN_LOSS_AMOUNT NUMBER Gain or loss amount from retiring an asset in Global Currency
RETIREMENT_TYPE_CODE VARCHAR2 32 Reason why the asset is retired in the system.
GAIN_LOSS_TYPE_CODE VARCHAR2 16 Reason why the asset is retired in the system.
REFERENCE_NUM VARCHAR2 16 Voucher number (Sequential Numbering) for invoice
IMPAIR_RESERVE_RETIRED NUMBER Ratio at which the principal unit of one currency is converted into another currency for an invoice.
GLOBAL_IMPAIR_RESERVE_RETIRED NUMBER Impairment reserve amount which is retired in Global Currency
REDUCTION_RATE NUMBER Accounting date to default to invoice distributions
SOLD_TO VARCHAR2 32 Name of the party to whom the asset was sold as part of retirement.
TERMINAL_GAIN_LOSS VARCHAR2 32 Option indicating how terminal gain or loss should be recognized for member asset retirement.
UNREVALUED_COST_RETIRED NUMBER Cost retired without any regard to any revaluations.
GLOBAL_UNREVALUED_COST_RETIRED NUMBER Cost retired without any regard to any revaluations in Global Currency
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency of the ledger.
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion rate.
CREATION_DATE TIMESTAMP Creation Date