OrderRefundsPayments
Refund payments made to payment providers.
Table Specific Information
Select
The cmdlet uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- OrderId supports the '=, IN' comparison.
- OrderRefundsId supports the '=, IN' comparison.
The rest of the filter is executed client-side within the cmdlet.
For example, the following queries are processed server-side:
SELECT * FROM OrderRefundsItems WHERE OrderRefundId = 2 SELECT * FROM OrderRefundsPayments WHERE OrderId = 2
Columns
Name | Type | References | Description |
Id [KEY] | Integer | The ID of the refund payment. | |
OrderRefundId | Integer |
OrderRefunds.Id | The ID of the order refund. |
OrderId | Integer |
OrderRefunds.OrderId | 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. |