MFG Customers Process API - Implementation Template
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.
| Module | Description |
|---|---|
| capture-external-ids-from-routes | |
| map-erp-prc-request | Customer Mapping for ERP Systems (SAP HANA) |
| map-salesforce-customer-update-request | Customer Update Mapping for Salesforce |
| map-salesforce-customer-create-request | Customer Create Mapping for Salesforce |
capture-external-ids-from-routes
Source:
./src/main/resources/dwl/capture-external-ids-from-routes.dwl
Mapping Tables
Capture External IDs
| ExternalId Field | External System Value | Description |
|---|---|---|
| id | id | The id will be null for external id |
| externalId | payload | The external id in the external system |
| externalIdType | externalIdType | Pre-defined external id type |
| status | status | Default to VALID |
map-erp-prc-request
Customer Mapping for ERP Systems (SAP HANA)
Source:
./src/main/resources/dwl/map-erp-prc-request.dwl
Mapping Tables
Maps customer profiles of SourceSystems (B2C,Salesforce,ERP Systems -SAP ECC, HANA) to MDM in CIM format which is further used for creation of Customer in B2C Commerce. The object structure is same with only exception of Global Party Role Id being sent as an External Id to be stored in ERP Systems(SAPECC,HANA) to uniquely identify the customer.
| MDM | ERP Systems | Description |
|---|---|---|
| id | id | The id will be Global Party Role Id for updating an existing customer |
| partyRoleType | partyRoleType | The type of party role - default as Customer |
| party.id | id | The id of the Party |
| party.partyType | partyType | The type of party |
| party.personName | personName | The full name of the Party |
| party.firstName | firstName | The first name of the Party |
| party.lastName | lastName | The last name of the Party |
| party.name | name | The name of the Party |
| party.contactPoints | contactPoints | Contact Points of the Party |
| party.externalIds | externalIds | The Global Party Id of Customer as in MDM.This will not be stored in ERP Systems |
| party.auditInfo | auditInfo | Audit Info of the Party |
| customerNumber | customerNumber | The Customer Number to be stored in ERP Systems |
| customerStatus | customerStatus | The Status of Customer to be updated in ERP Systems |
| externalIds | externalIds | The Global Party Role Id of Customer as in MDM that will need to be stored in ERP Systems |
| auditInfo | auditInfo | Audit Info of the Customer |
map-salesforce-customer-update-request
Customer Update Mapping for Salesforce
Source:
./src/main/resources/dwl/map-salesforce-customer-update-request.dwl
Mapping Tables
Maps customer profiles of SourceSystem (SAP or B2C Commerce) to MDM in CIM format which is further used for creation of Customer in Salesforce. The object structure is same with only exception of Global Customer Id being sent as an ExternalId with ExternalIdType as MDM. This Id will be stored in Salesforce to uniquely identify the customer.
| MDM | Salesforce | Description |
|---|---|---|
| id | id | The id will be Global Customer Id to update an existing Customer in Salesforce |
| partyRoleType | partyRoleType | The type of party role - usually Customer |
| party.id | id | The id of the Party |
| party.partyType | partyType | The type of Party |
| party.personName | personName | The full name of the Party |
| party.firstName | firstName | The first name of the Party |
| party.lastName | lastName | The last name of the Party |
| party.name | name | The name of the party |
| party.contactPoints | contactPoints | Contact Points of the Party |
| party.auditInfo | auditInfo | Audit Info of the Party |
| party.externalIds | externalIds | The Global Party Id of Customer as in MDM.This will not be stored in Salesforce |
| externalIds | externalIds | The Global Customer Id of Customer as in MDM that will need to be stored in Salesforce |
| auditInfo | auditInfo | Audit Info of the Customer |
| customerNumber | customerNumber | The Customer Number to be stored in Salesforce |
| customerStatus | customerStatus | The Status of Customer to be updated in Salesforce |
map-salesforce-customer-create-request
Customer Create Mapping for Salesforce
Source:
./src/main/resources/dwl/map-salesforce-customer-create-request.dwl
Mapping Tables
Maps customer profiles of SourceSystem (SAP or B2C Commerce) to MDM in CIM format which is further used for creation of Customer in Salesforce. The object structure is same with only exception of Global Customer Id being sent as an External Id with External Id Type as MDM. This Id will be stored in Salesforce to uniquely identify the customer.
| MDM | Salesforce | Description |
|---|---|---|
| id | id | The id will be null for creating a new Customer in Salesforce |
| partyRoleType | partyRoleType | The type of party role - usually Customer |
| party | currentParty | The Party |
| externalIds | externalIds | The Global Customer Id of Customer as in MDM that will need to be stored in Salesforce |
| customerNumber | customerNumber | The Customer Number to be stored in Salesforce |
| customerStatus | customerStatus | The Status of Customer to be updated in Salesforce |