Tehnically there are Pricing interface that are handled throug Talend Job that Read SAP WP1 and PF1, or a Google Sheet then it also Read an Write in Saleforce some data.
Talend uses the follwing user to connect to Salesforce :
Each interface will be granted of a specific permission set that will allow to access relvant information in Saleforce.
For Pricing some extra process uses the Talend users
The datalake is also using the Talend user to access Salesforce and read data.
| Connecting user | Interface Details & link | Permission Set | |
|---|---|---|---|
| talend_integration@solvay.com.crm | Shipping plant | Integration Shipping Plant | |
| UOM | Integration UOM | ||
| Integration Customer Product | |||
| Integration CPC | |||
Data Lake |
Product2,Utility,Manufacturing_Plant__c, RecordType ==> READ
Manufacturing_Plant__c ==> Read & Update
Object | Field | Access |
|---|---|---|
Manufacturing_Plant__c | SLV48_MOQ__c | write |
Manufacturing_Plant__c | SLV48_Stock_Holding_Strategy__c | write |
Manufacturing_Plant__c | PP_HC_Code__c | write |
Manufacturing_Plant__c | PP_Special_Status__c | write |
Manufacturing_Plant__c | PP_Is_Deleted__c | write |
Manufacturing_Plant__c | PP_GBU__c | Read |
Product2 | Id | Read |
Product2 | ProductCode | Read |
Product2 | SLV11_PRO_GBU__c | Read |
Product2 | Type__c | Read |
Utility | Id | Read |
Utility | Name | Read |
Utility | SLV_Type__c | Read |
Utility | SLV5_1_Is_Active__c | Read |
Manufacturing_Plant__c | Record Type | Read |
RecordType | DeveloperName | Read |
RecordType | Id | Read |
Product : READ
GEN_SAP_Unit_of_Measure__c : Read Create Update
Object | Field | Access |
|---|---|---|
Product2 | Id | read |
Product2 | SLV11_PRO_SAP_External_ID__c | read |
Product2 | GEN_External_Id__c | read |
Product2 | SLV5_1_SAP_Origin__c | read |
Product2 | SLV11_PRO_GBU__c | read |
Product2 | Type__c | read |
GEN_SAP_Unit_of_Measure__c | GEN_Conversion__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_Counter__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_Denominator__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_External_ID__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_Is_Active__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_Is_Reference_Value__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_Product__c | write |
GEN_SAP_Unit_of_Measure__c | SLV11_PRO_SAP_External_ID__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_SAP_External_ID__c | write |
GEN_SAP_Unit_of_Measure__c | GEN_Unit_of_Measure__c | write |
Object | Access |
|---|---|
Product | Read |
Customer Product | Read, Create, Update, Delete |
Account | Read |
Object | Field | Access |
|---|---|---|
Product | Id | Read |
Product | SLV11_PRO_GBU__c | Read |
Product | Type__c | Read |
Product | SLV5_1_SAP_Origin__c | Read |
Product | ProductCode | Read |
Customer Product | Sales Org | Read, Edit |
Customer Product | Customer | Read, Edit |
Customer Product | Product | Read, Edit |
Customer Product | Customer Product Number | Read, Edit |
Customer Product | Customer Product Description | Read, Edit |
Account | Id | Read |
Account | RCS_ID__c | Read |
Account | PRS_ID__c | Read |
User, Account, Product2, Prcing Campaign, Utility ==> READ
Pricing Campaign CPC ==>Read & Create & Update & Delete
Object | Field | Access |
|---|---|---|
User | Id | Read |
User | username | Read |
User | Read | |
User | .sActive | Read |
Account | Id | Read |
Account | RCS_ID__c | Read |
Account | PRS_ID__c | Read |
Product2 | Id | Read |
Product2 | ProductCode | Read |
Product2 | SLV11_PRO_GBU__c | Read |
Product2 | SLV5_1_SAP_Origin__c | Read |
Pricing Campaign | Id | Read |
Pricing Campaign | SLV44_GBU__c | Read |
Utility | Id | Read |
Utility | Name | Read |
Utility | SLV5_1_Is_Active__c | Read |
Utility | SLV4_1_Involved_GBU__c | Read |
Utility | Type | Read |
Pricing Campaign CPC | API Name | Read & Edit |
Pricing Campaign CPC | SLV44_Pricing_Campaign__c | Read & Edit |
Pricing Campaign CPC | OwnerId | Read & Edit |
Pricing Campaign CPC | SLV44_Ship_to_Account__c | Read & Edit |
Pricing Campaign CPC | SLV44_Sold_To_Account__c | Read & Edit |
Pricing Campaign CPC | SLV44_Product_Level_5__c | Read & Edit |
Pricing Campaign CPC | SLV47_ShippingPlant__c | Read & Edit |
Pricing Campaign CPC | SLV44_Utility_Plant__c | Read & Edit |
Pricing Campaign CPC | SLV44_Business_Unit__c | Read & Edit |
Pricing Campaign CPC | SLV44_Incoterms__c | Read & Edit |
Pricing Campaign CPC | SLV44_Month_of_last_sales__c | Read & Edit |
Pricing Campaign CPC | PP_Last_Transportation_Mode__c | Read & Edit |
Pricing Campaign CPC | SLV44_Margin_squeeze_price__c | Read & Edit |
Pricing Campaign CPC | SLV44_Last_12M_Qty__c | Read & Edit |
Pricing Campaign CPC | SLV44_Next_3M_Qty__c | Read & Edit |
Pricing Campaign CPC | SLV44_Last_invoice_price__c | Read & Edit |
Pricing Campaign CPC | SLV44_Active_SAP_price__c | Read & Edit |
Pricing Campaign CPC | SLV44_Last_sales_VC__c | Read & Edit |
Pricing Campaign CPC | SLV44_Last_sales_ICM__c | Read & Edit |
Pricing Campaign CPC | SLV44_Variable_Costs_forward__c | Read & Edit |
Pricing Campaign CPC | SLV47_Forecasted12MQtyOfTheSoldTo__c | Read & Edit |
Pricing Campaign CPC | PP_Highest_ICM_of_past_12M__c | Read & Edit |
Pricing Campaign CPC | PP_Quarter_of_highest_ICM__c | Read & Edit |
Pricing Campaign CPC | PP_Priority__c | Read & Edit |
Pricing Campaign CPC | SLV44_Original_Currency__c | Read & Edit |
Pricing Campaign CPC | SLV44_Original_UOM__c | Read & Edit |
Pricing Campaign CPC | SLV44_Link_to_Pricing_Dashboard__c | Read & Edit |
Pricing Campaign CPC | PP_Last_FD__c | Read & Edit |
Pricing Campaign CPC | SLV_RMD_Comments__c | Read & Edit |
Pricing Campaign CPC | SLV44_Local_Currency__c | Read & Edit |