AppSubscriptionLineItems
Contains details of app subscription line items, including plan names, billing intervals, and pricing.
Table-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.
- AppInstallationId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM AppSubscriptionLineItems WHERE AppInstallationId = 'Val1'
Update
The following columns can be updated:
UsagePricingPlanCappedAmount, UsagePricingPlanCappedAmountCurrencyCode
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the subscription line item record. | |
| AppSubscriptionId | String | True |
The unique identifier of the app subscription associated with this line item. | |
| AppInstallationId | String | True |
The unique identifier of the app installation linked to the subscription line item. | |
| RecurringPricingPlanDiscountDurationLimitInIntervals | Int | True |
The total number of billing intervals during which the discount will be applied. If blank, the discount continues indefinitely. | |
| RecurringPricingPlanDiscountPriceAfterDiscountAmount | Decimal | True |
The subscription price charged to the merchant after the discount is applied, expressed as a decimal money amount. | |
| RecurringPricingPlanDiscountPriceAfterDiscountCurrencyCode | String | True |
The currency code for the discounted subscription price. | |
| RecurringPricingPlanDiscountRemainingDurationInIntervals | Int | True |
The number of remaining billing intervals in which the current discount will still apply. | |
| RecurringPricingPlanValueAmount | Decimal | True |
The monetary value of the discount applied to the subscription for each billing interval. | |
| RecurringPricingPlanValueAmountCurrencyCode | String | True |
The currency code for the recurring discount value applied each billing interval. | |
| RecurringPricingPlanValuePercentage | Double | True |
The percentage-based value of the recurring discount applied to the subscription. | |
| RecurringPricingPlanInterval | String | True |
The frequency or billing cycle for the subscription, such as monthly or yearly. | |
| RecurringPricingPlanPriceAmount | Decimal | True |
The total recurring charge billed to the merchant for each billing interval, expressed as a decimal money amount. | |
| RecurringPricingPlanPriceCurrencyCode | String | True |
The currency code for the recurring subscription charge. | |
| UsagePricingPlanBalanceUsedAmount | Decimal | True |
The total value of usage charges accumulated for the current billing interval, expressed as a decimal money amount. | |
| UsagePricingPlanBalanceUsedCurrencyCode | String | True |
The currency code for the total usage charges accumulated during the current billing interval. | |
| UsagePricingPlanCappedAmount | Decimal | False |
The maximum chargeable amount for usage during a billing period, preventing billing from exceeding this threshold unless a new charge is approved. | |
| UsagePricingPlanCappedAmountCurrencyCode | String | False |
The currency code for the capped usage billing amount within a billing period. | |
| UsagePricingPlanInterval | String | True |
The frequency or billing cycle used for tracking and charging app usage, such as monthly. | |
| UsagePricingPlanTerms | String | True |
The terms and conditions governing the app's usage-based pricing, shown to the merchant when approving usage charges. |