ORS Reports List: Difference between revisions
From CTMS
(Added list of all available ORS reports.) |
(Added Order Item Contents to Order Items extract (created for Tesla)) |
||
| (2 intermediate revisions by the same user not shown) | |||
| 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 | ||
| 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 | ||
| Line 311: | Line 318: | ||
|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]] | |||
Latest revision as of 15:45, 21 August 2025
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.
| 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 |
| 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 |
| 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 |
