> ## Documentation Index > Fetch the complete documentation index at: https://razorpay-881012b3.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Reports Data Schema > Explore reporting data schema on payments, refunds, settlements and more to build insightful reports.
Available in 🇮🇳 India
Create standard and custom reports from your data. Utilise our schema documentation for all entities, columns and their descriptions. ## Refunds Records details of amounts returned to customers from processed payments. Details of the available columns are listed below: | Column Name | Type | Description | Is Nullable? | | ---------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------ | | Unique Transaction Reference | String | | Yes | | Settled By | String | Indicates the entity responsible for settling the refund. | Yes | | Notes | String | Additional notes or comments related to the refund. | Yes | | Refund ID | Integer | Unique identifier for the refund. | No | | Fees | Integer | The processing fees associated with the refund. | No | | Tax | Integer | The tax amount applied to the refund. | No | | Amount | Integer | The total amount of the refund. | No | | Receipt | String | The unique receipt number for the refund. | Yes | | Currency | String | The currency in which the refund was processed (for example, 'INR'). | No | | Created At | Date/Time | Timestamp when the refund record was created. | No | | Payment ID | String | The ID of the original payment to which the refund is linked. | No | | Speed Requested | String | The requested processing speed for the refund. | No | | Status | String | The current status of the refund (for example, `processed`, `pending`, `failed`). | No | ## Transactions Captures comprehensive records of all financial movements, including debits, credits and associated fees. | Column Name | Type | Description | Is Nullable? | | ------------- | --------- | -------------------------------------------------------------------------------------- | ------------ | | Tax | Integer | The tax amount associated with the transaction. | Yes | | Debit | Integer | The debit amount the transaction. | No | | Amount | Integer | The total amount of the transaction. | No | | Credit | Integer | The credit amount of the transaction. | No | | Currency | String | The currency of the transaction. | No | | Entity ID | Integer | The ID of the entity related to this transaction (for example, payment ID, refund ID). | No | | Created At | Date/Time | Timestamp when the transaction record was created. | No | | Type | String | The type of transaction (for example, 'payment', 'refund', 'settlement'). | No | | Settled | Boolean | Indicates if the transaction has been settled (True/False). | No | | Fees | Integer | The total fees associated with the transaction. | No | | On Hold | Boolean | Indicates if the transaction amount is currently on hold (True/False). | Yes | | Settled At | Date/Time | Timestamp when the transaction record was settled. | Yes | | Settlement ID | String | The ID of the settlement associated with this transaction. | Yes | ## Orders Represents the initial request or intent to collect a payment, often preceding the actual payment capture. | Column Name | Type | Description | Is Nullable? | | ----------- | --------- | ------------------------------------------------------------------------------ | ------------ | | Order ID | String | Unique identifier for the order. | No | | Notes | String | Additional notes or comments for the order. | Yes | | Receipt | String | The unique receipt number for the order. | Yes | | Offer ID | String | The ID of any offer applied to the order. | Yes | | Updated At | Date/Time | Timestamp when the order record was last updated. | No | | Amount Paid | Integer | The total amount paid for the order. | Yes | | Amount | Integer | The total amount of the order. | No | | Status | String | The current status of the order (for example, `created`, `paid`, `fulfilled`). | No | | Attempts | Integer | The number of payment attempts made for the order. | No | | Currency | String | The currency of the order. | No | | Created At | Date/Time | Timestamp when the order was created. | No | ## UPI Metadata Stores additional details and technical information related to UPI (Unified Payments Interface) transactions. | Column Name | Type | Description | Is Nullable? | | ----------- | ------ | ----------------------------------------------- | ------------ | | Settled By | String | The tax amount associated with the transaction. | Yes | ## Disputes Manages details and statuses of chargebacks or disagreements initiated by customers regarding transactions. | Column Name | Type | Description | Is Nullable? | | ------------------ | --------- | -------------------------------------------------------------- | ------------ | | Dispute ID | String | Unique identifier for the dispute. | No | | Adjustment ID | String | Unique identifier for the adjustment. | No | | Payment ID | String | Unique identifier for the payment on which dispute was raised. | No | | Order ID | String | The ID of the order associated with this payment. | No | | Amount | Integer | The total amount of the payment. | No | | Currency | String | The currency in which the payment was made. | No | | Amount Deducted | Integer | Total amount deducted. | No | | Amount Reversed | Integer | Total amount reversed after the dispute was raised. | No | | Reason Code | String | A detailed description of the reason for the dispute. | No | | Dispute Created At | Date/Time | Timestamp when the dispute record was created. | No | | Resolved At | Date/Time | Timestamp when the dispute record was resolved. | Yes | ## Settlements Tracks the process of transferring accumulated funds from Razorpay to your linked bank account. | Column Name | Type | Description | Is Nullable? | | ---------------------------------- | --------- | ------------------------------------------------------------------------------------- | ------------ | | Created At | Date/Time | Timestamp when the settlement record was created. | No | | Settlement ID | String | Unique identifier for the settlement. | No | | UTR (Unique Transaction Reference) | String | The Unique Transaction Reference number for the settlement. | Yes | | Status | String | The current status of the settlement (for example, `processed`, `pending`, `failed`). | No | | Amount | Integer | The total amount of the settlement. | No | | Tax | Integer | The tax amount associated with the settlement. | Yes | | Fees | Integer | The total fees deducted from the settlement amount. | No | ## Payments Holds the core information about successful and failed payment attempts, including amount, method and customer details. | Column Name | Type | Description | Is Nullable? | | -------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------ | | Settled By | String | Indicates the entity that settled the payment. | Yes | | Notes | String | Additional notes or comments for the payment. | Yes | | Payment Method | String | The method used for the payment (for example, 'card', 'netbanking', 'upi', 'wallet'). | Yes | | Captured At | Date/Time | Timestamp when the payment was captured. | No | | Payment ID | String | Unique identifier for the payment. | No | | Customer Email | String | The email address of the customer who made the payment. | Yes | | Customer Contact | String | The contact number of the customer who made the payment. | Yes | | Currency | String | The currency in which the payment was made. | No | | Order ID | String | The ID of the order associated with this payment. | Yes | | Created At | Date/Time | Timestamp when the payment record was created. | No | | Status | String | The current status of the payment (for example, `captured`, `failed`, `refunded`). | No | | Amount | Integer | The total amount of the payment. | No | | Fee | Integer | The fee associated with the payment. | Yes | | Tax | Integer | The tax amount applied to the payment. | Yes | | Receiver ID | String | The ID of the receiver of the payment. | Yes | | Error Code | String | The error code if the payment failed. | Yes | | Invoice ID | String | The ID of the invoice associated with this payment. | Yes | | VPA | String | The Virtual Payment Address (VPA) used for UPI payments. | Yes | | Error Description | String | A detailed description of the error if the payment failed. | Yes | | Receiver Type | String | The type of the receiver of the payment. | Yes | | Bank | String | The bank used for the payment. | Yes | | Wallet | String | The wallet used for the payment. | Yes | | Card ID | String | The ID of the card used for the payment. | Yes | | Description | String | A general description of the payment. | Yes | | International | Boolean | Indicates if the payment was an international transaction (True/False). | Yes | | Refund Status | String | The status of any refund associated with this payment. | Yes | | Amount Refunded | Integer | The amount that has been refunded from this payment. | No | | Amount Transferred | Integer | The amount transferred out of this payment. | Yes | | Primary Transaction ID | String | Stores the main transaction identifier from payment gateways. | Yes | | Retrieval Reference Number | String | **RRN** (Retrieval Reference Number)

