DW_FA_MC_RETIREMENTS_D

This is the FA dimension table for Fixed asset retirements details

Details

Module: Assets

Key Columns

RETIREMENT_ID, LEDGER_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     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.    

Copyright © 2019, 2022, Oracle and/or its affiliates.