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

# xrpl.transactions_base

> The 'xrpl.transactions_base' table contains every validated transaction recorded on the XRP Ledger, covering payments, token operations, DEX trades, NFT activity, and more.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table Description

Contains every validated transaction recorded on the XRP Ledger, covering payments, token operations, DEX trades, NFT activity, and more. Use this table to analyze on-chain transaction volume, fees, outcomes, and account behavior over time.

## Column Descriptions

| **Column**                   | **type**                                                                           | **Description**                                                                                                                  |
| ---------------------------- | ---------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------- |
| **transaction\_id**          | bigint                                                                             | Unique surrogate primary key for the transaction record                                                                          |
| **transaction\_hash**        | string                                                                             | Cryptographic hash uniquely identifying the transaction on the XRP Ledger; used for cross-referencing with on-chain data         |
| **transaction\_type**        | string                                                                             | Transaction category (e.g., Payment, OfferCreate, TrustSet, NFTokenMint); determines applicable fields and behavior              |
| **transaction\_result**      | string                                                                             | Final outcome code (e.g., tesSUCCESS, tecNO\_DST), indicating whether the transaction succeeded or the reason for failure        |
| **ledger\_close\_date**      | date                                                                               | Calendar date the ledger containing this transaction was closed                                                                  |
| **ledger\_close\_time**      | timestamp                                                                          | Precise timestamp the ledger was closed and the transaction was confirmed                                                        |
| **ledger\_index**            | bigint                                                                             | Sequence number of the ledger in which this transaction was included                                                             |
| **transaction\_index**       | bigint                                                                             | Position of this transaction within its ledger, reflecting execution order                                                       |
| **transaction\_fee**         | decimal(38,6)                                                                      | XRP fee consumed by this transaction, expressed in XRP                                                                           |
| **account\_id**              | bigint                                                                             | Surrogate key for the sending account (→ accounts)                                                                               |
| **account\_address**         | string                                                                             | XRPL address of the transaction sender                                                                                           |
| **destination\_id**          | bigint                                                                             | Surrogate key for the receiving account (→ accounts)                                                                             |
| **destination\_address**     | string                                                                             | XRPL address of the transaction recipient                                                                                        |
| **destination\_tag**         | bigint                                                                             | Off-ledger routing tag identifying the intended beneficiary at the destination address (e.g., a customer account at an exchange) |
| **account\_transaction\_id** | string                                                                             | Chained hash linking to the sender's previous transaction, used to enforce transaction ordering                                  |
| **delivered\_amount**        | struct(currency: string, issuer: string, value: string, mpt\_issuance\_id: string) | Actual amount delivered to the destination, structured with currency, issuer, value, and MPT issuance ID                         |
| **flags**                    | bigint                                                                             | Bitwise integer encoding transaction-specific behavior modifiers                                                                 |
| **last\_ledger\_sequence**   | bigint                                                                             | Maximum ledger index at which the transaction remains valid; used to bound transaction expiry                                    |
| **memos**                    | array(json)                                                                        | Array of arbitrary key-value memo objects attached to the transaction for off-ledger annotation or metadata                      |
| **signers**                  | array(json)                                                                        | Array of signers for multi-signature transactions, each containing account, public key, and signature                            |
| **signing\_pub\_key**        | string                                                                             | Hex-encoded public key used to authorize a single-signed transaction                                                             |
| **source\_tag**              | bigint                                                                             | Off-ledger routing tag identifying the originating customer or purpose at the sending address                                    |
| **ticket\_sequence**         | bigint                                                                             | Sequence number of the ticket used in place of a standard account sequence, enabling out-of-order transaction submission         |
| **transaction\_sequence**    | bigint                                                                             | Account sequence number ensuring replay protection and ordering for transactions from the same sender                            |
| **transaction\_signature**   | string                                                                             | Cryptographic signature proving the transaction was authorized by the account's private key                                      |
| **uri**                      | string                                                                             | URI associated with the transaction, typically used in NFT-related transactions to reference off-chain metadata                  |

## Table Sample

<TableSample tableSchema="xrpl" tableName="transactions_base" />