Reports Details: Difference between revisions

From CTMS
m (Categorisation)
(Updated parameters)
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Schedule ||M || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|-
|-
| Group Name ||M || || || || || ||
| Group Name || P_GROUP_NAME || M || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Customer ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|}
|}
[[File:REP-106-BOOKED ORDERS.png|border|800x800px]]
[[File:REP-106-BOOKED ORDERS.png|border|800x800px]]
Line 19: Line 28:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Carrier ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
|}


Line 37: Line 55:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer ||O || || || || || ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| From Schedule || P_FROM_SCHED || M || || || || || ||
|-
|-
| From Schedule ||M || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Group Name ||M || || || || || ||
| Group Name || P_GROUP_NAME || M || || || || || ||
|-
|-
| To Schedule ||M || || || || || ||
| To Schedule || P_TO_SCHED || M || || || || || ||
|}
|}


Line 53: Line 80:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}
[[File:REP-106-DESP-BY-CARRIER.png|border|800x800px]]
[[File:REP-106-DESP-BY-CARRIER.png|border|800x800px]]
Line 68: Line 104:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}
[[File:REP-106-DESP-START-TIME.png|border|800x800px]]
[[File:REP-106-DESP-START-TIME.png|border|800x800px]]
Line 83: Line 128:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Depot ||O || || ||Depot ||Location Id ||Name ||
! Name
|-
! Mand
| End Schedule ||M || || || || || ||
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Schedule ||M || || || || || ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Schedule ||M || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| Carrier ||M || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|}
|}
[[File:REP-106-DRIVERS-RUN-SHEET.png|border|800x800px]]
[[File:REP-106-DRIVERS-RUN-SHEET.png|border|800x800px]]


==10.6 Failed Locations Report==
==10.6 Drivers Run Sheet UKS==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Carrier || P_CARRIER || M || || || || || ||
|}
 
==10.6 Failed Locations Report==
Parameters:
{| class="wikitable"
|+
! 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 || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|}
|}


Line 112: Line 190:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| Start Schedule || P_SCHEDULE_FROM || M || || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| End Schedule || P_SCHEDULE_TO || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Group Name || P_GROUP || O || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Owning Depot || P_OWNING_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Carrier ||O || || || || || ||
| Carrier || P_CARRIER_ID || O || || || || || ||
|}
|}


Line 130: Line 217:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Depot || P_OWNING_DEPOT || O || || || Depot || Location Id || Name ||
|}
|}


Line 140: Line 236:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Schedule ||M || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Group Name ||O || || || || || ||
| Carrier Is Not || P_NOT_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Carrier Is Not ||O || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| End Schedule || P_END_SCHED || M || || || || || ||
|}
|}


Line 158: Line 263:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Load Location ||M || || ||Loading Location ||Location Id ||Name ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Load Location || P_LOAD_LOC || M || || || Loading Location || Location Id || Name ||
|-
|-
| Carrier ||O || || || || || ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
|}
[[File:REP-106-HAULIER-TRIP-SHEET.png|border]]
[[File:REP-106-HAULIER-TRIP-SHEET.png|border]]
Line 175: Line 289:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip Id (optional) ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Loading Start Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Loading Location ||M || || ||Loading Location ||Location Id ||Name ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Loading End Date ||M ||TODAY || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Loading Start Date ||M ||TODAY || || || || ||
| Loading Locaton || P_LOAD_LOC || M || || || Loading Location || Location Id || Name ||
|-
|-
| Customer ||O || || || || || ||
| Loading End Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


Line 195: Line 318:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| End Date ||M ||TODAY || || || || ||
| Owning Depot || P_OWN_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Booked Status ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || Customer || Customer Id || Name ||
|-
|-
| Start Date ||M ||TODAY || || || || ||
| Order Status || P_STATUS || O || STRING || || || || ||
|-
|-
| Region ||O || || || || || ||
| Region || P_REGION || O || || || || || ||
|-
|-
| Order Status ||O ||STRING || || || || ||
| Start Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Customer ||O || || ||Customer ||Customer Id ||Name ||
| End Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Booked Status || P_BOOKED || O || || || || || ||
|}
|}


Line 215: Line 347:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||O || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Start Schedule ||M || || || || || ||
| Customer || P_CUSTOMER || O || || || CUSTOMER || CUSTOMER_ID || CUSTOMER NAME ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Trip Id (optional) ||O || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|-
|-
| Customer ||O || || ||CUSTOMER ||CUSTOMER_ID ||CUSTOMER NAME ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|}
|}


Line 233: Line 374:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Loading Location || P_LOAD_LOC || M || || || Loading Location || Location Id || Name ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Loading Location ||M || || ||Loading Location ||Location Id ||Name ||
| Group Name || P_GROUP || O || || || || || ||
|}
|}


Line 253: Line 403:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Schedule ||M || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Group Name ||M || || || || || ||
| Group Name || P_GROUP_NAME || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|}
|}


Line 267: Line 426:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Order Status ||M ||STRING ||ALL || || || ||
| Order Status || P_ORDER_STATUS || M || STRING || ALL || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


Line 283: Line 451:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Carrier || P_CARRIER || M || || || || || ||
|}
|}


Line 293: Line 470:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||O || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|}
|}


Line 305: Line 491:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Date ||M ||TODAY || || || || ||
| Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|}
|}


Line 317: Line 512:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trailer ID ||O || || || || || ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Trailer ID || P_TRAILER_ID || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


Line 331: Line 535:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Trip Id (optional) ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|}
|}
[[File:REP-106-TRIP-SHEET.png|border|800x800px]]
[[File:REP-106-TRIP-SHEET.png|border|800x800px]]
Line 352: Line 565:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Trip Id (optional) ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


Line 372: Line 594:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Start Schedule ||M || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|}
|}
[[File:REP-106-TRIP-STOPS.png|border|800x800px]]
[[File:REP-106-TRIP-STOPS.png|border|800x800px]]
Line 391: Line 622:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| End Schedule ||M || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| Owning Depot || P_OWN_DEPOT || O || || || || || ||
|-
|-
| Owning Depot ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|}
|}
[[File:REP-106-TRIP-STOPS-DSG.png|border|800x800px]]
[[File:REP-106-TRIP-STOPS-DSG.png|border|800x800px]]
Line 406: Line 646:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Schedule ||M || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| Carrier ||M ||STRING ||ALL || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Carrier || P_CARRIER || M || STRING || ALL || || || ||
|}
|}


Line 418: Line 667:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||M || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Group Name || P_GROUP_NAME || M || || || || || ||
|}
|}


Line 432: Line 690:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| End Sched ||M || || || || || ||
| Group Name || P_GROUP_NAME || M || || || || || ||
|-
|-
| Group Name ||M || || || || || ||
| End Sched || P_END_SCHED || M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Start Sched || P_START_SCHED || M || || || || || ||
|-
|-
| Start Sched ||M || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|}
|}
[[File:REP-106-UNSCHED-ORDS.png|800x800px]]
[[File:REP-106-UNSCHED-ORDS.png|800x800px]]
Line 447: Line 714:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||M || || || || || ||
| Carrier || P_CARRIER || M || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


Line 457: Line 733:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Usage ||M ||STRING ||EXTERNAL || || || ||
| Start Schedule || p_start_sched || M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Usage || p_usage || M || STRING || EXTERNAL || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| Customer || p_customer || M || STRING || ALL || || || ||
|-
|-
| Customer ||M ||STRING ||ALL || || || ||
| End Schedule || p_end_sched || M || || || || || ||
|}
|}


Line 471: Line 756:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Usage ||M ||STRING ||INTERNAL || || || ||
| Usage || p_usage || M || STRING || INTERNAL || || || ||
|-
|-
| Customer ||M ||STRING ||ALL || || || ||
| Customer || p_customer || M || STRING || ALL || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Start Schedule || p_start_sched || M || || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| End Schedule || p_end_sched || M || || || || || ||
|}
|}


Line 485: Line 779:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Group Name ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
|}


Line 507: Line 810:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Min. Volume (cu.m) ||M ||STRING ||0.000005 || || || ||
| Max. Volume (cu.m) || P_UPPER_VOLUME || M || STRING || 0.2 || || || ||
|-
|-
| In the Last ___ Days ||M ||STRING ||30 || || || ||
| Min. Volume (cu.m) || P_LOWER_VOLUME || M || STRING || 0.000005 || || || ||
|-
|-
| Max. Volume (cu.m) ||M ||STRING ||0.2 || || || ||
| In the Last ___ Days || P_DAYS || M || STRING || 30 || || || ||
|}
|}


