RCG POS Event Listener - 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 |
|---|---|
| map-PredictSpring-orders-to-cim | PredictSpring to Orders CIM mapping |
| map-PredictSpring-loyalty-customer-to-cim | PredictSpring to Loyalty Customer CIM mapping |
map-PredictSpring-orders-to-cim
PredictSpring to Orders CIM mapping
Source:
./src/main/resources/dwl/map-PredictSpring-orders-to-cim.dwl
Mapping Tables
| CIM | PredictSpring | Description | |
|---|---|---|---|
| id | "" | "" | |
| name | "SalesOrder-" ++ payload.orderId | Name of the order. | |
| description | productList.imageURL | ImageURL. | |
| orderNumber | orderId | orderId. | |
| requestedStartDate | orderDate | orderDate. | |
| orderSource | orderSource | orderSource. | |
| lastDateToReturnTimeStamp | lastDateToReturnTimeStamp | last Date To Return TimeStamp. | |
| salesOrderType | INITIAL | Hardcoded to INITIAL. | |
| grandTotalAmount | totalAmount | Total Amount. | |
| totalDeliveryFeeAmount | shippingSubTotal | Shipping SubTotal. | |
| totalTaxAmount | taxSubTotal | TaxSubTotal. | |
| taxExemption | taxExemption | Tax Exemption. | |
| totalProductTaxAmount | orderSubTotal | orderSubTotal. | |
| orderLineItems.orderProductNumber | productId | productId. | |
| orderLineItems.allocationGroupName | variantGroupId | Variant GroupId. | |
| orderLineItems.description | name | Name. | |
| orderLineItems.totalPriceAmount | price | Price. | |
| orderLineItems.orderedQuantity | quantity | quantity. | |
| orderLineItems.unitTaxAmount | perUnitTaxAmount | perUnitTaxAmount. | |
| orderLineItems.unitPriceAmount | productPriceAdjustments.basePrice | unitPriceAmount. | |
| orderLineItems.quantityOrderedUOM | UNIT | Hardcoded to Unit. | |
| orderLineItems.orderProductNumber | productList.productId | orderProductNumber. | |
| orderLineItems.size | size | size. | |
| orderLineItems.color | color | color. | |
| orderLineItems.itemStatus | itemStatus | ||
| orderLineItems.unitTaxAmount | perUnitTaxAmount | perUnitTaxAmount. | |
| orderLineItems.discountAmount | discount | discount. | |
| orderLineItems.totalUnitPriceAmount | productList.total | total. | |
| orderLineItems.lineAdjustmentSubTotalAmount | adjustedPrice | adjustedPrice. | |
| orderLineItems.product | gtin | gtin. | |
| orderLineItems.fulfillmentType | fulfillmentType | fulfillmentType. | |
| orderLineItems.fulfillmentSubType | fulfillmentSubType | fulfillmentSubType. | |
| orderLineItems.salesAssociateId | salesAssociateId | salesAssociateId. | |
| orderLineItems.salesAssociateAttribution.orderItemId | orderItemId | orderItemId. | |
| orderLineItems.salesAssociateAttribution.storeId | storeId | storeId. | |
| orderLineItems.salesAssociateAttribution.storeAssociateId | storeAssociateId | storeAssociateId. | |
| orderLineItems.salesAssociateAttribution.contributionPercentage | contributionPercentage | contributionPercentage. | |
| orderLineItems.salesAssociateAttribution.orderId | orderId | orderId. | |
| orderLineItems.salesAssociateAttribution.expiryDate | expiryDate | expiryDate. | |
| orderProductTax.country | countryCode | countryCode. | |
| orderProductTax.name | taxType | Type of tax. | |
| orderProductTax.taxRatePercent | taxRate | taxRate. | |
| orderProductTax.taxClass | taxClass | taxClass. | |
| orderProductTax.taxCode | taxCode | taxCode. | |
| orderProductTax.salesOrderTaxAmount | taxAmount | taxAmount. | |
| orderProductTax.taxAmount | perUnitTaxAmount | perUnitTaxAmount. | |
| orderProductTax.name | taxName | Name of the tax. | |
| orderProductTax.description | displayTaxName | displayTaxName. | |
| orderProductTax.returnedTaxAmount | returnedTaxAmount | returnedTaxAmount. | |
| orderAddress.id | "" | "" | |
| orderAddress.personName | billingAddress.firstName + payload.billingAddress.lastName | PersonName | |
| orderAddress.firstName | billingAddress.firstName | firstName | |
| orderAddress.lastName | billingAddress.lastName | lastName | |
| orderAddress.addressLine1 | billingAddress.addressLine1 | addressLine1 | |
| orderAddress.addressLine2 | billingAddress.addressLine2 | addressLine2 | |
| orderAddress.cityName | billingAddress.city | city | |
| orderAddress.stateProvinceName | billingAddress.state | state | |
| orderAddress.postalCodeText | billingAddress.postalCode | postalCode | |
| orderAddress.countryName | billingAddress.countryCode | countryCode | |
| orderAddress.personName | shippingAddress.firstName +payload.shippingAddress.lastName | PersonName | |
| orderAddress.firstName | shippingAddress.firstName | firstName | |
| orderAddress.lastName | shippingAddress.lastName | lastName | |
| orderAddress.addressLine1 | shippingAddress.addressLine1 | addressLine1 | |
| orderAddress.addressLine2 | shippingAddress.addressLine2 | addressLine2 | |
| orderAddress.cityName | shippingAddress.city | city | |
| orderAddress.stateProvinceName | shippingAddress.state | state | |
| orderAddress.postalCodeText | shippingAddress.postalCode | postalCode | |
| orderAddress.countryName | shippingAddress.countryCode | countryCode | |
| orderAddress.contactPointType | [BillToAddress]or[ShipToAddress] | Type of contact | |
| fullFillmentLocation.id | payload.productList.fulfillmentLocation.storeId | storeId | |
| fullFillmentLocation.name | payload.productList.fulfillmentLocation.name | name | |
| fullFillmentLocation.addressLine1 | payload.productList.fulfillmentLocation.addressLine1 | addressLine1 | |
| fullFillmentLocation.cityName | payload.productList.fulfillmentLocation.city | city | |
| fullFillmentLocation.stateProvinceName | payload.productList.fulfillmentLocation.state | state | |
| fullFillmentLocation.countryName | payload.productList.fulfillmentLocation.countryCode | countryCode | |
| fullFillmentLocation.geoLatitude | payload.productList.fulfillmentLocation.latitude | latitude | |
| fullFillmentLocation.geoLongitude | payload.productList.fulfillmentLocation.longitude | longitude | |
| fullFillmentLocation.allowTryAtStore | payload.productList.fulfillmentLocation.allowTryAtStore | allowTryAtStore | |
| fullFillmentLocation.scanCodeType | payload.productList.fulfillmentLocation.productScanCodeType | productScanCodeType | |
| fullFillmentLocation.timeZone | payload.productList.fulfillmentLocation.timeZoneId | timeZoneId | |
| fullFillmentLocation.storeType | payload.productList.fulfillmentLocation.storeType | storeType | |
| fullFillmentLocation.contactPointType | [fullFillmentLocation] | Type of contact | |
| store.id | payload.productList.store.storeId | storeId | |
| store.name | payload.productList.store.name | name | |
| store.addressLine1 | payload.productList.store.addressLine1 | addressLine1 | |
| store.cityName | payload.productList.store.city | city | |
| store.stateProvinceName | payload.productList.store.state | state | |
| store.countryName | payload.productList.store.countryCode | countryCode | |
| store.geoLatitude | payload.productList.store.latitude | latitude | |
| store.geoLongitude | payload.productList.store.longitude | longitude | |
| store.allowTryAtStore | payload.productList.store.allowTryAtStore | allowTryAtStore | |
| store.scanCodeType | payload.productList.store.productScanCodeType | productScanCodeType | |
| store.timeZone | payload.productList.store.timeZoneId | timeZoneId | |
| store.storeType | payload.productList.store.storeType | storeType | |
| store.contactPointType | [fullFillmentLocation] | Type of contact | |
| party.contactPoints.contactPointType | ContactPointAddress or ContactPointEmail or ContactPointPhone | Type of contactPoint. | |
| party.contactpoints.id | "" | null | |
| activeFromDate | now timestamp | Active from Date. | |
| party.contactPoints.addressLine1 | profile.address.addressLine1 | AddressLine1. | |
| party.contactPoints.cityName | profile.address.city | CityName | |
| party.contactPoints.postalCodeText | profile.address.postalCode | PostalCode. | |
| party.contactPoints.stateProvinceName | profile.address.state | State. | |
| party.contactPoints.countryName | profile.address.countryCode | CountryCode. | |
| party.contactPoints.emailAddress | profile.email | Email. | |
| party.contactPoints.telephoneNumber | profile.phoneMobile | PhoneMobile. | |
| orderPayment. id | null | null | |
| orderPayment.transactionId | payload.paymentDetails.transactionId | transactionId | |
| orderPayment.paymentId | payload.paymentDetails.paymentId | paymentId | |
| orderPayment.paymentStatus | payload.paymentDetails.paymentStatus | paymentStatus | |
| orderPayment.paymentMethod | payload.paymentDetails.paymentMethod | paymentMethod | |
| orderPayment.paymentDevice | payload.paymentDetails.paymentDevice | paymentDevice | |
| orderPayment.paymentDate | payload.paymentDetails.captureDate | captureDate | |
| orderPayment.refundedAmount | payload.paymentDetails.totalRefundedAmount | totalRefundedAmount | |
| orderPayment.carriedOverForExchange | payload.paymentDetails.totalAmountCarriedOverForExchange | totalAmountCarriedOverForExchange | |
| orderPayment.paymentSequenceNumber | payload.paymentDetails.paymentSequenceNumber | paymentSequenceNumber | |
| orderPayment.authStatus | payload.paymentDetails.authStatus | authStatus | |
| orderPayment.captureStatus | payload.paymentDetails.captureStatus | captureStatus | |
| orderPayment.cardPresent | payload.paymentDetails.cardPresent | cardPresent | |
| orderPayment.expiryDate | payload.paymentDetails.expiryDate | expiryDate | |
| productPriceAdjustment.id | prcAdj.id | id | |
| productPriceAdjustment.description | prcAdj.description | description | |
| productPriceAdjustment.adjustment | prcAdj.adjustment | adjustment | |
| productPriceAdjustment.price | prcAdj.price | price | |
| productPriceAdjustment.priceAdjustmentType | prcAdj.priceAdjustmentType | priceAdjustmentType | |
| productPriceAdjustment.fulfillmentType | prcAdj.fulfillmentType | fulfillmentType | |
| productPriceAdjustment.promoCode | prcAdj.promoCode | promoCode | |
| productPriceAdjustment.autoAdjustment | prcAdj.auto | auto | |
| productPriceAdjustment.quantity | prcAdj.quantity | quantity | |
| productPriceAdjustment.discountValue | prcAdj.discountValue | discountValue | |
| productPriceAdjustment.discountType | prcAdj.discountType | discountType | |
| productPriceAdjustment.priceAfterItemDiscount | payload.productPriceAdjustments.priceAfterItemDiscount | priceAfterItemDiscount | |
| productPriceAdjustment.totalAdjustedPrice | payload.productPriceAdjustments.totalAdjustedPrice | totalAdjustedPrice | |
| productPriceAdjustment.totalTaxablePrice | payload.productPriceAdjustments.totalTaxablePrice | totalTaxablePrice | |
| productPriceAdjustment.totalAddtionalCharge | payload.productPriceAdjustments.totalAddtionalCharge | totalAddtionalCharge | |
| externalIds.externalIdType | NA | set to ["POS"] | |
| externalIds.externalId | profile.customerId | CustomerId. | |
| externalIds.statusLastChangedDate | now | "" | |
| externalIds.status | NA | set to "VALID" |
map-PredictSpring-loyalty-customer-to-cim
PredictSpring to Loyalty Customer CIM mapping
Source:
./src/main/resources/dwl/map-PredictSpring-loyalty-customer-to-cim.dwl
Mapping Tables
| CIM | PredictSpring | Description | |
|---|---|---|---|
| id | "" | null | |
| partyRoleType | Party | set to Party. | |
| party.personName | customers.firstName + customers.lastName | Customer Name. | |
| party.firstName | loyaltyProfile.address.firstName | Customer firstName. | |
| party.lastName | loyaltyProfile.address.lastName | Customer lastName. | |
| party.partyType | Individual | Hardcoded to Individual. | |
| party.contactPoints.contactPointType | ContactPointAddress or ContactPointEmail or ContactPointPhone | Type of contactPoint. | |
| party.contactpoints.id | "" | null | |
| activeFromDate | now timestamp | Active from Date. | |
| party.contactPoints.addressLine1 | profile.address.addressLine1 | AddressLine1. | |
| party.contactPoints.cityName | profile.address.city | CityName | |
| party.contactPoints.postalCodeText | profile.address.postalCode | PostalCode. | |
| party.contactPoints.stateProvinceName | profile.address.state | State. | |
| party.contactPoints.countryName | profile.address.countryCode | CountryCode. | |
| party.contactPoints.emailAddress | profile.email | Email. | |
| party.contactPoints.telephoneNumber | profile.phoneMobile | PhoneMobile. | |
| loyaltyProgramMember.accountId | profile.customerId | CustomerId. | |
| loyaltyProgramMember.storeId | loyaltyProfile.address.storeId | StoreId. | |
| loyaltyProgramMember.loyaltyProgramId | loyaltyProfile.accountNumber | AccountNumber. | |
| loyaltyMemberTier.name | loyaltyProfile.currentTier.name | CurrentTier Name. | |
| loyaltyMemberTier.display | loyaltyProfile.currentTier.display | Display Name. | |
| loyaltyMemberTier.imageURL | loyaltyProfile.currentTier.imageURL | ImageURL. | |
| communicationSubscriptionConsent.ownerId | loyaltyProfile.customerId | CustomerId. | |
| communicationSubscriptionConsent.name | name | "agreeToTC". | |
| communicationSubscriptionConsent.ownerId | loyaltyProfile.customerId | CustomerId. | |
| externalIds.externalIdType | NA | set to ["POS"] | |
| externalIds.externalId | profile.customerId | CustomerId. | |
| externalIds.statusLastChangedDate | now | "" | |
| externalIds.status | NA | set to "VALID" |