274152

274152 - PA-82JSE9/ Add 2 x Fields to CTMS report

Copyright OBS Logistics © 2010

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

Add 2 x Fields to CTMS report Allan Butterworth/St Albans/UK/Exel. CN Trip and Order detail export report - add 2 x fields - [KM from previous Stop] and [Stop type] between [Stop No] and [Planned Arrival] Gives the ability to determine Empty Distances

Solution

The Stop Type already exists on the export in between Stop No and Planned Arrival. Therefore this change is to add the additional field ‘KM from Previous Stop’ this will be populated from the DISTANCE_FROM_PREV_STOP field on the SCH_TRIP_STOP table. This will mean a change is needed to the CSV package in the WRITE_CN_TRIP_ORDER_DETAIL procedure. The selection cursor will need to be changed along with the export output.

FUNCTIONAL DESCRIPTION

Not Applicable

REFERENCES

Not Applicable

DOCUMENT HISTORY

Not Applicable

AUTHORISED BY

Not Applicable

Back to CONPRD Release - 24/02/2010