> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Transactions V2

### Table Details

| Property            | Value                                       |
| ------------------- | ------------------------------------------- |
| Table Name          | `stellar.raw.transactions_v2`               |
| Table Status        | Production-Ready                            |
| Unique Key          | `hash`                                      |
| Clustering Key(s)   | `to_date("ledger_close_time")`              |
| Search Optimization | `hash`, `ledger_sequence`, `source_account` |

### Table Columns

| Column Name                                    | Data Type         | Description                                                                                         |
| ---------------------------------------------- | ----------------- | --------------------------------------------------------------------------------------------------- |
| hash                                           | VARCHAR(16777216) | Hash of this transaction.                                                                           |
| transaction\_index                             | NUMBER(38,0)      | Position of the transaction within its ledger.                                                      |
| source\_account                                | VARCHAR(16777216) | Account (G-address) that created and signed this transaction.                                       |
| source\_account\_muxed                         | VARCHAR(16777216) | Multiplexed (M-address) form of the source account, if used.                                        |
| source\_account\_sequence                      | NUMBER(38,0)      | Sequence number of the source account at the time of this transaction.                              |
| transaction\_result                            | VARCHAR(16777216) | Transaction result code.                                                                            |
| successful                                     | BOOLEAN           | True if this transaction was included in a ledger and executed without errors.                      |
| memo\_type                                     | VARCHAR(16777216) | Type of memo attached to this transaction (none, text, id, hash, return).                           |
| memo                                           | VARCHAR(16777216) | Memo attached to this transaction.                                                                  |
| memo\_bytes                                    | VARCHAR(16777216) | Raw bytes of the transaction memo (for memo\_type hash or return).                                  |
| transaction\_max\_fee                          | NUMBER(38,0)      | Maximum fee the sender authorized for this transaction, in stroops.                                 |
| inner\_transaction\_max\_fee                   | NUMBER(38,0)      | Maximum fee set on the inner transaction of a fee-bump, in stroops.                                 |
| fee\_charged                                   | NUMBER(38,0)      | Actual fee charged for this transaction, in stroops.                                                |
| total\_non\_refundable\_resource\_fee\_charged | NUMBER(38,0)      | Soroban resource fees charged that are non-refundable regardless of execution result, in stroops.   |
| total\_refundable\_resource\_fee\_charged      | NUMBER(38,0)      | Soroban resource fees charged that are refundable if execution uses less than budgeted, in stroops. |
| resource\_fee\_charged                         | NUMBER(38,0)      | Resource fee charged for Soroban execution, in stroops.                                             |
| inclusion\_fee\_charged                        | NUMBER(38,0)      | Fee charged for including this transaction in the ledger, in stroops.                               |
| resource\_fee\_refund                          | NUMBER(38,0)      | Unused resource fee refunded to the sender after Soroban execution, in stroops.                     |
| fee\_account                                   | VARCHAR(16777216) | Account (G-address) that paid the transaction fees.                                                 |
| fee\_account\_muxed                            | VARCHAR(16777216) | Multiplexed (M-address) form of the fee-paying account, if used.                                    |
| fee\_account\_muxed\_id                        | VARCHAR(16777216) | 64-bit sub-account id of the multiplexed fee-paying account.                                        |
| fee\_bump\_transaction                         | VARIANT           | Details of the fee-bump wrapper transaction, if this is a fee-bump.                                 |
| envelope\_xdr                                  | VARCHAR(16777216) | Base64-encoded XDR of the full transaction envelope including signatures.                           |
| fee\_meta\_xdr                                 | VARCHAR(16777216) | Base64-encoded XDR of the fee metadata for this transaction.                                        |
| result\_xdr                                    | VARCHAR(16777216) | Base64-encoded XDR of the transaction execution result.                                             |
| result\_meta\_xdr                              | VARCHAR(16777216) | Base64-encoded XDR of the transaction result metadata including all ledger changes.                 |
| preconditions                                  | VARIANT           | Preconditions on this transaction (time bounds, ledger bounds, etc.).                               |
| inner\_transaction                             | VARIANT           | The inner (wrapped) transaction in a fee-bump transaction.                                          |
| signatures                                     | VARCHAR(16777216) | Decorated signatures authorizing this transaction.                                                  |
| ledger\_sequence                               | NUMBER(38,0)      | Sequence number of the ledger containing this transaction.                                          |
| ledger\_close\_time                            | TIMESTAMP\_NTZ(9) | Time when the ledger containing this transaction closed and was finalized.                          |
| ledger\_hash                                   | VARCHAR(16777216) | Hash of the ledger containing this transaction.                                                     |
| operation\_count                               | NUMBER(38,0)      | Number of operations included in this transaction.                                                  |
| \_extra\_fields                                | VARIANT           | Catch-all of additional source fields not mapped to a dedicated column.                             |
| \_created\_at                                  | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                            |
| \_updated\_at                                  | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                       |
| transaction\_events                            | VARIANT           | Array of token-transfer and SEP-41 events emitted in the transaction.                               |