---
schema_version: "1"
id: b44edeff70e6ab1c902470fa2008f9ef77e0189943898de2edcdc80260727aa7
title: 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/dato_data_streams_api_connect_order_add.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_streams_api_connect_order_add.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d839dd1b35e3953df8306ef2f14328ff6976a6b18a1f2fee8077fdb29b744c4e
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"
---
# 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
```