Reports Details

10.6 Booked Orders

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M
Group Name	P_GROUP_NAME	M
Depot	P_DEPOT	O			Depot	Location Id	Name
Customer	P_CUSTOMER	O

10.6 Collection Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Customer	P_CUSTOMER	O
Trip ID (optional)	P_TRIP_ID	O
Group Name	P_GROUP_NAME	O
Depot	P_DEPOT	O			Depot	Location Id	Name
Carrier	P_CARRIER	O

10.6 Daily Collections

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
From Schedule	P_FROM_SCHED	M
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	M
To Schedule	P_TO_SCHED	M

10.6 Despatch Report By Carrier

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER	O
Depot	P_DEPOT	O			Depot	Location Id	Name
Group Name	P_GROUP_NAME	O
Schedule	P_SCHED	M

10.6 Despatch Report By Start Time

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O
Schedule	P_SCHED	M

10.6 Drivers Run Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	O			Depot	Location Id	Name
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M

10.6 Drivers Run Sheet UKS

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Carrier	P_CARRIER	M

10.6 Failed Locations Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Group Name	P_GROUP_NAME	O

10.6 Front Desk Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	P_SCHEDULE_FROM	M
End Schedule	P_SCHEDULE_TO	M
Group Name	P_GROUP	O
Customer	P_CUSTOMER	O
Owning Depot	P_OWNING_DEPOT	M			Depot	Location Id	Name
Carrier	P_CARRIER_ID	O

10.6 Front Desk Sheet DSG

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Depot	P_OWNING_DEPOT	O			Depot	Location Id	Name

10.6 Haulier Confirmation

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER	O
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Carrier Is Not	P_NOT_CARRIER	O
Group Name	P_GROUP_NAME	O
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M

10.6 Haulier Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Group Name	P_GROUP_NAME	O
Load Location	P_LOAD_LOC	M			Loading Location	Location Id	Name
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Carrier	P_CARRIER	O

10.6 Load Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	P_CUSTOMER	O
Loading Start Date	P_START_DATETIME	M	TODAY
Trip Id (optional)	P_TRIP_ID	O
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
Loading Locaton	P_LOAD_LOC	M			Loading Location	Location Id	Name
Loading End Date	P_END_DATETIME	M	TODAY

10.6 Load Planning

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Owning Depot	P_OWN_DEPOT	O			Depot	Location Id	Name
Customer	P_CUSTOMER	O			Customer	Customer Id	Name
Order Status	P_STATUS	O	STRING
Region	P_REGION	O
Start Date	P_START_DATETIME	M	TODAY
End Date	P_END_DATETIME	M	TODAY
Booked Status	P_BOOKED	O

10.6 Loading Schedule

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	P_START_SCHED	M
Depot	P_DEPOT	M			Depot	Location Id	Name
Customer	P_CUSTOMER	O			CUSTOMER	CUSTOMER_ID	CUSTOMER NAME
Carrier	P_CARRIER	O
End Schedule	P_END_SCHED	M
Trip Id (optional)	P_TRIP_ID	O

10.6 Loading Schedule Summary

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Loading Location	P_LOAD_LOC	M			Loading Location	Location Id	Name
Carrier	P_CARRIER	O
Customer	P_CUSTOMER	O
Group Name	P_GROUP	O

10.6 Missing Load Ref Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	P_START_SCHED	M
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	M
End Schedule	P_END_SCHED	M

10.6 Pick Control Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Order Status	P_ORDER_STATUS	M	STRING	ALL
From Date	P_START_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
Depot	P_DEPOT	O			Depot	Location Id	Name
To Date	P_END_DATETIME	M	TODAY

10.6 Store Delivery Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Carrier	P_CARRIER	M

10.6 Sub-Contractor Summary Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Carrier	P_CARRIER	O
Depot	P_DEPOT	M			Depot	Location Id	Name

10.6 Traffic Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
Date	P_START_DATETIME	M	TODAY
Group Name	P_GROUP_NAME	O

10.6 Trailer Tracking

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	O			Depot	Location Id	Name
Trailer ID	P_TRAILER_ID	O
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

