FA_RETIREMENTS_T
FA_RETIREMENTS_T contains temporary storage data for retirement transaction.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
FA_RETIREMENTS_T_PK |
RETIREMENT_INTERFACE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
BATCH_NAME | VARCHAR2 | 30 | Unique user-defined name for a batch of records in the interface table. Free text field. | |||
REQUEST_ID | NUMBER | 18 | Oracle Fusion Enterprise Resource Planning: request ID of the job that created or last updated the row. | |||
WORKER_ID | NUMBER | 18 | Oracle internal use only. Internal identifier for parallel processing. | |||
RETIREMENT_INTERFACE_ID | NUMBER | 18 | Yes | Oracle internal use only. Retirement interface identifier. | ||
RETIREMENT_ID | NUMBER | 18 | Oracle internal use only. Retirement identifier. | |||
BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Asset book. Use the Manage Asset Books task to identify valid values. | ||
POSTING_STATUS | VARCHAR2 | 30 | Yes | Posting status. Valid values: NEW, POST, ON HOLD. NEW means the asset information is new. POST means the asset is ready to be posted. ON HOLD means the row needs further review. | ||
ASSET_ID | NUMBER | 18 | Yes | Asset identifier. Use the Asset Inquiry in any work area to identify a valid value. | ||
TRANSACTION_NAME | VARCHAR2 | 240 | Transaction description. Free text field. Not validated. | |||
TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Retirement transaction type. Valid values: COST RETIRE, UNIT RETIRE, SRCLINE RETIRE, REINSTATEMENT, GROUP ADJUSTMENT.COST RETIRE means cost retirement. UNIT RETIRE means unit retirement. SRCLINE RETIRE means source line retirement. REINSTATMENT means reinstatement of the asset. GROUP ADJUSTMENT means group adjustment. | ||
DATE_RETIRED | DATE | Retirement date. Date format: YYYY/MM/DD. | ||||
COST_RETIRED | NUMBER | Amount of cost retired from the asset. Enter without thousands separator. Use either comma or period as decimal separator. | ||||
RETIREMENT_CONVENTION_TYPE_ID | NUMBER | 18 | Retirement convention type identifier. Use the Manage Prorate Conventions task to identify valid values. | |||
COST_OF_REMOVAL | NUMBER | Removal cost. Enter without thousands separator. Use either comma or period as decimal separator. Cannot be negative. | ||||
PROCEEDS_OF_SALE | NUMBER | Amount received from the sale of an asset. Enter without thousands separator. Use either comma or period as decimal separator. Cannot be negative. | ||||
RETIREMENT_TYPE_CODE | VARCHAR2 | 30 | Retirement type. Use the Manage Fixed Assets Lookups, lookup type FA_RETIREMENT_TYPES to identify valid values. | |||
REFERENCE_NUM | VARCHAR2 | 15 | Retirement reference number. Free text field. Not validated. | |||
SOLD_TO | VARCHAR2 | 30 | Sold to name. Free text field. Not validated. | |||
TRADE_IN_ASSET_ID | NUMBER | 18 | Trade in asset identifier. Use an Assets work area to identify valid values. | |||
STL_METHOD_ID | NUMBER | 18 | Straight line depreciation method identifier. Use the Manage Depreciation Methods task to identify valid values. | |||
STL_DEPRN_AMOUNT | NUMBER | Straight line depreciation amount for reporting of 1250 property in a tax book. Enter without thousands separator. Use either comma or period as decimal separator. | ||||
RECOGNIZE_GAIN_LOSS | VARCHAR2 | 30 | Indicates whether gain or loss on retirement must be recognized. Valid values: Y, N. | |||
REDUCTION_RATE | NUMBER | Depreciation reduction percentage for the asset group. Must be between 0 and 100. | ||||
RESERVE_RETIRED | NUMBER | Depreciation reserve reduced by retirement. Enter without thousands separator. Use either comma or period as decimal separator. Must be less than depreciation reserve. | ||||
EOFY_RESERVE | NUMBER | Depreciation reserve at the end of the fiscal year. Enter without thousands separator. Use either comma or period as decimal separator. | ||||
PREPARER_ID | NUMBER | 18 | Identifier of the person who prepared the mass addition record. Use the Manage resources task to identify valid values. | |||
INTERFACE_LINE_NUMBER | NUMBER | 18 | Oracle internal use only. Interface line number. | |||
LOAD_REQUEST_ID | NUMBER | 18 | Oracle Fusion Enterprise Resource Planning: process ID of the loader job that created or last updated the row. | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: user who created the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: user who last updated the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
TH_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Transactions descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Context code for Transactions descriptive flexfield. Use the Fixed Assets Descriptive Flexfields task to identify valid values. Use columns beginning with TH for segment values. | Transactions (FA_TRANSACTION_HEADERS) | ||
TH_ATTRIBUTE_NUMBER1 | NUMBER | Number value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_NUMBER2 | NUMBER | Number value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_NUMBER3 | NUMBER | Number value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_NUMBER4 | NUMBER | Number value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_NUMBER5 | NUMBER | Number value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_DATE1 | DATE | Date value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_DATE2 | DATE | Date value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_DATE3 | DATE | Date value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_DATE4 | DATE | Date value for Transactions descriptive flexfield. | ||||
TH_ATTRIBUTE_DATE5 | DATE | Date value for Transactions descriptive flexfield. | ||||
RET_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Retirements descriptive flexfield. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Context code for Retirements descriptive flexfield. Use the Manage Fixed Assets Descriptive Flexfields task to identify valid values. Use columns beginning with RET_ATTRIBUTE, RET_ATTRIBUTE_NUMBER, and RET_ATTRIBUTE_DATE for segment values. | Retirements (FA_RETIREMENTS) | ||
RET_ATTRIBUTE_NUMBER1 | NUMBER | Number value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_NUMBER2 | NUMBER | Number value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_NUMBER3 | NUMBER | Number value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_NUMBER4 | NUMBER | Number value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_NUMBER5 | NUMBER | Number value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_DATE1 | DATE | Date value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_DATE2 | DATE | Date value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_DATE3 | DATE | Date value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_DATE4 | DATE | Date value for Retirements descriptive flexfield. | ||||
RET_ATTRIBUTE_DATE5 | DATE | Date value for Retirements descriptive flexfield. | ||||
ERROR_MSG | VARCHAR2 | 2000 | Oracle internal use only. Error message for log file. | |||
ASSET_NUMBER | VARCHAR2 | 30 | User-defined asset identification number. | |||
TRADE_IN_ASSET_NUMBER | VARCHAR2 | 30 | Asset number of the new asset for which the retired asset was traded. | |||
RETIREMENT_CONVENTION_CODE | VARCHAR2 | 10 | Unique name of the retirement prorate convention. | |||
STL_METHOD_CODE | VARCHAR2 | 12 | Name of the straight line depreciation method used to calculate the depreciation for retirement transaction. | |||
STL_LIFE_IN_MONTHS | NUMBER | 4 | Life in months for the straight line depreciation method. | |||
PREPARER_EMAIL_ADDRESS | VARCHAR2 | 240 | Optional email address of the person assigned to prepare the line. | |||
PREPARER_NAME | VARCHAR2 | 240 | Optional name of the person assigned to prepare the line. | |||
PREPARER_NUMBER | VARCHAR2 | 30 | Optional number of the person assigned to prepare the line. | |||
TH_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
TH_GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
TH_GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
FEEDER_SYSTEM_NAME | VARCHAR2 | 40 | Name of the source system from which the asset transaction was created. This is a free text field that is not validated. | |||
AUTO_POST_TRANSACTION_FLAG | VARCHAR2 | 1 | Indicates whether an asset transaction should be automatically posted after approval. | |||
APPROVAL_STATUS_CODE | VARCHAR2 | 30 | Status of the asset transaction approval. | |||
ASSET_LEVEL_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether each asset in a mass transaction batch requires separate approval. | |||
TERMINATE_IB_ASSET_FLAG | VARCHAR2 | 1 | Indicates whether to terminate the associated installed base asset when a fixed asset is retired. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
FA_RETIREMENTS_T | fa_book_controls | BOOK_TYPE_CODE |
FA_RETIREMENTS_T | fa_additions_b | ASSET_ID |
FA_RETIREMENTS_T | fa_retirements | RETIREMENT_ID |
FA_RETIREMENTS_T | fa_additions_b | TRADE_IN_ASSET_ID |
FA_RETIREMENTS_T | fa_methods | STL_METHOD_ID |
FA_RETIREMENTS_T | fa_convention_types | RETIREMENT_CONVENTION_TYPE_ID |
fa_retirement_dists_t | fa_retirements_t | RETIREMENT_INTERFACE_ID |
fa_ret_src_lines_t | fa_retirements_t | RETIREMENT_INTERFACE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
FA_RETIREMENTS_T_N1 | Non Unique | Default | BOOK_TYPE_CODE, POSTING_STATUS, REQUEST_ID, WORKER_ID |
FA_RETIREMENTS_T_N2 | Non Unique | Default | BOOK_TYPE_CODE, POSTING_STATUS, BATCH_NAME, ASSET_ID, INTERFACE_LINE_NUMBER |
FA_RETIREMENTS_T_U1 | Unique | Default | RETIREMENT_INTERFACE_ID |