OrderRefundsPayments

Refund payments made to payment providers.

Table Specific Information

Select

The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

OrderId supports the '=, IN' comparison.
OrderRefundsId supports the '=, IN' comparison.

For example, the following queries are processed server side:

SELECT * FROM OrderRefundsPayments

SELECT * FROM OrderRefundsItems where OrderRefundId=2

SELECT * FROM OrderRefundsPayments where OrderId=2

Columns


Name	Type	Description
Id [KEY]	Integer	The ID of the refund payment.
OrderRefundId	Integer	The ID of the order refund.
OrderId	Integer	Reference to order id.
ProviderId	String	Reference to payment provider.
Amount	Decimal	A non-negative 2 decimal place rounded value that represents the amount that can be charged/refunded via payment providers.
Offline	Boolean	Indicate whether payment was offline.
IsDeclined	Boolean	Indicate if this payment has been declined by payment provider.
DeclinedMessage	String	Message indicate why payment was declined.

JDBC Driver for BigCommerce

OrderRefundsPayments

Table Specific Information

Select

Columns