Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
| Table of Contents |
|---|
How interface are Handled
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 :
- Username : talend_integration@solvay.com.crm
- Email : dataops@solvay.com
- Profile : Salesforce Integration, that provide the limited access 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 |
Integration Shipping Plant
| Jira | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
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 |
Integration UOM
| Jira | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
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 |
Integration Customer Product
| Jira | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
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 |
Integration CPC
| Jira | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
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 |