255681 - Revision history

Middletong at 11:48, 21 September 2009

2009-09-21T11:48:48Z

← Older revision		Revision as of 13:48, 21 September 2009
Line 164:		Line 164:


	== Document History ==		= Document History =

	{\| Border="1"		{\| Border="1"
Line 189:		Line 189:


	== Authorised By ==		= Authorised By =

Middletong at 11:48, 21 September 2009

2009-09-21T11:48:15Z

← Older revision		Revision as of 13:48, 21 September 2009
Line 143:		Line 143:

	The user can choose to save a specific configuration by giving the layout a name. This will store a record in the table ADM_MSEL_FORM and ADM_MSEL_FORM_PARAM, so that the layout is available for use in the future. If no name is specified, the layout is assumed to be temporary and is not saved to the database.		The user can choose to save a specific configuration by giving the layout a name. This will store a record in the table ADM_MSEL_FORM and ADM_MSEL_FORM_PARAM, so that the layout is available for use in the future. If no name is specified, the layout is assumed to be temporary and is not saved to the database.


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

			\|-
			\| <center>1</center>
			\| EST-255681 NW-7K5U4Q Capture Media Returns into Trip Debrief form v1a.doc
			\| <center>1a</center>
			\| <center>14/11/08</center>
			\|}


			= Glossary =
			Not Available


			== Document History ==

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

			\|-
			\| <center>1a</center>
			\| <center>25/11/08</center>
			\| <center>Draft</center>
			\| Initial version
			\| <center>SW</center>

			\|-
			\| <center>1</center>
			\| <center>25/11/08</center>
			\| <center>Issue</center>
			\| Reviewed and Issued
			\| <center>MJC</center>
			\|}


			== Authorised By ==



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

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

			\|}

Middletong: /* Functional Description */

2009-09-21T11:15:32Z

Functional Description

← Older revision		Revision as of 13:15, 21 September 2009
Line 136:		Line 136:


	*The System Parameter TRM_DISP_OMS_OR_CUST_REF_OR_BOOK_OR_CONT_NO will indicate if one of the default fields is Customer Ref or OMS ref or Booking ref or container no.		<*The System Parameter TRM_DISP_OMS_OR_CUST_REF_OR_BOOK_OR_CONT_NO will indicate if one of the default fields is Customer Ref or OMS ref or Booking ref or container no.

	Media Returns DU Type and Media Returns Quantity will be available to select in the layout.		Media Returns DU Type and Media Returns Quantity will be available to select in the layout.

Middletong: /* Functional Description */

2009-09-21T11:15:09Z

Functional Description

← Older revision		Revision as of 13:15, 21 September 2009
Line 102:		Line 102:

	Load Stop		Load Stop

	Load Location		Load Location

	Unload Stop		Unload Stop

	Unload Location		Unload Location

	Customer Ref*		Customer Ref*

	Line No		Line No

	Product Type		Product Type

	DU Type		DU Type
	Planned Quantity
			Planned Quantity

	Actual Despatched		Actual Despatched

	Actual Delivered		Actual Delivered

	Plan Weight		Plan Weight

	Actual Weight		Actual Weight

	Plan Volume		Plan Volume

	Actual Volume		Actual Volume

	Plan Cases		Plan Cases

	Actual Cases		Actual Cases

Middletong at 11:13, 21 September 2009

2009-09-21T11:13:58Z

← Older revision		Revision as of 13:13, 21 September 2009
Line 89:		Line 89:
	This block will be populated using a new procedure F_ADD_ORDER_DEBRIEF_ITEMS		This block will be populated using a new procedure F_ADD_ORDER_DEBRIEF_ITEMS
	In this procedure a record will be added for each field which will be available in the Configure Layout process.		In this procedure a record will be added for each field which will be available in the Configure Layout process.


			= Functional Description =

			When the user selects the Order Debrief tab on the Trip Debrief screen, two blocks of data are displayed. The data blocks show the order line information and the trip stop information. This change is relevant to the order line block only.

			When the cursor is positioned over one of the records in the Order line block, the user will be able to right click to display a popup menu. This menu will have one option only – Configure Layout.

			By selecting this menu option a popup form will be displayed which will list all the fields available in the block. The screen will be in the format of Column name, curr width, max width and new width. At the footer of the screen, the total selected width will be displayed with the maximum allowed width.

			Fields that have been selected to be displayed in the layout will be highlighted yellow. If no other layout has been selected the following fields will be highlighted as the default layout:

			Load Stop
			Load Location
			Unload Stop
			Unload Location
			Customer Ref*
			Line No
			Product Type
			DU Type
			Planned Quantity
			Actual Despatched
			Actual Delivered
			Plan Weight
			Actual Weight
			Plan Volume
			Actual Volume
			Plan Cases
			Actual Cases


			*The System Parameter TRM_DISP_OMS_OR_CUST_REF_OR_BOOK_OR_CONT_NO will indicate if one of the default fields is Customer Ref or OMS ref or Booking ref or container no.

			Media Returns DU Type and Media Returns Quantity will be available to select in the layout.

			The user will be able to select which fields they wish to display. The length of the display will not be able to exceed the maximum allowed width. However, the display length may be configured to be less than the maximum width.

			The user can choose to save a specific configuration by giving the layout a name. This will store a record in the table ADM_MSEL_FORM and ADM_MSEL_FORM_PARAM, so that the layout is available for use in the future. If no name is specified, the layout is assumed to be temporary and is not saved to the database.

