281871: Difference between revisions

From CTMS
No edit summary
No edit summary
 
(14 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 5: Line 5:




1. Functional Overview
1.1 Client Requirement
Change Request Summary:


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


Change Request Details:
== Client Requirement ==


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.
'''Change Request Summary:'''


Benefits identified as a result of the change:


Indentified as a requirement of the Consumer Consolidation Centre process.
Create a CN Load Manifest for Cross Dock Trips to Consolidation Centres.




1.2 Solution
'''Change Request Details:'''
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.
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.
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.
'''Benefits identified as a result of the change:'''




1.3 Scope
Indentified as a requirement of the Consumer Consolidation Centre process.
This change will be applied to system version 10.6. 
2. Set-up
2.1 Pre-requisites
The relevant users will need to have access to the new report.
 
2.2 Menu Structure
The new report will be added to the ‘Reports’ menu.
 
2.3 Data
The parameters for the new report will need to be setup (see Appendix A for further details).
 
 
 
 
 
 
 
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.
 




The parameters will be the same as displayed in the screenshot above.
== Solution ==
A new report called <span style="color:red">
‘CN Load Manifest for Consol Centres’ </span>
will be created based on the existing report called ‘CN Load Manifest’.


3.2 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:
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.
# The ‘DESTINATION’ value will be the cross-dock location and not the destination of the order.
# The ‘DESTINATION’ title will be renamed ‘Consol Centre’.


3. The ‘DESTINATION’ title will be renamed ‘CONSOL CENTRE’.
The selection criteria will be the same as report <span style="color:red">‘CN Load Manifest’.</span>




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


The changes will be applied to the following layout:


== 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.


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’.
== Data ==
The parameters for the new report will need to be setup (see Appendix A for further details).


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


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.
<center>[[Image:281871_1.png]]</center>


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:


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


Appendix B      QUOTE & DoCuMENT History


Activity
== LOAD_MANIFEST_<span style="color:red">CONSOLCENTRE.rep </span> ==
Estimate
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’.
Quote


No. of Days
No. of Days
Daily Rate (£)
Cost (£) Exc. VAT


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




# 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’ title will be renamed <span style="color:red">‘CONSOL CENTRE’</span>.


The changes will be applied to the following layout:


Work to Date
0.00
0.00
500


Change Request Evaluation
<center>[[Image:281871_2.png]]</center>
0.50
0.50
500


Functional Specification
0.50
0.50
500


Technical Specification
# 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’.
0.00
# 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’.
0.00
# The existing ‘DESTINATION’ field will be renamed to have the title <span style="color:red">‘CONSOL CENTRE’</span>.
500
# The title of the report will be <span style="color:red">‘LOAD MANIFEST FOR CONSOL CENTRES’</span> in the page heading.


Development
The layout of the report will not be changed so that the new values occupy the same positions as the old values.
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




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




{| 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>


Document History
|-
Version
| 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>
Date
| 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
Status
| 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>
Reason
| 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>
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-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;"|


|}


'''Document History'''




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


Matt Crisford
|-
| 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>


Development Manager
|-
| 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>


Peter Greer
|-
| 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;"|


TMSCC MTS Product Manager
|}
= Authorised By =
{| Border="1"
| '''''Matt Crisford'''''
| Development Manager
|
|-
| '''''Peter Greer'''''
| TMSCC MTS Product Manager  
|
|}

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