Anw: Added Order Item Contents to Order Items extract (created for Tesla)

2025-08-21T14:45:15Z

Added Order Item Contents to Order Items extract (created for Tesla)

← Older revision		Revision as of 16:45, 21 August 2025
Line 172:		Line 172:
	\|-		\|-
	\|ORDER_ITEM \|\|1 \|\|ORD_ITEM_DATA \|\|Reports on Order Items on orders (including order information relating to the From and To locations) \|\|Transactional \|\|Item		\|ORDER_ITEM \|\|1 \|\|ORD_ITEM_DATA \|\|Reports on Order Items on orders (including order information relating to the From and To locations) \|\|Transactional \|\|Item
			\|-
			\|ORDER_ITEM
			\|1
			\|ORD_ITEM_CONT
			\|Adds Item Contents to the report
			\|Transactional
			\|Item
	\|-		\|-
	\|ORDLN_TYPE \|\|1 \|\|ORDER_LINE_DATA \|\|Reports on Order Lines, including Location and Customer information. \|\|Transactional \|\|Line		\|ORDLN_TYPE \|\|1 \|\|ORDER_LINE_DATA \|\|Reports on Order Lines, including Location and Customer information. \|\|Transactional \|\|Line

Anw: Added searchable tables

2024-07-24T08:18:30Z

Added searchable tables

← Older revision		Revision as of 10:18, 24 July 2024
Line 3:		Line 3:
	{{Note}} Not all ORS reports are delivered as standard but can be added to the system.		{{Note}} Not all ORS reports are delivered as standard but can be added to the system.

	{\| class="wikitable" border="1"		{\| class="wikitable apt-searchable" border="1" id="ORSReports"
	\|- bgcolor="silver"		\|- bgcolor="silver"
	!Type !!Level !!Name !!Description !!S/T !!Data Reported		!Type !!Level !!Name !!Description !!S/T !!Data Reported

Anw: Categorisation

2024-05-07T09:17:35Z

Categorisation

← Older revision		Revision as of 11:17, 7 May 2024
Line 311:		Line 311:
	\|ZONE \|\|1 \|\|ZONE \|\|Reports on Zones set up in the system \|\|Standing Data \|\|Geographical		\|ZONE \|\|1 \|\|ZONE \|\|Reports on Zones set up in the system \|\|Standing Data \|\|Geographical
	\|}		\|}

			[[Category:Reports\|100]]
			[[Category:Interfaces]]

Anw: Added list of all available ORS reports.

2024-05-07T09:07:53Z

Added list of all available ORS reports.

New page

The following is a list of all available ORS reports.

{{Note}} Not all ORS reports are delivered as standard but can be added to the system.

