---
schema_version: "1"
id: d0a7014bb019db4907cf42ae994cc16877b4f71e07de70a7fa1caa1caa843892
title: MDP Change or Add Fields from the Order Management System to the Connector
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_data_streams_api_connect_order_add.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_streams_api_connect_order_add.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: cdaeb7b14e9490611d71a307ffbff940284a31ff3e0e5c2a634dc6434658b351
description: If you must add or change fields, we recommend working with a custom connector for SOQL. You can use these queries and change them accordingly.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# MDP Change or Add Fields from the Order Management System to the Connector

If you must add or change fields, we recommend working with a custom connector for SOQL. You can use these queries and change them accordingly.

**Order Summary**

```
SELECT 
TotalDeliveryAdjDistAmount,TotalAdjustedDeliveryAmount,TotalAdjustedDeliveryTaxAmount,OrderedDate,OriginalOrderId,GrandTotalAmount,Id,OrderNumber,Status,TotalAdjDistTaxAmount,TotalAdjustedProductAmount,TotalAdjDistAmount,TotalTaxAmount,SalesChannel.SalesChannelName FROM OrderSummary
```

**Order Item Summary**

```
SELECT 
CurrencyIsoCode,product2.StockKeepingUnit,product2.ProductCode,product2.Family,product2.Description,product2.name,QuantityOrdered,QuantityFulfilled,QuantityReturned,UnitPrice,TotalTaxAmount,orderSummary.Id,OriginalOrderItemId FROM OrderItemSummary Where Type = 'Order Product' ORDER BY OrderSummaryId DESC
```