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

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

File received

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.

File archived

  ==>