> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/payments/razorpay/schema-information.md).

# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Razorpay connector:

* Customers
* Disputes
* Items
* Orders
* Payments
* QR\_codes
* Refunds
* Settlements 

#### Customers 

Razorpay Customers API allows you to add or create a customer by providing basic details such as name, email, and contact information to use for the various Razorpay solutions. For more information, see [Razorpay Customers](https://razorpay.com/docs/api/customers/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Disputes

A dispute is a situation where a customer or the issuing bank questions the validity of payments. Razorpay Disputes API allows you to view all disputes or view a dispute by its ID. For more information, see [Razorpay Disputes](https://razorpay.com/docs/payments/disputes/apis/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>payment_id</td><td>STRING</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>amount_deducted</td><td>NUMERIC</td></tr><tr><td>gateway_dispute_id</td><td>STRING</td></tr><tr><td>reason_code</td><td>STRING</td></tr><tr><td>reason_description</td><td>STRING</td></tr><tr><td>respond_by</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>phase</td><td>STRING</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Items

Razorpay Items API retrieves information about all items ordered on your website or app by a customer or one specific item. For more information, see [Razorpay Items](https://razorpay.com/docs/api/payments/items/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>active</td><td>BOOLEAN</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>tax_inclusive</td><td>BOOLEAN</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Orders

Orders APIs are used to create, update and retrieve details of Orders. Also, you can retrieve details of payments made towards these Orders. For more information, see [Razorpay Orders](https://razorpay.com/docs/api/orders/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>amount_paid</td><td>NUMERIC</td></tr><tr><td>amount_due</td><td>NUMERIC</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>receipt</td><td>STRING</td></tr><tr><td>offer_id</td><td>STRING</td></tr><tr><td>offers</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>attempts</td><td>NUMERIC</td></tr><tr><td>notes</td><td>RECORD</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Payments&#x20;

Razorpay Payments APIs are used to capture and fetch payments. You can also fetch payments based on orders and card details of payment. For more information, see [Razorpay Payments](https://razorpay.com/docs/api/payments/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>order_id</td><td>STRING</td></tr><tr><td>international</td><td>BOOLEAN</td></tr><tr><td>method</td><td>STRING</td></tr><tr><td>amount_refunded</td><td>NUMERIC</td></tr><tr><td>captured</td><td>BOOLEAN</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>bank</td><td>STRING</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>contact</td><td>STRING</td></tr><tr><td>notes</td><td>RECORD</td></tr><tr><td>acquirer_data</td><td>RECORD</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### QR\_codes

Razorpay QR codes API are used to create QR Codes and share them with customers to accept digital payments. For more information, see [Razorpay Refunds](https://razorpay.com/docs/api/refunds/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>usage</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>fixed_amount</td><td>BOOLEAN</td></tr><tr><td>payments_amount_received</td><td>NUMERIC</td></tr><tr><td>payments_count_received</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Refunds&#x20;

Razorpay Refunds API retrieves information about all refunds or one specific refund using a unique identifier. For more information, see [Razorpay Refunds](https://razorpay.com/docs/api/refunds/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>acquirer_data</td><td>RECORD</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>notes</td><td>RECORD</td></tr><tr><td>payment_id</td><td>STRING</td></tr><tr><td>speed_processed</td><td>STRING</td></tr><tr><td>speed_requested</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Settlements

Razorpay Settlements is the process in which the money received from your customers is settled in your bank account. For more information, see [Razorpay Settlements](https://razorpay.com/docs/api/settlements/).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>entity</td><td>STRING</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>fees</td><td>NUMERIC</td></tr><tr><td>tax</td><td>NUMERIC</td></tr><tr><td>utr</td><td>STRING</td></tr><tr><td>created_at</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>