OrderRefundsPayments
Refund payments made to payment providers.
Table Specific Information
Select
The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- OrderId supports the = and IN comparisons.
- OrderRefundsId supports the = and IN comparisons.
The rest of the filter is executed client-side within the driver.
For example, the following queries are processed server-side:
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. |