Extracts Details: Difference between revisions

From CTMS
(Initial Creation)
 
(Updated parameters and extract names)
Line 1: Line 1:
This is a full list of all extracts in the system.
This is a full list of all extracts in the system.


==AA Trip and Order Detail==
== 10.6 Customer By Product Export ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
!
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|10.6 Customer By  Product Export
|Cust_By_Product
| colspan="2" |CSV.Cust_By_Product
|}
 
== 10.6 Customer Location Export ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group Name ||M || || || || || ||
|10.6 Customer  Location Export
|Customer_Location
|CSV.Customer_Location
|}
 
== 10.6 Customer Product By Arrival ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|10.6 Customer  Product By Arrival
|Cust_Product_By_Arrive
|CSV.Cust_Product_By_Arrive
|}
 
== 10.6 Data Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|10.6 Data Extract
|Data_Extract
|CSV.Data_Extract
|}
 
== 10.6 Load Status Export ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|10.6 Load Status  Export
|Load_Status_Export
|CSV.Load_Status_Export
|}
|}


== ACC Missing Payments ==
== 10.6 Matthew Clark Data Extract ==
No parameters
{| class="wikitable"
 
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|10.6 Matthew Clark  Data Extract
|Matt_Clark_Data_Extract
|CSV.Matt_Clark_Data_Extract
|}


== ACTIVITY_EXTRACT ==
== 10.6 Planning Export ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Schedule ||M || || || || || ||
|10.6 Planning  Export
|-
|Planning_Export
|Owning Depot ||O || || || || || ||
|CSV.Planning_Export
|-
|From Schedule ||M || || || || || ||
|}
|}


==Accruals==
== 10.6 Tokairo Export ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Revenue After ||O || || || || || ||
|10.6 Tokairo Export
|-
|Tokairo_Export
|Revenue Before ||O || || || || || ||
|CSV.Tokairo_Export
|-
|}
|Customer Group ||O || || || || || ||
 
|-
== 10.6 Warehouse Extract ==
|Debit Account ||O || || || || || ||
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Credit Account ||O || || || || || ||
|10.6 Warehouse  Extract
|Warehouse_Extract
|CSV.Warehouse_Extract
|}
|}


