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