# DW_FA_ASSET_HISTORY_D

This is the Dimension table for Fixed asset history details

## Details

Module: Assets

## Key Columns

BOOK_TYPE_CODE, TRANSACTION_HEADER_ID_IN, ASSET_ID

## Columns

Columns
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_EFFECTIVE_1 | DATE |  |  |  | Date when the row became effective. |  |
DATE_INEFFECTIVE | TIMESTAMP |  |  |  | Date when the row became inactive. |  |
DATE_INEFFECTIVE_1 | DATE |  |  |  | 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, 2026, Oracle and/or its affiliates.