10.6 Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Trip Id (optional)	P_TRIP_ID	O
To Date	P_END_DATETIME	M	TODAY
Carrier	P_CARRIER	O
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O

10.6 Trip Sheet Barcode

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
Trip Id (optional)	P_TRIP_ID	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
To Date	P_END_DATETIME	M	TODAY

10.6 Trip Stops

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER	O
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M

10.6 Trip Stops DSG

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	P_START_SCHED	M
Owning Depot	P_OWN_DEPOT	O
Carrier	P_CARRIER	O
End Schedule	P_END_SCHED	M

10.6 Trip Stops UKS

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M
Carrier	P_CARRIER	M	STRING	ALL

10.6 Unbooked Orders

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	P_CUSTOMER	O
End Schedule	P_END_SCHED	M
Start Schedule	P_START_SCHED	M
Group Name	P_GROUP_NAME	M

10.6 Unscheduled Orders

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	M
End Sched	P_END_SCHED	M
Start Sched	P_START_SCHED	M
Customer	P_CUSTOMER	O

10.6 Warehouse Loading Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER	M
Schedule	P_SCHED	M

AA Delivery Status Report External

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	p_start_sched	M
Usage	p_usage	M	STRING	EXTERNAL
Customer	p_customer	M	STRING	ALL
End Schedule	p_end_sched	M

AA Delivery Status Report Internal

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Usage	p_usage	M	STRING	INTERNAL
Customer	p_customer	M	STRING	ALL
Start Schedule	p_start_sched	M
End Schedule	p_end_sched	M

AA Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
Trip ID (optional)	P_TRIP_ID	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Customer	P_CUSTOMER	O
To Date	P_END_DATETIME	M	TODAY
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	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:

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

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:

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

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Credit Acc	P_CREDIT_ACC	M
Debit Acc	P_ACCOUNT_ID	M
Invoice No	P_INVOICE_NO	M

Advance Orders

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Sched Name	P_SCHED_NAME	M

Asset Inventory

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Dwell From	p_dwell_from	O	STRING
Active	p_active	O	STRING
Current Location	p_current_location	O	STRING
Dwell To	p_dwell_to	O	STRING
Status	p_status	O	STRING
Asset Type	p_asset_type	O	STRING

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_HAULIER	O
Schedule	P_SCHED_NAME	M

Bathstore Return To Base

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Schedule	P_SCHED_NAME	M
Trip Id (optional)	P_TRIP_ID	O

Bathstore Trip Sheet/Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Cost Centre	COST_CENTRE	O
Trip Id (optional)	trip_id	O
Carrier (optional)	carrier	O
From Schedule	sched_from	M
To Schedule	sched_to	M

Baxter Delivery Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_LOCATION	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
Copies	P_COPIES	M		1
To Date	P_END_DATETIME	O	TODAY
From Date	P_START_DATETIME	O	TODAY
Trip ID	P_TRIP_ID	O
Schedule	P_SCHED	O

Baxter Load Summary Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
End Schedule	P_SCHED_TO	M
Cost Centre	P_COST_CENTRE	O	STRING	ALL
Start Schedule	P_SCHED_FROM	M

Baxter Loading Schedule

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depart End	P_END_DATETIME	O	TODAY
Unloaded At	P_LOCATION	O
Start Schedule	P_FROM_SCHED	M
End Schedule	P_TO_SCHED	M
Cost Centre	P_COST_CENTRE	O		BAX
Depot	P_DEPOT	O
Depart Start	P_START_DATETIME	O	TODAY

BG Load Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	P_CUSTOMER	O
Trip Id (optional)	P_TRIP_ID	O
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
Loading Locaton	P_LOAD_LOC	M			Loading Location	Location Id	Name
Loading End Date	P_END_DATETIME	M	TODAY
Loading Start Date	P_START_DATETIME	M	TODAY

BG HC Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID (optional)	P_TRIP_ID	O
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O

BG Loading Schedule Summary

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER	O
Group Name	P_GROUP	O
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
Loading Location	P_LOAD_LOC	M			Loading Location	Location Id	Name
Customer	P_CUSTOMER	O
Owning Depot	P_DEPOT	O			Depot	Location Id	Name