Line 521: Line 833:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| In the Last ___ Days ||M ||STRING ||30 || || || ||
| Max. Weight (kg) || P_UPPER_WEIGHT || M || STRING || 18 || || || ||
|-
|-
| Max. Weight (kg) ||M ||STRING ||18 || || || ||
| Min. Weight (kg) || P_LOWER_WEIGHT || M || STRING || 0.2 || || || ||
|-
|-
| Min. Weight (kg) ||M ||STRING ||0.2 || || || ||
| In the Last ___ Days || P_DAYS || M || STRING || 30 || || || ||
|}
|}


Line 536: Line 857:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Invoice No ||M || || || || || ||
| Credit Acc || P_CREDIT_ACC || M || || || || || ||
|-
|-
| Credit Acc ||M || || || || || ||
| Debit Acc || P_ACCOUNT_ID || M || || || || || ||
|-
|-
| Debit Acc ||M || || || || || ||
| Invoice No || P_INVOICE_NO || M || || || || || ||
|}
|}


Line 548: Line 878:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Sched Name ||M || || || || || ||
| Sched Name || P_SCHED_NAME || M || || || || || ||
|}
|}


Line 556: Line 895:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Dwell From ||O ||STRING || || || || ||
| Dwell From || p_dwell_from || O || STRING || || || || ||
|-
|-
| Active ||O ||STRING || || || || ||
| Active || p_active || O || STRING || || || || ||
|-
|-
| Status ||O ||STRING || || || || ||
| Current Location || p_current_location || O || STRING || || || || ||
|-
|-
| Asset Type ||O ||STRING || || || || ||
| Dwell To || p_dwell_to || O || STRING || || || || ||
|-
|-
| Current Location ||O ||STRING || || || || ||
| Status || p_status || O || STRING || || || || ||
|-
|-
| Dwell To ||O ||STRING || || || || ||
| Asset Type || p_asset_type || O || STRING || || || || ||
|}
|}


==BG  Load Manifest==
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer ||O || || || || || ||
| Carrier || P_HAULIER || O || || || || || ||
|-
|-
| Trip Id (optional) ||O || || || || || ||
| Schedule || P_SCHED_NAME || M || || || || || ||
|-
|}
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
 
|-
==Bathstore Return To Base==
| Carrier ||O || || || || || ||
Parameters:
|-
{| class="wikitable"
| Loading Locaton ||M || || ||Loading Location ||Location Id ||Name ||
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Loading End Date ||M ||TODAY || || || || ||
| From Schedule || P_SCHED_NAME || M || || || || || ||
|-
|-
| Loading Start Date ||M ||TODAY || || || || ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|}
|}


==BG HC Trip Sheet==
==Bathstore Trip Sheet/Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Cost Centre || COST_CENTRE || O || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Trip Id (optional) || trip_id || O || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Carrier (optional) || carrier || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Schedule || sched_from || M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| To Schedule || sched_to || M || || || || || ||
|-
|}
| Group Name ||O || || || || || ||
[[File:REP-BATHSTORE-TRIP-SHEET.png|800x800px]]
|-
| Carrier ||O || || || || || ||
|}
[[File:REP-BG-HC-TRIP-SHEET.png|border|800x800px]]


==BG Loading Schedule Summary==
==Baxter Delivery Note==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M ||TODAY || || || || ||
| Depot || P_LOCATION || O || || || Depot || Location Id || Name ||
|-
|-
| Loading Location ||M || || ||Loading Location ||Location Id ||Name ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Copies || P_COPIES || M || || 1 || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || O || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| From Date || P_START_DATETIME || O || TODAY || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Schedule || P_SCHED || O || || || || || ||
|}
|}
[[File:REP-BAXTER-DELNOTE1.png|774x774px]]


==BG Trip Sheet==
==Baxter Load Summary Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer ||O || || || || || ||
| End Schedule || P_SCHED_TO || M || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Cost Centre || P_COST_CENTRE || O || STRING || ALL || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Start Schedule || P_SCHED_FROM || M || || || || || ||
|}
 
==Baxter Loading Schedule==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| Depart End || P_END_DATETIME || O || TODAY || || || || ||
|-
|-
| Trip Id (optional) ||O || || || || || ||
| Unloaded At || P_LOCATION || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Start Schedule || P_FROM_SCHED || M || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| End Schedule || P_TO_SCHED || M || || || || || ||
|-
| Cost Centre || P_COST_CENTRE || O || || BAX || || || ||
|-
| Depot || P_DEPOT || O || || || || || ||
|-
| Depart Start || P_START_DATETIME || O || TODAY || || || || ||
|}
|}
[[File:REP-BG-TRIP-SHEET.png|border|800x800px]]


==BNL Delivery Report==
==BG  Load Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Trip ||M || || || || || ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|}
 
==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:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Schedule ||M || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Loading Locaton || P_LOAD_LOC || M || || || Loading Location || Location Id || Name ||
|}
 
==Bathstore Return To Base==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| From Schedule ||M || || || || || ||
| Loading End Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip Id (optional) ||O || || || || || ||
| Loading Start Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


==Bathstore Trip Sheet/Manifest==
==BG HC Trip Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Schedule ||M || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| To Schedule ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip Id (optional) ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Cost Centre ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Carrier (optional) ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name ||
|-
| Carrier || P_CARRIER || O || || || || || ||
|-
| Group Name || P_GROUP_NAME || O || || || || || ||
|}
|}
[[File:REP-BATHSTORE-TRIP-SHEET.png|800x800px]]
[[File:REP-BG-HC-TRIP-SHEET.png|border|800x800px]]


==Baxter Delivery Note==
==BG Loading Schedule Summary==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Copies ||M || ||1 || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Group Name || P_GROUP || O || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||O ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| To Date ||O ||TODAY || || || || ||
| Loading Location || P_LOAD_LOC || M || || || Loading Location || Location Id || Name ||
|-
|-
| Schedule ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|}
|}
[[File:REP-BAXTER-DELNOTE1.png|774x774px]]


==Baxter Load Summary Report==
==BG Trip Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| Cost Centre ||O ||STRING ||ALL || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}
[[File:REP-BG-TRIP-SHEET.png|border|800x800px]]


==Baxter Loading Schedule==
==BNL Delivery Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Depot ||O || || || || || ||
! Name
|-
! Mand
| Unloaded At ||O || || || || || ||
! Def Type
|-
! Def Val
| Start Schedule ||M || || || || || ||
! LOV
|-
! Column 1
| Depart End ||O ||TODAY || || || || ||
! Column 2
|-
! Column 3
| Cost Centre ||O || ||BAX || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Schedule || p_sched || M || || || || || ||
|-
|-
| Depart Start ||O ||TODAY || || || || ||
| Trip || p_trip || M || || || || || ||
|}
|}


Line 761: Line 1,208:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


Line 769: Line 1,225:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Owning Depot ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| From Schedule || P_START_SCHED || O || || || || || ||
|-
|-
| To Schedule ||O || || || || || ||
| To Schedule || P_END_SCHED || O || || || || || ||
|-
|-
| From Schedule ||O || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || O || || || || || ||
|}
|}


Line 785: Line 1,250:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Changed Since ||O ||TODAY || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Include Order No ||M ||STRING ||N || || || ||
| Include Order No || P_INCLUDE_ORD_NO || M || STRING || N || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier ||M ||STRING ||ALL || || || ||
| Changed Since || P_CHANGED_DATE || O || TODAY || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Carrier || P_VALUE_LIST1 || M || STRING || ALL || || || ||
|}
|}


==CMR==
==Carrier Invoice==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Debit Acc || P_ACCOUNT_ID || M || || || || || ||
|-
|-
| Trip id ||O ||STRING ||ALL || || || ||
| Credit Acc || P_CREDIT_ACC || M || || || || || ||
|-
|-
| Carrier ||O ||STRING ||ALL || || || ||
| Invoice No || P_INVOICE_NO || M || || || || || ||
|}
|}


==CMR BNL Report==
==Carrier Manifest (DHL Express)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| Trip ||M || || || || || ||
| End Date || P_END_DATE || O || TODAY || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Start Date || P_START_DATE || O || TODAY || || || || ||
|}
|}


==CN Booked Orders==
==Carrier Manifest (Movianto)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Start Schedule ||M || || || || || ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| End Schedule ||M || || || || || ||
| Start Date || P_START_DATETIME || O || TODAY || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| End Date || P_END_DATETIME || O || TODAY || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Group Name ||M || || || || || ||
| Carrier ID || P_CARRIER_ID || O || || || || || ||
|}
|}


