This is the Dimension table for Fixed asset history details
Module: Assets
TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE, ASSET_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | 32 | True | The name of the asset book. | |||
ASSET_ID | NUMBER | 38 | 0 | True | Identifier of the asset number. | ||
TRANSACTION_HEADER_ID_IN | NUMBER | 38 | 0 | True | Identifier of the transaction that created the row. | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Source record identifier. Value is derived from a combination of ASSET_ID,BOOK_TYPE_CODE and TRANSACTION_HEADER_ID_IN | ||||
TRANSACTION_HEADER_ID_OUT | NUMBER | 38 | 0 | Identifier of the transaction that terminated the row. | |||
DATE_EFFECTIVE | TIMESTAMP | Date when the row became effective. | |||||
DATE_INEFFECTIVE | TIMESTAMP | Date when the row became inactive. | |||||
CATEGORY_ID | NUMBER | 38 | 0 | Identifier of the asset category. | |||
ASSET_TYPE | VARCHAR2 | 16 | Type of the asset allowed in Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group. | ||||
UNITS | NUMBER | Total number of units for the asset. |