BG Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip Id (optional)	P_TRIP_ID	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O
From Date	P_START_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
To Date	P_END_DATETIME	M	TODAY

BNL Delivery Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	p_sched	M
Trip	p_trip	M

Breach Driving Regulations

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M

British Gas Waste Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	P_CUSTOMER	O
From Schedule	P_START_SCHED	O
To Schedule	P_END_SCHED	O
Trip ID	P_TRIP_ID	O
Owning Depot	P_OWN_DEPOT	O

Buf Loading Schedule

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY
Include Order No	P_INCLUDE_ORD_NO	M	STRING	N
To Date	P_END_DATETIME	M	TODAY
Changed Since	P_CHANGED_DATE	O	TODAY
Carrier	P_VALUE_LIST1	M	STRING	ALL

Carrier Invoice

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Debit Acc	P_ACCOUNT_ID	M
Credit Acc	P_CREDIT_ACC	M
Invoice No	P_INVOICE_NO	M

Carrier Manifest (DHL Express)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	P_TRIP_ID	O
Carrier ID	P_CARRIER_ID	O
End Date	P_END_DATE	O	TODAY
Start Date	P_START_DATE	O	TODAY

Carrier Manifest (Movianto)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Date	P_START_DATETIME	O	TODAY
End Date	P_END_DATETIME	O	TODAY
Trip ID	P_TRIP_ID	O
Carrier ID	P_CARRIER_ID	O

Carrier Manifest (Standard1)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
End Date	P_END_DATETIME	O
Start Date	P_START_DATETIME	O
Trip ID	P_TRIP_ID	O
Carrier ID	P_CARRIER_ID	O

Carrier Manifest (Standard2)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
End Date	P_END_DATE	M
Carrier ID	P_CARRIER_ID	O
Trip ID	P_TRIP_ID	O
Start Date	P_START_DATE	M

Carrier Manifest (UKMail)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Date	P_START_DATETIME	M	TODAY
End Date	P_END_DATETIME	M	TODAY
Carrier ID	P_CARRIER_ID	M
Trip ID	P_TRIP_ID	O

Carrier Manifest (Yodel)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Date	P_START_DATE	O	TODAY
Carrier ID	P_CARRIER_ID	O
Trip ID	P_TRIP_ID	O
End Date	P_END_DATE	O	TODAY

Carrier Work Confirmation

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Schedule	P_SCHED_FROM	M
To Schedule	P_SCHED_TO	M
Carrier	P_CARRIER	O

CMR

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip id	P_TRIP	O	STRING	ALL
Carrier	P_CARRIER	O	STRING	ALL
Schedule	P_SCHED	M

CMR BNL Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip	p_trip	M
Schedule	p_sched	M

CMR BNL Report1

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	p_sched	M
Trip	p_trip	M

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

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER	O
Customer	P_CUSTOMER	O
Loading Location	P_LOAD_LOC	O			Loading Location	Location Id	Name
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Trip ID (optional)	P_TRIP_ID	O
Loading Start Date	P_START_DATETIME	M	TODAY
Loading End Date	P_END_DATETIME	M	TODAY

CN Order Status

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Order Status	P_STATUS	O
Booked Status	P_BOOKED	O
Region	P_Region	O
Owning Depot	P_OWN_DEPOT	O			Depot	Location Id	Name
Customer	P_CUSTOMER	O			Customer	Customer Id	Name
Sched To	P_SCHED_TO	M
Sched From	P_SCHED_FROM	M

CN Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O
Customer	P_CUSTOMER	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
To Date	P_END_DATETIME	M	TODAY

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

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	P_START_SCHED	M
Carrier	P_CARRIER	O
Trip ID (optional)	P_TRIP_ID	O
End Schedule	P_END_SCHED	M
Customer	P_CUSTOMER	O			Customer	CUSTOMER_ID	CUSTOMER_NAME
Depot	P_DEPOT	M			Depot	Location Id	Name

