You are here:
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
Hjalp denne artikkelen med å løse problemet ditt?
La oss få vite det slik at vi kan forbedre!
