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 | 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, 2023, Oracle and/or its affiliates.