DW_FA_INTER_ASSET_TRANSACTIONS_EN

This is the Enity table for Fixed asset inter-asset transactions details

Details

Module: Assets

Key Columns

TRX_REFERENCE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TRX_REFERENCE_ID NUMBER 38 0 True Identifier of the transaction reference which links transactions involving multiple assets.    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier. Value is derived from a combination of Asset Transaction header identifiers.    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 64     Subledger Linkage Header Entity Identifier    
TRANSACTION_TYPE VARCHAR2 32     Classification of the inter-asset transaction.    
SRC_TRANSACTION_SUBTYPE VARCHAR2 32     Further detail of the transaction type for source asset.    
DEST_TRANSACTION_SUBTYPE VARCHAR2 32     Further detail of the transaction type for destination asset.    
BOOK_TYPE_CODE VARCHAR2 32     Unique book identification name.    
SRC_ASSET_ID NUMBER 38 0   Identifier of the source asset on which the transaction occurred.    
SRC_TRANSACTION_HEADER_ID NUMBER 38 0   Identifier of the source transaction.    
DEST_ASSET_ID NUMBER 38 0   Identifier of the destination asset on which the transaction occurred.    
DEST_TRANSACTION_HEADER_ID NUMBER 38 0   Identifier of the destination transaction.    
MEMBER_ASSET_ID NUMBER 38 0   Identification number of the member asset.    
MEMBER_TRANSACTION_HEADER_ID NUMBER 38 0   Identifier of the member asset transaction which spawned this transaction for the group asset.    
SRC_AMORTIZATION_START_DATE DATE       Amortization start date for the source asset transaction.    
DEST_AMORTIZATION_START_DATE DATE       Amortization start date for the destination asset transaction.    
RESERVE_TRANSFER_AMOUNT NUMBER       Reserve amount transferred between assets.    
SRC_EXPENSE_AMOUNT NUMBER       Amount entered for catch-up depreciation expense on the source asset transaction.    
DEST_EXPENSE_AMOUNT NUMBER       Amount entered for catch-up depreciation expense on the destination asset transaction.    
SRC_EOFY_RESERVE NUMBER       Amount entered for the reserve of the prior fiscal year for the source asset.    
DEST_EOFY_RESERVE NUMBER       Depreciation reserve of the destination asset at the end of the previous fiscal year.    
EVENT_ID NUMBER 38 0   Identifier of the transaction event which is associated with this row for accounting purposes.    
INVOICE_TRANSACTION_ID NUMBER 38 0   Unique identifier of the invoice transaction.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row.    
LAST_UPDATE_LOGIN VARCHAR2 64     Who column: indicates the session login associated to the user who last updated the row.    
OBJECT_VERSION_NUMBER NUMBER 38 0   Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.