This document describes the data maintenance on CEP platform.


Table of Contents



Introduction 

The platform is designed to share commercial processes with customers (Solvay's externals). This implies datas and documents sharing. Those ones are already existing in Solvay's IS, wether they are stored in Salesforce or Documentum referentials.

Therefore, few datas are specifically  managed in and for CEP.


Nethertheless, some CEP specific datas are required : 

  • A distributor can't be authorized to order samples from all the Solvay's catalog, or to download documents on every product. Indeed, Solvay and distributors are tied by a contract listing a limited number of product open for sale.
    • This business reality constraints CEP to apply a filter on a certain number of products
    • This filter applies to a corporate group
    • This is the Authorized Product List described below
  • To automate sample request process, the manufacturing plant must be calculated. The process is described in Sample request Section, but sample center matrix tables are needed : 
    • Plant to Order

    • Country to SCM

    • Plant to SCM

    • SCM to Product

Authorized Product List

(SLV9_Customer_Product_Association__c)

Pre-requisite

The mapping has to be setup whenever a NEW roll-out of a DISTRIBUTOR, based on the Corporate Group

As a pilot for Azelis, the data has been extracted from SAP for the last 2 years sample ordering in the SAP.


Purpose
  • Allow the customer, typed DISTRIBUTOR, to see a restricted list of products that are under his/her contract
  • Used to populate the PRODUCT dropdown list in screens
  • Serves for:
    • Sample request ordering
    • Customer request ordering
    • Access to product-related documentations (SDS, TDS, RDS)
Common NameCRM Technical Fields NameExample values

CRM Account Corporate Group ID

SLV9_Account_Name__c00124000014bozuAAA
CRM Account Corporate Group NameSLV10_Account_Corporate_Group__cAZELIS
CRM GBUSLV10_GBU__cNovecare
Name (what is displayed in the dropdown list)NameALKAMULS A
Product CodeSLV9_Product_Code__c90001914
Product NameSLV9_Product_Label__cALKAMULS A
Material CodeSLV9_Material_Code__c81699
Material NameSLV9_Material_Label__cALKAMULS A ECHANTILLON



Plant to Order

(SLV_Utility__c_plantToOrder)

Pre-requisite


Purpose
  • Used in the SAMPLE REQUEST ORDERING for Shipping Plant Determination
  • Serves
Common NameCRM Technical Fields NameExample values

Plant Code

SLV9_Plant_Code_SAP__c
7512
Plant NameSLV9_Plant_Name_SAP__c
ZFR3 Clamecy
Ordering system (either SFDC or SAP)SLV9_Ordering_System__cSAP
Record typeRecordTypeId0125E0000003Xg0QAE
TypeSLV_Type__cPlantToOrder



Country to SCM

(SLV_Utility__c_countryToSCM)

Pre-requisite


Purpose
  • Used in the SAMPLE REQUEST ORDERING for Shipping Plant Determination
  • Serves
Common NameCRM Technical Fields NameExample values

Region

SLV9_Region__cEMEA
CountrySLV9_Country__cGermany
Sample CenterSLV9_Sample_Center__c
Clamecy
Back end systemSLV9_Back_end_System__c

Record TypeRecordTypeId
0125E0000003Xg0QAE
TypeSLV_Type__c

CountryToSCM

Sample Center CodeSLV9_Sample_Center_Code__c

7512



Plant to SCM

(SLV_Utility__c_plantToSCM)

Pre-requisite


Purpose
  • Used in the SAMPLE REQUEST ORDERING for Shipping Plant Determination
  • Serves
Common NameCRM Technical Fields NameExample values

SAP Plant Code

SLV9_Plant_Code_SAP__c
7512
SAP Plant NameSLV9_Plant_Name_SAP__c
ZFR3 Clamecy
Simplified Plant NameSLV9_Plant_Name_Simplified__cClamecy (EU)
RegionSLV9_Region_ShortName__cEU
CountrySLV9_Country__cFrance
Sample CenterSLV9_Sample_Center__c

Clamecy

Record TypeRecordTypeId

0125E0000003Xg0QAE

TypeSLV_Type__c

PlantToSCM

Sample Center CodeSLV9_Sample_Center_Code__c

7512



SCM to Product

(SLV_Utility__c_SCMToProduct)

Pre-requisite


Purpose
  • Used in the SAMPLE REQUEST ORDERING for Shipping Plant Determination
  • Serves
Common NameCRM Technical Fields NameExample values

Sample Center

SLV9_Sample_Center__c

Clamecy
Material Code

SLV9_Material_Code__c

81828

Material NameName

ABEX 18S ECHANTILLON

Record TypeRecordTypeId

0125E0000003Xg0QAE

TypeSLV_Type__c

SCMToProduct

Sample Center CodeSLV9_Sample_Center_Code__c

7512