Reports Details: Difference between revisions

From CTMS
VisualWikitext
m (Minor correction)
m (Anw moved page Reports List to Reports Details)
(No difference)

Revision as of 12:42, 31 July 2025

10.6 Booked Orders

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
End Schedule M
Group Name M
Depot O Depot Location Id Name
Customer O

REP-106-BOOKED ORDERS.png

10.6 Collection Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Customer O
Trip ID (optional) O
Group Name O
Depot O Depot Location Id Name
Carrier O

10.6 Daily Collections

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Owning Depot O Depot Location Id Name
From Schedule M
Group Name M
To Schedule M

10.6 Despatch Report By Carrier

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
Carrier O
Depot O Depot Location Id Name
Schedule M

REP-106-DESP-BY-CARRIER.png

10.6 Despatch Report By Start Time

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Depot O Depot Location Id Name
Carrier O
Group Name O

REP-106-DESP-START-TIME.png

10.6 Drivers Run Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O Depot Location Id Name
End Schedule M
Start Schedule M
Schedule M
Carrier M

REP-106-DRIVERS-RUN-SHEET.png

10.6 Failed Locations Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
To Date M TODAY
From Date M TODAY

10.6 Front Desk Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
Start Schedule M
End Schedule M
Owning Depot M Depot Location Id Name
Customer O
Carrier O

10.6 Front Desk Sheet DSG

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O Depot Location Id Name
Schedule M

10.6 Haulier Confirmation

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
End Schedule M
Group Name O
Carrier O
Carrier Is Not O
Owning Depot O Depot Location Id Name

10.6 Haulier Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Load Location M Loading Location Location Id Name
Owning Depot O Depot Location Id Name
Carrier O
Group Name O

REP-106-HAULIER-TRIP-SHEET.png

10.6 Load Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip Id (optional) O
Owning Depot O Depot Location Id Name
Carrier O
Loading Location M Loading Location Location Id Name
Loading End Date M TODAY
Loading Start Date M TODAY
Customer O

10.6 Load Planning

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
End Date M TODAY
Booked Status O
Start Date M TODAY
Region O
Order Status O STRING
Customer O Customer Customer Id Name
Owning Depot O Depot Location Id Name

10.6 Loading Schedule

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier O
End Schedule M
Start Schedule M
Depot M Depot Location Id Name
Trip Id (optional) O
Customer O CUSTOMER CUSTOMER_ID CUSTOMER NAME

10.6 Loading Schedule Summary

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Group Name O
Owning Depot O Depot Location Id Name
To Date M TODAY
From Date M TODAY
Carrier O
Loading Location M Loading Location Location Id Name

10.6 Missing Load Ref Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
Customer O
Group Name M
End Schedule M

10.6 Pick Control Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Order Status M STRING ALL
From Date M TODAY
Customer O
Depot O Depot Location Id Name
To Date M TODAY

10.6 Store Delivery Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier M
Schedule M

10.6 Sub-Contractor Summary Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier O
Schedule M
Depot M Depot Location Id Name

10.6 Traffic Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot M Depot Location Id Name
Date M TODAY
Group Name O

10.6 Trailer Tracking

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trailer ID O
Depot O Depot Location Id Name
To Date M TODAY
From Date M TODAY

10.6 Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
To Date M TODAY
From Date M TODAY
Owning Depot M Depot Location Id Name
Customer O
Carrier O
Trip Id (optional) O

REP-106-TRIP-SHEET.png

10.6 Trip Sheet Barcode

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY
Trip Id (optional) O
Owning Depot M Depot Location Id Name
Carrier O
Group Name O
Customer O

10.6 Trip Stops

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
Carrier O
Customer O
Owning Depot M Depot Location Id Name
Start Schedule M
End Schedule M

REP-106-TRIP-STOPS.png

10.6 Trip Stops DSG

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
End Schedule M
Start Schedule M
Owning Depot O
Carrier O

