This is the Dimension table for Fixed asset history details
Module: Assets
ASSET_ID, TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE
| 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 | This column is for Oracle Internal use only. 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. | |||||
| CREATION_DATE | TIMESTAMP | Creation Date |
Copyright © 2019, 2024, Oracle and/or its affiliates.