Extracts - WCS Scanning

From CTMS

A number of existing extracts exist for the monitoring the WCS scanning process. These request several common parameters.

The exact parameters of each report are shown below, but the following shows detailed descriptions of how these parameters will work;

  • Date Range - required date range, filtering by default to one day's data, from today's date. The To date will default to the same date - both From and To date may be modified by the user.
  • Date and Time Range - filtering by default to one day's data, from today's date at 00:00 to Today's date at 23:59. The To date will default to the From date - both From and To date and time may be modified by the user.
  • Schedule or Schedule Range - required schedule or range of schedules, selecting from drop-down lists.
  • Customer - a drop-down list of Auto Alliance customers, with an option to select All, many or 1.
  • Asset - A lookup list of all available assets in the system. May be left blank to select all values. Allows direct typing of the selected value.
  • Asset Type - select from a list of asset types.
  • Driver/User ID - a lookup of all drivers, allowing selection of one, many or all. May be left blank to select all values. Allows direct typing of the selected value.
  • Last Scan Location - a lookup list of all locations associated to the customer selected (if selected), allowing selection of one, many or all. May be left blank to select all values. Allows direct typing of the selected value.
  • Dealer - as above, but limited only to dealership locations.
  • Depot - a drop-down list of all Owning Depots, with an option to select one, many or all.
  • Route - a lookup list of all routes created within C-TMS for the selected owning depot, allowing selection of one, many or all. May be left blank to select all values. Allows direct typing of the selected value.
  • Media Type - a lookup list of all media types within the system, allowing selection of one, many or all. May be left blank to select all values. Allows direct typing of the selected value.


AA Trip and Order Detail

The report will allow selection of the following parameters;

  • Start Schedule - required.
  • Carrier
  • Group Name (Required)
  • Activity

The report will extract the information from the Trip and Order data and will display;

  • The criteria used for selection
  • The selected data with titles for each column

The data items shown will be as follows;

  • Order Status,
  • From Location Id,
  • From Location Name,
  • To Location Id,
  • To Location Name,
  • Postcode,
  • Postal Region,
  • Planning Region,
  • Current Location Id,
  • Current Location Name,
  • Customer,
  • Order Cost Centre,
  • Order Schedule,
  • OMS Ref,
  • Booking Ref,
  • Booked In,
  • Customer Ref,
  • Del Point Ref,
  • Shipping Ref,
  • Group Name,
  • Early Collect,
  • Late Collect,
  • Early Delivery,
  • Late Delivery,
  • Product Type,
  • DU Type,
  • Planned DU Quantity,
  • Planned Weight,
  • Cases,
  • Planned RPE Quantity,
  • Actual DU Quantity,
  • Actual Dispatched,
  • Actual Delivered,
  • Actual Weight,
  • Special Instructions,
  • Order Comments,
  • Lane Comments,
  • Delivery Type,
  • Order Cost Revenue,
  • Order Cost VAT,
  • Allocated from Trip,
  • Order Revenue,
  • Order VAT,
  • Container No.,
  • POD CMR No.,
  • Non-Conformance Reason Codes,
  • Created By,
  • Created Date,
  • Last Modified By,
  • Last Modified Date,
  • Trip Schedule,
  • Trip Status,
  • Trip Number,
  • Start Time,
  • Departure Time,
  • Stop No,
  • Planned Arrive,
  • Actual Arrive,
  • Planned Depart,
  • Actual Depart,
  • Activity Name,
  • Trailer Type,
  • Trailer ID,
  • Owning Depot,
  • Trip Cost Centre,
  • Carrier,
  • Trip Ref,
  • Driver,
  • Vehicle,
  • Seal No,
  • Planned Distance,
  • Total Elapsed Time,
  • Total Drive Time,
  • Trip Currency,
  • Trip Cost,
  • Trip Allocable Cost,
  • Trip VAT,
  • Customer Fuel Charge,
  • Customer Premium Charge,
  • POD Received Date,
  • KM from previous Stop,
  • Stop Type,
  • Actual Distance,
  • Route Code,


Asset Dwell

The report will allow selection of the following parameters;

  • Asset Type

The report will extract the information from the Asset and Audit data and will display;

  • The criteria used for selection
  • The selected data with titles for each column

