255681
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
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.
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.
References
| EST-255681 NW-7K5U4Q Capture Media Returns into Trip Debrief form v1a.doc |
Glossary
Not Available
Document History
| Initial version | ||||
| Reviewed and Issued |
Authorised By
| Matt Crisford | Development Manager | |
| Suk Sandhu | TMSCC MTS Product Manager |