REP-106-TRIP-STOPS-DSG.png

10.6 Trip Stops UKS

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
Carrier M STRING ALL
End Schedule M

10.6 Unbooked Orders

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name M
Customer O
Start Schedule M
End Schedule M

10.6 Unscheduled Orders

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
End Sched M
Group Name M
Customer O
Start Sched M

REP-106-UNSCHED-ORDS.png

10.6 Warehouse Loading Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier M
Schedule M

AA Delivery Status Report External

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Usage M STRING EXTERNAL
End Schedule M
Start Schedule M
Customer M STRING ALL

AA Delivery Status Report Internal

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Usage M STRING INTERNAL
Customer M STRING ALL
End Schedule M
Start Schedule M

AA Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY
Customer O
Group Name O
Carrier O
Owning Depot M Depot Location Id Name
Trip ID (optional) O

Abnormal Product Volumes

The information for this report is collated from the Product Item file form, provided by uploaded product data from clients’ third-party systems. Parameters to be supplied are: Minimum volume and maximum volume, both in cubic metres, and the number of days for the report to cover, working back from the present day. This report is typically used if a problem with the DU’s arises, i.e. case sizes.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Min. Volume (cu.m) M STRING 0.000005
In the Last ___ Days M STRING 30
Max. Volume (cu.m) M STRING 0.2

Abnormal Product Weights

The information for this is collated from the Product Item file, provided by uploaded product data from clients’ third-party systems. Parameters to be supplied are: Minimum and maximum weight, both in kilograms, and the number of days for the report to cover, working back from the present day. This report is typically used if a problem with the DU’s arises, i.e. case sizes.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
In the Last ___ Days M STRING 30
Max. Weight (kg) M STRING 18
Min. Weight (kg) M STRING 0.2

Adjusted Invoice

This report is called from the Invoices form. It produces an Adjusted Invoice for those customers using Provisional Invoicing Advance Orders This report is used by the planner to check what advances are in the system. Data can be displayed for all or a given schedule.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Invoice No M
Credit Acc M
Debit Acc M

Advance Orders

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Sched Name M

Asset Inventory

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Dwell From O STRING
Active O STRING
Status O STRING
Asset Type O STRING
Current Location O STRING
Dwell To O STRING

BG Load Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Trip Id (optional) O
Owning Depot O Depot Location Id Name
Carrier O
Loading Locaton M Loading Location Location Id Name
Loading End Date M TODAY
Loading Start Date M TODAY

BG HC Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (optional) O
Owning Depot M Depot Location Id Name
From Date M TODAY
To Date M TODAY
Customer O
Group Name O
Carrier O

REP-BG-HC-TRIP-SHEET.png

BG Loading Schedule Summary

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
Loading Location M Loading Location Location Id Name
To Date M TODAY
Owning Depot O Depot Location Id Name
Group Name O
Carrier O
Customer O

BG Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Owning Depot M Depot Location Id Name
From Date M TODAY
To Date M TODAY
Trip Id (optional) O
Group Name O
Carrier O

REP-BG-TRIP-SHEET.png

BNL Delivery Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Trip M

Backhaul Schedule

This provides a view of all collections and back-hauls, and is used to check what is planned against the supplier’s requirements. The data is displayed for a user-supplied depot.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Carrier O

Bathstore Return To Base

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Schedule M
Trip Id (optional) O

Bathstore Trip Sheet/Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Schedule M
To Schedule M
Trip Id (optional) O
Cost Centre O
Carrier (optional) O

REP-BATHSTORE-TRIP-SHEET.png

Baxter Delivery Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Copies M 1
Carrier O
Depot O Depot Location Id Name
From Date O TODAY
To Date O TODAY
Schedule O
Trip ID O

REP-BAXTER-DELNOTE1.png

Baxter Load Summary Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Cost Centre O STRING ALL
Start Schedule M
End Schedule M

Baxter Loading Schedule

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O
Unloaded At O
Start Schedule M
Depart End O TODAY
Cost Centre O BAX
End Schedule M
Depart Start O TODAY