== Actual Load==
== 1POD Delivery Extract ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Procedure for Scheduling'''
|-
|Load Date To ||M || || || || || ||
|-
|-
|Load Date From ||M || || || || || ||
|1POD Delivery  Extract
|POD_Delivery_Extract
|DP_CSV2.POD_DELIVERY_EXTRACT
|}
|}


== Actual Unload==
== AA Trip and Order Detail ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Load Date To ||M || || || || || ||
|AA Trip and Order  Detail
|-
|AA_Trip_Order_Detail_Extract
|Load Date From ||M || || || || || ||
|CSV.AA_Trip_Order_Detail_Extract
|}
|}
==Additional Reporting Requirements==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Activity ||M ||STRING ||Both || || || ||
|-
|Group Name ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Start Schedule ||M || || || || || ||
Line 80: Line 134:
|End Schedule ||M || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|}
|Customer ||O || || || || || ||
 
== ACC Missing Payments ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cost Centre ||O || || || || || ||
|ACC Missing  Payments
|ACC_Missing_Payment
|DP_CSV_DUN.ACC_MISSING_PAYMENT
|}
|}
 
No parameters
==Amazon Resources==
== ACTIVITY_EXTRACT ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Arrival Time To ||O || || || || || ||
|ACTIVITY_EXTRACT
|-
|ACTIVITY_EXTRACT
|Arrival Time From ||O || || || || || ||
|dp_csv3.activity_extract
|}
|}
==Amazon Resources Update==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Update After (HHMI) ||O || || || || || ||
|To Schedule ||M || || || || || ||
|-
|-
|Arrival Time To ||O || || || || || ||
|Owning Depot ||O || || || || || ||
|-
|-
|Arrival Time From ||O || || || || || ||
|From Schedule ||M || || || || || ||
|}
|}


==Approved Price Report==
==Accruals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Accruals
|ACCRUALS
|CSV.ACCRUALS
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|Revenue After ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Revenue Before ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Debit Account ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Credit Account ||O || || || || || ||
|}
|}


==Asset History==
== Actual Load==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Actual Load
|ACTUAL_LOAD_EXTRACT
|DP_CSV_GEN.DAILY_EXT_LOAD
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Date From ||M ||TODAY || || || || ||
|!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Driver/User ||O ||STRING || || || || ||
|Load Date To ||M || || || || || ||
|-
|-
|Asset Id ||O ||STRING ||ALL ||Asset ||Asset ID ||Asset ID ||
|Load Date From ||M || || || || || ||
|}
 
== Actual Unload==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Date To ||M ||TODAY || || || || ||
|Actual Unload
|ACTUAL_UNLOAD_EXTRACT
|DP_CSV_GEN.DAILY_EXT_UNLOAD
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O ||STRING ||ALL || || || ||
|Load Date To ||M || || || || || ||
|-
|-
|Asset Id ||O ||STRING ||ALL ||Asset ||Asset ID ||Asset ID ||
|Load Date From ||M || || || || || ||
|}
 
==Additional Reporting Requirements==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Last Scan Location ||O ||STRING ||ALL ||Last Scan Location ||Location ID ||Name ||
|Additional  Reporting Requirements
|-
|nr_additional_rep
|Customer ||O ||STRING ||ALL || || || ||
|dp_csv_nr.nr_additional_report
|}
|}
==Asset Utilisation==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Route ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Vehicle ||O || || || || || ||
|Cost Centre ||O || || || || || ||
|}
 
==Amazon Resources==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Current Location ||O || || ||Location ||Location ||Location Name ||
|Amazon Resources
|-
|FMC_BULK_UPLOAD
|Location ||O || || ||Location ||Location ||Location Name ||
|DP_CSV_CSS.AMAZON_RESOURCES
|}
|}
==Assets On Time Delivery==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Arrival Time To ||O || || || || || ||
|-
|-
|Location ||O || || ||Location ||Location ||Location Name ||
|Arrival Time From ||O || || || || || ||
|-
|}
|Route ||O || || || || || ||
 
|-
==Amazon Resources Update==
|To Date ||M ||TODAY || || || || ||
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Amazon Resources  Update
|FMC_UPDATE
|DP_CSV_CSS.AMAZON_RESOURCE_UPDATE
|}
|}
==Automotive Planning Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||M || || || || || ||
|Update After (HHMI) ||O || || || || || ||
|-
|-
|Utilisation > ||O ||STRING ||0 || || || ||
|Arrival Time To ||O || || || || || ||
|-
|-
|Utilisation < ||O ||STRING ||999 || || || ||
|Arrival Time From ||O || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Depot ||M ||STRING ||ALL || || || ||
|-
|Level ||M ||STRING ||SUMMARY || || || ||
|}
|}


==BGW Trip and Order Detail==
==Approved Price Report==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Start Schedule ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|End Schedule ||M || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|Loaded At ||O || || || || || ||
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|Approved Price  Report
|-
|approved_price_rep
|Group Name ||M || || || || || ||
|dp_csv_nr.approved_price_report
|}
|}
==BGW_DEBRIEF==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Cost Centre ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|}
|}


==BMW Asset Dwell==
==Asset History==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Asset History
|ASSET_HISTORY
|DP_CSV6.ASSET_HISTORY_EXTRACT
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Asset Type ||O || || || || || ||
|Date From ||M ||TODAY || || || || ||
|-
|Driver/User ||O ||STRING || || || || ||
|-
|Asset Id ||O ||STRING ||ALL ||Asset ||Asset ID ||Asset ID ||
|-
|Date To ||M ||TODAY || || || || ||
|-
|Customer ||O ||STRING ||ALL || || || ||
|-
|Asset Id ||O ||STRING ||ALL ||Asset ||Asset ID ||Asset ID ||
|-
|Last Scan Location ||O ||STRING ||ALL ||Last Scan Location ||Location ID ||Name ||
|-
|Customer ||O ||STRING ||ALL || || || ||
|}
|}


==Backing Sheet==
==Asset Status==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Asset Status
|ASSET_STATUS
|DP_CSV6.ASSET_STATUS
|}
Parameters:
Parameters:
==Asset Utilisation==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Sched To ||O || || || || || ||
!'''Procedure for Scheduling'''
|-
|Customer ||O || || || || || ||
|-
|Manifest ||O || || || || || ||
|-
|-
|Sched From ||O || || || || || ||
|Asset Utilisation
|ASSET_UTILISATION
|dp_csv4.asset_utilisation
|}
|}
==Baxter CSR==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||M ||STRING ||ALL || || || ||
|Customer ||O || || || || || ||
|-
|Route ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
Line 266: Line 388:
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Vehicle ||O || || || || || ||
|-
|Current Location ||O || || ||Location ||Location ||Location Name ||
|-
|Location ||O || || ||Location ||Location ||Location Name ||
|}
|}


==Baxter Download Id Orders==
==Assets On Time Delivery==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Download Id ||M ||STRING || || || || ||
|Assets On Time  Delivery
|ASSET_ON_TIME_DELIV
|dp_csv4.asset_on_time_deliv
|}
|}
==CN Data Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|Customer ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Location ||O || || ||Location ||Location ||Location Name ||
|-
|-
|Customer ||O || || || || || ||
|Route ||O || || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
|}


==CN Planning Export==
==Automotive Planning Report==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Group Name ||O || || || || || ||
!'''Procedure for Scheduling'''
|-
|Current Depot ||M || || ||Current Depot ||Location Id ||Name ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Automotive Planning  Report
|-
|Planning_Report
|From Date ||M ||TODAY || || || || ||
|DP_CSV2.PLANNING_REPORT
|}
|}
==CN Tokairo Export==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||M ||TODAY || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Utilisation > ||O ||STRING ||0 || || || ||
|-
|Utilisation < ||O ||STRING ||999 || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Depot ||M ||STRING ||ALL || || || ||
|-
|Level ||M ||STRING ||SUMMARY || || || ||
|}
|}


==CN Trip and Order Detail==
==BGW Trip and Order Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|BGW Trip and Order  Detail
|BGW_Trip_Order_Detail_Extract
|DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Schedule ||M || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Loaded At ||O || || || || || ||
|Loaded At ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Activity ||M ||STRING ||Both || || || ||
|-
|-
|Group Name ||M || || || || || ||
|Group Name ||M || || || || || ||
|}
==BGW_DEBRIEF==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|BGW_DEBRIEF
|BGW_DEBRIEF
|dp_csv3.bgw_debrief
|}
|}
==CN Warehouse Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Location ||M || || ||From Location ||Location Id ||Name ||
|Cost Centre ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
Line 346: Line 494:
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|Customer ||O || || || || || ||
|}
 
==BMW Asset Dwell==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group Name ||O || || || || || ||
|BMW Asset Dwell
|AUTO_ASSET_DWELL
|DP_CSV3.AUTO_AFTERMARKET_BMW
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Asset Type ||O || || || || || ||
|}
 
==Backing Sheet==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Backing Sheet
|BACKING_SHEET_EXTRACT
|DP_CSV_GEN.BACKING_SHEET
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|Sched To ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Manifest ||O || || || || || ||
|-
|-
|Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
|Sched From ||O || || || || || ||
|}
|}


==CTM Carrier Responsiveness==
==Baxter CSR==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Baxter CSR
|Baxter_csr
|DP_CSV5.BAXTER_CSR
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||O || || || || || ||
|Customer ||M ||STRING ||ALL || || || ||
|-
|-
|Carrier ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|Cost Centre ||O || || || || || ||
|}
 
==Baxter Download Id Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|Baxter Download Id  Orders
|-
|Baxter Download
|End Schedule ||O || || || || || ||
|DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER
|}
|}
==Call Collection OTIF Day==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|Download Id ||M ||STRING || || || || ||
|}
 
==CARGOWISE Header==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|CARGOWISE Header
|CARGOWISE_HEADER
|OF_INT.WRITE_CARGOWISE_HEADER
|}
Parameters:
==CN Data Extract==
{{Warning}}Missing
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer Group ||O || || || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Product Type ||O || || || || || ||
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|-
|End Schedule ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Group Name ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
|}


==Call Collection OTIF Time Window==
==CN Equipment Moves==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|CN Equipment Moves
|Equip_Move
|DP_CSV2.CN_EQUIP_MOVE
|}
Parameters:
==CN Planning Export==
{{Warning}}Missing
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer Group ||O || || || || || ||
|Group Name ||O || || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|Current Depot ||M || || ||Current Depot ||Location Id ||Name ||
|-
|End Schedule ||O || || || || || ||
|-
|Start Schedule ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
Line 425: Line 649:
|}
|}


==Call Delivery OTIF Day==
==CN Tokairo Export==
{{Warning}}Missing
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
==CN Trip and Order Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M ||TODAY || || || || ||
|CN Trip and Order  Detail
|CN_Trip_Order_Detail_Extract
|CSV.CN_Trip_Order_Detail_Extract
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|Loaded At ||O || || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Group Name ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Activity ||M ||STRING ||Both || || || ||
|}
|}


==Call Delivery OTIF Time Window==
==CN Warehouse Loading==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|CN Warehouse  Loading
|CN_Warehouse_Loading
|DP_CSV_DHL.p_warehouse_loading
|}
Parameters:
==CN Warehouse Extract==
{{Warning}}Missing
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|End Schedule ||O || || || || || ||
|From Location ||M || || ||From Location ||Location Id ||Name ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|Customer ||O || || || || || ||
|Group Name ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Trip ID (optional) ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
|}
|}


==Carrier DUs Shipped==
==CTM Carrier Responsiveness==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Carrier ||O ||STRING ||ALL || || || ||
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M ||TODAY || || || || ||
|CTM Carrier  Responsiveness
|-
|CTM_CARRIER_RESPONSIVENESS
|From Date ||M ||TODAY || || || || ||
|CSV.CTM_CARRIER_RESPONSIVENESS
|}
|}
==Carrier Delivery Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Sched Name ||M || || || || || ||
|Start Schedule ||O || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|End Schedule ||O || || || || || ||
|-
|-
|Carrier ||M || || || || || ||
|Start Schedule ||O || || || || || ||
|-
|-
|Depot ||M || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Trip ID ||O ||STRING ||ALL || || || ||
|End Schedule ||O || || || || || ||
|}
|}


==Carrier Invoice==
==CTM Trips Not Responded To==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|CTM Trips Not  Responded To
|CTM_TRIPS_NO_RESPONSE
|CSV.CTM_TRIPS_NO_RESPONSE
|}
Parameters:
Parameters:
==Call Collection OTIF Day==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Invoice No ||M || || || || || ||
|Call Collection  OTIF Day
|coll_OTIF_date_window
|dp_csv_nr.coll_otif_date_window
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Product Type ||O || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|End Schedule ||O || || || || || ||
|-
|-
|Invoice No ||M || || || || || ||
|Start Schedule ||O || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
|}


==Carrier Self Billing==
==Call Collection OTIF Time Window==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|End Schedule ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|Carrier ||0 || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Call Collection  OTIF Time Window
|coll_OTIF_window
|dp_csv_nr.coll_otif_window
|}
|}
==Co-ordinate Non-Conformities==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||M || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Discrepancy Dist ||0 || ||1 || || || ||
|Customer ||O || || || || || ||
|-
|-
|TomTom,Epod,Both ||M || ||B || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|Driver ||O || || || || || ||
|Product Type ||O || || || || || ||
|-
|End Schedule ||O || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|Start Schedule ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
 
==Commercial==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
|}


==Compliance Report==
==Call Delivery OTIF Day==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Collection Date ||M || || || || || ||
|Call Delivery OTIF  Day
|del_OTIF_date_window
|dp_csv_nr.del_otif_date_window
|}
|}
==Concurrent Logon Export==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||O ||TODAY || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
 
==Contracts== || || || || || || || || ||
No Parameters
 
==Cross Dock==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Media Type ||O ||STRING || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Route ||O ||STRING || || || || ||
|Start Schedule ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|End Schedule ||O || || || || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Product Type ||O || || || || || ||
|-
|-
|Depot ||O ||STRING || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Customer ||O || || || || || ||
|}
 
==Call Delivery OTIF Time Window==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O ||STRING || || || || ||
|Call Delivery OTIF  Time Window
|del_OTIF_window
|dp_csv_nr.del_otif_window
|}
|}
==Customer Invoice==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Invoice No ||M || || || || || ||
|End Schedule ||O || || || || || ||
|-
|Product Type ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Invoice No ||M || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Start Schedule ||O || || || || || ||
|}
|}


==Customer Invoice By Dates==
==Campus KPI Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Payment Status ||O || || || || || ||
|Campus KPI Extract
|-
|Campus_KPI_Extract
|Customer ||M || || || || || ||
|KPI.KPI_CAMPUS_EXTRACT
|-
|}
|From Date ||M || || || || || ||
Parameters:
==Carrier DUs Shipped==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M || || || || || ||
|Carrier DUs Shipped
|CARRIER_DUS_SHIPPED
|DP_CSV5.CARRIER_DUS_SHIPPED
|}
|}
==Customer Invoice Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Invoice No ||M || || || || || ||
|Carrier ||O ||STRING ||ALL || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
|}


==Cut Offs Extract==
==Carrier Delivery Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Carrier Delivery  Report
|Carrier_Delivery_Report
|DP_CSV5.CARRIER_DELIVERY
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|End Schedule ||M || || || || || ||
|Sched Name ||M || || || || || ||
|-
|Carrier ||M || || || || || ||
|-
|-
|Customer ||0 || || || || || ||
|Depot ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Trip ID ||O ||STRING ||ALL || || || ||
|}
|}


==DELIVERY_OVERVIEW==
==Carrier Invoice==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Schedule ||M || || || || || ||
|Carrier Invoice
|Carrier_Invoice
|CSV.CARRIER_INVOICE
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Invoice No ||M || || || || || ||
|-
|Credit Acc ||M || || || || || ||
|-
|Debit Acc ||M || || || || || ||
|-
|-
|To Schedule ||M || || || || || ||
|Invoice No ||M || || || || || ||
|-
|-
|Owning Depot ||O || || || || || ||
|Credit Acc ||M || || || || || ||
|-
|-
|POD Confirmed ||O || || || || || ||
|Debit Acc ||M || || || || || ||
|}
|}


==DOOD Rpt==
==Carrier Self Billing==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Carrier Self  Billing
|Carrier_Self_billing
|DP_CSV_BNL.CARRIER_SELF_BILLING
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule To ||M || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Carrier ||0 || || || || || ||
|-
|-
|Customer ||O ||STRING ||OPENFIELD || || || ||
|Start Schedule ||M || || || || || ||
|}
|}


==DUs Despatched==
==Catalyst Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Catalyst Extract
|CATALYST_EXTRACT
|CSV.CATALYST_EXTRACT
|}
Parameters:
Parameters:
==Co-ordinate Non-Conformities==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Consignment Num ||O ||STRING || || || || ||
!'''Procedure for Scheduling'''
|-
|-
|Start Sched ||O || || || || || ||
|Co-ordinate  Non-Conformities
|Co_Ord_Non_Conf
|DP_CSV6.CO_ORD_NON_CONFORM
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Schedule ||M || || || || || ||
|-
|Discrepancy Dist ||0 || ||1 || || || ||
|-
|-
|Manifest ||O ||STRING || || || || ||
|TomTom,Epod,Both ||M || ||B || || || ||
|-
|-
|PO Number ||O ||STRING || || || || ||
|Driver ||O || || || || || ||
|-
|-
|Supplier ||O || || || || || ||
|Depot ||O || || || || || ||
|-
|-
|End Sched ||O || || || || || ||
|End Schedule ||M || || || || || ||
|}
|}


==DUs Not Loaded==
==Commercial==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Commercial
|COMMERCIAL
|CSV.Commercial_Orders
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Store ||O || || ||Store ||Location ID ||Name ||
|-
|-
|Schedule ||M || || || || || ||
|Schedule ||M || || || || || ||
|}
|}


==DUs Not Received
==Compliance Report==
|-
{| class="wikitable"
|To Date ||M || || || || || ||
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M || || || || || ||
|Compliance Report
|COMPLIANCE_REPORT
|DP_CSV_DUN.COMPLIANCE_REPORT
|}
|}
==Daily Manifest E-OT-L==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M || || || || || ||
|Collection Date ||M || || || || || ||
|-
|}
|To Date ||M || || || || || ||
 
==Concurrent Logon Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|Concurrent Logon  Export
|-
|Concurrent_Logon_Export
|Start Schedule ||M || || || || || ||
|CSV.Concurrent_Logon
|}
|}
==Daily Transport Plan==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Order Status ||M ||STRING ||ALL || || || ||
|From Date ||O ||TODAY || || || || ||
|-
|-
|Supplier ||M ||STRING ||ALL || || || ||
|To Date ||O ||TODAY || || || || ||
|-
|}
|To Date ||M || || || || || ||
 
== Contracts ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M || || || || || ||
|Contracts
|CONTRACTS
|CSV.CONTRACTS
|}
|}
No Parameters


==Daily Unscheduled Orders==
==Cross Dock==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M || || || || || ||
|Cross Dock
|-
|CROSS_DOCK
|From Date ||M || || || || || ||
|DP_CSV6.CROSS_DOCK
|}
|}
==Debrief Performance==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier Code ||O || || || || || ||
|Media Type ||O ||STRING || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Route ||O ||STRING || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|Cust Group ||O || || || || || ||
|Dealer ||O ||STRING || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Depot ||O ||STRING || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Customer ||O ||STRING || || || || ||
|}
|}


==Del Scans==
==Customer Invoice==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|Customer Invoice
|-
|Customer_Invoice
|Start Schedule ||M || || || || || ||
|CSV.Customer_Invoice
|}
|}
==Delivery Conf==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Type ||M || ||M || || || ||
|Invoice No ||M || || || || || ||
|-
|Credit Acc ||M || || || || || ||
|-
|-
|Owning Depot ||O || || || || || ||
|Debit Acc ||M || || || || || ||
|-
|-
|Cost Centre ||M || || || || || ||
|Invoice No ||M || || || || || ||
|-
|-
|To Actual date ||M ||TODAY || || || || ||
|Debit Acc ||M || || || || || ||
|-
|-
|From Actual date ||M ||TODAY || || || || ||
|Credit Acc ||M || || || || || ||
|}
|}


==Delivery Schedule Extract==
==Customer Invoice By Dates==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Show Dates ||Y || || || || || ||
|Customer Invoice By  Dates
|Customer_Invoice_By_Dates
|CSV.Customer_Invoice_By_Dates
|}
|}
==Depot Exits by Hour (Loads)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Payment Status ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Customer ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|From Date ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|To Date ||M || || || || || ||
|}
 
==Customer Invoice Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M ||TODAY || || || || ||
|Customer Invoice  Extract
|-
|Customer_Invoice
|Depot ||M || || ||Depot ||Location Id ||Name ||
|CSV.Customer_Invoice
|}
|}
==Detailed Interface Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer Group ||O || || || || || ||
|Invoice No ||M || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Credit Acc ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Debit Acc ||M || || || || || ||
|-
|}
|From Date ||O ||TODAY || || || || ||
 
==Cut Offs Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Status ||M ||STRING ||All || || || ||
|Cut Offs Extract
|Cut_offs_extract
|DP_CSV6.CUT_OFF_EXTRACT
|}
|}
==Dixons Catalyst Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
Line 842: Line 1,229:
|End Schedule ||M || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Customer ||0 || || || || || ||
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|-
|Start Schedule ||M || || || || || ||
|Start Schedule ||M || || || || || ||
|}
|}


==Dixons Order Export==
==D365 Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||O ||TODAY || || || || ||
|D365 Extract
|-
|DP_FINANCE.D365_EXPORT
|Carrier ||O || || || || || ||
|D365_EXPORT_
|-
|To Date ||O ||TODAY || || || || ||
|}
|}
==Dixons Trip Extract==
Parameters:
Parameters:
==DELIVERY_OVERVIEW==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|DELIVERY_OVERVIEW
|-
|DELIVERY_OVERVIEW
|To Date ||O ||TODAY || || || || ||
|dp_csv3.delivery_overview
|-
|From Date ||O ||TODAY || || || || ||
|}
|}
==Driver Hours==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Schedule ||M || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|To Schedule ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Owning Depot ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|POD Confirmed ||O || || || || || ||
|}
|}


==Driver Scanning==
==DOOD Rpt==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DOOD Rpt
|DOOD_RPT
|dp_csv_dood.dood_rpt
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O ||STRING || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|Depot ||O ||STRING || || || || ||
|Customer ||O ||STRING ||OPENFIELD || || || ||
|-
|}
|Route ||O ||STRING || || || || ||
 
|-
==DUs Despatched==
|Media Type ||O ||STRING || || || || ||
{| class="wikitable"
|-
!'''Report Name'''
|Schedule To ||M || || || || || ||
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule From ||M || || || || || ||
|DUs Despatched
|-
|DUS_DESPATCHED_EXTRACT
|Activity ||O ||STRING || || || || ||
|DP_CSV_GEN.DUS_DESPATCHED_EXTRACT
|}
|}
==Dunelm Backing Sheet==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Manifest ||O || || || || || ||
|Consignment Num ||O ||STRING || || || || ||
|-
|Start Sched ||O || || || || || ||
|-
|Manifest ||O ||STRING || || || || ||
|-
|-
|Customer ||M || || || || || ||
|PO Number ||O ||STRING || || || || ||
|-
|-
|Sched To ||M || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|Sched From ||M || || || || || ||
|End Sched ||O || || || || || ||
|}
|}


==Dunelm Inventory Transactions==
==DUs Not Loaded==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DUs Not Loaded
|DUS_NOT_LOADED_EXTRACT
|DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Delivery Trip ||O || || || || || ||
|Store ||O || || ||Store ||Location ID ||Name ||
|-
|-
|Trunk Trip ||O || || || || || ||
|Schedule ||M || || || || || ||
|}
 
== DUs Not Received ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Collection Trip ||O || || || || || ||
|DUs Not Received
|DUS_NOT_RECEIVED_EXTRACT
|DP_CSV_GEN.DAILY_EXT_NOT_RECD
|}
Parameters:
 
|-
|-
|Store ||O || || || || || ||
|To Date ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|From Date ||M || || || || || ||
|-
|}
|Date Type ||M ||STRING ||C || || || ||
 
|-
==Daily Manifest E-OT-L==
|To Date ||M ||TODAY ||TODAY:23:59 || || || ||
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY ||TODAY:00:00 || || || ||
|Daily Manifest  E-OT-L
|DAILY_MANIFEST_E_OT_L_EXTRACT
|DP_CSV_GEN.DAILY_EXT_MANIFEST
|}
|}
==Dunelm Item Movements 3==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Manifest Number ||O || || || || || ||
|From Date ||M || || || || || ||
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|To Date ||M || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|DU Type ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|Supplier ||O || || || || || ||
|-
|P/O Number ||O || || || || || ||
|-
|Store ||O || || || || || ||
|}
|}


==Dunelm Item Movements Extract==
==Daily Receiving E-OT-L==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Daily Receiving  E-OT-L
|RECEIVING_E_OT_L_EXTRACT
|DP_CSV_GEN.DAILY_EXT_RECEIPTING
|}
Parameters:
==Daily Transport Plan==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Daily Transport  Plan
|DAILY_TRANSPORT_PLAN_EXTRACT
|DP_CSV_GEN.DAILY_TRANSPORT_PLAN
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Manifest Number ||O ||STRING || || || || ||
|Order Status ||M ||STRING ||ALL || || || ||
|-
|-
|P/O Number ||O || || || || || ||
|Supplier ||M ||STRING ||ALL || || || ||
|-
|-
|Store ||O || || || || || ||
|To Date ||M || || || || || ||
|-
|-
|DU Type ||O || || || || || ||
|From Date ||M || || || || || ||
|}
 
==Daily Unscheduled Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Supplier ||O || || || || || ||
|Daily Unscheduled  Orders
|DAILY_UNSCHEDULED_ORDERS_EXTRACT
|DP_CSV_GEN.DAILY_UNSCHED_ORD
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|To Date ||M || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|From Date ||M || || || || || ||
|}
|}


==Dunelm Item Movements Extract New==
==Debrief Performance==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Debrief Performance
|debrief_performance
|dp_csv_nr.debrief_performance
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|P/O Number ||O || || || || || ||
|Carrier Code ||O || || || || || ||
|-
|-
|Manifest Number ||O ||STRING || || || || ||
|Carrier Group ||O || || || || || ||
|-
|-
|Store ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|DU Type ||O || || || || || ||
|Cust Group ||O || || || || || ||
|-
|-
|Supplier ||O || || || || || ||
|Cost Centre ||O || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
|}


==Dunelm Left Offs==
==Del Scans==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Trip Id (Optional) ||O || || || || || ||
!'''Procedure for Scheduling'''
|-
|Days Back ||M ||STRING ||30 || || || ||
|-
|-
|Store (Optional) ||O || || ||Store ||Location Id ||Name ||
|Del Scans
|DEL_SCANS
|DP_CSV6.DEL_SCANS
|}
|}
==Dunelm Manual Loaded Items Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|To Date ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|}
|}


==Dunelm Supplier Trends Extract==
==Delivery Conf==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Year ||M || || || || || ||
|Delivery Conf
|-
|BGYP_DELCONF_
|Week ||M || || || || || ||
|DP_CSV5.DELIVERY_CONF
|}
|}
==Duplicate Postcodes==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Ignore Inactive? ||O || || || || || ||
|Type ||M || ||M || || || ||
|-
|Owning Depot ||O || || || || || ||
|-
|Cost Centre ||M || || || || || ||
|-
|-
|Location From ||O || || ||Location From ||Location Id ||Location Name ||
|To Actual date ||M ||TODAY || || || || ||
|-
|-
|Location To ||O || || ||Location To ||Location Id ||Location Name ||
|From Actual date ||M ||TODAY || || || || ||
|}
|}


==ERC==
==Delivery Schedule Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Delivery Schedule  Extract
|Delivery_Schedule
|DP_CSV_DHL.DELIVERY_SCHEDULE
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Sched End ||M || || || || || ||
|Show Dates ||Y || || || || || ||
|}
 
==Depot Exits by Hour (Loads)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Sched Start ||M || || || || || ||
|Depot Exits by Hour  (Loads)
|-
|DEPOT_EXITS_LOADS
|Carrier ||O || || || || || ||
|CSV.DEPOT_EXITS_BY_HOUR_LOADS
|-
|DHL Carriers ||M || || || || || ||
|-
|Detail Level ||M || || || || || ||
|}
|}
==Equipment Moves==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Owning Depot ||O || || || || || ||
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|Customer ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
Line 1,078: Line 1,541:
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|}
|}


==Extract Lane==
==Depot Exits by Hour (RPEs)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Depot Exits by Hour  (RPEs)
|DEPOT_EXITS_RPE
|CSV.DEPOT_EXITS_BY_HOUR_RPE
|}
Parameters:
Parameters:
==Detailed Interface Report==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Cost Centre ||O || || ||Cost Centre ||Location Id ||Name ||
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|Detailed Interface  Report
|Detailed_Interface_Report
|CSV.Detailed_Interface_Report
|}
|}
==Failed Shipment==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule To ||M || || || || || ||
|Customer Group ||O || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|Customer ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|From Date ||O ||TODAY || || || || ||
|-
|-
|Customer ||O ||STRING ||OPENFIELD || || || ||
|Status ||M ||STRING ||All || || || ||
|}
|}


==Fixed Routes Extract==
==Dixons Catalyst Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dixons Catalyst  Report
|fn
|CSV.Dixons_Catalyst_Report
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Show Active / Inactive ||M ||STRING ||B || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|Start Schedule ||M || || || || || ||
|}
|}


==GREENE KING Interface Results==
==Dixons Order Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dixons Order Export
|Dixons_Order_Export
|CSV.Dixons_Order_Export
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|From Date ||O ||TODAY || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|}
 
==Dixons Trip Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dixons Trip Extract
|Dixons_Trip_Extract
|CSV.Dixons_Trip_Extract
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Depot ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|To Date ||O ||TODAY || || || || ||
Line 1,129: Line 1,647:
|}
|}


==GYP EFX Export==
==Driver Hours==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Driver Hours
|driver_hours
|dp_csv_nr.driver_hours
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Trip Status ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|To Schedule ||M || || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|From Schedule ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Cost Centre ||O || || || || || ||
|}
==Driver Scanning==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer Group ||O || || || || || ||
|Driver Scanning
|DRIVER_SCANNING
|DP_CSV6.DRIVER_SCANNING
|}
|}
==HC Booking In Form==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|Customer ||O ||STRING || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Dealer ||O ||STRING || || || || ||
|-
|-
|Delivery Location ||O || || || || || ||
|Depot ||O ||STRING || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Route ||O ||STRING || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Media Type ||O ||STRING || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|Delivery Location ||O || || || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Activity ||O ||STRING || || || || ||
|}
|}


==HC Haulier Trip Sheet==
==Dunelm Actual Load==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Actual Load
|DUNELM_ACTUAL_LOAD
|DP_CSV_DUN.daily_ext_load
|}
Parameters:
Parameters:
==Dunelm Actual Unload==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Dunelm Actual  Unload
|DUNELM_ACTUAL_UNLOAD
|DP_CSV_DUN.daily_ext_unload
|}
Parameters:
==Dunelm Backing Sheet==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Owning Depot ||O || || ||Depot ||Location Id ||Name ||
|Dunelm Backing  Sheet
|BACKING_SHEET
|DP_CSV2.BACKING_SHEET
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|Manifest ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Customer ||M || || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Sched To ||M || || || || || ||
|-
|-
|Load Location ||O || || ||Loading Location ||Location Id ||Name ||
|Sched From ||M || || || || || ||
|}
 
== Dunelm DUs Despatched Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Owning Depot ||O || || ||Depot ||Location Id ||Name ||
|Dunelm DUs  Despatched Extract
|DUNELM_DUS_DESPATCHED_EXTRACT
|DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT
|}
Parameters:
 
== Dunelm DUs Not Loaded Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Dunelm DUs Not  Loaded Extract
|DUNELM_DUS_NOT_LOADED_EXTRACT
|DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT
|}
Parameters:
 
== Dunelm DUs Not Received ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|Dunelm DUs Not  Received
|DUNELM_DUS_NOT_RECEIVED
|DP_CSV_DUN.daily_ext_not_recd
|}
Parameters:
 
== Dunelm Inventory Transactions ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|Dunelm Inventory  Transactions
|-
|DUN_INVENTORY_TRANS
|Group Name ||O || || || || || ||
|DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS
|-
|Load Location ||O || || ||Loading Location ||Location Id ||Name ||
|}
|}
==HCR Customer Orders==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Delivery Trip ||O || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Trunk Trip ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Collection Trip ||O || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|Store ||O || || || || || ||
|}
|-
|Customer ||O || || || || || ||
|-
|Date Type ||M ||STRING ||C || || || ||
|-
|To Date ||M ||TODAY ||TODAY:23:59 || || || ||
|-
|From Date ||M ||TODAY ||TODAY:00:00 || || || ||
|}


==HCR Loading Sheet CSV==
==Dunelm Item Movements 3==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Item  Movements 3
|DUN_ITEM_MOVEMENTS_EXTRACT
|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Manifest Number ||O || || || || || ||
|-
|-
|Load Location ||O || || ||Loading Location ||Loading Location ||Name ||
|Actual To Date ||M ||TODAY || || || || ||
|-
|-
|Owning Depot ||O || || ||Depot ||Loading Location ||Name ||
|Actual From Date ||M ||TODAY || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|DU Type ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|P/O Number ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Store ||O || || || || || ||
|}
 
==Dunelm Item Movements Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group Name ||O || || || || || ||
|Dunelm Item  Movements Extract
|DUN_ITEM_MOVEMENTS_EXTRACT
|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT
|}
|}
==Haulier Invoice==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|End Date ||O || || || || || ||
|Manifest Number ||O ||STRING || || || || ||
|-
|P/O Number ||O || || || || || ||
|-
|-
|Start Date ||O || || || || || ||
|Store ||O || || || || || ||
|-
|-
|Invoice ID ||O ||STRING || || || || ||
|DU Type ||O || || || || || ||
|-
|-
|End Date ||O || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|Start Date ||O || || || || || ||
|Actual To Date ||M ||TODAY || || || || ||
|-
|-
|Invoice ID ||O ||STRING || || || || ||
|Actual From Date ||M ||TODAY || || || || ||
|}
|}


==Heavy Vehicle Utilisation==
==Dunelm Item Movements Extract New==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Start Schedule ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|Dunelm Item  Movements Extract New
|-
|DUN_ITEM_MOVEMENTS_EXTRACT
|Customer Group ||O || || || || || ||
|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2
|}
|}
==Historical Lane Based Orders==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||O ||TODAY || || || || ||
|P/O Number ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Manifest Number ||O ||STRING || || || || ||
|}
 
==IND Trip and Order Detail==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|Store ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|DU Type ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|Loaded At ||O || || || || || ||
|Actual From Date ||M ||TODAY || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Actual To Date ||M ||TODAY || || || || ||
|}
 
==Dunelm Left Offs==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group Name ||M || || || || || ||
|Dunelm Left Offs
|Left_Offs_Extract
|DP_CSV_DUN.left_offs_extract
|}
|}
==ISC Finance (2) Export==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||M ||STRING ||ALL || || || ||
|Trip Id (Optional) ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Days Back ||M ||STRING ||30 || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Store (Optional) ||O || || ||Store ||Location Id ||Name ||
|}
|}


==Interface Errors Failures==
==Dunelm Loading Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|External Ref ||O ||STRING || || || || ||
!'''Procedure for Scheduling'''
|-
|Customer ||O || || ||Customer || || ||
|-
|-
|Source System ||O || || || || || ||
|Dunelm Loading  Extract
|-
|DUNELM_LOADING_EXTRACT
|End Date ||M ||TODAY || || || || ||
|DP_CSV2.DUN_LOADING
|-
|Start Date ||M ||TODAY || || || || ||
|}
|}
==Invalid Orders==
Parameters:
Parameters:
==Dunelm Manifest E-OT-L Extract==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|Dunelm Manifest  E-OT-L Extract
|DUNELM_MANIFESTED_EOL
|DP_CSV_DUN.daily_ext_manifest
|}
Parameters:
==Dunelm Manual Loaded Items Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|Dunelm Manual  Loaded Items Extract
|-
|MANL_SCAN_ORDER_DETAIL_EXTRACT
|Customer ||0 || || || || || ||
|DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT
|}
|}
==Item Movements==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|From Date ||O || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|To Date ||O || || || || || ||
|}
 
== Dunelm Receiving Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Supplier ||O || || || || || ||
|Dunelm Receiving  Extract
|DUNELM_RECEIVING_EXTRACT
|DP_CSV2.DUN_RECEIVING
|}
Parameters:
 
== Dunelm Recieving E-OT-L Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|DU Type ||O || || || || || ||
|Dunelm Recieving  E-OT-L Extract
|-
|DUNELM_RECEIPTED_EOL
|Store ||O || || || || || ||
|DP_CSV_DUN.daily_ext_receipting
|}
Parameters:
 
== Dunelm Supplier DU Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Manifest Number ||O || || || || || ||
|Dunelm Supplier DU  Extract
|-
|DUNELM_SUPPLIER_DU_EXTRACT
|P/O Number ||O || || || || || ||
|DP_CSV2.DUN_SUPPLIER_DU_EXTRACT
|}
|}
Parameters:


==Item Movements 2==
== Dunelm Supplier DU Extract by Store ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|DU Type ||O || || || || || ||
|Dunelm Supplier DU Extract by Store
|DUNELM_DU_STORE_EXTRACT
|DP_CSV2.DUN_DU_STORE_EXTRACT
|}
Parameters:
 
== Dunelm Supplier Revenue Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Supplier ||O || || || || || ||
|Dunelm Supplier Revenue Extract
|DUNELM_SUPPLIER_REVENUE_EXTRACT
|DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT
|}
Parameters:
 
== Dunelm Supplier Revenue Extract New ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|Dunelm Supplier  Revenue Extract New
|DUNELM_SUPPLIER_REVENUE_NEW
|DP_CSV2.DUN_SUPPLIER_REVENUE_NEW
|}
Parameters:
 
== Dunelm Supplier Trends Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|Dunelm Supplier  Trends Extract
|DUN_SUPPLIER_TRENDS
|dp_csv_dun.dun_du_rpe_revenue_extract
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|P/O Number ||O || || || || || ||
|Year ||M || || || || || ||
|-
|-
|Store ||O || || || || || ||
|Week ||M || || || || || ||
|}
 
==Dunelm Transport Plan==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Manifest Number ||O || || || || || ||
|Dunelm Transport  Plan
|DUNELM_TRANSPORT_PLAN
|DP_CSV_DUN.daily_transport_plan
|}
|}
Parameters:


==Item Movements 3==
== Dunelm Unsched Orders ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Unsched  Orders
|DUNELM_UNSCHED_ORD
|DP_CSV_DUN.daily_unsched_ord
|}
Parameters:
Parameters:
==Duplicate Postcodes==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|P/O Number ||O || || || || || ||
|Duplicate Postcodes
|-
|DUPLICATE_POSTCODES
|Store ||O || || || || || ||
|dp_csv2.duplicate_postcodes_extract
|-
|Manifest Number ||O || || || || || ||
|-
|DU Type ||O || || || || || ||
|-
|Supplier ||O || || || || || ||
|-
|Actual To Date ||M ||TODAY || || || || ||
|-
|Actual From Date ||M ||TODAY || || || || ||
|}
|}
==Items Not Scanned By Date==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule To ||M || || || || || ||
|Ignore Inactive? ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Location From ||O || || ||Location From ||Location Id ||Location Name ||
|-
|-
|Depot ||M || || || || || ||
|Location To ||O || || ||Location To ||Location Id ||Location Name ||
|}
|}


==Items Not Scanned By Trip==
==EFX Inbound Errors==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|EFX Inbound Errors
|EFX_Inbound_Errors
|DP_CSV2.EFX_In_Errs_Extract
|}
Parameters:
Parameters:
==ERC==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Trip ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|ERC
|ERC
|DP_CSV_DHL.ERC
|}
|}
==JEYES Interface Results==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||O ||TODAY || || || || ||
|Sched End ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Sched Start ||M || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|DHL Carriers ||M || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Detail Level ||M || || || || || ||
|}
|}


==KPI By Lane==
==Equipment Moves==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Equipment Moves
|Equip_Move
|DP_CSV2.EQUIP_MOVE
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer Group ||O || || || || || ||
|Owning Depot ||O || || || || || ||
|-
|-
|End Date ||M || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Show Detail ||M ||STRING ||Y || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|End Date ||M ||TODAY || || || || ||
|Carrier ||O || || || || || ||
|-
|Start Date ||M ||TODAY || || || || ||
|-
|Start Date ||M || || || || || ||
|-
|Tolerance(days) ||O || || || || || ||
|-
|Separate Pages ||M ||STRING ||N || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|}
|}


==Kraft KPI==
==Extract Lane==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Extract Lane
|-
|EXTRACT_LANE
|To Date ||M ||TODAY || || || || ||
|CSV.EXTRACT_BY_LANE
|-
|Cost Centre ||O || || || || || ||
|}
|}
==LFS Packages==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|Cost Centre ||O || || ||Cost Centre ||Location Id ||Name ||
|-
|-
|Order Status ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|}
|Customer ||O || || || || || ||
 
==Failed Shipment==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|External Ref ||O || || || || || ||
|
|
|
|}
|}
==Lane Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|To Loc ||O || || ||To Loc ||Location Id ||Name ||
|Customer ||O ||STRING ||OPENFIELD || || || ||
|}
 
==Fixed Routes Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Loc ||O || || ||From Loc ||Location Id ||Name ||
|
|
|
|}
|}
==Left Offs==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Store (optional) ||O || || ||Store ||Location ID ||Name ||
|Show Active / Inactive ||M ||STRING ||B || || || ||
|-
|-
|Days Back ||M ||STRING ||30 || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Depot ||O || || ||Depot ||Location Id ||Name ||
|}
|}


==Loading Extract==
==GREENE KING Interface Results==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|
|
|
|}
|}
==Loading Schedule CSV==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Customer ||O || || || || || ||
|-
|Depot ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||O ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||O ||TODAY || || || || ||
|}
|}


==Location Export==
==GYP EFX Export==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Country ||O || || || || || ||
|
|
|
|}
|}
==Location Pre-Warning==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Load Type ||M ||STRING ||ALL || || || ||
|Trip Status ||O || || || || || ||
|-
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|To Schedule ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|From Schedule ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Cost Centre ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Customer Group ||O || || || || || ||
|}
 
==HC Booking In Form==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Group Name ||O || || || || || ||
|-
|Delivery Location ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Group Name ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Schedule ||M || || || || || ||
|-
|-
|Load Type ||M ||STRING ||ALL || || || ||
|Delivery Location ||O || || || || || ||
|-
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|Customer ||O || || || || || ||
|}
|}


==MDD Code 03 Exceptions==
==HC Haulier Trip Sheet==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|
|-
|
|To Date ||M ||TODAY || || || || ||
|
|}
|}
==Manual Loaded Items==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||O || || || || || ||
|Trip ID (optional) ||O || || || || || ||
|-
|-
|To Date ||O || || || || || ||
|Owning Depot ||O || || ||Depot ||Location Id ||Name ||
|}
|-
 
|Schedule ||M || || || || || ||
==Master and Child Locations==
|-
Parameters:
|Carrier ||O || || || || || ||
{| class="wikitable"
|-
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|Group Name ||O || || || || || ||
|-
|Load Location ||O || || ||Loading Location ||Location Id ||Name ||
|-
|Owning Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|Trip ID (optional) ||O || || || || || ||
|-
|Schedule ||M || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|-
|Show UnMapped ||O || || ||Show UnMapped || || ||
|Group Name ||O || || || || || ||
|-
|-
|Show Mapped ||O || || ||Show Mapped || || ||
|Load Location ||O || || ||Loading Location ||Location Id ||Name ||
|}
|}


==Message Maintenance== || || || || || || || || ||
==HCR Customer Orders==
|}
 
==Missing Lat Long Report==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cost Centre ||M || ||ALL || || || ||
|
|
|
|}
|}
==Missing Steps Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||M ||TODAY || || || || ||
|Customer ||O || || || || || ||
|-
|Schedule ||M || || || || || ||
|-
|-
|Missing Step ||O ||STRING ||ALL || || || ||
|Cost Centre ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Depot ||O || || || || || ||
|}
|}


==Month End Accruals==
==HCR Loading Sheet CSV==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|Trip ID (optional) ||O || || || || || ||
|-
|Load Location ||O || || ||Loading Location ||Loading Location ||Name ||
|-
|Owning Depot ||O || || ||Depot ||Loading Location ||Name ||
|-
|Schedule From ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Cust Group ||O || || || || || ||
|Group Name ||O || || || || || ||
|}
|}


==NR Finance Extract==
==Haulier Invoice==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|End Date ||O || || || || || ||
|-
|-
|Debriefed ||M || || || || || ||
|Start Date ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Invoice ID ||O ||STRING || || || || ||
|-
|-
|To Region ||M ||STRING ||ALL || || || ||
|End Date ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Start Date ||O || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Invoice ID ||O ||STRING || || || || ||
|}
 
==Heavy Vehicle Utilisation==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Strategy ||O || || || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Cost Centre ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|From Region ||M ||STRING ||ALL || || || ||
|Customer Group ||O || || || || || ||
|}
|}


==NR Invoice==
==Historical Lane Based Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||O ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
==IND Trip and Order Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Debriefed ||M || || || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|Activity ||M ||STRING ||Both || || || ||
|-
|-
|To Region ||M ||STRING ||ALL || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|From Region ||M ||STRING ||ALL || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Loaded At ||O || || || || || ||
|-
|-
|Strategy ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Group Name ||M || || || || || ||
|}
 
==ISC Finance (2) Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cost Centre ||O || || || || || ||
|
|
|
|}
|}
==OTM Export==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Date To ||M ||TODAY || || || || ||
|Customer ||M ||STRING ||ALL || || || ||
|-
|-
|Date From ||M ||TODAY || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|}
|}


==On Time Arrivals==
==Interface Errors Failures==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Outbase ||O || || || || || ||
|External Ref ||O ||STRING || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Customer ||O || || ||Customer || || ||
|-
|-
|Route Code ||O || || || || || ||
|Source System ||O || || || || || ||
|-
|-
|Dealer ||O || || || || || ||
|End Date ||M ||TODAY || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Start Date ||M ||TODAY || || || || ||
|}
 
==Invalid Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule To ||M || || || || || ||
|
|-
|
|Schedule From ||M || || || || || ||
|
|}
|}
==On Time Drops==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Outbase ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Customer ||0 || || || || || ||
|-
|}
|Schedule To ||M || || || || || ||
 
==Item Movements==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|
|-
|
|Schedule From ||M || || || || || ||
|
|-
|Dealer ||O || || || || || ||
|}
|}
==On Time Items==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Dealer ||O || || || || || ||
|Actual To Date ||M ||TODAY || || || || ||
|-
|-
|Outbase ||O || || || || || ||
|Actual From Date ||M ||TODAY || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|DU Type ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Store ||O || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Manifest Number ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|P/O Number ||O || || || || || ||
|}
|}


==On Time Items (Assets)==
==Item Movements 2==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule From ||M || || || || || ||
|DU Type ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|Dealer ||O || || || || || ||
|Actual From Date ||M ||TODAY || || || || ||
|-
|-
|Outbase ||O || || || || || ||
|Actual To Date ||M ||TODAY || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|P/O Number ||O || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Store ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Manifest Number ||O || || || || || ||
|}
|}


==On Time Returns==
==Item Movements 3==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Media Type ||O || || || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|P/O Number ||O || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Store ||O || || || || || ||
|-
|-
|Outbase ||O || || || || || ||
|Manifest Number ||O || || || || || ||
|-
|-
|Dealer ||O || || || || || ||
|DU Type ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Actual To Date ||M ||TODAY || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Actual From Date ||M ||TODAY || || || || ||
|}
|}


==Order Charges Extract==
==Items Not Scanned By Date==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Date ||M ||TODAY || || || || ||
|
|
|
|}
|}
==Order Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|End Sched ||M || || || || || ||
|Schedule To ||M || || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|-
|Start Sched ||M || || || || || ||
|Depot ||M || || || || || ||
|}
|}


==Order Interface Results==
==Items Not Scanned By Trip==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||O ||TODAY || || || || ||
|Trip ||M || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Schedule ||M || || || || || ||
|}
 
==JEYES Interface Results==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Depot ||O || || || || || ||
|
|-
|
|Message Type ||O || || || || || ||
|
|}
|}
==Order Items POD Debriefed==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date ||O ||TODAY || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|Depot ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|From Date ||O ||TODAY || || || || ||
|}
|}


==Order Savings==
==KPI By Lane==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|
|-
|
|End Schedule ||O || || || || || ||
|
|-
|Show Neg Savings ||M || || || || || ||
|}
|}
==Order Tracking==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O ||STRING ||OPENFIELD || || || ||
|Customer Group ||O || || || || || ||
|-
|End Date ||M || || || || || ||
|-
|Show Detail ||M ||STRING ||Y || || || ||
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|-
|End Date ||M ||TODAY || || || || ||
|-
|Start Date ||M ||TODAY || || || || ||
|-
|Start Date ||M || || || || || ||
|-
|-
|Month ||M || || || || || ||
|Tolerance(days) ||O || || || || || ||
|-
|-
|Week Offset ||O || || || || || ||
|Separate Pages ||M ||STRING ||N || || || ||
|-
|-
|Year ||M || || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|Cost Centre ||O ||STRING ||OPENFIELDCC || || || ||
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|}
|}


==Orders for Relabelling==
==Kraft KPI==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|
|}
|
 
|
==Orders to LogiX== || || || || || || || || ||
|}
|}
==Orders to Paragon==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||O || || || || || ||
|}
|}


==Outbound Shortage==
==LFS Packages==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule To ||M || || || || || ||
|Schedule ||M || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Order Status ||O || || || || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Media Type ||O ||STRING || || || || ||
|External Ref ||O || || || || || ||
|-
|}
|Route ||O ||STRING || || || || ||
 
|-
==Lane Extract==
|Depot ||O ||STRING || || || || ||
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O ||STRING || || || || ||
|
|
|
|}
|}
==PAYMENT_DTLS==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|End Date ||M ||TODAY || || || || ||
|Customer ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|To Loc ||O || || ||To Loc ||Location Id ||Name ||
|-
|-
|Customer ||M || || || || || ||
|From Loc ||O || || ||From Loc ||Location Id ||Name ||
|}
|}


==POC to SAP Extract==
==Left Offs==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Store (optional) ||O || || ||Store ||Location ID ||Name ||
|-
|Days Back ||M ||STRING ||30 || || || ||
|-
|Trip ID (optional) ||O || || || || || ||
|}
|}


==POC to SAP Extract(A)==
==Loading Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Resend All? ||M ||STRING ||No || || || ||
|Schedule ||M || || || || || ||
|}
|}


==POD Delivery Extract==
==Loading Schedule CSV==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Schedule ||M || || || || || ||
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|To Schedule ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Del Msg Sent ||O ||STRING ||ALL || || || ||
|From Date ||M ||TODAY || || || || ||
|}
 
==Location Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|POD Status ||O ||STRING ||ALL || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O ||STRING ||ALL || || || ||
|Country ||O || || || || || ||
|-
|}
|> Days Outstanding ||O ||STRING ||0 || || || ||
 
==Location Pre-Warning==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group ||O ||STRING ||ALL || || || ||
|
|-
|
|Customer ||O ||STRING ||ALL || || || ||
|
|-
|Scanning Depot ||O ||STRING ||ALL ||Depot ||Location Id ||Name ||
|}
|}
==POD Generation Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|POD Flow ||M || || || || || ||
|Load Type ||M ||STRING ||ALL || || || ||
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|Date To ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Date From ||M ||TODAY || || || || ||
|Load Type ||M ||STRING ||ALL || || || ||
|-
|-
|Schedule ||O || || || || || ||
|Trip Status ||M ||STRING ||ALL || || || ||
|}
|}


==POD to SAP Extract==
==MDD Code 03 Exceptions==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|}
|}


==POD to SAP Extract(A)==
==Manual Loaded Items==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Resend All? ||M ||STRING ||No || || || ||
|
|
|
|}
|}
==PORSCHE19 Invoice Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||M ||STRING ||PORSCHE19 || || || ||
|From Date ||O || || || || || ||
|-
|-
|Sub Debit Account ||O ||STRING ||ALL || || || ||
|To Date ||O || || || || || ||
|-
|Trip ID ||O ||STRING ||ALL || || || ||
|-
|Sub Credit Account ||O ||STRING ||ALL || || || ||
|-
|Invoice ID ||O ||STRING ||0 || || || ||
|-
|Export ID ||O ||STRING ||0 || || || ||
|}
|}


==PROVIDER_REVENUE== || ||Owning Depot ||O || || || || || ||
==Master and Child Locations==
|-
{| class="wikitable"
|To Schedule ||M || || || || || ||
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Schedule ||M || || || || || ||
|
|
|
|}
|}
==Parts and Empites==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Export Type ||M || || || || || ||
|Show UnMapped ||O || || ||Show UnMapped || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Show Mapped ||O || || ||Show Mapped || || ||
|-
|}
|Schedule To ||M || || || || || ||
 
|-
== Message Maintenance ==
|Location From ||O || || || || || ||
== || || || || || || || || ||
|-
|Customer ||M || || || || || ||
|}
|}


==PostCode Matrix==
==Missing Lat Long Report==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|
|
|
|}
|}
==Pre Invoice Check==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Cut-off Date ||M ||TODAY || || || || ||
|Cost Centre ||M || ||ALL || || || ||
|}
|}


==Process Items Interface Audit==
==Missing Steps Report==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Incl. Reprocessed ||M ||STRING ||N || || || ||
!'''Procedure for Scheduling'''
|-
|-
|Start Date ||M ||TODAY || || || || ||
|
|-
|
|End Date ||M ||TODAY || || || || ||
|
|-
|Record Status ||M ||STRING ||ALL || || || ||
|}
|}
==Provisional Booking Exceptions==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
Line 2,062: Line 3,010:
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|Missing Step ||O ||STRING ||ALL || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
|}


==Purchase Order Extract==
==Month End Accruals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Status ||O ||STRING ||All || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|To Date ||O ||TODAY ||TODAY || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|-
|From Date ||O ||TODAY ||TODAY || || || ||
|Cust Group ||O || || || || || ||
|}
|}


==Reason Listings==
==NR Finance Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Date From ||M ||DATETIME ||TODAY:00:01 || || || ||
|
|-
|
|Depot ||M || || || || || ||
|
|-
|Date To ||M ||DATETIME ||TODAY:23:59 || || || ||
|}
|}
==Receipt Scanning==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Dealer ||O ||STRING || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|Debriefed ||M || || || || || ||
|-
|-
|Route ||O ||STRING || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Media Type ||O ||STRING || || || || ||
|To Region ||M ||STRING ||ALL || || || ||
|-
|-
|Customer ||O ||STRING || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Date To ||M ||TODAY || || || || ||
|Carrier Group ||O || || || || || ||
|-
|-
|Date From ||M ||TODAY || || || || ||
|Strategy ||O || || || || || ||
|-
|-
|Depot ||O ||STRING || || || || ||
|Cost Centre ||O || || || || || ||
|}
|-
 
|Customer ||O || || || || || ||
==Receiving Extract==
|-
Parameters:
|From Region ||M ||STRING ||ALL || || || ||
|}
 
==NR Invoice==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|
|
|
|}
|}
==Revenue Check (Account)==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Debriefed ||M || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|To Region ||M ||STRING ||ALL || || || ||
|-
|From Region ||M ||STRING ||ALL || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Carrier Group ||O || || || || || ||
|-
|-
|Cust Group ||O || || || || || ||
|Strategy ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|}
|}


==SMS Email Summary Report==
==OTM Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|Date To ||M ||TODAY || || || || ||
|-
|-
|Cost Centre ||M ||STRING ||ALL || || || ||
|Date From ||M ||TODAY || || || || ||
|-
|Carrier ||O || || || || || ||
|}
|}


==STL Trip and Order Extract==
==On Time Arrivals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Trip Schedule ||M || || || || || ||
|Outbase ||O || || || || || ||
|-
|Media Type ||O || || || || || ||
|-
|Route Code ||O || || || || || ||
|-
|-
|End Trip Schedule ||M || || || || || ||
|Dealer ||O || || || || || ||
|-
|-
|Order Status ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|Location Type ||O || || || || || ||
|Schedule From ||M || || || || || ||
|}
|}


==Sales Margin Extract==
==On Time Drops==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier Group ||O || || || || || ||
|Outbase ||O || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Route Code ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Media Type ||O || || || || || ||
|-
|-
|Last Schedule ||O || || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|Dealer ||O || || || || || ||
|}
|}


==Savings Extract==
==On Time Items==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||O ||TODAY || || || || ||
|Dealer ||O || || || || || ||
|-
|-
|Credit Acc ||O || || || || || ||
|Outbase ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Route Code ||O || || || || || ||
|-
|-
|To Cty Code ||O || || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|From Cty Code ||O || || || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|Lane Id ||O || || || || || ||
|Media Type ||O || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Customer ||O || || || || || ||
|-
|Debit Acc ||O || || || || || ||
|-
|Saving (> or <) ||O ||STRING || || || || ||
|}
|}


==Schedule==
==On Time Items (Assets)==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|
|-
|
|To Date ||M ||TODAY || || || || ||
|
|}
|}
==Schedule Details==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||M || || || || || ||
|Schedule From ||M || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Dealer ||O || || || || || ||
|-
|Outbase ||O || || || || || ||
|-
|Route Code ||O || || || || || ||
|-
|Media Type ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Schedule To ||M || || || || || ||
|}
|}


==Schedule Trips CS==
==On Time Returns==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|
|
|
|}
|}
==Schedule Trips CS==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|Media Type ||O || || || || || ||
|}
 
==Scheduled and Cancelled Orders==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|Route Code ||O || || || || || ||
|-
|-
|Last Schedule ||O || || || || || ||
|Outbase ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Dealer ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Schedule From ||M || || || || || ||
|-
|Schedule To ||M || || || || || ||
|}
|}


==Scheduled and Cancelled Orders v2
==Order Charges Extract==
|-
{| class="wikitable"
|Schedule ||M || || || || || ||
!'''Report Name'''
|-
!'''Filename'''
|Customer ||O || || || || || ||
!'''Procedure for Scheduling'''
|-
|Last Schedule ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|
|-
|
|Carrier Group ||O || || || || || ||
|
|}
|}
==Short Rail Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Cost Centre ||O || || || || || ||
|Date ||M ||TODAY || || || || ||
|}
 
==Order Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Product Type ||O || || || || || ||
|
|-
|
|Start Schedule ||M || || || || || ||
|
|-
|End Schedule ||M || || || || || ||
|}
|}
==Slot Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Day ||O ||String ||ALL || || || ||
|End Sched ||M || || || || || ||
|-
|-
|Slot Type ||O ||String ||ALL || || || ||
|Start Sched ||M || || || || || ||
|-
|Location Type ||O ||String ||ALL || || || ||
|}
|}


==Store PVA || ||Del
==Order Interface Results==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|ivery Date ||M || || || || || ||
|
|
|
|}
|}
==Store Pre Warning==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Show empty Slots ||O ||STRING ||N || || || ||
|Customer ||O || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|From Date ||O ||TODAY || || || || ||
|-
|-
|Store ||O || || ||Store ||Location Id ||Name ||
|Depot ||O || || || || || ||
|-
|-
|Sched Name ||M || || || || || ||
|Message Type ||O || || || || || ||
|}
|}


==Sub Contractor==
==Order Items POD Debriefed==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Sched ||M || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Cost Centre ||M || || || || || ||
|End Schedule ||O || || || || || ||
|-
|-
|From Sched ||M || || || || || ||
|Start Schedule ||M || || || || || ||
|}
|}


==Supplier DUs==
==Order Savings==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To ||M || ||TODAY || || || ||
|
|-
|
|From ||M || ||TODAY || || || ||
|
|}
|}
==Supplier DUs By Store==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Store ||O || || ||Store ||Location ID ||Name ||
|Start Schedule ||M || || || || || ||
|-
|-
|Order Status ||O || || || || || ||
|End Schedule ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Show Neg Savings ||M || || || || || ||
|}
 
==Order Tracking==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|
|
|
|}
|}
==Supplier Invoice==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Date ||O || || || || || ||
|Customer ||O ||STRING ||OPENFIELD || || || ||
|-
|-
|End Date ||O || || || || || ||
|Month ||M || || || || || ||
|-
|-
|Invoice ID ||O ||STRING || || || || ||
|Week Offset ||O || || || || || ||
|-
|-
|End Date ||O || || || || || ||
|Year ||M || || || || || ||
|-
|-
|Invoice ID ||O ||STRING || || || || ||
|Cost Centre ||O ||STRING ||OPENFIELDCC || || || ||
|-
|}
|Start Date ||O || || || || || ||
 
|-
==Orders for Relabelling==
|Start Schedule ||M || || || || || ||
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|
|
|
|}
|}
==Supplier Revenue 2==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Revenue Start ||M || ||TODAY || || || ||
|Schedule ||M || || || || || ||
|-
|Revenue End ||M || ||TODAY || || || ||
|}
|}


==TYRE SUMMARY EXTRACT==
== Orders to LogiX ==
{{Note}} Can be run from Trip Waterfall screen.
== || || || || || || || || ||
|}


Parameters:
==Orders to Paragon==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|
|
|
|}
|}
==Trip Actuals==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|}
|}


==Trip Assessment Extract==
==Outbound Shortage==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|
|
|
|}
|}
==Trip Extract==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|Schedule To ||M || || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|Dealer ||O ||STRING || || || || ||
|-
|Media Type ||O ||STRING || || || || ||
|-
|Route ||O ||STRING || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Depot ||O ||STRING || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Customer ||O ||STRING || || || || ||
|}
|}


==Trip and Order Detail Extract==
==PAYMENT_DTLS==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|End Date ||M ||TODAY || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Location Type ||M || ||ALL || || || ||
|Customer ||M || || || || || ||
|}
 
==POC to SAP Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|
|
|
|}
|}
==Trunking Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|}
 
==POC to SAP Extract(A)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||M || || || || || ||
|Resend All? ||M ||STRING ||No || || || ||
|}
 
==POD Delivery Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Report Type ||M ||STRING ||Revenue || || || ||
|
|
|
|}
|}
==UNISON Interface Results==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|From Schedule ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|To Schedule ||M || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Del Msg Sent ||O ||STRING ||ALL || || || ||
|-
|POD Status ||O ||STRING ||ALL || || || ||
|-
|Carrier ||O ||STRING ||ALL || || || ||
|-
|> Days Outstanding ||O ||STRING ||0 || || || ||
|-
|Group ||O ||STRING ||ALL || || || ||
|-
|Customer ||O ||STRING ||ALL || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Scanning Depot ||O ||STRING ||ALL ||Depot ||Location Id ||Name ||
|}
|}


==User Activity Extract==
==POD Generation Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||M ||TODAY || || || || ||
|POD Flow ||M || || || || || ||
|-
|Date To ||M ||TODAY || || || || ||
|-
|Date From ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Schedule ||O || || || || || ||
|}
|}


==User Last Logon Extract==
==POD to SAP Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Days since logon ||M ||STRING ||90 || || || ||
|
|
|
|}
|}
==Variance Analysis Store Detail==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||M || || || || || ||
|}
|}


==Variance Analysis Summary==
==POD to SAP Extract(A)==
Parameters:
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Filename'''
|-
!'''Procedure for Scheduling'''
|To Date ||M ||TODAY || || || || ||
|-
|-
|
|From Date ||M ||TODAY || || || || ||
|
|}
|
 