The data items shown will be as follows;

  • Asset ID,
  • Asset Type,
  • Current Location,
  • Location Name,
  • Alt Date,
  • Dwell Days


Asset History

Extracts asset history.png

The report will allow selection of the following parameters;

  • Date and Time Range - required, filtering on scan date.
  • Customer
  • Asset
  • Driver/User ID

The report will extract the information from the Order Item and Audit data and will display;

  • The criteria used for selection
  • The selected data with titles for each column

The data items shown will be as follows;

  • Scan Date - the date of the scan
  • Customer - the customer code
  • Asset - The Asset ID
  • Media Type - the DU Type of the asset
  • Scan Location - the location description
  • Location Name
  • Vehicle - the Tractor ID
  • Trailer - the Trailer ID
  • Driver/User ID - the driver forename and surname concatenated, separated by a space.
  • Scan Time - The time of scan.
  • Scan Activity - Whether Loading, Unloading, etc
  • Scan Process - the application scanning the item


Asset Status

This report is intended to show the last location of items scanned. The report will report all items that match the criteria, and display the information against the items, with the date and time of the last scan.

Extracts asset status.png

The report will allow selection of the following parameters;

  • Customer
  • Asset
  • Last Scan Location

The report will extract the information from the Order Item and Audit data and will display;

  • The criteria used for selection
  • A series of sub-total rows with titles for each column
  • A series of summary rows
  • The selected data with titles for each column.

The data items shown will be as follows;

  • Last Scan Date - the date of the scan
  • Customer - the customer code
  • Asset - The Asset ID
  • Media Type - the DU Type of the asset
  • Last Scan Location - the location ID
  • Quantity - the number of items scanned (expected to be 1)
  • Last Scan Time - The time of scan.
  • Scan Type - Whether Loading, Unloading, etc

The Sub-total section will show the following items, sub-totalled at Date, Customer and Dealer;

  • Quantity

The summary section will show the following items, sub-totalled at Date, Customer and Media Type;

  • Quantity


Driver Scanning

This report is intended to show how the driver collected or delivered goods from or to the dealership, through the Microlise data captured.

Extracts driver scanning.png

The report will allow selection of the following parameters;

  • Date Range - required, filtering on scan date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data (generated from Microlise data only) and will display;

  • The criteria used for selection
  • Titles for each column
  • A series of summary rows with titles for each column, with a total row.
  • The selected data with titles for each column.

The data items shown will be as follows;

  • Date - the date of the scan
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • DHL Depot - The Owning Depot Code
  • Route - the Route Code (if there is one)
  • Activity
  • Media Type - the DU Type of the asset
  • Asset or Item information, including:

o Asset - the Asset ID o Pallet ID o Item Weight o Item Volume

  • Deadline - the CUTOFF held against the Dealership Location, formatted with “Pre-“ (see section 2.3.1.1 above for details)
  • Actual Time
  • Count - Orders Created (assumed 1)
  • Scanned
  • Scan Type - SCAN, KEYED or ACCEPT - the scan type from the Item Audit (see section 2.3.11 above for details)
  • Scan Time
  • Driver Percentage
  • Driver/User ID - the driver forename and surname concatenated, separated by a space.

The summary section will show the following items, sub-totalled at Date and Scan Type;

  • Orders Created
  • Percentage of total

A total line will be shown for ALL scan types.


On Time Arrivals

The report will allow selection of the following parameters;

  • Schedule Range - required, filtering on planned collection date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data for Microlise scans of collection return orders only and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • The selected data with titles for each column

The data items shown will be as follows;

  • Schedule Name- the date the item was scanned collected
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name
  • DHL Depot - The Owning Depot Code
  • Depot Name
  • Load Depot
  • Load Depot Name
  • Route - the Route Code (if there is one)
  • Deadline - the CUTOFF held against the Dealership Location, formatted with “Pre-“ (see section 2.3.1.1 above for details)
  • Drops
  • Actual FPOC
  • On Time
  • Exception Code - the reason code entered against the item
  • Force Majeure - Whether this reason code is designated Force Majeure (see section 2.3.1.4 above for details).

The summary section will show the following items, sub-totalled at Date;

  • On Time
  • Exceptions
  • Variance (against deadline)


On Time Returns

This report is a measure of all requested web portal orders, collected on-time, or at all. This measures on-time versus the cut-off time held against the dealership, rather than versus the planned collection time.