Breach Driving Regulations

This prints the total driving time and the total trip time for all carriers/trips that have breeched

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M

British Gas Waste Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot O
Customer O
To Schedule O
From Schedule O
Trip ID O

Buf Loading Schedule

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Changed Since O TODAY
To Date M TODAY
Include Order No M STRING N
From Date M TODAY
Carrier M STRING ALL
Depot M Depot Location Id Name

CMR

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Trip id O STRING ALL
Carrier O STRING ALL

CMR BNL Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip M
Schedule M

CN Booked Orders

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
End Schedule M
Depot O Depot Location Id Name
Customer O
Group Name M

CN Collection Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (optional) O
Depot O Depot Location Id Name
Group Name O
Carrier O
Customer O
Schedule M

CN Daily Collections

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O Depot Location Id Name
Customer O
To Schedule M
From Schedule M
Group Name M

CN Despatch Report By Carrier

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O Depot Location Id Name
Group Name O
Schedule M
Carrier O

CN Despatch Report By Start Time

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
Carrier O
Schedule M
Depot O Depot Location Id Name

CN Failed Locations Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
From Date M TODAY
To Date M TODAY

CN Front Desk Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier O
Owning Depot M Depot Location Id Name
Customer O
Group Name O
End Schedule M
Start Schedule M

CN Haulier Confirmation

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier Is Not O
Carrier O
Group Name O
End Schedule M
Start Schedule M
Owning Depot O Depot Location Id Name

CN Haulier Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Carrier O
Group Name O
Load Location M Loading Location Location Id Name
Owning Depot O Depot Location Id Name

REP-CN-HAULIER-TRIP-SHEET.png

CN Load Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot O Depot Location Id Name
Trip ID (optional) O
Loading Start Date M TODAY
Loading End Date M TODAY
Carrier O
Customer O
Loading Location M Loading Location Location Id Name

CN Load Manifest for Consol Centres

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Carrier O
Loading End Date M TODAY
Loading Start Date M TODAY
Trip ID (optional) O
Owning Depot O Depot Location Id Name
Loading Location O Loading Location Location Id Name

CN Load Planning

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot O Depot Location Id Name
Customer O Customer Customer Id Name
Region O
Booked Status O
Order Status O
To Date M TODAY
From Date M TODAY

CN Loading Schedule

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (optional) O
Depot M Depot Location Id Name
Customer O Customer CUSTOMER_ID CUSTOMER_NAME
Carrier O
End Schedule M
Start Schedule M
Owning Depot O Depot Location Id Name
Customer O
Carrier O
Group Name O
To Date M TODAY
Loading Location M Loading Location Location Id Name
From Date M TODAY

CN Missing Load Ref Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
Customer O
Group Name M
End Schedule M

CN Order Status

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Order Status O
Booked Status O
Region O
Sched To M
Customer O Customer Customer Id Name
Sched From M
Owning Depot O Depot Location Id Name

CN Pick Control Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
Depot O Depot Location Id Name
Customer O
To Date M TODAY

CN Sub-Contractor Summary Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Depot M Depot Location Id Name
Carrier O

CN Traffic Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
Date M TODAY
Depot M Depot Location Id Name

CN Trailer Tracking

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
To Date M TODAY
Trailer ID O
Depot O Depot Location Id Name

CN Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
Trip ID (optional) O
To Date M TODAY
Owning Depot M Depot Location Id Name
Customer O
Group Name O
Carrier O

REP-CN-TRIP-SHEET.png

CN Trip Stops

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
Carrier O
Customer O
Group Name O
End Schedule M
Owning Depot M Depot Location Id Name

REP-CN-TRIP-STOPS.png

CN Unbooked Orders

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
End Schedule M
Customer O
Group Name M
Start Schedule M

CN Unscheduled Orders

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
End Schedule M
Start Schedule M
Group Name M