|}
==Variance Analysis Trip Detail==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Resend All? ||M ||STRING ||No || || || ||
|Schedule ||M || || || || || ||
|}
|}
 
 
==PORSCHE19 Invoice Extract==
==Vehicle Utilisation==
{| class="wikitable"
Parameters:
!'''Report Name'''
{| class="wikitable"
!'''Filename'''
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|
|-
|
|End Schedule ||M || || || || || ||
|
|}
|}
 
Parameters:
==Vehicle Utilisation Heavy==
{| class="wikitable"
Parameters:
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
{| class="wikitable"
|-
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|Customer ||M ||STRING ||PORSCHE19 || || || ||
|-
|-
|Carrier Code ||O || || || || || ||
|Sub Debit Account ||O ||STRING ||ALL || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Trip ID ||O ||STRING ||ALL || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Sub Credit Account ||O ||STRING ||ALL || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Invoice ID ||O ||STRING ||0 || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Export ID ||O ||STRING ||0 || || || ||
|-
|}
|Start Schedule ||M || || || || || ||
 
|}
== PROVIDER_REVENUE ==
 
== || ||Owning Depot ||O || || || || || ||
==Vehicle Utilisation Non-Heavy==
|-
Parameters:
|To Schedule ||M || || || || || ||
{| class="wikitable"
|-
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|From Schedule ||M || || || || || ||
|-
|}
 