Extracts on time returns.png

The report will allow selection of the following parameters;

  • Date Range - required, filtering on planned collection date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data for Microlise scans of collection return orders only and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • A list of all exceptions encountered with titles for each column, with a total row
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date and time the return item was scanned collected
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name
  • DHL Depot - The Owning Depot Code
  • Depot Name
  • Route - the Route Code (if there is one)
  • Media Type - the DU Type of the asset
  • Asset or Item Reference
  • Deadline - the CUTOFF held against the Dealership Location, formatted with “Pre-“ (see section 2.3.1.1 above for details)
  • Actual FPOC
  • Collection Orders (assuming 1)
  • FPOC - the final POC proof of collection date and time
  • Variance - 0 if the item was undelivered with a reason code, else 1
  • Exception Code - the reason code entered against the item
  • Force Majeure - Whether this reason code is designated Force Majeure (see section 2.3.1.4 above for details).

The summary section will show the following items, sub-totalled at Date;

  • Collection Orders
  • FPOC
  • Variance (against deadline)

The Exception section will show the following items in detail, summarised at Date, Customer, Dealer, DHL Depot, Route and Force Majeure:

  • Date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type
  • Deadline
  • Collection Orders (sub-totalled)
  • FPOC (assumed 0)
  • Variance (qty) (as Collection Orders)
  • Force Majeure

A total row will summarise at Date, Customer, Dealer, DHL Depot, Route and Media Type:

  • Date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type
  • Collection Orders
  • FPOC
  • Variance (qty versus total)


On Time Drops

This report is intended to show On Time Drops rather than the following On Time Items, the major difference that this report is based on the trip stops at a location, rather than quantity of items. Note that this report requires manual debriefing of the stops in C-TMS.

Extracts on time drops.png

The report will allow selection of the following parameters;

  • Date Range - required, filtering on planned delivery date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the C-TMS Trip Stops of delivery orders only and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • A list of all exceptions encountered with titles for each column, with a total row
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date the return item was scanned delivered
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name
  • Load Depot - The Loading Depot Code
  • Depot Name
  • Route - the Route Code (if there is one)
  • Deadline - the CUTOFF held against the Dealership Location, formatted with “Pre-“ (see section 2.3.1.1 above for details)
  • Drops (assuming 1)
  • Actual FPOD - the final POD proof of delivery date and time
  • On Time - N if the delivery was before the cut-off time, else Y
  • Exception Code - the reason code captured for any exceptions
  • Exception Code - Whether this reason code is designated Force Majeure (see section 2.3.1.4 above for details). This column will be headed Force Majeure

The summary section will show the following items, subtotalled at Date:

  • Drops
  • On Time (Percentage of total On Time versus the total orders)

The Exception section will show the following items summarised at Date, Customer, Dealer, DHL Depot and Route and Force Majeure, for each item with a reason code attached;

  • Date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Deadline
  • Drops
  • Actual FPOD
  • Percentage of On Time
  • Force Majeure

A total row will summarise;

  • Drops
  • On Time (Percentage of total not On Time versus the total orders)


On Time Items

The On Time Items is very similar to On Time Drops, but shows each item asset ID for each of the drops, reporting to Item level. Drops are assumed to be delivery stops in the traffic plan for the trip.

Extracts on time items.png

  • note the %age values appear incorrect in this example but serve to describe the formatting of the output.

The report will allow selection of the following parameters;

  • Date Range - required, filtering on planned delivery date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data for Microlise scans of delivery orders only and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • A list of all exceptions encountered with titles for each column, with a total row
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date the return item was scanned delivered
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name
  • DHL Depot - The Owning Depot Code
  • Depot Name
  • Route - the Route Code (if there is one)
  • Media Type - the DU Type of the asset
  • Asset or Item details, including:

o Asset or Item o Child Asset o Pallet ID o Item Weight o Item Volume

  • Deadline - the CUTOFF held against the Dealership Location, formatted with “Pre-“ (see section 2.3.1.1 above for details)
  • Orders Created (assuming 1)
  • Actual FPOD - the final POD proof of delivery date and time
  • On Time - N if the delivery was before the cut-off time, else Y
  • Exception Code - the reason code captured for any exceptions
  • Exception Code - Whether this reason code is designated Force Majeure (see section 2.3.1.4 above for details). This column will be headed Force Majeure

