264533

FUNCTIONAL OVERVIEW

Client Requirement

A new .csv data extract is required from MTS to allow the Polish team to manage pallet balances owed from Customers and Carriers. The minimum data requirements to be included in this are:

Schedule
Customer
Carrier
From Location
To Location
DU Type
Qty Delivered
Qty Collected
Qty returned by Carrier*
Date received from Carrier*

The criteria for running this Export should be:

From and To Date based on Schedule (Mandatory)
Customer (Optional - if not selected include all)
Carrier (Optional - if not selected include all)
Owning Depot (Optional - if not selected include all)

Solution

A new csv will be created to run from the existing exports screen. The parameters for this extract will be

Date Range (from and to), 
Customer, 
Carrier 
Owning Depot. 

If these values are not selected then All will be chosen.

The below fields will be included in the extract

Schedule
Customer
Carrier
From Location
To Location
DU Type 
Qty Collected
Qty Delivered
Qty Received by Carrier
Qty Returned by Carrier
Date received from Carrier

Scope

This change will be applied to system version 10.6.

SET-UP

Data

The new export will be added to the standing data to allow it to be selected from the standard exports form. The selection criteria for the export will be;

Date Range 
Customer(s) All
Owning Depot All 
Carrier(s) All.

3. FUNCTIONAL DESCRIPTION

The date will be taken from the new table SCH_EQUIPMENT_MOVES. This table is populated when the Actual Despatch, Actual Deliver, Exchange Qty or Received Qty fields are changed. A record is written for each change and will contain the quantity, du type and trip \ order information associated with the move.

The date displayed in the export will be.

Action Date		Date Movement entered. 
Type			Type of movement
Customer		Customer
Planned Date		Planned Del Date
Actual Date		Actual Del Date
MTS Ref		OMS Ref
Cust Ref		External Ref
Del DU Type		DU Type
Planned Del Qty	DU Qty
Carrier		Carrier
Ticket Received	Ticket Received Date
Trip			Trip Reference
From Loc		From Location
To Loc			To Location
Stop			Stop number
Action DU Type		DU Type associated with the movement
Prev Qty		Previous Quantity
New Qty		New quantity
Movement		Difference between new and previous quantity
User			User who entered the movement. 

Document History

Version	Date	Status	Reason	Initials
1	12/03/09	Draft	Initial version	DNG

Authorised By

Dave Meir

Development Manager

Suk Sandhu

TMSCC MTS Product Mgr

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