DW_FA_ASSET_HISTORY_D

This is the Dimension table for Fixed asset history details

Details

Module: Assets

Key Columns

ASSET_ID, TRANSACTION_HEADER_ID_IN, 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     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.