Mainly used for UPI transactions as a unique identifier for reconciliation and sometimes for Cards/EMI | Yes | | Auth Code | String | | Yes | | Updated At | Date/Time | Timestamp when the payment record was last updated. | No | ## Transfers Records the movement of funds from one account or entity to another within the Razorpay ecosystem. | Column Name | Type | Description | Is Nullable? | | --------------- | --------- | ---------------------------------------------------------------------- | ------------ | | Transfer ID | String | Unique identifier for the transfer. | No | | Amount | Integer | The total amount of the transfer. | No | | Currency | String | The currency of the transfer. | No | | Created At | Date/Time | Timestamp when the transfer record was created. | No | | Amount Reversed | Integer | The amount reversed from this transfer. | Yes | | Notes | String | Additional notes or comments for the transfer. | Yes | | Source Type | String | The type of the source for the transfer (for example, 'payment'). | No | | Source ID | String | The ID of the source entity for the transfer. | No | | Tax | Integer | The tax amount applied to the transfer. | Yes | | Fees | Integer | The fees associated with the transfer. | Yes | | On Hold | Boolean | Indicates if the transferred amount is currently on hold (True/False). | No | | To ID | String | The ID of the recipient of the transfer. | No | | On Hold Until | Date/Time | The timestamp until which the transferred amount is on hold. | Yes | ## Reversals Documents the reversal of previously completed transfers or other financial movements. | Column Name | Type | Description | Is Nullable? | | ----------- | --------- | ----------------------------------------------- | ------------ | | Reversal ID | String | Unique identifier for the reversal. | No | | Currency | String | The currency of the reversal. | No | | Created At | Date/Time | Timestamp when the reversal record was created. | No | | Amount | Integer | The amount of the reversal. | No | | Notes | String | Additional notes or comments for the reversal. | Yes | ## Customers Contains demographic and contact information for the individuals or businesses making payments or associated with transactions. | Column Name | Type | Description | Is Nullable? | | ---------------- | ------ | ----------------------------------- | ------------ | | Customer ID | String | Unique identifier for the customer. | No | | Customer Name | String | The full name of the customer. | Yes | | Customer Email | String | The email address of the customer. | Yes | | Customer Contact | String | The contact number of the customer. | Yes | ## Payment Links Enables the creation and management of shareable web links for collecting payments. | Column Name | Type | Description | Is Nullable? | | --------------- | ------ | --------------------------------------- | ------------ | | Payment Link ID | String | Unique identifier for the payment link. | No | | Title | String | The title or name of the payment link. | Yes | ## Contacts Stores general contact information for various entities or individuals relevant to your business operations. | Column Name | Type | Description | Is Nullable? | | -------------- | --------- | -------------------------------------------------------- | ------------ | | Contact ID | String | Unique identifier for the contact. | No | | Contact Name | String | The name of the contact. | No | | Contact Type | String | The type of contact (for example, 'customer', 'vendor'). | Yes | | Contact Email | String | The email address of the contact. | Yes | | Notes | String | Additional notes or comments for the contact. | No | | Contact Number | String | The contact number of the entity. | Yes | | Created At | Date/Time | Timestamp when the contact record was created. | No | | Reference ID | String | An external reference ID for the contact. | Yes | ## Fund Accounts Consists of details of the bank accounts or other financial instruments used for payouts and settlements. | Column Name | Type | Description | Is Nullable? | | --------------- | ------ | -------------------------------------------------------------- | ------------ | | Fund Account ID | String | Unique identifier for the fund account. | No | | Account Type | String | The type of fund account (for example, `bank_account`, `vpa`). | No | ## Credits Represents a form of balance or credit available to a merchant or customer. | Column Name | Type | Description | Is Nullable? | | ----------- | ------ | ------------------- | ------------ | | Credit Type | String | The type of credit. | No | ## Credit Transactions Records the specific actions where credits are used or adjusted. | Column Name | Type | Description | Is Nullable? | | ------------ | ------- | ---------------------------------------------- | ------------ | | Credits Used | Integer | The number of credits used in the transaction. | No | ## Payment Link (Customers) Stores customer-specific information related to interactions with payment links. | Column Name | Type | Description | Is Nullable? | | ---------------- | ------ | ----------------------------------------------------------------- | ------------ | | Customer ID | String | Unique identifier of the customer associated with a payment link. | Yes | | Customer Name | String | The name of the customer. | Yes | | Customer Email | String | The email address of the customer. | Yes | | Customer Contact | String | The contact number of the customer. | Yes | ## Offshore Remittance Information about payments made to foreign bank accounts. | Column Name | Type | Description | Is Nullable? | | ------------------------ | --------- | ------------------------------------------------------------------------------------------------- | ------------ | | Merchant ID | String | Unique identifier of the merchant | No | | Settlements ID | String | Unique identifier of the settlement associated with the transaction | No | | Transaction ID | String | Unique identifier of the transaction | No | | Type | String | The type of transaction carried out. For example, `payment`, `refund`. | No | | Order ID | String | Unique identifier for the order. | No | | Transaction Date | Date/Time | Timestamp when the transaction record was made. | No | | Transaction Currency | String | The currency in which the transaction was made. | No | | Gross Transaction Amount | Integer | The total amount of the transaction inclusive of the tax component. | No | | MDR | Integer | Fee charged by Razorpay for each debit or credit transaction made. | No | | Tax | Integer | The tax amount applied to the transaction. | No | | Net Transaction Amount | Integer | The actual amount transacted, excluding taxes and fees. | No | | Net Debit | Integer | The amount debited from the account as part of the transaction. | No | | Net Credit | Integer | The amount credited to the account as part of the transaction. | No | | MTS Reference Number | String | Unique identifier generated by the payment gateway or processing system. | No | | Offshore Remittance Date | Date/Time | Timestamp when the amount was credited to the receiver's account. | No | | Total Offshore | Integer | Total amount of transaction made for a particular MTS Reference Number (in the foreign currency). | No | | Remittance Currency | String | Currency used for the offshore transaction. For example, `USD`. | No | | Total Amount | Integer | Total amount of transaction made for a particular MTS Reference Number (in the local currency). | No | | Domestic Currency | String | Domestic currency used for the transaction. For example, `INR`. | No | | Notes | String | Additional notes or comments related to the offshore remittance. | Yes |