278837
DHL MTS
XML Order Flow Extract
FUNCTIONAL SPECIFICATION - 10.6
- 1.0
Reference: FS 278837 PA-873KHW
Functional Overview
Client Requirement
Create a new extractable report in Excel format to list all XML Order flow into C-TMS. This will be for records with a status of “Success” and “Failure”.
Solution
Provide CSV Export from the Exports. The export will run with no parameters associated with the report.
The export will include the following columns;
| INT_RECORD_ID |
| INT_FILENAME |
| MTS_OPERATION |
| RECORD_STATUS |
| SOURCE_SYSTEM |
| SCHED_NAME |
| WMS_WAREHOUSE |
| CUSTOMER |
| EXTERNAL_REF |
| DEL_POINT_REF |
| BOOKING_REF |
| BOOK_DATE |
| SPECIAL_INSTRUCTIONS |
| ORDER_COMMENTS |
| EARLY_AVAIL |
| LATE_AVAIL |
| EARLY_DEL |
| LATE_DEL |
| GROUP_NAME |
| DEL_TYPE |
| COST_CENTRE_NAME |
| TEMP_COMBO_ID |
| ADDRESS_TYPE_DEP |
| LOCATION_ID_DEP |
| LOCATION_NAME_DEP |
| ADDRESS_LINE1_DEP |
| ADDRESS_LINE2_DEP |
| ADDRESS_LINE3_DEP |
| TOWN_DEP |
| COUNTY_DEP |
| COUNTRY_CODE_DEP |
| POSTCODE_DEP |
| ADDRESS_TYPE_DEL |
| LOCATION_ID_DEL |
| LOCATION_NAME_DEL |
| ADDRESS_LINE1_DEL |
| ADDRESS_LINE2_DEL |
| ADDRESS_LINE3_DEL |
| TOWN_DEL |
| COUNTY_DEL |
| COUNTRY_CODE_DEL |
| POSTCODE_DEL |
| DUPLICATE_ORDER |
| VALIDATION_ERROR |
| MSG_TYPE |
| ACTION |
| CREATED_DATE |
| CREATED_BY |
| UPDATED_DATE |
| UPDATED_BY |
| OMS_REF |
| LANE_COMMENTS |
| DEPOT_DEP |
| CUST_GROUP_DEP |
| LOADING_RATE_DEP |
| UNLOADING_RATE_DEP |
| LATITUDE_DEP |
| LONGITUDE_DEP |
| DEPOT_DEL |
| CUST_GROUP_DEL |
| LOADING_RATE_DEL |
| UNLOADING_RATE_DEL |
| LATITUDE_DEL |
| LONGITUDE_DEL |
| KEY_CODE |
| TRAILER_SET_DEP |
| TRAILER_SET_DEL |
| CONF_DATE |
| CONF_USER |
| CONF_COMMENT_1 |
| CONF_COMMENT_2 |
| CONF_COMMENT_3 |
Scope
This change will be applied to system version 10.6 on CONTST and once approved CONPRD.
Set-up
Pre-requisites
None
Menu Structure
Unchanged
Data
The new export will be added to the standing data to allow it to be selected from the standard exports form. There will be no selection criteria associated with this report.
Functional Description
The data for the export will be based on XML Order flow information.
Table Updates Required
No table changes are required for this development.
References
| AS - 76SC99 Warehouse Extract v2.2.xls | |||
Document History
| Initial version | ||||
AUTHORISED BY
| Dave Meir | Development Manager | |
| Suk Sandhu | TMSCC MTS Product Manager |