==CN Collection Note==
==Carrier Manifest (Standard1)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Trip ID (optional) ||O || || || || || ||
! Name
|-
! Mand
| Depot ||O || || ||Depot ||Location Id ||Name ||
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| End Date || P_END_DATETIME || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Start Date || P_START_DATETIME || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Carrier ID || P_CARRIER_ID || O || || || || || ||
|}
|}


==CN Daily Collections==
==Carrier Manifest (Standard2)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| End Date || P_END_DATE || M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Carrier ID || P_CARRIER_ID || O || || || || || ||
|-
| To Schedule ||M || || || || || ||
|-
|-
| From Schedule ||M || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Group Name ||M || || || || || ||
| Start Date || P_START_DATE || M || || || || || ||
|}
|}


==CN Despatch Report By Carrier==
==Carrier Manifest (UKMail)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Start Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| End Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Carrier ID || P_CARRIER_ID || M || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|}
|}


==CN Despatch Report By Start Time==
==Carrier Manifest (Yodel)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| Start Date || P_START_DATE || O || TODAY || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Carrier ID || P_CARRIER_ID || O || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| End Date || P_END_DATE || O || TODAY || || || || ||
|}
|}


==CN Failed Locations Report==
==Carrier Work Confirmation==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| From Schedule || P_SCHED_FROM || M || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| To Schedule || P_SCHED_TO || M || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
|}


==CN Front Desk Sheet==
==CMR==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Carrier ||O || || || || || ||
! Name
|-
! Mand
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
! Def Type
|-
! Def Val
| Customer ||O || || || || || ||
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| Trip id || P_TRIP || O || STRING || ALL || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Carrier || P_CARRIER || O || STRING || ALL || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


==CN Haulier Confirmation==
==CMR BNL Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier Is Not ||O || || || || || ||
| Trip || p_trip || M || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Schedule || p_sched || M || || || || || ||
|-
|}
| Group Name ||O || || || || || ||
 
|-
==CMR BNL Report1==
| End Schedule ||M || || || || || ||
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Schedule ||M || || || || || ||
| Schedule || p_sched || M || || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Trip || p_trip || M || || || || || ||
|}
|}


Line 988: Line 1,553:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Loading End Date ||M ||TODAY || || || || ||
| Loading Location || P_LOAD_LOC || O || || || Loading Location || Location Id || Name ||
|-
|-
| Loading Start Date ||M ||TODAY || || || || ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Loading Start Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Loading Location ||O || || ||Loading Location ||Location Id ||Name ||
| Loading End Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


==CN Load Planning==
==CN Order Status==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Order Status || P_STATUS || O || || || || || ||
|-
|-
| Customer ||O || || ||Customer ||Customer Id ||Name ||
| Booked Status || P_BOOKED || O || || || || || ||
|-
|-
| Region ||O || || || || || ||
| Region || P_Region || O || || || || || ||
|-
|-
| Booked Status ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Order Status ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || Customer || Customer Id || Name ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Sched To || P_SCHED_TO || M || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Sched From || P_SCHED_FROM || M || || || || || ||
|}
|}


==CN Loading Schedule==
==CN Trip Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID (optional) ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Start Schedule ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|}
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
[[File:REP-CN-TRIP-SHEET.png|border|800x800px]]
 
==CN Trip Stops==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Customer ||O || || || || || ||
| Start Schedule ||M || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Carrier ||O || || || || || ||
|-
| Customer ||O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Group Name ||O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| End Schedule ||M || || || || || ||
|-
|-
| Loading Location ||M || || ||Loading Location ||Location Id ||Name ||
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|-
| From Date ||M ||TODAY || || || || ||
|}
|}
[[File:REP-CN-TRIP-STOPS.png|border|800x800px]]


==CN Missing Load Ref Report==
==CN Unbooked Orders==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Start Schedule ||M || || || || || ||
| End Schedule ||M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Customer ||O || || || || || ||
Line 1,068: Line 1,666:
| Group Name ||M || || || || || ||
| Group Name ||M || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Start Schedule ||M || || || || || ||
|}
|}


==CN Order Status==
==CN Unscheduled Orders==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Order Status ||O || || || || || ||
| Customer ||O || || || || || ||
|-
|-
| Booked Status ||O || || || || || ||
| End Schedule ||M || || || || || ||
|-
|-
| Region ||O || || || || || ||
| Start Schedule ||M || || || || || ||
|-
|-
| Sched To ||M || || || || || ||
| Group Name ||M || || || || || ||
|-
| Customer ||O || || ||Customer ||Customer Id ||Name ||
|-
| Sched From ||M || || || || || ||
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
|}
|}


==CN Pick Control Sheet==
==CN Warehouse Loading Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| From Date ||M ||TODAY || || || || ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Start Schedule || P_START_SCHED || M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|}
 
==CN Sub-Contractor Summary Sheet==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Schedule ||M || || || || || ||
| End Schedule || P_END_SCHED || M || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Customer || P_CUSTOMER || O || || || Customer || CUSTOMER_ID || CUSTOMER_NAME ||
|-
|-
| Carrier ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|}
|}


==CN Traffic Sheet==
==Collections Deviation Distance==
This report display trip details for depot and collection location.
 
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Date ||M ||TODAY || || || || ||
| Location (Optional) || P_COL_LOC_ID || O || || || Location (Optional) || Location Id || Name ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|}
|}


==CN Trailer Tracking==
==Collections Excess Distance==
This report prints trip details for those trips which have exceeded the specified distance for depot specified.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M ||TODAY || || || || ||
| Minimum Miles || P_MIN_DIST_STORES || M || STRING || 0 || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Trailer ID ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


==CN Trip Sheet==
==Combined Documents BNL==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M ||TODAY || || || || ||
| Trip || p_trip || M || || || || || ||
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Schedule || p_sched || M || || || || || ||
|-
|}
| To Date ||M ||TODAY || || || || ||
[[File:REP-COMBINED-DOCS-BNL.png|border|800x800px]]
|-
 
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
[[File:REP-COMBINED-DOCS-BNL2.png|border|600x600px]]
|-
 
| Customer ||O || || || || || ||
[[File:REP-COMBINED-DOCS-BNL3.png|border|755x755px]]
 
==Control Tower Traffic Plan==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||O || || || || || ||
| Schedule || scheduleDate || M || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Owning Depot || depotSelect || O || || || Depot || Location ID || Name ||
|}
|}
[[File:REP-CN-TRIP-SHEET.png|border|800x800px]]


==CN Trip Stops==
==Customer Delivery Note==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Schedule || P_SCHED || O || || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| From Date || P_START_DATETIME || O || TODAY || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| To Date || P_END_DATETIME || O || TODAY || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Copies || P_COPIES || M || || 1 || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| Depot || P_LOCATION || O || || || Depot || Location Id || Name ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|}
|}
[[File:REP-CN-TRIP-STOPS.png|border|800x800px]]


==CN Unbooked Orders==
==Customer Dunelm==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| End Schedule ||M || || || || || ||
| Invoice No || P_INVOICE_NO || M || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Credit Acc || P_CREDIT_ACC || M || || || || || ||
|-
| Group Name ||M || || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| Debit Acc || P_ACCOUNT_ID || M || || || || || ||
|}
|}


==CN Unscheduled Orders==
==Customer Invoice==
This report is called from the Invoices form, and produces invoices for the specified customer
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Customer ||O || || || || || ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| End Schedule ||M || || || || || ||
| Invoice No || P_INVOICE_NO || M || || || || || ||
|-
|-
| Start Schedule ||M || || || || || ||
| Credit Acc || P_CREDIT_ACC || M || || || || || ||
|-
|-
| Group Name ||M || || || || || ||
| Debit Acc || P_ACCOUNT_ID || M || || || || || ||
|}
|}


==CN Warehouse Loading Report==
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
! Name
|-
! Mand
| Trip ID (optional) ||O || || || || || ||
! Def Type
|-
! Def Val
| Carrier ||O || || || || || ||
! LOV
|-
! Column 1
| End Schedule ||M || || || || || ||
! Column 2
|-
! Column 3
| Start Schedule ||M || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


==Carrier Invoice==
==Daily Store ASN==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Credit Acc ||M || || || || || ||
| Store || P_STORE || O || || || Store || Location ID || Name ||
|-
|-
| Debit Acc ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Invoice No ||M || || || || || ||
| Detail/Summary || P_DETAIL || M || || || || || ||
|-
|}
| Credit Acc ||M || || || || || ||
 
|-
==Delivery Docs==
| Debit Acc ||M || || || || || ||
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Invoice No ||M || || || || || ||
| Trip ID || P_TRIP || M || STRING || ALL || || || ||
|}
|}