Collections Deviation Distance

This report display trip details for depot and collection location.

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Location (Optional)	P_COL_LOC_ID	O			Location (Optional)	Location Id	Name
Depot	P_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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Minimum Miles	P_MIN_DIST_STORES	M	STRING	0
From Date	P_START_DATETIME	M	TODAY
Depot	P_DEPOT	M			Depot	Location Id	Name
To Date	P_END_DATETIME	M	TODAY

Combined Documents BNL

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip	p_trip	M
Schedule	p_sched	M

Control Tower Traffic Plan

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	scheduleDate	M
Owning Depot	depotSelect	O			Depot	Location ID	Name

Customer Delivery Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	O
From Date	P_START_DATETIME	O	TODAY
To Date	P_END_DATETIME	O	TODAY
Copies	P_COPIES	M		1
Carrier	P_CARRIER	O
Depot	P_LOCATION	O			Depot	Location Id	Name
Trip ID	P_TRIP_ID	O

Customer Dunelm

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Invoice No	P_INVOICE_NO	M
Credit Acc	P_CREDIT_ACC	M
Debit Acc	P_ACCOUNT_ID	M

Customer Invoice

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Invoice No	P_INVOICE_NO	M
Credit Acc	P_CREDIT_ACC	M
Debit Acc	P_ACCOUNT_ID	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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M

Daily Store ASN

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Store	P_STORE	O			Store	Location ID	Name
Schedule	P_SCHED	M
Detail/Summary	P_DETAIL	M

Delivery Docs

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	P_TRIP	M	STRING	ALL

Delivery Note HCR

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_LOCATION	O			Depot	Location Id	Name
To Date	P_END_DATETIME	O	TODAY
Carrier	P_CARRIER	O
Schedule	P_SCHED	O
Trip ID	P_TRIP_ID	O
From Date	P_START_DATETIME	O	TODAY
Copies	P_COPIES	M		1

DG TEST

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
	P_SCHED	M

Distribution

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer Section	P_CUST_SUM	M
To Date	P_TO_DATE	M
Customer	P_CUSTOMER	M			CUSTOMER	CUSTOMER_NAME	CUSTOMER_ID
From Date	P_FROM_DATE	M
Details Section	P_CUST_DTLS	M
Zone Section	P_CUST_ZONE	M
Zone	P_DEPOT	M			Zone	ZONE_NAME	ZONE_ID

Dng Test

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	O			Dng	Location Id	Name
Location Type	P_LOC_TYPE	M

Dom Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	TRIP_ID	M
Schedule	SCHED_NAME	O

Domestic Order Confirmation

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
OMS Ref	P_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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_HAULIER	O
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
Depot	P_DEPOT	O			Depot	Location Id	Name

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
Depot	P_DEPOT	M			Depot	Location Id	Name

Driver Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	CUSTOMER	O
To Schedule	SCHED_TO	O
Owning Depot	OWNING_DEPOT	O
Group Name	GROUP_NAME	O
Carrier ID	CARRIER_ID	O
From Schedule	SCHED_FROM	O
Trip ID	TRIP_ID	O

Driver Run Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	scheduleDate	M
Owning Depot	depotSelect	O			Depot	Location ID	Name

Dunelm Coll Manifest Recon

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	P_CUSTOMER	O
To Schedule	P_COLLECTION_TO	O
From Schedule	P_COLLECTION_FROM	O

Dunelm Collection Arrivals

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
Schedule	P_SCHED	M

Dunelm Daily Store

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Summary or Detail	P_DETAIL	M
Store	P_STORE	M

Dunelm PO Reconciliation

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Delivery Date	P_DELIVERY	O
Store	P_STORE	O
From PO	P_PO_FROM	O
To PO	P_PO_TO	O

Dunelm Unloading Variance

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
Schedule	P_SCHED	M
Trip Id (optional)	P_TRIP_ID	O

