Extracts

C-TMS Exports provides the users with Extracts of data that are required for day to day operations, finance and management reporting.

Requirements for particular exports are defined by the business and once exports have been developed and installed onto C-TMS, they are available to users via the Exports form.

C-TMS Exports can be accessed from the C-TMS Modules menu

Generating Exports

Once you click on the Exports option, the form as shown below will be displayed.

Select the required extract from the drop down field. Based on the Extract that you are selecting a list of parameters for generating the Extract will be displayed as shown below.

Note: User access to particular exports is controlled by the Administration section of C-TMS and is maintained by administrator users of the system. See the ADM section for further information.

In this example, we will look at generating the Failed Shipment. Once the Failed Shipment option is selected, the list of parameters for generating the Extract will be prompted as shown below. Based on the Extract that you are selecting the parameters will vary.

Note: Some parameters are mandatory, others are optional. Some exports do not require any input from the user.

Enter the From, To Schedule and Customer details and click on the Export button to generate the extract. You can save the file to your PC, the method will differ depending on which browser you are using.

Once you have saved the file you can open it in an application on your PC to view or edit.

Available Extracts

The following is a list of common available extracts. There are other bespoke extracts that may also be used. At latest count there are over 240 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 C-TMS in a particular format
Contracts	This export, extracts all contract details within the C-TMS 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
Equipment Moves	The export extracts all of the equipment (DU Type) despatches, receipts, returns and exchanges. You can select by From/To Date/Time, Customer, Carrier and Owning Depot. The extract lists the following information: Action Date, Type, Customer, Planned Date, Actual Date, MTS Ref, Cust Ref, Del DU Type, Planned Del Qty, Carrier, Ticket Received, Trip, From Loc, To Loc, Stop, Action DU Type, Prev Qty, New Qty, Move, User
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.

A series of extracts relating to WCS Scanning has been created - these are available in section Extracts - WCS Scanning.

A list of all extracts including their parameters is shown in section Extracts List.