Middletong: /* Data */

2009-09-21T11:13:02Z

Data

← Older revision		Revision as of 13:13, 21 September 2009
Line 72:		Line 72:

	Item_name		Item_name

	Curr_width		Curr_width

	Min_width		Min_width

	Width		Width

	Sum_item		Sum_item

	CHB		CHB

	Row Total		Row Total

	Update Allowed		Update Allowed

	This block will be populated using a new procedure F_ADD_ORDER_DEBRIEF_ITEMS		This block will be populated using a new procedure F_ADD_ORDER_DEBRIEF_ITEMS
	In this procedure a record will be added for each field which will be available in the Configure Layout process.		In this procedure a record will be added for each field which will be available in the Configure Layout process.

Middletong: /* Data */

2009-09-21T11:12:30Z

Data

← Older revision		Revision as of 13:12, 21 September 2009
Line 63:		Line 63:

	MEDIA_RETURNS_DU_TYPE		MEDIA_RETURNS_DU_TYPE

	MEDIA_RETURNS_QUANTITY		MEDIA_RETURNS_QUANTITY

Middletong: /* 255681 - NW-7K5U5Q/ Capture Media Returns into Trip Debrief formr */

2009-09-21T11:11:59Z

255681 - NW-7K5U5Q/ Capture Media Returns into Trip Debrief formr

← Older revision		Revision as of 13:11, 21 September 2009
Line 4:		Line 4:

	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 ==
			On the Order Debrief tab of the TRIPDTL form add another two columns at line level to capture the DU Type and Quantity of any media returns i.e. empty pallets, cages etc.

			As part of this it may be worth considering making the block on this tab configurable as there is a lot of data and it is unlikely that an operation will want to capture DU, Weight and Volume actuals. This should be included as part of the estimate based on the same code used in the Trip Manipulation and Trip Planning forms.

			Product improvement and also required as part of the Healthcare UK TMS deployment.


			== Solution ==

			The TRIPDTL screen will be updated to include the ‘Configure Layout’ option, as currently available for the Unscheduled Order Well in the TRIP_PLAN and TRIPSUM screens. It will be accessible via a pop-up menu, using the right-click option when the user has the cursor positioned over the Order Lines, within the ‘Order Debrief’ tab. There is currently no right-click pop-up menu available, so this will have to be created.

			The configurable fields are as follows, those marked with a * will be the default fields displayed if no other layout has been saved:
			Load Stop*
			Load Location*
			Unload Stop*
			Unload Location*
			Customer Ref *
			OMS Ref
			Container No
			Booking Ref
			Line No*
			Product Type*
			DU Type*
			Planned Quantity*
			Actual Despatched*
			Actual Delivered*
			Plan Weight*
			Actual Weight*
			Plan Volume*
			Actual Volume*
			Plan Cases* (Included as part of RIO PA-7JJFZQ)
			Actual Cases* (Included as part of RIO PA-7JJFZQ)
			Media Returns DU Type
			Media Returns Quantity

			The default field displayed between Customer Ref, OMS Ref, Container No and Booking Ref depends on the value held in System Parameter TRM_DISP_OMS_OR_CUST_REF_OR_BOOK_OR_CONT_NO.


			When a user saves a layout for the Order Lines block, it will re-use procedure ADM.Save_Form_Param, that is used when a user saves a layout in the Trip Screens. This procedure will insert the user’s name and the form name of ‘TRIPDTL’ into table ADM_MSEL_FORM. It will also insert a record into table ADM_MSEL_FORM_PARAM, which is used to hold a list of parameters that the user has saved in their layout.

			Some data items that are configurable in the Order Lines block may have the text associated to them altered or amended. This is due to some text fields being programmed in a specific position on the ‘Order Debrief’ tab, therefore when their corresponding data items are configured to not be displayed, the text may still remain. An example of this is the ‘-----Quantity--------‘ text field.

			The Media return fields , Media Returns DU Type and Media Returns Quantity are new fields that will be added to the SCH_ORDER_LINES table.

			To accommodate the configuration function, we will create 2 new blocks ATTRIBUTES and ATTRIBUTES_CTRL. A new package called F_ADD_ORDER_DEBRIEF_ITEMS will be created to define the fields available in the configurable layout. Packages FC_ATTRIBUTES_INIT and FC_ATTRIBUTES will be copied and amended to format the configurations.


			== Scope ==
			This change will be applied to system version 10.5.0 on HCRTST and one HCRPRD.


			== Data ==

			MEDIA_RETURNS_DU_TYPE
			MEDIA_RETURNS_QUANTITY


			Two new non database blocks will be created to store the configured layout information. The blocks will be named ATTRIBUTES and ATTRIBUTES_CTRL.

			ATTRIBUTES will contain the following fields

			Item_name
			Curr_width
			Min_width
			Width
			Sum_item
			CHB
			Row Total
			Update Allowed

			This block will be populated using a new procedure F_ADD_ORDER_DEBRIEF_ITEMS
			In this procedure a record will be added for each field which will be available in the Configure Layout process.

Middletong: New page: =255681 - NW-7K5U5Q/ Capture Media Returns into Trip Debrief formr= Copyright OBS Logistics © 2009 The information contained herein is the property of OBS Logistics and is supplied with...

2009-09-21T11:09:52Z

New page

=255681 - NW-7K5U5Q/ Capture Media Returns into Trip Debrief formr=

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