MFG Salesforce Orders System API - Implementation Template

(0 reviews)

Data mappings

This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.

ModuleDescription
create-orderlineitem-requestSalesforce create Order Line Item mapping
createOrdersRequestSalesforce create Orders mapping
getOrderByIdResponseSalesforce get Order by Id response mapping
getOrderListResponseSalesforce get Orders list response mapping
ordersListQuerySalesforce Orders list query mapping
update-orderlineitem-requestSalesforce Order Line Item update mapping
updateOrderRequestSalesforce Order update mapping

create-orderlineitem-request

Salesforce create Order Line Item mapping

Source: ./src/main/resources/dwl/create-orderlineitem-request.dwl

Variables

var s

Create OrderLines mapping.

Mapping Tables

Create OrderLines mapping.

Request FieldCIM Source fieldDescription of source field
OrderIdsalesOrderResponse IDOrder ID
DescriptiondescriptionDescription of the Order
Product2IdProduct2Id from Query ResponseProduct ID
PricebookEntryIdPricebookEntryId from Query ResponsePriceBook Entry ID
SBQQOrderedQuantitycorderedQuantityOrder Quantity
UnitPriceUnitPriceAmountUnit Price of the Product
QuantityorderedQuantityOrder Quantity

(back to top)

createOrdersRequest

Salesforce create Orders mapping

Source: ./src/main/resources/dwl/createOrdersRequest.dwl

Mapping Tables

Create Order mapping.

Request FieldCIM Source fieldDescription of source field
NamenameOrder Name
AccountIdsoldToCustomerAccount Id Info
DescriptiondescriptionDescription of the Order
EffectiveDatesysdateEffective date of the Order
Global_SalesOrder_Id__cexternalIds.externalIdGlobal SalesOrder Id
SAP_4HANA_Id__cexternalIds.externalIdSAP HANA Id
StatussalesOrderStatusStatus of the order
TypesalesOrderTypeType of order
Pricebook2Iddefault valuePriceBook ID
Total_Tax__ctotalTaxAmountTotal Tax Amount
Shipping__ctotalDeliveryFeeAmountShipping Fee
SalesAgreementIdsalesAgreementIdsales Agreement Id

(back to top)

getOrderByIdResponse

Salesforce get Order by Id response mapping

Source: ./src/main/resources/dwl/getOrderByIdResponse.dwl

Mapping Tables

Get OrderById response mapping.

Resp FieldSalesforce Source fieldDescription of source field
nameNamename of the Order
requestedStartDateCreatedDateStart Date of Order
idIdSalesforce Order Id
orderNumberOrderNumberOrder Number
soldToCustomerAccountIdSalesforce Account Id Info
descriptionDescriptionDescription of the Order
totalProductAmountTotalAmounttotal Product Amount
activatedDateEffectiveDateEffective Date
grandTotalAmountOrderTotalAmount__cTotal Amount of the Order
salesOrderStatus.idIdSalesforce Order Status Id
salesOrderStatus.nameNameSalesforce Order Status Name
salesOrderStatus.auditInfo.createdByCreatedByIdCreatedBy Id
salesOrderStatus.auditInfo.updatedByLastModifiedByIdUpdatedBy Id
salesOrderStatus.auditInfo.updatedDateLastModifiedDateUpdated Date
salesOrderStatus.auditInfo.createdDateCreatedDateCreated Date
salesOrderStatus.auditInfo.isDeleted"false"Is Deleted or not
totalDeliveryFeeAmountShipping__cShipping Fee
originalOrderOriginalOrderIdSalesforce Original Order Id
salesOrderType.idRecordTypeIdRecord Type Id
salesOrderType.nameTypeSalesforce Order Type
totalAdjustmentTaxAmountTax__cTax amount
totalTaxAmountTotal_Tax__cTotal Tax Amount
orderEndDateEndDateEnd Date for Order
auditInfo.createdByCreatedByIdCreatedBy Id
auditInfo.updatedByLastModifiedByIdUpdatedBy Id
auditInfo.updatedDateLastModifiedDateUpdated Date
auditInfo.createdDateCreatedDateCreated Date
auditInfo.isDeleted"false"Is Deleted or not
salesOrderSystemStatusStatusStatus of the Salesforce Order
externalIds.externalIdType"MDM"Master data management
externalIds.externalIdExternal_ID__cGlobal SalesOrder Id
externalIds.externalIdSAP_4HANA_Id__cSAP HANA Id
externalIds.idIdExternal Id
externalIds.statusLastChangedDateLastModifiedDateLast Modified Date of Order
externalIds.status"VALID"Status of External Id
salesAgreementIdSalesAgreementIdsales Agreement Id
orderLineItems.idIdId of Order Line Items
orderLineItems.codeProduct2IdOrder Line Items Code
orderLineItems.descriptionDescriptionOrder Line Items Description
orderLineItems.orderedQuantityQuantityOrder Line Items Ordered Quantity
orderLineItems.quantityOrderedUOMQuantityOrder Line Items Ordered UOM Quantity
orderLineItems.unitPriceAmountUnitPriceOrder Line Items Unit Price Amount
orderLineItems.totalPriceAmountTotalPriceOrder Line Items Total Price Amount
orderLineItems.orderProductNumberProduct2IdOrder Line Items Product Number
orderLineItems.orderedCurrency"USD"Order Line Items Ordered Currency

