Commerce: Order Summary Mapping
After a data stream is deployed, the Commerce starter data bundle automatically maps data from Commerce Cloud to data model objects (DMO)s in Data Cloud. Order Summary data is about an internal document generated by the seller indicating that the customer is ready to purchase products and services.
These data mappings relate to the OrderSummary object included in the Salesforce Commerce connector and how that data connects to DMOs.
| DLO Field | DLO Field Data Type | DMO | DMO Field Name |
|---|---|---|---|
| Id | ID | SalesOrder | id |
| OwnerId | reference | SalesOrder | OwnerUserId |
| CurrencyIsoCode | picklist | SalesOrder | CurrencyCode |
| OrderNumber | string | SalesOrder | OrderNumber |
| CreatedDate | dateTime | SalesOrder | CreatedDate |
| SystemModstamp | dateTime | SalesOrder | SystemModstamp |
| OriginalOrderId | reference | SalesOrder | OriginalOrderId |
| AccountId | reference | SalesOrder | SoldToCustomerId |
| TotalAmount | currency | SalesOrder | TotalAmount |
| GrandTotalAmount | currency | SalesOrder | GrandTotalAmount |
| TotalAdjDistAmount | currency | SalesOrder | TotalAdjustmentAmount |
| TotalAdjDistTaxAmount | currency | SalesOrder | TotalAdjustmentTaxAmount |
| TaxLocaleType | picklist | SalesOrder | TaxationPolicyId |
| TaxationPolicy | |||
| OrderedDate | dateTime | SalesOrder | CheckoutDate |
| TotalTaxAmount | currency | SalesOrder | TotalTaxAmount |
| Status | picklist | SalesOrder | SalesOrderStatusId |
| SalesOrderSystemStatusId | |||
| Description | textarea | SalesOrder | Description |
| SalesStoreId | reference | SalesOrder | SalesStoreId |
| MobileStoreSalesStoreId | |||
| RetailStoreSalesStoreId | |||
| WarehouseSalesStoreId | |||
| WebStoreSalesStoreId | |||
| SalesChannelId | reference | SalesOrder | SalesChannelId |
| PoNumber | string | SalesOrder | PurchaseOrderNumber |
| PoDate | dateTime | SalesOrder | PurchaseOrderDate |
| TotalProductAmount | currency | SalesOrder | TotalProductAmount |
| TotalDeliveryAmount | currency | SalesOrder | TotalDeliveryAmount |
| TotalAdjustedProductAmount | currency | SalesOrder | AdjustedTotalProductAmount |
| TotalAdjustedDeliveryAmount | currency | SalesOrder | AdjustedTotalDeliveryAmount |
| TotalProductAdjDistAmount | currency | SalesOrder | TotalProductAdjustmentDistAmount |
| TotalDeliveryAdjDistAmount | currency | SalesOrder | TotalDeliveryAdjustmentDistAmount |
| TotalProductTaxAmount | currency | SalesOrder | TotalProductTaxAmount |
| TotalDeliveryTaxAmount | currency | SalesOrder | TotalDeliveryTaxAmount |
| TotalAdjustedProductTaxAmount | currency | SalesOrder | AdjustedProductTaxAmount |
| TotalAdjustedDeliveryTaxAmount | currency | SalesOrder | TotalAdjustedDeliveryTaxAmount |
| TotalProductAdjDistTaxAmount | currency | SalesOrder | TotalProductAdjDistTaxAmount |
| TotalDeliveryAdjDistTaxAmount | currency | SalesOrder | TotalDeliveryAdjDistTaxAmount |
| BillToContactId | reference | SalesOrder | BillToContactId |
| ExternalReferenceIdentifier | string | SalesOrder | externalRecordId |
| TotalProductAmountWithTax | currency | SalesOrder | TotalWithTaxProductAmount |
| TotalDeliveryAmountWithTax | currency | SalesOrder | TotalWithTaxDeliveryAmount |
| TotalAdjProductAmtWithTax | currency | SalesOrder | TotalWithTaxProductAdjDistAmount |
| TotalAdjDeliveryAmtWithTax | currency | SalesOrder | TotalWithTaxAdjDeliveryAmount |
| TotalProductAdjDistAmtWithTax | currency | SalesOrder | TotalWithTaxAdjProductAmount |
| TotalDeliveryAdjDistAmtWithTax | currency | SalesOrder | TotalWithTaxDeliveryAdjDistAmount |
| TotalAdjDistAmountWithTax | currency | SalesOrder | OrderDiscount |
| IsSuspended | boolean | SalesOrder | IsSuspended |
| BusinessModel | picklist | SalesOrder | BusinessModel |