CN Warehouse Loading Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O Customer CUSTOMER_ID CUSTOMER_NAME
Trip ID (optional) O
Carrier O
End Schedule M
Start Schedule M
Depot M Depot Location Id Name

Carrier Invoice

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Credit Acc M
Debit Acc M
Invoice No M
Credit Acc M
Debit Acc M
Invoice No M

Carrier Manifest (DHL Express)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
End Date O TODAY
Carrier ID O
Trip ID O
Start Date O TODAY

Carrier Manifest (Movianto)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier ID O
Trip ID O
End Date O TODAY
Start Date O TODAY

Carrier Manifest (Standard1)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Date M
Trip ID O
Carrier ID O
End Date M

Carrier Manifest (Standard2)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Date M
Carrier ID O
Trip ID O
End Date M

Carrier Manifest (UKMail)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID O
End Date M TODAY
Start Date M TODAY
Carrier ID M

Carrier Manifest (Yodel)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier ID O
End Date O TODAY
Start Date O TODAY
Trip ID O

Carrier Work Confirmation

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Schedule M
To Schedule M
Carrier O

Collections Deviation Distance

This report display trip details for depot and collection location.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Location (Optional) O Location (Optional) Location Id Name
From Date M TODAY
To Date M TODAY
Depot M Depot Location Id Name

Collections Excess Distance

This report prints trip details for those trips which have exceeded the specified distance for depot specified.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Minimum Miles M STRING 0
Depot M Depot Location Id Name
From Date M TODAY
To Date M TODAY

Combined Documents BNL

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Trip M

REP-COMBINED-DOCS-BNL.png

REP-COMBINED-DOCS-BNL2.png

REP-COMBINED-DOCS-BNL3.png

Control Tower Traffic Plan

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Owning Depot O Depot Location ID Name

Customer Delivery Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date O TODAY
Copies M 1
From Date O TODAY
Trip ID O
Depot O Depot Location Id Name
Carrier O
Schedule O

Customer Dunelm

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Debit Acc M
Invoice No M
Credit Acc M

Customer Invoice

This report is called from the Invoices form, and produces invoices for the specified customer

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Debit Acc M
Credit Acc M
Invoice No M
Debit Acc M
Credit Acc M
Invoice No M

Daily KPI by Schedule

This report displays various KPI information, such as no of Orders on a schedule , No of trips on a schedule, No of on-time deliveries on a schedule, etc

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M

Daily Store ASN

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Detail/Summary M
Store O Store Location ID Name

Delivery Docs

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID M STRING ALL

Delivery Note HCR

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID O
Copies M 1
To Date O TODAY
From Date O TODAY
Schedule O
Carrier O
Depot O Depot Location Id Name

REP-DELNOTE-HCR.png

Delivery Note HCR1

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date O TODAY
From Date O TODAY
Trip ID O
Copies M 1
Depot O Depot Location Id Name
Carrier O
Schedule O

Distribution

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M
To Date M
Details Section M
Zone Section M
Customer Section M
Zone M Zone ZONE_ID ZONE_ID
Customer M CUSTOMER CUSTOMER_NAME CUSTOMER_ID

Dom Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID M
Schedule O

Domestic Order

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
OMS Ref M

Driver Days

This report enables transport departments to monitor trips and changes to trips for a given time period. It provides information about the current status of trips, the drivers assigned to the trip and the volumes being transported.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O Depot Location Id Name
From Date M TODAY
To Date M TODAY
Carrier O

Driver Itineraries

This report is used by the sites. It outlines the trips leaving from a site, the times, their destinations and the load in RPEs for each trip. The required parameters are date range and depot.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
Depot M Depot Location Id Name
From Date M TODAY

Driver Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Schedule O
Trip ID O
From Schedule O
Customer O
Group Name O
Carrier ID O
Owning Depot O

Driver Run Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Owning Depot O Depot Location ID Name

REP-DRIVER-RUN-SHEET.png

