281871: Difference between revisions

From CTMS
No edit summary
No edit summary
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres|Reference=FS 281871 JC-89ZHDD|Version=2.0|Date=02/12/2010|Sysver=10.5|Client=DHL MTS}}
{{Doc_Title|System=FUNCTIONAL SPECIFICATION | Title =Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres | Reference=FS 281871 JC-89ZHDD|Version=2.0|Date=02/12/2010|Sysver=10.5|Client=DHL MTS}}
 
 
 




Line 31: Line 28:


== Solution ==
== Solution ==
A new report called < style="color:red">
A new report called <span style="color:red">
‘CN Load Manifest for Consol Centres’ </style>
‘CN Load Manifest for Consol Centres’ </span>
will be created based on the existing report called ‘CN Load Manifest’.
will be created based on the existing report called ‘CN Load Manifest’.


Line 43: Line 40:
# The ‘DESTINATION’ title will be renamed ‘Consol Centre’.
# The ‘DESTINATION’ title will be renamed ‘Consol Centre’.


The selection criteria will be the same as report <pre style="color:red">‘CN Load Manifest’.</pre>
The selection criteria will be the same as report <span style="color:red">‘CN Load Manifest’.</span>




Line 55: Line 52:
== Pre-requisites ==
== 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.


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


== Data ==
== Data ==
Line 70: Line 65:




<center>[[Image:]]</center>
<center>[[Image:281871_1.png]]</center>




Line 76: Line 71:




== LOAD_MANIFEST_CONSOLCENTRE.rep ==
== LOAD_MANIFEST_<span style="color:red">CONSOLCENTRE.rep </span> ==
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 <span style="color:red">‘Load Manifest for Consol Centres ’ </span>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’.




Line 84: Line 79:


# The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.
# The ‘DELIVER TO’ value will be the destination of the order and not the cross-dock location.
# The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
# The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
 
# The ‘DESTINATION’ title will be renamed <span style="color:red">‘CONSOL CENTRE’</span>.
# 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>
<center>[[Image:281871_2.png]]</center>




# 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’.
# 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’.
 
# The existing ‘DESTINATION’ field will be renamed to have the title <span style="color:red">‘CONSOL CENTRE’</span>.
# The existing ‘DESTINATION’ field will be renamed to have the title ‘CONSOL CENTRE’.
# The title of the report will be <span style="color:red">‘LOAD MANIFEST FOR CONSOL CENTRES’</span> 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.
Line 108: Line 98:
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.


#
#:
#::
#:::
#::::
#:::::
#::::::
#:::::::
#:::::::# '''table updates REQUIRED'''
The following script may be run to setup the data for the new report:
[[Image:]]
#
#:
#::
#:::
#::::
#:::::
#::::::
#:::::::
#:::::::# '''QUOTE & DoCuMENT History'''
{| 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;"|
|-
| 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;"|
|-
| 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;"|
| 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="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: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.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'''
'''References'''


Line 245: Line 127:


|}
|}
'''Glossary'''
{| 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'''


Line 311: Line 174:


|}
|}
'''Authorised By'''
= Authorised By =
 
{| Border="1"
 
| '''''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;"|
 
|-
|-
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''''Peter Greer'''''
| '''''Peter Greer'''''
| style="border:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| TMSCC MTS Product Manager  
| 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;"|
|  
 
|}
|}

Latest revision as of 10:43, 12 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















































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.


281871 1.png


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.
  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 changes will be applied to the following layout:


281871 2.png


  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’.
  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’.
  3. 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 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.


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

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