Sales

x fct trans sales name description date day num of year the number representing the day of the year date id unique key that uniquify a date date month num of year the month number of the year order account id id generated by chord to identify the account order bill to contact id id of the contact associated with the order summary it represents the shopper in the storefront when not using person accounts order billing city billing address city order billing country billing address country order billing email address email address on the billing address order billing state billing address state order billing state country the billing state or country of the order default to billing country if state is unavailable order currency iso code available only for stores with the multicurrency feature enabled contains the iso code for the currency of the original order associated with the order summary the default value is usd possible values are dkk—danish krone, eur—euro, gbp—british pound, usd—u s dollar order fulfillment ids ids generated by chord to identify the fulfillments associated with the order order fulfillment numbers the fulfillment numbers associated with the order order fulfillment statuses the fulfillment statuses associated with the order order has a shipped fulfillment a flag marking if an order has a shipped fulfillment order hours to first delivery the number of hours between when the order was created and the first fulfillment was created order hours to last delivery the number of hours between when the order was created and the last, most recent, fulfillment was created order id id generated by chord to identify the order order is canceled whether an order is canceled order is completed whether an order is completed an order is considered complete if it has a status of 'fulfilled' or 'returned' or it has a status 'canceled' and has a payment associated with it order number of fulfillments the total number of fulfillments associated with the order order number of reimbursements the number of reimbursements associated with an order order oms account id id of the account or person account associated with the order summary it represents the shopper in the storefront order oms fulfillment ids id generated by the oms to identify the order order oms order id the id generated by the oms for the order summary order oms order payment summary ids the id generated by the oms for the order summary order oms return order ids ids generated by the oms to identify the returns associated with the order order is first order whether the order is first order associated with the account order number name of the order summary order payment summary ids ids generated by chord to identify the payment summaries associated with the order order original order id order payment methods id of the original order associated with this order summary order payment types the payment types associated with the order order po number purchase order number associated with this order summary order promotion details collection the promotion details associated with the order summary order return order ids ids generated by chord to identify the returns associated with the order order return order numbers the return order numbers associated with the order order sales channel id id of the sales channel associated with this order summary order status status of the order summary unlike the status and status category fields on the order and fulfillment order objects, this field is optional order tax locale type the system used to handle tax on the original order associated with the order summary gross usually applies to taxes like value added tax (vat), and net usually applies to taxes like sales tax possible values are gross (displays most prices and taxes as combined values), net (displays most prices and taxes as separate values) order utm campaign the utm campaign associated with the order summary order utm medium the utm medium associated with the order summary order created at (central) the date the order summary was created cental time zone order created at (eastern) the date the order summary was created eastern time zone order created at (mountain) the date the order summary was created mountain time zone order created at (pacific) the date the order summary was created pacific time zone order created at (universal) the date the order summary was created universal time zone order first fulfillment created at (universal) timestamp when the first fulfillment for the order was created universal time zone order first order created at (universal) timestamp when the first order was created at universal time zone order last fulfillment created at (universal) timestamp when the most recent, or last, fulfillment for the order was created universal time zone order last modified date (universal) the date the order summary was last modified universal time zone order ordered date (universal) date of the original order associated with this order summary universal time zone ts (universal) average adjusted product total the total adjusted product amount associated with the order summary average fulfillment total the total adjusted filfillment amount associated with the order summary average gross revenue gross revenue is the pre tax, pre adjusted total line item price (unit price quantity) + the fulfillment total average net revenue net revenue is the adjusted line item price (unit price quantity line adjustments) + the adjusted fulfillment (fulfillment total line adjustments) order level adjustments refunds average promo total the total adjustment amount associated with the order summary average refund total average tax total total tax on all order item summaries belonging to this order summary equal to total adjusted delivery tax amount plus total adjusted product tax amount average total basket value total line itemamount in the order this is the equivalent of the unit price quantity average total items total items in order average total price total amount, including adjustments and tax, of the order summary adjusted product total the total adjusted product amount associated with the order summary total basket value total line itemamount in the order this is the equivalent of the unit price quantity fulfillment total the total adjusted filfillment amount associated with the order summary gross revenue gross revenue is the pre tax, pre adjusted total line item price (unit price quantity) + the fulfillment total total items total items in order net revenue net revenue is the adjusted line item price (unit price quantity line adjustments) + the adjusted fulfillment (fulfillment total line adjustments) order level adjustments refunds total price total amount, including adjustments and tax, of the order summary promo total the total adjustment amount associated with the order summary refund total tax total total tax on all order item summaries belonging to this order summary equal to total adjusted delivery tax amount plus total adjusted product tax amount