Dunelm Coll Manifest Recon

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
To Schedule O
From Schedule O

Dunelm Collection Arrivals

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot M Depot Location Id Name
Schedule M

Dunelm PO Reconciliation

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From PO O
Store O
To PO O
Delivery Date O

Dunelm Unloading Variance

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Depot M Depot Location Id Name
Trip Id (optional) O
Depot O Depot Location_Id Name
Schedule M

Early/Late Deliveries

This shows all the early and late deliveries and shows order id, trip numbers, destination of orders, the type of produce, quantity and unloads start time.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Product Type M
Min Du Qty M STRING 0
Arrive Time M STRING 07:30
Before/After Time M STRING BEFORE
Latest Delivery M TODAY
Earliest Delivery M TODAY
Depot M Depot Location Id Name

Early/Late Deliveries (MTM)

This shows all the early and late deliveries and shows order id, trip numbers, destination of orders, the type of produce, quantity and unloads start time.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Before/After Time M STRING BEFORE
Product Type M STRING AMBIENT
Depot M
Arrive Time M STRING 07:30
Schedule M

Excess Waiting Time

This report display trips which have a waiting time greater than that specified for a specified carrier

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Min Waiting Time M STRING 60
To Date M TODAY
From Date M TODAY
Carrier O

Generic Portal Label

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
OMS Ref M

Grid Closure

This report shows what products have been picked out side of Grid Closure (POR)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Depot M Depot Location Id Name
Grid Closure Time M STRING 01:15
Product Type M

HC Booking In Form

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Group Name O
Customer O
Delivery Location O
Schedule M
Group Name O
Customer O
Delivery Location O

HC Delivery Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID O
Depot O Depot Location Id Name
Carrier O
Schedule O
Copies O 1
To Date O TODAY
From Date O TODAY

HC Haulier Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (optional) O
Schedule M
Carrier O
Group Name O
Owning Depot O Depot Location Id Name
Load Location O Loading Location Location Id Name
Group Name O
Carrier O
Schedule M
Trip ID (optional) O
Owning Depot O Depot Location Id Name
Load Location O Loading Location Location Id Name

REP-HC-HAULIER-TRIP-SHEET.png

HC Load Summary Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Sched End M
Group Name M STRING ALL
Sched Start M
Outbase Depot M STRING ALL
Carrier M STRING ALL

HC Loading Schedule

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
Depot M Depot Location Id Name
To Date M TODAY
Changed Since O TODAY
Include Order No M STRING N
Carrier M STRING ALL

HC Marshalling Exception Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot M STRING Depot Location Id Name
Customer M STRING ALL
To Date M TODAY
From Date M TODAY

HC Shunt Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Load Location O Loading Location Location Id Name
Owning Depot O Depot Location Id Name
Trip ID (optional) O
Carrier O
Group Name O
Schedule M

REP-HC-SHUNT-SHEET.png

HC Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (optional) O
Customer O
Owning Depot M Depot Location Id Name
From Date M TODAY
To Date M TODAY
Carrier O
Group Name O

REP HC TRIP SHEET.png

HC Van Delivery Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date O TODAY
To Date O TODAY
Copies O 1
Schedule O
Carrier O
Depot O Depot Location Id Name
Trip ID O

REP-HC-VAN-DELNOTE.png

HCR Loading Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot O Depot Loading Location Name
Schedule M
Carrier O
Trip ID (optional) O
Load Location O Loading Location Loading Location Name
Group Name O

REP-HCR-LOADING-SHEET.png

Haulier Confirmation

This report displays carrier information along with trip details

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID(Optional) O STRING
From Date M TODAY
To Date M TODAY
Carrier O

Haulier Invoice

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Invoice ID O STRING
Start Date O
End Date O
Invoice ID O STRING
Start Date O
End Date O

Haulier Performance

This report display the performance of each haulier for a specific period of time

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
To Date M TODAY

