291449
DHL C-TMS
Order Import from Transport Manifest
FUNCTIONAL SPECIFICATION - 10.7
19/05/2011 - 1.1
Reference: FS 291449 NW-8L3JXV
Functional Overview
Client Requirement
Maintain the current ORDER_AND_LINE and LINE formats for the csv order upload but allow multiple items to be uploaded and order lines to be consolidated by DU Type and Product Type (instead of one item per line as at present).Functionality to be controlled by a system parameter maintained at Cost Centre level.
Solution
The CSV order import process will be changed for the ‘ORDER_AND_LINE’ import format to allow multiple items to be uploaded and order lines to be consolidated by despatch unit type and product type (instead of an item per order line as at present).
Order Sub-References will be added to the ‘ORDER_AND_LINE’ import format along with additional order fields required for this project.
This new functionality would be controlled by a system parameter configured by cost centre.
Scope
This change will be applied to system version 10.7.
Set-up
Pre-requisites
None
Menu Structure
No change
Data
- New cost centre based system parameter MANIFEST_ORDERS will be created.
- All required data for HUK_ORDER will be added to the ORDER_AND_LINE import format.
- New XML_DECODE value will be added for “Order WMS Ref”
Functional DESCRIPTION
CSV Order Import
A new XML decode value will be created for “Order WMS Ref” this will allow the data within the import file to be stored as a sub reference for the order and displayed in the “Add Refs” tab of the orders form.
The ‘IMP’ package will be changed to process Healthcare UK Orders.
A new cost centre based system parameter “MANIFEST_ORDERS” will be created.
The existing functionality within the PROCESS_TI_ORDER will be amended to ascertain the value of the MANIFEST_ORDER system parameter.
If the value has been set to “Y” the order may contain more than one order line. The procedure will then process each line consolidating the order lines by DU Type and Product Type; i.e. only one order line should be created for each DU type and product type combination and the quantity, weight and volume of the order will be a cumulative total of all order lines within the DU and product type.
Order items will be created for each order line when an item identifier is contained within the data. There may be multiple order items for a single order line.
A number of new fields will be contained within the import:
- Titles
- Order WMS Ref
- Message Medium
- Recipient SMS
- Recipient SMS 2
- Recipient SMS 3
- Recipient SMS 4
- Recipient Email
- UN Number
- Hazardous Description
- Hazardous Quantity
The Titles data will not be used within the order data.
The Order WMS ref will be used to create an entry in the SCH_ORD_REFERENCE table for the order. The data within the file will be used in the SUB_REF_VALUE column and the data for the SUB_REF_NAME column will be derived from the SOURCE_REF column on the IMP_DECODE table for the TARGET_VALUE of ‘Order WMS Ref’
The message medium will indicate if the recipient address is an SMS, email address or both and will be used to populate the required field on the order header.
The Recipient SMS and Recipient Email addresses will be used to update the correct fields on the order.
The UN_NUMBER, HAZARD_DESC and HAZARD_QTY import values will be used to create the HAZARDOUS_ITEMS data for the order. There may be multiple hazardous items associated with an order. If hazardous items are present the HAZARDOUS_ITEMS indicator on the order header will be updated to “Y”.
The order import will contain the following fields which are taken from the sample manifest above and will map to the shown import fields:
| Manifest Field | Import Field |
| TITLES | TITLES |
| OWNING_DEPOT | COST_CENTRE |
| ORDER_WMS_REF | ORDER_WMS_REF |
| SHIPMENT_WMS_REF | SHIP_REF |
| CUST_ORD_REF | EXT_REF |
| WMS_CUSTOMER | CUSTOMER |
| FROM_LOC_REF | FROM_LOC |
| TO_LOC_REF | TO_LOC |
| COMMENTS | ORD_COMMENTS |
| DELIVERY_INSTRUCTIONS | SPECIAL_INSTR |
| PROD_TYPE | PRODUCT |
| TU_TYPE | DU_TYPE |
| TU_QTY | QTY |
| TU_WEIGHT | WEIGHT_KG |
| TU_VOLUME | VOL_CU_M |
| ECT | EARLY_AVAIL |
| LCT | LATE_AVAIL |
| EDT | EARLY_DEL |
| LDT | LATE_DEL |
| BOOKING_REF | BOOKING_REF |
| ORDER_TYPE | DEL_TYPE |
| MSG_MEDIUM | MSG_MEDIUM |
| RECIPIENT_ADDRESS_SMS | RECIPIENT_SMS |
| RECIPIENT_ADDRESS_SMS2 | RECIPIENT_SMS2 |
| RECIPIENT_ADDRESS_SMS3 | RECIPIENT_SMS3 |
| RECIPIENT_ADDRESS_SMS4 | RECIPIENT_SMS4 |
| RECIPIENT_ADDRESS_EMAIL | RECIPIENT_EMAIL |
| UN_NUMBER | UN_NUMBER |
| DESCRIPTION | HAZARD_DESC |
| QTY | HAZARD_QTY |
Table Updates Required
[DATA_IMP_DECODE_291449.sql DATA_IMP_DECODE_291449.sql]
[DATA_ADM_SYSTEM_PARAM_291449.sql DATA_ADM_SYSTEM_PARAM_291449.sql]
[DATA_IMP_RECORD_FORMAT_291449.sql DATA_IMP_RECORD_FORMAT_291449.sql]
[DATA_IMP_FIELD_291449.sql DATA_IMP_FIELD_291449.sql]
[DATA_IMP_FIELD_SOURCE_291449.sql DATA_IMP_FIELD_SOURCE_291449.sql]
References
| EST-291449 NW-8L3JXV Order Import from Transport Manifest v1.0.doc | |||
Glossary
| C-TMS | Calidus TMS |
Document History
| Initial version | ||||
| Review of the initial draft | ||||
| Issued to client | ||||
| Added 3 extra SMS address to the import. | ||||
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
