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