This is the FA dimension table for Fixed asset retirements details
Module: Assets
LEDGER_ID, MC_FLAG, RETIREMENT_ID
| 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, 2024, Oracle and/or its affiliates.