This table contains the main data source for the Transaction Audit Trail. Contains the history of transactions and their changes.
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 |
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 |