Subscriptions

2 min

x_fct_trans_subscriptions

Name	Description
Billing Address Address1	The street address of the customer.
Billing Address Address2	The optional second address of the customer.
Billing Address Alternative Phone	The customer's alternative phone number.
Billing Address City	The city where the address is.
Billing Address Company
Billing Address Country Abbr	A company name.
Billing Address Country Name	Full name of the country.
Billing Address Firstname	First name of the customer.
Billing Address Id	Unique key generated by Chord to identify a unique address.
Billing Address Lastname	Last name of the customer.
Billing Address Oms Address Id	Unique key generated by Solidus that identifies an address.
Billing Address Phone	The customer's phone number.
Billing Address State Abbr
Billing Address State Name	Full name of the state.
Billing Address Zipcode	The postal code.
Shipping Address Address1	The street address of the customer.
Shipping Address Address2	The optional second address of the customer.
Shipping Address Alternative Phone	The customer's alternative phone number.
Shipping Address City	The city where the address is.
Shipping Address Company	A company name.
Shipping Address Country Abbr
Shipping Address Country Name	Full name of the country.
Shipping Address Firstname	First name of the customer.
Shipping Address Id	Unique key generated by Chord to identify a unique address.
Shipping Address Lastname	Last name of the customer.
Shipping Address Oms Address Id	Unique key generated by Solidus that identifies an address.
Shipping Address Phone	The customer's phone number.
Shipping Address State Abbr
Shipping Address State Name	Full name of the state.
Shipping Address Zipcode	The postal code.
Subscription Completed Oms Order Ids	List of completed OMS order ids by a subscription.
Subscription Completed Order Count	Total amount of orders completed by a subscription.
Subscription Completed Order Ids	List of completed order ids by a subscription.
Subscription First Order Unique Product Basket	Array of unique product names ordered in the first order per subscription.
Subscription First Order Unique Variant Basket	Array of unique SKUs ordered in the first order per subscription.
Subscription Has Subscription Tags	Whether or not the subscription has tags.
Subscription Id	Unique key generated by Solidus that identifies a subscription.
Subscription Interval In Days	The number of days in the subscription interval.
Subscription Is Auto Redeemed	Whether the pre-paid subscription will be auto-redeemed or if an action is required by the recepient.
Subscription Is Gift	Whether or not the pre-paid subscription is a gift.
Subscription Is Recurring	Whether the pre-paid subscription is recurring.
Subscription Last Order Unique Product Basket	Array of unique product names ordered in the latest order per subscription.
Subscription Last Order Unique Variant Basket	Array of unique SKUs ordered in the latest order per subscription.
Subscription Oms Pre Paid Subscription Id	ID generated by ChordOMS to identify a unique pre-paid subscription.
Subscription Oms Subscription Id	Unique key generated by Solidus that identifies a subscription.
Subscription Pre Paid Subscription Id	Chord generated unique id for the pre-pay subscription.
Subscription State	The current state of the subscription, enhanced with values for `paused` if the subscription is active and paused.
Subscription Store Id	Unique key generated by our models that uniquifies a store.
Subscription Store Name	The name of the store.
Subscription Store Oms Admin Url	The Admin URL of that OMS.
Subscription Store Oms Id	Unique key generated by Chord that uniquifies an OMS.
Subscription Store Oms Store Id	Unique key generated by our models that uniquifies a store.
Subscription Store Oms Type	The type of the OMS.
Subscription Store Id	Unique key generated by our models that uniquifies a store.
Subscription Store Tenant Id	Unique key generated by Chord that uniquifies a tenant.
Subscription Store Url	The Storefront URL of of the store.
Subscription Tags	The list of tags associated with a subscription.
Subscription Tags Count	The number of tags associated with a subscription.
Subscription Unique Product Basket	Array of unique product names ever ordered per subscription.
Subscription Unique Variant Basket	Array of unique SKUs ever ordered per subscription.
User Completed Oms Order Ids	List of completed OMS order ids by a user.
User Completed Order Ids	List of completed order ids by a user.
User Credit Category Basket	Array of credit categories (Gift Card, Reimbursement, Referral Credits, Prepaid Subscription, GMA) issued per user.
User Email	Email address of the user.
User First Completed Oms Order Id	OMS order id of the first order completed by a user.
User First Completed Order Id	Unique order id of the first order completed by a user.
User First Order Unique Ordered Products	Unique products ordered by the user in their first completed order.
User First Order Unique Ordered Skus	Unique SKUs ordered by the user in their first completed order.
User Has Ordered A La Carte	Whether or not the user has had at least one order that is not part of a subscription.
User Has Promo Applied In First Order	Whether or not the user has a promo applied to their first completed order.
User Has Subscription In First Order	Whether or not the user's first order is linked to a subscription.
User Id	Unique key generated by Chord to identify a unique user.
User Is Active Subscriber	Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused.
User Is Customer	Whether or not the user is a customer.
User Is New Customer	Whether or not the user is a new customer.
User Is Not Customer	Whether or not the user is not a customer.
User Is Returning Customer	Whether or not the user is a returning customer.
User Is Subscriber	Whether or not the user has completed at least one subscription order.
User Login	The login email address of the user.
User Name	Full name of the user.
User Number Of Completed A La Carte Orders	Total amount of orders completed by a user that are a la carte.
User Number Of Completed Subscription Orders	Total amount of orders completed by a user that was part of a subscription.
User Number Of Orders With Promos	The count of completed orders with a promo applied.
User Number Of Subscriptions	Total amount of subscriptions linked to a user.
User Oms User Id	Unique key generated by Solidus that identifies a user.
User Phone	Phone number of the user.
User Total Completed Order Count	Total amount of orders completed by a user.
User Unique Ordered Products	Unique products ordered by the user across all orders.
User Unique Ordered Skus	Unique SKUs ordered by the user across all orders.
Billing Address Created At (Universal)	Timestamp at which the address row was created - Universal Time Zone.
Billing Address Updated At (Universal)	Timestamp at which the address row was last updated - Universal Time Zone.
Shipping Address Created At (Universal)	Timestamp at which the address row was created - Universal Time Zone.
Shipping Address Updated At (Universal)	Timestamp at which the address row was last updated - Universal Time Zone.
Subscription Actionable Date (Universal)	The date of the next subscription installment. This date is updated after each successful installment. Subscriptions in an inactive state will be null - Universal Time Zone.
Subscription Created At (Universal)	Reflects when the entity was first created in Solidus - Universal Time Zone.
Subscription First Order Completed At (Universal)	The timestamp of the subscription's first completed order - Universal Time Zone.
Subscription Last Order Completed At (Universal)	The timestamp of the subscription's last completed order - Universal Time Zone.
Subscription Updated At (Universal)	Reflects when the entity was last updated in Solidus - Universal Time Zone.
User Created At (Universal)	Timestamp at which the users row was created - Universal Time Zone.
User Date Of Birth (Universal)	Date of birth of the user - Universal Time Zone.
User Deleted At (Universal)	Timestamp at which the user's account was deleted - Universal Time Zone.
User First Order Completed At (Universal)	The timestamp of the user's first completed order - Universal Time Zone.
User First Subscription Order Completed At (Universal)	The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone.
User Last Order Completed At (Universal)	The timestamp of the user's last completed order - Universal Time Zone.
User Last Sign In At (Universal)	The last sign in timestamp for the user - Universal Time Zone.
User Updated At (Universal)	Timestamp at which the users row was last updated - Universal Time Zone.
Average Additional Tax Total	Sum of additional taxes paid for all completed orders for a subscription.
Average Adjustment Total	Sum of adjustment applied for all completed orders for a subscription as on the order.
Average Commission Total	Sum of commission paid for all completed orders for a subscription.
Average Fulfillment Total	Sum paid for fulfillment for all completed orders for a subscription.
Average Included Tax Total	Sum of included taxes paid for all completed orders for a subscription.
Average Item Total	Sum of items price paid for all completed orders for a subscription.
Average Promo Total	Sum of promotions applied for all completed orders for a subscription.
Average Tax Total	Sum of total taxes paid for all completed orders for a subscription.
Average Total Completed Order Count	Total amount of orders completed by a subscription.
Average Transaction Total	Sum paid on all transactions for a subscription.
Additional Tax Total	Sum of additional taxes paid for all completed orders for a subscription.
Adjustment Total	Sum of adjustment applied for all completed orders for a subscription as on the order.
Commission Total	Sum of commission paid for all completed orders for a subscription.
Total Completed Order Count	Total amount of orders completed by a subscription.
Fulfillment Total	Sum paid for fulfillment for all completed orders for a subscription.
Included Tax Total	Sum of included taxes paid for all completed orders for a subscription.
Item Total	Sum of items price paid for all completed orders for a subscription.
Promo Total	Sum of promotions applied for all completed orders for a subscription.
Tax Total	Sum of total taxes paid for all completed orders for a subscription.
Transaction Total	Sum paid on all transactions for a subscription.

subscription_unique_product_basket

Name	Description
Unique Product Basket	Unique product basket for the subscription. Includes all products associated with the subscription, historical and current.