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. |