268395
268395 - PA-7UVB6P/ CN Trip and Order Det Extract additions
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
Request Summary
Add fields to CN Trip and Order Detail Extract.
Request Detail
Actual Distance (Adjacent to Planned Distance), Stop Type (eg SU,DL,PK,CL adjacent to Stop Number)
Solution
Scope
The’ CN Trip and Order Detail Extract’ report will be altered to display a new ‘Stop Type’ field. This will be taken from the SCH_TRIP_STOP.STOP_TYPE data and will be displayed after the existing ‘Stop Number’ field. In addition, a new ‘Actual Distance’ field will be added after the existing ‘Total Distance’ field. The ‘Total Distance’ field will be renamed ‘Planned Distance’. The ‘Actual Distance’ field will be derived from the ODO_END field minus the ODO_START field and will be displayed for trips that are at status ‘CONFIRMED’ and ‘COMPLETED’ only. For all other values of trip status, the ‘Actual Distance’ field will be displayed as 0.
FUNCTIONAL DESCRIPTION
Not Applicable
REFERENCES
Not Applicable
DOCUMENT HISTORY
Not Applicable
AUTHORISED BY
Not Applicable
Back to CONPRD Release - 24/02/2010
