MFG SFTP CIM Handler -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.

csvProductsCimRequest

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

Mapping Tables

Maps SFTP Product request to CIM Product format

CIMSFTP ProductDescription
idIDThe id of the Product in SFTP Product
nameNameThe name of the Product in SFTP Product
longDescriptionDescriptionThe description of the Product in SFTP Product
descriptionDescriptionThe description of the Product in SFTP Product
externalSourceRecordExternalIdThe external id of the Product in SFTP Product
isSellableIsActiveIndicates whether or not the product is active
typeTypeThe family of the Product in SFTP Product
productCategory.nameProductCategoryThe product category name of the product
productCatalog.nameProductCatalogThe product catalog name of the product
priceBookEntry.unitListPriceUnitListPriceThe price book entry list price of the product
externalIds.externalIdIdThe salesforce Id of the Product
externalIds.externalIdType"SALESFORCE_MFG"The externalId Type of the Product
productSKUProductCodeThe sku of the Product in SFTP Product
productStatusStatusThe status of the Product in SFTP Product
brandNameBrand of the Product in SFTP Product
auditInfo.createdByCreatedByIdIdentifies the system or user which created the product entry
auditInfo.createdDateCreatedDateTimestamp of when the product entry was created
auditInfo.updatedByLastModifiedByIdIdentifies the system or user which last updated the product entry
auditInfo.updatedDateLastModifiedDateTimestamp of when the product entry was last updated
auditInfo.isDeletedIsDeletedIndicates whether or not the product has been soft-deleted

(back to top)

xlsxProductsCimRequest

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

Mapping Tables

Maps SFTP Product request to CIM Product format

CIMSFTP ProductDescription
idIDThe id of the Product in SFTP Product
nameNameThe name of the Product in SFTP Product
longDescriptionDescriptionThe description of the Product in SFTP Product
descriptionDescriptionThe description of the Product in SFTP Product
externalSourceRecordExternalIdThe external id of the Product in SFTP Product
isSellableIsActiveIndicates whether or not the product is active
typeTypeThe family of the Product in SFTP Product
productCategory.nameProductCategoryThe product category name of the product
productCatalog.nameProductCatalogThe product catalog name of the product
priceBookEntry.unitListPriceUnitListPriceThe price book entry list price of the product
externalIds.externalIdIdThe Salesforce Id of the Product
externalIds.externalIdType"SALESFORCE_MFG"The externalId Type of the Product
productSKUProductCodeThe sku of the Product in SFTP Product
productStatusStatusThe status of the Product in SFTP Product
brandNameBrand of the Product in SFTP Product
auditInfo.createdByCreatedByIdIdentifies the system or user which created the product entry
auditInfo.createdDateCreatedDateTimestamp of when the product entry was created
auditInfo.updatedByLastModifiedByIdIdentifies the system or user which last updated the product entry
auditInfo.updatedDateLastModifiedDateTimestamp of when the product entry was last updated
auditInfo.isDeletedIsDeletedIndicates whether or not the product has been soft-deleted

(back to top)

csvOrdersCimRequest

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

Mapping Tables

Maps SFTP Order request to CIM Order format

CIMSFTP OrderDescription
nameNamename of the Order
requestedStartDateEffectiveDateOrdered Date
idIdOrder Id
orderNumberOrderNumberSFTP Order Number
soldToCustomerAccountIdAccount Id Info
descriptionDescriptionDescription of the Order
grandTotalAmountTotalPriceAmountTotalAmount of the Order
salesOrderStatus"DELIVERED"Default delivered status
totalProductAmountTotalAmounttotal Product Amount
totalDeliveryAmountTotalProductAmounttotal Product Amount
activatedDateEffectiveDateEffective Date
totalAdjustmentAmountTotalAdjustedProductAmountTotal Adjusted Product Amount
activatedDateEffectiveDateEffective Date
adjustedTotalProductAmountTotalAdjustedProductAmountAdjusted Product Amount
orderStartDateOrderedDateSFTP Order start date
totalDeliveryFeeAmountShipping__cShipping Fee
salesChannelSalesChannelIdSales Channel Id
originalOrderOriginalOrderIdSFTP Original Order Id
totalProductTaxAmountTotalTaxAmountTax Amount
totalAdjustmentTaxAmountTotalAdjustmentTaxAmountTax amount
totalAdjustedDeliveryTaxAmountTotalAdjustedDeliveryTaxAmountDelivery Tax Amount
totalTaxAmountTotalTaxAmountTotal Tax Amount
auditInfo.createdByCreatedByIdCreatedBy Id
auditInfo.updatedByLastModifiedByIdUpdatedBy Id
auditInfo.updatedDateLastModifiedDateUpdated Date
auditInfo.createdDateCreatedDateCreated Date
salesOrderSystemStatus"DraftStatus of the SFTP Order
externalIds.externalIdType"SALESFORCE_MFG"SALESFORCE MFG
externalIds.externalIdexternalIdExternal SalesOrder id
orderLineItems.ididId of the orderLine Items
orderLineItems.codeProductCodeProduct Code of the orderLine Items
orderLineItems.descriptionProductDescriptionDescription of the Product
orderLineItems.orderedQuantityOrderedQuantityQuantity of the Product
orderLineItems.unitPriceAmountUnitPriceAmountUnit Price of the Product
orderLineItems.totalPriceAmountTotalPriceAmountTotal Price of the Product
orderLineItems.orderProductNumberOrderProductNumberProduct Number
orderLineItems.orderedCurrency"USD"Currency of the Order
orderLineItems.totalLineAmountTotalPriceAmountTotal Price of the Product

(back to top)

xlsxOrdersCimRequest

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

Mapping Tables

Maps SFTP Order request to CIM Order format