==Carrier Manifest (DHL Express)==
==Delivery Note HCR==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| End Date ||O ||TODAY || || || || ||
| Schedule || P_SCHED || O || || || || || ||
|-
|-
| Carrier ID ||O || || || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| From Date || P_START_DATETIME || O || TODAY || || || || ||
|-
|-
| Start Date ||O ||TODAY || || || || ||
| Copies || P_COPIES || M || || 1 || || || ||
|}
|}
[[File:REP-DELNOTE-HCR.png|788x788px]]


==Carrier Manifest (Movianto)==
==DG TEST==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Carrier ID ||O || || || || || ||
! Name
|-
! Mand
| Trip ID ||O || || || || || ||
! Def Type
|-
! Def Val
| End Date ||O ||TODAY || || || || ||
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Date ||O ||TODAY || || || || ||
| || P_SCHED || M || || || || || ||
|}
|}


==Carrier Manifest (Standard1)==
==Distribution==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 ||
|-
|-
| Start Date ||M || || || || || ||
| From Date || P_FROM_DATE || M || || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Details Section || P_CUST_DTLS || M || || || || || ||
|-
|-
| Carrier ID ||O || || || || || ||
| Zone Section || P_CUST_ZONE || M || || || || || ||
|-
|-
| End Date ||M || || || || || ||
| Zone || P_DEPOT || M || || || Zone || ZONE_NAME || ZONE_ID ||
|}
|}


==Carrier Manifest (Standard2)==
==Dng Test==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Start Date ||M || || || || || ||
! Name
|-
! Mand
| Carrier ID ||O || || || || || ||
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID ||O || || || || || ||
| Depot || P_DEPOT || O || || || Dng || Location Id || Name ||
|-
|-
| End Date ||M || || || || || ||
| Location Type || P_LOC_TYPE || M || || || || || ||
|}
|}


==Carrier Manifest (UKMail)==
==Dom Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID ||O || || || || || ||
| Trip ID || TRIP_ID || M || || || || || ||
|-
|-
| End Date ||M ||TODAY || || || || ||
| Schedule || SCHED_NAME || O || || || || || ||
|-
|}
| Start Date ||M ||TODAY || || || || ||
 
==Domestic Order Confirmation==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ID ||M || || || || || ||
| OMS Ref || P_OMS_REF || M || || || || || ||
|}
|}


==Carrier Manifest (Yodel)==
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ID ||O || || || || || ||
| Carrier || P_HAULIER || O || || || || || ||
|-
|-
| End Date ||O ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Start Date ||O ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|}
|}


==Carrier Work Confirmation==
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Schedule ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| To Schedule ||M || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|}
|}


==Collections Deviation Distance==
==Driver Manifest==
This report display trip details for depot and collection location.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| Location (Optional) ||O || || ||Location (Optional) ||Location Id ||Name ||
| Group Name || GROUP_NAME || O || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Carrier ID || CARRIER_ID || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Schedule || SCHED_FROM || O || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Trip ID || TRIP_ID || O || || || || || ||
|}
|}


==Collections Excess Distance==
==Driver Run Sheet==
This report prints trip details for those trips which have exceeded the specified distance for depot specified.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Minimum Miles ||M ||STRING ||0 || || || ||
| Schedule || scheduleDate || M || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Owning Depot || depotSelect || O || || || Depot || Location ID || Name ||
|-
|}
| From Date ||M ||TODAY || || || || ||
[[File:REP-DRIVER-RUN-SHEET.png|800x800px]]
 
==Dunelm Coll Manifest Recon==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Customer || P_CUSTOMER || O || || || || || ||
|-
| To Schedule || P_COLLECTION_TO || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Schedule || P_COLLECTION_FROM || O || || || || || ||
|}
|}


==Combined Documents BNL==
==Dunelm Collection Arrivals==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Trip ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}
[[File:REP-COMBINED-DOCS-BNL.png|border|800x800px]]
[[File:REP-COMBINED-DOCS-BNL2.png|border|600x600px]]
[[File:REP-COMBINED-DOCS-BNL3.png|border|755x755px]]


==Control Tower Traffic Plan==
==Dunelm Daily Store==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location ID ||Name ||
| Summary or Detail || P_DETAIL || M || || || || || ||
|-
|-
| || || || || || || ||
| Store || P_STORE || M || || || || || ||
|}
|}


==Customer Delivery Note==
==Dunelm PO Reconciliation==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| To Date ||O ||TODAY || || || || ||
! Name
|-
! Mand
| Copies ||M || ||1 || || || ||
! Def Type
|-
! Def Val
| From Date ||O ||TODAY || || || || ||
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID ||O || || || || || ||
| Delivery Date || P_DELIVERY || O || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Store || P_STORE || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| From PO || P_PO_FROM || O || || || || || ||
|-
|-
| Schedule ||O || || || || || ||
| To PO || P_PO_TO || O || || || || || ||
|}
|}


==Customer Dunelm==
==Dunelm Unloading Variance==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Debit Acc ||M || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Invoice No ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| Credit Acc ||M || || || || || ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|}
|}


==Customer Invoice==
==Dunelm Vehicle Despatch==
This report is called from the Invoices form, and produces invoices for the specified customer
Parameters:
{| class="wikitable"
|+
! 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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Before/After Time || P_BEFORE_AFTER || M || STRING || BEFORE || || || ||
|-
|-
| Debit Acc ||M || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Credit Acc ||M || || || || || ||
| Arrive Time || P_ARRIVE_TIME || M || STRING || 07:30 || || || ||
|-
|-
| Invoice No ||M || || || || || ||
| Earliest Delivery || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Debit Acc ||M || || || || || ||
| Product Type || P_PROD_TYPE || M || || || || || ||
|-
|-
| Credit Acc ||M || || || || || ||
| Latest Delivery || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Invoice No ||M || || || || || ||
| Min Du Qty || P_MIN_QTY || M || STRING || 0 || || || ||
|}
|}


==Daily KPI by Schedule==
==Early/Late Deliveries (MTM)==
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
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Before/After Time || P_BEFORE_AFTER || M || STRING || BEFORE || || || ||
|}
|}


==Daily Store ASN==
==Excess Waiting Time==
This report display trips which have a waiting time greater than that specified for a specified carrier
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Carrier || P_CARRIER_ID || O || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Detail/Summary ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Store ||O || || ||Store ||Location ID ||Name ||
| Min Waiting Time || P_MIN_ELAPSED_TIME || M || STRING || 60 || || || ||
|}
|}


==Delivery Docs==
==Generic Portal Label==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID ||M ||STRING ||ALL || || || ||
| OMS Ref || P_OMS || M || || || || || ||
|}
|}


==Delivery Note HCR==
==Grid Closure==
This report shows what products have been picked out side of Grid Closure (POR)
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Product Type || P_PROD_TYPE || M || || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Schedule || P_SCHED_NAME || M || || || || || ||
|-
|-
| Copies ||M || ||1 || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| To Date ||O ||TODAY || || || || ||
| Grid Closure Time || P_GRID_CLOSURE_TIME || M || STRING || 01:15 || || || ||
|}
 
==Haulier Confirmation==
This report displays carrier information along with trip details
 
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||O ||TODAY || || || || ||
| "Trip ID<br>(Optional)" || P_TRIP_ID || O || STRING || || || || ||
|-
|-
| Schedule ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}
[[File:REP-DELNOTE-HCR.png|788x788px]]


==Delivery Note HCR1==
==Haulier Invoice==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||O ||TODAY || || || || ||
| Invoice ID || P_INVOICE_NO || O || STRING || || || || ||
|}
 
==Haulier Performance==
This report display the performance of each haulier for a specific period of time
 
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||O ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
 
==HC Booking In Form==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Copies ||M || ||1 || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Delivery Location || P_DEL_LOCATION || O || || || || || ||
|-
|-
| Schedule ||O || || || || || ||
| Schedule || P_SCHED_NAME || M || || || || || ||
|}
|}


==Distribution==
==HC Haulier Trip Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| To Date ||M || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Details Section ||M || || || || || ||
| Load Location || P_LOAD_LOC || O || || || Loading Location || Location Id || Name ||
|-
|-
| Zone Section ||M || || || || || ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| Customer Section ||M || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Zone ||M || || ||Zone ||ZONE_ID ||ZONE_ID ||
| Carrier || P_CARRIER || O || || || || || ||
|-
| Customer ||M || || ||CUSTOMER ||CUSTOMER_NAME ||CUSTOMER_ID ||
|}
|}
[[File:REP-HC-HAULIER-TRIP-SHEET.png|800x800px]]


