View source for 268520 (JB-7V5JP2) - (Unilever Interface)

{{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Unilever Interface|Reference=FS 268520 JB-7V5JP2 |Version=2.0|Date=28/08/2009|Sysver=10.6|Client=DHL MTS}}


== Client Requirement ==
West Thurrock is having a new WMS implemented (DAI Matflo system). DHL will re-use and modify slightly the message specs used in the BEIG development as that was a DAI WMS messaging into MTS.

Requirements are to send a T_ORD via ESI into MTS and for MTS to send a T_LOAD to the WMS. This will be over ftp and we would like the same functionality as BEIG , push messaging for the T_LOAD , and the changes made to cater for the cross docking. T_LOADS should only be sent where the loading depot is DHLUNWTK.

== Solution ==
A new flow will be set up in MTS. The flow will be controlled by a new database job that will run at set intervals. Inbound files will be placed (by ESI) in the agreed directory, and these files will be picked up and processed using the existing inbound order packages. Validation will be identical to the Birdseye interface previously developed the format will be based on TripOrderv2.3.xsd. 

A new trigger will be created to process the outbound messages. This trigger will be specific for Unilever, so only trips with a loading depot of DHLUNWTK will be picked up by the trigger. A new procedure will be added to the existing XML creation process to create and send the files in generic XML format based on TripOrderv2.3.xsd


[[Image:268520_1.png]]


== Scope ==
This change will be applied to system version 10.6. 

= Set-up =
== Pre-requisites ==
== Menu-Structure ==
== Data ==
System Parameters are required for the inbound flow.

:UNI_INBOUND_PATH - Area where files are placed to be processed

:UNI_INBOUND_FAIL  - Area where failed files are placed. 

:UNI_INBOUND_IDENTIFIER - Filename Prefix

:UNI_INBOUND_LISTING_NAME - List which will hold files to be processed.

:UNI_LISTING_SCRIPT_NAME - Script will process the files


:UNI_FTP_DESTINATION_DIRECTORY

:UNI_FTP_DESTINATION_IP_ADDRESS

:UNI_FTP_DESTINATION_PASSWORD

:UNI_FTP_DESTINATION_PORT

:UNI_FTP_DESTINATION_USERNAME

:UNI_OUTBOUND_ARCH

:UNI_OUTBOUND_FAIL

:UNI_OUTBOUND_PATH

= Functional Description =
Files will be placed in the directory specified in the system registry UNI_INBOUND_PATH. A new database job will be set up specifically for Unilever files. This job will run at a set interval, and will pick up files and process them creating the necessary orders. 

The existing inbound process will be used to import and process the files. 

A trigger will be added to the following tables:-

:SCH_HAULAGE_ACTIVITY

:SCH_TRIP

:SCH_TRIP_STOP

When one of the following actions is performed a record will be written to the table INT_XML_CONTROL. The record will only be written if the loading depot is DHLUNWTK

:Trip set to accepted

:Trip at accepted and times changed

:Trip at accepted and order added to the trip. 

A new database job will be setup to run at a set interval. This job will retrieve any records from the table for Unilever and run a new procedure in INT_XML_OUT2. For each record that is found an XML file will be created and placed in the outbound directory listed in the system registry. The xml files will be created in the generic XML format based on TripOrderv2.3.xsd (attached in section 1). 

The processed files will then be pushed via FTP to ESI. The destination for the FTP can be set at a system registry level. 


'''Document History'''

{| style="border-spacing:0;"
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Version'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Date'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Status'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Reason'''</center>
| style="background-color:#c0c0c0;border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Initials'''</center>

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>1</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>28/08/09</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>Draft</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| Initial version
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>DNG</center>

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| 

|}

=AUTHORISED BY=

{| Border="1"	
| '''''Matt Crisford'''''
| Development Manager
| 

|-
| '''''Peter Greer'''''
| TMSCC MTS Product Manager 
| 

|}