ISC Road Ops Trip Control Form

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Euro Exchange Rate M STRING 1.00000
Trip Ref M

Inbound Schedule

This report shows all the trips scheduled to arrive at depots.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
Depot M Depot Location Id Name
From Date M TODAY
Trip Status M STRING ALL

Item Labels (DOM)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID M
Collection Location O Collection Location Location Location

Item Labels by Schedule (DOM)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Supplier O

KPI By Lane

This report displays various KPI’s for a specified period of time

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Grouping M STRING CUST_GROUP
End Date M TODAY
Start Date M TODAY
Customer Group O
Tolerance(days) O
Separate Pages M STRING N
Customer Group O
Grouping M STRING CUST_GROUP
Show Detail M STRING Y
End Date M
Start Date M

KPI Summary

The report allows planners to analyse the quality of the plan against the KPI’s to be achieved. The results are restricted by choice of schedule.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M STRING

LFS Despatch Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip id M

LFS Label

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
OMS Ref M
OMS Ref M

LFS Pallet Label

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Pallet ID M
Depot O Depot Location ID Name

Loading List

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID M STRING ALL

Loading Schedule

This report is typically used by a planning centre, and sites and is used quite frequently (2-3 times daily). It displays the state of the plan, and any updated changes made to trips on the plan.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier M STRING ALL
Depot M Depot Location Id Name
From Date M TODAY
To Date M TODAY
Changed Since O TODAY
Include Order No M STRING N

Location Pre-Warning

This report shows the Collection and/or Delivery activities for a given Depot. The parameters used to restrict the results for this report are as follows: Date Range, Trip Status: ALL or Accepted, Load Type: Collected, Delivered or Both, Depot: the list of locations available to the user is determined by whether the operation is using the Lane Based Order mechanism and whether the user is assigned the LBO_TRACKING user parameter. In this case, the list of locations will be based on which lanes the user is authorised to see. If the Lane Based mechanism is not being used by the operation, then the list of depots will be a combination of the Based-at user parameter and the locations set up by the Customer/Customer Group mechanism.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
To Date M TODAY
Depot M Depot Location Id Name
Load Type M STRING ALL
Trip Status M STRING ALL
Load Type M STRING ALL
From Date M TODAY
To Date M TODAY
Depot M Depot Location Id Name
Trip Status M STRING ALL

Low Vehicle Fill

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Min RPE Qty M STRING 40
To Date M TODAY
From Date M TODAY
Depot M Depot Location Id Name

MDD Code 03 Exception Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY

MS RDC Intake Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
RDC Location M STRING
Date From M DATETIME YESTERDAY:20:00
Date To M DATETIME TODAY:19:59
Date
M TODAY
% Fill O STRING 100.00
Depot M STRING
Slot Type M STRING
Location Type O STRING Location Types Location Type
DU Qty O STRING 999999

Moran Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Trip ID O
Group Name O
Carrier O
Owning Depot M Depot Location ID Name
To Date M TODAY
From Date M TODAY
M STRING 0
To Date M TODAY
From Date M TODAY
Depot M Depot Location Id Name

Multiple Deliveries

This shows locations and order details where multiple deliveries are to be made for a particular date range. Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Max Time M STRING 60
To Date M TODAY
From Date M TODAY

NHSBT Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Schedule M
Trip ID M
End Schedule M

REP-NHSBT-MANIFEST.png

REP-NHSBT-MANIFEST-2.png

NR Driver Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID O
To Schedule O
From Schedule O
Owning Depot O
Carrier Name O
Group Name O
Customer O

NR Order Conf

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer Ref M

NR Supplier Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot O
Collection Postcode O
Trip ID O
To Schedule O
From Schedule O
Carrier Name O
Group Name O
Customer O

Non Slot Deliveries

This shows all the deliveries to be delivered outside of a locations slot.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY
Depot M Depot Location Id Name
Schedule M
Depot M

