273478
DHL MTS
Iggesund EDI Phase II Amendment
FUNCTIONAL SPECIFICATION - 10.5
10/02/2010 - 1.0
Reference: FS-273478 MW-7ZUKLV
Client Requirement
The 2nd EDI will now contain the Actual Quantity despatched within the EDI message received.
As the 2nd EDI was adapted to provide both initial PO details and updated transit details - the quantity given was the initial plan so therefore was not mapped to the Tracking screen as a simple copy was carried out as both quantities would be the same - now this will contain the actual quantity despatched, this could be different to the planned we now need this mapping to the Actual Quantity element of the Tracking screen.
This will totally remove the requirement to print an individual loading report for all vehicles and manually enter in the details into MTS.
Solution
The existing inbound EDI message for client ‘Iggesund’ will be modified to include an extra item for the ‘Actual Despatched Quantity’ despatched after the existing last item for the ‘Actual Departure’ date.
This extra item will be considered to be optional for the first upload of the EDI message like the items ‘Vehicle ID’, ‘Actual Weight’, ‘Actual Arrival’ and ‘Actual Departure’, therefore it will be assessed with the other four items during the second upload.
The existing functionality for the extra items for the second upload will be retained but the ‘Actual Despatched Quantity’ will be validated to ensure that it is numeric if it is provided, the quantity will then update the ‘Actual Despatched Quantity’ of the scheduled order lines in preference to the existing quantity provided.
The ‘Actual Despatched Quantity’ will be stored as a new column on the ‘Interface Order Header’ table for reference but will not be displayed in the ‘Interface Errors’ screen.
NB No implementation assistance has been quoted for at this time. Assistance required during UAT will be charged on a T&M basis.
Scope
This change will be applied to system version 10.6 on IIBTST and once approved IIBPRD.
Set-up
Pre-requisites
The table ‘INT_ORDER_HEADER’ will need to be updated to include a new column as described in the ‘Data’ section below.
Menu Structure
Unchanged
Data
The table ‘INT_ORDER_HEADER’ will be updated to include a new column called ‘ACTUAL_DESPATCHED_QUANTITY’ and will be performed prior to the new programs being placed into test and live on a time and materials basis.
The new column will be of type ‘NUMBER(24,4)’ when added to the table and will be nullable. See Appendix A for how to insert the new column.
Functional Description
Format of ‘Iggesund’ Order Message
The format of the ‘Iggesund’ order message will be changed to include an extra item for the ‘Actual Despatched Quantity’ for the second upload of the order details.
The ‘Actual Despatched Quantity’ will be the last item on the ‘DETAIL’ line in the file located after the ‘Actual Departure Date’ item and it will be a numeric item.
For example:
No changes will be required or the directory structure to upload the files in the new format.
The new item will not be displayed in the ‘Interface Errors’ screen.
Package ‘INT_MSG’
The package ‘INT_MSG’ will be changed for the upload of the file to process the new item.
The procedure ‘PROCESS_IGGESUND_ORDER_FILE’ will be changed to extract the new item into the variable ‘R_ORDER. ACTUAL_DESPATCHED_QUANTITY’ from the last position of the ‘DETAIL’ line received. The new item will then be validated to ensure that it is numeric and does not contain any characters such as a decimal point, if it does then an error message will be generated ‘The actual despatched quantity must be numeric’ and the upload will be rejected.
The extra item will then be stored on the table ‘INT_ORDER_HEADER’ in the new column ‘ACTUAL_DESPATCHED_QUANTITY’ for future reference.
It is expected that the ‘Actual Despatched Quantity’ will be blank for a new order that is being uploaded but if it is not then it will be ignored: if a new order is uploaded because the vehicle ID provided is blank then the actual despatched quantity of the order line will not be populated at this point via the procedure ‘OMS_INT.PROCESS_UNISON_RECORD’.
The function ‘F_UPDATE_IGGESUND_ORDER’ will be changed to extract the new item ‘INT_ORDER_HEADER.ACTUAL_DESPATCHED_QUANTITY’ via the cursor ‘C_FILE’ into the variable ‘R_FILE.ACTUAL_DESPATCHED_QUANTITY’.
If the order is being processed for the second time then the variable ‘R_FILE.ACTUAL_DESPATCHED_QUANTITY’ will be used in preference to the existing variable ‘R_ORDER.QUANTITY’ when calling function ‘TRM.SET_ACTUAL’ for action ‘LINE_QTY’.
This function will then update ‘SCH_ORDER_LINE.ACTUAL_DESPATCHED_QUANTITY’ with the actual despatched quantity so that it is stored against the order line being processed.
Table Updates Required
The new column ‘ACTUAL_DESPATCHED_QUANTITY’ will be added to the table ‘INT_ORDER_HEADER’ as follows:
| Name | Type | Nullable | Default | Storage | Comments |
| ACTUAL_DESPATCHED_QUANTITY | NUMBER(24,4) | Y |
References
| EST-273478 MW-7ZUKLV Iggesund EDI Phase II Amendment v1.0.doc | |||
Document History {Update date and Initial on completion – then delete this line of info}
| Initial version | ||||
| Reviewed and Issued v1.0 | ||||
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