==Dom Manifest==
==HC Load Summary Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || ||
|-
|-
| Trip ID ||M || || || || || ||
| Outbase Depot || P_OUTBASE || M || STRING || ALL || || || ||
|-
|-
| Schedule ||O || || || || || ||
| Sched End || P_SCHED_TO || M || || || || || ||
|}
|}


==Domestic Order ==
==HC Loading Schedule==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || ||
|-
|-
| OMS Ref ||M || || || || || ||
| Changed Since || P_CHANGED_DATETIME || O || TODAY || || || || ||
|}
|}


==Driver Days==
==HC Marshalling Exception Report==
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Customer || P_CUSTOMER || M || STRING || ALL || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Depot || P_DEPOT || M || STRING || || Depot || Location Id || Name ||
|}
|}


==Driver Itineraries==
==HC Shunt Sheet==
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Load Location || P_LOAD_LOC || O || || || Loading Location || Location Id || Name ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Owning Depot || P_DEPOT || O || || || Depot || Location Id || Name ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
|-
| Schedule || P_SCHED || M || || || || || ||
|-
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|}
[[File:REP-HC-SHUNT-SHEET.png|800x800px]]


==Driver Manifest==
==HC Trip Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Schedule ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Trip ID ||O || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| From Schedule ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ID ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}
[[File:REP HC TRIP SHEET.png|800x800px]]


==Driver Run Sheet==
==HC Van Delivery Note==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || ||
|-
|-
| Schedule ||M || || || || || ||
| To Date || P_END_DATETIME || O || TODAY || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location ID ||Name ||
| From Date || P_START_DATETIME || O || TODAY || || || || ||
|}
|}
[[File:REP-DRIVER-RUN-SHEET.png|800x800px]]
[[File:REP-HC-VAN-DELNOTE.png|border]]


==Dunelm Coll Manifest Recon==
==HCR Delivery Note==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Copies || P_COPIES || O || || 1 || || || ||
|-
|-
| To Schedule ||O || || || || || ||
| Schedule || P_SCHED || O || || || || || ||
|-
|-
| From Schedule ||O || || || || || ||
| Depot || P_LOCATION || O || || || Depot || Location Id || Name ||
|}
|}


==Dunelm Collection Arrivals==
==HCR Loading Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| 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 || || || || || ||
|}
|}
[[File:REP-HCR-LOADING-SHEET.png|800x800px]]
==Inbound Schedule==
This report shows all the trips scheduled to arrive at depots.


==Dunelm PO Reconciliation==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From PO ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Store ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| To PO ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Delivery Date ||O || || || || || ||
| Trip Status || P_VALUE_LIST1 || M || STRING || ALL || || || ||
|}
|}


==Dunelm Unloading Variance==
==ISC Road Ops Trip Control Form==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Euro Exchange Rate || P_EX_RATE || M || STRING || 1 || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Trip Ref || P_TRIP_REF || M || || || || || ||
|}
 
==Item Labels (DOM)==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip Id (optional) ||O || || || || || ||
| Trip ID || P_TRIP_ID || M || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location_Id ||Name ||
| Collection Location || P_LOCATION_ID || O || || || Collection Location || Location || Location ||
|}
 
==Item Labels by Schedule (DOM)==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Supplier || P_CUST || O || || || || || ||
 
|-
|-
| || || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


==Early/Late Deliveries==
==Job Details==
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Product Type ||M || || || || || ||
| OMS Ref To || i_oms_to || O || || || || || ||
|-
|-
| Min Du Qty ||M ||STRING ||0 || || || ||
| Date to || i_date_to || M || || || || || ||
|-
|-
| Arrive Time ||M ||STRING ||07:30 || || || ||
| OMS Ref From || i_oms_from || O || || || || || ||
|-
|-
| Before/After Time ||M ||STRING ||BEFORE || || || ||
| Customer || i_customer || O || || || || || ||
|-
|-
| Latest Delivery ||M ||TODAY || || || || ||
| Date from || i_date_from || M || || || || || ||
|}
 
==JP Dummy==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Earliest Delivery ||M ||TODAY || || || || ||
| Date From || P_START_DATETIME || M || DATETIME || FIRST:25:12 || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Date To || P_END_DATETIME || M || DATETIME || LAST || || || ||
|}
|}


==Early/Late Deliveries (MTM)==
==KPI By Lane==
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.
This report displays various KPI’s for a specified period of time


Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Separate Pages || P_SEPARATE_PAGES || M || STRING || N || || || ||
|-
|-
| Before/After Time ||M ||STRING ||BEFORE || || || ||
| Customer Group || P_CUST_GROUP || O || || || || || ||
|-
|-
| Product Type ||M ||STRING ||AMBIENT || || || ||
| Grouping || P_GROUP_BY || M || STRING || CUST_GROUP || || || ||
|-
|-
| Depot ||M || || || || || ||
| Show Detail || P_SHOW_DETAIL || M || STRING || Y || || || ||
|-
|-
| Arrive Time ||M ||STRING ||07:30 || || || ||
| End Date || P_TO_DATETIME || M || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Start Date || P_FROM_DATETIME || M || || || || || ||
|}
|}


==Excess Waiting Time==
==KPI Summary==
This report display trips which have a waiting time greater than that specified for a specified carrier
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Min Waiting Time ||M ||STRING ||60 || || || ||
| Schedule || P_SCHED_NAME || M || STRING || || || || ||
|-
|}
| To Date ||M ||TODAY || || || || ||
 
|-
==LFS Despatch Note==
| From Date ||M ||TODAY || || || || ||
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||O || || || || || ||
| Trip id || P_TRIP || M || || || || || ||
|}
|}


==Generic Portal Label==
==LFS Label==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| OMS Ref ||M || || || || || ||
| OMS Ref || P_OMS || M || || || || || ||
|}
|}


==Grid Closure==
==LFS Label Multi==
This report shows what products have been picked out side of Grid Closure (POR)
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Source Ref || P_SOURCE_REF || M || || || || || ||
|-
|}
| Depot ||M || || ||Depot ||Location Id ||Name ||
 
|-
==LFS Label Sched==
| Grid Closure Time ||M ||STRING ||01:15 || || || ||
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Product Type ||M || || || || || ||
| OMS Ref || p_oms || M || || || || || ||
|}
|}


==HC Booking In Form==
==LFS Pallet Label==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Schedule ||M || || || || || ||
! Name
|-
! Mand
| Group Name ||O || || || || || ||
! Def Type
|-
! Def Val
| Customer ||O || || || || || ||
! LOV
|-
! Column 1
| Delivery Location ||O || || || || || ||
! Column 2
|-
! Column 3
| Schedule ||M || || || || || ||
|-
| Group Name ||O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| Pallet ID || P_PALLET_ID || M || || || || || ||
|-
|-
| Delivery Location ||O || || || || || ||
| Depot || P_DEPOT_ID || O || || || Depot || Location ID || Name ||
|}
|}


==HC Delivery Note==
==LFS Trip Sheet POD POC==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Trip ID ||O || || || || || ||
! Name
|-
! Mand
| Depot ||O || || ||Depot ||Location Id ||Name ||
! Def Type
|-
! Def Val
| Carrier ||O || || || || || ||
! LOV
|-
! Column 1
| Schedule ||O || || || || || ||
! Column 2
|-
! Column 3
| Copies ||O || ||1 || || || ||
|-
|-
| To Date ||O ||TODAY || || || || ||
| Trip Id || P_TRIP_ID || M || || || || || ||
|-
|-
| From Date ||O ||TODAY || || || || ||
| Sched Name || P_SCHED_NAME || M || || || || || ||
|}
|}


==HC Haulier Trip Sheet==
==Loading List==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID (optional) ||O || || || || || ||
| 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:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Schedule ||M || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Carrier ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| Changed Since || P_CHANGED_DATETIME || O || TODAY || || || || ||
|-
|-
| Load Location ||O || || ||Loading Location ||Location Id ||Name ||
| Include Order No || P_INCLUDE_ORD_NO || M || STRING || N || || || ||
|-
|-
| Group Name ||O || || || || || ||
| 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:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Schedule ||M || || || || || ||
| Load Type || P_VALUE_LIST2 || M || STRING || ALL || || || ||
|-
|-
| Trip ID (optional) ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Load Location ||O || || ||Loading Location ||Location Id ||Name ||
| Trip Status || P_VALUE_LIST1 || M || STRING || ALL || || || ||
|}
|}
[[File:REP-HC-HAULIER-TRIP-SHEET.png|800x800px]]