The summary section will show the following items, subtotalled at Date:

  • Orders Created
  • On Time (Percentage of total On Time versus the total orders)

The Exception section will show the following items summarised at Date, Customer, Dealer, DHL Depot and Route and Force Majeure, for each item with a reason code attached;

  • Date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type
  • Deadline
  • Drops
  • Actual FPOD
  • Percentage of On Time
  • Force Majeure


A total row will summarise;

  • Orders Created
  • On Time (Percentage of total not On Time versus the total orders)


On Time Items (Assets)

The On Time Items (Assets) report is very similar to On Time Items, but shows each item asset ID for each of the drops, reporting to Item level. Drops are assumed to be delivery stops in the traffic plan for the trip.

Extracts on time items assets.png

  • note the %age values appear incorrect in this example but serve to describe the formatting of the output.

The report will allow selection of the following parameters;

  • Date Range - required, filtering on planned delivery date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data for Microlise scans of delivery orders only and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • A list of all exceptions encountered with titles for each column, with a total row
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date the return item was scanned delivered
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name
  • DHL Depot - The Owning Depot Code
  • Depot Name
  • Route - the Route Code (if there is one)
  • Media Type - the DU Type of the asset
  • Asset or Item details, including:

o Asset or Item o Pallet ID o Item Weight o Item Volume

  • Deadline - the CUTOFF held against the Dealership Location, formatted with “Pre-“ (see section 2.3.1.1 above for details)
  • Orders Created (assuming 1)
  • Actual FPOD - the final POD proof of delivery date and time
  • On Time - N if the delivery was before the cut-off time, else Y
  • Exception Code - the reason code captured for any exceptions
  • Exception Code - Whether this reason code is designated Force Majeure (see section 2.3.1.4 above for details). This column will be headed Force Majeure

The summary section will show the following items, subtotalled at Date:

  • Orders Created
  • On Time (Percentage of total On Time versus the total orders)

The Exception section will show the following items summarised at Date, Customer, Dealer, DHL Depot and Route and Force Majeure, for each item with a reason code attached;

  • Date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type
  • Deadline
  • Drops
  • Actual FPOD
  • Percentage of On Time
  • Force Majeure


A total row will summarise;

  • Orders Created
  • On Time (Percentage of total not On Time versus the total orders)


Outbound Shortage

This output shows orders with FPOD date and time captured and highlights exceptions where FPOD is missing, at an item level.

Extracts outbound shortage.png

The report will allow selection of the following parameters;

  • Date Range - required, filtering on Planned Despatch date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data for WCS scans of loaded delivery orders only and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • A list of all exceptions encountered with titles for each column
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date the return item was scanned loaded
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name
  • DHL Depot - The Owning Depot Code
  • Depot Name
  • Route - the Route Code (if there is one)
  • Media Type - the DU Type of the asset
  • Asset or Item Reference details, consisting of:

o Asset ID o Pallet ID o Item Weight o Item Volume

  • Deadline - the CUTOFF held against the Dealership Location, formatted with “Pre-“ (see section 2.3.1.1 above for details)
  • Order Create (assuming 1)
  • Actual FPOD - the final POD proof of delivery date and time
  • Variance - 0 if the item was not loaded for the order, else 1

The summary section will show the following items, sub-totalled at Date and DHL Depot;

  • Order Create
  • FPOD
  • Variance (against deadline)

The Exception section will show the following items in detail, for each item with a reason code attached;

  • Date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type
  • Asset or Item
  • Order Create
  • FPOD
  • Variance (qty)


Cross Dock

This report is intended to show a comparison of everything scanned in to and out of a cross-dock location, to help highlight items lost on the floor. Extracts cross dock.png

The report will allow selection of the following parameters;

  • Date and Time Range - required, filtering on scan date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data for WCS scans of loaded and unloaded delivery orders at out-bases only and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • A list of all exceptions encountered with titles for each column
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date the return item was scanned
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name
  • DHL Depot - The Owning Depot Code
  • Depot Name
  • Unload Route Code- the Unload Route Code (if there is one)
  • Load Route Code- the Load Route Code (if there is one)
  • Movement
  • Media Type - the DU Type of the asset
  • Asset or Item Reference details, consisting of:

