Transaction_history

This table contains the main data source for the Transaction Audit Trail. Contains the history of transactions and their changes.

Columns

Name Type Length Precision Scale References In Description
account_id NUMBER 39 0 account_id
Accounts
Account ID
action VARCHAR2 8 The type of change made
amount NUMBER 20 2 Amount
date_time TIMESTAMP The timestamp of the change
date_transaction TIMESTAMP The transaction date
document_number VARCHAR2 138 The document number of the transaction
entity_id NUMBER 39 0 entity_id
Entity
Entity ID
transaction_id NUMBER 39 0 transaction_id
Transactions
Internal transaction ID
transaction_number VARCHAR2 138 Transaction number
transaction_type VARCHAR2 8 Transaction type
user_id NUMBER 39 0 entity_id
Entity
User ID

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
transaction_history_accounts_fk account_id Accounts account_id 1
transaction_history_entity_fk user_id Entity entity_id 1
transaction_history_entity_fk_2 entity_id Entity entity_id 1
transaction_history_transactions_fk transaction_id Transactions transaction_id 1