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.
Table Description
Contains all successful direct, same-asset Payment transactions on the XRP Ledger, one row per transfer. Only includes transfers where the sender and recipient transact in the same currency — cross-currency and DEX-routed payments are excluded.Column Descriptions
| Column | type | Description |
|---|---|---|
| transfer_id | bigint | Unique surrogate primary key for this transfer record |
| ledger_close_date | date | Calendar date the ledger containing this transfer was closed |
| transaction_id | bigint | Surrogate key linking to the transaction (→ transactions) |
| transaction_hash | string | Cryptographic hash uniquely identifying this transaction on the XRP Ledger |
| transaction_type | string | Type of transaction that generated this transfer (e.g. Payment) |
| timestamp | timestamp | Precise timestamp when the ledger containing this transfer was closed and confirmed |
| memo | string | First memo attached to the transaction, decoded from hex; used for off-ledger context such as payment references or identifiers |
| transaction_fee | double | XRP fee consumed by this transaction, expressed in XRP |
| account_id | bigint | Surrogate key for the account that sent this transfer (→ accounts) |
| account_address | string | XRPL address of the sending account |
| account_balance_before | double | Sender’s asset balance immediately before this transfer was applied |
| account_balance_after | double | Sender’s asset balance immediately after this transfer was applied |
| destination_id | bigint | Surrogate key for the account that received this transfer (→ accounts) |
| destination_address | string | XRPL address of the receiving account |
| destination_balance_before | double | Recipient’s asset balance immediately before this transfer was applied |
| destination_balance_after | double | Recipient’s asset balance immediately after this transfer was applied |
| amount_token_id | bigint | Surrogate key for the token specified as the intended transfer amount (→ tokens) |
| amount_currency | string | Currency code of the intended transfer amount |
| amount_currency_iso | string | ISO 4217 currency code of the intended transfer amount, if applicable |
| amount_issuer_address | string | XRPL address of the issuer of the intended transfer currency; null if XRP |
| amount_value | double | Intended amount to deliver; for partial payments this is a maximum, not a guarantee — use delivered_amount_value for the actual amount received |
| delivered_amount_token_id | bigint | Surrogate key for the token actually delivered to the destination (→ tokens) |
| delivered_amount_currency | string | Currency code of the amount actually received by the destination |
| delivered_amount_currency_iso | string | ISO 4217 currency code of the delivered amount, if applicable |
| delivered_amount_issuer_address | string | XRPL address of the issuer of the delivered currency; null if XRP |
| delivered_amount_value | double | Actual amount received by the destination after fees and exchange rates; always use this field — not amount_value — to measure true transfer value |
| deliver_min_token_id | bigint | Surrogate key for the token used to express the minimum delivery threshold (→ tokens); only set on partial payments |
| deliver_min_currency | string | Currency code of the minimum delivery threshold |
| deliver_min_currency_iso | string | ISO 4217 currency code of the deliver minimum, if applicable |
| deliver_min_issuer_address | string | XRPL address of the issuer of the deliver minimum currency; null if XRP |
| deliver_min_value | double | Minimum amount the sender required to be delivered for the partial payment to succeed; null for non-partial payments |
| send_max_token_id | bigint | Surrogate key for the token used to express the sender’s spending cap (→ tokens) |
| send_max_currency | string | Currency code the sender was willing to spend |
| send_max_currency_iso | string | ISO 4217 currency code of the send maximum, if applicable |
| send_max_issuer_address | string | XRPL address of the issuer of the send maximum currency; null if XRP |
| send_max_value | double | Maximum amount the sender was willing to spend, including transfer fees and exchange costs |