DW_FA_DISTRIBUTION_HISTORY_D

This is the Dimension table for Fixed asset Distribution History details

Details

Module: Assets

Key Columns

BOOK_TYPE_CODE, DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BOOK_TYPE_CODE VARCHAR2 32   True Unique book identification name.    
DISTRIBUTION_ID NUMBER 38 0 True Identifier of the asset distribution.    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier. Value is derived from a combination of Asset Distribution identifier.    
TRANSACTION_HEADER_ID_IN NUMBER 38 0   Identifier of the transaction that created the row.    
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 effective.    
ASSET_ID NUMBER 38 0   Identifier of the asset number.    
LOCATION_ID NUMBER 38 0   Location flexfield identification number.    
ASSIGNED_TO_ID NUMBER 38 0   Identifier of the employee to whom the asset is assigned.    
DEPRN_EXPENSE_CCID NUMBER 38 0   Identifier of the account code combination for the depreciation expense account.    
INVENTORY_DATE_TAKEN DATE       User-defined inventory taken date.    
UNITS_ASSIGNED NUMBER       Number of units assigned to the distribution.    
TRANSACTION_UNITS NUMBER       Number of units involved in the transaction. Negative value for the row from which the units were transferred away or retired. Positive value for the row to which the units were transferred to or added.    
RETIREMENT_ID NUMBER 38 0   Identifier of the asset retirement transaction.