(back to top)

getOrderListResponse

Salesforce get Orders list response mapping

Source: ./src/main/resources/dwl/getOrderListResponse.dwl

Mapping Tables

Get OrdersList response mapping.

Resp FieldSalesforce Source fieldDescription of source field
nameNamename of the Order
requestedStartDateCreatedDateStart Date of Order
idIdSalesforce Order Id
orderNumberOrderNumberOrder Number
soldToCustomerAccountIdSalesforce Account Id Info
descriptionDescriptionDescription of the Order
totalProductAmountTotalAmounttotal Product Amount
activatedDateEffectiveDateEffective Date
grandTotalAmountOrderTotalAmount__cTotal Amount of the Order
salesOrderStatus.idIdSalesforce Order Status Id
salesOrderStatus.nameNameSalesforce Order Status Name
salesOrderStatus.auditInfo.createdByCreatedByIdCreatedBy Id
salesOrderStatus.auditInfo.updatedByLastModifiedByIdUpdatedBy Id
salesOrderStatus.auditInfo.updatedDateLastModifiedDateUpdated Date
salesOrderStatus.auditInfo.createdDateCreatedDateCreated Date
salesOrderStatus.auditInfo.isDeleted"false"Is Deleted or not
totalDeliveryFeeAmountShipping__cShipping Fee
originalOrderOriginalOrderIdSalesforce Original Order Id
salesOrderType.idRecordTypeIdRecord Type Id
salesOrderType.nameTypeSalesforce Order Type
totalAdjustmentTaxAmountTax__cTax amount
totalTaxAmountTotal_Tax__cTotal Tax Amount
orderEndDateEndDateEnd Date for Order
auditInfo.createdByCreatedByIdCreatedBy Id
auditInfo.updatedByLastModifiedByIdUpdatedBy Id
auditInfo.updatedDateLastModifiedDateUpdated Date
auditInfo.createdDateCreatedDateCreated Date
auditInfo.isDeleted"false"Is Deleted or not
salesOrderSystemStatusStatusStatus of the Salesforce Order
externalIds.externalIdType"MDM"Master data management
externalIds.externalIdExternal_ID__cGlobal SalesOrder id
externalIds.externalIdSAP_4HANA_Id__cSAP HANA Id
externalIds.idIdExternal Id
externalIds.statusLastChangedDateLastModifiedDateLast Modified Date of Order
externalIds.status"VALID"Status of External Id
salesAgreementIdSalesAgreementIdsales Agreement Id
orderLineItems.idIdId of Order Line Items
orderLineItems.codeProduct2IdOrder Line Items Code
orderLineItems.descriptionDescriptionOrder Line Items Description
orderLineItems.orderedQuantityQuantityOrder Line Items Ordered Quantity
orderLineItems.quantityOrderedUOMQuantityOrder Line Items Ordered UOM Quantity
orderLineItems.unitPriceAmountUnitPriceOrder Line Items Unit Price Amount
orderLineItems.totalPriceAmountTotalPriceOrder Line Items Total Price Amount
orderLineItems.orderProductNumberProduct2IdOrder Line Items Product Number
orderLineItems.orderedCurrency"USD"Order Line Items Ordered Currency

(back to top)

ordersListQuery

Salesforce Orders list query mapping

Source: ./src/main/resources/dwl/ordersListQuery.dwl

(back to top)

update-orderlineitem-request

Salesforce Order Line Item update mapping

Source: ./src/main/resources/dwl/update-orderlineitem-request.dwl

Mapping Tables

Create OrderLines mapping.

Request FieldCIM Source fieldDescription of source field
IdidSalesforce Order Id
DescriptiondescriptionDescription of Salesforce Order
SBQQOrderedQuantitycorderedQuantityOrder Quantity
UnitPriceUnitPriceAmountUnit Price of the Product
QuantityorderedQuantityOrder Quantity

(back to top)

updateOrderRequest

Salesforce Order update mapping

Source: ./src/main/resources/dwl/updateOrderRequest.dwl

Mapping Tables

Get OrdersList response mapping.

Resp FieldCIM Source fieldDescription of source field
IdidSalesforce Order Id
NamenameOrder Name
AccountIdsoldToCustomerAccount Id Info
DescriptiondescriptionDescription of the Order
EffectiveDaterequestedStartDateEffective date of the Order
Global_SalesOrder_Id__cexternalIds[0].externalIdGlobal SalesOrder Id
SAP_4HANA_Id__cexternalIds.externalIdSAP HANA Id
StatussalesOrderStatusStatus of the order
TypesalesOrderTypeType of the Order
Total_Tax__ctotalTaxAmountTotal tax of Order
Shipping__ctotalDelieveryFeeAmountTotal Shipping Amount of Order
SalesAgreementIdsalesAgreementIdSales Agreement Id

(back to top)


Reviews

TypeTemplate
OrganizationMulesoft Inc.
Published by
MuleSoft Solutions
Published onOct 27, 2023
Asset overview

Asset versions for 1.0.x

Asset versions
VersionActions
1.0.2
1.0.0