==HC Load Summary Report==
==Low Vehicle Fill==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Sched End ||M || || || || || ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Group Name ||M ||STRING ||ALL || || || ||
| Min RPE Qty || P_MIN_RPE || M || STRING || 40 || || || ||
|-
|-
| Sched Start ||M || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name ||
|-
|-
| Outbase Depot ||M ||STRING ||ALL || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier ||M ||STRING ||ALL || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


==HC Loading Schedule==
==MDD Code 03 Exception Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
 
==Moran Trip Sheet==
Parameters:
{| class="wikitable"
|+
! 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 || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Changed Since ||O ||TODAY || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Include Order No ||M ||STRING ||N || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier ||M ||STRING ||ALL || || || ||
| Owning Depot || || || || || || || || ||
|}
|}


==HC Marshalling Exception Report==
==MS RDC Intake Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Depot ||M ||STRING || ||Depot ||Location Id ||Name ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer ||M ||STRING ||ALL || || || ||
| Date From || P_START_DATETIME || M || DATETIME || YESTERDAY:20:00 || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| RDC Location || P_RDC_LOC || M || STRING || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Date To || P_END_DATETIME || M || DATETIME || TODAY:19:59 || || ||
|}
|}


==HC Shunt Sheet==
==MS Slot Utilisation==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Load Location ||O || || ||Loading Location ||Location Id ||Name ||
| % Fill || P_FILL || O || STRING || 100 || || ||
|-
|-
| Owning Depot ||O || || ||Depot ||Location Id ||Name ||
| DU Qty || P_DU_QTY || O || STRING || 999999 || || ||
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Location Type || P_STORE_TYPE || O || STRING || || Location Types || Location Type ||
|-
|-
| Carrier ||O || || || || || ||
| Date || P_SCHED_DATE || M || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Depot || P_DEPOT || M || STRING || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Slot Type || P_SLOT_TYPE || M || STRING || || || || ||
|}
|}
[[File:REP-HC-SHUNT-SHEET.png|800x800px]]


==HC Trip Sheet==
==Multi Drops Excess Distance==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name
|-
|-
| Customer ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||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:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Max Time || P_MAX_ELAPSED_TIME || M || STRING || 60 || || || ||
|-
|-
| Group Name ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}
[[File:REP HC TRIP SHEET.png|800x800px]]


==HC Van Delivery Note==
==NHSBT Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||O ||TODAY || || || || ||
| Start Schedule || sched_from || M || || || || || ||
|-
|-
| To Date ||O ||TODAY || || || || ||
| End Schedule || sched_to || M || || || || || ||
|-
|-
| Copies ||O || ||1 || || || ||
| Trip ID || trip_id || M || || || || || ||
|-
|}
| Schedule ||O || || || || || ||
[[File:REP-NHSBT-MANIFEST.png|border|800x800px]]
 
[[File:REP-NHSBT-MANIFEST-2.png|border|800x800px]]
 
==Non Slot Deliveries==
This shows all the deliveries to be delivered outside of a locations slot.
 
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name
|-
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}
[[File:REP-HC-VAN-DELNOTE.png|border]]


==HCR Loading Sheet==
==Non-Slot Deliveries (MTM)==
This shows all the deliveries to be delivered outside of a locations slot.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Owning Depot ||O || || ||Depot ||Loading Location ||Name ||
| Depot || P_DEPOT || M || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Schedule || P_SCHED_NUM || M || || || || || ||
|}
 
==NR Driver Manifest==
Parameters:
{| class="wikitable"
|+
! 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 || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Group Name || GROUP_NAME || O || || || || || ||
|-
|-
| Trip ID (optional) ||O || || || || || ||
| Customer || CUSTOMER || O || || || || || ||
|-
|-
| Load Location ||O || || ||Loading Location ||Loading Location ||Name ||
| From Schedule || SCHED_FROM || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Trip ID || TRIP_ID || O || || || || || ||
|}
|}
[[File:REP-HCR-LOADING-SHEET.png|800x800px]]


==Haulier Confirmation==
==NR Order Conf==
This report displays carrier information along with trip details
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Customer Ref || P_EXT_REF || M || || || || || ||
|}


==NR Supplier Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| Trip ID(Optional) ||O ||STRING || || || || ||
| From Schedule || SCHED_FROM || O || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Customer || CUSTOMER || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Carrier Name || CARRIER_NAME || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Group Name || GROUP_NAME || O || || || || || ||
|}
|}


==Haulier Invoice==
==Openfield Drivers Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Trip ID || TRIP_ID || O || || || || || ||
|-
|-
| Invoice ID ||O ||STRING || || || || ||
| To Schedule || SCHED_TO || O || || || || || ||
|-
|-
| Start Date ||O || || || || || ||
| From Schedule || SCHED_FROM || O || || || || || ||
|-
|-
| End Date ||O || || || || || ||
| Carrier Name || CARRIER_ID || O || || || || || ||
|-
|-
| Invoice ID ||O ||STRING || || || || ||
| Group Name || GROUP_NAME || O || || || || || ||
|-
|-
| Start Date ||O || || || || || ||
| Customer || CUSTOMER || O || || || || || ||
|-
|-
| End Date ||O || || || || || ||
| Owning Depot || OWNING_DEPOT || O || || || || || ||
|}
|}


==Haulier Performance==
==Operational Value Detail==
This report display the performance of each haulier for a specific period of time
Parameters:
{| class="wikitable"
|+
! 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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


==ISC Road Ops Trip Control Form==
==Order Conf==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Euro Exchange Rate ||M ||STRING ||1.00000 || || || ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip Ref ||M || || || || || ||
| OMS Ref || P_OMS_REF || M || || || || || ||
|}
|}


==Inbound Schedule==
==Order Variance Qty by Product==
This report shows all the trips scheduled to arrive at depots.  
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| Source || P_SOURCE || O || || || Source || Location Id || Name
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Destination || P_DEST || O || || || Destination || Location Id || Name
|-
|-
| From Date ||M ||TODAY || || || || ||
| Min. DU Variance || P_MIN_VARIANCE || M || STRING || || || || ||
|-
|-
| Trip Status ||M ||STRING ||ALL || || || ||
| Schedule || P_SCHED_DATE || M || || || || || ||
 
|-
|-
| || || || || || || ||
| Product Type || P_PROD_TYPE || O || || || || || ||
|}
|}


==Item Labels (DOM)==
==Order Variance Qty by Store==
This report shows the same as Order Variance Qty by Product but groups the result by store.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Product Type || P_PROD_TYPE || O || || || || || ||
|-
|-
| Trip ID ||M || || || || || ||
| Schedule || P_SCHED_DATE || M || || || || || ||
|-
|-
| Collection Location ||O || || ||Collection Location ||Location ||Location ||
| Min. DU Variance || P_MIN_VARIANCE || M || STRING || || || || ||
|}
 
==Item Labels by Schedule (DOM)==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Schedule ||M || || || || || ||
| Destination || P_DEST || O || || || Destination || Location Id || Name
|-
|-
| Supplier ||O || || || || || ||
| Source || P_SOURCE || O || || || Source || Location Id || Name
|}
|}


==KPI By Lane==
==Order Variance Qty by Trip==
This report displays various KPI’s for a specified period of time
This report shows the same as Order Variance Qty by Product but shows the result by trip.


Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Grouping ||M ||STRING ||CUST_GROUP || || || ||
! Name
|-
! Mand
| End Date ||M ||TODAY || || || || ||
! Def Type
|-
! Def Val
| Start Date ||M ||TODAY || || || || ||
! LOV
|-
! Column 1
| Customer Group ||O || || || || || ||
! Column 2
|-
! Column 3
| Tolerance(days) ||O || || || || || ||
|-
| Separate Pages ||M ||STRING ||N || || || ||
|-
|-
| Customer Group ||O || || || || || ||
| Product Type || P_PROD_TYPE || O || || || || || ||
|-
|-
| Grouping ||M ||STRING ||CUST_GROUP || || || ||
| Source || P_SOURCE || O || || || Source || Location Id || Name
|-
|-
| Show Detail ||M ||STRING ||Y || || || ||
| Destination || P_DEST || O || || || Destination || Location Id || Name
|-
|-
| End Date ||M || || || || || ||
| Schedule || P_SCHED_DATE || M || || || || || ||
|-
|-
| Start Date ||M || || || || || ||
| Min. DU Variance || P_MIN_VARIANCE || M || STRING || || || || ||
|}
|}


==KPI Summary==
==Pending Supplier Invoices==
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.
This report displays the pending supplier invoices, with total amount of all invoices, for a user-supplied date range


Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Schedule ||M ||STRING || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


==LFS Despatch Note==
==PL Pallets Ticket==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| Trip id ||M || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


