292987 - Revision history

Admin: /* AUTHORISED BY */

2012-04-26T15:38:32Z

AUTHORISED BY

← Older revision		Revision as of 17:38, 26 April 2012
Line 935:		Line 935:

	\|}		\|}



	=AUTHORISED BY=		=AUTHORISED BY=

Admin: /* Provider Revenue (Carrier Level) */

2012-04-26T15:37:08Z

Provider Revenue (Carrier Level)

← Older revision		Revision as of 17:37, 26 April 2012
Line 751:		Line 751:
	'''Table Updates Required'''		'''Table Updates Required'''

	~~[[Image:]]~~		DATA_REP_REPORT_292987.SQL

	insert into rep_report (name, report_type, filename, printer_type, show_pform, orientation, proc_name)		insert into rep_report (name, report_type, filename, printer_type, show_pform, orientation, proc_name)
Line 763:		Line 763:


	~~[[Image:]]~~		DATA_REP_REPORT_PARAM_292987.SQL

	INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)		INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)

Admin: /* Provider Revenue (Carrier Level) */

2012-04-26T15:32:40Z

Provider Revenue (Carrier Level)

← Older revision		Revision as of 17:32, 26 April 2012
Line 752:		Line 752:

	[[Image:]]		[[Image:]]

			insert into rep_report (name, report_type, filename, printer_type, show_pform, orientation, proc_name)
			values ('ACTIVITY_EXTRACT','CSV','ACTIVITY_EXTRACT','Laser','F','LANDSCAPE', 'dp_csv5.activity_extract');

			insert into rep_report (name, report_type, filename, printer_type, show_pform, orientation, proc_name)
			values ('DELIVERY_OVERVIEW','CSV','DELIVERY_OVERVIEW','Laser','F','LANDSCAPE', 'dp_csv5.delivery_overview');

			insert into rep_report (name, report_type, filename, printer_type, show_pform, orientation, proc_name)
			values ('PROVIDER_REVENUE','CSV','PROVIDER_REVENUE','Laser','F','LANDSCAPE', 'dp_csv5.provider_revenue');


	[[Image:]]		[[Image:]]

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)
			values ('ACTIVITY_EXTRACT','CSV','P_START_SCHED','P_START_SCHED','M','From Schedule','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)
			values ('ACTIVITY_EXTRACT','CSV','P_END_SCHED','P_END_SCHED','M','To Schedule','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, sql_string, report_list)
			values ('ACTIVITY_EXTRACT','CSV','PG_SELECT_LIST1','P_OWNING_DEPOT','M','Owning Depot',
			'SELECT distinct(gl.location_id) COL1, gl.location_name COL2 FROM geo_location gl, adm_user_param aup WHERE gl.location_id = aup.value AND aup.username = (SELECT user FROM dual) AND aup.param_type = ''BASED_AT'' AND gl.depot = ''RDC'' and NVL(gl.inactive,''N'') = 'N' UNION SELECT distinct (gl.location_id) COL1, gl.location_name COL2 FROM geo_location gl, adm_user_param aup WHERE gl.location_name like DECODE(aup.value,''Y'',''%%'') AND aup.username = (SELECT user FROM dual) and aup.param_type = ''ALL_DEPOTS'' and gl.depot = ''RDC'' and NVL(gl.inactive,''N'') = ''N''','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)
			values ('DELIVERY_OVERVIEW','CSV','P_START_SCHED','P_START_SCHED','M','From Schedule','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)
			values ('DELIVERY_OVERVIEW','CSV','P_END_SCHED','P_END_SCHED','M','To Schedule','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, sql_string, report_list)
			values ('DELIVERY_OVERVIEW','CSV','PG_SELECT_LIST1','P_OWNING_DEPOT','M','Owning Depot',
			'SELECT distinct(gl.location_id) COL1, gl.location_name COL2 FROM geo_location gl, adm_user_param aup WHERE gl.location_id = aup.value AND aup.username = (SELECT user FROM dual) AND aup.param_type = ''BASED_AT'' AND gl.depot = ''RDC'' and NVL(gl.inactive,''N'') = 'N' UNION SELECT distinct (gl.location_id) COL1, gl.location_name COL2 FROM geo_location gl, adm_user_param aup WHERE gl.location_name like DECODE(aup.value,''Y'',''%%'') AND aup.username = (SELECT user FROM dual) and aup.param_type = ''ALL_DEPOTS'' and gl.depot = ''RDC'' and NVL(gl.inactive,''N'') = ''N''','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, default_value_type,default_value report_list)
			values ('DELIVERY_OVERVIEW','CSV','PG_FFCHAR1','PFPOD','M','POD Confirmed','STRING','Y','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)
			values ('PROVIDER_REVENUE','CSV','P_START_SCHED','P_START_SCHED','M','From Schedule','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, report_list)
			values ('PROVIDER_REVENUE','CSV','P_END_SCHED','P_END_SCHED','M','To Schedule','N');

			INSERT INTO rep_report_param(report_name, report_type, param_type, param_name, conditional, param_title, sql_string, report_list)
			values ('PROVIDER_REVENUE','CSV','PG_SELECT_LIST1','P_OWNING_DEPOT','M','Owning Depot',
			'SELECT distinct(gl.location_id) COL1, gl.location_name COL2 FROM geo_location gl, adm_user_param aup WHERE gl.location_id = aup.value AND aup.username = (SELECT user FROM dual) AND aup.param_type = ''BASED_AT'' AND gl.depot = ''RDC'' and NVL(gl.inactive,''N'') = 'N' UNION SELECT distinct (gl.location_id) COL1, gl.location_name COL2 FROM geo_location gl, adm_user_param aup WHERE gl.location_name like DECODE(aup.value,''Y'',''%%'') AND aup.username = (SELECT user FROM dual) and aup.param_type = ''ALL_DEPOTS'' and gl.depot = ''RDC'' and NVL(gl.inactive,''N'') = ''N''','N');

Admin: /* Provider Revenue (Carrier Level) */

2012-04-26T13:15:53Z

Provider Revenue (Carrier Level)

← Older revision		Revision as of 15:15, 26 April 2012
Line 686:		Line 686:


	~~<center>~~[[Image:]]~~</center>~~		[[Image:292987_4.png]]

Admin: /* Delivery Overview (Order Level) */

2012-04-26T13:15:11Z

Delivery Overview (Order Level)

← Older revision		Revision as of 15:15, 26 April 2012
Line 529:		Line 529:


	~~<center>~~[[Image:]]~~</center>~~		[[Image:292987_3.png]]

Admin: /* C-TMS Activity Extract (Trip Level) */

2012-04-26T13:14:24Z

C-TMS Activity Extract (Trip Level)

← Older revision		Revision as of 15:14, 26 April 2012
Line 393:		Line 393:


	~~<center>~~[[Image:]]~~</center>~~		[[Image:292987_2.png]]

Admin: /* Implementation Advice */

2012-04-26T13:13:24Z

Implementation Advice

← Older revision		Revision as of 15:13, 26 April 2012
Line 386:		Line 386:
	A system super user will be required to grant access to the required extracts		A system super user will be required to grant access to the required extracts

	[[Image:]]		[[Image:292987_1.png]]

	= Functional Description =		= Functional Description =

Admin: /* Solution */

2012-04-26T13:06:12Z

Solution

← Older revision		Revision as of 15:06, 26 April 2012
Line 303:		Line 303:
	* Depot will restrict the trips selected by Owning Depot . If the user only has one owning depot the list will default to this else the owning depot can be selected from the list. If no depot is selected all relevant depots will be used		* Depot will restrict the trips selected by Owning Depot . If the user only has one owning depot the list will default to this else the owning depot can be selected from the list. If no depot is selected all relevant depots will be used
	* POD confirmed will restrict orders selected by proof of delivery the value can be Yes/No/Both		* POD confirmed will restrict orders selected by proof of delivery the value can be Yes/No/Both



	'''Provider Revenue (Carrier Level)'''		'''Provider Revenue (Carrier Level)'''


	The Following fields are required in the extract		The Following fields are required in the extract



	{\| style="border-spacing:0;"		{\| style="border-spacing:0;"

Admin: /* Solution */

2012-04-26T13:05:03Z

Solution

← Older revision		Revision as of 15:05, 26 April 2012
Line 22:		Line 22:

	The following fields are required in the extract		The following fields are required in the extract


	{\| style="border-spacing:0;"		{\| style="border-spacing:0;"
Line 150:		Line 149:
	* To Schedule (the schedules will be used to select trips with a schedule name between these 2 values)		* To Schedule (the schedules will be used to select trips with a schedule name between these 2 values)
	* Depot will restrict orders selected by Owning Depot. If the user only has one owning depot the list will default to this else the owning depot can be selected from the list. If no depot is selected all relevant depots will be used		* Depot will restrict orders selected by Owning Depot. If the user only has one owning depot the list will default to this else the owning depot can be selected from the list. If no depot is selected all relevant depots will be used

Admin: /* Solution */

2012-04-26T13:04:15Z

Solution

← Older revision		Revision as of 15:04, 26 April 2012
Line 20:		Line 20:

	'''C-TMS Activity Extract(Trip Level)'''		'''C-TMS Activity Extract(Trip Level)'''


	The following fields are required in the extract		The following fields are required in the extract



Line 152:		Line 150:
	* To Schedule (the schedules will be used to select trips with a schedule name between these 2 values)		* To Schedule (the schedules will be used to select trips with a schedule name between these 2 values)
	* Depot will restrict orders selected by Owning Depot. If the user only has one owning depot the list will default to this else the owning depot can be selected from the list. If no depot is selected all relevant depots will be used		* Depot will restrict orders selected by Owning Depot. If the user only has one owning depot the list will default to this else the owning depot can be selected from the list. If no depot is selected all relevant depots will be used



Line 158:		Line 155:

	The Following fields are required in the extract		The Following fields are required in the extract



	{\| style="border-spacing:0;"		{\| style="border-spacing:0;"