Transactions

x fct trans transactions name description applied gift card amount dollar value of the gift card at time of issuance applied gift card amount used amount used from the initial gift card amount applied gift card currency currency of the gift card amount applied gift card gift message gift card's custom message from the purchaser to the recipient applied gift card id unique key generated by chord that uniquifies a gift card applied gift card is redeemable flag that determines whether or not the gift card is redeemable applied gift card purchaser name gift card's purchaser name as inputed by the gift card's purchaser applied gift card recipient email gift card's recipient email applied gift card recipient name gift card's recipient name as inputed by the gift card's purchaser applied gift card redemption code gift card's redemption code order adjustment types list of distinct adjustment reasons for adjustments made to the order order admin url the admin url of pointing to the order order applied discount codes list of promotion codes applied to the order order applied discount codes count count of promotion codes applied to the order order applied discount ids list of promotion ids applied to the order order applied discount names list of promotion names applied to the order order applied discount names count count of promotion names applied to the order order cart url url of the cart which contains the order order channel the channel from which the order is created order completed order rank by subscription allows to rank completed orders by completion date for a subscription order completed order rank by user allows to rank completed orders by completion date for a user order contains refund whether or not the order contains refund adjustments or refunds that are processed outside of the chord oms adjustment systems (for example via rmas or cancellations) order contains replacement whether or not the order contains replacement adjustments or shipped replacement items (following an rma authorization) order contains return whether or not the order contains returns (authorized rmas) order contains rma refund whether or not the order contains rma refunds (refunds issued after an rma was requested and authorized) order contains rma store credits this column is not documented order currency the currency for this order order customer lifetime month number of months between the current order's completion date and the user's first order completion date first orders have a value of 1 order customer lifetime week number of weeks between the current order's completion date and the user's first order completion date first orders always have a value of 1 order email the email address of the customer that made the order order financial state the current payment state of the order order fulfillment ids array of unique keys generated by chord to identify the unique shipments for an order order fulfillment numbers the unique identifier for this shipment order fulfillment state the current shipment state of the order order has discount whether or not the order has promotions applied to it order has order tags whether or not that order has tags order hours from order to first fulfillment number of hours between order completion and first order shipment; how long it takes a company to get the initial product out to a customer order hours from order to last fulfillment number of hours between order completion and last order shipment order id unique key generated by chord to identify a unique order order is canceled whether or not the order is canceled the order is considered canceled when the canceled at date is not null order is completed whether or not that order is completed the order is considered completed when the completed at date is not null this means that the order does not necessarily have a state = 'complete', since states can change after the order completion (for example in the case of a refund) order is first completed order whether or not that order was the first completed order for a user order is first order whether or not that order was the first order for a user order is first subscription completed order whether or not that order was the first completed order for a subscription order is first subscription order whether or not that order was the first order for a subscription order is fulfilled whether or not that order has shipped order is part of subscription whether or not that order is part of a subscription order is pre paid purchase whether the order the orderincludes the purchase of a pre payment; this could be a gift subscription, pre pay subscription, or gift card order is pre paid redemption whether the order included the redemption of a pre payment; this could be the redemption of a gift subscription, pre pay subscription, or gift card order is referred by affiliate whether or not the user is referred by an affiliate order is referred by referrer whether or not the user is referred by a referrer order is replacement true when the order is a replacement order order is suspicious referral conversion wether this represents a suspicous referral conversions or not order number human readable unique key generated by solidus that identifies an order it begins with a set of tenant store defined letters and ends in a nine digit number (for example, chord 123456789) this number is shown to the users in various places these combinations are unique for a given store order oms order id unique key generated by solidus that identifies an order order rank by user allows to rank completed orders by completion date for a user order tags list of tags associated to the order order tags count number of tags associated to the order order referral conversion suspicious reasons a list of reasons explaining why the referral conversion is suspicious order referrer user email the email address of the customer identified with the referral order special instructions any special shipping instructions that have been specified by the customer during checkout order state the current state of the order order subscription customer lifetime month number of months between the current order's completion date and the user's first subscription order completion date first orders have a value of 1 order subscription customer lifetime week number of weeks between the current order's completion date and the user's first subscription order completion date first orders always have a value of 1 order user referral code unique key generated by solidus that represents the user's referral code order website locale locale of website this will either be collected from the url or from the drop down link on the store purchased gift card amount dollar value of the gift card at time of issuance purchased gift card amount used amount used from the initial gift card amount purchased gift card currency currency of the gift card amount purchased gift card gift message gift card's custom message from the purchaser to the recipient purchased gift card id unique key generated by chord that uniquifies a gift card purchased gift card is redeemable flag that determines whether or not the gift card is redeemable purchased gift card purchaser name gift card's purchaser name as inputed by the gift card's purchaser purchased gift card recipient email gift card's recipient email purchased gift card recipient name gift card's recipient name as inputed by the gift card's purchaser purchased gift card redemption code gift card's redemption code store id unique key generated by our models that uniquifies a store store name the name of the store store oms admin url the admin url of that oms store oms id unique key generated by chord that uniquifies an oms store oms store id unique key generated by our models that uniquifies a store store oms type the type of the oms store id unique key generated by our models that uniquifies a store store tenant id unique key generated by chord that uniquifies a tenant store url the storefront url of of the store transaction id unique key generated by chord that uniquifies a transaction transaction payment method represents the transaction's payment method may include values such as 'stripe', 'venmo', etc transaction payment type represents the transaction's payment type may include values such as 'money', 'store credit', 'referral credit applied', etc transaction reason represents the transaction reason may include values such as 'return processing', 'order canceled', 'order', 'order not received', etc transaction type represents the transaction type its value is either 'payment' or 'refund' 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 applied gift card applied at (universal) timestamp that represents the time at which gift card was last applied as a payment method on an order universal time zone applied gift card created at (universal) timestamp that represents the time at which gift card was created universal time zone applied gift card deactivated at (universal) timestamp that represents the time at which gift card was deactivated universal time zone applied gift card sent at (universal) timestamp that represents the time at which gift card was sent to its recipient universal time zone applied gift card updated at (universal) timestamp that represents the time at which gift card was last updated universal time zone order approved at (universal) reflects when the entity was approved in solidus universal time zone order canceled at (universal) reflects when the order was cancelled universal time zone order completed at (central) reflects when the entity was moved to the 'completed' state cental time zone order completed at (eastern) reflects when the entity was moved to the 'completed' state eastern time zone order completed at (mountain) reflects when the entity was moved to the 'completed' state mountain time zone order completed at (pacific) reflects when the entity was moved to the 'completed' state pacific time zone order completed at (universal) reflects when the entity was moved to the 'completed' state universal time zone order created at (central) reflects when the entity was first created in solidus cental time zone order created at (eastern) reflects when the entity was first created in solidus eastern time zone order created at (mountain) reflects when the entity was first created in solidus mountain time zone order created at (pacific) reflects when the entity was first created in solidus pacific time zone order created at (universal) reflects when the entity was first created in solidus universal time zone order first fulfillment fulfilled at (universal) timestamp at which the first shipment for that order was shipped universal time zone order last adjustment refund at (universal) timestamp of the last return adjustment for an order universal time zone order last adjustment replacement at (universal) timestamp of the last replacement adjustment for an order universal time zone order last fulfillment fulfilled at (universal) timestamp at which the last shipment for that order was shipped universal time zone order updated at (universal) reflects when the entity was last updated in solidus universal time zone purchased gift card applied at (universal) timestamp that represents the time at which gift card was last applied as a payment method on an order universal time zone purchased gift card created at (universal) timestamp that represents the time at which gift card was created universal time zone purchased gift card deactivated at (universal) timestamp that represents the time at which gift card was deactivated universal time zone purchased gift card sent at (universal) timestamp that represents the time at which gift card was sent to its recipient universal time zone purchased gift card updated at (universal) timestamp that represents the time at which gift card was last updated universal time zone transaction ts (central) timestamp that represents the time at which the transaction was last updated cental time zone transaction ts (eastern) timestamp that represents the time at which the transaction was last updated eastern time zone transaction ts (mountain) timestamp that represents the time at which the transaction was last updated mountain time zone transaction ts (pacific) timestamp that represents the time at which the transaction was last updated pacific time zone transaction ts (universal) timestamp that represents the time at which the transaction was last updated 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 net revenue this column is not documented average transaction amount full amount of transaction the value will be positive if the transaction is a payment, and negative if the transaction is a refund net revenue this column is not documented transaction amount full amount of transaction the value will be positive if the transaction is a payment, and negative if the transaction is a refund