Dunelm Vehicle Despatch

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Depot	P_DEPOT	O			Depot	Location_Id	Name

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Before/After Time	P_BEFORE_AFTER	M	STRING	BEFORE
Depot	P_DEPOT	M			Depot	Location Id	Name
Arrive Time	P_ARRIVE_TIME	M	STRING	07:30
Earliest Delivery	P_START_DATETIME	M	TODAY
Product Type	P_PROD_TYPE	M
Latest Delivery	P_END_DATETIME	M	TODAY
Min Du Qty	P_MIN_QTY	M	STRING	0

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Arrive Time	P_ARRIVE_TIME	M	STRING	07:30
Schedule	P_SCHED_NUM	M
Depot	P_DEPOT	M
Product Type	P_PROD_TYPE	M	STRING	AMBIENT
Before/After Time	P_BEFORE_AFTER	M	STRING	BEFORE

Excess Waiting Time

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER_ID	O
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Min Waiting Time	P_MIN_ELAPSED_TIME	M	STRING	60

Generic Portal Label

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
OMS Ref	P_OMS	M

Grid Closure

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Product Type	P_PROD_TYPE	M
Schedule	P_SCHED_NAME	M
Depot	P_DEPOT	M			Depot	Location Id	Name
Grid Closure Time	P_GRID_CLOSURE_TIME	M	STRING	01:15

Haulier Confirmation

This report displays carrier information along with trip details

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
"Trip ID (Optional)"	P_TRIP_ID	O	STRING
Carrier	P_CARRIER	O
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

Haulier Invoice

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Invoice ID	P_INVOICE_NO	O	STRING

Haulier Performance

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY

HC Booking In Form

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	O
Customer	P_CUSTOMER	O
Delivery Location	P_DEL_LOCATION	O
Schedule	P_SCHED_NAME	M

HC Haulier Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Group Name	P_GROUP_NAME	O
Load Location	P_LOAD_LOC	O			Loading Location	Location Id	Name
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Trip ID (optional)	P_TRIP_ID	O
Carrier	P_CARRIER	O

HC Load Summary Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	M	STRING	ALL
Sched Start	P_SCHED_FROM	M
Carrier	P_CARRIER_ID	M	STRING	ALL
Outbase Depot	P_OUTBASE	M	STRING	ALL
Sched End	P_SCHED_TO	M

HC Loading Schedule

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Include Order No	P_INCLUDE_ORD_NO	M	STRING	N
Carrier	P_VALUE_LIST1	M	STRING	ALL
Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Changed Since	P_CHANGED_DATETIME	O	TODAY

HC Marshalling Exception Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
Customer	P_CUSTOMER	M	STRING	ALL
Depot	P_DEPOT	M	STRING		Depot	Location Id	Name

HC Shunt Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	O
Load Location	P_LOAD_LOC	O			Loading Location	Location Id	Name
Owning Depot	P_DEPOT	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
Schedule	P_SCHED	M
Trip ID (optional)	P_TRIP_ID	O

HC Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Trip ID (optional)	P_TRIP_ID	O
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

HC Van Delivery Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	P_TRIP_ID	O
Depot	P_LOCATION	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
Schedule	P_SCHED	O
Copies	P_COPIES	O		1
To Date	P_END_DATETIME	O	TODAY
From Date	P_START_DATETIME	O	TODAY

HCR Delivery Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier	P_CARRIER	O
Trip ID	P_TRIP_ID	O
From Date	P_START_DATETIME	O	TODAY
To Date	P_END_DATETIME	O	TODAY
Copies	P_COPIES	O		1
Schedule	P_SCHED	O
Depot	P_LOCATION	O			Depot	Location Id	Name

HCR Loading Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
Schedule	P_SCHED	M
Owning Depot	P_DEPOT	O			Depot	Loading Location	Name
Load Location	P_LOAD_LOC	O			Loading Location	Loading Location	Name
Trip ID (optional)	P_TRIP_ID	O

Inbound Schedule

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Depot	P_DEPOT	M			Depot	Location Id	Name
Trip Status	P_VALUE_LIST1	M	STRING	ALL

ISC Road Ops Trip Control Form

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Euro Exchange Rate	P_EX_RATE	M	STRING	1
Trip Ref	P_TRIP_REF	M