Openfield Drivers Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot O
Customer O
Group Name O
Carrier Name O
From Schedule O
To Schedule O
Trip ID O

Operational Value Detail

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
Customer Group
From Date M TODAY
Cost Centre M
Customer

Operational Value Summary

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY

Order Conf

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
OMS Ref M

Order Variance Qty by Product

This report shows all the orders that have a variance against them, where the Create TI’s process from Bookings Information has created the orders.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Destination O Destination Location Id Name
Source O Source Location Id Name
Product Type O
Min. DU Variance M STRING
Schedule M

Order Variance Qty by Store

This report shows the same as Order Variance Qty by Product but groups the result by store.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Source O Source Location Id Name
Schedule M
Min. DU Variance M STRING
Destination O Destination Location Id Name
Product Type O

Order Variance Qty by Trip

This report shows the same as Order Variance Qty by Product but shows the result by trip.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Destination O Destination Location Id Name
Product Type O
Source O Source Location Id Name
Min. DU Variance M STRING
Schedule M

PL Pallets Ticket

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
To Date M TODAY
Group Name O
Owning Depot M Depot Location Id Name
Load Location O Loading Location Location Id Name
Carrier O

PL Transport Order

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Load Location O Loading Location Location Id Name
Cost Centre M Cost Centre Cost Centre Cost Centre
Owning Depot M Depot Location Id Name
Carrier O
To Date M TODAY
From Date M TODAY

PL Trip Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot M Depot Location Id Name
Group Name O
Carrier O
To Date M TODAY
From Date M TODAY
Load Location O Loading Location Location Id Name

Pending Supplier Invoices

This report displays the pending supplier invoices, with total amount of all invoices, for a user-supplied date range

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY

Plan Exceptions

This report displays several sections of planning exceptions:

  • Non Slot Deliveries
  • Advance Breaches
  • Short Trips
  • Missing Trailer Types
  • Light Trips
  • Over Laden Trips
  • Missed Collection Windows
  • Incompatible Temperature Combinations

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Max Deviation Miles M STRING 80
Light Trip Min. RPE M STRING 30
Schedule O
Short Trip Min. Miles M STRING 200
Overladen Trip Tol. M STRING 0.5

Poland Pallet Label

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Depot M Depot Location Id Name

Polarspeed Label

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer Ref M

Prov Booking Exception Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
To Date M TODAY

Rigel Delivery Note

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID O
Depot O Depot Location Id Name
Carrier O
From Date O TODAY
Copies M 1
To Date O TODAY
Schedule O

SCALE Drivers Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID O
To Schedule O
Owning Depot O
Carrier Name O
Group Name O
Customer O
From Schedule O

STL Driver Manifest

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (Optional) O
End Date M TODAY
Start Date M TODAY

Service Self Bill

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Invoice ID M

Shipments Invoice

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY

Short Trips

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
To Date M TODAY
Carrier M STRING ALL
Max Time M STRING 360

Slot Usage

The report displays which slots that have been used in the creation of Transport Instructions, and the RPEs being transported for that particular slot for a particular period of time.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
Slot Usage O STRING
Depot M Depot Location Id Name
From Date M TODAY

Slot Variance

The report displays all new slots that have been created in C-TMS since the last VAST file upload, or created manually in the system. The parameter used to restrict the results is Slot variance with a choice of ‘manual’ or ‘new’.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Slot Variance M STRING M

Stapletons Load Sheet

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Depot M Depot Location_id Name
Trip M STRING ALL

Store Cage Collections

The report displays all the trips for stores and the associated RPE quantity of cages returned to an RDC with the query restricted by the number of stops on a trip that return to RDCs as a percentage of the overall trip.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
RDC Return Less % M STRING 50
From Date M TODAY
To Date M TODAY

Supplier Invoice

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Start Date O
Invoice ID O STRING
End Date O
Start Date O
Invoice ID O STRING
End Date O

The Driver Sheet

