---
schema_version: "1"
id: af8466260e2024808512bd239aed68e33570ab9b33ab1256f7f43fdc4a4db579
title: ccdl_sales_order
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_data_cloud_ccdl_sales_order.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_data_cloud_ccdl_sales_order.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b114a433a701c3a98ec2a923b04a162a34c85b8b650b383697d2b15a69685574
description: 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.
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# ccdl\_sales\_order

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 |