Order-header table for placed B2C Commerce orders, keyed by documentNo and siteId. Each row holds one order's grand totals, subtotals, shipping, and tax in the tendered currency.
Default refresh frequency: Hourly.
Primary Key: (documentNo, siteId).
This table contains order headers of placed orders. All orders where visitor consent hasn't been given to track activities are excluded from this table. All monetary values are represented in the currency defined by the currencyCodeAlpha3 column, which represents the tendered currency for the sales order.
Column Reference
| Column Name | Data Type | Description |
|---|---|---|
| businessType | String | Business type classification |
| currencyCodeAlpha3 | String | ISO 4217 alpha-3 currency code of order |
| customerNo | String | Identifier for registered user |
| documentNo | String | Unique identifier for an order, scoped to site |
| grandTotalGrossPrice | Double | Order total gross price (including tax) |
| grandTotalNetPrice | Double | Order total net price (excluding tax) |
| grandTotalTax | Double | Order total tax |
| locale | String | Locale of the order |
| orderChannel | String | Channel through which order was placed |
| orderPlacedTimestamp | Date | Timestamp when the order was placed |
| shippingAfterDiscountsGrossPrice | Double | Shipping gross price after discounts |
| shippingAfterDiscountsNetPrice | Double | Shipping net price after discounts |
| shippingAfterDiscountsTax | Double | Shipping tax after discounts |
| shippingGrossPrice | Double | Shipping gross price (including tax) |
| shippingNetPrice | Double | Shipping net price (excluding tax) |
| shippingTax | Double | Shipping tax amount |
| siteId | String | Unique site identifier within a B2C Commerce tenant |
| subtotalAfterDiscountsGrossPrice | Double | Subtotal gross price after all discounts |
| subtotalAfterDiscountsNetPrice | Double | Subtotal net price after all discounts |
| subtotalAfterDiscountsTax | Double | Subtotal tax after all discounts |
| subtotalAfterProductDiscountsGrossPrice | Double | Subtotal gross price after product discounts |
| subtotalAfterProductDiscountsNetPrice | Double | Subtotal net price after product discounts |
| subtotalGrossPrice | Double | Subtotal gross price (including tax) |
| subtotalNetPrice | Double | Subtotal net price (excluding tax) |
| subtotalTax | Double | Subtotal tax |
| tenantId | String | Unique identifier for tenant in B2C Commerce |
| version | String | Version of data stream (for example, "v1") |
| visitId | String | Identifier for the visit/session |
| visitorId | String | Identifier of the site visitor who placed the order |