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

> XRP Ledger transactions — payments, offers, trust sets, and other transaction types.

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

The `xrpl.transactions` table contains all transaction data from the XRP Ledger including payment types, account changes, and transaction metadata.

## Column Descriptions

| **Column** | **type** | **Description** |
| - | - | - |
| **account** | string | The account that initiated the transaction |
| **account\_txn\_id** | string | Unique identifier for the transaction from the account's perspective |
| **amount** | struct(currency: string, issuer: string, value: string) | The amount being transferred (for payment transactions) |
| **amount2** | struct(currency: string, issuer: string, value: string) | Secondary amount field for complex transactions |
| **asset** | struct(currency: string, issuer: string) | Asset information for token-related transactions |
| **asset2** | struct(currency: string, issuer: string) | Secondary asset information |
| **asset\_class** | string | Classification of the asset being traded |
| **auth\_accounts** | array(struct(authaccount: struct(account: string))) | Accounts authorized for this transaction |
| **authorize** | string | Account to be authorized |
| **balance** | struct(currency: string, value: string) | Balance information |
| **bid\_max** | struct(currency: string, issuer: string, value: string) | Maximum bid amount for auction transactions |
| **bid\_min** | struct(currency: string, issuer: string, value: string) | Minimum bid amount for auction transactions |
| **cancel\_after** | long | Timestamp after which the transaction should be cancelled |
| **channel** | string | Payment channel identifier |
| **check\_id** | string | Unique identifier for a check |
| **clear\_flag** | long | Flag to be cleared from the account |
| **condition** | string | Condition for conditional transactions |
| **deliver\_max** | struct(currency: string, issuer: string, value: string) | Maximum amount to deliver in a payment |
| **deliver\_min** | struct(currency: string, issuer: string, value: string) | Minimum amount to deliver in a payment |
| **destination** | string | Destination account for the transaction |
| **destination\_tag** | long | Tag for the destination account |
| **domain** | string | Domain associated with the account |
| **email\_hash** | string | Hash of the email address |
| **expiration** | long | Expiration timestamp for the transaction |
| **fee** | string | Transaction fee in drops |
| **finish\_after** | long | Timestamp after which the transaction should be finished |
| **flags** | long | Transaction flags |
| **fulfillment** | string | Fulfillment condition for conditional transactions |
| **invoice\_id** | string | Invoice identifier |
| **issuer** | string | Issuer of the token |
| **lp\_token\_in** | struct(currency: string, issuer: string, value: string) | Liquidity pool token input amount |
| **lp\_token\_out** | struct(currency: string, value: string) | Liquidity pool token output amount |
| **last\_ledger\_sequence** | long | Last ledger sequence number |
| **last\_update\_time** | long | Last update timestamp |
| **ledger\_sequence** | long | Ledger sequence number |
| **limit\_amount** | struct(currency: string, issuer: string, value: string) | Limit amount for trust lines |
| **memos** | array(struct(Memo: struct(MemoData: string, MemoFormat: string, MemoType: string))) | Transaction memos |
| **metadata** | string | Transaction metadata in JSON format |
| **nf\_token\_broker\_fee** | struct(currency: string, issuer: string, value: string) | NFT broker fee |
| **nf\_token\_buy\_offer** | string | NFT buy offer identifier |
| **nf\_token\_id** | string | NFT token identifier |
| **nf\_token\_minter** | string | NFT token minter |
| **nf\_token\_offers** | array(string) | NFT token offers |
| **nf\_token\_sell\_offer** | string | NFT sell offer identifier |
| **nf\_token\_taxon** | long | NFT token taxon |
| **offer\_sequence** | long | Offer sequence number |
| **operation\_limit** | long | Operation limit |
| **oracle\_document\_id** | long | Oracle document identifier |
| **owner** | string | Owner of the account or asset |
| **paths** | string | Payment paths for cross-currency payments |
| **previous\_txn\_id** | string | Previous transaction identifier |
| **price\_data\_series** | array(struct(PriceData: struct(AssetPrice: string, BaseAsset: String, QuoteAsset: string, Scale: long))) | Price data series |
| **provider** | string | Provider information |
| **public\_key** | string | Public key of the account |
| **quality\_in** | long | Quality in for exchange transactions |
| **quality\_out** | long | Quality out for exchange transactions |
| **regular\_key** | string | Regular key for the account |
| **send\_max** | struct(currency: string, issuer: string, value: string) | Maximum amount to send |
| **sequence** | long | Account sequence number |
| **set\_flag** | long | Flag to be set on the account |
| **settle\_delay** | long | Settlement delay |
| **signature** | string | Transaction signature |
| **signer\_entries** | array(struct(SignerEntry: struct(Account: String, SignerWeight: long))) | Signer entries for multi-signing |
| **signer\_quorum** | long | Signer quorum |
| **signers** | array(struct(Signer: struct(Account: string, SigningPubKey: string, TxnSignature: string))) | Transaction signers |
| **signing\_pub\_key** | string | Signing public key |
| **source\_tag** | long | Source tag |
| **taker\_gets** | struct(currency: string, issuer: string, value: string) | Amount the taker gets in an offer |
| **taker\_pays** | struct(currency: string, issuer: string, value: string) | Amount the taker pays in an offer |
| **tick\_size** | long | Tick size for trading |
| **ticket\_count** | long | Number of tickets |
| **ticket\_sequence** | long | Ticket sequence number |
| **trading\_fee** | long | Trading fee |
| **transaction\_type** | string | Type of transaction |
| **transfer\_fee** | long | Transfer fee |
| **transfer\_rate** | long | Transfer rate |
| **txn\_signature** | string | Transaction signature |
| **unl\_modify\_disabling** | long | UNL modify disabling flag |
| **unl\_modify\_validator** | string | UNL modify validator |
| **uri** | string | URI associated with the account |
| **hash** | string | Transaction hash |
| **ledger\_index** | long | Ledger index |
| **\_event\_created\_at** | timestamp | Event creation timestamp |
| **\_ledger\_close\_time\_human** | string | Human-readable ledger close time |
| **ledger\_close\_date** | date | Date when the ledger closed |
| **\_inserted\_at** | timestamp | Record insertion timestamp |
| **message\_key** | string | Message key |
| **e\_price** | struct(currency: string, value: string) | Exchange price |
| **unauthorize** | string | Account to be unauthorized |
| **amendment** | string | Amendment identifier |
| **\_ingested\_at** | timestamp | Data ingestion timestamp |

## Table Sample

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


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