Item Labels (DOM)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	P_TRIP_ID	M
Collection Location	P_LOCATION_ID	O			Collection Location	Location	Location

Item Labels by Schedule (DOM)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Supplier	P_CUST	O
Schedule	P_SCHED	M

Job Details

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
OMS Ref To	i_oms_to	O
Date to	i_date_to	M
OMS Ref From	i_oms_from	O
Customer	i_customer	O
Date from	i_date_from	M

JP Dummy

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Date From	P_START_DATETIME	M	DATETIME	FIRST:25:12
Date To	P_END_DATETIME	M	DATETIME	LAST

KPI By Lane

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Separate Pages	P_SEPARATE_PAGES	M	STRING	N
Customer Group	P_CUST_GROUP	O
Grouping	P_GROUP_BY	M	STRING	CUST_GROUP
Show Detail	P_SHOW_DETAIL	M	STRING	Y
End Date	P_TO_DATETIME	M
Start Date	P_FROM_DATETIME	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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED_NAME	M	STRING

LFS Despatch Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip id	P_TRIP	M

LFS Label

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
OMS Ref	P_OMS	M

LFS Label Multi

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Source Ref	P_SOURCE_REF	M

LFS Label Sched

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
OMS Ref	p_oms	M

LFS Pallet Label

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Pallet ID	P_PALLET_ID	M
Depot	P_DEPOT_ID	O			Depot	Location ID	Name

LFS Trip Sheet POD POC

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip Id	P_TRIP_ID	M
Sched Name	P_SCHED_NAME	M

Loading List

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	P_TRIP	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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Changed Since	P_CHANGED_DATETIME	O	TODAY
Include Order No	P_INCLUDE_ORD_NO	M	STRING	N
Carrier	P_VALUE_LIST1	M	STRING	ALL

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
Load Type	P_VALUE_LIST2	M	STRING	ALL
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Trip Status	P_VALUE_LIST1	M	STRING	ALL

Low Vehicle Fill

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Min RPE Qty	P_MIN_RPE	M	STRING	40
Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY

MDD Code 03 Exception Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY

Moran Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
Trip ID	P_TRIP_ID	O
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
To Date	P_END_DATETIME	M	TODAY
Owning Depot

MS RDC Intake Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Date From	P_START_DATETIME	M	DATETIME	YESTERDAY:20:00
RDC Location	P_RDC_LOC	M	STRING
Date To	P_END_DATETIME	M	DATETIME	TODAY:19:59

MS Slot Utilisation

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
% Fill	P_FILL	O	STRING	100
DU Qty	P_DU_QTY	O	STRING	999999
Location Type	P_STORE_TYPE	O	STRING		Location Types	Location Type
Date	P_SCHED_DATE	M	TODAY
Depot	P_DEPOT	M	STRING
Slot Type	P_SLOT_TYPE	M	STRING

Multi Drops Excess Distance

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
Minimum Miles	P_MIN_DIST_STORES	M	STRING	0

Multiple Deliveries

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
Max Time	P_MAX_ELAPSED_TIME	M	STRING	60
To Date	P_END_DATETIME	M	TODAY

NHSBT Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Schedule	sched_from	M
End Schedule	sched_to	M
Trip ID	trip_id	M

Non Slot Deliveries

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

Non-Slot Deliveries (MTM)

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M
Schedule	P_SCHED_NUM	M

NR Driver Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Carrier Name	CARRIER_NAME	O
Owning Depot	OWNING_DEPOT	O
To Schedule	SCHED_TO	O
Group Name	GROUP_NAME	O
Customer	CUSTOMER	O
From Schedule	SCHED_FROM	O
Trip ID	TRIP_ID	O

NR Order Conf

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer Ref	P_EXT_REF	M

NR Supplier Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Collection Postcode	POSTCODE	O
Owning Depot	OWNING_DEPOT	O
Trip ID	TRIP_ID	O
To Schedule	SCHED_TO	O
From Schedule	SCHED_FROM	O
Customer	CUSTOMER	O
Carrier Name	CARRIER_NAME	O
Group Name	GROUP_NAME	O

