> ## 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" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.