==Parts and Empites==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Export Type ||M || || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|Schedule To ||M || || || || || ||
|-
|Location From ||O || || || || || ||
|-
|Customer ||M || || || || || ||
|}
 
==PostCode Matrix==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|}
 
==Pre Invoice Check==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Cut-off Date ||M ||TODAY || || || || ||
|}
 
==Process Items Interface Audit==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Incl. Reprocessed ||M ||STRING ||N || || || ||
|-
|Start Date ||M ||TODAY || || || || ||
|-
|End Date ||M ||TODAY || || || || ||
|-
|Record Status ||M ||STRING ||ALL || || || ||
|}
 
==Provisional Booking Exceptions==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|}
 
==Purchase Order Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Status ||O ||STRING ||All || || || ||
|-
|To Date ||O ||TODAY ||TODAY || || || ||
|-
|From Date ||O ||TODAY ||TODAY || || || ||
|}
 
==Reason Listings==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Date From ||M ||DATETIME ||TODAY:00:01 || || || ||
|-
|Depot ||M || || || || || ||
|-
|Date To ||M ||DATETIME ||TODAY:23:59 || || || ||
|}
 
==Receipt Scanning==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Dealer ||O ||STRING || || || || ||
|-
|Route ||O ||STRING || || || || ||
|-
|Media Type ||O ||STRING || || || || ||
|-
|Customer ||O ||STRING || || || || ||
|-
|Date To ||M ||TODAY || || || || ||
|-
|Date From ||M ||TODAY || || || || ||
|-
|Depot ||O ||STRING || || || || ||
|}
 
