Extracts

The Exports module of MTS enables the generation of pre-defined CSV files. Requirements for particular exports are defined by the business and once exports have been developed and installed onto MTS, they are available to users via the Exports form shown below.

Available Extracts

Export	Description
Accruals	The information for this export is collated from the Payments and display payment details
Carrier Invoice	This is an export of payments which have been invoiced for a particular invoice number
Carrier completed trips	This is an export of the all the Trips completed by a carrier during a specified period.
Carrier non completed trips	This is an export of the all the Trips that have not been completed (POD applied) by a carrier during a specified period.
CTM Carrier Responsiveness	The information for this is collated from the Sch_Trip Audit table
CTM Trips Not Responded to	This export is used by the planner to check which carriers have not responded to a tender invitation for a trip
Commercial	This provides an extract of orders in MTS in a particular format
Contracts	This export, extracts all contract details within the MTS system in a certain format. .
Customer Invoice	This is an export of payments which have been invoiced for a particular invoice number
Customer Invoice By Dates	This is an export of payments which have been invoiced between two Depot Exits by Hour (Loads) This export shows which products were unloaded – in hourly chunks on a range of dates
Depot Exits by Hour (RPE)	This export shows which products were unloaded – in hourly chunks on a range of dates in RPE
Extract Lane	The export, extracts all the lanes for a particular customer and or cost centre
Fixed Route Extracts	This export, will extract fixed routes, for a particular carrier or depot
KPI by Lane	The export allows planners to analyse the quality of the plan against the KPI’s to be achieved. The results are restricted by choice of schedule.
Kraft KPI	This shows a list of trips with orders for a range of dates for a particular cost centre
Lane Extract	This export, extracts lanes which have been set up for , customer, cost Centre, From Location and To
Load Schedule CSV	This export shows trips which have been loaded and unloaded at a particular Depot between a specified date range.
Location Delivery Pre Warning	This export show trips, which have loaded or unloaded at a specific depot between a specified range of dates in a specified status.
Message Maintenance	This export extracts ALL recipients which have been set up to receive emails & faxes along with the email address/ fax numbers
Order Savings	This export extracts data from the Savings table for a specified range of schedules.
Pre-Invoice Check	This export writes out a list of debit_accounts which are ready for invoicing.
Schedule	This export, writes out a list of trips and orders on a schedule between a date range specified
Schedule Trip CS	The export, writes out details of orders which have been schedule onto trips for a specified customer.
Store Pre-Warning	This export, extracts orders which have been created via the bookings module
Trip Actuals	This export writes out trip details which have been passed into ISOTRAK, for a specified schedule
Variance Analysis Store Detail	This extract write out planned and actual DU’s and RPE’s for all locations for a specified schedule.
Variance Analysis Summary	This extracts summaries totals from the SCH_Product_Summary table for a date range specified
Variance Analysis Trip Detail	This extracts writes out planned and Actual DU’s and RPE’s from the Sch_Order_Line table for a specified schedule.