252347 - Revision history

Middletong at 12:35, 27 January 2010

2010-01-27T12:35:58Z

← Older revision		Revision as of 14:35, 27 January 2010
Line 1:		Line 1:
	= 252347 PA-7DGPFT Add Trip Revenue to Trip Finance= ~~'''Needs updating'''~~		= 252347 PA-7DGPFT Add Trip Revenue to Trip Finance=

	Copyright OBS Logistics © 2009		Copyright OBS Logistics © 2009
Line 20:		Line 20:
	More financial awareness when a Trip is being planned.		More financial awareness when a Trip is being planned.

	== Solution ==		==Solution==

	Amend screens Trip Manipulation (TRIPSUM) and Trip Planning (TRIP_PLAN) to include the following changes:		Amend screens Trip Manipulation (TRIPSUM) and Trip Planning (TRIP_PLAN) to include the following changes:
Line 34:		Line 34:


	== Scope ==		==Scope==

	This change will be applied to system version 10.6 on CONTST and once approved CONPRD. This form will be applicable to all MTS environments, as the nature of this change does not impact on the current functionality of the form. This field will only be viewed, and can not be edited.		This change will be applied to system version 10.6 on CONTST and once approved CONPRD. This form will be applicable to all MTS environments, as the nature of this change does not impact on the current functionality of the form. This field will only be viewed, and can not be edited.
Line 40:		Line 40:


	= FUNCTIONAL DESCRIPTION =		=FUNCTIONAL DESCRIPTION=


	== New Functionality ==		==New Functionality==

	The sample screenshot below displays the TRIPSUM screen with the new functionality included - to sum all order payments on the one trip, then display in the greyed out field - for financial awareness. Trip MAN-00665530 on Sched 080428 is the provided example (from COLV):		The sample screenshot below displays the TRIPSUM screen with the new functionality included - to sum all order payments on the one trip, then display in the greyed out field - for financial awareness. Trip MAN-00665530 on Sched 080428 is the provided example (from COLV):

	~~IMAGE~~		[[Image:252347_1.PNG]]

	Also notice, the change to the text labels, ‘Trip Cost’ and ‘Trip Revenue’.		Also notice, the change to the text labels, ‘Trip Cost’ and ‘Trip Revenue’.
Line 55:		Line 55:
	From the screen shots below, note 3 orders that are on this Trip. Summing all Order Revenues will calculate an overall total 300.94, same figure as displayed above.		From the screen shots below, note 3 orders that are on this Trip. Summing all Order Revenues will calculate an overall total 300.94, same figure as displayed above.

	~~IMAGE~~		[[Image:252347_2.PNG]]

	~~IMAGE~~		[[Image:252347_3.PNG]]

	~~IMAGE~~		[[Image:252347_4.PNG]]


	== New Function ==		==New Function==

	The following Function ‘F_GET_TRIP_REVENUE’ will be used in forms TRIP_PLAN and TRIPSUM. It will be passed in a Trip ID (e.g. MAN-00012345) where it will sum field ORD_REVENUE from all Orders on the current trip.		The following Function ‘F_GET_TRIP_REVENUE’ will be used in forms TRIP_PLAN and TRIPSUM. It will be passed in a Trip ID (e.g. MAN-00012345) where it will sum field ORD_REVENUE from all Orders on the current trip.

	== Trigger Updates ==		==Trigger Updates==

	General structure the code will take for displaying Trip Revenue functionality in:		General structure the code will take for displaying Trip Revenue functionality in:
	• POST-QUERY trigger on the TRIP_DTL tabs in TRIP_PLAN and TRIPSUM		*POST-QUERY trigger on the TRIP_DTL tabs in TRIP_PLAN and TRIPSUM


Line 75:		Line 75:


	== Trigger Amendments ==		==Trigger Amendments==

	Currently, there is a WHEN-BUTTON-PRESSED trigger on button ‘Apply’ next to MTM Cost in the Finance tab. It includes the code below, which returns values into TRIP_REVENUE, TRIP_COST and ALLOCATABLE_COST:		Currently, there is a WHEN-BUTTON-PRESSED trigger on button ‘Apply’ next to MTM Cost in the Finance tab. It includes the code below, which returns values into TRIP_REVENUE, TRIP_COST and ALLOCATABLE_COST:
