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