=======================================================================

=======================================================================

MFT

FTP

Dynasys file loading moved from FTP to MFT

Contacts on Dynasys side

Developper :

Laura Labbadi

Exploitation : 

LAURE PICHOT-PLASSE <laure.pichot-plasse@solvay.com>,
"Min(mark) Yu" <min.yu@solvay.com>,
Lei Shen <lei.shen@solvay.com>,
Pablo Prieri <pablo.prieri@solvay.com>,
Olivier Descamps <olivier.descamps@solvay.com>,
Etienne Ribet-ext <etienne.ribet-ext@solvay.com>,
Maggie MA <maggie.ma@solvay.com>

File received

Frequency of export of file SAFIRZD30.CSV from DynaSys : generate the file two times per day:

• 23h00 CET
• 18h15 CET (so that Asian could see the data D+1 in their morning)

Contain Forecasts from the current month.

Loader and SQL 

Remark :

The loader loads the SOLD_TO_CUSTOMER on 11 digits in the TMP_GL_FORECAST_APO because of an hidden character at the end of the Dynasys file.

With the SQL from TMP to REC and PROD, we get the substring of 10 first digits of the Sold-To code. So in REC and PROD, the customer code is well back on 10 digits.

Archived

  ==>