Extracts
The Exports module of C-TMS 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 C-TMS, 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 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 |
| 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. |
User Access
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.
Form Usage
The Exports form is used by configuring the following options and then using the EXPORT function to initiate the export:
Export
A drop-down list allows the user to choose from the different exports installed on C-TMS.
User Parameters
When the user selects an export, they will be presented with a list of parameters, some of which will be mandatory, others will be Optional. Some exports do not require any input from the user.