o Asset ID o Pallet ID o Item Weight o Item Volume o Item Qty

  • Scanned In - Whether the item was scanned in on the date
  • Variance
  • Scanned Out - whether the item was scanned out on the date
  • Variance - 0 if the item was not loaded for the order, else 1

The summary section will show the following items, sub-totalled at Date and DHL Depot;

  • Scanned In
  • Scanned Out
  • Variance (difference between scanned in and out)

The Exception section will show the following items in detail, for each item with a reason code attached;

  • Date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type
  • Asset or Item
  • Scanned In
  • Scanned Out
  • Variance (qty)

Note: This report will show variances where an item is scanned in and out at the out-base on different days.


Receipt Scanning

Extracts receipt scanning.png

The report will allow selection of the following parameters;

  • Date Range - required, filtering on scan date
  • Customer
  • Dealer
  • DHL Depot
  • Route
  • Media Type

The report will extract the information from the Order Item and Audit data for WCS unloading scans of collection orders at DHL Depots only (not out-bases) and will display;

  • The criteria used for selection
  • A summary line with titles for each column
  • A list of all exceptions encountered with titles for each column
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date the return item was scanned
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • Dealer Name - The dealership name
  • Origin Depot - The Depot Code at which the order originated
  • Depot Name - the origin depot name
  • Route Code - the Route Code (if there is one)
  • Media Type - the DU Type of the asset
  • Asset or Item Reference details, containing

o Asset o Child Item o Pallet ID o Item Weight o Item Volume

  • Items Created (assuming 1)
  • Positive Load Scan - the load scan of the item at the origin depot
  • Variance - 0 if the item was unloaded but not loaded for the order, else 1

The summary section will show the following items, sub-totalled at Date and Origin Depot;

  • Items Created
  • Positive Load Scan
  • Variance

The Exception section will show the following items in detail, for each item with no positive load scan;

  • Date
  • Customer
  • Dealer
  • Origin Depot
  • Route
  • Media Type
  • Asset or Item
  • Orders Created
  • Positive Load Scan
  • Variance


Volume or Activity

This output shows the quantity and volumetric of items despatched from each originating depot.

Extracts volume or activity.png

The report will allow selection of the following parameters;

  • Date Range - required, filtering on Scheduled Despatch date
  • Customer
  • Dealer
  • DHL Depot (Note: Although this is referred to as Owning depot, there is no functional difference between this and DHL depot)
  • Route
  • Media Type

The report will extract the information from the Order Detail data and will display;

The criteria used for selection

  • A summary line with titles for each column
  • The selected data with titles for each column

The data items shown will be as follows;

  • Date - the date the return item was scanned
  • Customer - the customer code
  • Dealer - the Dealership location ID
  • DHL Depot - The Owning Depot Code
  • Route - the Route Code (if there is one)
  • Media Type - the DU Type of the asset
  • Quantity (despatched from the depot)
  • Conversion - the RPE conversion factor of the media type
  • LCE - total RPE for that line.

The summary section will show the following items, sub-totalled at Date and DHL Depot:

  • Quantity
  • LCE (total)


WCS Location Snapshot

The report itemises all successful scans as well as damages and errors.

Extracts wcs location snapshot.png

The data items shown will be as follows;

  • From Name
  • Coll Sched
  • Coll Trip
  • Coll Bay
  • Early Del
  • To Loc
  • To Name
  • Del Sched
  • Del Trip
  • Del Status
  • Del Bay
  • DU Type
  • Item ID
  • Ordered
  • Despatched
  • Item Location
  • Reason Code
  • Reason Description


WCS Order Items Extract

The report shows all order items and unload con-conformances.

Extracts wcs order items.png

The report will allow selection of the following parameters;

  • Date Range - required, filtering on Scheduled Despatch date
  • Customer
  • Trip

The report will extract the information from the items data and will display;

  • The date and time run
  • The report name and criteria used for selection
  • The selected data with titles for each column

The data items shown will be as follows;

  • Order
  • Trip
  • Customer
  • External Ref
  • Product Type
  • DU Type
  • Item ID
  • Item AKA
  • Item Desc
  • Item Factor
  • Qty Ordered
  • Qty to Deliver
  • Unload Non-conformance Reason
  • Unload Non-conformance
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/MTS/index.php?title=Extracts_-_WCS_Scanning&oldid=7047’