Middletong at 14:04, 21 September 2009

2009-09-21T14:04:56Z

← Older revision		Revision as of 16:04, 21 September 2009
Line 10:		Line 10:

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


			= Functional Overview =

	== Client Requirement ==		== Client Requirement ==
Line 59:		Line 62:
	The options will be added to the main query Q_ORD_INFO.		The options will be added to the main query Q_ORD_INFO.

	==References==		=References=

	{\| ~~class~~="~~prettytable~~"		{\| Border="1"
	\| <center>'''Ref No'''</center>		\| <center>'''Ref No'''</center>
	\| <center>'''Document Title & ID'''</center>		\| <center>'''Document Title & ID'''</center>
Line 76:		Line 79:
	\|}		\|}

	==Document History==		=Document History=


	{\| ~~class~~="~~prettytable~~"		{\| Border="1"
	\| <center>'''Version'''</center>		\| <center>'''Version'''</center>
	\| <center>'''Date'''</center>		\| <center>'''Date'''</center>
Line 103:		Line 106:
	\|}		\|}

	==Authorised By==		=Authorised By=



	{\| ~~class~~="~~prettytable~~"		{\| Border="1"
	\| '''''Matt Crisford'''''		\| '''''Matt Crisford'''''
	\| Development Manager		\| Development Manager

Crisfordm: New page: ==264760 PA-7RHJWK CN Load plan report by Area and status== {| class="prettytable" |
'''Version :'''
| '''1.0''' |} '''Copyright OBS Logistics ...

2009-07-02T14:05:44Z

New page: ==264760 PA-7RHJWK CN Load plan report by Area and status== {| class="prettytable" | <div align="right">'''Version :'''</div> | <center>'''1.0'''</center> |} '''Copyright OBS Logistics ...

New page

==264760 PA-7RHJWK CN Load plan report by Area and status==

{| class="prettytable"
| <div align="right">'''Version :'''</div>
| <center>'''1.0'''</center>

|}

'''Copyright OBS Logistics © 2009'''

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

== Client Requirement ==
Selection Parameters: Order Status - add UNSCHEDULED and ALL to criteria. Booked Status: add ALL to selection.Rename Report to: CN ORDER STATUS REPORT

Added by ss - The report to be changed is CN Load Planning The reports mentioned below are not to be deleted. These can be removed from user view via access control if need be

== Solution ==
Create a copy of the existing report and rename the report ‘CN Order Status Report’.

Create the relevant report records in the following tables

REP_REPORT

REP_REPORT_PARAM

In REP_REPORT create a record for the new report so that is available for selection in the Reports form.

Records added to the REP_REPORT_PARAM table will control which parameters are associated with the new report and the data which will be available to select in the parameters. We must create a record for each parameter which is available in the old report and amend the SQL string field for the Status fields so that the new values are available for selection.

In the new report, amend the data model to select based on the parameter values or the parameter value equals ALL.

Eg (ORDER_STATUS <nowiki>= :P_ORDER_STATUS OR :P_ORDER_STATUS = ‘ALL’)</nowiki>

Ensure the report format is not changed when the user selects ALL for either of the parameters.

= Set-up =

== Data ==
New records in table REP_REPORT and REP_REPORT_PARAM will be added for report ‘CN Order Status Report’

= Functional Description =
The CN Load Planning report will be copied and renamed CN Order Status Report.

New entries will be added to REP_REPORT and REP_REPORT_PARAMS will be added for the new report.

The REP_REPORT_PARAMS records will be copied from the existing params for the CN Load Planning report, but with a change to the SQL string. The string for Order Status will be changed to include UNSCHEDULED and ALL, the Booking status will include ALL.

Report to be renamed CN Order Status

[[Image:264760_1.png]]

Order status will include UNSCHEDULED and ALL. Booking status will include ALL

The layout of the report will remain unchanged. However the data model will be altered to accommodate the new parameter options.

The options will be added to the main query Q_ORD_INFO.

==References==

{| class="prettytable"
| <center>'''Ref No'''</center>
| <center>'''Document Title & ID'''</center>
| <center>'''Version'''</center>
| <center>'''Date'''</center>

|-
|
| 264760 PA-7RHJWK CN Load Plan Report by Area and Stat v1.0.doc
| <center>1.0</center>
| <center>11/05/09</center>

|}

==Document History==

{| class="prettytable"
| <center>'''Version'''</center>
| <center>'''Date'''</center>
| <center>'''Status'''</center>
| <center>'''Reason'''</center>
| <center>'''Initials'''</center>

|-
| <center>0.1</center>
| <center>01/06/09</center>
| <center>Draft</center>
| Initial version
| <center>DNG</center>

|-
| <center>1.0</center>
| <center>01/06/09</center>
| <center>Issue</center>
| Reviewed and Issued
| <center>LAD /MJC</center>

|}

==Authorised By==

{| class="prettytable"
| '''''Matt Crisford'''''
| Development Manager
|

|-
| '''''Suk Sandhu'''''
| TMSCC MTS Product Manager
|

|}

264760 - Revision history

Middletong at 14:04, 21 September 2009

Crisfordm: New page: ==264760 PA-7RHJWK CN Load plan report by Area and status== {| class="prettytable" | '''Version :''' | '''1.0''' |} '''Copyright OBS Logistics ...

Crisfordm: New page: ==264760 PA-7RHJWK CN Load plan report by Area and status== {| class="prettytable" |
'''Version :'''
| '''1.0''' |} '''Copyright OBS Logistics ...