=======================================================================
=======================================================================
Chemlogics sales are sent for Novecare, from a non-SAP source (Chemplex source is named SAGE)
They are related to legal entity "0143 - CHEMLOGICS"
Chemlogics sales are received in PPE only (finest detail by customer/material)
Our contacts on Chemlogics side for the interface are Mark Farrales & Kenneth Long
Files are sent from SAGE (chemplex) to BI4 using NFS copy
This step is on Chemplex side
Once the file is created in Chemplex side, ,NFS copy files to exploit/arrivee
IP address for CHEMSQL 10.169.168.7
IP address for CHEMSQL 10.169.25.163 / server 150.251.116.33 → changed on 23/10/2019 due to VLAN migration
IP address for CHEMSQL 10.76.120.4 / server USCEKDB01 → from 15/11/2019
FTP access via ftp://10.76.120.4:21
Physical path is: \\uscekdb01\C$\inetpub\ftproot
Credentials: User : SolvayFTP; PW : *f\?CD?= (those can be changed if needed)
frequency : daily
received in PPS : /exploit/PR_PIL/PEP
file name : PCCUST_CHEMPLEX_CUST
source code in BI4 : CHEMPLEX20
In SAGE, Payer represents a master sales account, and Sold-To represents any of potentially numerous decentralized purchasing units per master account.
Because of this, Chemplex uses the Payer account to consolidate and monitor sales. It's the de facto equivalent of Sold To in SAP.
Then : SAGE-Payer=RCS-Sold-To=RCS-payer,
SAGE-Sold-To = RCS-Ship To.
frequency : daily
received in PPE : /exploit/PR_ECO/DW2
file name : PECO_CHEMPLEX_DATA
source code in BI4 : CHEMPLEX20
Sales and quantities are updated daily in SAGE ==> updated daily in BI4
But logistic costs are frozen and updated only once a month in SAGE (at end of month). nb : Logistic cost = R12910 in P&L
no file is received for new Chemplex materials
When sales are loaded, new materials are created in PE_DC :
And then transferred in PEPDBA.MARA → GBR_DC.GBR_PRODUCT
nb : by default all Chemplex materials are allocated to material division=UZ