Line 93:		Line 93:


	~~QUOTE~~ & ~~DOCUMENT HISTORY =~~		=References=
			{\| Border="1"
			\| <center>'''Ref No'''</center>
			\| <center>'''Document Title & ID'''</center>
			\| <center>'''Version'''</center>
			\| <center>'''Date'''</center>

	~~IMAGE~~		\|-
			\| <center>1</center>
			\| Revenue RIO.doc
			\| <center>N/A</center>
			\| <center>N/A</center>

			\|-
			\| <center>2</center>
			\| EST-252347 PA-7DGPFT Add Trip Revenue to Trip Finance v1.doc
			\| <center>1</center>
			\| <center>07/08/08</center>

			\|}

	~~== References ==~~		=Document History=
	~~IMAGE~~


	~~== Glossary ==~~


	~~IMAGE~~



	== Document History ==

	~~IMAGE~~		{\| Border="1"
			\| <center>'''Version'''</center>
			\| <center>'''Date'''</center>
			\| <center>'''Status'''</center>
			\| <center>'''Reason'''</center>
			\| <center>'''Initials'''</center>

			\|-
			\| <center>1a</center>
			\| <center>13/08/08</center>
			\| <center>Draft</center>
			\| Initial version
			\| <center>LAD</center>

			\|-
			\| <center>1</center>
			\| <center>13/08/08</center>
			\| <center>Issue</center>
			\| Reviewed and Issued via Email
			\| <center>JAT</center>
			\|}

	~~== Authorised By ==~~


			=Authorised By=

	{\| border="1"		{\| border="1"

Middletong at 15:51, 16 December 2009

2009-12-16T15:51:09Z

← Older revision		Revision as of 17:51, 16 December 2009
Line 1:		Line 1:
	= 252347 PA-7DGPFT Add Trip Revenue to Trip Finance=		= 252347 PA-7DGPFT Add Trip Revenue to Trip Finance= '''Needs updating'''

	Copyright OBS Logistics © 2009		Copyright OBS Logistics © 2009

Middletong: /* Client Requirement */

2009-12-16T15:50:34Z

Client Requirement

← Older revision		Revision as of 17:50, 16 December 2009
Line 13:		Line 13:

	#Currently Operational- Trip Cost (Payments) - Populated by Carrier related Contract or Manual input of agreed Subcontractor Rates - Sum of PAYMENTS v2.23 Trip Based		#Currently Operational- Trip Cost (Payments) - Populated by Carrier related Contract or Manual input of agreed Subcontractor Rates - Sum of PAYMENTS v2.23 Trip Based

	#Revenue - Currently un-used (Greyed-out)- Develop to show sum of all Revenues from all the Orders on the Trip.		#Revenue - Currently un-used (Greyed-out)- Develop to show sum of all Revenues from all the Orders on the Trip.
	See Attachment		See Attachment

Middletong: /* Client Requirement */

2009-12-16T15:50:19Z

Client Requirement

← Older revision		Revision as of 17:50, 16 December 2009
Line 12:		Line 12:
	Currently 2 Fields visible on Finance Tab of a Trip:		Currently 2 Fields visible on Finance Tab of a Trip:

	1: Currently Operational- Trip Cost (Payments) - Populated by Carrier related Contract or Manual input of agreed Subcontractor Rates - Sum of PAYMENTS v2.23 Trip Based		#Currently Operational- Trip Cost (Payments) - Populated by Carrier related Contract or Manual input of agreed Subcontractor Rates - Sum of PAYMENTS v2.23 Trip Based

	2: Revenue - Currently un-used (Greyed-out)- Develop to show sum of all Revenues from all the Orders on the Trip.		#Revenue - Currently un-used (Greyed-out)- Develop to show sum of all Revenues from all the Orders on the Trip.
	See Attachment		See Attachment
	Change Label to REVENUE		Change Label to REVENUE
Line 20:		Line 20:

	More financial awareness when a Trip is being planned.		More financial awareness when a Trip is being planned.





	== Solution ==		== Solution ==

Middletong at 15:49, 16 December 2009

2009-12-16T15:49:40Z

← Older revision		Revision as of 17:49, 16 December 2009
Line 1:		Line 1:
	= ~~'''~~252347 PA-7DGPFT Add Trip Revenue to Trip Finance~~'''~~ =		= 252347 PA-7DGPFT Add Trip Revenue to Trip Finance=

	~~'''~~Copyright OBS Logistics © ~~2008'''~~		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		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 =		=FUNCTIONAL OVERVIEW=

			==Client Requirement==

	== Client Requirement ==
	The Finance Tab in Trip Manipulation and Trip planning to show Trip revenue and trip cost (subbed)		The Finance Tab in Trip Manipulation and Trip planning to show Trip revenue and trip cost (subbed)

Middletong: /* New Function */

2009-12-16T15:48:17Z

New Function

← Older revision		Revision as of 17:48, 16 December 2009
Line 72:		Line 72:

	The following Function ‘F_GET_TRIP_REVENUE’ will be used in forms TRIP_PLAN and TRIPSUM. It will be passed in a Trip ID (e.g. MAN-00012345) where it will sum field ORD_REVENUE from all Orders on the current trip.		The following Function ‘F_GET_TRIP_REVENUE’ will be used in forms TRIP_PLAN and TRIPSUM. It will be passed in a Trip ID (e.g. MAN-00012345) where it will sum field ORD_REVENUE from all Orders on the current trip.



	~~FUNCTION F_GET_TRIP_REVENUE(i_trip_id IN VARCHAR2) RETURN NUMBER IS~~

	~~v_trip_revenue SCH_ORD.ORD_REVENUE%TYPE;~~

	~~CURSOR c_trip_revenue( cp_trip_id VARCHAR2 ) IS~~
	~~SELECT SUM(SO.ORDER_REVENUE)~~
	~~FROM SCH_ORD SO, SCH_HAULAGE_ACTIVITY SHA, SCH_TRIP_STOP STS~~
	~~WHERE SO.OMS_REF = SHA.OMS_REF~~
	~~AND SHA.STOP_ID = STS.STOP_ID~~
	~~AND SHA.ACTIVITY_NAME = ‘Load’~~
	~~AND STS.TRIP_ID = cp_trip_id;~~


	~~BEGIN~~

	~~OPEN c_trip_revenue ( i_trip_id );~~
	~~FETCH c_trip_revenue INTO v_trip_revenue;~~
	~~CLOSE c_trip_revenue;~~

	~~RETURN (v_trip_revenue);~~

	~~EXCEPTION~~
	~~WHEN OTHERS THEN~~
	~~RETURN (NULL);~~

	~~END;~~

	== Trigger Updates ==		== Trigger Updates ==

Middletong: /* New Function */

2009-12-16T15:47:45Z

New Function

← Older revision		Revision as of 17:47, 16 December 2009
Line 90:		Line 90:
	BEGIN		BEGIN

	OPEN c_trip_revenue ( i_trip_id );		OPEN c_trip_revenue ( i_trip_id );
	FETCH c_trip_revenue INTO v_trip_revenue;		FETCH c_trip_revenue INTO v_trip_revenue;
	CLOSE c_trip_revenue;		CLOSE c_trip_revenue;

Line 101:		Line 101:

	END;		END;


	== Trigger Updates ==		== Trigger Updates ==

Kingj at 14:43, 4 February 2009

2009-02-04T14:43:39Z

@@ Line 44: / Line 44: @@
 This change will be applied to system version 10.6 on CONTST and once approved CONPRD. This form will be applicable to all MTS environments, as the nature of this change does not impact on the current functionality of the form. This field will only be viewed, and can not be edited.
@@ Line 148: / Line 130: @@
+ QUOTE & DOCUMENT HISTORY =
 IMAGE

Kingj: /* Authorised By */

2009-02-04T12:28:32Z

Authorised By

← Older revision		Revision as of 14:28, 4 February 2009
Line 180:		Line 180:
	== Authorised By ==		== Authorised By ==

	~~=== Authorised By ===~~

	{\| border="1"		{\| border="1"

Kingj: /* Authorised By */

2009-02-04T12:27:07Z

Authorised By

← Older revision		Revision as of 14:27, 4 February 2009
Line 179:		Line 179:

	== Authorised By ==		== Authorised By ==
	~~IMAGE~~
			=== Authorised By ===

			{\| border="1"
			\| '''''Dave Meir'''''
			\| Development Manager
			\|-
			\| '''Suk Sandhu'''
			\| TMSCC MTS Product Manager
			\|}