Openfield Drivers Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	TRIP_ID	O
To Schedule	SCHED_TO	O
From Schedule	SCHED_FROM	O
Carrier Name	CARRIER_ID	O
Group Name	GROUP_NAME	O
Customer	CUSTOMER	O
Owning Depot	OWNING_DEPOT	O

Operational Value Detail

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Cost Centre	P_COST_CENTRE	M
Customer	P_CUSTOMER
Customer Group	P_GROUP

Operational Value Summary

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

Order Conf

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
OMS Ref	P_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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Source	P_SOURCE	O			Source	Location Id	Name
Destination	P_DEST	O			Destination	Location Id	Name
Min. DU Variance	P_MIN_VARIANCE	M	STRING
Schedule	P_SCHED_DATE	M
Product Type	P_PROD_TYPE	O

Order Variance Qty by Store

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Product Type	P_PROD_TYPE	O
Schedule	P_SCHED_DATE	M
Min. DU Variance	P_MIN_VARIANCE	M	STRING
Destination	P_DEST	O			Destination	Location Id	Name
Source	P_SOURCE	O			Source	Location Id	Name

Order Variance Qty by Trip

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Product Type	P_PROD_TYPE	O
Source	P_SOURCE	O			Source	Location Id	Name
Destination	P_DEST	O			Destination	Location Id	Name
Schedule	P_SCHED_DATE	M
Min. DU Variance	P_MIN_VARIANCE	M	STRING

Pending Supplier Invoices

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY

PL Pallets Ticket

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	O
Load Location	P_LOAD_LOC	O			Loading Location	Location Id	Name
Owning Depot	P_DEPOT	M			Depot	Location Id	Name
To Date	P_END_DATETIME	M	TODAY
Carrier	P_CARRIER	O
From Date	P_START_DATETIME	M	TODAY

PL Transport Order

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Load Location	P_LOAD_LOC	O			Loading Location	Location Id	Name
Owning Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY
Cost Centre	P_COST_CENTRE	M			Cost Centre	Cost Centre	Cost Centre
To Date	P_END_DATETIME	M	TODAY
Carrier	P_CARRIER	O

PL Trip Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Load Location	P_LOAD_LOC	O			Loading Location	Location Id	Name
Owning Depot	P_DEPOT	M			Depot	Location Id	Name
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Light Trip Min. RPE	P_LT_THRESHOLD	M	STRING	30
Schedule	P_SCHED_NAME	O
Max Deviation Miles	P_EDM_THRESHOLD	M	STRING	80
Short Trip Min. Miles	P_SHORT_TRIP_THRESHOLD	M	STRING	200
Overladen Trip Tol.	P_OVERLADEN_TOLERANCE	M	STRING	0.5

Poland Pallet Label

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Depot	P_DEPOT	M			Depot	Location Id	Name
Schedule	P_SCHED	M

Polarspeed Label

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer Ref	P_EXT_REF	M

Prov Booking Exception Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

Rigel Delivery Note

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip ID	P_TRIP_ID	O
Depot	P_LOCATION	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
From Date	P_START_DATETIME	O	TODAY
Copies	P_COPIES	M		1
To Date	P_END_DATETIME	O	TODAY
Schedule	P_SCHED	O

SCALE Drivers Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	GROUP_NAME	O
To Schedule	SCHED_TO	O
Owning Depot	OWNING_DEPOT	O
Trip ID	TRIP_ID	O
Customer	CUSTOMER	O
Carrier Name	CARRIER_NAME	O
From Schedule	SCHED_FROM	O

Service Self Bill Invoice

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Invoice ID	P_INVOICE_NO	M

Shipments Invoice

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATE	M	TODAY
From Date	P_START_DATE	M	TODAY

Short Trips

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
Max Time	P_MAX_ELAPSED_TIME	M	STRING	360
Carrier	P_CARRIER_ID	M	STRING	ALL
From Date	P_START_DATETIME	M	TODAY

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY
Slot Usage	P_ADVANCES_FLAG	O	STRING

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Slot Variance	P_MODIFIED_FLAG	M	STRING	M