==Receiving Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|}
 
==Revenue Check (Account)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|Cust Group ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|}
 
==SMS Email Summary Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||M ||STRING ||ALL || || || ||
|}
 
==STL Trip and Order Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Trip Schedule ||M || || || || || ||
|-
|End Trip Schedule ||M || || || || || ||
|-
|Order Status ||O || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|Location Type ||O || || || || || ||
|}
 
==Sales Margin Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier Group ||O || || || || || ||
|-
|Schedule ||M || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Last Schedule ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|}
 
==Savings Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date ||O ||TODAY || || || || ||
|-
|Credit Acc ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|To Cty Code ||O || || || || || ||
|-
|From Cty Code ||O || || || || || ||
|-
|Lane Id ||O || || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|-
|Debit Acc ||O || || || || || ||
|-
|Saving (> or <) ||O ||STRING || || || || ||
|}
 
==Schedule==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date ||M ||TODAY || || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|}
 
==Schedule Details==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Schedule ||M || || || || || ||
|-
|End Schedule ||M || || || || || ||
|}
 
==Schedule Trips CS==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Customer ||O || || || || || ||
|}
 
==Schedule Trips CS==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|}
 
==Scheduled and Cancelled Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|-
|Last Schedule ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Carrier Group ||O || || || || || ||
|}
 