==LFS Label==
==PL Transport Order==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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
|-
|-
| OMS Ref ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| OMS Ref ||M || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
|}


==LFS Pallet Label==
==PL Trip Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| Pallet ID ||M || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Depot ||O || || ||Depot ||Location ID ||Name ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
 
==Loading List==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Trip ID ||M ||STRING ||ALL || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}


==Loading Schedule==
==Plan Exceptions==
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.
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Carrier ||M ||STRING ||ALL || || || ||
| Light Trip Min. RPE || P_LT_THRESHOLD || M || STRING || 30 || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Schedule || P_SCHED_NAME || O || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Max Deviation Miles || P_EDM_THRESHOLD || M || STRING || 80 || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| 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:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Changed Since ||O ||TODAY || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name
|-
|-
| Include Order No ||M ||STRING ||N || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


==Location Pre-Warning==
==Polarspeed Label==
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:
{| class="wikitable"
|+
! 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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|}
| Depot ||M || || ||Depot ||Location Id ||Name ||
 
==Rigel Delivery Note==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Load Type ||M ||STRING ||ALL || || || ||
| Trip ID || P_TRIP_ID || O || || || || || ||
|-
|-
| Trip Status ||M ||STRING ||ALL || || || ||
| Depot || P_LOCATION || O || || || Depot || Location Id || Name
|-
|-
| Load Type ||M ||STRING ||ALL || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || O || TODAY || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Copies || P_COPIES || M || || 1 || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| To Date || P_END_DATETIME || O || TODAY || || || || ||
|-
|-
| Trip Status ||M ||STRING ||ALL || || || ||
| Schedule || P_SCHED || O || || || || || ||
|}
|}


==Low Vehicle Fill==
==SCALE Drivers Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Group Name || GROUP_NAME || O || || || || || ||
|-
|-
| Min RPE Qty ||M ||STRING ||40 || || || ||
| To Schedule || SCHED_TO || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| Owning Depot || OWNING_DEPOT || O || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Trip ID || TRIP_ID || O || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Customer || CUSTOMER || O || || || || || ||
|-
| Carrier Name || CARRIER_NAME || O || || || || || ||
|-
| From Schedule || SCHED_FROM || O || || || || || ||
|}
|}


==MDD Code 03 Exception Report==
==Service Self Bill Invoice==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| To Date ||M ||TODAY || || || || ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| From Date ||M ||TODAY || || || || ||
| Invoice ID || P_INVOICE_NO || M || || || || || ||
|}
|}


==MS RDC Intake Report==
==Shipments Invoice==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| RDC Location ||M ||STRING || || || || ||
| To Date || P_END_DATE || M || TODAY || || || || ||
|-
|-
| Date From ||M ||DATETIME ||YESTERDAY:20:00 || || || ||
| From Date || P_START_DATE || M || TODAY || || || || ||
|-
|}
| Date To ||M ||DATETIME ||TODAY:19:59 || || || ||


==Short Trips==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Date
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
| M ||TODAY || || || || ||
|-
| % Fill ||O ||STRING ||100.00 || || || ||
|-
| Depot ||M ||STRING || || || || ||
|-
|-
| Slot Type ||M ||STRING || || || || ||
| Max Time || P_MAX_ELAPSED_TIME || M || STRING || 360 || || || ||
|-
|-
| Location Type ||O ||STRING || ||Location Types ||Location Type || ||
| Carrier || P_CARRIER_ID || M || STRING || ALL || || || ||
|-
|-
| DU Qty ||O ||STRING ||999999 || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


==Moran Trip Sheet==
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name
|-
|-
| Group Name ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| 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:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Owning Depot ||M || || ||Depot ||Location ID ||Name ||
| Slot Variance || P_MODIFIED_FLAG || M || STRING || M || || || ||
|-
|}
| To Date ||M ||TODAY || || || || ||
|-
| From Date ||M ||TODAY || || || || ||


==Stapletons Load Sheet==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
|  
| Trip || P_TRIP || M || STRING || ALL || || || ||
|-
| M ||STRING ||0 || || || ||
|-
| To Date ||M ||TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location_id || Name
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


==Multiple Deliveries==
==STL Driver Manifest==
This shows locations and order details where multiple deliveries are to be made for a particular date range.
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Max Time ||M ||STRING ||60 || || || ||
| Start Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| End Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Trip ID (Optional) || P_TRIP_ID || O || || || || || ||
|}
|}


==NHSBT Manifest==
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Start Schedule ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip ID ||M || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| End Schedule ||M || || || || || ||
| RDC Return Less % || P_RDC_PCT || M || STRING || 50 || || || ||
|}
|}
[[File:REP-NHSBT-MANIFEST.png|border|800x800px]]


[[File:REP-NHSBT-MANIFEST-2.png|border|800x800px]]
==Supplier Invoice==
 
==NR Driver Manifest==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID ||O || || || || || ||
| End Date || P_END_DATE || O || || || || || ||
|-
|-
| To Schedule ||O || || || || || ||
| Invoice ID || P_INVOICE_NO || O || STRING || || || || ||
|-
|-
| From Schedule ||O || || || || || ||
| 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:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| "To<br>Date" || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Owning Depot ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Carrier Name ||O || || || || || ||
| Depot || P_DEPOT || M || || || Depot || Location Id || Name
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Customer ||O || || || || || ||
| "Trip ID<br>(Optional)" || P_TRIP_ID || O || STRING || || || || ||
|}
|}
[[File:REP-THE-DRIVER-SHEET.png|border|800x800px]]
==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.


==NR Order Conf==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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
|-
|-
| Customer Ref ||M || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


==NR Supplier Manifest==
==Trailer Shunting==
This report is typically used by sites to track the shunting of the trailers.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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
|-
|-
| Owning Depot ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
 
==Trip Sheet (Generic Barcode)==
Parameters:
{| class="wikitable"
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Collection Postcode ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| To Schedule ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Schedule ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Carrier Name ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location ID || Name
|-
|-
| Customer ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
|}
[[File:REP-DRIVER-TRIP-SHEET-GENERIC-BC.png|border|800x800px]]


==Non Slot Deliveries==
==Trip Sheet (Generic Detail)==
This shows all the deliveries to be delivered outside of a locations slot.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Depot ||M || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|}
|}
[[File:REP-TRIP-SHEET-GENERIC-DTL.png|border|800x800px]]


==Openfield Drivers Manifest==
==Trip Sheet (Generic New)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Owning Depot ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location ID || Name
|-
|-
| Customer ||O || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier Name ||O || || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| From Schedule ||O || || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| To Schedule ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Trip ID ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|}
|}
[[File:REP-DRIVER-TRIP-SHEET-GENERIC-NEW.png|border|800x800px]]


==Operational Value Detail==
==Trip Sheet (Generic)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Customer Group || || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Cost Centre ||M || || || || || ||
| Trip ID (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Customer || || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|}
 
==Operational Value Summary==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location ID || Name
|}
|}
[[File:REP-TRIP-SHEET-GENERIC.png|border|800x800px]]


==Order Conf==
==Trip Sheet Barcode==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| OMS Ref ||M || || || || || ||
| Group Name ||O || || || || || ||
|}
|-
 
| Customer ||O || || || || || ||
==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:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
|-
| Destination ||O || || ||Destination ||Location Id ||Name ||
| Trip Id (optional) ||O || || || || || ||
|-
|-
| Source ||O || || ||Source ||Location Id ||Name ||
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
| Product Type ||O || || || || || ||
| Carrier ||O || || || || || ||
|-
|-
| Min. DU Variance ||M ||STRING || || || || ||
| From Date ||M ||TODAY || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| To Date ||M ||TODAY || || || || ||
|}
|}
[[File:REP-TRIP-SHEET-BARCODE.png|border|800x800px]]


==Order Variance Qty by Store==
==Trip Sheet BNL==
This report shows the same as Order Variance Qty by Product but groups the result by store.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || || || ||
|-
|-
| Source ||O || || ||Source ||Location Id ||Name ||
| Trip ID || TRIP_ID || O || STRING || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Schedule To || SCHED_TO || M || || || || || ||
|-
|-
| Min. DU Variance ||M ||STRING || || || || ||
| Schedule From || SCHED_FROM || M || || || || || ||
|-
|-
| Destination ||O || || ||Destination ||Location Id ||Name ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Product Type ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || O || || || || || ||
|}
|}