Stapletons Load Sheet

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip	P_TRIP	M	STRING	ALL
Depot	P_DEPOT	M			Depot	Location_id	Name
Schedule	P_SCHED	M

STL Driver Manifest

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Start Date	P_START_DATETIME	M	TODAY
End Date	P_END_DATETIME	M	TODAY
Trip ID (Optional)	P_TRIP_ID	O

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
RDC Return Less %	P_RDC_PCT	M	STRING	50

Supplier Invoice

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
End Date	P_END_DATE	O
Invoice ID	P_INVOICE_NO	O	STRING
Start Date	P_START_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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
"To Date"	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY
Depot	P_DEPOT	M			Depot	Location Id	Name
Carrier	P_CARRIER	O
"Trip ID (Optional)"	P_TRIP_ID	O	STRING

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY

Trailer Shunting

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
Depot	P_DEPOT	M			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY

Trip Sheet (Generic Barcode)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
Trip ID (optional)	P_TRIP_ID	O
To Date	P_END_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location ID	Name
Carrier	P_CARRIER	O

Trip Sheet (Generic Detail)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Owning Depot	P_OWN_DEPOT	M			Depot	Location ID	Name
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
Trip ID (optional)	P_TRIP_ID	O

Trip Sheet (Generic New)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Owning Depot	P_OWN_DEPOT	M			Depot	Location ID	Name
Trip ID (optional)	P_TRIP_ID	O
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Customer	P_CUSTOMER	O

Trip Sheet (Generic)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
Trip ID (optional)	P_TRIP_ID	O
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location ID	Name

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

Trip Sheet BNL

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	O	STRING
Customer	P_CUSTOMER	O
Trip ID	TRIP_ID	O	STRING
Schedule To	SCHED_TO	M
Schedule From	SCHED_FROM	M
Carrier	P_CARRIER	O
Owning Depot	P_OWN_DEPOT	O

Trip Sheet Dunelm

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Trip Id (optional)	P_TRIP_ID	O
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Customer	P_CUSTOMER	O

Trip Sheet Dunelm (Detail)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Owning Depot	P_OWN_DEPOT	O			Depot	Location Id	Name
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
Group Name	P_GROUP_NAME	O
Carrier	P_CARRIER	O
Trip Id (optional)	P_TRIP_ID	O

Trip Sheet Dunelm (New)

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Trip Id (optional)	P_TRIP_ID	O
Owning Depot	P_OWN_DEPOT	O			Depot	Location Id	Name
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O
Customer	P_CUSTOMER	O
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

Trip Sheet TDL

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	P_GROUP_NAME	O
Trip Id (optional)	P_TRIP_ID	O
Owning Depot	P_OWN_DEPOT	M			Depot	Location Id	Name
Carrier	P_CARRIER	O
From Date	P_START_DATETIME	M	TODAY
Customer	P_CUSTOMER	O
To Date	P_END_DATETIME	M	TODAY

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	TODAY
From Date	P_START_DATETIME	M	TODAY

Unplanned Product

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Min Variance Qty	P_VARIANCE_QTY	M	STRING	0
Depot	P_DEPOT	O			Depot	Location Id	Name

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule Date	P_SCHED_DATE	M	TODAY
Depot	P_DEPOT	O			Depot	Location Id	Name
Show Store Detail	P_SHOW_STORES	M	STRING	NO
Overplanned RPE >	P_SHOW_RPE_OVER	M	STRING	0
Underplanned RPE >	P_SHOW_RPE_UNDER	M	STRING	0

Unscheduled Order Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	P_CUSTOMER	M	STRING	ALL
Depot	P_DEPOT	O	STRING		Depot	Location ID	Name
DU Category	P_DU_TYPE	O	STRING
Schedule	P_SCHED	M
Order Status	P_STATUS	M	STRING	UNSCHEDULED
Order By	P_ORDER_BY	M

Vehicle Despatch

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M

Vehicle Utilisation

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Schedule	P_SCHED	M
Cost Centre	P_COST_CENTRE	M