281871: Difference between revisions

From CTMS
No edit summary
No edit summary
Line 3: Line 3:




[[Image:]]




1. Functional Overview
<center>'''DHL MTS'''</center>
1.1 Client Requirement
 
Change Request Summary:
 
<center>'''10.5'''</center>
 
 
 
{| style="border-spacing:0;"
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''FUNCTIONAL SPECIFICATION'''</center>
 
 
<center>'''281871 JC-89ZHDD Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres'''</center>
 
 
 
 
|}
 
{| style="border-spacing:0;"
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <div align="right">'''Version :'''</div>
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''2.0'''</center>
 
|}
'''Copyright OBS Logistics © 2010'''
 
 
The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied
 
 
'''Contents'''
 
 
[#__RefHeading__57_685495578 1. Functional Overview4]
 
[#__RefHeading__59_685495578 2. Set-up5]
 
[#__RefHeading__61_685495578 3. Functional Description6]
 
[#__RefHeading__63_685495578 Appendix A table updates REQUIRED8]
 
[#__RefHeading__65_685495578 Appendix B QUOTE & DoCuMENT History9]= Functional Overview =
== Client Requirement ==
'''Change Request Summary:'''
 


Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres.
Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres.


Change Request Details:
 
'''Change Request Details:'''
 


Currently within CTMS reports there is a report called CN Load Manifest (attached to RIO). A need has been identified to create a new report which would be the same in all details to the CN Load Manifest except the Deliver To field would be the final location of the order not the Cross Dock location, the destination field (top centre) of the report would be the Cross Dock location (E.g. SWCONSOL). Please note this is a request to create an additional report very similar to the existing report not modify the existing report.
Currently within CTMS reports there is a report called CN Load Manifest (attached to RIO). A need has been identified to create a new report which would be the same in all details to the CN Load Manifest except the Deliver To field would be the final location of the order not the Cross Dock location, the destination field (top centre) of the report would be the Cross Dock location (E.g. SWCONSOL). Please note this is a request to create an additional report very similar to the existing report not modify the existing report.


Benefits identified as a result of the change:
 
'''Benefits identified as a result of the change:'''
 


Indentified as a requirement of the Consumer Consolidation Centre process.
Indentified as a requirement of the Consumer Consolidation Centre process.




1.2 Solution
== Solution ==
A new report called ‘CN Load Manifest for Consol Centres’ will be created based on the existing report called ‘CN Load Manifest’.
A new report called ‘CN Load Manifest for Consol Centres’ will be created based on the existing report called ‘CN Load Manifest’.


The new report will have the following adaptations for cross-dock trips:
The new report will have the following adaptations for cross-dock trips:


1. The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.
 
2. The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
# The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.
3. The ‘DESTINATION’ title will be renamed ‘Consol Centre’.
# The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
# The ‘DESTINATION’ title will be renamed ‘Consol Centre’.


The selection criteria will be the same as report ‘CN Load Manifest’.
The selection criteria will be the same as report ‘CN Load Manifest’.


There will be no restriction on the type of trip for which the new report may be run.
There will be no restriction on the type of trip for which the new report may be run.




1.3 Scope
== Scope ==
This change will be applied to system version 10.6.
This change will be applied to system version 10.6.  
2. Set-up
 
2.1 Pre-requisites
= Set-up =
== Pre-requisites ==
The relevant users will need to have access to the new report.
The relevant users will need to have access to the new report.


2.2 Menu Structure
 
== Menu Structure ==
The new report will be added to the ‘Reports’ menu.
The new report will be added to the ‘Reports’ menu.


2.3 Data
 
== Data ==
The parameters for the new report will need to be setup (see Appendix A for further details).
The parameters for the new report will need to be setup (see Appendix A for further details).




= Functional Description =
== Data Setup ==
The new report will require the same set of parameters as the existing ‘Load Manifest’ report but will need to be setup separately so that the new program is run.




 
<center>[[Image:]]</center>
 
 
3. Functional Description
3.1 Data Setup
The new report will require the same set of parameters as the existing ‘Load Manifest’ report but will need to be setup separately so that the new program is run.
 




Line 61: Line 110:




3.2 LOAD_MANIFEST_CONSOLCENTRE.rep   
== LOAD_MANIFEST_CONSOLCENTRE.rep  ==
The new ‘Load Manifest for Consol Centres ’ report will be created with the same layout as the existing ‘Load Manifest’ report and will be based on version 1.0 of program ‘LOAD_MANIFEST.rep’.
The new ‘Load Manifest for Consol Centres ’ report will be created with the same layout as the existing ‘Load Manifest’ report and will be based on version 1.0 of program ‘LOAD_MANIFEST.rep’.


The new report will have the following adaptations for cross-dock trips:
The new report will have the following adaptations for cross-dock trips:


1. The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.


2. The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
# The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.
 
3. The ‘DESTINATION’ title will be renamed ‘CONSOL CENTRE’.


# The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.


# The ‘DESTINATION’ title will be renamed ‘CONSOL CENTRE’.


The changes will be applied to the following layout:
The changes will be applied to the following layout:




<center>[[Image:]]</center>




1. The ‘DELIVER TO’ field will be changed from value ‘F_LOCATION_NAME1’ to value ‘F_LOCATION_NAME2’, this will then display the value from item ‘GEO_LOCATION_FINAL.LOCATION_ID’.
# The ‘DELIVER TO’ field will be changed from value ‘F_LOCATION_NAME1’ to value ‘F_LOCATION_NAME2’, this will then display the value from item ‘GEO_LOCATION_FINAL.LOCATION_ID’.


2. The existing ‘DESTINATION’ field will be changed from a blank to display the value ‘F_LOCATION_NAME1’, this will then display the value from item ‘GEO_LOCATION_UNLOAD.LOCATION_ID’.
# The existing ‘DESTINATION’ field will be changed from a blank to display the value ‘F_LOCATION_NAME1’, this will then display the value from item ‘GEO_LOCATION_UNLOAD.LOCATION_ID’.


3. The existing ‘DESTINATION’ field will be renamed to have the title ‘CONSOL CENTRE’.
# The existing ‘DESTINATION’ field will be renamed to have the title ‘CONSOL CENTRE’.


4. The title of the report will be ‘LOAD MANIFEST FOR CONSOL CENTRES’ in the page heading.
# The title of the report will be ‘LOAD MANIFEST FOR CONSOL CENTRES’ in the page heading.


The layout of the report will not be changed so that the new values occupy the same positions as the old values.
The layout of the report will not be changed so that the new values occupy the same positions as the old values.


There will be no restriction on the type of trip for which the new report may be run; therefore the existing queries will not be changed.
There will be no restriction on the type of trip for which the new report may be run; therefore the existing queries will not be changed.
Appendix A      table updates REQUIRED
The following script may be run to setup the data for the new report:


#
#:
#::
#:::
#::::
#:::::
#::::::
#:::::::
#:::::::# '''table updates REQUIRED'''


Appendix B      QUOTE & DoCuMENT History
The following script may be run to setup the data for the new report:
 
Activity
Estimate
Quote
 
No. of Days
No. of Days
Daily Rate (£)
Cost (£) Exc. VAT
 
 
 
 
 
Work to Date
0.00
0.00
500
 
Change Request Evaluation
0.50
0.50
500
 
Functional Specification
0.50
0.50
500


Technical Specification
0.00
0.00
500


Development
[[Image:]]
1.00
1.00
417


Testing & Release
#
0.50
#:
0.50
#::
417
#:::
#::::
#:::::
#::::::
#:::::::
#:::::::# '''QUOTE & DoCuMENT History'''


Implementation
0.00
0.00
462


{| style="border-spacing:0;"
| style="background-color:#e5e5e5;border-top:0.039cm double #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| '''Activity'''
| style="background-color:#e5e5e5;border-top:0.039cm double #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.212cm;padding-right:0.212cm;"| <center>'''Estimate'''</center>
| colspan="3"  style="background-color:#e5e5e5;border-top:0.039cm double #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| <center>'''Quote'''</center>


|-
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>'''No. of Days'''</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>'''No. of Days'''</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>'''Daily Rate (£)'''</center>
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| '''Cost (£) Exc. VAT'''


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|
| 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.212cm;padding-right:0.212cm;"|
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"|
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| Work to Date
| 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.212cm;padding-right:0.212cm;"| <center>0.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>0.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>500</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| Change Request Evaluation
| 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.212cm;padding-right:0.212cm;"| <center>0.50</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>0.50</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>500</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


TOTAL
|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| Functional Specification
| 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.212cm;padding-right:0.212cm;"| <center>0.50</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>0.50</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>500</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| Technical Specification
| 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.212cm;padding-right:0.212cm;"| <center>0.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>0.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>500</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| Development
| 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.212cm;padding-right:0.212cm;"| <center>1.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>1.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>417</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| Testing & Release
| 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.212cm;padding-right:0.212cm;"| <center>0.50</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>0.50</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>417</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| Implementation
| 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.212cm;padding-right:0.212cm;"| <center>0.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>0.00</center>
| style="background-color:#e5e5e5;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.212cm;padding-right:0.212cm;"| <center>462</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


References
|-
Ref No
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|
Document Title & ID
| 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.212cm;padding-right:0.212cm;"|
Version
| 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.212cm;padding-right:0.212cm;"|
Date
| 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.212cm;padding-right:0.212cm;"|
1
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|
EST-281871 JC-89ZHDD Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres v1.0.doc
1.0
22/10/10


|-
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.039cm double #000000;border-left:0.039cm double #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"| ==== TOTAL ====


| style="border-top:0.018cm solid #000000;border-bottom:0.039cm double #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.039cm double #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|
| style="background-color:#e5e5e5;border-top:0.018cm solid #000000;border-bottom:0.039cm double #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.039cm double #000000;border-left:0.018cm solid #000000;border-right:0.039cm double #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.212cm;padding-right:0.212cm;"|


|}
'''References'''




{| 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>'''Ref No'''</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>'''Document Title & ID'''</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>'''Version'''</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>'''Date'''</center>


|-
| style="border-top:none;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:none;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;"| EST-281871 JC-89ZHDD Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres v1.0.doc
| style="border-top:none;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.0</center>
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>22/10/10</center>


|-
| style="border-top:none;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:none;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:none;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:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right: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:none;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:none;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:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|


Glossary
|}
Term or Acronym
'''Glossary'''
Meaning




{| 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>'''Term or Acronym'''</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>'''Meaning'''</center>


|-
| style="border-top:none;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:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|


|-
| style="border-top:none;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:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|


|-
| style="border-top:none;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:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|


|}
'''Document History'''


Document History
Version
Date
Status
Reason
Initials
0.1
29/11/10
Draft
Initial version
PDR
1.0
30/11/10
Issued
Reviewed & Issued
MJC
1.1
01/12/10
Revised
See Red for details
JC
2.0
02/12/10
Issued
Approved Jamie’s amendments.
MJC


{| 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>0.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>29/11/10</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>PDR</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.0</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>30/11/10</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>Issued</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;"| Reviewed & Issued
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>MJC</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.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>01/12/10</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>Revised</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;"| See Red for details
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>JC</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>2.0</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>02/12/10</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>Issued</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;"| Approved Jamie’s amendments.
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>MJC</center>


Authorised By
|-
| 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'''


Matt Crisford


Development Manager


{| style="border-spacing:0;"
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''''Matt Crisford'''''
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| Development Manager
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|


Peter Greer
|-
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''''Peter Greer'''''
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| TMSCC MTS Product Manager
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:none;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|


TMSCC MTS Product Manager
|}

Revision as of 12:08, 11 May 2011

Aptean Logo.png







DHL MTS

Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres


FUNCTIONAL SPECIFICATION - 10.5

02/12/2010 - 2.0
Reference: FS 281871 JC-89ZHDD













































[[Image:]]


DHL MTS


10.5


FUNCTIONAL SPECIFICATION


281871 JC-89ZHDD Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres



Version :
2.0

Copyright OBS Logistics © 2010


The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied


Contents


[#__RefHeading__57_685495578 1. Functional Overview4]

[#__RefHeading__59_685495578 2. Set-up5]

[#__RefHeading__61_685495578 3. Functional Description6]

[#__RefHeading__63_685495578 Appendix A table updates REQUIRED8]

[#__RefHeading__65_685495578 Appendix B QUOTE & DoCuMENT History9]= Functional Overview =

Client Requirement

Change Request Summary:


Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres.


Change Request Details:


Currently within CTMS reports there is a report called CN Load Manifest (attached to RIO). A need has been identified to create a new report which would be the same in all details to the CN Load Manifest except the Deliver To field would be the final location of the order not the Cross Dock location, the destination field (top centre) of the report would be the Cross Dock location (E.g. SWCONSOL). Please note this is a request to create an additional report very similar to the existing report not modify the existing report.


Benefits identified as a result of the change:


Indentified as a requirement of the Consumer Consolidation Centre process.


Solution

A new report called ‘CN Load Manifest for Consol Centres’ will be created based on the existing report called ‘CN Load Manifest’.


The new report will have the following adaptations for cross-dock trips:


  1. The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.
  2. The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
  3. The ‘DESTINATION’ title will be renamed ‘Consol Centre’.

The selection criteria will be the same as report ‘CN Load Manifest’.


There will be no restriction on the type of trip for which the new report may be run.


Scope

This change will be applied to system version 10.6.

Set-up

Pre-requisites

The relevant users will need to have access to the new report.


Menu Structure

The new report will be added to the ‘Reports’ menu.


Data

The parameters for the new report will need to be setup (see Appendix A for further details).


Functional Description

Data Setup

The new report will require the same set of parameters as the existing ‘Load Manifest’ report but will need to be setup separately so that the new program is run.


[[Image:]]


The parameters will be the same as displayed in the screenshot above.


LOAD_MANIFEST_CONSOLCENTRE.rep

The new ‘Load Manifest for Consol Centres ’ report will be created with the same layout as the existing ‘Load Manifest’ report and will be based on version 1.0 of program ‘LOAD_MANIFEST.rep’.


The new report will have the following adaptations for cross-dock trips:


  1. The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.
  1. The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
  1. The ‘DESTINATION’ title will be renamed ‘CONSOL CENTRE’.

The changes will be applied to the following layout:


[[Image:]]


  1. The ‘DELIVER TO’ field will be changed from value ‘F_LOCATION_NAME1’ to value ‘F_LOCATION_NAME2’, this will then display the value from item ‘GEO_LOCATION_FINAL.LOCATION_ID’.
  1. The existing ‘DESTINATION’ field will be changed from a blank to display the value ‘F_LOCATION_NAME1’, this will then display the value from item ‘GEO_LOCATION_UNLOAD.LOCATION_ID’.
  1. The existing ‘DESTINATION’ field will be renamed to have the title ‘CONSOL CENTRE’.
  1. The title of the report will be ‘LOAD MANIFEST FOR CONSOL CENTRES’ in the page heading.

The layout of the report will not be changed so that the new values occupy the same positions as the old values.


There will be no restriction on the type of trip for which the new report may be run; therefore the existing queries will not be changed.

    1. table updates REQUIRED

The following script may be run to setup the data for the new report:


[[Image:]]

    1. QUOTE & DoCuMENT History


Activity
Estimate
Quote
No. of Days
No. of Days
Daily Rate (£)
Cost (£) Exc. VAT
Work to Date
0.00
0.00
500
Change Request Evaluation
0.50
0.50
500
Functional Specification
0.50
0.50
500
Technical Specification
0.00
0.00
500
Development
1.00
1.00
417
Testing & Release
0.50
0.50
417
Implementation
0.00
0.00
462
==== TOTAL ====

References


Ref No
Document Title & ID
Version
Date
1
EST-281871 JC-89ZHDD Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres v1.0.doc
1.0
22/10/10

Glossary


Term or Acronym
Meaning

Document History


Version
Date
Status
Reason
Initials
0.1
29/11/10
Draft
Initial version
PDR
1.0
30/11/10
Issued
Reviewed & Issued
MJC
1.1
01/12/10
Revised
See Red for details
JC
2.0
02/12/10
Issued
Approved Jamie’s amendments.
MJC

Authorised By


Matt Crisford Development Manager
Peter Greer TMSCC MTS Product Manager