# DW_FA_MC_RETIREMENTS_D

This is the FA dimension table for Fixed asset retirements details

## Details

Module: Assets

## Key Columns

MC_FLAG, RETIREMENT_ID, LEDGER_ID

## 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 |  |

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