> ## 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 🌱

### Table Details

| Property            | Value                                       |
| ------------------- | ------------------------------------------- |
| Table Name          | `stellar_testnet.raw.transactions`          |
| Table Status        | Beta 🌱                                     |
| Unique Key          | `ledger_close_time`, `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) | The hash of the transaction                                                                                                                                                                    |
| transaction\_index                             | NUMBER(38,0)      | The index of the transaction within the ledger                                                                                                                                                 |
| source\_account                                | VARCHAR(16777216) | The account that submitted the transaction                                                                                                                                                     |
| source\_account\_muxed                         | VARCHAR(16777216) | The muxed account address (if applicable)                                                                                                                                                      |
| source\_account\_sequence                      | NUMBER(38,0)      | The sequence number of the source account                                                                                                                                                      |
| transaction\_result                            | VARCHAR(16777216) | The result code of the transaction                                                                                                                                                             |
| successful                                     | BOOLEAN           | Whether the transaction was successful                                                                                                                                                         |
| memo\_type                                     | VARCHAR(16777216) | The type of memo attached to the transaction                                                                                                                                                   |
| memo                                           | VARCHAR(16777216) | The memo text (if applicable)                                                                                                                                                                  |
| memo\_bytes                                    | VARCHAR(16777216) | The memo as bytes (if applicable)                                                                                                                                                              |
| transaction\_max\_fee                          | NUMBER(38,0)      | The maximum fee specified for the transaction                                                                                                                                                  |
| inner\_transaction\_max\_fee                   | NUMBER(38,0)      | The maximum fee for inner transactions                                                                                                                                                         |
| fee\_charged                                   | NUMBER(38,0)      | The actual fee charged for the transaction                                                                                                                                                     |
| total\_non\_refundable\_resource\_fee\_charged | NUMBER(38,0)      | Total non-refundable resource fees charged                                                                                                                                                     |
| total\_refundable\_resource\_fee\_charged      | NUMBER(38,0)      | Total refundable resource fees charged                                                                                                                                                         |
| resource\_fee\_charged                         | NUMBER(38,0)      | Resource fees charged for the transaction                                                                                                                                                      |
| inclusion\_fee\_charged                        | NUMBER(38,0)      | Fee charged for including the transaction in the ledger                                                                                                                                        |
| resource\_fee\_refund                          | NUMBER(38,0)      | Resource fees refunded                                                                                                                                                                         |
| fee\_account                                   | VARCHAR(16777216) | The account that paid the fee                                                                                                                                                                  |
| fee\_account\_muxed                            | VARCHAR(16777216) | The muxed fee account address (if applicable)                                                                                                                                                  |
| fee\_account\_muxed\_id                        | VARCHAR(16777216) | The muxed ID of the fee account                                                                                                                                                                |
| fee\_bump\_transaction                         | VARIANT           | Whether this is a fee bump transaction                                                                                                                                                         |
| envelope\_xdr                                  | VARCHAR(16777216) | The transaction envelope in XDR format                                                                                                                                                         |
| fee\_meta\_xdr                                 | VARCHAR(16777216) | The fee metadata in XDR format                                                                                                                                                                 |
| result\_xdr                                    | VARCHAR(16777216) | The transaction result in XDR format                                                                                                                                                           |
| result\_meta\_xdr                              | VARCHAR(16777216) | The result metadata in XDR format                                                                                                                                                              |
| preconditions                                  | VARIANT           | Transaction preconditions                                                                                                                                                                      |
| inner\_transaction                             | VARIANT           | Whether this is an inner transaction                                                                                                                                                           |
| signatures                                     | VARCHAR(16777216) | Transaction signatures                                                                                                                                                                         |
| ledger\_sequence                               | NUMBER(38,0)      | The sequence number of the ledger containing this transaction                                                                                                                                  |
| ledger\_close\_time                            | TIMESTAMP\_NTZ(9) | The close time of the ledger containing this transaction                                                                                                                                       |
| ledger\_hash                                   | VARCHAR(16777216) | The hash of the ledger containing this transaction                                                                                                                                             |
| operation\_count                               | NUMBER(38,0)      | The number of operations in this transaction                                                                                                                                                   |
| \_extra\_fields                                | VARIANT           | Additional fields not explicitly defined                                                                                                                                                       |
| transaction\_events                            | VARIANT           | List of Soroban transaction-scoped events emitted during transaction execution, as JSON. These are events not tied to a specific operation (e.g. fee events, transaction-level state changes). |
| \_created\_at                                  | TIMESTAMP\_NTZ(9) | Timestamp when this record was created                                                                                                                                                         |
| \_updated\_at                                  | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated                                                                                                                                                    |

### Related Docs

* [Stellar Raw Transactions](/historical-data/supported-blockchains/other-ecosystems/stellar/raw/transactions)