ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders
Links payout balance transaction adjustments back to the originating orders for reconciliation.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- ShopifyPaymentsAccountBalanceTransactionId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders WHERE ShopifyPaymentsAccountBalanceTransactionId = 'Val1'
Columns
| Name | Type | References | Description |
| Link [KEY] | String | The direct link to the order associated with the balance adjustment, allowing reference to the originating transaction in Shopify. | |
| Name | String | The name or identifier of the order that caused the balance adjustment, typically matching the Shopify order number. | |
| Amount | Decimal | The monetary value of the adjustment applied to the order, represented as a decimal amount. | |
| AmountCurrencyCode | String | The three-letter ISO currency code corresponding to the currency of the adjustment amount (for example, USD or EUR). | |
| ShopifyPaymentsAccountBalanceTransactionId [KEY] | String | The globally unique identifier linking this adjustment record to the corresponding Shopify Payments balance transaction. |