Line Items

5 min

x_fct_trans_line_items

Name	Description
Affiliate Email	Email address of the affiliate.
Affiliate Id	Unique key generated by Chord to identify a unique affiliate.
Affiliate Name	Full name of the user.
Affiliate Seen Emails	List of email addresses seen.
Affiliate User Id	Unique key generated by Chord to identify a unique user.
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	A company name.
Billing Address Country Abbr
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.
Bundle All Parts	List that contains all of the parts skus for a specific bundle.
Bundle Id	Unique key of line item variant if it is a bundle or kit, coalesce of bundles from line_item_part_bundles and parts_and_bundles.
Bundle Is Bundle	Whether or not the bundle is an actual bundle.
Bundle Is Oms Bundle	Whether or not the bundle is an actual Chord OMS bundle.
Bundle Name	The name of the bundle.
Bundle Variant Sku	Variant sku associated with the bundle variant id.
Line Item Adjustment Types	List of distinct adjustment reasons for adjustments made to the order line item.
Line Item Contains Refund	Whether or not the line item contains a partial or full refund. Refunds can be done via adjustments, RMAs or order cancellations.
Line Item Contains Replacement	Whether or not the line item contains a replacement adjustment or has been partially or fully replaced via the Chord OMS RMA functionality.
Line Item Contains Return	Whether or not the line item has been partially or fully returned via the Chord OMS RMA functionality.
Line Item Fulfillment State	Status of the shipment.
Line Item Id	Unique key generated by Chord to identify a unique line item.
Line Item Is Subscription Item	Whether or not the line item is part of a subscription.
Line Item Oms Line Item Id	Unique key generated by Solidus that identifies a line item.
Line Item Price	The price of the variant.
Line Item Quantity	The quantity of how many of said variant was purchased.
Line Item Unique Line Item Count Per Order	Count of unique line items per order.
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 (i.e. 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 Item Id	Unique key generated by Chord to identify a unique order.
Order Item Line Items Quantity	Sum of line items quantities per order.
Order Item Product Basket	List of product names per in the order.
Order Item Product Basket Count	Number of products in the order.
Order Product Basket	The titles of products for a given order array converted to a string.
Order Item Total Line Item Unit Quantity	Sum of line item units in the order.
Order Item Total Line Items Quantity	Sum of line items quantities per order.
Order Item Unique Product Basket	List of unique product names per in the order.
Order Item Unique Product Basket Count	Number of unique products in the order.
Order Unique Product Basket	The list of unique products for a given order array converted to a string.
Order Item Unique Unit Basket	List of unique units in the order.
Order Item Unique Unit Basket Count	Count of unique units in the order.
Order Unit Basket	The list of units for a given order array converted to a string.
Order Item Unique Variant Basket	List of unique variant names per in the order.
Order Item Unique Variant Basket Count	Number of unique variants in the order.
Order Unique Variant Basket	The list of unique variants for a given order array converted to a string.
Order Item Unit Basket	List of all units in the order.
Order Item Unit Basket Count	Count of all units in the order.
Order Unique Unit Basket	The list of unique units for a given order array converted to a string.
Order Item Variant Basket	List of variant names per in the order.
Order Item Variant Basket Count	Number of variants in the order.
Order Variant Basket	The titles of variants for a given order array converted to a string.
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 (i.e., 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 Store Id	Unique key generated by our models that uniquifies a store.
Order Store Name	The name of the store.
Order Store Oms Admin Url	The Admin URL of that OMS.
Order Store Oms Id	Unique key generated by Chord that uniquifies an OMS.
Order Store Oms Store Id	Unique key generated by our models that uniquifies a store.
Order Store Oms Type	The type of the OMS.
Order Store Id	Unique key generated by our models that uniquifies a store.
Order Store Tenant Id	Unique key generated by Chord that uniquifies a tenant.
Order Store Url	The Storefront URL of of the store.
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.
Product Description	The description of the product.
Product Id	Unique key generated by Chord to identify a unique product.
Product Is Adult Signature Required	If an adult's signature is required.
Product Is Promotionable	Whether promotions can apply to the product.
Product Name	The name of the product.
Product Oms Product Id	Unique key generated by Solidus that identifies a product.
Product Property Gender	Product property gender.
Product Slug	The slug of the product.
Product Store Id	Unique key generated by our models that uniquifies a store.
Product Store Name	The name of the store.
Product Store Oms Admin Url	The Admin URL of that OMS.
Product Store Oms Id	Unique key generated by Chord that uniquifies an OMS.
Product Store Oms Store Id	Unique key generated by our models that uniquifies a store.
Product Store Oms Type	The type of the OMS.
Product Store Id	Unique key generated by our models that uniquifies a store.
Product Store Tenant Id	Unique key generated by Chord that uniquifies a tenant.
Product Store Url	The Storefront URL of of the store.
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 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.
Variant Cost Price	The manufacturing cost of the variant.
Variant Depth	The depth of the variant.
Variant Height	The height of the variant.
Variant Id	Unique key generated by Chord to identify a unique product variant.
Variant Is Backorderable	Whether the stock item has at least one location where it is back-orderable or not.
Variant Is Inventory Tracked	Whether the inventory should or should not be tracked for this variant.
Variant Is Master	Whether this represents the master SKU or not.
Variant Is Subscribable	Whether or not a customer can ask to subscribe to this product.
Variant Oms Variant Id	Unique key generated by Solidus that identifies a variant.
Variant Option Color	Color of the variant.
Variant Option Format	Format of the variant.
Variant Option Quantity	Quantity of item for the variant.
Variant Option Size	Size of the variant.
Variant Position	The position of the variant in the list of variants.
Variant Sku	The SKU of the variant.
Variant Weight	The weight of the variant.
Variant Width	The weight of the variant.
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.
Line Item Last Adjustment Refund At (Universal)	Timestamp of the last return adjustment for an order line item - Universal Time Zone.
Line Item Last Adjustment Replacement At (Universal)	Timestamp of the last replacement adjustment for an order line item - 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 completedstate - Pacific Time Zone.
Order Completed At (Universal)	Reflects when the entity was moved to the completedstate - 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.
Product Created At (Universal)	Reflects when the entity was first created in Solidus - Universal Time Zone.
Product Deleted At (Universal)	Reflects when the entity was deleted - Universal Time Zone.
Product Discontinued At (Universal)	Reflects when the entity was discontinued - Universal Time Zone.
Product Updated At (Universal)	Reflects when the entity was last updated in Solidus - 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.
Variant Created At (Universal)	Reflects when the entity was first created in Solidus - Universal Time Zone.
Variant Deleted At (Universal)	Reflects when the entity was deleted - Universal Time Zone.
Variant Updated At (Universal)	Reflects when the entity was last updated in Solidus - Universal Time Zone.
Average Adjusted Total Price	Total price for the line item after adjustments.
Average Adjustment Fulfillment Tax Total	Total of adjustment shipment taxes paid for the line item.
Average Adjustment Tax Total	Total of included adjustment taxes paid for the line item.
Average Adjustment Total	The sum of all adjustment for this line item.
Average Order Additional Tax Total	Total additional taxes for an order.
Average Order Adjustment Fulfillment Tax Total	Total adjustment shipment taxes for an order.
Average Order Adjustment Fulfillment Total	Total shipment adjustments applied to an order.
Average Order Adjustment Other Charges Total	Total of included additional adjustment charges paid for an order.
Average Order Adjustment Other Credits Total	Total of credits issued for an order.
Average Order Adjustment Refund Total	Total of return dollars for an order.
Average Order Adjustment Replacement Total	Total of replacement dollars for an order.
Average Order Adjustment Rma Refund Total	Total of refund dollards associated to an order that was returned via the RMA functionality of the Chord OMS.
Average Order Adjustment Tax Total	Total adjustment taxes an order.
Average Order Adjustment Total	Total of adjustment applied for an order as on the order.
Average Order Applied Gift Card Total	Total of gift card dollars that were used as a payment method in the order
Average Order Commission Total	Commission for an order.
Average Order Fulfillment Total	Total shipment for an order.
Average Order Gross Revenue	Gross amount of revenue generated by the order including items and shipments totals. Gross revenue = total - included_tax_total + shipment_total - purchased_gift_card_total - pre-payment subscription purchase amount
Average Order Included Tax Total	Total included taxes for an order.
Average Order Item Total	Total price for the order before adjustments.
Average Order Net Revenue	Net revenue generated by the order's items after promotions. Net revenue = total - included_tax_total + shipment_total + adjustment_total - additional_tax_total - purchased_gift_card_total - pre-payment subscription purchase amount
Average Order Pre Paid Purchase Total
Average Order Pre Paid Redemption Total
Average Order Promo Total	Promotions applied to an order.
Average Order Purchased Gift Card Total	Total of gift card dollars that were purchased in the order.
Average Order Reimbursement Credit Total
Average Order Tax Total	Total taxes for an order.
Average Order Total Price	Total to be paid by the customer for an order.
Average Order Transaction Total	Total paid by the customer for a completed order.
Average Promo Total	The sum of all of the promo totals from this line items and promotions.
Average Quantity	The quantity of how many of said variant was purchased.
Average Tax Total	Total of total taxes paid for the line item.
Average Total Price	Total price for the line item before adjustments.
Adjusted Total Price	Total price for the line item after adjustments.
Adjustment Fulfillment Tax Total	Total of adjustment shipment taxes paid for the line item.
Adjustment Tax Total	Total of included adjustment taxes paid for the line item.
Adjustment Total	The sum of all adjustment for this line item.
Order Additional Tax Total	Total additional taxes for an order.
Order Adjustment Fulfillment Tax Total	Total adjustment shipment taxes for an order.
Order Adjustment Fulfillment Total	Total shipment adjustments applied to an order.
Order Adjustment Other Charges Total	Total of included additional adjustment charges paid for an order.
Order Adjustment Other Credits Total	Total of credits issued for an order.
Order Adjustment Refund Total	Total of return dollars for an order.
Order Adjustment Replacement Total	Total of replacement dollars for an order.
Order Adjustment Rma Refund Total	Total of refund dollards associated to an order that was returned via the RMA functionality of the Chord OMS.
Order Adjustment Tax Total	Total adjustment taxes an order.
Order Adjustment Total	Total of adjustment applied for an order as on the order.
Order Applied Gift Card Total	Total of gift card dollars that were used as a payment method in the order
Order Commission Total	Commission for an order.
Order Fulfillment Total	Total shipment for an order.
Order Gross Revenue	Gross amount of revenue generated by the order including items and shipments totals. Gross revenue = total - included_tax_total + shipment_total - purchased_gift_card_total - pre-payment subscription purchase amount
Order Included Tax Total	Total included taxes for an order.
Order Item Total	Total price for the order before adjustments.
Order Net Revenue	Net revenue generated by the order's items after promotions. Net revenue = total - included_tax_total + shipment_total + adjustment_total - additional_tax_total - purchased_gift_card_total - pre-payment subscription purchase amount
Order Pre Paid Purchase Total
Order Pre Paid Redemption Total
Order Promo Total	Promotions applied to an order.
Order Purchased Gift Card Total	Total of gift card dollars that were purchased in the order.
Order Reimbursement Credit Total
Order Tax Total	Total taxes for an order.
Order Total Price	Total to be paid by the customer for an order.
Order Transaction Total	Total paid by the customer for a completed order.
Total Price	Total price for the line item before adjustments.
Promo Total	The sum of all of the promo totals from this line items and promotions.
Quantity	The quantity of how many of said variant was purchased.
Tax Total	Total of total taxes paid for the line item.

order_discount_codes

Name	Description
Order Applied Discount Codes	Discount code(s) applied to the order.

order_discount_names

Name	Description
Order Applied Discount Names	Discount name(s) applied to the order.

order_tags

Name	Description
Order Tags	Order tag(s) applied to the order.

subscription_tags

Name	Description
Subscription Tags	Subscription tag(s) applied to the order.