Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Razorpay connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Razorpay connector and the associated fields and tables.
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.
Fields
Field Name |
Data Type |
|---|---|
id |
STRING |
entity |
STRING |
email |
STRING |
created_at |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
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.
Fields
Field Name |
Data Type |
|---|---|
id |
STRING |
entity |
STRING |
payment_id |
STRING |
amount |
NUMERIC |
currency |
STRING |
amount_deducted |
NUMERIC |
gateway_dispute_id |
STRING |
reason_code |
STRING |
reason_description |
STRING |
respond_by |
NUMERIC |
status |
STRING |
phase |
STRING |
created_at |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC
|
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.
Fields
Field Name |
Data Type |
|---|---|
id |
STRING |
active |
BOOLEAN |
name |
STRING |
currency |
STRING |
type |
STRING |
tax_inclusive |
BOOLEAN |
created_at |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC
|
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.
Fields
Field Name |
Data Type |
|---|---|
id |
STRING |
entity |
STRING |
amount |
NUMERIC |
amount_paid |
NUMERIC |
amount_due |
NUMERIC |
currency |
STRING |
receipt |
STRING |
offer_id |
STRING |
offers |
STRING |
status |
STRING |
attempts |
NUMERIC |
notes |
RECORD |
created_at |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC
|
Payments
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.
Fields
Field Name |
Data Type |
|---|---|
id |
STRING |
entity |
STRING |
amount |
NUMERIC |
currency |
STRING |
status |
STRING |
order_id |
STRING |
international |
BOOLEAN |
method |
STRING |
amount_refunded |
NUMERIC |
captured |
BOOLEAN |
description |
STRING |
bank |
STRING |
email |
STRING |
contact |
STRING |
notes |
RECORD |
acquirer_data |
RECORD |
created_at |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC
|
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.
Fields
Field Name |
Data Type |
|---|---|
id |
STRING |
entity |
STRING |
created_at |
NUMERIC |
name |
STRING |
usage |
STRING |
type |
STRING |
image_url |
STRING |
status |
STRING |
fixed_amount |
BOOLEAN |
payments_amount_received |
NUMERIC |
payments_count_received |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
Refunds
Razorpay Refunds API retrieves information about all refunds or one specific refund using a unique identifier. For more information, see Razorpay Refunds.
Fields
Field Name |
Data Type |
|---|---|
acquirer_data |
RECORD |
amount |
NUMERIC |
created_at |
NUMERIC |
currency |
STRING |
entity |
STRING |
id |
STRING |
notes |
RECORD |
payment_id |
STRING |
speed_processed |
STRING |
speed_requested |
STRING |
status |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
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.
Fields
Field Name |
Data Type |
|---|---|
id |
STRING |
entity |
STRING |
amount |
NUMERIC |
status |
STRING |
fees |
NUMERIC |
tax |
NUMERIC |
utr |
STRING |
created_at |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |