> ## 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        | `ton_testnet.raw.transactions` |
| Table Status      | Beta 🌱                        |
| Unique Key        | `utime`, `hash`                |
| Clustering Key(s) | `to_date("utime")`             |

### Table Columns

| Column Name            | Data Type         | Description                                                                                                      |
| ---------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------- |
| account                | VARCHAR(16777216) | The account involved in the transaction.                                                                         |
| account\_state\_after  | VARIANT           | The state of the account after the transaction.                                                                  |
| account\_state\_before | VARIANT           | The state of the account before the transaction.                                                                 |
| workchain              | NUMBER(38,0)      | The workchain identifier where the transaction occurred.                                                         |
| shard                  | VARCHAR(16777216) | The shard identifier where the transaction occurred.                                                             |
| seqno                  | NUMBER(38,0)      | The sequence number of the transaction.                                                                          |
| aborted                | BOOLEAN           | Indicates if the transaction was aborted.                                                                        |
| action                 | VARIANT           | Details of the action performed in the transaction.                                                              |
| compute\_ph            | VARIANT           | Compute phase details of the transaction.                                                                        |
| credit\_first          | BOOLEAN           | Indicates if the transaction has a credit phase first.                                                           |
| credit\_ph             | VARIANT           | Credit phase details of the transaction.                                                                         |
| destroyed              | BOOLEAN           | Indicates if the account was destroyed.                                                                          |
| storage\_ph            | VARIANT           | Storage phase details of the transaction.                                                                        |
| type                   | VARCHAR(16777216) | The type of the transaction.                                                                                     |
| end\_status            | VARCHAR(16777216) | The status of the account at the end of the transaction.                                                         |
| hash                   | VARCHAR(16777216) | The hash of the transaction.                                                                                     |
| in\_msg\_hash          | VARCHAR(16777216) | The hash of the inbound message associated with the transaction.                                                 |
| lt                     | NUMBER(38,0)      | The logical time of the transaction.                                                                             |
| mc\_block\_seqno       | NUMBER(38,0)      | The masterchain block sequence number.                                                                           |
| utime                  | TIMESTAMP\_NTZ(9) | The Unix timestamp of the transaction.                                                                           |
| orig\_status           | VARCHAR(16777216) | The original status of the account before the transaction.                                                       |
| out\_msgs\_count       | NUMBER(38,0)      | The count of outbound messages generated by the transaction.                                                     |
| prev\_trans\_hash      | VARCHAR(16777216) | The hash of the previous transaction.                                                                            |
| prev\_trans\_lt        | NUMBER(38,0)      | The logical time of the previous transaction.                                                                    |
| total\_fees            | NUMBER(38,0)      | The total fees paid for the transaction.                                                                         |
| transaction\_index     | NUMBER(38,0)      | The index of the transaction within the block.                                                                   |
| in\_msg                | VARIANT           | The full inbound message that triggered the transaction, including source, destination, value, and body payload. |
| \_created\_at          | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                                                                 |
| \_updated\_at          | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                                                                   |

### Related Docs

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