JDBC Driver for BigCommerce

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462