== Scheduled and Cancelled Orders v2 ==
|-
|Schedule ||M || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Last Schedule ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Carrier Group ||O || || || || || ||
|}
 
==Short Rail Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Cost Centre ||O || || || || || ||
|-
|Product Type ||O || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|-
|End Schedule ||M || || || || || ||
|}
 
==Slot Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Day ||O ||String ||ALL || || || ||
|-
|Slot Type ||O ||String ||ALL || || || ||
|-
|Location Type ||O ||String ||ALL || || || ||
|}
 
== Store PVA ==
|| ||Del
|-
|ivery Date ||M || || || || || ||
|}
 
==Store Pre Warning==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Show empty Slots ||O ||STRING ||N || || || ||
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|Store ||O || || ||Store ||Location Id ||Name ||
|-
|Sched Name ||M || || || || || ||
|}
 
==Sub Contractor==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Sched ||M || || || || || ||
|-
|Cost Centre ||M || || || || || ||
|-
|From Sched ||M || || || || || ||
|}
 
==Supplier DUs==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To ||M || ||TODAY || || || ||
|-
|From ||M || ||TODAY || || || ||
|}
 
==Supplier DUs By Store==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Store ||O || || ||Store ||Location ID ||Name ||
|-
|Order Status ||O || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|}
 
==Supplier Invoice==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Date ||O || || || || || ||
|-
|End Date ||O || || || || || ||
|-
|Invoice ID ||O ||STRING || || || || ||
|-
|End Date ||O || || || || || ||
|-
|Invoice ID ||O ||STRING || || || || ||
|-
|Start Date ||O || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|-
|End Schedule ||M || || || || || ||
|}
 
==Supplier Revenue 2==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Revenue Start ||M || ||TODAY || || || ||
|-
|Revenue End ||M || ||TODAY || || || ||
|}
 
==TYRE SUMMARY EXTRACT==
{{Note}} Can be run from Trip Waterfall screen.
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|}
 
==Trip Actuals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|}
 
==Trip Assessment Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|}
 
==Trip Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier ||O || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|}
 
==Trip and Order Detail Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier ||O || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Location Type ||M || ||ALL || || || ||
|-
|Start Schedule ||M || || || || || ||
|}
 
==Trunking Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|End Schedule ||M || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|-
|Report Type ||M ||STRING ||Revenue || || || ||
|}
 
==UNISON Interface Results==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|Customer ||O || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|}
 
==User Activity Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|}
 
==User Last Logon Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Days since logon ||M ||STRING ||90 || || || ||
|}
 
==Variance Analysis Store Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|}
 
==Variance Analysis Summary==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|}
 
==Variance Analysis Trip Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|}
 
==Vehicle Utilisation==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Schedule ||M || || || || || ||
|-
|End Schedule ||M || || || || || ||
|}
 
==Vehicle Utilisation Heavy==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier Code ||O || || || || || ||
|-
|Carrier Group ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|}
 
==Vehicle Utilisation Non-Heavy==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier Group ||O || || || || || ||
|Carrier Group ||O || || || || || ||
|-
|-
Line 2,549: Line 4,565:


==Volume Deviation Extract==
==Volume Deviation Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
Line 2,571: Line 4,596:


==Volume or Activity==
==Volume or Activity==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
Line 2,591: Line 4,625:


==WCS Order Items Extract==
==WCS Order Items Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
Line 2,605: Line 4,648:


==Weekly Transport Report ==
==Weekly Transport Report ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
Line 2,617: Line 4,669:


==XML Order Interface Export==
==XML Order Interface Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
No Parameters
No Parameters

Revision as of 16:59, 30 July 2025

This is a full list of all extracts in the system.

10.6 Customer By Product Export

Report Name Filename Procedure for Scheduling
10.6 Customer By Product Export Cust_By_Product CSV.Cust_By_Product

10.6 Customer Location Export

Report Name Filename Procedure for Scheduling
10.6 Customer Location Export Customer_Location CSV.Customer_Location

10.6 Customer Product By Arrival

Report Name Filename Procedure for Scheduling
10.6 Customer Product By Arrival Cust_Product_By_Arrive CSV.Cust_Product_By_Arrive

10.6 Data Extract

Report Name Filename Procedure for Scheduling
10.6 Data Extract Data_Extract CSV.Data_Extract

10.6 Load Status Export

Report Name Filename Procedure for Scheduling
10.6 Load Status Export Load_Status_Export CSV.Load_Status_Export

10.6 Matthew Clark Data Extract

Report Name Filename Procedure for Scheduling
10.6 Matthew Clark Data Extract Matt_Clark_Data_Extract CSV.Matt_Clark_Data_Extract

10.6 Planning Export

Report Name Filename Procedure for Scheduling
10.6 Planning Export Planning_Export CSV.Planning_Export

10.6 Tokairo Export

Report Name Filename Procedure for Scheduling
10.6 Tokairo Export Tokairo_Export CSV.Tokairo_Export

10.6 Warehouse Extract

Report Name Filename Procedure for Scheduling
10.6 Warehouse Extract Warehouse_Extract CSV.Warehouse_Extract

1POD Delivery Extract

Report Name Filename Procedure for Scheduling
1POD Delivery Extract POD_Delivery_Extract DP_CSV2.POD_DELIVERY_EXTRACT

AA Trip and Order Detail

Report Name Filename Procedure for Scheduling
AA Trip and Order Detail AA_Trip_Order_Detail_Extract CSV.AA_Trip_Order_Detail_Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Activity M STRING Both
Group Name M
Start Schedule M
End Schedule M
Carrier O

ACC Missing Payments

Report Name Filename Procedure for Scheduling
ACC Missing Payments ACC_Missing_Payment DP_CSV_DUN.ACC_MISSING_PAYMENT

No parameters

ACTIVITY_EXTRACT

Report Name Filename Procedure for Scheduling
ACTIVITY_EXTRACT ACTIVITY_EXTRACT dp_csv3.activity_extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Schedule M
Owning Depot O
From Schedule M

Accruals

Report Name Filename Procedure for Scheduling
Accruals ACCRUALS CSV.ACCRUALS

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Revenue After O
Revenue Before O
Customer Group O
Debit Account O
Credit Account O

Actual Load

Report Name Filename Procedure for Scheduling
Actual Load ACTUAL_LOAD_EXTRACT DP_CSV_GEN.DAILY_EXT_LOAD

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
Load Date To M
Load Date From M

Actual Unload

Report Name Filename Procedure for Scheduling
Actual Unload ACTUAL_UNLOAD_EXTRACT DP_CSV_GEN.DAILY_EXT_UNLOAD

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Load Date To M
Load Date From M

Additional Reporting Requirements

Report Name Filename Procedure for Scheduling
Additional Reporting Requirements nr_additional_rep dp_csv_nr.nr_additional_report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Customer Group O
Customer O
Cost Centre O

Amazon Resources

Report Name Filename Procedure for Scheduling
Amazon Resources FMC_BULK_UPLOAD DP_CSV_CSS.AMAZON_RESOURCES

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Arrival Time To O
Arrival Time From O

Amazon Resources Update

Report Name Filename Procedure for Scheduling
Amazon Resources Update FMC_UPDATE DP_CSV_CSS.AMAZON_RESOURCE_UPDATE

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Update After (HHMI) O
Arrival Time To O
Arrival Time From O

Approved Price Report

Report Name Filename Procedure for Scheduling
Approved Price Report approved_price_rep dp_csv_nr.approved_price_report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY
Cost Centre O
Customer Group O
Customer O

Asset History

Report Name Filename Procedure for Scheduling
Asset History ASSET_HISTORY DP_CSV6.ASSET_HISTORY_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date From M TODAY
Driver/User O STRING
Asset Id O STRING ALL Asset Asset ID Asset ID
Date To M TODAY
Customer O STRING ALL
Asset Id O STRING ALL Asset Asset ID Asset ID
Last Scan Location O STRING ALL Last Scan Location Location ID Name
Customer O STRING ALL

Asset Status

Report Name Filename Procedure for Scheduling
Asset Status ASSET_STATUS DP_CSV6.ASSET_STATUS

Parameters:

Asset Utilisation

Report Name Filename Procedure for Scheduling
Asset Utilisation ASSET_UTILISATION dp_csv4.asset_utilisation

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Route O
From Date M TODAY
To Date M TODAY
Vehicle O
Current Location O Location Location Location Name
Location O Location Location Location Name

Assets On Time Delivery

Report Name Filename Procedure for Scheduling
Assets On Time Delivery ASSET_ON_TIME_DELIV dp_csv4.asset_on_time_deliv

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Location O Location Location Location Name
Route O
To Date M TODAY
From Date M TODAY

Automotive Planning Report

Report Name Filename Procedure for Scheduling
Automotive Planning Report Planning_Report DP_CSV2.PLANNING_REPORT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
Utilisation > O STRING 0
Utilisation < O STRING 999
End Schedule M
Depot M STRING ALL
Level M STRING SUMMARY

BGW Trip and Order Detail

Report Name Filename Procedure for Scheduling
BGW Trip and Order Detail BGW_Trip_Order_Detail_Extract DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Carrier O
Loaded At O
Activity M STRING Both
Group Name M

BGW_DEBRIEF

Report Name Filename Procedure for Scheduling
BGW_DEBRIEF BGW_DEBRIEF dp_csv3.bgw_debrief

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre O
From Date M TODAY
To Date M TODAY
Customer O

BMW Asset Dwell

Report Name Filename Procedure for Scheduling
BMW Asset Dwell AUTO_ASSET_DWELL DP_CSV3.AUTO_AFTERMARKET_BMW

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Asset Type O

Backing Sheet

Report Name Filename Procedure for Scheduling
Backing Sheet BACKING_SHEET_EXTRACT DP_CSV_GEN.BACKING_SHEET

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched To O
Customer O
Manifest O
Sched From O

Baxter CSR

Report Name Filename Procedure for Scheduling
Baxter CSR Baxter_csr DP_CSV5.BAXTER_CSR

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer M STRING ALL
From Date M TODAY
To Date M TODAY
Cost Centre O

Baxter Download Id Orders

Report Name Filename Procedure for Scheduling
Baxter Download Id Orders Baxter Download DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Download Id M STRING

CARGOWISE Header

Report Name Filename Procedure for Scheduling
CARGOWISE Header CARGOWISE_HEADER OF_INT.WRITE_CARGOWISE_HEADER

Parameters:

CN Data Extract

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot O Depot Location Id Name
From Date M TODAY
Customer O
Group Name O
To Date M TODAY

CN Equipment Moves

Report Name Filename Procedure for Scheduling
CN Equipment Moves Equip_Move DP_CSV2.CN_EQUIP_MOVE

Parameters:

CN Planning Export

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Group Name O
Current Depot M Current Depot Location Id Name
To Date M TODAY
From Date M TODAY

CN Tokairo Export

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

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

CN Trip and Order Detail

Report Name Filename Procedure for Scheduling
CN Trip and Order Detail CN_Trip_Order_Detail_Extract CSV.CN_Trip_Order_Detail_Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Start Schedule M
Loaded At O
Carrier O
Group Name M
Activity M STRING Both

CN Warehouse Loading

Report Name Filename Procedure for Scheduling
CN Warehouse Loading CN_Warehouse_Loading DP_CSV_DHL.p_warehouse_loading

Parameters:

CN Warehouse Extract

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Location M From Location Location Id Name
From Date M TODAY
To Date M TODAY
Owning Depot M Depot Location Id Name
Group Name O
Trip ID (optional) O
Depot M Depot Location Id Name
Carrier O
Start Schedule M
End Schedule M
Customer O Customer CUSTOMER_ID CUSTOMER_NAME

CTM Carrier Responsiveness

Report Name Filename Procedure for Scheduling
CTM Carrier Responsiveness CTM_CARRIER_RESPONSIVENESS CSV.CTM_CARRIER_RESPONSIVENESS

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule O
Carrier O
End Schedule O
Start Schedule O
Carrier O
End Schedule O

CTM Trips Not Responded To

Report Name Filename Procedure for Scheduling
CTM Trips Not Responded To CTM_TRIPS_NO_RESPONSE CSV.CTM_TRIPS_NO_RESPONSE

Parameters:

Call Collection OTIF Day

Report Name Filename Procedure for Scheduling
Call Collection OTIF Day coll_OTIF_date_window dp_csv_nr.coll_otif_date_window

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
Customer O
Customer Group O
Product Type O
End Schedule O
Start Schedule O
From Date M TODAY
To Date M TODAY

Call Collection OTIF Time Window

Report Name Filename Procedure for Scheduling
Call Collection OTIF Time Window coll_OTIF_window dp_csv_nr.coll_otif_window

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
Customer O
Customer Group O
Product Type O
End Schedule O
Start Schedule O
To Date M TODAY
From Date M TODAY

