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

> The 'xrpl.transfers' table contains all successful direct, same-asset Payment transactions on the XRP Ledger, one row per transfer.

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

## Table Sample

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


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