Cmdlets for BigCommerce

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060