247529

247529-MW-796ATJ Full Load or Groupage Flag

FUNCTIONAL OVERVIEW

Client Requirement

Within the trip detail screen we need to identify if the trip is classified as a full load or groupage load and the current report changed to reflect this additional report feature. We require a check field within the trip detail screen that is unchecked on trip generation, but needs to be checked and you are unable to take the trip out of planned status until one of the check boxes is checked. We also have a finance export report that needs to be changed as well to incorporate these changes.

Due to European rate structures a part load can in a finance point of view be a full load so this can identify loads that we can easily identify and therefore monitor and report on to increase vehicle utilisation etc.

Solution

A new system parameter will be created called TRM_STATUS_CHECK_FTL_GROUP with a Y or N value. If set to be Y, the status of a trip cannot be progressed from PLANNED to either TENDERED, ACCEPTED or EN_ROUTE without the FTL or GRP checkbox being set. An appropriate popup warning message will be displayed if the status change is rejected. The Trip Manipulation from will be modified to allow a checkbox entry to categorise each trip as FTL or GRP. This will be a manual input with a mouse click to one or other checkbox. Once set, the two checkboxes will toggle; in other words one or other condition is valid, not both or neither. The Finance Export CSV will be modified to include the FTL / GRP flag in column 34. Additionally column 11 will be renamed to Seal No. and Column 11a included showing the trip container number field. (note there are other RIO changes relating to this same export MW-779JFA dates plus weight column).

Scope

This change will be applied to system version 10.6.

SET-UP

Pre-requisites

None.

Menu Structure

No changes.

Data

System parameter FULL_LOAD_GROUPAGE_FLAG needs to be added to table ADM_SYSTEM_PARAM.

FUNCTIONAL DESCRIPTION

Changes to Trip Manipulation

FTL and GRP tick boxes will be added to the Trip Detail tab.Both tick boxes will be blank when the trip is created. One of the boxes must be ticked before the trip can be taken out of planned status.If the system parameter, Full_load_groupage_flag, is set to ‘N’, the screen will not check the flags before a status change. If the parameter is set to ‘Y’ the status change will only be allowed if one of the flags is set.

Changes to Finance Report

The finance report will be changed to add a column, and to alter 2 existing columns.

(11)	Name change
(11a) 	NEW Column
(34)	Needs to look against new Check Box instead of Container No.

All the New/Amended columns are to be set as Text on extract.

APPENDIX A: TABLE UPDATES REQUIRED

Add the column FULL_LOAD (varchar2(10))  to table sch_trip. 

References

No references.

Document History

Version	Date	Status	Reason	Initials
1a	25/03/08	Draft	Initial version	DNG

Authorised By

Dave Meir

Development Manager

Nick Wilkins

Copyright OBS Logistics © 2007

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