{| class="wikitable" border="1"
|- bgcolor="silver"
!Type !!Level !!Name !!Description !!S/T !!Data Reported
|-
|3PL_CARR ||1 ||3PL_CARR ||Reports on Carrier and trip assigned to 3rd-party carriers (designated as 3PL) ||Transactional ||Trip
|-
|ACCOUNT ||1 ||CONTRACTS_OUT ||Reports on Accounts and Invoice Requirements set up in the system. ||Standing Data ||Finance
|-
|ACC_ACCNT ||1 ||ACC_ACCNT ||Reports on Account set up in the system ||Standing Data ||Finance
|-
|ACC_SRVCS ||1 ||ACC_SRVCS ||Reports on Account Services set up in the system (services supplied) ||Standing Data ||Finance
|-
|ACC_SRVCS ||2 ||SLIDING_CHG ||Adds Sliding Charges from the services supplied to the report ||Standing Data ||Finance
|-
|ASSETS ||1 ||DETAIL ||Reports on Permanent assets configured in the system. ||Standing Data ||Asset
|-
|ASSETS ||2 ||HISTORY ||Adds the history of events against the assets to the report. ||Transactional ||Asset
|-
|AWB ||1 ||AIRWAY BILL ||Reports on AWBs created through Calidus MCS. ||Transactional ||Item
|-
|AWB_CONS ||1 ||AWS CONS ||Reports on AWBs and Consignments to Shipments ||Transactional ||Trip
|-
|CARRIERS ||1 ||HEADER ||Reports on the Carriers core information set up in the system. ||Standing Data ||Carrier
|-
|CARR_ALLOC ||1 ||CARRIER ALLOCATION ||Reports on Carrier and tendered trip assigned to 3rd-party carriers (designated as 3PL) ||Transactional ||Trip
|-
|CARR_CLASS ||1 ||CLASSES ||Reports on Carrier Rules Commodity Class. ||Standing Data ||Carrier
|-
|CARR_COMMS ||1 ||COMMODITIES ||Reports on Carrier Rules Commodity. ||Standing Data ||Carrier
|-
|CARR_DUS ||1 ||DUS ||Reports on Carrier Du Types ||Standing Data ||Trip
|-
|CARR_MANF ||1 ||CARR_MANF ||Reports the full data from Trip down to Order Lines i.e. manifest data. ||Transactional ||Trip, Order, Line, Item
|-
|CARR_PRODS ||1 ||PRODUCTS ||Reports on Carrier Product Types ||Standing Data ||Carrier
|-
|CARR_ROUTE ||1 ||ROUTES ||Reports on Carrier Routes configured in the system ||Standing Data ||Carrier
|-
|CARR_ROUTE ||2 ||ROUTE_DETAILS ||Adds Carrier Route Services to the report ||Standing Data ||Carrier
|-
|CARR_SHIP ||1 ||SHIPMENTS ||Reports on Carrier Shipment rules ||Standing Data ||Carrier
|-
|CONTRACTS ||1 ||CONTRACTS ||Reports on Contracts configured in the system ||Standing Data ||Finance
|-
|CONTRACTS ||2 ||TARIFFS ||Adds Tariffs to the report ||Standing Data ||Finance
|-
|CONTRACTS ||3 ||TIERS ||Adds Tiers to the report ||Standing Data ||Finance
|-
|CONTRACTS ||4 ||CHARGES ||Adds Charges to the report ||Standing Data ||Finance
|-
|CONTRACTS ||5 ||CHARGE DETAILS ||Adds Charge Details to the report ||Standing Data ||Finance
|-
|CONTRACTS ||6 ||CONDTITIONS ||Adds Charge Conditions to the report ||Standing Data ||Finance
|-
|CONTRACTS ||7 ||VEHICLE ||Adds Vehicle to the report ||Standing Data ||Finance
|-
|CONT_JRNY ||1 ||CONT_JRNY ||Reports on Contracts and Tariffs on standard journeys (geographical restrictions) ||Standing Data ||Finance
|-
|CUSTOMERS ||1 ||CUSTOMERS ||Reports on Customers core information configured in the system. ||Standing Data ||Customer
|-
|CUST_CHRGS ||1 ||CUST_CHRGS ||Reports on Customer Charges configured in the system for a customer. ||Standing Data ||Customer
|-
|CUST_COST ||1 ||CUST_COST ||Reports on Customer Cost Plus configured in the system for a customer. ||Standing Data ||Customer
|-
|CUST_DATA ||1 ||CUST_DATA ||Reports on Customer Cut-offs configured in the system for a customer. ||Standing Data ||Customer
|-
|CUST_FUEL ||1 ||CUST_FUEL ||Reports on Customer Fuel Surcharges configured in the system for a customer. ||Standing Data ||Customer/Finance
|-
|CUST_FUELC ||1 ||CUST_FUELC ||Reports on Customer Fuel Surcharges configured in the system for a customer. ||Standing Data ||Customer/Finance
|-
|CUST_PAIN ||1 ||CUST_PAIN ||Reports on Customer Pain/Gain rules configured in the system for a customer. ||Standing Data ||Customer
|-
|CUST_PREFS ||1 ||CUST_PREFS ||Reports on Customer Prefs configured in the system for a customer. ||Standing Data ||Customer
|-
|CUST_SCHED ||1 ||CUST_SCHED ||Reports on Customer Schedule Engine Thresholds configured in the system for a customer. ||Standing Data ||Customer
|-
|CUST_SEC ||1 ||CUST_SEC ||Reports on Customer Secure Transport configured in the system for a customer. ||Standing Data ||Customer
|-
|CUST_SEC_C ||1 ||CUST_SEC_C ||Reports on Customer Security configured in the system for a customer. ||Standing Data ||Customer
|-
|DEL_TIMES ||1 ||MORNING-DELTIMES ||A "Morning Report", showing Delivery Times from trips executed. ||Transactional ||Trip, Item
|-
|DEL_TRIPS ||1 ||DEL_TRIPS_ORD ||Reports on Trips and Trip Stops and Orders. ||Transactional ||Trip, Stop, Order
|-
|DEL_TRIPS ||2 ||DEL_LINE_DATA ||Adds Order Lines to the report. ||Transactional ||Line
|-
|DEL_TRIPS ||3 ||DEL_ITEM_DATA ||Adds Order Items to the report. ||Transactional ||Item
|-
|DOOD_RPT ||1 ||STANDARD ||Day out of Days report for Lane orders. ||Transactional ||Trip
|-
|DRIVERS ||1 ||HEADER ||Reports on Drivers/Crew configured in the system. ||Standing Data ||Resource
|-
|DU_TYPES ||1 ||DU_TYPES ||Reports on DU types configured in the system ||Standing Data ||Resource
|-
|EX_CARRIER ||1 ||HEADER ||Reports on the Carriers core information set up in the system. ||Standing Data ||Carrier
|-
|EX_HAUL ||1 ||HEADER ||Reports on the Haulage Activity for executed trips (Load/Unload) ||Transactional ||Trip, Stop
|-
|EX_LOC ||1 ||HEADER ||Reports on the Locations set up in the system, and the usage (which Customer/Group they "belong" to) ||Standing Data ||Geographical
|-
|EX_ORDHEAD ||1 ||HEADER ||Reports on Orders, Locations and Contacts. ||Transactional ||Order
|-
|EX_ORDHEAD ||2 ||ORD_ITEM_DATA ||Adds Items to the report ||Transactional ||Item
|-
|EX_ORDITEM ||1 ||HEADER ||Reports on Order Items on orders ||Transactional ||Item
|-
|EX_ORDLINE ||1 ||HEADER ||Reports on Order Lines on orders ||Transactional ||Line
|-
|EX_PERSON ||1 ||HEADER ||Reports on Drivers/Crew configured in the system. ||Standing Data ||Resource
|-
|EX_TRACTOR ||1 ||HEADER ||Reports on Tractors or Vehicles configured in the system. ||Standing Data ||Resource
|-
|EX_TRAILER ||1 ||HEADER ||Reports on Trailers or Vehicles configured in the system. ||Standing Data ||Resource
|-
|EX_TRIP ||1 ||HEADER ||Reports on Trip Header information. ||Transactional ||Trip
|-
|EX_TRPSTOP ||1 ||HEADER ||Reports on Trips and Stops information. ||Transactional ||Trip, Stop
|-
|FAILED ||1 ||MORNING-FAILED ||A "Morning Report", showing Failed items i.e. items not delivered. ||Transactional ||Trip, Item
|-
|FIX_ROUTE ||1 ||ROUTES ||Reports on Fixed Routes configured in the system. ||Standing Data ||Planning
|-
|FIX_ROUTE ||2 ||ROUTE_STOPS ||Reports on Fixed Routes and Stops configured in the system. ||Standing Data ||Planning
|-
|HAULIER ||1 ||SCH_TRIP ||Reports on Trips and Stops information. ||Transactional ||Trip, Stop
|-
|HELD ||1 ||MORNING-HELD ||A "Morning Report", showing failed items that are to be held at the outbase for redelivery. ||Transactional ||Trip, Item
|-
|IMP_DECODE ||1 ||IMP_DECODE ||Reports on any configured import/export decode tables and data set up in the system. ||Standing Data ||Import
|-
|INTERFACE ||1 ||INTERFACE ||Reports on interface triggered events. ||Transactional ||EDI
|-
|INT_XML ||2 ||DETAIL ||Adds detail information to the report. ||Transactional ||EDI
|-
|INV_TYPE ||1 ||INVOICES_DATA ||Reports on Invoices generated for accounts. ||Transactional ||Finance
|-
|INV_TYPE ||2 ||PAYMENTS_DATA ||Adds Payment data included on an invoice to the report. ||Transactional ||Finance
|-
|LABOUR ||1 ||SCH_ORD_LABOUR ||Reports on Labour for orders. ||Transactional ||Order
|-
|LOCKED_OUT ||1 ||LOCKED_OUT ||Reports on Payments generated against Orders where the status is F or A ||Transactional ||Finance
|-
|MCS_DTLS ||1 ||MCS_DETAILS ||Reports on Items scanned or to be scanned through Calidus MCS ||Transactional ||MCS
|-
|NAVTEQ ||1 ||HEADER ||Reports on Geocoding and Route Time/Distance calculations called from external systems. ||Standing Data ||Geographical
|-
|NETWORK ||1 ||LOCATIONS ||Reports on Network Locations in the system, for time and distance calculations ||Standing Data ||Geographical
|-
|NETWORK ||2 ||DRIVE_TIME_DETAILS ||Adds drive time details from that location to other locations to the report. ||Standing Data ||Geographical
|-
|NON_CONF ||1 ||HEADER ||Reports on Order Non-conformance Information . ||Transactional ||Order
|-
|NON_CONF ||2 ||LINE ||Adds Lines to the report ||Transactional ||Line
|-
|NON_CONF ||3 ||ITEMS ||Adds Items to the report ||Transactional ||Item
|-
|NON_CONF ||4 ||NON_CONFORM ||Adds non-conformance/reasons information to the report ||Transactional ||Item History
|-
|O/S SCANS ||1 ||MISSING_SCANS ||Reports on items not scanned through Calidus MCS. ||Transactional ||MCS
|-
|OPEN_AWB ||1 ||V_MCS_OPEN_AWB ||Reports on Open AWBs through Calidus MCS ||Transactional ||MCS
|-
|ORDERS ||1 ||HEADER ||Reports on Order Header Information ||Transactional ||Order
|-
|ORDERS ||2 ||LINE ||Adds Lines to the report ||Transactional ||Line
|-
|ORDERS ||3 ||ITEMS ||Adds Items to the report ||Transactional ||Item
|-
|ORDER_ITEM ||1 ||ORD_ITEM_DATA ||Reports on Order Items on orders (including order information relating to the From and To locations) ||Transactional ||Item
|-
|ORDLN_TYPE ||1 ||ORDER_LINE_DATA ||Reports on Order Lines, including Location and Customer information. ||Transactional ||Line
|-
|ORD_IN_INV ||1 ||ORD_IN_INV_DATA ||Bespoke order invoice report ||Transactional ||Finance
|-
|ORD_OFFSET ||1 ||ORDER_OFFSETS ||Reports on Location time offsets configured in the system. ||Standing Data ||Geographical
|-
|ORD_STATS ||1 ||SCH_ORDER_STATS ||Reports on Order Stats - summary report of orders created, delivered or for delivery. ||Transactional ||Order
|-
|ORD_TYPE ||1 ||ORDERS_DATA ||Reports on Orders (including order information relating to the From and To locations) ||Transactional ||Order
|-
|OWN_CHRGS ||1 ||OWN_CHARGES ||Reports on Own Package Charges ||Standing Data ||Finance
|-
|PALLETS ||1 ||PALLETS ||Reports on Shipment Pallets created in Calidus MCS ||Transactional ||MCS
|-
|PALLETS ||2 ||PALLET_ITEM ||Adds Items to the report ||Transactional ||MCS
|-
|PALL_ITEM ||1 ||PALLET_ITEM ||Reports on Shipment Pallet Items created in Calidus MCS ||Transactional ||MCS
|-
|PAYMENTS ||1 ||PAYMENTS_DATA ||Reports on generated payments of all types ||Transactional ||Finance
|-
|PAYMENTS ||2 ||EVENT_DETAILS ||Adds event details to the report ||Transactional ||Finance
|-
|RE-DELIVER ||1 ||SCH_ORD_RE_DEL ||Reports on history of rebooked orders. ||Transactional ||Order
|-
|REASONS ||1 ||ORD_ITEM_DATA ||Reports on Order Item non-confirmances ||Transactional ||Item History
|-
|REASONS ||2 ||ORD_ITEM_REASON ||Adds Reason Code Information to the report ||Transactional ||Item History
|-
|RES_EQUIP ||1 ||SCH_ORD_RES_EQUIP ||Reports on Order Equipment Requirements. ||Transactional ||Order
|-
|RPE_CUST ||1 ||RPE_CUST ||Bespoke customer RPE data. ||Standing Data ||Resource
|-
|RTE_COSTS ||1 ||RTE_COSTS ||Reports on fixed costs against routes ||Standing Data ||Planning
|-
|RULES ||1 ||RULES ||Reports on Schedule Rules configured in the system. ||Standing Data ||Planning
|-
|SCANS ||1 ||TRIP ||Reports on Trips ||Transactional ||Trip
|-
|SCANS ||2 ||STOP ||Adds Stop information to the report. ||Transactional ||Stop
|-
|SCANS ||3 ||ORDER ||Adds Order and Item information to the report. ||Transactional ||Order, Items
|-
|SCANS ||4 ||ASSET ||Adds Permanent Asset information to the report. ||Transactional ||Asset
|-
|SCANS ||5 ||REASON ||Adds non-conformance/reasons information to the report ||Transactional ||Reasons
|-
|SCHED_ORD2 ||1 ||TRIP_DATA ||Reports on Trip, Stop and Location information. ||Transactional ||Trip
|-
|SCHED_ORD2 ||2 ||STOPS_DATA ||Adds Haulage Activity to the report ||Transactional ||Stop
|-
|SCHED_ORD2 ||3 ||ORDERS_DATA ||Adds Order, Contact and Customer information to the report. ||Transactional ||Order
|-
|SCHED_ORD2 ||4 ||ORDER_LINE_DATA ||Adds order line information to the report. ||Transactional ||Line
|-
|SCHED_ORD2 ||5 ||ORD_ITEM_DATA ||Adds order item information to the report. ||Transactional ||Item
|-
|SCHED_ORDS ||1 ||TRIP_DATA ||Reports on Trip, Stop and Location information. ||Transactional ||Trip
|-
|SCHED_ORDS ||2 ||STOPS_DATA ||Adds Haulage Activity to the report ||Transactional ||Stop
|-
|SCHED_ORDS ||3 ||ORDERS_DATA ||Adds Order, Contact and Customer information to the report. ||Transactional ||Order
|-
|SCHED_ORDS ||4 ||ORDER_LINE_DATA ||Adds order line information to the report. ||Transactional ||Line
|-
|SCHED_ORDS ||5 ||ORD_ITEM_DATA ||Adds order item information to the report. ||Transactional ||Item
|-
|SRVCS_CAPT ||1 ||SRVCS_CAPT ||Reports on Account Service Rates set up in the system. ||Standing Data ||Finance
|-
|STD_ORDS ||1 ||ORDER_AND_TRIP ||Reports on Order Header Information ||Transactional ||Order
|-
|STD_ORDS ||2 ||LINE ||Adds Lines to the report. ||Transactional ||Line
|-
|STD_ORDS ||3 ||ITEM ||Adds Items to the report. ||Transactional ||Item
|-
|STD_ORDS ||4 ||FINANCE ||Adds Finance information to the report. ||Transactional ||Finance
|-
|STD_TIMES ||1 ||ORDER_AND_TIMES ||Reports on order, vehicle and times. ||Transactional ||Order
|-
|STD_TRIPS ||1 ||TRIP ||Reports on Trip, Stop and Location information. ||Transactional ||Trip
|-
|STD_TRIPS ||2 ||STOPS ||Adds Haulage Activity to the report ||Transactional ||Stop
|-
|STD_TRIPS ||3 ||ORDERS ||Adds Order, Contact and Customer information to the report. ||Transactional ||Order
|-
|STD_TRIPS ||4 ||ORDER_LINE ||Adds order line information to the report. ||Transactional ||Line
|-
|STOPS ||1 ||STOP_DATA ||Reports on Trip, Stop, Location and Haulage Activity. ||Transactional ||Trip, Stop
|-
|STORAGE ||1 ||SCH_ORD_STORE ||Bespoke white glove report. ||Transactional ||Order
|-
|SUCCESS ||1 ||MORNING-SUCCESS ||A "Morning Report" showing successful collections/Deliveries. ||Transactional ||Order
|-
|TRACTORS ||1 ||HEADER ||Reports on Tractors or Vehicles configured in the system. ||Standing Data ||Resource
|-
|TRAILERS ||1 ||HEADER ||Reports on Trailers or Vehicles configured in the system. ||Standing Data ||Resource
|-
|TRIP ||1 ||HEADER ||Reports on Trips ||Transactional ||Trip
|-
|TRIP SCANS ||1 ||TRIP SCANS ||Reports on Items on Trips ||Transactional ||Trip Scans
|-
|TRIPS ||1 ||TRIP ||Reports on Trip, Stop and Location information. ||Transactional ||Trip
|-
|TRIPS ||2 ||STOPS ||Adds Stop information to the report ||Transactional ||Stop
|-
|TRIPS ||3 ||ORDERS ||Adds Order, Contact and Customer information to the report. ||Transactional ||Order
|-
|TRIPS ||4 ||ORDER_LINE ||Adds order line information to the report. ||Transactional ||Line
|-
|TRIP_LOCS ||1 ||TRIP_DATA ||Reports on Trip Stop and Locations, for Loading and Unloading activity ||Transactional ||Trip
|-
|TRIP_TYPE ||1 ||TRIP_DATA ||Reports on trip data ||Transactional ||Trip
|-
|TRIP_TYPE ||1 ||TRIP_TYPE ||Summary of 3PL assigned trips ||Transactional ||Trip
|-
|TRL_TYPES ||1 ||HEADER ||Reports on Trailer Types ||Standing Data ||Resource
|-
|TYREKEYCUS ||1 ||PERIOD ||Fleet Maintenance report ||Transactional ||Fleet Management
|-
|TYREKEYGRP ||1 ||PERIOD ||Fleet Maintenance report ||Transactional ||Fleet Management
|-
|TYRE_INSP ||1 ||ORDER_AND_TRIP ||Fleet Maintenance report ||Transactional ||Trip, Order
|-
|TYRE_INSP ||2 ||VEHICLE_TYRES ||Fleet Maintenance report ||Transactional ||Vehicle
|-
|TYRE_INSP ||3 ||INSPECTIONS ||Fleet Maintenance report ||Transactional ||Inspections
|-
|TYRE_ORDS ||1 ||ORDER_AND_TRIP ||Fleet Maintenance report ||Transactional ||Trip, Order
|-
|TYRE_ORDS ||2 ||LINE ||Fleet Maintenance report ||Transactional ||Line
|-
|TYRE_ORDS ||3 ||ITEM ||Fleet Maintenance report ||Transactional ||Item
|-
|TYRE_ORDS ||4 ||FINANCE ||Fleet Maintenance report ||Transactional ||Finance
|-
|VOLUMETRIC ||1 ||DATA ||Product vehicle volumetric data ||Standing Data ||Product
|-
|ZONE ||1 ||ZONE ||Reports on Zones set up in the system ||Standing Data ||Geographical
|}

ORS Reports List - Revision history

Anw: Added Order Item Contents to Order Items extract (created for Tesla)

Anw: Added searchable tables

Anw: Categorisation

Anw: Added list of all available ORS reports.