CIMSFTP OrderDescription
nameNamename of the Order
requestedStartDateEffectiveDateOrdered Date
idIdOrder Id
orderNumberOrderNumberSFTP Order Number
soldToCustomerAccountIdAccount Id Info
descriptionDescriptionDescription of the Order
grandTotalAmountTotalPriceAmountTotalAmount of the Order
salesOrderStatus"DELIVERED"Default delivered status
totalProductAmountTotalAmounttotal Product Amount
totalDeliveryAmountTotalProductAmounttotal Product Amount
activatedDateEffectiveDateEffective Date
totalAdjustmentAmountTotalAdjustedProductAmountTotal Adjusted Product Amount
activatedDateEffectiveDateEffective Date
adjustedTotalProductAmountTotalAdjustedProductAmountAdjusted Product Amount
orderStartDateOrderedDateSFTP Order start date
totalDeliveryFeeAmountShipping__cShipping Fee
salesChannelSalesChannelIdSales Channel Id
originalOrderOriginalOrderIdSFTP Original Order Id
totalProductTaxAmountTotalTaxAmountTax Amount
totalAdjustmentTaxAmountTotalAdjustmentTaxAmountTax amount
totalAdjustedDeliveryTaxAmountTotalAdjustedDeliveryTaxAmountDelivery Tax Amount
totalTaxAmountTotalTaxAmountTotal Tax Amount
auditInfo.createdByCreatedByIdCreatedBy Id
auditInfo.updatedByLastModifiedByIdUpdatedBy Id
auditInfo.updatedDateLastModifiedDateUpdated Date
auditInfo.createdDateCreatedDateCreated Date
salesOrderSystemStatus"DraftStatus of the SFTP Order
externalIds.externalIdType"SALESFORCE_MFG"SALESFORCE MFG
externalIds.externalIdexternalIdExternal SalesOrder id
orderLineItems.ididId of the orderLine Items
orderLineItems.codeProductCodeProduct Code of the orderLine Items
orderLineItems.descriptionProductDescriptionDescription of the Product
orderLineItems.orderedQuantityOrderedQuantityQuantity of the Product
orderLineItems.unitPriceAmountUnitPriceAmountUnit Price of the Product
orderLineItems.totalPriceAmountTotalPriceAmountTotal Price of the Product
orderLineItems.orderProductNumberOrderProductNumberProduct Number
orderLineItems.orderedCurrency"USD"Currency of the Order
orderLineItems.totalLineAmountTotalPriceAmountTotal Price of the Product

(back to top)

CustomersCIMRequest

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

Mapping Tables

Maps SFTP Customer request to CIM Product format

CIMSFTP CustomerDescription
idIDThe id of the Customer in SFTP Product
customerNumberExternalIdCustomer id in external system
customerStatusACTIVECustomer status
partyRoleTypeCustomerparty role type
party.idnullThe id of the Party
party.partyTypePartyThe type of Party
party.nameorganizationNameOrganization name of the Party when partyType is Organization
party.personNamefirstName lastNameThe full name of the Party - if middle name is present then firstName middleName lastName
party.firstNamefirstNameThe first name of the Party
party.lastNamelastNameThe last name of the Party
contactPoints.contactPointTypecontactPointTypeType of contact point
contactPoints.idnullId of contact point
contactPoints.activeFromDatecurrent dateDate from which contact point is active
contactPoints.emailAddressEmailAddressEmail address when contact point type is ContactPointEmail
contactPoints.profileOccurrenceCount1profile occurrence count
contactPoints.telephoneNumberPhoneNumberPhone number when contact point type is ContactPointPhone
contactPoints.countryNameCountryCountry when contact point type is ContactPointPhone
contactPoints.phoneCountryCodeInternationalCode default 001Phone country code when contact point type is ContactPointPhone
contactPoints.primaryPhoneTypePhone TypePhone type when contact point type is ContactPointPhone
contactPoints.shortCode1Short code when contact point type is ContactPointPhone
contactPoints.profileOccurrenceCount1profile occurrence count
contactPoints.profileFirstCreatedDate00:01:01Profile First Created Date when contact point type is ContactPointAddress
contactPoints.activeToDatecurrent dateDate to whcih contact point is active when contact point type is ContactPointAddress
contactPoints.addressLine1AddressLine1Address Line1 when contact point type is ContactPointAddress
contactPoints.addressLine2AddressLine2Address Line2 when contact point type is ContactPointAddress
contactPoints.addressLine4PostalCodePostal Code when contact point type is ContactPointAddress
contactPoints.stateProvinceNameStateState when contact point type is ContactPointAddress
contactPoints.cityNameCityCity when contact point type is ContactPointAddress
contactPoints.countryNameCountryCountry when contact point type is ContactPointAddress
contactPoints.nameAddressTypeType of address when contact point type is ContactPointAddress
contactPoints.primaryFlagtrueprimary flag when contact point type is ContactPointAddress
externalIds.externalIduuidThe masterId of the Product
externalIds.externalIdTypeMDMThe externalId Type of the Product
auditInfo.createdByCreatedByIdIdentifies the system or user which created the product entry
auditInfo.createdDateCreatedDateTimestamp of when the product entry was created
auditInfo.updatedByLastModifiedByIdIdentifies the system or user which last updated the product entry
auditInfo.updatedDateLastModifiedDateTimestamp of when the product entry was last updated
auditInfo.isDeletedIsDeletedIndicates whether or not the product has been soft-deleted

(back to top)


Reviews

TypeTemplate
OrganizationMuleSoft
Published by
MuleSoft Solutions
Published onNov 7, 2022
Asset overview

Asset versions for 1.0.x

Asset versions
VersionActions
1.0.0