DW_FA_ASSET_HISTORY_D

This is the Dimension table for Fixed asset history details

Details

Module: Assets

Key Columns

TRANSACTION_HEADER_ID_IN, ASSET_ID, BOOK_TYPE_CODE

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