Call Delivery OTIF Day

Report Name Filename Procedure for Scheduling
Call Delivery OTIF Day del_OTIF_date_window dp_csv_nr.del_otif_date_window

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
From Date M TODAY
To Date M TODAY
Start Schedule O
End Schedule O
Product Type O
Customer Group O
Customer O

Call Delivery OTIF Time Window

Report Name Filename Procedure for Scheduling
Call Delivery OTIF Time Window del_OTIF_window dp_csv_nr.del_otif_window

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule O
Product Type O
Customer Group O
Customer O
Carrier O
From Date M TODAY
To Date M TODAY
Start Schedule O

Campus KPI Extract

Report Name Filename Procedure for Scheduling
Campus KPI Extract Campus_KPI_Extract KPI.KPI_CAMPUS_EXTRACT

Parameters:

Carrier DUs Shipped

Report Name Filename Procedure for Scheduling
Carrier DUs Shipped CARRIER_DUS_SHIPPED DP_CSV5.CARRIER_DUS_SHIPPED

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O STRING ALL
To Date M TODAY
From Date M TODAY

Carrier Delivery Report

Report Name Filename Procedure for Scheduling
Carrier Delivery Report Carrier_Delivery_Report DP_CSV5.CARRIER_DELIVERY

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched Name M
Carrier M
Depot M
Trip ID O STRING ALL

Carrier Invoice

Report Name Filename Procedure for Scheduling
Carrier Invoice Carrier_Invoice CSV.CARRIER_INVOICE

Parameters:

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

Carrier Self Billing

Report Name Filename Procedure for Scheduling
Carrier Self Billing Carrier_Self_billing DP_CSV_BNL.CARRIER_SELF_BILLING

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Carrier 0
Start Schedule M

Catalyst Extract

Report Name Filename Procedure for Scheduling
Catalyst Extract CATALYST_EXTRACT CSV.CATALYST_EXTRACT

Parameters:

Co-ordinate Non-Conformities

Report Name Filename Procedure for Scheduling
Co-ordinate Non-Conformities Co_Ord_Non_Conf DP_CSV6.CO_ORD_NON_CONFORM

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
Discrepancy Dist 0 1
TomTom,Epod,Both M B
Driver O
Depot O
End Schedule M

Commercial

Report Name Filename Procedure for Scheduling
Commercial COMMERCIAL CSV.Commercial_Orders

Parameters:

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

Compliance Report

Report Name Filename Procedure for Scheduling
Compliance Report COMPLIANCE_REPORT DP_CSV_DUN.COMPLIANCE_REPORT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Collection Date M

Concurrent Logon Export

Report Name Filename Procedure for Scheduling
Concurrent Logon Export Concurrent_Logon_Export CSV.Concurrent_Logon

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O TODAY
To Date O TODAY

Contracts

Report Name Filename Procedure for Scheduling
Contracts CONTRACTS CSV.CONTRACTS

No Parameters

Cross Dock

Report Name Filename Procedure for Scheduling
Cross Dock CROSS_DOCK DP_CSV6.CROSS_DOCK

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Media Type O STRING
Route O STRING
Schedule From M
Dealer O STRING
Depot O STRING
Schedule To M
Customer O STRING

Customer Invoice

Report Name Filename Procedure for Scheduling
Customer Invoice Customer_Invoice CSV.Customer_Invoice

Parameters:

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

Customer Invoice By Dates

Report Name Filename Procedure for Scheduling
Customer Invoice By Dates Customer_Invoice_By_Dates CSV.Customer_Invoice_By_Dates

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Payment Status O
Customer M
From Date M
To Date M

Customer Invoice Extract

Report Name Filename Procedure for Scheduling
Customer Invoice Extract Customer_Invoice CSV.Customer_Invoice

Parameters:

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

Cut Offs Extract

Report Name Filename Procedure for Scheduling
Cut Offs Extract Cut_offs_extract DP_CSV6.CUT_OFF_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Customer 0
Start Schedule M

D365 Extract

Report Name Filename Procedure for Scheduling
D365 Extract DP_FINANCE.D365_EXPORT D365_EXPORT_

Parameters:

DELIVERY_OVERVIEW

Report Name Filename Procedure for Scheduling
DELIVERY_OVERVIEW DELIVERY_OVERVIEW dp_csv3.delivery_overview

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Schedule M
To Schedule M
Owning Depot O
POD Confirmed O

DOOD Rpt

Report Name Filename Procedure for Scheduling
DOOD Rpt DOOD_RPT dp_csv_dood.dood_rpt

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Customer O STRING OPENFIELD

DUs Despatched

Report Name Filename Procedure for Scheduling
DUs Despatched DUS_DESPATCHED_EXTRACT DP_CSV_GEN.DUS_DESPATCHED_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Consignment Num O STRING
Start Sched O
Manifest O STRING
PO Number O STRING
Supplier O
End Sched O

DUs Not Loaded

Report Name Filename Procedure for Scheduling
DUs Not Loaded DUS_NOT_LOADED_EXTRACT DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Store O Store Location ID Name
Schedule M

DUs Not Received

Report Name Filename Procedure for Scheduling
DUs Not Received DUS_NOT_RECEIVED_EXTRACT DP_CSV_GEN.DAILY_EXT_NOT_RECD

Parameters:

|- |To Date ||M || || || || || || |- |From Date ||M || || || || || || |}

Daily Manifest E-OT-L

Report Name Filename Procedure for Scheduling
Daily Manifest E-OT-L DAILY_MANIFEST_E_OT_L_EXTRACT DP_CSV_GEN.DAILY_EXT_MANIFEST

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M
To Date M
End Schedule M
Start Schedule M

Daily Receiving E-OT-L

Report Name Filename Procedure for Scheduling
Daily Receiving E-OT-L RECEIVING_E_OT_L_EXTRACT DP_CSV_GEN.DAILY_EXT_RECEIPTING

Parameters:

Daily Transport Plan

Report Name Filename Procedure for Scheduling
Daily Transport Plan DAILY_TRANSPORT_PLAN_EXTRACT DP_CSV_GEN.DAILY_TRANSPORT_PLAN

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Order Status M STRING ALL
Supplier M STRING ALL
To Date M
From Date M

Daily Unscheduled Orders

Report Name Filename Procedure for Scheduling
Daily Unscheduled Orders DAILY_UNSCHEDULED_ORDERS_EXTRACT DP_CSV_GEN.DAILY_UNSCHED_ORD

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M
From Date M

Debrief Performance

Report Name Filename Procedure for Scheduling
Debrief Performance debrief_performance dp_csv_nr.debrief_performance

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Code O
Carrier Group O
Customer O
Cust Group O
Cost Centre O
From Date M TODAY
From Date M TODAY

Del Scans

Report Name Filename Procedure for Scheduling
Del Scans DEL_SCANS DP_CSV6.DEL_SCANS

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Start Schedule M

Delivery Conf

Report Name Filename Procedure for Scheduling
Delivery Conf BGYP_DELCONF_ DP_CSV5.DELIVERY_CONF

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Type M M
Owning Depot O
Cost Centre M
To Actual date M TODAY
From Actual date M TODAY

Delivery Schedule Extract

Report Name Filename Procedure for Scheduling
Delivery Schedule Extract Delivery_Schedule DP_CSV_DHL.DELIVERY_SCHEDULE

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show Dates Y

Depot Exits by Hour (Loads)

Report Name Filename Procedure for Scheduling
Depot Exits by Hour (Loads) DEPOT_EXITS_LOADS CSV.DEPOT_EXITS_BY_HOUR_LOADS

Parameters:

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

Depot Exits by Hour (RPEs)

Report Name Filename Procedure for Scheduling
Depot Exits by Hour (RPEs) DEPOT_EXITS_RPE CSV.DEPOT_EXITS_BY_HOUR_RPE

Parameters:

Detailed Interface Report

Report Name Filename Procedure for Scheduling
Detailed Interface Report Detailed_Interface_Report CSV.Detailed_Interface_Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer Group O
To Date O TODAY
Customer O
From Date O TODAY
Status M STRING All

Dixons Catalyst Report

Report Name Filename Procedure for Scheduling
Dixons Catalyst Report fn CSV.Dixons_Catalyst_Report

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule M
Carrier O
Depot O Depot Location Id Name
Start Schedule M

Dixons Order Export

Report Name Filename Procedure for Scheduling
Dixons Order Export Dixons_Order_Export CSV.Dixons_Order_Export

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O TODAY
Carrier O
To Date O TODAY

Dixons Trip Extract

Report Name Filename Procedure for Scheduling
Dixons Trip Extract Dixons_Trip_Extract CSV.Dixons_Trip_Extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
To Date O TODAY
From Date O TODAY

Driver Hours

Report Name Filename Procedure for Scheduling
Driver Hours driver_hours dp_csv_nr.driver_hours

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
Customer Group O
To Date M TODAY
Cost Centre O

Driver Scanning

Report Name Filename Procedure for Scheduling
Driver Scanning DRIVER_SCANNING DP_CSV6.DRIVER_SCANNING

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O STRING
Dealer O STRING
Depot O STRING
Route O STRING
Media Type O STRING
Schedule To M
Schedule From M
Activity O STRING

Dunelm Actual Load

Report Name Filename Procedure for Scheduling
Dunelm Actual Load DUNELM_ACTUAL_LOAD DP_CSV_DUN.daily_ext_load

Parameters:

Dunelm Actual Unload

Report Name Filename Procedure for Scheduling
Dunelm Actual Unload DUNELM_ACTUAL_UNLOAD DP_CSV_DUN.daily_ext_unload

Parameters:

Dunelm Backing Sheet

Report Name Filename Procedure for Scheduling
Dunelm Backing Sheet BACKING_SHEET DP_CSV2.BACKING_SHEET

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Manifest O
Customer M
Sched To M
Sched From M

Dunelm DUs Despatched Extract

Report Name Filename Procedure for Scheduling
Dunelm DUs Despatched Extract DUNELM_DUS_DESPATCHED_EXTRACT DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT

Parameters:

Dunelm DUs Not Loaded Extract

Report Name Filename Procedure for Scheduling
Dunelm DUs Not Loaded Extract DUNELM_DUS_NOT_LOADED_EXTRACT DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT

Parameters:

Dunelm DUs Not Received

Report Name Filename Procedure for Scheduling
Dunelm DUs Not Received DUNELM_DUS_NOT_RECEIVED DP_CSV_DUN.daily_ext_not_recd

Parameters:

Dunelm Inventory Transactions

Report Name Filename Procedure for Scheduling
Dunelm Inventory Transactions DUN_INVENTORY_TRANS DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Delivery Trip O
Trunk Trip O
Collection Trip O
Store O
Customer O
Date Type M STRING C
To Date M TODAY TODAY:23:59
From Date M TODAY TODAY:00:00

Dunelm Item Movements 3

Report Name Filename Procedure for Scheduling
Dunelm Item Movements 3 DUN_ITEM_MOVEMENTS_EXTRACT DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Manifest Number O
Actual To Date M TODAY
Actual From Date M TODAY
DU Type O
Supplier O
P/O Number O
Store O

Dunelm Item Movements Extract

Report Name Filename Procedure for Scheduling
Dunelm Item Movements Extract DUN_ITEM_MOVEMENTS_EXTRACT DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Manifest Number O STRING
P/O Number O
Store O
DU Type O
Supplier O
Actual To Date M TODAY
Actual From Date M TODAY

Dunelm Item Movements Extract New

Report Name Filename Procedure for Scheduling
Dunelm Item Movements Extract New DUN_ITEM_MOVEMENTS_EXTRACT DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
P/O Number O
Manifest Number O STRING
Store O
DU Type O
Supplier O
Actual From Date M TODAY
Actual To Date M TODAY

Dunelm Left Offs

Report Name Filename Procedure for Scheduling
Dunelm Left Offs Left_Offs_Extract DP_CSV_DUN.left_offs_extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip Id (Optional) O
Days Back M STRING 30
Store (Optional) O Store Location Id Name

Dunelm Loading Extract

Report Name Filename Procedure for Scheduling
Dunelm Loading Extract DUNELM_LOADING_EXTRACT DP_CSV2.DUN_LOADING

Parameters:

Dunelm Manifest E-OT-L Extract

Report Name Filename Procedure for Scheduling
Dunelm Manifest E-OT-L Extract DUNELM_MANIFESTED_EOL DP_CSV_DUN.daily_ext_manifest

Parameters:

Dunelm Manual Loaded Items Extract

Report Name Filename Procedure for Scheduling
Dunelm Manual Loaded Items Extract MANL_SCAN_ORDER_DETAIL_EXTRACT DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O
To Date O

Dunelm Receiving Extract

Report Name Filename Procedure for Scheduling
Dunelm Receiving Extract DUNELM_RECEIVING_EXTRACT DP_CSV2.DUN_RECEIVING

Parameters:

Dunelm Recieving E-OT-L Extract

Report Name Filename Procedure for Scheduling
Dunelm Recieving E-OT-L Extract DUNELM_RECEIPTED_EOL DP_CSV_DUN.daily_ext_receipting

Parameters:

Dunelm Supplier DU Extract

Report Name Filename Procedure for Scheduling
Dunelm Supplier DU Extract DUNELM_SUPPLIER_DU_EXTRACT DP_CSV2.DUN_SUPPLIER_DU_EXTRACT

Parameters:

Dunelm Supplier DU Extract by Store

Report Name Filename Procedure for Scheduling
Dunelm Supplier DU Extract by Store DUNELM_DU_STORE_EXTRACT DP_CSV2.DUN_DU_STORE_EXTRACT

Parameters:

Dunelm Supplier Revenue Extract

Report Name Filename Procedure for Scheduling
Dunelm Supplier Revenue Extract DUNELM_SUPPLIER_REVENUE_EXTRACT DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT

Parameters:

Dunelm Supplier Revenue Extract New