The report displays the trip deliveries for a particular day for a chosen driver. This outlines the driver’s day.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot M Depot Location Id Name
Carrier O
Trip ID(Optional) O STRING
ToDate M TODAY
From Date M TODAY

REP-THE-DRIVER-SHEET.png

The Front Desk Sheet

This report shows all the departures from a particular depot and includes information such as destination of orders, driver, trailer type and total distance.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot M Depot Location Id Name
To Date M TODAY
From Date M TODAY

Trailer Shunting

This report is typically used by sites to track the shunting of the trailers.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY
Depot M Depot Location Id Name

Trip Sheet (Generic Barcode)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (optional) O
Owning Depot M Depot Location ID Name
Carrier O
Group Name O
Customer O
To Date M TODAY
From Date M TODAY

REP-DRIVER-TRIP-SHEET-GENERIC-BC.png

Trip Sheet (Generic Detail)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier O
Group Name O
Customer O
To Date M TODAY
From Date M TODAY
Trip ID (optional) O
Owning Depot M Depot Location ID Name

REP-TRIP-SHEET-GENERIC-DTL.png

Trip Sheet (Generic New)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Trip ID (optional) O
Owning Depot M Depot Location ID Name
Carrier O
Group Name O
Customer O
To Date M TODAY
From Date M TODAY

REP-DRIVER-TRIP-SHEET-GENERIC-NEW.png

Trip Sheet (Generic)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY
Customer O
Group Name O
Carrier O
Owning Depot M Depot Location ID Name
Trip ID (optional) O

REP-TRIP-SHEET-GENERIC.png

Trip Sheet BNL

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Group Name O STRING
Carrier O
Owning Depot O
Trip ID O STRING
Schedule To M
Schedule From M

Trip Sheet Barcode

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Group Name O
Customer O
Trip Id (optional) O
Owning Depot M Depot Location Id Name
Carrier O
From Date M TODAY
To Date M TODAY

REP-TRIP-SHEET-BARCODE.png

Trip Sheet Dunelm

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Owning Depot M Depot Location Id Name
Trip Id (optional) O
Carrier O
Group Name O
Customer O
To Date M TODAY
From Date M TODAY

Trip Sheet Dunelm (Detail)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Customer O
Owning Depot O Depot Location Id Name
From Date M TODAY
To Date M TODAY
Trip Id (optional) O
Carrier O
Group Name O

Trip Sheet Dunelm (New)

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Carrier O
Trip Id (optional) O
Owning Depot O Depot Location Id Name
Group Name O
From Date M TODAY
To Date M TODAY
Customer O

Trip Sheet TDL

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
From Date M TODAY
To Date M TODAY
Customer O
Group Name O
Owning Depot M Depot Location Id Name
Trip Id (optional) O
Carrier O

REP-TRIP-SHEET-TDL-1.png

REP-TRIP-SHEET-TDL-2.png

Trip Summary

This report provides summary information about trips for a specified time period such as start and departure times, total mileage of each trip, first collection and first delivery locations, carrier, and early and late delivery times.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
To Date M TODAY
From Date M TODAY

Unplanned Product

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O Depot Location Id Name
Min Variance Qty M STRING 0
From Date M TODAY
To Date M TODAY

Unplanned Quantity

This report shows the underplanned and overplanned quantities of types goods, e.g. Perishable, Frozen etc. for each depot for a particular Schedule.

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule Date M TODAY
Show Store Detail M STRING NO
Overplanned RPE > M STRING 0
Underplanned RPE > M STRING 0
Depot O Depot Location Id Name

Unscheduled Order Report

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Depot O STRING Depot Location ID Name
Schedule M
Order By M
Customer M STRING ALL
DU Category O STRING
Order Status M STRING UNSCHEDULED

Vehicle Despatch

Parameters:

Name Mand Def Type Def Val LOV Col 1 Col 2 Col 3
Schedule M
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/MTS/index.php?title=Reports_Details&oldid=7954’