==Order Variance Qty by Trip==
==Trip Sheet Dunelm==
This report shows the same as Order Variance Qty by Product but shows the result by trip.
 
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Destination ||O || || ||Destination ||Location Id ||Name ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Product Type ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name
|-
|-
| Source ||O || || ||Source ||Location Id ||Name ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Min. DU Variance ||M ||STRING || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Schedule ||M || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
| Customer || P_CUSTOMER || O || || || || || ||
|}
|}


==PL Pallets Ticket==
==Trip Sheet Dunelm (Detail)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Load Location ||O || || ||Loading Location ||Location Id ||Name ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|}
|}


==PL Transport Order==
==Trip Sheet Dunelm (New)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Load Location ||O || || ||Loading Location ||Location Id ||Name ||
| Owning Depot || P_OWN_DEPOT || O || || || Depot || Location Id || Name
|-
|-
| Cost Centre ||M || || ||Cost Centre ||Cost Centre ||Cost Centre ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Carrier ||O || || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


==PL Trip Sheet==
==Trip Sheet TDL==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
| Group Name || P_GROUP_NAME || O || || || || || ||
|-
|-
| Owning Depot ||M || || ||Depot ||Location Id ||Name ||
| Trip Id (optional) || P_TRIP_ID || O || || || || || ||
|-
|-
| Group Name ||O || || || || || ||
| Owning Depot || P_OWN_DEPOT || M || || || Depot || Location Id || Name
|-
|-
| Carrier ||O || || || || || ||
| Carrier || P_CARRIER || O || || || || || ||
|-
|-
| To Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| Customer || P_CUSTOMER || O || || || || || ||
|-
|-
| Load Location ||O || || ||Loading Location ||Location Id ||Name ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|}
|}
[[File:REP-TRIP-SHEET-TDL-1.png|border|800x800px]]


==Pending Supplier Invoices==
[[File:REP-TRIP-SHEET-TDL-2.png|border|800x800px]]
This report displays the pending supplier invoices, with total amount of all invoices, for a user-supplied date range
 
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| To Date ||M ||TODAY || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| From Date ||M ||TODAY || || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|}
|}


==Plan Exceptions==
==Unplanned Product==
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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Max Deviation Miles ||M ||STRING ||80 || || || ||
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Light Trip Min. RPE ||M ||STRING ||30 || || || ||
| From Date || P_START_DATETIME || M || TODAY || || || || ||
|-
|-
| Schedule ||O || || || || || ||
| To Date || P_END_DATETIME || M || TODAY || || || || ||
|-
|-
| Short Trip Min. Miles ||M ||STRING ||200 || || || ||
| Min Variance Qty || P_VARIANCE_QTY || M || STRING || 0 || || || ||
|-
|-
| Overladen Trip Tol. ||M ||STRING ||0.5 || || || ||
| Depot || P_DEPOT || O || || || Depot || Location Id || Name
|}
|}


==Poland Pallet Label==
==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:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! 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 || || || ||
|-
|-
| Schedule ||M || || || || || ||
| Overplanned RPE > || P_SHOW_RPE_OVER || M || STRING || 0 || || || ||
|-
|-
| Depot ||M || || ||Depot ||Location Id ||Name ||
| Underplanned RPE > || P_SHOW_RPE_UNDER || M || STRING || 0 || || || ||
|}
|}


==Polarspeed Label==
==Unscheduled Order Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Customer Ref ||M || || || || || ||
| Customer || P_CUSTOMER || M || STRING || ALL || || || ||
|}
 
==Prov Booking Exception Report==
Parameters:
{| class="wikitable"
!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:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
| Trip ID ||O || || || || || ||
|-
| Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|-
| Carrier ||O || || || || || ||
| Depot || P_DEPOT || O || STRING || || Depot || Location ID || Name
|-
|-
| From Date ||O ||TODAY || || || || ||
| DU Category || P_DU_TYPE || O || STRING || || || || ||
|-
|-
| Copies ||M || ||1 || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| To Date ||O ||TODAY || || || || ||
| Order Status || P_STATUS || M || STRING || UNSCHEDULED || || || ||
|-
|-
| Schedule ||O || || || || || ||
| Order By || P_ORDER_BY || M || || || || || ||
|}
|}


==SCALE Drivers Manifest==
==Vehicle Despatch==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
|-
! Title
| Trip ID ||O || || || || || ||
! Name
|-
! Mand
| To Schedule ||O || || || || || ||
! Def Type
|-
! Def Val
| Owning Depot ||O || || || || || ||
! LOV
|-
! Column 1
| Carrier Name ||O || || || || || ||
! Column 2
|-
! Column 3
| Group Name ||O || || || || || ||
|-
| Customer ||O || || || || || ||
|-
|-
| From Schedule ||O || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|}
|}


==STL Driver Manifest==
==Vehicle Utilisation==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|+
! Title
! Name
! Mand
! Def Type
! Def Val
! LOV
! Column 1
! Column 2
! Column 3
|-
|-
| Trip ID (Optional) ||O || || || || || ||
| Schedule || P_SCHED || M || || || || || ||
|-
|-
| End Date ||M ||TODAY || || || || ||
| Cost Centre || P_COST_CENTRE || M || || || || || ||
|-
| Start Date ||M ||TODAY || || || || ||
|}
 
==Service Self Bill==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
| Invoice ID ||M || || || || || ||
|}
 
==Shipments Invoice==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
| To Date ||M ||TODAY || || || || ||
|-
| From Date ||M ||TODAY || || || || ||
|}
 
==Short Trips==
Parameters:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
| Slot Variance ||M ||STRING ||M || || || ||
|}
==Stapletons Load Sheet==
Parameters:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!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 || || || || ||
|}
[[File:REP-THE-DRIVER-SHEET.png|border|800x800px]]
==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:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!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 || || || || ||
|}
[[File:REP-DRIVER-TRIP-SHEET-GENERIC-BC.png|border|800x800px]]
==Trip Sheet (Generic Detail)==
Parameters:
{| class="wikitable"
!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 ||
|}
[[File:REP-TRIP-SHEET-GENERIC-DTL.png|border|800x800px]]
==Trip Sheet (Generic New)==
Parameters:
{| class="wikitable"
!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 || || || || ||
|}
[[File:REP-DRIVER-TRIP-SHEET-GENERIC-NEW.png|border|800x800px]]
==Trip Sheet (Generic)==
Parameters:
{| class="wikitable"
!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 || || || || || ||
|}
[[File:REP-TRIP-SHEET-GENERIC.png|border|800x800px]]
==Trip Sheet BNL==
Parameters:
{| class="wikitable"
!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:
{| class="wikitable"
!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 || || || || ||
|}
[[File:REP-TRIP-SHEET-BARCODE.png|border|800x800px]]
==Trip Sheet Dunelm==
Parameters:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!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 || || || || || ||
|}
[[File:REP-TRIP-SHEET-TDL-1.png|border|800x800px]]
[[File:REP-TRIP-SHEET-TDL-2.png|border|800x800px]]
==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:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
| To Date ||M ||TODAY || || || || ||
|-
| From Date ||M ||TODAY || || || || ||
|}
==Unplanned Product==
Parameters:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!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:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Col 1 !! Col 2 !! Col 3
|-
| Schedule ||M || || || || || ||
|}
[[Category:Reports]]

Latest revision as of 13:44, 31 July 2025

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

REP-106-BOOKED ORDERS.png

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

REP-106-DESP-BY-CARRIER.png

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

REP-106-DESP-START-TIME.png

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

REP-106-DRIVERS-RUN-SHEET.png

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

REP-106-HAULIER-TRIP-SHEET.png

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

REP-106-TRIP-SHEET.png

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

REP-106-TRIP-STOPS.png

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

REP-106-TRIP-STOPS-DSG.png

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

REP-106-UNSCHED-ORDS.png

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

REP-BATHSTORE-TRIP-SHEET.png

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

REP-BAXTER-DELNOTE1.png

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

REP-BG-HC-TRIP-SHEET.png

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

REP-BG-TRIP-SHEET.png

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

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:

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

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:

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

REP-COMBINED-DOCS-BNL.png

REP-COMBINED-DOCS-BNL2.png

REP-COMBINED-DOCS-BNL3.png

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

REP-DELNOTE-HCR.png

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

REP-DRIVER-RUN-SHEET.png

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

REP-HC-HAULIER-TRIP-SHEET.png

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

REP-HC-SHUNT-SHEET.png

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

REP HC TRIP SHEET.png

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

REP-HC-VAN-DELNOTE.png

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

REP-HCR-LOADING-SHEET.png

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

REP-NHSBT-MANIFEST.png

REP-NHSBT-MANIFEST-2.png

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

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:

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

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

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

REP-TRIP-SHEET-GENERIC-DTL.png

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

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

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

REP-TRIP-SHEET-GENERIC.png

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 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

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:

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