Subscription events

x fct trans subscription events name description 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 event type the type of the subscription event subscription event id unique key generated by chord to identify a unique subscription event subscription event oms subscription event id unique key generated by solidus that identifies a subscription event subscription event oms subscription id unique key generated by solidus that identifies a subscription subscription event unique product basket array of products per subscription when an event is triggered subscription event unique variant basket array of skus per subscription when an event is triggered 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 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 event created at (universal) reflects when the entity was first created in solidus universal time zone subscription event updated at (universal) reflects when the entity was last updated 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 subscription event unique product basket name description unique product basket unique product basket at the time of subscription event