Report Name Filename Procedure for Scheduling
Dunelm Supplier Revenue Extract New DUNELM_SUPPLIER_REVENUE_NEW DP_CSV2.DUN_SUPPLIER_REVENUE_NEW

Parameters:

Dunelm Supplier Trends Extract

Report Name Filename Procedure for Scheduling
Dunelm Supplier Trends Extract DUN_SUPPLIER_TRENDS dp_csv_dun.dun_du_rpe_revenue_extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Year M
Week M

Dunelm Transport Plan

Report Name Filename Procedure for Scheduling
Dunelm Transport Plan DUNELM_TRANSPORT_PLAN DP_CSV_DUN.daily_transport_plan

Parameters:

Dunelm Unsched Orders

Report Name Filename Procedure for Scheduling
Dunelm Unsched Orders DUNELM_UNSCHED_ORD DP_CSV_DUN.daily_unsched_ord

Parameters:

Duplicate Postcodes

Report Name Filename Procedure for Scheduling
Duplicate Postcodes DUPLICATE_POSTCODES dp_csv2.duplicate_postcodes_extract

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Ignore Inactive? O
Location From O Location From Location Id Location Name
Location To O Location To Location Id Location Name

EFX Inbound Errors

Report Name Filename Procedure for Scheduling
EFX Inbound Errors EFX_Inbound_Errors DP_CSV2.EFX_In_Errs_Extract

Parameters:

ERC

Report Name Filename Procedure for Scheduling
ERC ERC DP_CSV_DHL.ERC

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched End M
Sched Start M
Carrier O
DHL Carriers M
Detail Level M

Equipment Moves

Report Name Filename Procedure for Scheduling
Equipment Moves Equip_Move DP_CSV2.EQUIP_MOVE

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Owning Depot O
Customer O
To Date M TODAY
From Date M TODAY
Carrier O

Extract Lane

Report Name Filename Procedure for Scheduling
Extract Lane EXTRACT_LANE CSV.EXTRACT_BY_LANE

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre O Cost Centre Location Id Name
Customer O

Failed Shipment

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Customer O STRING OPENFIELD

Fixed Routes Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show Active / Inactive M STRING B
Carrier O
Depot O Depot Location Id Name

GREENE KING Interface Results

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Depot O
To Date O TODAY
From Date O TODAY

GYP EFX Export

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip Status O
To Schedule M
From Schedule M
Cost Centre O
Customer Group O

HC Booking In Form

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M
Group Name O
Delivery Location O
Customer O
Group Name O
Schedule M
Delivery Location O
Customer O

HC Haulier Trip Sheet

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip ID (optional) O
Owning Depot O Depot Location Id Name
Schedule M
Carrier O
Group Name O
Load Location O Loading Location Location Id Name
Owning Depot O Depot Location Id Name
Trip ID (optional) O
Schedule M
Carrier O
Group Name O
Load Location O Loading Location Location Id Name

HCR Customer Orders

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Schedule M
Cost Centre O
Depot O

HCR Loading Sheet CSV

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip ID (optional) O
Load Location O Loading Location Loading Location Name
Owning Depot O Depot Loading Location Name
Schedule From M
Schedule To M
Carrier O
Customer O
Group Name O

Haulier Invoice

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Date O
Start Date O
Invoice ID O STRING
End Date O
Start Date O
Invoice ID O STRING

Heavy Vehicle Utilisation

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Customer Group O

Historical Lane Based Orders

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date O TODAY
From Date M TODAY

IND Trip and Order Detail

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Activity M STRING Both
End Schedule M
Carrier O
Loaded At O
Start Schedule M
Group Name M

ISC Finance (2) Export

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer M STRING ALL
End Schedule M
Start Schedule M

Interface Errors Failures

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
External Ref O STRING
Customer O Customer
Source System O
End Date M TODAY
Start Date M TODAY

Invalid Orders

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M
Customer 0

Item Movements

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Actual To Date M TODAY
Actual From Date M TODAY
Supplier O
DU Type O
Store O
Manifest Number O
P/O Number O

Item Movements 2

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
DU Type O
Supplier O
Actual From Date M TODAY
Actual To Date M TODAY
P/O Number O
Store O
Manifest Number O

Item Movements 3

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
P/O Number O
Store O
Manifest Number O
DU Type O
Supplier O
Actual To Date M TODAY
Actual From Date M TODAY

Items Not Scanned By Date

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Depot M

Items Not Scanned By Trip

Report Name Filename Procedure for Scheduling

Parameters:

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

JEYES Interface Results

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date O TODAY
Customer O
Depot O
From Date O TODAY

KPI By Lane

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer Group O
End Date M
Show Detail M STRING Y
Grouping M STRING CUST_GROUP
End Date M TODAY
Start Date M TODAY
Start Date M
Tolerance(days) O
Separate Pages M STRING N
Customer Group O
Grouping M STRING CUST_GROUP

Kraft KPI

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY
Cost Centre O

LFS Packages

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M
Order Status O
Customer O
External Ref O

Lane Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
Cost Centre O
To Loc O To Loc Location Id Name
From Loc O From Loc Location Id Name

Left Offs

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Store (optional) O Store Location ID Name
Days Back M STRING 30
Trip ID (optional) O

Loading Extract

Report Name Filename Procedure for Scheduling

Parameters:

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

Loading Schedule CSV

Report Name Filename Procedure for Scheduling

Parameters:

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

Location Export

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Country O

Location Pre-Warning

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Load Type M STRING ALL
Trip Status M STRING ALL
To Date M TODAY
To Date M TODAY
From Date M TODAY
Depot M Depot Location Id Name
Depot M Depot Location Id Name
From Date M TODAY
Load Type M STRING ALL
Trip Status M STRING ALL

MDD Code 03 Exceptions

Report Name Filename Procedure for Scheduling

Parameters:

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

Manual Loaded Items

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date O
To Date O

Master and Child Locations

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show UnMapped O Show UnMapped
Show Mapped O Show Mapped

Message Maintenance

== || || || || || || || || || |}

Missing Lat Long Report

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre M ALL

Missing Steps Report

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
Missing Step O STRING ALL
From Date M TODAY

Month End Accruals

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
From Date M TODAY
Cost Centre O
Customer O
Cust Group O

NR Finance Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
Debriefed M
Carrier O
To Region M STRING ALL
To Date M TODAY
Carrier Group O
Strategy O
Cost Centre O
Customer O
From Region M STRING ALL

NR Invoice

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date M TODAY
From Date M TODAY
Debriefed M
Carrier O
To Region M STRING ALL
From Region M STRING ALL
Carrier Group O
Strategy O
Customer O
Cost Centre O

OTM Export

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date To M TODAY
Date From M TODAY
Carrier O

On Time Arrivals

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Outbase O
Media Type O
Route Code O
Dealer O
Customer O
Schedule To M
Schedule From M

On Time Drops

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Outbase O
Route Code O
Media Type O
Schedule To M
Customer O
Schedule From M
Dealer O

On Time Items

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Dealer O
Outbase O
Route Code O
Schedule To M
Schedule From M
Media Type O
Customer O

On Time Items (Assets)

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule From M
Customer O
Dealer O
Outbase O
Route Code O
Media Type O
Schedule To M

On Time Returns

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Media Type O
Route Code O
Outbase O
Dealer O
Customer O
Schedule From M
Schedule To M

Order Charges Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date M TODAY

Order Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Sched M
Start Sched M

Order Interface Results

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
To Date O TODAY
From Date O TODAY
Depot O
Message Type O

Order Items POD Debriefed

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O
End Schedule O
Start Schedule M

Order Savings

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule O
Show Neg Savings M

Order Tracking

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O STRING OPENFIELD
Month M
Week Offset O
Year M
Cost Centre O STRING OPENFIELDCC

Orders for Relabelling

Report Name Filename Procedure for Scheduling

Parameters:

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

Orders to LogiX

== || || || || || || || || || |}

Orders to Paragon

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

Outbound Shortage

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Dealer O STRING
Media Type O STRING
Route O STRING
Depot O STRING
Customer O STRING

PAYMENT_DTLS

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Date M TODAY
From Date M TODAY
Customer M

POC to SAP Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

POC to SAP Extract(A)

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Resend All? M STRING No

POD Delivery Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Schedule M
To Schedule M
Del Msg Sent O STRING ALL
POD Status O STRING ALL
Carrier O STRING ALL
> Days Outstanding O STRING 0
Group O STRING ALL
Customer O STRING ALL
Scanning Depot O STRING ALL Depot Location Id Name

POD Generation Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
POD Flow M
Date To M TODAY
Date From M TODAY
Schedule O

POD to SAP Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

POD to SAP Extract(A)

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Resend All? M STRING No

PORSCHE19 Invoice Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer M STRING PORSCHE19
Sub Debit Account O STRING ALL
Trip ID O STRING ALL
Sub Credit Account O STRING ALL
Invoice ID O STRING 0
Export ID O STRING 0

PROVIDER_REVENUE

== || ||Owning Depot ||O || || || || || || |- |To Schedule ||M || || || || || || |- |From Schedule ||M || || || || || || |}

Parts and Empites

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Export Type M
Schedule From M
Schedule To M
Location From O
Customer M

PostCode Matrix

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3

Pre Invoice Check

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cut-off Date M TODAY

Process Items Interface Audit

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Incl. Reprocessed M STRING N
Start Date M TODAY
End Date M TODAY
Record Status M STRING ALL

Provisional Booking Exceptions

Report Name Filename Procedure for Scheduling

Parameters:

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

Purchase Order Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Status O STRING All
To Date O TODAY TODAY
From Date O TODAY TODAY

Reason Listings

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date From M DATETIME TODAY:00:01
Depot M
Date To M DATETIME TODAY:23:59

Receipt Scanning

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Dealer O STRING
Route O STRING
Media Type O STRING
Customer O STRING
Date To M TODAY
Date From M TODAY
Depot O STRING

Receiving Extract

Report Name Filename Procedure for Scheduling

Parameters:

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

Revenue Check (Account)

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
From Date M TODAY
Cost Centre O
Cust Group O
Customer O

SMS Email Summary Report

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
Cost Centre M STRING ALL

STL Trip and Order Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Trip Schedule M
End Trip Schedule M
Order Status O
Carrier O
Location Type O

Sales Margin Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Group O
Schedule M
Customer Group O
Last Schedule O
Customer O

Savings Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date O TODAY
Credit Acc O
Customer Group O
To Cty Code O
From Cty Code O
Lane Id O
From Date O TODAY
Debit Acc O
Saving (> or <) O STRING

Schedule

Report Name Filename Procedure for Scheduling

Parameters:

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

Schedule Details

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M

Schedule Trips CS

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O

Schedule Trips CS

Report Name Filename Procedure for Scheduling

Parameters:

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

Scheduled and Cancelled Orders

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule M
Last Schedule O
Customer Group O
Customer O
Carrier Group O

Scheduled and Cancelled Orders v2

|- |Schedule ||M || || || || || || |- |Customer ||O || || || || || || |- |Last Schedule ||O || || || || || || |- |Customer Group ||O || || || || || || |- |Carrier Group ||O || || || || || || |}

Short Rail Report

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre O
Product Type O
Start Schedule M
End Schedule M

Slot Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Day O String ALL
Slot Type O String ALL
Location Type O String ALL

Store PVA

|| ||Del |- |ivery Date ||M || || || || || || |}

Store Pre Warning

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Show empty Slots O STRING N
Depot O Depot Location Id Name
Store O Store Location Id Name
Sched Name M

Sub Contractor

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Sched M
Cost Centre M
From Sched M

Supplier DUs

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To M TODAY
From M TODAY

Supplier DUs By Store

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Store O Store Location ID Name
Order Status O
End Schedule M
Start Schedule M

Supplier Invoice

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Date O
End Date O
Invoice ID O STRING
End Date O
Invoice ID O STRING
Start Date O
Start Schedule M
End Schedule M

Supplier Revenue 2

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Revenue Start M TODAY
Revenue End M TODAY

TYRE SUMMARY EXTRACT

Note Note: Can be run from Trip Waterfall screen.

Report Name Filename Procedure for Scheduling

Parameters:

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

Trip Actuals

Report Name Filename Procedure for Scheduling

Parameters:

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

Trip Assessment Extract

Report Name Filename Procedure for Scheduling

Parameters:

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

Trip Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
To Date O TODAY
From Date O TODAY

Trip and Order Detail Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
End Schedule M
Location Type M ALL
Start Schedule M

Trunking Report

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot M Depot Location Id Name
End Schedule M
Start Schedule M
Report Type M STRING Revenue

UNISON Interface Results

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot O Depot Location Id Name
Customer O
To Date O TODAY
From Date O TODAY

User Activity Extract

Report Name Filename Procedure for Scheduling

Parameters:

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

User Last Logon Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Days since logon M STRING 90

Variance Analysis Store Detail

Report Name Filename Procedure for Scheduling

Parameters:

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

Variance Analysis Summary

Report Name Filename Procedure for Scheduling

Parameters:

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

Variance Analysis Trip Detail

Report Name Filename Procedure for Scheduling

Parameters:

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

Vehicle Utilisation

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule M
End Schedule M

Vehicle Utilisation Heavy

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Code O
Carrier Group O
Cost Centre O
Customer Group O
End Schedule M
Start Schedule M

Vehicle Utilisation Non-Heavy

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier Group O
Customer Group O
Cost Centre O
End Schedule M
Start Schedule M
Carrier Code O

Volume Deviation Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O ALL
To Date M TODAY
From Date M TODAY
Schedule O
Cost Centre O ALL
Trip Leg O STRING ALL
Include Unpacked O STRING Y
Deviation O STRING ALL

Volume or Activity

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule From M
Schedule To M
Route Code O
Customer O
Dealer O
Depot O
Media Type O

WCS Order Items Extract

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY
Order O STRING
Trip O STRING

Weekly Transport Report

Report Name Filename Procedure for Scheduling

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Sched M
To Sched M
Carrier ALL

XML Order Interface Export

Report Name Filename Procedure for Scheduling

No Parameters