Extracts Details: Difference between revisions

Latest revision as of 12:37, 31 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

Parameters:

Title	Name	Mand
Customer	i_customer	M
To Schedule	i_to_sched	M
From Schedule	i_from_sched	M

10.6 Customer Location Export

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

Parameters:

Title	Name	Mand
Customer	i_customer	M
To Schedule	i_to_sched	M
From Schedule	i_from_sched	M

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

Parameters:

Title	Name	Mand
To Schedule	i_to_sched	M
From Schedule	i_from_sched	M
Customer	i_customer	M

10.6 Data Extract

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

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
Group Name	i_group_name	O
From Date	i_from_date	M	TODAY
To Date	i_to_date	M	TODAY
Customer	i_customer	O
Depot	i_depot	O		Depot	Location Id	Name

10.6 Load Status Export

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

Parameters:

Title	Name	Mand
Status	i_status	O
Carrier	i_carrier	O
To Schedule	i_to_sched	M
Customer	i_customer	O
From Schedule	i_from_sched	M

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Schedule	i_to_sched	M
From Schedule	i_from_sched	M

10.6 Planning Export

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

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
Current Depot	i_current_depot	M		Current Depot	Location Id	Name
Group Name	i_group_name	O
From Date	i_from_date	M	TODAY
To Date	i_to_date	M	TODAY

10.6 Tokairo Export

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
End Date	i_to_date	M	TODAY
Start Date	i_from_date	M	TODAY

10.6 Warehouse Extract

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

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
From Location	i_from_loc	M		From Location	Location Id	Name
Owning Depot	i_depot	M		Depot	Location Id	Name
To Date	i_to_date	M	TODAY
From Date	i_from_date	M	TODAY
Group Name	i_group_name	O

1POD Delivery Extract

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
> Days Outstanding	p_outstanding	O	STRING	0
Scanning Depot	p_scan_depot	O	STRING	ALL	Depot	Location Id	Name
POD Status	p_pod	O	STRING	ALL
Del Msg Sent	p_del_msg_sent	O	STRING	ALL
From Schedule	p_from_date	M
Customer	p_customer	O	STRING	ALL
Group	p_group_name	O	STRING	ALL
To Schedule	p_to_date	M
Carrier	p_carrier	O	STRING	ALL

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:

Title	Name	Mand	Def Type	Def Val
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M
Carrier	i_carrier_id	O
Group Name	i_group_name	M
Activity	i_activity_name	M	STRING	Both

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:

Title	Name	Mand
From Schedule	P_START_SCHED	M
Owning Depot	P_OWNING_DEPOT	O
To Schedule	P_END_SCHED	M

Accruals

Report Name	Filename	Procedure for Scheduling
Accruals	ACCRUALS	CSV.ACCRUALS

Parameters:

Title	Name	Mand
Revenue After	i_revenue_after	O
Revenue Before	i_revenue_before	O
Customer Group	i_cust_group	O
Debit Account	i_debit_acc	O
Credit Account	i_credit_acc	O

Actual Load

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

Parameters:

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

Actual Unload

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

Parameters:

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

Additional Reporting Requirements

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

Parameters:

Title	Name	Mand
Customer Group	i_cust_group	O
Cost Centre	i_cost_centre	O
End Schedule	i_Sched_To	M
Customer	i_customer	O
Start Schedule	i_Sched_From	M

Amazon Resources

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

Parameters:

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

Amazon Resources Update

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

Parameters:

Title	Name	Mand
Arrival Time To	i_date_to	O
Update After (HHMI)	i_changed	O
Arrival Time From	i_date_from	O

Approved Price Report

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

Parameters:

Title	Name	Mand	Def Type
From Date	i_Start_Date_Time	M	TODAY
Customer	i_customer	O
Customer Group	i_cust_group	O
Cost Centre	i_cost_centre	O
To Date	i_End_Date_Time	M	TODAY

Asset History

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
Customer	i_customer	O	STRING	ALL
Asset Id	i_asset_id	O	STRING	ALL	Asset	Asset ID	Asset ID
Driver/User	i_action_by	O	STRING
Date To	i_date_to	M	TODAY
Date From	i_date_from	M	TODAY

Asset Status

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
Asset Id	i_asset_id	O	STRING	ALL	Asset	Asset ID	Asset ID
Customer	i_customer	O	STRING	ALL
Last Scan Location	i_last_scan_loc	O	STRING	ALL	Last Scan Location	Location ID	Name

Asset Utilisation

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

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
Current Location	I_CURRENT_LOCATION	O		Location	Location	Location Name
Customer	I_CUSTOMER	O
To Date	I_DATE_TO	M	TODAY
From Date	I_DATE_FROM	M	TODAY
Vehicle	I_VEHICLE	O
Route	I_ROUTE	O
Location	I_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:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
Route	I_ROUTE	O
Customer	I_CUSTOMER	O
From Date	I_DATE_FROM	M	TODAY
To Date	I_DATE_TO	M	TODAY
Location	I_LOCATION	O		Location	Location	Location Name

Automotive Planning Report

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

Parameters:

Title	Name	Mand	Def Type	Def Val
Utilisation >	I_UTIL_FROM	O	STRING	0
Utilisation <	I_UTIL_TO	O	STRING	999
End Schedule	I_END_DATE	M
Level	I_LEVEL	M	STRING	SUMMARY
Depot	I_DEPOT	M	STRING	ALL
Start Schedule	I_START_DATE	M

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:

Title	Name	Mand	Def Type	Def Val
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M
Loaded At	i_loaded_at	O
Activity	i_activity_name	M	STRING	Both
Group Name	i_group_name	M
Carrier	i_carrier_id	O

BGW_DEBRIEF

Report Name	Filename	Procedure for Scheduling
BGW_DEBRIEF	BGW_DEBRIEF	dp_csv3.bgw_debrief

Parameters:

Title	Name	Mand	Def Type
Cost Centre	P_COST_CENTRE	O
From Date	P_START_DATETIME	M	TODAY
To Date	P_END_DATETIME	M	TODAY
Customer	P_CUSTOMER	O

BMW Asset Dwell

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

Parameters:

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

Backing Sheet

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

Parameters:

Title	Name	Mand
Customer	i_customer	O
Sched To	i_end_sched	O
Sched From	i_start_sched	O
Manifest	i_booking	O

Baxter CSR

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

Parameters:

Title	Name	Mand	Def Type	Def Val
Customer	I_CUSTOMER	M	STRING	ALL
To Date	I_DATE_TO	M	TODAY
Cost Centre	i_cost_centre	O
From Date	I_DATE_FROM	M	TODAY

Baxter Download Id Orders

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

Parameters:

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

CARGOWISE Header

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Export_id	i_exp_id	M

CN Data Extract

Warning: Missing

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	LOV	Column 1	Column 2
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:

Name	Mand	Def Type	Def Val
To Date	i_date_to	M	TODAY
Group Name	i_group_name	O
Customer	i_customer	O
From Date	i_date_from	M	TODAY

CN Planning Export

Warning: Missing

Report Name	Filename	Procedure for Scheduling

Parameters:

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

CN Tokairo Export

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:

Title	Name	Mand	Def Type	Def Val
Activity	i_activity_name	M	STRING	Both
Group Name	i_group_name	M
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M
Carrier	i_carrier_id	O
Loaded At	i_loaded_at	O

CN Warehouse Loading

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

Parameters:

Title	Name	Mand	LOV	Column 1	Column 2
Customer	i_customer	O	Customer	CUSTOMER_ID	CUSTOMER_NAME
Depot	i_depot	M	Depot	Location Id	Name
Trip ID (optional)	i_trip_id	O
Carrier	i_carrier	O
End Schedule	i_end_sched	M
Start Schedule	i_start_sched	M

CN Warehouse Extract

Warning: Missing

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	LOV	Column 1	Column 2
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:

Title	Name	Mand
Start Schedule	P_START_SCHED	O
Carrier	P_HAULIER	O
End Schedule	P_END_SCHED	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:

Title	Name	Mand
End Schedule	P_END_SCHED	O
Start Schedule	P_START_SCHED	O
Carrier	P_HAULIER	O

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:

Title	Name	Mand	Def Type
Carrier	i_carrier	O
End Schedule	i_Sched_To	O
From Date	i_Start_Date_Time	M	TODAY
To Date	i_End_Date_Time	M	TODAY
Start Schedule	i_Sched_From	O
Product Type	i_product_type	O
Customer Group	i_cust_group	O
Customer	i_customer	O

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:

Title	Name	Mand	Def Type
To Date	i_End_Date_Time	M	TODAY
Start Schedule	i_Sched_From	O
End Schedule	i_Sched_To	O
Product Type	i_product_type	O
Customer Group	i_cust_group	O
Customer	i_customer	O
Carrier	i_carrier	O
From Date	i_Start_Date_Time	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:

Title	Name	Mand	Def Type
Carrier	i_carrier	O
Customer	i_customer	O
Customer Group	i_cust_group	O
Product Type	i_product_type	O
End Schedule	i_Sched_To	O
Start Schedule	i_Sched_From	O
From Date	i_Start_Date_Time	M	TODAY
To Date	i_End_Date_Time	M	TODAY

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:

Title	Name	Mand	Def Type
Customer	i_customer	O
Carrier	i_carrier	O
Customer Group	i_cust_group	O
Product Type	i_product_type	O
End Schedule	i_Sched_To	O
Start Schedule	i_Sched_From	O
To Date	i_End_Date_Time	M	TODAY
From Date	i_Start_Date_Time	M	TODAY

Campus KPI Extract

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

Parameters:

Title	Name	Mand	Def Type	Def Val	Column 1	Column 2
From Date	i_date_from	M	TODAY
Carrier	i_carrier	O		ALL
Cost Centre	i_cost_centre	O		ALL
Date Range Type	i_date_type	M	String
Depot	i_depot	O		ALL	Location Id	Name
To Date	i_date_to	M	TODAY
Client	i_client	O		ALL

Carrier DUs Shipped

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

Parameters:

Title	Name	Mand	Def Type	Def Val
From Date	I_DATE_FROM	M	TODAY
Carrier	P_CARRIER	O	STRING	ALL
To Date	I_DATE_TO	M	TODAY

Carrier Delivery Report

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

Parameters:

Title	Name	Mand	Def Type	Def Val
Sched Name	P_SCHED_NAME	M
Trip ID	P_TRIP	O	STRING	ALL
Carrier	P_CARRIER	M
Depot	P_DEPOT	M

Carrier Invoice

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

Parameters:

Title	Name	Mand
Invoice No	I_INVOICE_NO	M
Credit Acc	I_CREDIT_ACC	M
Debit Acc	I_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:

Title	Name	Mand
Start Schedule	i_start_sched	M
Carrier	i_carrier	0
End Schedule	i_end_sched	M

Catalyst Extract

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

Parameters:

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

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:

Title	Name	Mand	Def Val
Start Schedule	i_sched_from	M
End Schedule	i_sched_to	M
Driver	i_driver	O
TomTom,Epod,Both	i_inc	M	B
Discrepancy Dist	i_disc_dist	0	1
Depot	i_depot	O

Commercial

Report Name	Filename	Procedure for Scheduling
Commercial	COMMERCIAL	CSV.Commercial_Orders

Parameters:

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

Compliance Report

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

Parameters:

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

Concurrent Logon Export

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
From Date	i_from_date	O	TODAY
To Date	i_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:

Title	Name	Mand	Def Type
Schedule From	i_sched_from	M
Schedule To	i_sched_to	M
Customer	i_customer	O	STRING
Media Type	i_media_type	O	STRING
Depot	i_depot	O	STRING
Route	i_route	O	STRING
Dealer	i_dealer	O	STRING

Customer Invoice

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

Parameters:

Title	Name	Mand
Invoice No	I_INVOICE_NO	M
Credit Acc	I_CREDIT_ACC	M
Debit Acc	I_DEBIT_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:

Title	Name	Mand
Payment Status	i_act_or_prov	O
From Date	I_START_DATETIME	M
To Date	I_END_DATETIME	M
Customer	I_CUSTOMER	M

Customer Invoice Extract

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

Parameters:

Title	Name	Mand
Debit Acc	I_DEBIT_ACC	M
Invoice No	I_INVOICE_NO	M
Credit Acc	I_CREDIT_ACC	M

Cut Offs Extract

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

Parameters:

Title	Name	Mand
End Schedule	i_end_sched	M
Customer	i_customer	0
Start Schedule	i_start_sched	M

D365 Extract

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

No parameters.

DELIVERY_OVERVIEW

Report Name	Filename	Procedure for Scheduling
DELIVERY_OVERVIEW	DELIVERY_OVERVIEW	dp_csv3.delivery_overview

Parameters:

Title	Name	Mand
POD Confirmed	P_POD	O
Owning Depot	P_OWNING_DEPOT	O
To Schedule	P_END_SCHED	M
From Schedule	P_START_SCHED	M

DOOD Rpt

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

Parameters:

Title	Name	Mand	Def Type	Def Val
Schedule To	I_SCHED_TO	M
Schedule From	I_SCHED_FROM	M
Customer	I_CUSTOMER	O	STRING	OPENFIELD

DUs Despatched

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

Parameters:

Title	Name	Mand	Def Type
Start Sched	p_start_sched	O
PO Number	p_external	O	STRING
Consignment Num	p_oms	O	STRING
End Sched	p_end_sched	O
Manifest	p_manifest	O	STRING
Supplier	p_customer	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:

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

DUs Not Received

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	i_avail_to	M
From Date	i_avail_from	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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	i_avail_to	M
From Date	i_avail_from	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:

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

Daily Transport Plan

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

Parameters:

Title	Name	Mand	Def Type	Def Val
From Date	i_avail_from	M
Supplier	i_supplier	M	STRING	ALL
To Date	i_avail_to	M
Order Status	i_ord_status	M	STRING	ALL

Daily Unscheduled Orders

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

Parameters:

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

Debrief Performance

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

Parameters:

Title	Name	Mand	Def Type
Cust Group	i_cust_group	O
Customer	i_customer	O
Carrier Group	i_carrier_group	O
Cost Centre	i_cost_centre	O
From Date	i_Start_Date_Time	M	TODAY
Carrier Code	i_carrier_code	O
From Date	i_End_Date_Time	M	TODAY

Del Scans

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

Parameters:

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

Delivery Conf

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

Parameters:

Title	Name	Mand	Def Type	Def Val
Owning Depot	p_own	O
Cost Centre	p_cost	M
To Actual date	p_to_date	M	TODAY
Type	p_type	M		M
From Actual date	p_from_date	M	TODAY

Delivery Schedule Extract

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Show Dates	P_DATE_SELECT	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:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
To Date	i_End_Date_Time	M	TODAY
Depot	i_Depot_Loc_Id	M		Depot	Location Id	Name
From Date	i_Start_Date_Time	M	TODAY

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:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
Depot	i_Depot_Loc_ID	M		Depot	Location Id	Name
From Date	i_Start_Date_Time	M	TODAY
To Date	i_End_Date_Time	M	TODAY

Detailed Interface Report

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

Parameters:

Title	Name	Mand	Def Type	Def Val
Customer Group	i_group_name	O
Customer	i_customer	O
Status	i_status	M	STRING	All
To Date	i_to_date	O	TODAY
From Date	i_from_date	O	TODAY

Dixons Catalyst Report

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

Parameters:

Title	Name	Mand	LOV	Column 1	Column 2
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M
Depot	i_Depot	O	Depot	Location Id	Name
Carrier	P_HAULIER	O

Dixons Order Export

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

Parameters:

Title	Name	Mand	Def Type
From Date	i_from_date	O	TODAY
To Date	i_to_date	O	TODAY
Carrier	i_carrier	O

Dixons Trip Extract

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

Parameters:

Title	Name	Mand	Def Type
To Date	i_to_date	O	TODAY
From Date	i_from_date	O	TODAY
Carrier	i_carrier	O

Driver Hours

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

Parameters:

Title	Name	Mand	Def Type
Cost Centre	i_cost_centre	O
Customer Group	i_cust_group	O
To Date	i_End_Date_Time	M	TODAY
From Date	i_Start_Date_Time	M	TODAY

Driver Scanning

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

Parameters:

Title	Name	Mand	Def Type
Depot	i_depot	O	STRING
Media Type	i_media_type	O	STRING
Route	i_route	O	STRING
Customer	i_customer	O	STRING
Dealer	i_dealer	O	STRING
Activity	i_activity	O	STRING
Schedule To	i_sched_to	M
Schedule From	i_sched_from	M

Dunelm Actual Load

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

Parameters:

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

Dunelm Actual Unload

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Unload Date From	i_date_from	M
Unload Date To	i_date_to	M

Dunelm Backing Sheet

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

Parameters:

Title	Name	Mand
Customer	i_customer	O
Sched To	i_end_sched	O
Sched From	i_start_sched	O
Manifest	i_booking	O

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:

Title	Name	Mand	Def Type
PO Number	p_external	O	STRING
Manifest	p_manifest	O	STRING
Supplier	p_customer	O
Start Sched	p_start_sched	O
End Sched	p_end_sched	O
Consignment Num	p_oms	O	STRING

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:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Store	p_store	O			Store	Location Id	Name
Schedule	p_sched_date	M

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:

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

Dunelm Inventory Transactions

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

Parameters:

Title	Name	Mand	Def Type	Def Val
To Date	P_DATE_TO	M	TODAY	TODAY:23:59
Trunk Trip	P_TRUNK_TRIP	O
Delivery Trip	P_DEL_TRIP	O
Collection Trip	P_COL_TRIP	O
Date Type	P_DATE_TYPE	M	STRING	C
Customer	i_customer	O
From Date	P_DATE_FROM	M	TODAY	TODAY:00:00
Store	i_dealer	O

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:

Title	Name	Mand	Def Type
Manifest Number	P_MANF_NO	O	STRING
Store	P_STORE	O
Supplier	P_SUPPLIER	O
Actual From Date	P_START_DATETIME	M	TODAY
P/O Number	P_PO_NO	O
DU Type	P_DU_TYPE	O
Actual To Date	P_END_DATETIME	M	TODAY

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:

Title	Name	Mand	Def Type
Supplier	P_SUPPLIER	O
Actual To Date	P_END_DATETIME	M	TODAY
Actual From Date	P_START_DATETIME	M	TODAY
DU Type	P_DU_TYPE	O
Store	P_STORE	O
P/O Number	P_PO_NO	O
Manifest Number	P_MANF_NO	O

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:

Title	Name	Mand	Def Type
Actual To Date	P_END_DATETIME	M	TODAY
Store	P_STORE	O
P/O Number	P_PO_NO	O
Manifest Number	P_MANF_NO	O	STRING
Actual From Date	P_START_DATETIME	M	TODAY
Supplier	P_SUPPLIER	O
DU Type	P_DU_TYPE	O

Dunelm Left Offs

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

Parameters:

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

Dunelm Loading Extract

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

Parameters:

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

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:

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

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:

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

Dunelm Receiving Extract

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

Parameters:

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

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:

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

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:

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

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:

Title	Name	Mand	LOV	Column 1	Column 2
Order Status	P_STATUS	O
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	M
Store	P_STORE	O	Store	Location Id	Name

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:

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

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:

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

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:

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

Dunelm Transport Plan

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

Parameters:

Title	Name	Mand	Def Type	Def Val
From Date	i_avail_from	M
Order Status	i_ord_status	M	STRING	ALL
Supplier	i_supplier	M	STRING	ALL
To Date	i_avail_to	M

Dunelm Unsched Orders

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

Parameters:

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

Duplicate Postcodes

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

Parameters:

Title	Name	Mand	LOV	Column 1	Column 2
Location To	P_LOCATION_TO	O	Location To	Location Id	Location Name
Ignore Inactive?	P_IGNORE_INACTIVE	O
Location From	P_LOCATION_FROM	O	Location From	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

No parameters.

ERC

Report Name	Filename	Procedure for Scheduling
ERC	ERC	DP_CSV_DHL.ERC

Parameters:

Title	Name	Mand
DHL Carriers	i_dhl_carr	M
Detail Level	i_detail	M
Sched Start	i_sched_from	M
Carrier	i_carrier	O
Sched End	i_sched_to	M

Equipment Moves

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

Parameters:

Title	Name	Mand	Def Type
Owning depot	i_depot	O
Customer	i_customer	O
To Date	i_date_to	M	TODAY
From Date	i_date_from	M	TODAY
Carrier	i_carrier	O

Extract Lane

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

Parameters:

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

Failed Shipment

Report Name	Filename	Procedure for Scheduling
Failed Shipment	FAILED_SHIPMENT	dp_csv3.failed_shipment

Parameters:

Title	Name	Mand	Def Type	Def Val
Schedule To	I_SCHED_TO	M
Schedule From	I_SCHED_FROM	M
Customer	I_CUSTOMER	O	STRING	OPENFIELD

Fixed Routes Extract

Report Name	Filename	Procedure for Scheduling
Fixed Routes Extract	Routes_Extract	CSV.FIXED_ROUTES_EXPORT

Parameters:

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

GREENE KING Interface Results

Report Name	Filename	Procedure for Scheduling
GREENE KING Interface Results	GREENE_KING_interface_results	CSV.GREENE_KING_if_res

Parameters:

Title	Name	Mand	Def Type
Customer	I_CUSTOMER	O
Depot	i_depot	O
To Date	i_to_date	O	TODAY
From Date	i_from_date	O	TODAY

GYP EFX Export

Report Name	Filename	Procedure for Scheduling
GYP EFX Export	GYP_EFX_Export	DP_CSV5.GYP_EFX_EXPORT

Parameters:

Title	Name	Mand
Trip Status	I_STATUS	O
To Schedule	P_END_SCHED	M
From Schedule	P_START_SCHED	M
Cost Centre	I_COST_CENTRE	O
Customer Group	I_CUST_GRP	O

HC Booking In Form

Report Name	Filename	Procedure for Scheduling
HC Booking In Form	HC_BOOKING_IN_FORM	DP_CSV5.P_HC_BOOKING_IN_FORM

Parameters:

Title	Name	Mand
Schedule	I_SCHED_NAME	M
Group Name	I_GROUP_NAME	O
Customer	I_CUSTOMER	O
Delivery Location	I_DEL_LOCATION	O

HC Haulier Trip Sheet

Report Name	Filename	Procedure for Scheduling
HC Haulier Trip Sheet	HAULIER_TRIP_SHEET	DP_CSV2.HAULIER_TRIP_SHEET

Parameters:

Title	Name	Mand	LOV	Column 1	Column 2
Trip ID (optional)	i_trip_id	O
Owning Depot	i_depot	O	Depot	Location Id	Name
Load Location	i_load_loc	O	Loading Location	Location Id	Name
Group Name	i_group_name	O
Carrier	i_carrier	O
Schedule	i_sched	M

HCR Customer Orders

Report Name	Filename	Procedure for Scheduling
HCR Customer Orders	HCR_CUSTOMER_ORDERS	DP_CSV_DHL.HCR_CUSTOMER_ORDERS

Parameters:

Title	Name	Mand
Cost Centre	I_COST_CENTRE	O
Depot	P_LOCATION	O
Customer	I_CUSTOMER	O
Schedule	I_SCHED_NAME	M

HCR Loading Sheet CSV

Report Name	Filename	Procedure for Scheduling
HCR Loading Sheet CSV	HCR_LOADING_SHEET	DP_CSV5.HCR_LOADING_SHEET

Parameters:

Title	Name	Mand	LOV	Column 1	Column 2
Carrier	P_CARRIER	O
Group Name	P_GROUP_NAME	O
Owning Depot	P_OWNING_DEPOT	O	Depot	Loading Location	Name
Customer	P_CUSTOMER	O
Schedule To	P_SCHED_TO	M
Trip ID (optional)	P_TRIP_ID	O
Load Location	P_LOAD_LOC	O	Loading Location	Loading Location	Name
Schedule From	P_SCHED_FROM	M

Haulier Invoice

Report Name	Filename	Procedure for Scheduling
Haulier Invoice	Haulier_Invoice	DP_CSV5.HAULIER_INVOICE

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Invoice ID	P_INVOICE_ID	O	STRING

Heavy Vehicle Utilisation

Warning: Missing

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:

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

IND Trip and Order Detail

Report Name	Filename	Procedure for Scheduling
IND Trip and Order Detail	IND_Trip_Order_Detail_Extract	DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT

Parameters:

Title	Name	Mand	Def Type	Def Val
End Schedule	P_END_SCHED	M
Activity	i_activity_name	M	STRING	Both
Loaded At	i_loaded_at	O
Start Schedule	P_START_SCHED	M
Carrier	i_carrier_id	O
Group Name	i_group_name	M

ISC Finance (2) Export

Report Name	Filename	Procedure for Scheduling
ISC Finance (2) Export	FINANCE_2_EXPORT	DP_CSV2.FINANCE_EXPORT_V2

Parameters:

Title	Name	Mand	Def Type	Def Val
Customer	I_CUSTOMER	M	STRING	ALL
Start Schedule	I_FROM_SCHED_NAME	M
End Schedule	I_TO_SCHED_NAME	M

ISC Finance (3) Export

Report Name	Filename	Procedure for Scheduling
ISC Finance (3) Export	FINANCE_2_EXPORT	CSV6.ISC_FINANCE_2_EXPORT

Parameters:

Title	Name	Mand	Def Type	Def Val
Customer	I_CUSTOMER	M	STRING	ALL
Start Schedule	I_FROM_SCHED_NAME	M
End Schedule	I_TO_SCHED_NAME	M

ISC Finance (4) Export

Report Name	Filename	Procedure for Scheduling
ISC Finance (4) Export	FINANCE_2_EXPORT	CSV7.FINANCE_EXPORT_V2

Parameters:

Title	Name	Mand	Def Type	Def Val
Customer	I_CUSTOMER	M	STRING	ALL
Start Schedule	I_FROM_SCHED_NAME	M
End Schedule	I_TO_SCHED_NAME	M

Interface Errors Failures

Report Name	Filename	Procedure for Scheduling
Interface Errors Failures	Interface_Errors_Failures	DP_CSV5.INTERFACE_ERRORS_FAILURES

Parameters:

Title	Name	Mand	Def Type	LOV
Source System	P_SOURCE_SYSTEM	O		Source System
Customer	P_CUSTOMER	O		Customer
External Ref	P_EXTERNAL_REF	O	STRING
End Date	P_END_DATETIME	M	TODAY
Start Date	P_START_DATETIME	M	TODAY

Invalid Orders

Report Name	Filename	Procedure for Scheduling
Invalid Orders	Invalid_Orders	DP_CSV6.INVALID_ORDERS

Parameters:

Title	Name	Mand
Customer	i_customer	0
End Schedule	i_end_sched	M
Start Schedule	i_start_sched	M

Item Movements

Report Name	Filename	Procedure for Scheduling
Item Movements	ITEM_MOVEMENTS_EXTRACT	DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT

Parameters:

Title	Name	Mand	Def Type
Actual From Date	P_START_DATETIME	M	TODAY
Actual To Date	P_END_DATETIME	M	TODAY
Supplier	P_SUPPLIER	O
DU Type	P_DU_TYPE	O
Manifest Number	P_MANF_NO	O
P/O Number	P_PO_NO	O
Store	P_STORE	O

Item Movements 2

Report Name	Filename	Procedure for Scheduling
Item Movements 2	ITEM_MOVEMENTS_2_EXTRACT	DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2

Parameters:

Title	Name	Mand	Def Type
Actual From Date	P_START_DATETIME	M	TODAY
Actual To Date	P_END_DATETIME	M	TODAY
Supplier	P_SUPPLIER	O
DU Type	P_DU_TYPE	O
Manifest Number	P_MANF_NO	O
P/O Number	P_PO_NO	O
Store	P_STORE	O

Item Movements 3

Report Name	Filename	Procedure for Scheduling
Item Movements 3	ITEM_MOVEMENTS_3_EXTRACT	DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3

Parameters:

Title	Name	Mand	Def Type
Actual From Date	P_START_DATETIME	M	TODAY
Actual To Date	P_END_DATETIME	M	TODAY
Supplier	P_SUPPLIER	O
DU Type	P_DU_TYPE	O
Manifest Number	P_MANF_NO	O
P/O Number	P_PO_NO	O
Store	P_STORE	O

Items Not Scanned By Date

Report Name	Filename	Procedure for Scheduling
Items Not Scanned By Date	Items_Not_Scanned	DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE

Parameters:

Title	Name	Mand
Depot	P_DEPOT	M
Schedule To	P_END_SCHED	M
Schedule From	P_START_SCHED	M

Items Not Scanned By Trip

Report Name	Filename	Procedure for Scheduling
Items Not Scanned By Trip	Items_Not_Scanned	DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP

Parameters:

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

JEYES Interface Results

Report Name	Filename	Procedure for Scheduling
JEYES Interface Results	JEYES_interface_results	CSV.JEYES_if_res

Parameters:

Title	Name	Mand	Def Type
Customer	I_CUSTOMER	O
Depot	i_depot	O
From Date	i_from_date	O	TODAY
To Date	i_to_date	O	TODAY

Job Notes

Report Name	Filename	Procedure for Scheduling
Job Notes	Job_Notes	DP_CSV5.JOB_NOTES

Parameters:

Title	Name	Mand
Date from	i_date_from	M
OMS Ref To	i_oms_to	O
OMS Ref From	i_oms_from	O
Date to	i_date_to	M
Customer	i_customer	O

KPI By Lane

Report Name	Filename	Procedure for Scheduling
KPI By Lane	KPI_BY_LANE	CSV.KPI_BY_LANE

Parameters:

Title	Name	Mand	Def Type	Def Val
Start Date	I_START_DATE_TIME	M	TODAY
Tolerance(days)	I_TOLERANCE	O
Customer Group	I_CUST_GROUP	O
End Date	I_END_DATE_TIME	M	TODAY
Grouping	I_GROUP_BY	M	STRING	CUST_GROUP

KPI Extract

Report Name	Filename	Procedure for Scheduling
KPI Extract	CN_KPI_Extract	KPI_EXTRACT.KPI_EXTRACT

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
Owning Depot	i_owning_depot	O			Depot	Location Id	Name
Start Schedule	i_start_sched	M
Group Name	i_group_name	O	STRING	ALL
End Schedule	i_end_sched	M

Kraft KPI

Report Name	Filename	Procedure for Scheduling
Kraft KPI	KRAFT_KPI	CSV.Trips_with_Orders

Parameters:

Title	Name	Mand	Def Type
From Date	I_START_DATETIME	M	TODAY
To Date	I_END_DATETIME	M	TODAY
Cost Centre	I_COST_CENTRE	O

LFS Packages

Report Name	Filename	Procedure for Scheduling
LFS Packages	LFS_Packages	DP_CSV_LFS.LFS_PACKAGES

Parameters:

Title	Name	Mand
External Ref	i_ext_ref	O
Customer	i_customer	O
Schedule	i_sched	M
Order Status	i_ord_status	O

Lane Extract

Report Name	Filename	Procedure for Scheduling
Lane Extract	Lane_Extract	CSV.LANE_EXPORT

Parameters:

Title	Name	Mand	LOV	Column 1	Column 2
From Loc	p_from_loc	O	From Loc	Location Id	Name
To Loc	p_to_loc	O	To Loc	Location Id	Name
Customer	p_customer	O
Cost Centre	p_cost_centre	O

Left Offs

Report Name	Filename	Procedure for Scheduling
Left Offs	LEFT_OFFS_EXTRACT	DP_CSV_GEN.LEFT_OFFS_EXTRACT

Parameters:

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

Loading Extract

Report Name	Filename	Procedure for Scheduling
Loading Extract	LOADING_EXTRACT	DP_CSV_GEN.EXT_LOADING

Parameters:

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

Loading Schedule CSV

Report Name	Filename	Procedure for Scheduling
Loading Schedule CSV	Loading_Schedule	CSV.LOADING_SCHEDULE

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
To Date	i_End_Time	M	TODAY
From Date	i_Start_Time	M	TODAY
Depot	i_Depot	M		Depot	Location Id	Name

Location Export

Report Name	Filename	Procedure for Scheduling
Location Export	Location_Export	DP_CSV2.LOCATION_EXPORT

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Location Group	I_CUST_GROUP	O
Country	i_country	O

Location Export GL

Report Name	Filename	Procedure for Scheduling
Location Export GL	Location_Export	CSV.LOCATION_EXPORT_GL

No parameters

Location Export GPR

Report Name	Filename	Procedure for Scheduling
Location Export GL	Location_Export	CSV.LOCATION_EXPORT_GPR

No parameters.

Location Pre-Warning

Report Name	Filename	Procedure for Scheduling
Location Pre-Warning	Loc_Del_Pre_Warn	CSV.Loc_Del_Pre_Warning

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
Depot	i_depot	M			Depot	Location Id	Name
From Date	i_start_date_time	M	TODAY
Load Type	i_load_type	M	STRING	ALL
To Date	i_end_date_time	M	TODAY
Trip Status	i_trip_status	M	STRING	ALL

MDD Code 03 Exceptions

Report Name	Filename	Procedure for Scheduling
MDD Code 03 Exceptions	MDD Code 03 Exceptions	CSV.MDD_Code_03_Exceptions

Parameters:

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

MTS Finance Export

Report Name	Filename	Procedure for Scheduling
MTS Finance Export	FINANCE_EXPORT	CSV.finance_export_v2

Parameters:

Title	Name	Mand	Def Type	Def Val
End Schedule	i_to_sched_name	M
Start Schedule	i_from_sched_name	M
Customer	I_CUSTOMER	M	STRING	ALL

MTS Finance Export V2

Report Name	Filename	Procedure for Scheduling
MTS Finance Export	FINANCE_EXPORT_V2	CSV.finance_export_v2

Parameters:

Title	Name	Mand	Def Type	Def Val
End Schedule	i_to_sched_name	M
Start Schedule	i_from_sched_name	M
Customer	I_CUSTOMER	M	STRING	ALL

Manual Loaded Items

Report Name	Filename	Procedure for Scheduling
Manual Loaded Items	MANUAL_LOADED_ITEMS_EXTRACT	DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT

Parameters:

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

Master and Child Locations

Report Name	Filename	Procedure for Scheduling
Master and Child Locations	Master_and_Child	DP_CSV5.MASTER_AND_CHILD

Parameters:

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

Message Maintenance

Report Name	Filename	Procedure for Scheduling
Message Maintenance	Message_Maintenance	CSV.msg_maint

No parameters

Missing Lat Long Report

Report Name	Filename	Procedure for Scheduling
Missing Lat Long Report	MISSING_LAT_LONGS	dp_csv3.missing_lat_long_extract

Parameters:

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

Missing Steps Report

Report Name	Filename	Procedure for Scheduling
Missing Steps Report	Missing_Steps_Report	DP_CSV5.Missing_Steps_Report

Parameters:

Title	Name	Mand	Def Type	Def Val
Missing Step	i_step	O	STRING	ALL
To Date	i_date_to	M	TODAY
From Date	i_date_from	M	TODAY

Month End Accruals

Report Name	Filename	Procedure for Scheduling
Month End Accruals	month_end_accruals	dp_csv_nr.month_end_accruals

Parameters:

Title	Name	Mand	Def Type
From Date	i_End_Date_Time	M	TODAY
From Date	i_Start_Date_Time	M	TODAY
Cost Centre	i_cost_centre	O
Cust Group	i_cust_group	O
Customer	i_customer	O

NR Additional Report

Report Name	Filename	Procedure for Scheduling
NR Additional Report	nr_additional_rep	dp_csv_nr.nr_additional_report

No parameters

NR Finance Extract

Report Name	Filename	Procedure for Scheduling
NR Finance Extract	NR_Finance_Extract	DP_CSV_NR.NR_FINANCE_EXTRACT

Parameters:

Title	Name	Mand	Def Type	Def Val
Debriefed	i_debriefed	M
From Date	i_from_date	M	TODAY
Carrier	i_carrier	O
To Region	i_to_region	M	STRING	ALL
From Region	i_from_region	M	STRING	ALL
Carrier Group	i_carrier_group	O
Strategy	i_strategy	O
Cost Centre	i_cost_centre	O
Customer	i_customer	O
To Date	i_to_date	M	TODAY

NR Invoice

Report Name	Filename	Procedure for Scheduling
NR Invoice	NR_Invoice	DP_CSV_NR.NR_INVOICE

Parameters:

Title	Name	Mand	Def Type	Def Val
From Date	i_from_date	M	TODAY
Carrier	i_carrier	O
To Region	i_to_region	M	STRING	ALL
From Region	i_from_region	M	STRING	ALL
Debriefed	i_debriefed	M
Strategy	i_strategy	O
Cost Centre	i_cost_centre	O
Customer	i_customer	O
To Date	i_to_date	M	TODAY
Carrier Group	i_carrier_group	O

OPS KPI Extract

Report Name	Filename	Procedure for Scheduling
OPS KPI Extract	OPS_KPI_Extract	KPI.KPI_OPS_EXTRACT

Parameters:

Title	Name	Mand	Def Type	Def Val	Column 1	Column 2
Cost Centre	i_cost_centre	O		ALL
To Date	i_date_to	M	TODAY
From Date	i_date_from	M	TODAY
Client	i_client	O		ALL
Carrier	i_carrier	O		ALL
Depot	i_depot	O		ALL	Location Id	Name
Date Range Type	i_date_type	M	String

OPS KPI Extract2

Report Name	Filename	Procedure for Scheduling
OPS KPI Extract2	OPS_KPI_Extract	KPI.KPI_OPUS_EXTRACT

Parameters:

Title	Name	Mand	Def Type	Def Val	Column 1	Column 2
Cost Centre	i_cost_centre	O		ALL
To Date	i_date_to	M	TODAY
From Date	i_date_from	M	TODAY
Client	i_client	O		ALL
Carrier	i_carrier	O		ALL
Depot	i_depot	O		ALL	Location Id	Name
Date Range Type	i_date_type	M	String

OTM Export

Report Name	Filename	Procedure for Scheduling
OTM Export	OTM_Export	DP_CSV_DHL.OTM_EXPORT

Parameters:

Title	Name	Mand	Def Type
Date To	i_date_to	M	TODAY
Carrier	i_carrier	O
Date From	i_date_from	M	TODAY

On Time Arrivals

Report Name	Filename	Procedure for Scheduling
On Time Arrivals	ON_TIME_ARRIVALS	DP_CSV6.ON_TIME_ARRIVALS

Parameters:

Title	Name	Mand
Schedule From	i_sched_from	M
Schedule To	i_sched_to	M
Customer	i_customer	O
Outbase	i_depot	O
Route Code	i_route	O
Media Type	i_media	O
Dealer	i_dealer	O

On Time Drops

Report Name	Filename	Procedure for Scheduling
On Time Drops	ON_TIME_DROPS	DP_CSV6.ON_TIME_DROPS

Parameters:

Title	Name	Mand
Route Code	i_route	O
Outbase	i_depot	O
Dealer	i_dealer	O
Customer	i_customer	O
Media Type	i_media	O
Schedule From	i_sched_from	M
Schedule To	i_sched_to	M

On Time Items

Report Name	Filename	Procedure for Scheduling
On Time Items	ON_TIME_ITEMS	DP_CSV6.ON_TIME_ITEMS

Parameters:

Title	Name	Mand
Schedule From	i_sched_from	M
Schedule To	i_sched_to	M
Customer	i_customer	O
Media Type	i_media	O
Route Code	i_route	O
Dealer	i_dealer	O
Outbase	i_depot	O

On Time Items (Assets)

Report Name	Filename	Procedure for Scheduling
On Time Items (Assets)	ON_TIME_ITEMS	DP_CSV6.ON_TIME_ITEMS_ASSETS

Parameters:

Title	Name	Mand
Schedule To	i_sched_to	M
Schedule From	i_sched_from	M
Route Code	i_route	O
Outbase	i_depot	O
Dealer	i_dealer	O
Customer	i_customer	O
Media Type	i_media	O

On Time Returns

Report Name	Filename	Procedure for Scheduling
On Time Returns	ON_TIME_RETURNS	DP_CSV6.ON_TIME_RETURNS

Parameters:

Title	Name	Mand
Route Code	i_route	O
Media Type	i_media	O
Outbase	i_depot	O
Dealer	i_dealer	O
Customer	i_customer	O
Schedule To	i_sched_to	M
Schedule From	i_sched_from	M

Operational Information

Report Name	Filename	Procedure for Scheduling
Operational Information	Operational_Information	DP_CSV2.OPERATIONAL_INFO

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
To Date	P_END_DATE	M	TODAY
POD	P_POD	O
Carrier	I_FROM_LOC	O		Carrier	Carrier Name	Carrier ID
Location From	P_FROM_LOC	O	STRING	Location From	Location ID	Name
From Date	P_START_DATE	M	TODAY

Order Charges Extract

Report Name	Filename	Procedure for Scheduling
Order Charges Extract	ORD_CHARGE	DP_CSV5.ORD_CHARGE_REPORT

Parameters:

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

Order Extract

Report Name	Filename	Procedure for Scheduling
Order Extract	ORDER_EXTRACT.csv	DP_CSV2.HCR_ORDER_EXTRACT

Parameters:

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

Order Interface Results

Report Name	Filename	Procedure for Scheduling
Order Interface Results	ORDER_INTERFACE_RESULTS	CSV.ORDER_INTERFACE_RESULTS

Parameters:

Title	Name	Mand	Def Type
To Date	i_to_date	O	TODAY
Customer	I_CUSTOMER	O
From Date	i_from_date	O	TODAY
Depot	i_depot	O
	Message Type	O

Order Items POD Debriefed

Report Name	Filename	Procedure for Scheduling
Order Items POD Debriefed	Order_Items_POD_Debriefed	DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED

Parameters:

Title	Name	Mand
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	O
Customer	P_CUSTOMER	O

Order Savings

Report Name	Filename	Procedure for Scheduling
Order Savings	ORDER_SAVINGS	CSV.Order_savings

Parameters:

Title	Name	Mand
Start Schedule	P_START_SCHED	M
End Schedule	P_END_SCHED	O
Show Neg Savings	p_show_only_negative	M

Order Tracking

Report Name	Filename	Procedure for Scheduling
Order Tracking	Order_Tracking	DP_CSV5.ORDER_TRACKING

Parameters:

Title	Name	Mand	Def Type	Def Val
Month	P_MONTH	M
Week Offset	P_WEEK_OFFSET	O
Year	P_YEAR	M
Customer	P_CUSTOMER	O	STRING	OPENFIELD
Cost Centre	P_COST_CENTRE	O	STRING	EXEL

Orders for Relabelling

Report Name	Filename	Procedure for Scheduling
Orders for Relabelling	ORDERS_FOR_RELABELLING	DP_CSV_DHL.ORDERS_FOR_RELABELLING

Parameters:

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

Orders to LogiX

Report Name	Filename	Procedure for Scheduling
Orders to LogiX	LogiX_Orders	DP_LOGIX.ORDER_EXPORT

No parameters

Orders to Paragon

Report Name	Filename	Procedure for Scheduling
Orders to Paragon	Paragon_Orders	CSV.Orders_to_Paragon

No parameters

Outbound Shortage

Report Name	Filename	Procedure for Scheduling
Outbound Shortage	OUTBOUND_SHORTAGE	DP_CSV6.OUTBOUND_SHORTAGE

Parameters:

Title	Name	Mand	Def Type
Dealer	i_dealer	O	STRING
Schedule From	i_sched_from	M
Customer	i_customer	O	STRING
Schedule To	i_sched_to	M
Depot	i_depot	O	STRING
Route	i_route	O	STRING
Media Type	i_media_type	O	STRING

PAYMENT_DTLS

Report Name	Filename	Procedure for Scheduling
PAYMENT_DTLS	PAYMENT_DTLS	OF_INT.WRITE_PAYMENT_DETAILS

Parameters:

Title	Name	Mand	Def Type
Customer	i_cust	M
From Date	i_from_date	M	TODAY
End Date	i_to_date	M	TODAY

POC to SAP Extract

Report Name	Filename	Procedure for Scheduling
POC to SAP Extract	POC to SAP Extract	CSV.POC_to_Sap_Extract

No parameters

POC to SAP Extract(A)

Report Name	Filename	Procedure for Scheduling
POC to SAP Extract(A)	POC to SAP Extract(A)	CSV.POC_to_Sap_Extract

Parameters:

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

POC-POD Reprocessing Team Export

Report Name	Filename	Procedure for Scheduling
POC-POD Reprocessing Team Export	POC_POD_REPOROCESSING	DP_CSV.POC_POD_REPROCESSING

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
To Date	P_END_DATETIME	M	YESTERDAY	YESTERDAY
Date From	P_START_DATETIME	M	TODAY	YESTERDAY:20:00

POD Delivery Extract

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
Customer Group	p_group_name	O	STRING	ALL
Scanning Depot	p_scan_depot	O	STRING	ALL	Depot	Location Id	Name
> Days Outstanding	p_outstanding	O	STRING	0
POD Status	p_pod	O	STRING	ALL
Carrier	p_carrier	O	STRING	ALL
To Schedule	p_to_date	M
From Schedule	p_from_date	M
Customer	p_customer	O	STRING	ALL
Del Msg Sent	p_del_msg_sent	O	STRING	ALL

POD Generation Extract

Report Name	Filename	Procedure for Scheduling
POD Generation Extract	POD_GEN	DP_CSV5.POD_REPORT

Parameters:

Title	Name	Mand	Def Type
POD Flow	P_FLOW	M
Schedule	P_SCHED	O
Date From	P_DATE_FROM	M	TODAY
Date To	P_DATE_TO	M	TODAY

POD to SAP Extract

Report Name	Filename	Procedure for Scheduling
POD to SAP Extract	POD to SAP Extract	CSV.POD_to_Sap_Extract

No parameters

POD to SAP Extract(A)

Report Name	Filename	Procedure for Scheduling
POD to SAP Extract(A)	POD to SAP Extract(A)	CSV.POD_to_Sap_Extract

Parameters:

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

PORSCHE19 Invoice Extract

Report Name	Filename	Procedure for Scheduling
PORSCHE19 Invoice Extract	Invoice_Extract	DP_CSV2.Invoice_Extract

Parameters:

Title	Name	Mand	Def Type	Def Val
Sub Credit Account	p_sub_credit_acc	O	STRING	ALL
Trip ID	p_trip	O	STRING	ALL
Export ID	p_export	O	STRING	0
Customer	p_customer	M	STRING	PORSCHE19
Sub Debit Account	p_sub_debit_acc	O	STRING	ALL
Invoice ID	p_invoice	O	STRING	0

PROVIDER_REVENUE

Report Name	Filename	Procedure for Scheduling
PROVIDER_REVENUE	PROVIDER_REVENUE	dp_csv3.provider_revenue

Parameters:

Title	Name	Mand
Owning Depot	P_OWNING_DEPOT	O
From Schedule	P_START_SCHED	M
To Schedule	P_END_SCHED	M

Parts and Empties

Report Name	Filename	Procedure for Scheduling
Parts and Empites	Parts_and_Empties	DP_CSV5.PARTS_AND_EMPTIES

Parameters:

Title	Name	Mand
Schedule From	P_SCHED_FROM	M
Schedule To	P_SCHED_TO	M
Location From	P_LOCATION	O
Export Type	P_EXPORT_TYPE	M
Customer	P_CUSTOMER	M

PostCode Matrix

Report Name	Filename	Procedure for Scheduling
PostCode Matrix	POSTCODE_MATRIX	dp_csv3.postcode_matrix

No parameters

Pre Invoice Check

Report Name	Filename	Procedure for Scheduling
Pre Invoice Check	Pre_Invoice_Check	CSV.PRE_INVOICE_CHECK

Parameters:

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

Process Items Audit

Report Name	Filename	Procedure for Scheduling
Process Items Audit	PROCESS_ITEMS_AUDIT	DP_CSV6.PROCESS_ITEMS_AUDIT

Parameters:

Title	Name	Mand	Def Type	Def Val
Record Status	i_record_status	M	STRING	ALL
End Date	i_end_datetime	M	TODAY
Start Date	i_start_datetime	M	TODAY
Incl. Reprocessed	i_incl_reprocessed	M	STRING	N

Process Items Interface Audit

Report Name	Filename	Procedure for Scheduling
Process Items Interface Audit	PROCESS_ITEMS_INTERFACE_AUDIT	DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT

Parameters:

Title	Name	Mand	Def Type	Def Val
Incl. Reprocessed	i_incl_reprocessed	M	STRING	N
Record Status	i_record_status	M	STRING	ALL
End Date	i_end_datetime	M	TODAY
Start Date	i_start_datetime	M	TODAY

Provisional Booking Exceptions

Report Name	Filename	Procedure for Scheduling
Provisional Booking Exceptions	Provisional Booking Exceptions	CSV.Provisional_Booking_Exceptions

Parameters:

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

Purchase Order Extract

Report Name	Filename	Procedure for Scheduling
Purchase Order Extract	po_extract	DP_CSV2.PURCHASE_ORDER_EXTRACT

Parameters:

Title	Name	Mand	Def Type	Def Val
To Date	i_end_date	O	TODAY	TODAY
From Date	i_start_date	O	TODAY	TODAY
Status	i_status_id	O	STRING	All

Reason Listings

Report Name	Filename	Procedure for Scheduling
Reason Listings	REASON_LISTING_	dp_csv3.reasons_listing

Parameters:

Title	Name	Mand	Def Type	Def Val
Date To	p_end_datetime	M	TODAY	TODAY:00:01
Depot	p_depot	M
Date From	p_start_datetime	M	TODAY	TODAY:23:59

Receipt Scanning

Report Name	Filename	Procedure for Scheduling
Receipt Scanning	RECEIPT_SCANNING	DP_CSV6.RECEIPT_SCANNING

Parameters:

Title	Name	Mand	Def Type
Depot	i_depot	O	STRING
Dealer	i_dealer	O	STRING
Media Type	i_media_type	O	STRING
Route	i_route	O	STRING
Customer	i_customer	O	STRING
Date To	i_date_to	M	TODAY
Date From	i_date_from	M	TODAY

Receiving Extract

Report Name	Filename	Procedure for Scheduling
Receiving Extract	RECEIVING_EXTRACT	DP_CSV_GEN.EXT_RECEIVING

Parameters:

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

Revenue Check (Account)

Report Name	Filename	Procedure for Scheduling
Revenue Check (Account)	revenue_report	dp_csv_nr.revenue_report

Parameters:

Title	Name	Mand	Def Type
From Date	i_Start_Date_Time	M	TODAY
From Date	i_End_Date_Time	M	TODAY
Customer	i_customer	O
Cust Group	i_cust_group	O
Cost Centre	i_cost_centre	O

SMS Email Summary Report

Report Name	Filename	Procedure for Scheduling
SMS Email Summary Report	sms_email_summary	DP_CSV5.SMS_EMAIL_SUMMARY

Parameters:

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

STL Trip and Order Extract

Report Name	Filename	Procedure for Scheduling
STL Trip and Order Extract	STL_Trip_Order_Extract	DP_CSV2.STL_TRIP_ORDER_EXTRACT

Parameters:

Title	Name	Mand
Order Status	I_ORDER_STATUS	O
End Trip Schedule	I_END_SCHED	M
Location Type	I_LOC_TYPE	O
Start Trip Schedule	I_START_SCHED	M
Carrier	I_CARRIER_ID	O

Sales Margin Extract

Report Name	Filename	Procedure for Scheduling
Sales Margin Extract	sme	CSV.order_costs

Parameters:

Title	Name	Mand
Customer	i_CUSTOMER	O
Customer Group	i_CUST_GROUP	O
Last Schedule	i_sched_to	O
Schedule	i_Sched	M
Carrier Group	i_carr_group	O

Savings Extract

Report Name	Filename	Procedure for Scheduling
Savings Extract	Savings	CSV.SAVINGS_EXTRACT

Parameters:

Title	Name	Mand	Def Type
Credit Acc	I_CREDIT_ACC	O
Saving (> or <)	I_SAVING	O	STRING
Lane Id	I_LANE_ID	O
Customer Group	I_CUST_GROUP	O
To Cty Code	I_TO_CTY	O
From Cty Code	I_FROM_CTY	O
From Date	I_FROM_DATE	O	TODAY
To Date	I_TO_DATE	O	TODAY
Debit Acc	I_DEBIT_ACC	O

Schedule

Report Name	Filename	Procedure for Scheduling
Schedule	Schedule	CSV.SCHEDULE

Parameters:

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

Schedule Details

Report Name	Filename	Procedure for Scheduling
Schedule Details	schedule_details	DP_CSV_GEN.SCHEDULE

Parameters:

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

Schedule Trips CS

Report Name	Filename	Procedure for Scheduling
Schedule Trips CS	SCHED_TRIPS_CS	CSV.SCHEDULE_TRIPS_CS

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Customer	i_customer	O
Schedule	i_Sched	M

Scheduled and Cancelled Orders

Report Name	Filename	Procedure for Scheduling
Scheduled and Cancelled Orders	Schedule_Orders	CSV.SCHEDULE_ORDERS_VS

Parameters:

Title	Name	Mand
Customer	i_CUSTOMER	O
Carrier Group	i_carr_group	O
Last Schedule	i_sched_to	O
Schedule	i_Sched	M
Customer Group	i_CUST_GROUP	O

Scheduled and Cancelled Orders v2

Report Name	Filename	Procedure for Scheduling
Scheduled and Cancelled Orders v2	fn	CSV.SCHEDULE_ORDERS_VS_V2

Parameters:

Title	Name	Mand
Customer	i_CUSTOMER	O
Carrier Group	i_carr_group	O
Last Schedule	i_sched_to	O
Schedule	i_Sched	M
Customer Group	i_CUST_GROUP	O

Short Rail Report

Report Name	Filename	Procedure for Scheduling
Short Rail Report	short_rail_rep	dp_csv_nr.short_rail_report

Parameters:

Title	Name	Mand
Cost Centre	i_cost_centre	O
Product Type	i_product_type	O
End Schedule	i_Sched_To	M
Start Schedule	i_Sched_From	M

Slot Extract

Report Name	Filename	Procedure for Scheduling
Slot Extract	Slot_Extract	DP_CSV3.Slot_Extract

Parameters:

Title	Name	Mand	Def Type	Def Val
Location Type	I_LOC_TYPE	O	String	ALL
Day	I_DAY	O	String	ALL
Slot Type	I_SLOT_TYPE	O	String	ALL

Store PVA

Report Name	Filename	Procedure for Scheduling
Store PVA	STORE_PVA	DP_CSV_DUN.STORE_PVA

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Delivery Date	P_DEL_DATE	M

Store Pre Warning

Report Name	Filename	Procedure for Scheduling
Store Pre Warning	Store_Pre_Warning	CSV.Store_Pre_Warning

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
Depot	i_Depot	O			Depot	Location Id	Name
Store	i_store	O			Store	Location Id	Name
Sched Name	i_sched_name	M
Show empty Slots	i_show_empty_slots	O	STRING	N

Sub Contractor

Report Name	Filename	Procedure for Scheduling
Sub Contractor	SUB_CONTRACTOR	DP_CSV_GEN.SUB_CONTRACTOR

Parameters:

Title	Name	Mand
Cost Centre	P_CC	M
To Sched	P_END_SCHED	M
From Sched	P_START_SCHED	M

Supplier DUs

Report Name	Filename	Procedure for Scheduling
Supplier DUs	SUPPLIER_DU_EXTRACT	DP_CSV_GEN.SUPPLIER_DU_EXTRACT

Parameters:

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

Supplier DUs By Store

Report Name	Filename	Procedure for Scheduling
Supplier DUs By Store	SUPPLIER_DU_BY_STORE_EXTRACT	DP_CSV_GEN.DU_STORE_EXTRACT

Parameters:

Title	Name	Mand	Def Type	Column 1	Column 2	Column 3
Supplier DUs By Store	Start Schedule	P_START_SCHED	M
Supplier DUs By Store	End Schedule	P_END_SCHED	M
Supplier DUs By Store	Store	P_STORE	O	Store	Location ID	Name
Supplier DUs By Store	Order Status	P_STATUS	O

Supplier Invoice

Report Name	Filename	Procedure for Scheduling
Supplier Invoice	Supplier_Invoice	DP_CSV5.SUPPLIER_INVOICE

Parameters:

Title	Name	Mand	Def Type
End Date	P_END_DATE	O
Start Date	P_START_DATE	O
Invoice ID	P_INVOICE_ID	O	STRING

Supplier Revenue

Report Name	Filename	Procedure for Scheduling
Supplier Revenue	SUPPLIER_REVENUE_EXTRACT	DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT

Parameters:

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

Supplier Revenue 2

Report Name	Filename	Procedure for Scheduling
Supplier Revenue 2	SUPPLIER_REVENUE_2_EXTRACT	DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2

Parameters:

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

TYRE SUMMARY EXTRACT

Note: Can be run from Trip Waterfall screen.

Report Name	Filename	Procedure for Scheduling
TYRE SUMMARY EXTRACT	TYRE_SUMMARY_EXTRACT	DP_CSV6.TYRE_SUMMARY_EXTRACT

Parameters:

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

Trip Actuals

Report Name	Filename	Procedure for Scheduling
Trip Actuals	TRIP_ACTUALS	CSV.TRIP_ACTUALS

Parameters:

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

Trip Assessment Extract

Report Name	Filename	Procedure for Scheduling
Trip Assessment Extract	chk_trips	dp_csv_lfs.chk_trips

Parameters:

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

Trip Extract

Report Name	Filename	Procedure for Scheduling
Trip Extract	Trip_Extract	CSV.Trip_Extract

Parameters:

Title	Name	Mand	Def Type
From Date	i_from_date	O	TODAY
To Date	i_to_date	O	TODAY
Carrier	i_carrier	O

Trip and Order Detail Extract

Report Name	Filename	Procedure for Scheduling
Trip and Order Detail Extract	Trip_Order_Detail_Extract	CSV.Trip_Order_Detail_Extract

Parameters:

Title	Name	Mand	Def Val
Start Schedule	P_START_SCHED	M
Location Type	i_loc_type	M	ALL
Carrier	i_carrier_id	O
End Schedule	P_END_SCHED	M

Trunking Report

Report Name	Filename	Procedure for Scheduling
Trunking Report	Trunking_Report	CSV.Trunking_Report

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2
Depot	p_Depot	M			Depot	Location Id	Name
End Schedule	P_END_SCHED	M
Start Schedule	P_START_SCHED	M
Report Type	p_report_type	M	STRING	Revenue

UNISON Interface Results

Report Name	Filename	Procedure for Scheduling
UNISON Interface Results	UNSION_interface_results	CSV.UNISON_if_res

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
Depot	i_depot	O		Depot	Location Id	Name
Customer	I_CUSTOMER	O
To Date	i_to_date	O	TODAY
From Date	i_from_date	O	TODAY

User Activity Extract

Report Name	Filename	Procedure for Scheduling
User Activity Extract	User_Activity_Extract	CSV.User_Activity_Extract

Parameters:

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

User Last Logon Extract

Report Name	Filename	Procedure for Scheduling
User Last Logon Extract	USER_LAST_LOGON	CSV.user_logon_export

Parameters:

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

Variance Analysis Store Detail

Report Name	Filename	Procedure for Scheduling
Variance Analysis Store Detail	VAR_ANLYS_STORE_DTL	CSV.VARIANCE_ANALYSIS_STORE_DTL

Parameters:

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

Variance Analysis Summary

Report Name	Filename	Procedure for Scheduling
Variance Analysis Summary	VAR_ANLYSIS_SUM	CSV.VARIANCE_ANALYSIS_SUMMARY

Parameters:

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

Variance Analysis Trip Detail

Report Name	Filename	Procedure for Scheduling
Variance Analysis Trip Detail	VAR_ANLYS_TRIP_DTL	CSV.VARIANCE_ANALYSIS_TRIP_DTL

Parameters:

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

Vehicle Utilisation

Report Name	Filename	Procedure for Scheduling
Vehicle Utilisation	vehicle_util	dp_csv_nr.vehicle_utilisation

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
Vehicle Utilisation Heavy	hvy_vehicle_util	dp_csv_nr.heavy_vehicle_utilisation

Parameters:

Title	Name	Mand
End Schedule	i_Sched_To	M
Carrier Code	i_carrier_code	O
Carrier Group	i_carrier_group	O
Customer Group	i_cust_group	O
Cost Centre	i_cost_centre	O
Start Schedule	i_Sched_From	M

Vehicle Utilisation Non-Heavy

Report Name	Filename	Procedure for Scheduling
Vehicle Utilisation Non-Heavy	vehicle_util	dp_csv_nr.vehicle_utilisation

Parameters:

Title	Name	Mand
End Schedule	i_Sched_To	M
Customer Group	i_cust_group	O
Carrier Group	i_carrier_group	O
Carrier Code	i_carrier_code	O
Start Schedule	i_Sched_From	M
Cost Centre	i_cost_centre	O

Volume Deviation Extract

Report Name	Filename	Procedure for Scheduling
Volume Deviation Extract	VOLUME_DEVIATION_EXTRACT	DP_CSV5.volume_deviation_report

Parameters:

Title	Name	Mand	Def Type	Def Val
To Date	i_date_to	M	TODAY
Carrier	i_carrier	O		ALL
Trip Leg	i_trip_leg	O	STRING	ALL
Schedule	i_Sched_name	O
From Date	i_date_from	M	TODAY
Deviation	i_deviation	O	STRING	ALL
Cost Centre	I_COST_CENTRE	O		ALL
Include Unpacked	i_inc_unpacked	O	STRING	Y

Volume or Activity

Report Name	Filename	Procedure for Scheduling
Volume or Activity	VOLUME_ACTIVITY	DP_CSV6.VOLUME_ACTIVITY

Parameters:

Title	Name	Mand
Schedule From	i_sched_from	M
Customer	i_customer	O
Media Type	i_media	O
Schedule To	i_sched_to	M
Dealer	i_dealer	O
Depot	i_depot	O
Route Code	i_route	O

WCS Location Snapshot

Report Name	Filename	Procedure for Scheduling
WCS Location Snapshot	WCS_LOC_SANPSHOT	DP_CSV2.wcs_loc_snapshot

No parameters.

WCS Order Items Extract

Report Name	Filename	Procedure for Scheduling
WCS Order Items Extract	WCS_ORDER_ITEMS_EXTRACT	DP_CSV2.WCS_ORDER_ITEMS_EXTRACT

Parameters:

Title	Name	Mand	Def Type	LOV	Column 1	Column 2
To Date	i_end_date	M	TODAY
Trip	i_trip	O	STRING
Customer	i_customer	O
From Date	i_start_date	M	TODAY
Crossdock Depot	i_depot	O		Crossdock Depot	Location Id	Name
Order	i_order	O	STRING

Weekly Transport Report

Report Name	Filename	Procedure for Scheduling
Weekly Transport Report	Weekly_Transport	DP_CSV_BNL.Weekly_Transport

Parameters:

Title	Name	Mand	Def Type	LOV
Weekly Transport Report	To Sched	i_sched_to	M
Weekly Transport Report	From Sched	i_sched_from	M
Weekly Transport Report	Carrier	i_carrier		ALL

XML Order Interface Export

Report Name	Filename	Procedure for Scheduling
XML Order Interface Export	XML_Order_Interface	DP_CSV3.XML_ORDER_INTERFACE

No Parameters

@@ Line 1,522: / Line 1,522: @@
 |End Schedule
 |P_END_SCHED	||O	||	||	||	||	||	||
-|-
-|
-|Start Schedule	||O	||	||	||	||	||	||
-|-
-|
-|Carrier	||O	||	||	||	||	||	||
-|-
-|
-|End Schedule	||O	||	||	||	||	||	||
 |}
@@ Line 2,310: / Line 2,301: @@
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|
+|Start Sched
-|Consignment Num	||O	||STRING	||	||	||	||	||
+|p_start_sched	||O	|| || ||	||	||	||
 |-
-|
+|PO Number
-|Start Sched	||O	||	||	||	||	||	||
+|p_external	||O	||	STRING|| ||	||	||	||
 |-
-|
+|Consignment Num
-|Manifest	||O	||STRING	||	||	||	||	||
+|p_oms	||O	||STRING	||	||	||	||	||
 |-
-|
+|End Sched
-|PO Number	||O	||STRING	||	||	||	||	||
+|p_end_sched	||O	|| || ||	||	||	||
 |-
-|
+|Manifest
-|Supplier	||O	||	||	||	||	||	||
+|p_manifest	||O	||	STRING|| ||	||	||	||
 |-
-|
+|Supplier
-|End Sched	||O	||	||	||	||	||	||
+|p_customer	||O	||	||	||	||	||	||
 |}
@@ Line 2,601: / Line 2,592: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
+|To Date
+|i_End_Date_Time	||M	||	TODAY|| || || || ||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Depot
+|i_Depot_Loc_Id	||M	|| || ||	Depot||	Location  Id||	Name||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|From Date
-|-
+|i_Start_Date_Time	||M	||TODAY	||	||	||	||	||
-|From Date	||M	||TODAY	||	||	||	||	||
-|-
-|To Date	||M	||TODAY	||	||	||	||	||
-|-
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
 |}
@@ Line 2,627: / Line 2,616: @@
 |}
 Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Depot
+|i_Depot_Loc_ID	||M	|| || ||	Depot||	Location  Id||	Name||
+|-
+|From Date
+|i_Start_Date_Time	||M	||TODAY	|| || || || ||
+|-
+|To Date
+|i_End_Date_Time	||M	||	TODAY|| || || || ||
+|}
 ==Detailed Interface Report==
 {| class="wikitable"
@@ Line 2,639: / Line 2,641: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer Group	||O	||	||	||	||	||	||
+|Customer Group
+|i_group_name	||O	||	||	||	||	||	||
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Customer
+|i_customer	||O	|| || ||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Status
+|i_status	||M	||	STRING||	All|| ||	||	||
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|To Date
+|i_to_date	||O	||TODAY	||	||	||	||	||
 |-
-|Status	||M	||STRING	||All	||	||	||	||
+|From Date
+|i_from_date	||O	||TODAY	|| || ||	||	||
 |}
@@ Line 2,664: / Line 2,672: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Start Schedule
+|P_START_SCHED	||M	||	||	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|End Schedule
+|P_END_SCHED	||M	|| ||	||	||	||	||
 |-
-|Depot	||O	||	||	||Depot	||Location Id	||Name	||
+|Depot
+|i_Depot	||O	||	||	||Depot	||Location  Id	||Name	||
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Carrier
+|P_HAULIER	||O	|| ||	||	||	||	||
 |}
@@ Line 2,687: / Line 2,700: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|From Date
+|i_from_date	||O	||TODAY	||	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|To Date
+|i_to_date	||O	||	TODAY|| ||	||	||	||
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Carrier
+|i_carrier	||O	|| || ||	||	||	||
 |}
@@ Line 2,708: / Line 2,725: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Carrier	||O	||	||	||	||	||	||
+|To Date
+|i_to_date	||O	||	TODAY|| ||	||	||	||
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|From Date
+|i_from_date	||O	||TODAY	||	||	||	||	||
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|Carrier
+|i_carrier	||O	|| || ||	||	||	||
 |}
@@ Line 2,729: / Line 2,750: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Cost Centre
+|i_cost_centre	||O	|| || ||	||	||	||
 |-
-|Customer Group	||O	||	||	||	||	||	||
+|Customer Group
+|i_cust_group	||O	||	||	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|To Date
+|i_End_Date_Time	||M	||TODAY	||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|From Date
+|i_Start_Date_Time	||M	||	TODAY|| ||	||	||	||
 |}
@@ Line 2,752: / Line 2,778: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||STRING	||	||	||	||	||
+|Depot
+|i_depot	||O	||STRING	||	||	||	||	||
 |-
-|Dealer	||O	||STRING	||	||	||	||	||
+|Media Type
+|i_media_type	||O	||STRING	||	||	||	||	||
 |-
-|Depot	||O	||STRING	||	||	||	||	||
+|Route
+|i_route	||O	||STRING	||	||	||	||	||
 |-
-|Route	||O	||STRING	||	||	||	||	||
+|Customer
+|i_customer	||O	||STRING	||	||	||	||	||
 |-
-|Media Type	||O	||STRING	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||STRING	||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Activity
+|i_activity	||O	||	STRING|| ||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Schedule To
+|i_sched_to	||M	||	||	||	||	||	||
 |-
-|Activity	||O	||STRING	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	|| || ||	||	||	||
 |}
@@ Line 2,782: / Line 2,817: @@
 |}
 Parameters:
-==Dunelm Actual Unload==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name
-!'''Procedure for Scheduling'''
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
+|-
+|Load Date From
+|i_date_from
+|M
+|
+|
+|
+|
+|
+|
 |-
-|Dunelm Actual  Unload
+|Load Date To
-|DUNELM_ACTUAL_UNLOAD
+|i_date_to
-|DP_CSV_DUN.daily_ext_unload
+|M
+|
+|
+|
+|
+|
+|
 |}
-Parameters:
-==Dunelm Backing Sheet==
+==Dunelm Actual Unload==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,799: / Line 2,855: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Backing  Sheet
+|Dunelm Actual  Unload
-|BACKING_SHEET
+|DUNELM_ACTUAL_UNLOAD
-|DP_CSV2.BACKING_SHEET
+|DP_CSV_DUN.daily_ext_unload
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
-|-
+!Name
-|Manifest	||O	||	||	||	||	||	||
+!Mand
-|-
+!Def Type
-|Customer	||M	||	||	||	||	||	||
+!Def Val
-|-
+!LOV
-|Sched To	||M	||	||	||	||	||	||
+!Column 1
+!Column 2
+!Column 3
+|-
+|Unload Date From
+|i_date_from
+|M
+|
+|
+|
+|
+|
+|
 |-
-|Sched From	||M	||	||	||	||	||	||
+|Unload Date To
+|i_date_to
+|M
+|
+|
+|
+|
+|
+|
 |}
-== Dunelm DUs Despatched Extract ==
+==Dunelm Backing Sheet==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,822: / Line 2,898: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm DUs  Despatched Extract
+|Dunelm Backing  Sheet
-|DUNELM_DUS_DESPATCHED_EXTRACT
+|BACKING_SHEET
-|DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT
+|DP_CSV2.BACKING_SHEET
 |}
 Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Customer
+|i_customer	||O	||	||	||	||	||	||
+|-
+|Sched To
+|i_end_sched	||O	|| ||	||	||	||	||
+|-
+|Sched From
+|i_start_sched	||O	|| ||	||	||	||	||
+|-
+|Manifest
+|i_booking	||O	|| ||	||	||	||	||
+|}
-== Dunelm DUs Not Loaded Extract ==
+== Dunelm DUs Despatched Extract ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,834: / Line 2,926: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm DUs Not  Loaded Extract
+|Dunelm DUs  Despatched Extract
-|DUNELM_DUS_NOT_LOADED_EXTRACT
+|DUNELM_DUS_DESPATCHED_EXTRACT
-|DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT
+|DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT
 |}
 Parameters:
-== Dunelm DUs Not Received ==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name
-!'''Procedure for Scheduling'''
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Dunelm DUs Not  Received
+|PO Number
-|DUNELM_DUS_NOT_RECEIVED
+|p_external
-|DP_CSV_DUN.daily_ext_not_recd
+|O
-|}
+|STRING
-Parameters:
+|
+|
-== Dunelm Inventory Transactions ==
+|
-{| class="wikitable"
+|
-!'''Report Name'''
+|
-!'''Filename'''
-!'''Procedure for Scheduling'''
 |-
-|Dunelm Inventory  Transactions
+|Manifest
-|DUN_INVENTORY_TRANS
+|p_manifest
-|DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS
+|O
-|}
+|STRING
-Parameters:
+|
-{| class="wikitable"
+|
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|
+|
+|
 |-
-|Delivery Trip	||O	||	||	||	||	||	||
+|Supplier
+|p_customer
+|O
+|
+|
+|
+|
+|
+|
 |-
-|Trunk Trip	||O	||	||	||	||	||	||
+|Start Sched
+|p_start_sched
+|O
+|
+|
+|
+|
+|
+|
 |-
-|Collection Trip	||O	||	||	||	||	||	||
+|End Sched
+|p_end_sched
+|O
+|
+|
+|
+|
+|
+|
 |-
-|Store	||O	||	||	||	||	||	||
+|Consignment Num
-|-
+|p_oms
-|Customer	||O	||	||	||	||	||	||
+|O
-|-
+|STRING
-|Date Type	||M	||STRING	||C	||	||	||	||
+|
-|-
+|
-|To Date	||M	||TODAY	||TODAY:23:59	||	||	||	||
+|
-|-
+|
-|From Date	||M	||TODAY	||TODAY:00:00	||	||	||	||
+|
 |}
-==Dunelm Item Movements 3==
+== Dunelm DUs Not Loaded Extract ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,889: / Line 3,009: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Item  Movements 3
+|Dunelm DUs Not  Loaded Extract
-|DUN_ITEM_MOVEMENTS_EXTRACT
+|DUNELM_DUS_NOT_LOADED_EXTRACT
-|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3
+|DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Manifest Number	||O	||	||	||	||	||	||
+|Store
+|p_store
+|O
+|
+|
+|Store
+|Location Id
+|Name
+|
 |-
-|Actual To Date	||M	||TODAY	||	||	||	||	||
+|Schedule
-|-
+|p_sched_date
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|M
-|-
+|
-|DU Type	||O	||	||	||	||	||	||
+|
-|-
+|
-|Supplier	||O	||	||	||	||	||	||
+|
-|-
+|
-|P/O Number	||O	||	||	||	||	||	||
+|
-|-
-|Store	||O	||	||	||	||	||	||
 |}
-==Dunelm Item Movements Extract==
+== Dunelm DUs Not Received ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,918: / Line 3,052: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Item  Movements Extract
+|Dunelm DUs Not  Received
-|DUN_ITEM_MOVEMENTS_EXTRACT
+|DUNELM_DUS_NOT_RECEIVED
-|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT
+|DP_CSV_DUN.daily_ext_not_recd
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
-|-
+!Name
-|Manifest Number	||O	||STRING	||	||	||	||	||
+!Mand
-|-
+!Def Type
-|P/O Number	||O	||	||	||	||	||	||
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Store	||O	||	||	||	||	||	||
+|To Date
+|i_avail_to
+|M
+|
+|
+|
+|
+|
+|
 |-
-|DU Type	||O	||	||	||	||	||	||
+|From Date
-|-
+|i_avail_from
-|Supplier	||O	||	||	||	||	||	||
+|M
-|-
+|
-|Actual To Date	||M	||TODAY	||	||	||	||	||
+|
-|-
+|
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|
+|
+|
 |}
-==Dunelm Item Movements Extract New==
+== Dunelm Inventory Transactions ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,947: / Line 3,095: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Item  Movements Extract New
+|Dunelm Inventory  Transactions
-|DUN_ITEM_MOVEMENTS_EXTRACT
+|DUN_INVENTORY_TRANS
-|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2
+|DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|P/O Number	||O	||	||	||	||	||	||
+|To Date
+|P_DATE_TO	||M	||	TODAY||	TODAY:23:59|| ||	||	||
+|-
+|Trunk Trip
+|P_TRUNK_TRIP	||O	||	||	||	||	||	||
 |-
-|Manifest Number	||O	||STRING	||	||	||	||	||
+|Delivery Trip
+|P_DEL_TRIP	||O	||	||	||	||	||	||
 |-
-|Store	||O	||	||	||	||	||	||
+|Collection Trip
+|P_COL_TRIP	||O	||	||	||	||	||	||
 |-
-|DU Type	||O	||	||	||	||	||	||
+|Date Type
+|P_DATE_TYPE	||M	||	STRING||	C|| ||	||	||
 |-
-|Supplier	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	|| || || ||	||	||
 |-
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|P_DATE_FROM	||M	||TODAY	||TODAY:00:00	|| ||	||	||
 |-
-|Actual To Date	||M	||TODAY	||	||	||	||	||
+|Store
+|i_dealer	||O	|| || || ||	||	||
 |}
-==Dunelm Left Offs==
+==Dunelm Item Movements 3==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,976: / Line 3,135: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Left Offs
+|Dunelm Item  Movements 3
-|Left_Offs_Extract
+|DUN_ITEM_MOVEMENTS_EXTRACT
-|DP_CSV_DUN.left_offs_extract
+|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip Id (Optional)	||O	||	||	||	||	||	||
+|Manifest Number
+|P_MANF_NO	||O	||STRING	|| || || || ||
 |-
-|Days Back	||M	||STRING	||30	||	||	||	||
+|Store
+|P_STORE	||O	|| || || || || ||
 |-
-|Store (Optional)	||O	||	||	||Store	||Location Id	||Name	||
+|Supplier
+|P_SUPPLIER	||O	|| || || || || ||
+|-
+|Actual From Date
+|P_START_DATETIME	||M	||	TODAY|| || || || ||
+|-
+|P/O Number
+|P_PO_NO	||O	|| || || || || ||
+|-
+|DU Type
+|P_DU_TYPE	||O	|| || || || || ||
+|-
+|Actual To Date
+|P_END_DATETIME	||M	||TODAY	|| || || || ||
 |}
-==Dunelm Loading Extract==
+==Dunelm Item Movements Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 2,997: / Line 3,172: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Loading  Extract
+|Dunelm Item  Movements Extract
-|DUNELM_LOADING_EXTRACT
+|DUN_ITEM_MOVEMENTS_EXTRACT
-|DP_CSV2.DUN_LOADING
+|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT
 |}
 Parameters:
-==Dunelm Manifest E-OT-L Extract==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
-!'''Procedure for Scheduling'''
+|-
+|Supplier
+|P_SUPPLIER	||O	|| || || || || ||
+|-
+|Actual To Date
+|P_END_DATETIME	||M	||TODAY	|| || || || ||
+|-
+|Actual From Date
+|P_START_DATETIME	||M	||TODAY	|| || || || ||
+|-
+|DU Type
+|P_DU_TYPE	||O	|| || || || || ||
+|-
+|Store
+|P_STORE	||O	|| || || || || ||
+|-
+|P/O Number
+|P_PO_NO	||O	|| || || || || ||
 |-
-|Dunelm Manifest  E-OT-L Extract
+|Manifest Number
-|DUNELM_MANIFESTED_EOL
+|P_MANF_NO	||O	|| || || || || ||
-|DP_CSV_DUN.daily_ext_manifest
 |}
-Parameters:
-==Dunelm Manual Loaded Items Extract==
+==Dunelm Item Movements Extract New==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,019: / Line 3,209: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Manual  Loaded Items Extract
+|Dunelm Item  Movements Extract New
-|MANL_SCAN_ORDER_DETAIL_EXTRACT
+|DUN_ITEM_MOVEMENTS_EXTRACT
-|DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT
+|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||O	||	||	||	||	||	||
+|Actual To Date
+|P_END_DATETIME	||M	||	TODAY|| ||	||	||	||
+|-
+|Store
+|P_STORE	||O	|| || ||	||	||	||
+|-
+|P/O Number
+|P_PO_NO	||O	||	||	||	||	||	||
 |-
-|To Date	||O	||	||	||	||	||	||
+|Manifest Number
+|P_MANF_NO	||O	||	STRING|| ||	||	||	||
+|-
+|Actual From Date
+|P_START_DATETIME	||M	||	TODAY|| ||	||	||	||
+|-
+|Supplier
+|P_SUPPLIER	||O	|| || ||	||	||	||
+|-
+|DU Type
+|P_DU_TYPE	||O	|| || ||	||	||	||
 |}
-== Dunelm Receiving Extract ==
+==Dunelm Left Offs==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,038: / Line 3,246: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Receiving  Extract
+|Dunelm Left Offs
-|DUNELM_RECEIVING_EXTRACT
+|Left_Offs_Extract
-|DP_CSV2.DUN_RECEIVING
+|DP_CSV_DUN.left_offs_extract
 |}
 Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Store (Optional)
+|P_STORE	||O	||	||	||	Store||	Location Id||	Name||
+|-
+|Trip Id (Optional)
+|P_TRIP_ID	||O	|| || || ||	||	||
+|-
+|Days Back
+|P_DAYS_BACK	||M	||	STRING||	30|| || || ||
+|}
-== Dunelm Recieving E-OT-L Extract ==
+==Dunelm Loading Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,050: / Line 3,271: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Recieving  E-OT-L Extract
+|Dunelm Loading  Extract
-|DUNELM_RECEIPTED_EOL
+|DUNELM_LOADING_EXTRACT
-|DP_CSV_DUN.daily_ext_receipting
+|DP_CSV2.DUN_LOADING
 |}
 Parameters:
+{| class="wikitable"
-== Dunelm Supplier DU Extract ==
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Schedule
+|P_SCHED_DATE	||M	|| || || || || ||
+|}
+==Dunelm Manifest E-OT-L Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,062: / Line 3,289: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Supplier DU  Extract
+|Dunelm Manifest  E-OT-L Extract
-|DUNELM_SUPPLIER_DU_EXTRACT
+|DUNELM_MANIFESTED_EOL
-|DP_CSV2.DUN_SUPPLIER_DU_EXTRACT
+|DP_CSV_DUN.daily_ext_manifest
 |}
 Parameters:
+{| class="wikitable"
-== Dunelm Supplier DU Extract by Store ==
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|To Date
+|i_avail_to	||M	|| || || || || ||
+|-
+|From Date
+|i_avail_from ||M	|| || || || || ||
+|}
+==Dunelm Manual Loaded Items Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,074: / Line 3,310: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Supplier DU  Extract by Store
+|Dunelm Manual  Loaded Items Extract
-|DUNELM_DU_STORE_EXTRACT
+|MANL_SCAN_ORDER_DETAIL_EXTRACT
-|DP_CSV2.DUN_DU_STORE_EXTRACT
+|DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT
 |}
 Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|From Date
+|P_START_DATE	||O	||	||	||	||	||	||
+|-
+|To Date
+|P_END_DATE	||O	||	||	||	||	||	||
+|}
-== Dunelm Supplier Revenue Extract ==
+== Dunelm Receiving Extract ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,086: / Line 3,332: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Supplier  Revenue Extract
+|Dunelm Receiving  Extract
-|DUNELM_SUPPLIER_REVENUE_EXTRACT
+|DUNELM_RECEIVING_EXTRACT
-|DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT
+|DP_CSV2.DUN_RECEIVING
 |}
 Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Schedule
+|P_SCHED_DATE	||M	|| || || || || ||
+|}
-== Dunelm Supplier Revenue Extract New ==
+== Dunelm Recieving E-OT-L Extract ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,098: / Line 3,351: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Supplier  Revenue Extract New
+|Dunelm Recieving  E-OT-L Extract
-|DUNELM_SUPPLIER_REVENUE_NEW
+|DUNELM_RECEIPTED_EOL
-|DP_CSV2.DUN_SUPPLIER_REVENUE_NEW
+|DP_CSV_DUN.daily_ext_receipting
-|}
-Parameters:
-== Dunelm Supplier Trends Extract ==
-{| class="wikitable"
-!'''Report Name'''
-!'''Filename'''
-!'''Procedure for Scheduling'''
-|-
-|Dunelm Supplier  Trends Extract
-|DUN_SUPPLIER_TRENDS
-|dp_csv_dun.dun_du_rpe_revenue_extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Year	||M	||	||	||	||	||	||
+|Start Schedule
+|i_sched_from	||M	|| || || || || ||
 |-
-|Week	||M	||	||	||	||	||	||
+|End Schedule
+|i_sched_to
+|M
+|
+|
+|
+|
+|
+|
 |}
-==Dunelm Transport Plan==
+== Dunelm Supplier DU Extract ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,129: / Line 3,380: @@
 !'''Procedure for Scheduling'''
 |-
-|Dunelm Transport  Plan
+|Dunelm Supplier DU  Extract
-|DUNELM_TRANSPORT_PLAN
+|DUNELM_SUPPLIER_DU_EXTRACT
-|DP_CSV_DUN.daily_transport_plan
+|DP_CSV2.DUN_SUPPLIER_DU_EXTRACT
 |}
 Parameters:
-== Dunelm Unsched Orders ==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name
-!'''Procedure for Scheduling'''
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
+|-
+|To
+|P_TO
+|M
+|
+|TODAY
+|
+|
+|
+|
 |-
-|Dunelm Unsched  Orders
+|From
-|DUNELM_UNSCHED_ORD
+|P_FROM
-|DP_CSV_DUN.daily_unsched_ord
+|M
+|
+|TODAY
+|
+|
+|
+|
 |}
-Parameters:
-==Duplicate Postcodes==
+== Dunelm Supplier DU Extract by Store ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,152: / Line 3,423: @@
 !'''Procedure for Scheduling'''
 |-
-|Duplicate Postcodes
+|Dunelm Supplier DU  Extract by Store
-|DUPLICATE_POSTCODES
+|DUNELM_DU_STORE_EXTRACT
-|dp_csv2.duplicate_postcodes_extract
+|DP_CSV2.DUN_DU_STORE_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
-|-
+!Name
-|Ignore Inactive?	||O	||	||	||	||	||	||
+!Mand
-|-
+!Def Type
-|Location From	||O	||	||	||Location From	||Location Id	||Location Name	||
+!Def Val
-|-
+!LOV
-|Location To	||O	||	||	||Location To	||Location Id	||Location Name	||
+!Column 1
+!Column 2
+!Column 3
+|-
+|Order Status
+|P_STATUS
+|O
+|
+|
+|
+|
+|
+|
+|-
+|Start Schedule
+|P_START_SCHED
+|M
+|
+|
+|
+|
+|
+|
+|-
+|End Schedule
+|P_END_SCHED
+|M
+|
+|
+|
+|
+|
+|
+|-
+|Store
+|P_STORE
+|O
+|
+|
+|Store
+|Location  Id
+|Name
+|
 |}
-==EFX Inbound Errors==
+== Dunelm Supplier Revenue Extract ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,173: / Line 3,486: @@
 !'''Procedure for Scheduling'''
 |-
-|EFX Inbound Errors
+|Dunelm Supplier  Revenue Extract
-|EFX_Inbound_Errors
+|DUNELM_SUPPLIER_REVENUE_EXTRACT
-|DP_CSV2.EFX_In_Errs_Extract
+|DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT
 |}
 Parameters:
-==ERC==
+{| class="wikitable"
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
+|-
+|End Schedule
+|P_END_SCHED
+|M
+|
+|
+|
+|
+|
+|
+|-
+|Start Schedule
+|P_START_SCHED
+|M
+|
+|
+|
+|
+|
+|
+|}
+== Dunelm Supplier Revenue Extract New ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,184: / Line 3,529: @@
 !'''Procedure for Scheduling'''
 |-
-|ERC
+|Dunelm Supplier  Revenue Extract New
-|ERC
+|DUNELM_SUPPLIER_REVENUE_NEW
-|DP_CSV_DHL.ERC
+|DP_CSV2.DUN_SUPPLIER_REVENUE_NEW
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Sched End	||M	||	||	||	||	||	||
+|Revenue End
+|P_REVENUE_END
+|M
+|
+|TODAY
+|
+|
+|
+|
 |-
-|Sched Start	||M	||	||	||	||	||	||
+|Revenue Start
-|-
+|P_REVENUE_START
-|Carrier	||O	||	||	||	||	||	||
+|M
-|-
+|
-|DHL Carriers	||M	||	||	||	||	||	||
+|TODAY
-|-
+|
-|Detail Level	||M	||	||	||	||	||	||
+|
+|
+|
 |}
-==Equipment Moves==
+== Dunelm Supplier Trends Extract ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,209: / Line 3,572: @@
 !'''Procedure for Scheduling'''
 |-
-|Equipment Moves
+|Dunelm Supplier  Trends Extract
-|Equip_Move
+|DUN_SUPPLIER_TRENDS
-|DP_CSV2.EQUIP_MOVE
+|dp_csv_dun.dun_du_rpe_revenue_extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Owning Depot	||O	||	||	||	||	||	||
+|Week
+|i_week_no	||M	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Year
-|-
+|i_year	||M	||	||	||	||	||	||
-|To Date	||M	||TODAY	||	||	||	||	||
-|-
-|From Date	||M	||TODAY	||	||	||	||	||
-|-
-|Carrier	||O	||	||	||	||	||	||
 |}
-==Extract Lane==
+==Dunelm Transport Plan==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,234: / Line 3,594: @@
 !'''Procedure for Scheduling'''
 |-
-|Extract Lane
+|Dunelm Transport  Plan
-|EXTRACT_LANE
+|DUNELM_TRANSPORT_PLAN
-|CSV.EXTRACT_BY_LANE
+|DP_CSV_DUN.daily_transport_plan
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Cost Centre	||O	||	||	||Cost Centre	||Location Id	||Name	||
+|From Date
+|i_avail_from ||M	|| || || || || ||
+|-
+|Order Status
+|i_ord_status	||M	||	STRING||	ALL|| || || ||
+|-
+|Supplier
+|i_supplier
+|M
+|STRING
+|ALL
+|
+|
+|
+|
 |-
-|Customer	||O	||	||	||	||	||	||
+|To Date
+|i_avail_to
+|M
+|
+|
+|
+|
+|
+|
 |}
-==Failed Shipment==
+== Dunelm Unsched Orders ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,253: / Line 3,636: @@
 !'''Procedure for Scheduling'''
 |-
-|Failed Shipment
+|Dunelm Unsched  Orders
-|FAILED_SHIPMENT
+|DUNELM_UNSCHED_ORD
-|dp_csv3.failed_shipment
+|DP_CSV_DUN.daily_unsched_ord
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|To Date
+|i_avail_to
+|M
+|
+|
+|
+|
+|
+|
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|From Date
-|-
+|i_avail_from
-|Customer	||O	||STRING	||OPENFIELD	||	||	||	||
+|M
+|
+|
+|
+|
+|
+|
 |}
-==Fixed Routes Extract==
+==Duplicate Postcodes==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,274: / Line 3,679: @@
 !'''Procedure for Scheduling'''
 |-
-|Fixed Routes  Extract
+|Duplicate Postcodes
-|Routes_Extract
+|DUPLICATE_POSTCODES
-|CSV.FIXED_ROUTES_EXPORT
+|dp_csv2.duplicate_postcodes_extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Show Active / Inactive	||M	||STRING	||B	||	||	||	||
+|Location To
+|P_LOCATION_TO	||O	||	||	||	Location To||	Location Id||	Location Name||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Ignore Inactive?
+|P_IGNORE_INACTIVE	||O	||	||	|| || || ||
 |-
-|Depot	||O	||	||	||Depot	||Location Id	||Name	||
+|Location From
+|P_LOCATION_FROM	||O	||	||	||Location  From	||Location  Id	||Location  Name	||
 |}
-==GREENE KING Interface Results==
+==EFX Inbound Errors==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,295: / Line 3,704: @@
 !'''Procedure for Scheduling'''
 |-
-|GREENE KING  Interface Results
+|EFX Inbound Errors
-|GREENE_KING_interface_results
+|EFX_Inbound_Errors
-|CSV.GREENE_KING_if_res
+|DP_CSV2.EFX_In_Errs_Extract
 |}
-Parameters:
+No parameters.
+==ERC==
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
 |-
-|Customer	||O	||	||	||	||	||	||
+|ERC
-|-
+|ERC
-|Depot	||O	||	||	||	||	||	||
+|DP_CSV_DHL.ERC
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|DHL Carriers
+|i_dhl_carr	||M	||	||	||	||	||	||
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|Detail Level
+|i_detail	||M	||	||	||	||	||	||
+|-
+|Sched Start
+|i_sched_from	||M	|| ||	||	||	||	||
+|-
+|Carrier
+|i_carrier	||O	|| ||	||	||	||	||
+|-
+|Sched End
+|i_sched_to	||M	||	||	||	||	||	||
 |}
-==GYP EFX Export==
+==Equipment Moves==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,318: / Line 3,746: @@
 !'''Procedure for Scheduling'''
 |-
-|GYP EFX Export
+|Equipment Moves
-|GYP_EFX_Export
+|Equip_Move
-|DP_CSV5.GYP_EFX_EXPORT
+|DP_CSV2.EQUIP_MOVE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip Status	||O	||	||	||	||	||	||
+|Owning depot
+|i_depot	||O	||	||	||	||	||	||
 |-
-|To Schedule	||M	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|From Schedule	||M	||	||	||	||	||	||
+|To Date
+|i_date_to	||M	||TODAY	||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|From Date
+|i_date_from	||M	||TODAY	||	||	||	||	||
 |-
-|Customer Group	||O	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |}
-==HC Booking In Form==
+==Extract Lane==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,343: / Line 3,777: @@
 !'''Procedure for Scheduling'''
 |-
-|HC Booking In Form
+|Extract Lane
-|HC_BOOKING_IN_FORM
+|EXTRACT_LANE
-|DP_CSV5.P_HC_BOOKING_IN_FORM
+|CSV.EXTRACT_BY_LANE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||Cost Centre	||Location Id	||Name	||
 |-
-|Group Name	||O	||	||	||	||	||	||
+|Customer
-|-
+|I_CUSTOMER	||O	||	||	||	||	||	||
-|Delivery Location	||O	||	||	||	||	||	||
-|-
-|Customer	||O	||	||	||	||	||	||
-|-
-|Group Name	||O	||	||	||	||	||	||
-|-
-|Schedule	||M	||	||	||	||	||	||
-|-
-|Delivery Location	||O	||	||	||	||	||	||
-|-
-|Customer	||O	||	||	||	||	||	||
 |}
-==HC Haulier Trip Sheet==
+==Failed Shipment==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,374: / Line 3,799: @@
 !'''Procedure for Scheduling'''
 |-
-|HC Haulier Trip  Sheet
+|Failed Shipment
-|HAULIER_TRIP_SHEET
+|FAILED_SHIPMENT
-|DP_CSV2.HAULIER_TRIP_SHEET
+|dp_csv3.failed_shipment
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip ID (optional)	||O	||	||	||	||	||	||
+|Schedule To
+|I_SCHED_TO	||M	||	||	||	||	||	||
 |-
-|Owning Depot	||O	||	||	||Depot	||Location Id	||Name	||
+|Schedule From
+|I_SCHED_FROM	||M	||	||	||	||	||	||
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Customer
-|-
+|I_CUSTOMER	||O	||STRING	||OPENFIELD	||	||	||	||
-|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==
+==Fixed Routes Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,413: / Line 3,824: @@
 !'''Procedure for Scheduling'''
 |-
-|HCR Customer Orders
+|Fixed Routes  Extract
-|HCR_CUSTOMER_ORDERS
+|Routes_Extract
-|DP_CSV_DHL.HCR_CUSTOMER_ORDERS
+|CSV.FIXED_ROUTES_EXPORT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||	||	||	||	||	||
+|Show Active / Inactive
+|i_inactive	||M	||STRING	||B	||	||	||	||
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Depot
-|-
+|i_depot	||O	||	||	||Depot	||Location  Id	||Name	||
-|Depot	||O	||	||	||	||	||	||
 |}
-==HCR Loading Sheet CSV==
+==GREENE KING Interface Results==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,436: / Line 3,849: @@
 !'''Procedure for Scheduling'''
 |-
-|HCR Loading Sheet  CSV
+|GREENE KING  Interface Results
-|HCR_LOADING_SHEET
+|GREENE_KING_interface_results
-|DP_CSV5.HCR_LOADING_SHEET
+|CSV.GREENE_KING_if_res
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip ID (optional)	||O	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |-
-|Load Location	||O	||	||	||Loading Location	||Loading Location	||Name	||
+|Depot
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Owning Depot	||O	||	||	||Depot	||Loading Location	||Name	||
+|To Date
+|i_to_date	||O	||TODAY	||	||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|From Date
-|-
+|i_from_date	||O	||TODAY	||	||	||	||	||
-|Schedule To	||M	||	||	||	||	||	||
-|-
-|Carrier	||O	||	||	||	||	||	||
-|-
-|Customer	||O	||	||	||	||	||	||
-|-
-|Group Name	||O	||	||	||	||	||	||
 |}
-==Haulier Invoice==
+==GYP EFX Export==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,467: / Line 3,877: @@
 !'''Procedure for Scheduling'''
 |-
-|Haulier Invoice
+|GYP EFX Export
-|Haulier_Invoice
+|GYP_EFX_Export
-|DP_CSV5.HAULIER_INVOICE
+|DP_CSV5.GYP_EFX_EXPORT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|End Date	||O	||	||	||	||	||	||
+|Trip Status
+|I_STATUS	||O	||	||	||	||	||	||
 |-
-|Start Date	||O	||	||	||	||	||	||
+|To Schedule
+|P_END_SCHED	||M	||	||	||	||	||	||
 |-
-|Invoice ID	||O	||STRING	||	||	||	||	||
+|From Schedule
+|P_START_SCHED	||M	||	||	||	||	||	||
 |-
-|End Date	||O	||	||	||	||	||	||
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||	||	||	||
 |-
-|Start Date	||O	||	||	||	||	||	||
+|Customer Group
-|-
+|I_CUST_GRP	||O	||	||	||	||	||	||
-|Invoice ID	||O	||STRING	||	||	||	||	||
 |}
-==Heavy Vehicle Utilisation==
+==HC Booking In Form==
-{{Warning}}Missing
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,495: / Line 3,908: @@
 !'''Procedure for Scheduling'''
 |-
-|
+|HC Booking In Form
-|
+|HC_BOOKING_IN_FORM
-|
+|DP_CSV5.P_HC_BOOKING_IN_FORM
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Schedule
+|I_SCHED_NAME	||M	||	||	||	||	||	||
+|-
+|Group Name
+|I_GROUP_NAME	||O	||	||	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |-
-|Customer Group	||O	||	||	||	||	||	||
+|Delivery Location
+|I_DEL_LOCATION	||O	||	||	||	||	||	||
 |}
-==Historical Lane Based Orders==
+==HC Haulier Trip Sheet==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,516: / Line 3,936: @@
 !'''Procedure for Scheduling'''
 |-
-|
+|HC Haulier Trip  Sheet
-|
+|HAULIER_TRIP_SHEET
-|
+|DP_CSV2.HAULIER_TRIP_SHEET
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Trip ID (optional)
+|i_trip_id	||O	||	||	||	||	||	||
+|-
+|Owning Depot
+|i_depot	||O	||	||	||Depot	||Location  Id	||Name	||
+|-
+|Load Location
+|i_load_loc	||O	|| ||	||	Loading  Location||	Location  Id||	Name||
+|-
+|Group Name
+|i_group_name	||O	||	||	||	||	||	||
+|-
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Schedule
+|i_sched	||M	|| ||	|| || || ||
 |}
-==IND Trip and Order Detail==
+==HCR Customer Orders==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,535: / Line 3,970: @@
 !'''Procedure for Scheduling'''
 |-
-|IND Trip and Order  Detail
+|HCR Customer Orders
-|IND_Trip_Order_Detail_Extract
+|HCR_CUSTOMER_ORDERS
-|DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT
+|DP_CSV_DHL.HCR_CUSTOMER_ORDERS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Activity	||M	||STRING	||Both	||	||	||	||
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Depot
+|P_LOCATION	||O	|| ||	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |-
-|Loaded At	||O	||	||	||	||	||	||
+|Schedule
-|-
+|I_SCHED_NAME	||M	|| ||	||	||	||	||
-|Start Schedule	||M	||	||	||	||	||	||
-|-
-|Group Name	||M	||	||	||	||	||	||
 |}
-==ISC Finance (2) Export==
+==HCR Loading Sheet CSV==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,562: / Line 3,998: @@
 !'''Procedure for Scheduling'''
 |-
-|ISC Finance (2)  Export
+|HCR Loading Sheet  CSV
-|FINANCE_2_EXPORT
+|HCR_LOADING_SHEET
-|DP_CSV2.FINANCE_EXPORT_V2
+|DP_CSV5.HCR_LOADING_SHEET
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||M	||STRING	||ALL	||	||	||	||
+|Carrier
+|P_CARRIER	||O	||	||	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Group Name
+|P_GROUP_NAME	||O	||	||	|| || || ||
+|-
+|Owning Depot
+|P_OWNING_DEPOT	||O	||	||	||Depot	||Loading  Location	||Name	||
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Customer
+|P_CUSTOMER	||O	|| ||	||	||	||	||
+|-
+|Schedule To
+|P_SCHED_TO	||M	||	||	||	||	||	||
+|-
+|Trip ID (optional)
+|P_TRIP_ID	||O	||	||	||	||	||	||
+|-
+|Load Location
+|P_LOAD_LOC	||O	||	||	||	Loading  Location||	Loading  Location||	Name||
+|-
+|Schedule From
+|P_SCHED_FROM	||M	|| ||	||	||	||	||
 |}
-== ISC Finance (3) Export ==
+==Haulier Invoice==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,583: / Line 4,038: @@
 !'''Procedure for Scheduling'''
 |-
-|ISC Finance (3)  Export
+|Haulier Invoice
-|FINANCE_2_EXPORT
+|Haulier_Invoice
-|CSV6.ISC_FINANCE_2_EXPORT
+|DP_CSV5.HAULIER_INVOICE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||M	||STRING	||ALL	|| || || ||
+|Invoice ID
-|-
+|P_INVOICE_ID	||O	||	STRING|| ||	||	||	||
-|End Schedule	||M	|| || || || || ||
-|-
-|Start Schedule	||M	|| || || || || ||
 |}
-== ISC Finance (4) Export ==
+==Heavy Vehicle Utilisation==
+{{Warning}}Missing
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,604: / Line 4,058: @@
 !'''Procedure for Scheduling'''
 |-
-|ISC Finance (4)  Export
+|
-|FINANCE_2_EXPORT
+|
-|CSV7.FINANCE_EXPORT_V2
+|
 |}
 Parameters:
@@ Line 3,612: / Line 4,066: @@
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||M	||STRING	||ALL	|| || || ||
+|Start Schedule	||M	||	||	||	||	||	||
 |-
-|End Schedule	||M	|| || || || || ||
+|End Schedule	||M	||	||	||	||	||	||
 |-
-|Start Schedule	||M	|| || || || || ||
+|Customer Group	||O	||	||	||	||	||	||
 |}
-==Interface Errors Failures==
+==Historical Lane Based Orders==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,625: / Line 4,079: @@
 !'''Procedure for Scheduling'''
 |-
-|Interface Errors  Failures
+|
-|Interface_Errors_Failures
+|
-|DP_CSV5.INTERFACE_ERRORS_FAILURES
+|
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|External Ref	||O	||STRING	||	||	||	||	||
+|From Date
+|I_FROM_DATE	||M	||TODAY	||	||	||	||	||
 |-
-|Customer	||O	||	||	||Customer	||	||	||
+|To Date
-|-
+|I_TO_DATE	||O	||TODAY	||	||	||	||	||
-|Source System	||O	||	||	||	||	||	||
-|-
-|End Date	||M	||TODAY	||	||	||	||	||
-|-
-|Start Date	||M	||TODAY	||	||	||	||	||
 |}
-==Invalid Orders==
+==IND Trip and Order Detail==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,650: / Line 4,101: @@
 !'''Procedure for Scheduling'''
 |-
-|Invalid Orders
+|IND Trip and Order  Detail
-|Invalid_Orders
+|IND_Trip_Order_Detail_Extract
-|DP_CSV6.INVALID_ORDERS
+|DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|End Schedule
+|P_END_SCHED	||M	|| || || ||	||	||
+|-
+|Activity
+|i_activity_name	||M	||	STRING||	Both|| ||	||	||
+|-
+|Loaded At
+|i_loaded_at	||O	||	||	||	||	||	||
+|-
+|Start Schedule
+|P_START_SCHED	||M	|| ||	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Carrier
+|i_carrier_id	||O	|| ||	||	||	||	||
 |-
-|Customer	||0	||	||	||	||	||	||
+|Group Name
+|i_group_name	||M	||	||	||	||	||	||
 |}
-==Item Movements==
+==ISC Finance (2) Export==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,671: / Line 4,135: @@
 !'''Procedure for Scheduling'''
 |-
-|Item Movements
+|ISC Finance (2)  Export
-|ITEM_MOVEMENTS_EXTRACT
+|FINANCE_2_EXPORT
-|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT
+|DP_CSV2.FINANCE_EXPORT_V2
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Actual To Date	||M	||TODAY	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||M	||STRING	||ALL	||	||	||	||
 |-
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|Start Schedule
+|I_FROM_SCHED_NAME	||M	||	||	||	||	||	||
 |-
-|Supplier	||O	||	||	||	||	||	||
+|End Schedule
-|-
+|I_TO_SCHED_NAME	||M	||	||	||	||	||	||
-|DU Type	||O	||	||	||	||	||	||
-|-
-|Store	||O	||	||	||	||	||	||
-|-
-|Manifest Number	||O	||	||	||	||	||	||
-|-
-|P/O Number	||O	||	||	||	||	||	||
 |}
-==Item Movements 2==
+== ISC Finance (3) Export ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,700: / Line 4,160: @@
 !'''Procedure for Scheduling'''
 |-
-|Item Movements 2
+|ISC Finance (3)  Export
-|ITEM_MOVEMENTS_2_EXTRACT
+|FINANCE_2_EXPORT
-|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2
+|CSV6.ISC_FINANCE_2_EXPORT
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title !! Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2
+!Column 3
 |-
-|DU Type	||O	||	||	||	||	||	||
+|Customer	||I_CUSTOMER	||M	||STRING	|| ALL|| || ||
+|
 |-
-|Supplier	||O	||	||	||	||	||	||
+|Start Schedule	||I_FROM_SCHED_NAME	|| M|| || || || ||
+|
 |-
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|End Schedule	||I_TO_SCHED_NAME	|| M|| || || || ||
-|-
+|
-|Actual To Date	||M	||TODAY	||	||	||	||	||
-|-
-|P/O Number	||O	||	||	||	||	||	||
-|-
-|Store	||O	||	||	||	||	||	||
-|-
-|Manifest Number	||O	||	||	||	||	||	||
 |}
-==Item Movements 3==
+== ISC Finance (4) Export ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,729: / Line 4,185: @@
 !'''Procedure for Scheduling'''
 |-
-|Item Movements 3
+|ISC Finance (4)  Export
-|ITEM_MOVEMENTS_3_EXTRACT
+|FINANCE_2_EXPORT
-|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3
+|CSV7.FINANCE_EXPORT_V2
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title !! Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2
+!Column 3
 |-
-|P/O Number	||O	||	||	||	||	||	||
+|Customer	||I_CUSTOMER	||M	||STRING	|| ALL|| || ||
+|
 |-
-|Store	||O	||	||	||	||	||	||
+|Start Schedule	||I_FROM_SCHED_NAME	|| M|| || || || ||
+|
 |-
-|Manifest Number	||O	||	||	||	||	||	||
+|End Schedule	||I_TO_SCHED_NAME	|| M|| || || || ||
-|-
+|
-|DU Type	||O	||	||	||	||	||	||
-|-
-|Supplier	||O	||	||	||	||	||	||
-|-
-|Actual To Date	||M	||TODAY	||	||	||	||	||
-|-
-|Actual From Date	||M	||TODAY	||	||	||	||	||
 |}
-==Items Not Scanned By Date==
+==Interface Errors Failures==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,758: / Line 4,210: @@
 !'''Procedure for Scheduling'''
 |-
-|Items Not Scanned  By Date
+|Interface Errors  Failures
-|Items_Not_Scanned
+|Interface_Errors_Failures
-|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE
+|DP_CSV5.INTERFACE_ERRORS_FAILURES
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Source System
+|P_SOURCE_SYSTEM	||O	|| || ||	Source System|| ||	||
+|-
+|Customer
+|P_CUSTOMER	||O	||	||	||Customer	||	||	||
+|-
+|External Ref
+|P_EXTERNAL_REF	||O	||	STRING|| ||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|End Date
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Depot	||M	||	||	||	||	||	||
+|Start Date
+|P_START_DATETIME	||M	||TODAY	||	||	||	||	||
 |}
-==Items Not Scanned By Trip==
+==Invalid Orders==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,779: / Line 4,241: @@
 !'''Procedure for Scheduling'''
 |-
-|Items Not Scanned  By Trip
+|Invalid Orders
-|Items_Not_Scanned
+|Invalid_Orders
-|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP
+|DP_CSV6.INVALID_ORDERS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip	||M	||	||	||	||	||	||
+|Customer
+|i_customer	||0	|| ||	||	||	||	||
 |-
-|Schedule	||M	||	||	||	||	||	||
+|End Schedule
+|i_end_sched	||M	||	||	||	||	||	||
+|-
+|Start Schedule
+|i_start_sched	||M	|| ||	||	||	||	||
 |}
-==JEYES Interface Results==
+==Item Movements==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,798: / Line 4,266: @@
 !'''Procedure for Scheduling'''
 |-
-|JEYES Interface  Results
+|Item Movements
-|JEYES_interface_results
+|ITEM_MOVEMENTS_EXTRACT
-|CSV.JEYES_if_res
+|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Actual From Date
+|P_START_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Actual To Date
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Depot	||O	||	||	||	||	||	||
+|Supplier
+|P_SUPPLIER	||O	||	||	||	||	||	||
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|DU Type
+|P_DU_TYPE	||O	||	||	||	||	||	||
+|-
+|Manifest Number
+|P_MANF_NO	||O	||	||	||	||	||	||
+|-
+|P/O Number
+|P_PO_NO	||O	||	||	||	||	||	||
+|-
+|Store
+|P_STORE	||O	||	||	||	||	||	||
 |}
-==Job Notes==
+==Item Movements 2==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,821: / Line 4,303: @@
 !'''Procedure for Scheduling'''
 |-
-|Job Notes
+|Item Movements 2
-|Job_Notes
+|ITEM_MOVEMENTS_2_EXTRACT
-|DP_CSV5.JOB_NOTES
+|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2
 |}
 Parameters:
-==KPI By Lane==
 {| class="wikitable"
-!'''Report Name'''
+!Title !! Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2
-!'''Filename'''
+!Column 3
-!'''Procedure for Scheduling'''
 |-
-|KPI By Lane
+|Actual From Date	||P_START_DATETIME	||	M||	TODAY|| ||	||	||
-|KPI_BY_LANE
+|
-|CSV.KPI_BY_LANE
-|}
-Parameters:
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer Group	||O	||	||	||	||	||	||
+|Actual To Date	||P_END_DATETIME	||	M||	TODAY|| ||	||	||
+|
 |-
-|End Date	||M	||	||	||	||	||	||
+|Supplier	||P_SUPPLIER	||O	|| ||	||	||	||
+|
 |-
-|Show Detail	||M	||STRING	||Y	||	||	||	||
+|DU Type	||P_DU_TYPE	||O	|| ||	||	||	||
+|
 |-
-|Grouping	||M	||STRING	||CUST_GROUP	||	||	||	||
+|Manifest Number	||P_MANF_NO	||	O|| ||	||	||	||
+|
 |-
-|End Date	||M	||TODAY	||	||	||	||	||
+|P/O Number	||P_PO_NO	||	O|| ||	||	||	||
+|
 |-
-|Start Date	||M	||TODAY	||	||	||	||	||
+|Store	||P_STORE	||	O|| ||	||	||	||
-|-
+|
-|Start Date	||M	||	||	||	||	||	||
-|-
-|Tolerance(days)	||O	||	||	||	||	||	||
-|-
-|Separate Pages	||M	||STRING	||N	||	||	||	||
-|-
-|Customer Group	||O	||	||	||	||	||	||
-|-
-|Grouping	||M	||STRING	||CUST_GROUP	||	||	||	||
 |}
-==KPI Extract==
+==Item Movements 3==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,869: / Line 4,340: @@
 !'''Procedure for Scheduling'''
 |-
-|KPI Extract
+|Item Movements 3
-|CN_KPI_Extract
+|ITEM_MOVEMENTS_3_EXTRACT
-|KPI_EXTRACT.KPI_EXTRACT
+|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3
 |}
 Parameters:
-==Kraft KPI==
 {| class="wikitable"
-!'''Report Name'''
+!Title !! Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2
-!'''Filename'''
+!Column 3
-!'''Procedure for Scheduling'''
+|-
+|Actual From Date	||P_START_DATETIME	||	M||	TODAY|| ||	||	||
+|
+|-
+|Actual To Date	||P_END_DATETIME	||	M||	TODAY|| ||	||	||
+|
+|-
+|Supplier	||P_SUPPLIER	||	O|| ||	||	||	||
+|
 |-
-|Kraft KPI
+|DU Type	||P_DU_TYPE	||	O|| ||	||	||	||
-|KRAFT_KPI
+|
-|CSV.Trips_with_Orders
-|}
-Parameters:
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Manifest Number	||P_MANF_NO	||	O|| ||	||	||	||
+|
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|P/O Number	||P_PO_NO	||O	|| ||	||	||	||
+|
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Store	||P_STORE	||O	|| ||	||	||	||
+|
 |}
-==LFS Packages==
+==Items Not Scanned By Date==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,901: / Line 4,377: @@
 !'''Procedure for Scheduling'''
 |-
-|LFS Packages
+|Items Not Scanned  By Date
-|LFS_Packages
+|Items_Not_Scanned
-|DP_CSV_LFS.LFS_PACKAGES
+|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule 	||M	||	||	||	||	||	||
+|Depot
+|P_DEPOT	||M	||	||	||	||	||	||
 |-
-|Order Status 	||O	||	||	||	||	||	||
+|Schedule To
+|P_END_SCHED	||M	||	||	||	||	||	||
 |-
-|Customer 	||O	||	||	||	||	||	||
+|Schedule From
-|-
+|P_START_SCHED	||M	||	||	||	||	||	||
-|External Ref	||O	||	||	||	||	||	||
 |}
-==Lane Extract==
+==Items Not Scanned By Trip==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,924: / Line 4,402: @@
 !'''Procedure for Scheduling'''
 |-
-|Lane Extract
+|Items Not Scanned  By Trip
-|Lane_Extract
+|Items_Not_Scanned
-|CSV.LANE_EXPORT
+|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||	||	||	||	||	||
+|Schedule
-|-
+|P_SCHED	||M	||	||	||	||	||	||
-|Cost Centre	||O	||	||	||	||	||	||
-|-
-|To Loc	||O	||	||	||To Loc	||Location Id	||Name	||
 |-
-|From Loc	||O	||	||	||From Loc	||Location Id	||Name	||
+|Trip
+|P_TRIP_ID	||M	||	||	||	||	||	||
 |}
-==Left Offs==
+==JEYES Interface Results==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,947: / Line 4,424: @@
 !'''Procedure for Scheduling'''
 |-
-|Left Offs
+|JEYES Interface  Results
-|LEFT_OFFS_EXTRACT
+|JEYES_interface_results
-|DP_CSV_GEN.LEFT_OFFS_EXTRACT
+|CSV.JEYES_if_res
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Store (optional)	||O	||	||	||Store	||Location ID	||Name	||
+|Customer
+|I_CUSTOMER	||O	|| || ||	||	||	||
+|-
+|Depot
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Days Back	||M	||STRING	||30	||	||	||	||
+|From Date
+|i_from_date	||O	||	TODAY|| ||	||	||	||
 |-
-|Trip ID (optional)	||O	||	||	||	||	||	||
+|To Date
+|i_to_date	||O	||TODAY	||	||	||	||	||
 |}
-==Loading Extract==
+==Job Notes==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 3,968: / Line 4,452: @@
 !'''Procedure for Scheduling'''
 |-
-|Loading Extract
+|Job Notes
-|LOADING_EXTRACT
+|Job_Notes
-|DP_CSV_GEN.EXT_LOADING
+|DP_CSV5.JOB_NOTES
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Date from
-|}
+|i_date_from
+|M
-==Loading Schedule CSV==
+|
-{| class="wikitable"
+|
-!'''Report Name'''
+|
-!'''Filename'''
+|
-!'''Procedure for Scheduling'''
+|
+|
 |-
-|Loading Schedule  CSV
+|OMS Ref To
-|Loading_Schedule
+|i_oms_to
-|CSV.LOADING_SCHEDULE
+|O
-|}
+|
-Parameters:
+|
-{| class="wikitable"
+|
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|
+|
+|
 |-
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
+|OMS Ref From
+|i_oms_from
+|O
+|
+|
+|
+|
+|
+|
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Date to
+|i_date_to
+|M
+|
+|
+|
+|
+|
+|
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Customer
+|i_customer
+|O
+|
+|
+|
+|
+|
+|
 |}
-==Location Export==
+==KPI By Lane==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,006: / Line 4,525: @@
 !'''Procedure for Scheduling'''
 |-
-|Location Export
+|KPI By Lane
-|Location_Export
+|KPI_BY_LANE
-|DP_CSV2.LOCATION_EXPORT
+|CSV.KPI_BY_LANE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Country	||O	||	||	||	||	||	||
+|Start Date
+|I_START_DATE_TIME	||M	||	TODAY|| ||	||	||	||
+|-
+|Tolerance(days)
+|I_TOLERANCE	||O	|| ||	||	||	||	||
+|-
+|Customer Group
+|I_CUST_GROUP	||O	|| || || ||	||	||
+|-
+|End Date
+|I_END_DATE_TIME	||M	||TODAY	|| || ||	||	||
+|-
+|Grouping
+|I_GROUP_BY	||M	||STRING	||	CUST_GROUP|| ||	||	||
 |}
-==Location Export GL==
+==KPI Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,023: / Line 4,556: @@
 !'''Procedure for Scheduling'''
 |-
-|Location Export GL
+|KPI Extract
-|Location_Export
+|CN_KPI_Extract
-|CSV.LOCATION_EXPORT_GL
+|KPI_EXTRACT.KPI_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Country	||O	|| || || || || ||
+|Owning Depot
+|i_owning_depot	||O	|| || ||	Depot||	Location Id||	Name||
+|-
+|Start Schedule
+|i_start_sched
+|M
+|
+|
+|
+|
+|
+|
+|-
+|Group Name
+|i_group_name
+|O
+|STRING
+|ALL
+|
+|
+|
+|
+|-
+|End Schedule
+|i_end_sched
+|M
+|
+|
+|
+|
+|
+|
 |}
+==Kraft KPI==
-==Location Export GPR==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,040: / Line 4,604: @@
 !'''Procedure for Scheduling'''
 |-
-|Location Export GL
+|Kraft KPI
-|Location_Export
+|KRAFT_KPI
-|CSV.LOCATION_EXPORT_GPR
+|CSV.Trips_with_Orders
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Country	||O	|| || || || || ||
+|From Date
+|I_START_DATETIME	||M	||TODAY	||	||	||	||	||
+|-
+|To Date
+|I_END_DATETIME	||M	||TODAY	||	||	||	||	||
+|-
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||	||	||	||
 |}
-==Location Pre-Warning==
+==LFS Packages==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,057: / Line 4,629: @@
 !'''Procedure for Scheduling'''
 |-
-|Location  Pre-Warning
+|LFS Packages
-|Loc_Del_Pre_Warn
+|LFS_Packages
-|CSV.Loc_Del_Pre_Warning
+|DP_CSV_LFS.LFS_PACKAGES
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Load Type	||M	||STRING	||ALL	||	||	||	||
+|External Ref
+|i_ext_ref 	||O	|| ||	||	||	||	||
 |-
-|Trip Status	||M	||STRING	||ALL	||	||	||	||
+|Customer
+|i_customer 	||O	||	||	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Schedule
+|i_sched 	||M	|| ||	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Order Status
+|i_ord_status	||O	||	||	||	||	||	||
+|}
+==Lane Extract==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Lane Extract
+|Lane_Extract
+|CSV.LANE_EXPORT
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
+|From Loc
+|p_from_loc	||O	||	||	||	From Loc||	Location Id||	Name||
 |-
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
+|To Loc
+|p_to_loc	||O	||	||	||	To Loc||	Location  Id||	Name||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Customer
+|p_customer	||O	||	||	|| || || ||
 |-
-|Load Type	||M	||STRING	||ALL	||	||	||	||
+|Cost Centre
-|-
+|p_cost_centre	||O	||	||	|| || || ||
-|Trip Status	||M	||STRING	||ALL	||	||	||	||
 |}
-==MDD Code 03 Exceptions==
+==Left Offs==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,092: / Line 4,685: @@
 !'''Procedure for Scheduling'''
 |-
-|MDD Code 03  Exceptions
+|Left Offs
-|MDD Code 03 Exceptions
+|LEFT_OFFS_EXTRACT
-|CSV.MDD_Code_03_Exceptions
+|DP_CSV_GEN.LEFT_OFFS_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Trip ID (optional)
+|P_TRIP_ID	||O	||	||	|| || || ||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Store (optional)
+|P_STORE	||O	|| || ||	Store||	Location  ID||	Name||
+|-
+|Days Back
+|P_DAYS_BACK	||M	||	STRING||	30|| ||	||	||
 |}
-==MTS Finance Export==
+==Loading Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,111: / Line 4,710: @@
 !'''Procedure for Scheduling'''
 |-
-|MTS Finance Export
+|Loading Extract
-|FINANCE_EXPORT
+|LOADING_EXTRACT
-|CSV.finance_export_v2
+|DP_CSV_GEN.EXT_LOADING
 |}
 Parameters:
-==MTS Finance Export V2==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
-!'''Procedure for Scheduling'''
 |-
-|MTS Finance Export
+|Schedule
-|FINANCE_EXPORT_V2
+|P_SCHED_DATE	||M	||	||	||	||	||	||
-|CSV.finance_export_v2
 |}
-Parameters:
-==Manual Loaded Items==
+==Loading Schedule CSV==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,133: / Line 4,729: @@
 !'''Procedure for Scheduling'''
 |-
-|Manual Loaded Items
+|Loading Schedule  CSV
-|MANUAL_LOADED_ITEMS_EXTRACT
+|Loading_Schedule
-|DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT
+|CSV.LOADING_SCHEDULE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||O	||	||	||	||	||	||
+|To Date
+|i_End_Time	||M	||	TODAY|| || || || ||
+|-
+|From Date
+|i_Start_Time	||M	||TODAY	||	||	||	||	||
 |-
-|To Date	||O	||	||	||	||	||	||
+|Depot
+|i_Depot	||M	|| || ||	Depot||	Location  Id||	Name||
 |}
-==Master and Child Locations==
+==Location Export==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,152: / Line 4,754: @@
 !'''Procedure for Scheduling'''
 |-
-|Master and Child  Locations
+|Location Export
-|Master_and_Child
+|Location_Export
-|DP_CSV5.MASTER_AND_CHILD
+|DP_CSV2.LOCATION_EXPORT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Show UnMapped	||O	||	||	||Show UnMapped	||	||	||
+|Location Group
+|I_CUST_GROUP	||O	||	||	||	||	||	||
 |-
-|Show Mapped	||O	||	||	||Show Mapped	||	||	||
+|Country
+|i_country
+|O
+|
+|
+|
+|
+|
+|
 |}
-== Message Maintenance ==
+==Location Export GL==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,171: / Line 4,783: @@
 !'''Procedure for Scheduling'''
 |-
-|Message Maintenance
+|Location Export GL
-|Message_Maintenance
+|Location_Export
-|CSV.msg_maint
+|CSV.LOCATION_EXPORT_GL
 |}
-Parameters:
+No parameters
-==Missing Lat Long Report==
+==Location Export GPR==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,182: / Line 4,794: @@
 !'''Procedure for Scheduling'''
 |-
-|Missing Lat Long  Report
+|Location Export GL
-|MISSING_LAT_LONGS
+|Location_Export
-|dp_csv3.missing_lat_long_extract
+|CSV.LOCATION_EXPORT_GPR
 |}
-Parameters:
+No parameters.
-{| class="wikitable"
+==Location Pre-Warning==
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
-|-
-|Cost Centre	||M	||	||ALL	||	||	||	||
-|}
-==Missing Steps Report==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,199: / Line 4,805: @@
 !'''Procedure for Scheduling'''
 |-
-|Missing Steps  Report
+|Location  Pre-Warning
-|Missing_Steps_Report
+|Loc_Del_Pre_Warn
-|DP_CSV5.Missing_Steps_Report
+|CSV.Loc_Del_Pre_Warning
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Depot
+|i_depot	||M	|| || ||	Depot||	Location Id||	Name||
+|-
+|From Date
+|i_start_date_time	||M	||TODAY	|| || ||	||	||
+|-
+|Load Type
+|i_load_type	||M	||STRING	||	ALL|| ||	||	||
 |-
-|Missing Step	||O	||STRING	||ALL	||	||	||	||
+|To Date
+|i_end_date_time	||M	||TODAY	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Trip Status
+|i_trip_status	||M	||STRING	||	ALL|| ||	||	||
 |}
-==Month End Accruals==
+==MDD Code 03 Exceptions==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,220: / Line 4,836: @@
 !'''Procedure for Scheduling'''
 |-
-|Month End Accruals
+|MDD Code 03  Exceptions
-|month_end_accruals
+|MDD Code 03 Exceptions
-|dp_csv_nr.month_end_accruals
+|CSV.MDD_Code_03_Exceptions
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|P_START_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|To Date
-|-
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
-|Cost Centre	||O	||	||	||	||	||	||
-|-
-|Customer	||O	||	||	||	||	||	||
-|-
-|Cust Group	||O	||	||	||	||	||	||
 |}
-==NR Additional Report==
+==MTS Finance Export==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,245: / Line 4,858: @@
 !'''Procedure for Scheduling'''
 |-
-|NR Additional  Report
+|MTS Finance Export
-|nr_additional_rep
+|FINANCE_EXPORT
-|dp_csv_nr.nr_additional_report
+|CSV.finance_export_v2
 |}
 Parameters:
-==NR Finance Extract==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name
-!'''Procedure for Scheduling'''
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|NR Finance Extract
+|End Schedule
-|NR_Finance_Extract
+|i_to_sched_name
-|DP_CSV_NR.NR_FINANCE_EXTRACT
+|M
-|}
+|
-Parameters:
+|
-{| class="wikitable"
+|
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|
+|
+|
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Start Schedule
-|-
+|i_from_sched_name
-|Debriefed	||M	||	||	||	||	||	||
+|M
-|-
+|
-|Carrier	||O	||	||	||	||	||	||
+|
+|
+|
+|
+|
 |-
-|To Region	||M	||STRING	||ALL	||	||	||	||
+|Customer
-|-
+|I_CUSTOMER
-|To Date	||M	||TODAY	||	||	||	||	||
+|M
-|-
+|STRING
-|Carrier Group	||O	||	||	||	||	||	||
+|ALL
-|-
+|
-|Strategy	||O	||	||	||	||	||	||
+|
-|-
+|
-|Cost Centre	||O	||	||	||	||	||	||
+|
-|-
-|Customer	||O	||	||	||	||	||	||
-|-
-|From Region	||M	||STRING	||ALL	||	||	||	||
 |}
-==NR Invoice==
+==MTS Finance Export V2==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,291: / Line 4,911: @@
 !'''Procedure for Scheduling'''
 |-
-|NR Invoice
+|MTS Finance Export
-|NR_Invoice
+|FINANCE_EXPORT_V2
-|DP_CSV_NR.NR_INVOICE
+|CSV.finance_export_v2
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|End Schedule
-|-
+|i_to_sched_name
-|From Date	||M	||TODAY	||	||	||	||	||
+|M
-|-
+|
-|Debriefed	||M	||	||	||	||	||	||
+|
-|-
+|
-|Carrier	||O	||	||	||	||	||	||
+|
+|
+|
 |-
-|To Region	||M	||STRING	||ALL	||	||	||	||
+|Start Schedule
+|i_from_sched_name
+|M
+|
+|
+|
+|
+|
+|
 |-
-|From Region	||M	||STRING	||ALL	||	||	||	||
+|Customer
-|-
+|I_CUSTOMER
-|Carrier Group	||O	||	||	||	||	||	||
+|M
-|-
+|STRING
-|Strategy	||O	||	||	||	||	||	||
+|ALL
-|-
+|
-|Customer	||O	||	||	||	||	||	||
+|
-|-
+|
-|Cost Centre	||O	||	||	||	||	||	||
+|
 |}
-==OPS KPI Extract==
+==Manual Loaded Items==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,326: / Line 4,964: @@
 !'''Procedure for Scheduling'''
 |-
-|OPS KPI Extract
+|Manual Loaded Items
-|OPS_KPI_Extract
+|MANUAL_LOADED_ITEMS_EXTRACT
-|KPI.KPI_OPS_EXTRACT
+|DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT
 |}
 Parameters:
-==OPS KPI Extract2==
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|From Date
+|P_START_DATE	||O	||	||	||	||	||	||
+|-
+|To Date
+|P_END_DATE	||O	||	||	||	||	||	||
+|}
+==Master and Child Locations==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,337: / Line 4,986: @@
 !'''Procedure for Scheduling'''
 |-
-|OPS KPI Extract2
+|Master and Child  Locations
-|OPS_KPI_Extract
+|Master_and_Child
-|KPI.KPI_OPUS_EXTRACT
+|DP_CSV5.MASTER_AND_CHILD
 |}
 Parameters:
-==OTM Export==
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Show Mapped
+|P_SHOW_MAPPED	||O	||	||	||Show Mapped	|| ||	||
+|-
+|Show UnMapped
+|P_SHOW_UNMAPPED	||O	||	||	||Show  UnMapped	|| ||	||
+|}
+== Message Maintenance ==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Message Maintenance
+|Message_Maintenance
+|CSV.msg_maint
+|}
+No parameters
+==Missing Lat Long Report==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,348: / Line 5,019: @@
 !'''Procedure for Scheduling'''
 |-
-|OTM Export
+|Missing Lat Long  Report
-|OTM_Export
+|MISSING_LAT_LONGS
-|DP_CSV_DHL.OTM_EXPORT
+|dp_csv3.missing_lat_long_extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Date To	||M	||TODAY	||	||	||	||	||
+|Cost Centre
-|-
+|i_cost_centre	||M	||	||ALL	||	||	||	||
-|Date From	||M	||TODAY	||	||	||	||	||
-|-
-|Carrier	||O	||	||	||	||	||	||
 |}
-==On Time Arrivals==
+==Missing Steps Report==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,369: / Line 5,038: @@
 !'''Procedure for Scheduling'''
 |-
-|On Time Arrivals
+|Missing Steps  Report
-|ON_TIME_ARRIVALS
+|Missing_Steps_Report
-|DP_CSV6.ON_TIME_ARRIVALS
+|DP_CSV5.Missing_Steps_Report
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Outbase	||O	||	||	||	||	||	||
+|Missing Step
+|i_step	||O	||STRING	||	ALL|| ||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|To Date
+|i_date_to	||M	||TODAY	|| || ||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|From Date
-|-
+|i_date_from	||M	||TODAY	||	||	||	||	||
-|Dealer	||O	||	||	||	||	||	||
-|-
-|Customer	||O	||	||	||	||	||	||
-|-
-|Schedule To	||M	||	||	||	||	||	||
-|-
-|Schedule From	||M	||	||	||	||	||	||
 |}
-==On Time Drops==
+==Month End Accruals==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,398: / Line 5,063: @@
 !'''Procedure for Scheduling'''
 |-
-|On Time Drops
+|Month End Accruals
-|ON_TIME_DROPS
+|month_end_accruals
-|DP_CSV6.ON_TIME_DROPS
+|dp_csv_nr.month_end_accruals
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Outbase	||O	||	||	||	||	||	||
+|From Date
+|i_End_Date_Time	||M	||TODAY	||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|From Date
+|i_Start_Date_Time	||M	||TODAY	||	||	||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Cust Group
+|i_cust_group	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
+|}
+==NR Additional Report==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|NR Additional  Report
-|-
+|nr_additional_rep
-|Dealer	||O	||	||	||	||	||	||
+|dp_csv_nr.nr_additional_report
 |}
+No parameters
-==On Time Items==
+==NR Finance Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,427: / Line 5,105: @@
 !'''Procedure for Scheduling'''
 |-
-|On Time Items
+|NR Finance Extract
-|ON_TIME_ITEMS
+|NR_Finance_Extract
-|DP_CSV6.ON_TIME_ITEMS
+|DP_CSV_NR.NR_FINANCE_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Dealer	||O	||	||	||	||	||	||
+|Debriefed
+|i_debriefed	||M	|| || ||	||	||	||
 |-
-|Outbase	||O	||	||	||	||	||	||
+|From Date
+|i_from_date	||M	||	TODAY|| ||	||	||	||
+|-
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|To Region
+|i_to_region	||M	||STRING	||ALL	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|From Region
+|i_from_region	||M	||STRING	||	ALL|| ||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Carrier Group
+|i_carrier_group	||O	||	||	||	||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Strategy
+|i_strategy	||O	||	||	||	||	||	||
+|-
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
+|-
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|To Date
+|i_to_date	||M	||TODAY	|| || ||	||	||
 |}
-==On Time Items (Assets)==
+==NR Invoice==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,456: / Line 5,151: @@
 !'''Procedure for Scheduling'''
 |-
-|On Time Items  (Assets)
+|NR Invoice
-|ON_TIME_ITEMS
+|NR_Invoice
-|DP_CSV6.ON_TIME_ITEMS_ASSETS
+|DP_CSV_NR.NR_INVOICE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|From Date
+|i_from_date	||M	||TODAY	||	||	||	||	||
+|-
+|Carrier
+|i_carrier	||O	|| || ||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|To Region
+|i_to_region	||M	||	STRING||	ALL|| ||	||	||
 |-
-|Dealer	||O	||	||	||	||	||	||
+|From Region
+|i_from_region	||M	||	STRING||	ALL|| ||	||	||
 |-
-|Outbase	||O	||	||	||	||	||	||
+|Debriefed
+|i_debriefed	||M	|| || || ||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|Strategy
+|i_strategy	||O	|| || || ||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
+|-
+|Customer
+|i_customer	||O	||	||	||	||	||	||
+|-
+|To Date
+|i_to_date	||M	||	TODAY|| ||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Carrier Group
+|i_carrier_group	||O	||	||	||	||	||	||
 |}
-==On Time Returns==
+==OPS KPI Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,485: / Line 5,197: @@
 !'''Procedure for Scheduling'''
 |-
-|On Time Returns
+|OPS KPI Extract
-|ON_TIME_RETURNS
+|OPS_KPI_Extract
-|DP_CSV6.ON_TIME_RETURNS
+|KPI.KPI_OPS_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Cost Centre
+|i_cost_centre
+|O
+|
+|ALL
+|
+|
+|
+|
 |-
-|Route Code	||O	||	||	||	||	||	||
+|To Date
+|i_date_to
+|M
+|TODAY
+|
+|
+|
+|
+|
 |-
-|Outbase	||O	||	||	||	||	||	||
+|From Date
+|i_date_from
+|M
+|TODAY
+|
+|
+|
+|
+|
 |-
-|Dealer	||O	||	||	||	||	||	||
+|Client
-|-
+|i_client
-|Customer	||O	||	||	||	||	||	||
+|O
-|-
+|
-|Schedule From	||M	||	||	||	||	||	||
+|ALL
-|-
+|
-|Schedule To	||M	||	||	||	||	||	||
+|
-|}
+|
+|
+|-
+|Carrier
+|i_carrier
+|O
+|
+|ALL
+|
+|
+|
+|
+|-
+|Depot
+|i_depot
+|O
+|
+|ALL
+|
+|Location  Id
+|Name
+|
+|-
+|Date Range Type
+|i_date_type
+|M
+|String
+|
+|
+|
+|
+|
+|}
-==Operational Information==
+==OPS KPI Extract2==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,514: / Line 5,290: @@
 !'''Procedure for Scheduling'''
 |-
-|Operational  Information
+|OPS KPI Extract2
-|Operational_Information
+|OPS_KPI_Extract
-|DP_CSV2.OPERATIONAL_INFO
+|KPI.KPI_OPUS_EXTRACT
 |}
 Parameters:
-==Order Charges Extract==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name
-!'''Procedure for Scheduling'''
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Order Charges  Extract
+|Cost Centre
-|ORD_CHARGE
+|i_cost_centre
-|DP_CSV5.ORD_CHARGE_REPORT
+|O
-|}
+|
-Parameters:
+|ALL
-{| class="wikitable"
+|
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|
+|
+|
 |-
-|Date 	||M	||TODAY	||	||	||	||	||
+|To Date
-|}
+|i_date_to
+|M
-==Order Extract==
+|TODAY
-{| class="wikitable"
+|
-!'''Report Name'''
+|
-!'''Filename'''
+|
-!'''Procedure for Scheduling'''
+|
+|
 |-
-|Order Extract
+|From Date
-|ORDER_EXTRACT.csv
+|i_date_from
-|DP_CSV2.HCR_ORDER_EXTRACT
+|M
-|}
+|TODAY
-Parameters:
+|
-{| class="wikitable"
+|
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|
+|
+|
 |-
-|End Sched	||M	||	||	||	||	||	||
+|Client
+|i_client
+|O
+|
+|ALL
+|
+|
+|
+|
 |-
-|Start Sched	||M	||	||	||	||	||	||
+|Carrier
-|}
+|i_carrier
+|O
-==Order Interface Results==
+|
-{| class="wikitable"
+|ALL
-!'''Report Name'''
+|
-!'''Filename'''
+|
-!'''Procedure for Scheduling'''
+|
+|
 |-
-|Order Interface  Results
+|Depot
-|ORDER_INTERFACE_RESULTS
+|i_depot
-|CSV.ORDER_INTERFACE_RESULTS
+|O
-|}
+|
-Parameters:
+|ALL
-{| class="wikitable"
+|
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|Location  Id
+|Name
+|
 |-
-|Customer	||O	||	||	||	||	||	||
+|Date Range Type
-|-
+|i_date_type
-|To Date	||O	||TODAY	||	||	||	||	||
+|M
-|-
+|String
-|From Date	||O	||TODAY	||	||	||	||	||
+|
-|-
+|
-|Depot	||O	||	||	||	||	||	||
+|
-|-
+|
-|Message Type	||O	||	||	||	||	||	||
+|
 |}
-==Order Items POD Debriefed==
+==OTM Export==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,586: / Line 5,383: @@
 !'''Procedure for Scheduling'''
 |-
-|Order Items POD  Debriefed
+|OTM Export
-|Order_Items_POD_Debriefed
+|OTM_Export
-|DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED
+|DP_CSV_DHL.OTM_EXPORT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||	||	||	||	||	||
+|Date To
+|i_date_to	||M	||TODAY	||	||	||	||	||
 |-
-|End Schedule	||O	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	|| || ||	||	||	||
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Date From
+|i_date_from	||M	||	TODAY|| ||	||	||	||
 |}
-==Order Savings==
+==On Time Arrivals==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,607: / Line 5,408: @@
 !'''Procedure for Scheduling'''
 |-
-|Order Savings
+|On Time Arrivals
-|ORDER_SAVINGS
+|ON_TIME_ARRIVALS
-|CSV.Order_savings
+|DP_CSV6.ON_TIME_ARRIVALS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	|| ||	||	||	||	||
+|-
+|Schedule To
+|i_sched_to	||M	|| ||	||	||	||	||
+|-
+|Customer
+|i_customer	||O	||	||	||	||	||	||
+|-
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
+|-
+|Route Code
+|i_route	||O	||	||	||	||	||	||
 |-
-|End Schedule	||O	||	||	||	||	||	||
+|Media Type
+|i_media	||O	|| ||	||	||	||	||
 |-
-|Show Neg Savings	||M	||	||	||	||	||	||
+|Dealer
+|i_dealer	||O	|| ||	||	||	||	||
 |}
-==Order Tracking==
+==On Time Drops==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,628: / Line 5,445: @@
 !'''Procedure for Scheduling'''
 |-
-|Order Tracking
+|On Time Drops
-|Order_Tracking
+|ON_TIME_DROPS
-|DP_CSV5.ORDER_TRACKING
+|DP_CSV6.ON_TIME_DROPS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||STRING	||OPENFIELD	||	||	||	||
+|Route Code
+|i_route	||O	||	||	||	||	||	||
 |-
-|Month	||M	||	||	||	||	||	||
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Week Offset	||O	||	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
 |-
-|Year	||M	||	||	||	||	||	||
+|Customer
+|i_customer	||O	|| ||	||	||	||	||
 |-
-|Cost Centre	||O	||STRING	||OPENFIELDCC	||	||	||	||
+|Media Type
+|i_media	||O	||	||	||	||	||	||
+|-
+|Schedule From
+|i_sched_from	||M	||	||	||	||	||	||
+|-
+|Schedule To
+|i_sched_to	||M	|| ||	||	||	||	||
 |}
-==Orders for Relabelling==
+==On Time Items==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,653: / Line 5,482: @@
 !'''Procedure for Scheduling'''
 |-
-|Orders for  Relabelling
+|On Time Items
-|ORDERS_FOR_RELABELLING
+|ON_TIME_ITEMS
-|DP_CSV_DHL.ORDERS_FOR_RELABELLING
+|DP_CSV6.ON_TIME_ITEMS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Schedule From
-|}
+|i_sched_from	||M	|| ||	||	||	||	||
+|-
-== Orders to LogiX ==
+|Schedule To
-{| class="wikitable"
+|i_sched_to	||M	|| ||	||	||	||	||
-!'''Report Name'''
+|-
-!'''Filename'''
+|Customer
-!'''Procedure for Scheduling'''
+|i_customer	||O	||	||	||	||	||	||
+|-
+|Media Type
+|i_media	||O	|| ||	||	||	||	||
 |-
-|Orders to LogiX
+|Route Code
-|LogiX_Orders
+|i_route	||O	|| ||	||	||	||	||
-|DP_LOGIX.ORDER_EXPORT
-|}
-Parameters:
-==Orders to Paragon==
-{| class="wikitable"
-!'''Report Name'''
-!'''Filename'''
-!'''Procedure for Scheduling'''
 |-
-|Orders to Paragon
+|Dealer
-|Paragon_Orders
+|i_dealer	||O	||	||	||	||	||	||
-|CSV.Orders_to_Paragon
-|}
-Parameters:
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |}
-==Outbound Shortage==
+==On Time Items (Assets)==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,697: / Line 5,519: @@
 !'''Procedure for Scheduling'''
 |-
-|Outbound Shortage
+|On Time Items  (Assets)
-|OUTBOUND_SHORTAGE
+|ON_TIME_ITEMS
-|DP_CSV6.OUTBOUND_SHORTAGE
+|DP_CSV6.ON_TIME_ITEMS_ASSETS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Schedule To
+|i_sched_to	||M	||	||	||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	|| ||	||	||	||	||
 |-
-|Dealer	||O	||STRING	||	||	||	||	||
+|Route Code
+|i_route	||O	||	||	||	||	||	||
 |-
-|Media Type	||O	||STRING	||	||	||	||	||
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Route	||O	||STRING	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
 |-
-|Depot	||O	||STRING	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||STRING	||	||	||	||	||
+|Media Type
+|i_media	||O	|| ||	||	||	||	||
 |}
-==PAYMENT_DTLS==
+==On Time Returns==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,726: / Line 5,556: @@
 !'''Procedure for Scheduling'''
 |-
-|PAYMENT_DTLS
+|On Time Returns
-|PAYMENT_DTLS
+|ON_TIME_RETURNS
-|OF_INT.WRITE_PAYMENT_DETAILS
+|DP_CSV6.ON_TIME_RETURNS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|End Date	||M	||TODAY	||	||	||	||	||
+|Route Code
+|i_route	||O	||	||	||	||	||	||
+|-
+|Media Type
+|i_media	||O	||	||	||	||	||	||
+|-
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
 |-
-|Customer	||M	||	||	||	||	||	||
+|Customer
-|}
+|i_customer	||O	||	||	||	||	||	||
-==POC to SAP Extract==
-{| class="wikitable"
-!'''Report Name'''
-!'''Filename'''
-!'''Procedure for Scheduling'''
 |-
-|POC to SAP Extract
+|Schedule To
-|POC to SAP Extract
+|i_sched_to	||M	||	||	||	||	||	||
-|CSV.POC_to_Sap_Extract
-|}
-Parameters:
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
+|Schedule From
+|i_sched_from	||M	||	||	||	||	||	||
 |}
-==POC to SAP Extract(A)==
+==Operational Information==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,763: / Line 5,593: @@
 !'''Procedure for Scheduling'''
 |-
-|POC to SAP  Extract(A)
+|Operational  Information
-|POC to SAP Extract(A)
+|Operational_Information
-|CSV.POC_to_Sap_Extract
+|DP_CSV2.OPERATIONAL_INFO
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Resend All?	||M	||STRING	||No	||	||	||	||
+|To Date
+|P_END_DATE	||M	||	TODAY|| || || || ||
+|-
+|POD
+|P_POD
+|O
+|
+|
+|
+|
+|
+|
+|-
+|Carrier
+|I_FROM_LOC
+|O
+|
+|
+|Carrier
+|Carrier  Name
+|Carrier  ID
+|
+|-
+|Location From
+|P_FROM_LOC
+|O
+|STRING
+|
+|Location  From
+|Location  ID
+|Name
+|
+|-
+|From Date
+|P_START_DATE
+|M
+|TODAY
+|
+|
+|
+|
+|
 |}
+==Order Charges Extract==
-==POC-POD  Reprocessing Team Export==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,780: / Line 5,651: @@
 !'''Procedure for Scheduling'''
 |-
-|POC-POD  Reprocessing Team Export
+|Order Charges  Extract
-|POC_POD_REPOROCESSING
+|ORD_CHARGE
-|DP_CSV.POC_POD_REPROCESSING
+|DP_CSV5.ORD_CHARGE_REPORT
 |}
 Parameters:
-==POD Delivery Extract==
 {| class="wikitable"
-!'''Report Name'''
+!Title
-!'''Filename'''
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
-!'''Procedure for Scheduling'''
 |-
-|POD Delivery  Extract
+|Date
-|POD_Delivery_Extract
+|P_DELIVERY_DATE 	||M	||TODAY	||	||	||	||	||
-|DP_CSV2.POD_DELIVERY_EXTRACT
+|}
+==Order Extract==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Order Extract
+|ORDER_EXTRACT.csv
+|DP_CSV2.HCR_ORDER_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Schedule	||M	||	||	||	||	||	||
+|Start Sched
-|-
+|P_START_SCHED	||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	||
+|End Sched
+|P_END_SCHED	||M	||	||	||	||	||	||
 |}
-==POD Generation Extract==
+==Order Interface Results==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,824: / Line 5,692: @@
 !'''Procedure for Scheduling'''
 |-
-|POD Generation  Extract
+|Order Interface  Results
-|POD_GEN
+|ORDER_INTERFACE_RESULTS
-|DP_CSV5.POD_REPORT
+|CSV.ORDER_INTERFACE_RESULTS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|POD Flow	||M	||	||	||	||	||	||
+|To Date
+|i_to_date	||O	||	TODAY|| ||	||	||	||
+|-
+|Customer
+|I_CUSTOMER	||O	|| || ||	||	||	||
 |-
-|Date To	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_from_date	||O	||TODAY	||	||	||	||	||
 |-
-|Date From	||M	||TODAY	||	||	||	||	||
+|Depot
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Schedule	||O	||	||	||	||	||	||
+|
+|Message Type	||O	||	||	||	||	||	||
 |}
-==POD to SAP Extract==
+==Order Items POD Debriefed==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,847: / Line 5,723: @@
 !'''Procedure for Scheduling'''
 |-
-|POD to SAP Extract
+|Order Items POD  Debriefed
-|POD to SAP Extract
+|Order_Items_POD_Debriefed
-|CSV.POD_to_Sap_Extract
+|DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
+|Start Schedule
+|P_START_SCHED	||M	|| ||	||	||	||	||
+|-
+|End Schedule
+|P_END_SCHED	||O	||	||	||	||	||	||
+|-
+|Customer
+|P_CUSTOMER	||O	|| ||	||	||	||	||
 |}
-==POD to SAP Extract(A)==
+==Order Savings==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,863: / Line 5,748: @@
 !'''Procedure for Scheduling'''
 |-
-|POD to SAP  Extract(A)
+|Order Savings
-|POD to SAP Extract(A)
+|ORDER_SAVINGS
-|CSV.POD_to_Sap_Extract
+|CSV.Order_savings
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Resend All?	||M	||STRING	||No	||	||	||	||
+|Start Schedule
+|P_START_SCHED	||M	||	||	||	||	||	||
+|-
+|End Schedule
+|P_END_SCHED	||O	||	||	||	||	||	||
+|-
+|Show Neg Savings
+|p_show_only_negative	||M	||	||	||	||	||	||
 |}
-==PORSCHE19 Invoice Extract==
+==Order Tracking==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,880: / Line 5,773: @@
 !'''Procedure for Scheduling'''
 |-
-|PORSCHE19 Invoice  Extract
+|Order Tracking
-|Invoice_Extract
+|Order_Tracking
-|DP_CSV2.Invoice_Extract
+|DP_CSV5.ORDER_TRACKING
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||M	||STRING	||PORSCHE19	||	||	||	||
+|Month
+|P_MONTH	||M	|| || || ||	||	||
 |-
-|Sub Debit Account	||O	||STRING	||ALL	||	||	||	||
+|Week Offset
+|P_WEEK_OFFSET	||O	|| ||	||	||	||	||
 |-
-|Trip ID	||O	||STRING	||ALL	||	||	||	||
+|Year
+|P_YEAR	||M	|| ||	||	||	||	||
 |-
-|Sub Credit Account	||O	||STRING	||ALL	||	||	||	||
+|Customer
+|P_CUSTOMER	||O	||	STRING||	OPENFIELD|| ||	||	||
 |-
-|Invoice ID	||O	||STRING	||0	||	||	||	||
+|Cost Centre
-|-
+|P_COST_CENTRE	||O	||STRING	||EXEL	|| ||	||	||
-|Export ID	||O	||STRING	||0	||	||	||	||
 |}
-== PROVIDER_REVENUE ==
+==Orders for Relabelling==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,907: / Line 5,804: @@
 !'''Procedure for Scheduling'''
 |-
-|PROVIDER_REVENUE
+|Orders for  Relabelling
-|PROVIDER_REVENUE
+|ORDERS_FOR_RELABELLING
-|dp_csv3.provider_revenue
+|DP_CSV_DHL.ORDERS_FOR_RELABELLING
 |}
 Parameters:
+{| class="wikitable"
-==	||	||Owning Depot	||O	||	||	||	||	||	||
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Schedule	||M	||	||	||	||	||	||
+|Schedule
-|-
+|p_schedule	||M	||	||	||	||	||	||
-|From Schedule	||M	||	||	||	||	||	||
 |}
-==Parts and Empites==
+== Orders to LogiX ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,926: / Line 5,823: @@
 !'''Procedure for Scheduling'''
 |-
-|Parts and Empites
+|Orders to LogiX
-|Parts_and_Empties
+|LogiX_Orders
-|DP_CSV5.PARTS_AND_EMPTIES
+|DP_LOGIX.ORDER_EXPORT
 |}
-Parameters:
+No parameters
+==Orders to Paragon==
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
 |-
-|Export Type	||M	||	||	||	||	||	||
+|Orders to Paragon
-|-
+|Paragon_Orders
-|Schedule From	||M	||	||	||	||	||	||
+|CSV.Orders_to_Paragon
-|-
-|Schedule To	||M	||	||	||	||	||	||
-|-
-|Location From	||O	||	||	||	||	||	||
-|-
-|Customer	||M	||	||	||	||	||	||
 |}
+No parameters
-==PostCode Matrix==
+==Outbound Shortage==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,951: / Line 5,845: @@
 !'''Procedure for Scheduling'''
 |-
-|PostCode Matrix
+|Outbound Shortage
-|POSTCODE_MATRIX
+|OUTBOUND_SHORTAGE
-|dp_csv3.postcode_matrix
+|DP_CSV6.OUTBOUND_SHORTAGE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|}
+|Dealer
+|i_dealer	||O	||	STRING|| ||	||	||	||
-==Pre Invoice Check==
-{| class="wikitable"
-!'''Report Name'''
-!'''Filename'''
-!'''Procedure for Scheduling'''
 |-
-|Pre Invoice Check
+|Schedule From
-|Pre_Invoice_Check
+|i_sched_from	||M	||	||	||	||	||	||
-|CSV.PRE_INVOICE_CHECK
+|-
+|Customer
+|i_customer	||O	||STRING	||	||	||	||	||
+|-
+|Schedule To
+|i_sched_to	||M	|| || ||	||	||	||
+|-
+|Depot
+|i_depot	||O	||STRING	||	||	||	||	||
+|-
+|Route
+|i_route	||O	||STRING	||	||	||	||	||
+|-
+|Media Type
+|i_media_type	||O	||STRING	||	||	||	||	||
+|}
+==PAYMENT_DTLS==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|PAYMENT_DTLS
+|PAYMENT_DTLS
+|OF_INT.WRITE_PAYMENT_DETAILS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Cut-off Date	||M	||TODAY	||	||	||	||	||
+|Customer
+|i_cust	||M	|| || ||	||	||	||
+|-
+|From Date
+|i_from_date	||M	||TODAY	||	||	||	||	||
+|-
+|End Date
+|i_to_date	||M	||	TODAY|| ||	||	||	||
 |}
-==Process Items Audit==
+==POC to SAP Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,984: / Line 5,907: @@
 !'''Procedure for Scheduling'''
 |-
-|Process Items Audit
+|POC to SAP Extract
-|PROCESS_ITEMS_AUDIT
+|POC to SAP Extract
-|DP_CSV6.PROCESS_ITEMS_AUDIT
+|CSV.POC_to_Sap_Extract
 |}
-Parameters:
+No parameters
-==Process Items Interface Audit==
+==POC to SAP Extract(A)==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 4,995: / Line 5,918: @@
 !'''Procedure for Scheduling'''
 |-
-|Process Items  Interface Audit
+|POC to SAP  Extract(A)
-|PROCESS_ITEMS_INTERFACE_AUDIT
+|POC to SAP Extract(A)
-|DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT
+|CSV.POC_to_Sap_Extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Incl. Reprocessed	||M	||STRING	||N	||	||	||	||
+|Resend All?
-|-
+|p_resend_flag	||M	||STRING	||No	||	||	||	||
-|Start Date	||M	||TODAY	||	||	||	||	||
-|-
-|End Date	||M	||TODAY	||	||	||	||	||
-|-
-|Record Status	||M	||STRING	||ALL	||	||	||	||
 |}
-==Provisional Booking Exceptions==
+==POC-POD  Reprocessing Team Export==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,018: / Line 5,937: @@
 !'''Procedure for Scheduling'''
 |-
-|Provisional Booking  Exceptions
+|POC-POD  Reprocessing Team Export
-|Provisional Booking Exceptions
+|POC_POD_REPOROCESSING
-|CSV.Provisional_Booking_Exceptions
+|DP_CSV.POC_POD_REPROCESSING
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|To Date
+|P_END_DATETIME
+|M
+|YESTERDAY
+|YESTERDAY
+|
+|
+|
+|
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Date From
+|P_START_DATETIME
+|M
+|TODAY
+|YESTERDAY:20:00
+|
+|
+|
+|
 |}
-==Purchase Order Extract==
+==POD Delivery Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,037: / Line 5,980: @@
 !'''Procedure for Scheduling'''
 |-
-|Purchase Order  Extract
+|POD Delivery  Extract
-|po_extract
+|POD_Delivery_Extract
-|DP_CSV2.PURCHASE_ORDER_EXTRACT
+|DP_CSV2.POD_DELIVERY_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Status	||O	||STRING	||All	||	||	||	||
+|Customer Group
+|p_group_name	||O	||	STRING||	ALL|| ||	||	||
 |-
-|To Date	||O	||TODAY	||TODAY	||	||	||	||
+|Scanning Depot
+|p_scan_depot	||O	||	STRING||	ALL||	Depot||	Location  Id||	Name||
 |-
-|From Date	||O	||TODAY	||TODAY	||	||	||	||
+|> Days Outstanding
-|}
+|p_outstanding	||O	||STRING	||0	|| ||	||	||
+|-
-==Reason Listings==
+|POD Status
-{| class="wikitable"
+|p_pod	||O	||STRING	||ALL	||	||	||	||
-!'''Report Name'''
+|-
-!'''Filename'''
+|Carrier
-!'''Procedure for Scheduling'''
+|p_carrier	||O	||STRING	||ALL	||	||	||	||
 |-
-|Reason Listings
+|To Schedule
-|REASON_LISTING_
+|p_to_date	||M	|| || || ||	||	||
-|dp_csv3.reasons_listing
-|}
-Parameters:
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Date From	||M	||DATETIME	||TODAY:00:01	||	||	||	||
+|From Schedule
+|p_from_date	||M	|| || || ||	||	||
 |-
-|Depot	||M	||	||	||	||	||	||
+|Customer
+|p_customer	||O	||STRING	||ALL	||	||	||	||
 |-
-|Date To	||M	||DATETIME	||TODAY:23:59	||	||	||	||
+|Del Msg Sent
+|p_del_msg_sent	||O	||STRING	||ALL	|| || || ||
 |}
-==Receipt Scanning==
+==POD Generation Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,079: / Line 6,023: @@
 !'''Procedure for Scheduling'''
 |-
-|Receipt Scanning
+|POD Generation  Extract
-|RECEIPT_SCANNING
+|POD_GEN
-|DP_CSV6.RECEIPT_SCANNING
+|DP_CSV5.POD_REPORT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Dealer	||O	||STRING	||	||	||	||	||
+|POD Flow
+|P_FLOW	||M	||	||	||	||	||	||
 |-
-|Route	||O	||STRING	||	||	||	||	||
+|Schedule
-|-
+|P_SCHED	||O	|| || ||	||	||	||
-|Media Type	||O	||STRING	||	||	||	||	||
 |-
-|Customer	||O	||STRING	||	||	||	||	||
+|Date From
+|P_DATE_FROM	||M	||TODAY	||	||	||	||	||
 |-
-|Date To	||M	||TODAY	||	||	||	||	||
+|Date To
-|-
+|P_DATE_TO	||M	||	TODAY|| ||	||	||	||
-|Date From	||M	||TODAY	||	||	||	||	||
-|-
-|Depot	||O	||STRING	||	||	||	||	||
 |}
-==Receiving Extract==
+==POD to SAP Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,108: / Line 6,051: @@
 !'''Procedure for Scheduling'''
 |-
-|Receiving Extract
+|POD to SAP Extract
-|RECEIVING_EXTRACT
+|POD to SAP Extract
-|DP_CSV_GEN.EXT_RECEIVING
+|CSV.POD_to_Sap_Extract
+|}
+No parameters
+==POD to SAP Extract(A)==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|POD to SAP  Extract(A)
+|POD to SAP Extract(A)
+|CSV.POD_to_Sap_Extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Resend All?
+|p_resend_flag	||M	||STRING	||No	|| || || ||
 |}
-==Revenue Check (Account)==
+==PORSCHE19 Invoice Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,125: / Line 6,081: @@
 !'''Procedure for Scheduling'''
 |-
-|Revenue Check  (Account)
+|PORSCHE19 Invoice  Extract
-|revenue_report
+|Invoice_Extract
-|dp_csv_nr.revenue_report
+|DP_CSV2.Invoice_Extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Sub Credit Account
+|p_sub_credit_acc	||O	||STRING	||ALL	|| ||	||	||
+|-
+|Trip ID
+|p_trip	||O	||STRING	||ALL	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Export ID
+|p_export	||O	||STRING	||0	|| ||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Customer
+|p_customer	||M	||STRING	||PORSCHE19	|| ||	||	||
 |-
-|Cust Group	||O	||	||	||	||	||	||
+|Sub Debit Account
+|p_sub_debit_acc	||O	||STRING	||ALL	|| ||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Invoice ID
+|p_invoice	||O	||STRING	||0	||	||	||	||
 |}
-==SMS Email Summary Report==
+== PROVIDER_REVENUE ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,150: / Line 6,115: @@
 !'''Procedure for Scheduling'''
 |-
-|SMS Email Summary  Report
+|PROVIDER_REVENUE
-|sms_email_summary
+|PROVIDER_REVENUE
-|DP_CSV5.SMS_EMAIL_SUMMARY
+|dp_csv3.provider_revenue
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Owning Depot
+|P_OWNING_DEPOT
+|O
+|
+|
+|
+|
+|
+|
+|-
+|From Schedule
+|P_START_SCHED
+|M
+|
+|
+|
+|
+|
+|
 |-
-|Cost Centre	||M	||STRING	||ALL	||	||	||	||
+|To Schedule
+|P_END_SCHED
+|M
+|
+|
+|
+|
+|
+|
 |}
-==STL Trip and Order Extract==
+==Parts and Empties==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,169: / Line 6,168: @@
 !'''Procedure for Scheduling'''
 |-
-|STL Trip and Order  Extract
+|Parts and Empites
-|STL_Trip_Order_Extract
+|Parts_and_Empties
-|DP_CSV2.STL_TRIP_ORDER_EXTRACT
+|DP_CSV5.PARTS_AND_EMPTIES
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Trip Schedule	||M	||	||	||	||	||	||
+|Schedule From
+|P_SCHED_FROM	||M	||	||	||	||	||	||
 |-
-|End Trip Schedule	||M	||	||	||	||	||	||
+|Schedule To
+|P_SCHED_TO	||M	||	||	||	||	||	||
 |-
-|Order Status	||O	||	||	||	||	||	||
+|Location From
+|P_LOCATION	||O	|| ||	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Export Type
+|P_EXPORT_TYPE	||M	|| ||	||	||	||	||
 |-
-|Location Type	||O	||	||	||	||	||	||
+|Customer
+|P_CUSTOMER	||M	||	||	||	||	||	||
 |}
-==Sales Margin Extract==
+==PostCode Matrix==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,194: / Line 6,199: @@
 !'''Procedure for Scheduling'''
 |-
-|Sales Margin  Extract
+|PostCode Matrix
-|sme
+|POSTCODE_MATRIX
-|CSV.order_costs
+|dp_csv3.postcode_matrix
 |}
-Parameters:
+No parameters
-{| class="wikitable"
+==Pre Invoice Check==
-!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'''
@@ Line 5,219: / Line 6,210: @@
 !'''Procedure for Scheduling'''
 |-
-|Savings Extract
+|Pre Invoice Check
-|Savings
+|Pre_Invoice_Check
-|CSV.SAVINGS_EXTRACT
+|CSV.PRE_INVOICE_CHECK
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Cut-off Date
-|-
+|i_cutoff_date	||M	||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==
+==Process Items Audit==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,252: / Line 6,229: @@
 !'''Procedure for Scheduling'''
 |-
-|Schedule
+|Process Items Audit
-|Schedule
+|PROCESS_ITEMS_AUDIT
-|CSV.SCHEDULE
+|DP_CSV6.PROCESS_ITEMS_AUDIT
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
-|-
+!Name
-|From Date	||M	||TODAY	||	||	||	||	||
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
+|-
+|Record Status
+|i_record_status
+|M
+|STRING
+|ALL
+|
+|
+|
+|
+|-
+|End Date
+|i_end_datetime
+|M
+|TODAY
+|
+|
+|
+|
+|
+|-
+|Start Date
+|i_start_datetime
+|M
+|TODAY
+|
+|
+|
+|
+|
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Incl. Reprocessed
+|i_incl_reprocessed
+|M
+|STRING
+|N
+|
+|
+|
+|
 |}
-==Schedule Details==
+==Process Items Interface Audit==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,271: / Line 6,292: @@
 !'''Procedure for Scheduling'''
 |-
-|Schedule Details
+|Process Items  Interface Audit
-|schedule_details
+|PROCESS_ITEMS_INTERFACE_AUDIT
-|DP_CSV_GEN.SCHEDULE
+|DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Incl. Reprocessed
+|i_incl_reprocessed	||M	||STRING	||N	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Record Status
+|i_record_status	||M	||STRING	||	ALL|| ||	||	||
+|-
+|End Date
+|i_end_datetime	||M	||TODAY	||	||	||	||	||
+|-
+|Start Date
+|i_start_datetime	||M	||TODAY	|| || ||	||	||
 |}
-==Schedule Trips CS==
+==Provisional Booking Exceptions==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,290: / Line 6,320: @@
 !'''Procedure for Scheduling'''
 |-
-|Schedule Trips CS
+|Provisional Booking  Exceptions
-|SCHED_TRIPS_CS
+|Provisional Booking Exceptions
-|CSV.SCHEDULE_TRIPS_CS
+|CSV.Provisional_Booking_Exceptions
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||	||	||	||	||	||
+|From Date
+|P_START_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Schedule
+|To Date
-|M
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
-|
-|
-|
-|
-|
-|
 |}
-==Scheduled and Cancelled Orders==
+==Purchase Order Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,316: / Line 6,342: @@
 !'''Procedure for Scheduling'''
 |-
-|Scheduled and  Cancelled Orders
+|Purchase Order  Extract
-|Schedule_Orders
+|po_extract
-|CSV.SCHEDULE_ORDERS_VS
+|DP_CSV2.PURCHASE_ORDER_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|To Date
+|i_end_date	||O	||TODAY	||TODAY	|| ||	||	||
 |-
-|Last Schedule	||O	||	||	||	||	||	||
+|From Date
-|-
+|i_start_date	||O	||TODAY	||TODAY	||	||	||	||
-|Customer Group	||O	||	||	||	||	||	||
-|-
-|Customer	||O	||	||	||	||	||	||
 |-
-|Carrier Group	||O	||	||	||	||	||	||
+|Status
+|i_status_id	||O	||STRING	||All	|| ||	||	||
 |}
-== Scheduled and Cancelled Orders v2 ==
+==Reason Listings==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,341: / Line 6,367: @@
 !'''Procedure for Scheduling'''
 |-
-|Scheduled and  Cancelled Orders v2
+|Reason Listings
-|fn
+|REASON_LISTING_
-|CSV.SCHEDULE_ORDERS_VS_V2
+|dp_csv3.reasons_listing
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	|| || || || || ||
+|Date To
+|p_end_datetime	||M	||TODAY	||TODAY:00:01	||	||	||	||
 |-
-|Last Schedule	||O	|| || || || || ||
+|Depot
-|-
+|p_depot	||M	||	||	||	||	||	||
-|Customer Group	||O	|| || || || || ||
-|-
-|Customer	||O	|| || || || || ||
 |-
-|Carrier Group	||O	|| || || || || ||
+|Date From
+|p_start_datetime	||M	||TODAY	||TODAY:23:59	||	||	||	||
 |}
-== Short Rail Report ==
+==Receipt Scanning==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,366: / Line 6,392: @@
 !'''Procedure for Scheduling'''
 |-
-|Short Rail Report
+|Receipt Scanning
-|short_rail_rep
+|RECEIPT_SCANNING
-|dp_csv_nr.short_rail_report
+|DP_CSV6.RECEIPT_SCANNING
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Depot
+|i_depot	||O	||STRING	||	||	||	||	||
+|-
+|Dealer
+|i_dealer	||O	||STRING	||	||	||	||	||
+|-
+|Media Type
+|i_media_type	||O	||STRING	||	||	||	||	||
+|-
+|Route
+|i_route	||O	||STRING	||	||	||	||	||
 |-
-|Product Type	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||STRING	|| ||	||	||	||
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Date To
+|i_date_to	||M	||TODAY	||	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Date From
+|i_date_from	||M	||TODAY	|| ||	||	||	||
 |}
-==Slot Extract==
+==Receiving Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,389: / Line 6,429: @@
 !'''Procedure for Scheduling'''
 |-
-|Slot Extract
+|Receiving Extract
-|Slot_Extract
+|RECEIVING_EXTRACT
-|DP_CSV3.Slot_Extract
+|DP_CSV_GEN.EXT_RECEIVING
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Day	||O	||String	||ALL	||	||	||	||
+|Schedule
-|-
+|P_SCHED_DATE	||M	||	||	||	||	||	||
-|Slot Type	||O	||String	||ALL	||	||	||	||
-|-
-|Location Type	||O	||String	||ALL	||	||	||	||
 |}
-== Store PVA ==
+==Revenue Check (Account)==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,410: / Line 6,448: @@
 !'''Procedure for Scheduling'''
 |-
-|Store PVA
+|Revenue Check  (Account)
-|STORE_PVA
+|revenue_report
-|DP_CSV_DUN.STORE_PVA
+|dp_csv_nr.revenue_report
 |}
 Parameters:
+{| class="wikitable"
-||	||Del
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|From Date
+|i_Start_Date_Time	||M	||TODAY	||	||	||	||	||
+|-
+|From Date
+|i_End_Date_Time	||M	||TODAY	||	||	||	||	||
+|-
+|Customer
+|i_customer	||O	||	||	||	||	||	||
+|-
+|Cust Group
+|i_cust_group	||O	||	||	||	||	||	||
 |-
-|ivery Date	||M	||	||	||	||	||	||
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
 |}
-==Store Pre Warning==
+==SMS Email Summary Report==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,427: / Line 6,479: @@
 !'''Procedure for Scheduling'''
 |-
-|Store Pre Warning
+|SMS Email Summary  Report
-|Store_Pre_Warning
+|sms_email_summary
-|CSV.Store_Pre_Warning
+|DP_CSV5.SMS_EMAIL_SUMMARY
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Show empty Slots	||O	||STRING	||N	||	||	||	||
+|From Date
+|I_DATE_FROM	||M	||TODAY	||	||	||	||	||
 |-
-|Depot	||O	||	||	||Depot	||Location Id	||Name	||
+|Cost Centre
-|-
+|I_COST_CENTRE	||M	||STRING	||ALL	||	||	||	||
-|Store	||O	||	||	||Store	||Location Id	||Name	||
-|-
-|Sched Name	||M	||	||	||	||	||	||
 |}
-==Sub Contractor==
+==STL Trip and Order Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,450: / Line 6,501: @@
 !'''Procedure for Scheduling'''
 |-
-|Sub Contractor
+|STL Trip and Order  Extract
-|SUB_CONTRACTOR
+|STL_Trip_Order_Extract
-|DP_CSV_GEN.SUB_CONTRACTOR
+|DP_CSV2.STL_TRIP_ORDER_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Sched	||M	||	||	||	||	||	||
+|Order Status
+|I_ORDER_STATUS	||O	|| ||	||	||	||	||
 |-
-|Cost Centre	||M	||	||	||	||	||	||
+|End Trip Schedule
+|I_END_SCHED	||M	||	||	||	||	||	||
 |-
-|From Sched	||M	||	||	||	||	||	||
+|Location Type
+|I_LOC_TYPE	||O	||	||	||	||	||	||
+|-
+|Start Trip Schedule
+|I_START_SCHED	||M	|| ||	||	||	||	||
+|-
+|Carrier
+|I_CARRIER_ID	||O	||	||	||	||	||	||
 |}
-==Supplier DUs==
+==Sales Margin Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,471: / Line 6,532: @@
 !'''Procedure for Scheduling'''
 |-
-|Supplier DUs
+|Sales Margin  Extract
-|SUPPLIER_DU_EXTRACT
+|sme
-|DP_CSV_GEN.SUPPLIER_DU_EXTRACT
+|CSV.order_costs
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To	||M	||	||TODAY	||	||	||	||
+|Customer
+|i_CUSTOMER	||O	||	||	||	||	||	||
+|-
+|Customer Group
+|i_CUST_GROUP	||O	|| ||	||	||	||	||
+|-
+|Last Schedule
+|i_sched_to	||O	||	||	||	||	||	||
 |-
-|From	||M	||	||TODAY	||	||	||	||
+|Schedule
+|i_Sched	||M	|| ||	||	||	||	||
+|-
+|Carrier Group
+|i_carr_group	||O	||	||	||	||	||	||
 |}
-==Supplier DUs By Store==
+==Savings Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,490: / Line 6,563: @@
 !'''Procedure for Scheduling'''
 |-
-|Supplier DUs By  Store
+|Savings Extract
-|SUPPLIER_DU_BY_STORE_EXTRACT
+|Savings
-|DP_CSV_GEN.DU_STORE_EXTRACT
+|CSV.SAVINGS_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Store	||O	||	||	||Store	||Location ID	||Name	||
+|Credit Acc
+|I_CREDIT_ACC	||O	|| || ||	||	||	||
+|-
+|Saving (> or <)
+|I_SAVING	||O	||	STRING|| ||	||	||	||
+|-
+|Lane Id
+|I_LANE_ID	||O	||	||	||	||	||	||
+|-
+|Customer Group
+|I_CUST_GROUP	||O	||	||	||	||	||	||
+|-
+|To Cty Code
+|I_TO_CTY	||O	||	||	||	||	||	||
+|-
+|From Cty Code
+|I_FROM_CTY	||O	||	||	||	||	||	||
 |-
-|Order Status	||O	||	||	||	||	||	||
+|From Date
+|I_FROM_DATE	||O	||TODAY	||	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|To Date
+|I_TO_DATE	||O	||	TODAY|| ||	||	||	||
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Debit Acc
+|I_DEBIT_ACC	||O	|| || ||	||	||	||
 |}
-==Supplier Invoice==
+==Schedule==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,513: / Line 6,606: @@
 !'''Procedure for Scheduling'''
 |-
-|Supplier Invoice
+|Schedule
-|Supplier_Invoice
+|Schedule
-|DP_CSV5.SUPPLIER_INVOICE
+|CSV.SCHEDULE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Date	||O	||	||	||	||	||	||
+|To Date
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|End Date	||O	||	||	||	||	||	||
+|From Date
-|-
+|P_START_DATETIME	||M	||TODAY	||	||	||	||	||
-|Invoice ID	||O	||STRING	||	||	||	||	||
-|-
-|End Date	||O	||	||	||	||	||	||
-|-
-|Invoice ID	||O	||STRING	||	||	||	||	||
-|-
-|Start Date	||O	||	||	||	||	||	||
-|-
-|Start Schedule	||M	||	||	||	||	||	||
-|-
-|End Schedule	||M	||	||	||	||	||	||
 |}
-==Supplier Revenue==
+==Schedule Details==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,544: / Line 6,628: @@
 !'''Procedure for Scheduling'''
 |-
-|Supplier Revenue
+|Schedule Details
-|SUPPLIER_REVENUE_EXTRACT
+|schedule_details
-|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT
+|DP_CSV_GEN.SCHEDULE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Revenue Start	||M	||	||TODAY	||	||	||	||
+|Start Schedule
+|P_START_SCHED	||M	||	||	||	||	||	||
 |-
-|Revenue End	||M	||	||TODAY	||	||	||	||
+|End Schedule
+|P_END_SCHED	||M	||	||	||	||	||	||
 |}
-==Supplier Revenue 2==
+==Schedule Trips CS==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,563: / Line 6,650: @@
 !'''Procedure for Scheduling'''
 |-
-|Supplier Revenue 2
+|Schedule Trips CS
-|SUPPLIER_REVENUE_2_EXTRACT
+|SCHED_TRIPS_CS
-|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2
+|CSV.SCHEDULE_TRIPS_CS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Revenue Start	||M	|| ||TODAY	|| || || ||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Revenue End	||M	|| ||TODAY	|| || || ||
+|Schedule
+|i_Sched
+|M
+|
+|
+|
+|
+|
+|
 |}
-==TYRE SUMMARY EXTRACT==
+==Scheduled and Cancelled Orders==
-{{Note}} Can be run from Trip Waterfall screen.
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,583: / Line 6,679: @@
 !'''Procedure for Scheduling'''
 |-
-|TYRE SUMMARY  EXTRACT
+|Scheduled and  Cancelled Orders
-|TYRE_SUMMARY_EXTRACT
+|Schedule_Orders
-|DP_CSV6.TYRE_SUMMARY_EXTRACT
+|CSV.SCHEDULE_ORDERS_VS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Customer
+|i_CUSTOMER	||O	|| ||	||	||	||	||
+|-
+|Carrier Group
+|i_carr_group	||O	||	||	||	||	||	||
+|-
+|Last Schedule
+|i_sched_to	||O	||	||	||	||	||	||
+|-
+|Schedule
+|i_Sched	||M	|| ||	||	||	||	||
+|-
+|Customer Group
+|i_CUST_GROUP	||O	||	||	||	||	||	||
 |}
-==Trip Actuals==
+== Scheduled and Cancelled Orders v2 ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,600: / Line 6,710: @@
 !'''Procedure for Scheduling'''
 |-
-|Trip Actuals
+|Scheduled and  Cancelled Orders v2
-|TRIP_ACTUALS
+|fn
-|CSV.TRIP_ACTUALS
+|CSV.SCHEDULE_ORDERS_VS_V2
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Customer
+|i_CUSTOMER	||O	|| || || || || ||
+|-
+|Carrier Group
+|i_carr_group	||O	|| || || || || ||
+|-
+|Last Schedule
+|i_sched_to	||O	|| || || || || ||
+|-
+|Schedule
+|i_Sched	||M	|| || || || || ||
+|-
+|Customer Group
+|i_CUST_GROUP	||O	|| || || || || ||
 |}
-==Trip Assessment Extract==
+== Short Rail Report ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,617: / Line 6,741: @@
 !'''Procedure for Scheduling'''
 |-
-|Trip Assessment  Extract
+|Short Rail Report
-|chk_trips
+|short_rail_rep
-|dp_csv_lfs.chk_trips
+|dp_csv_nr.short_rail_report
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Cost Centre
-|}
+|i_cost_centre	||O	||	||	||	||	||	||
-==Trip Extract==
-{| class="wikitable"
-!'''Report Name'''
-!'''Filename'''
-!'''Procedure for Scheduling'''
 |-
-|Trip Extract
+|Product Type
-|Trip_Extract
+|i_product_type	||O	||	||	||	||	||	||
-|CSV.Trip_Extract
-|}
-Parameters:
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Carrier	||O	||	||	||	||	||	||
+|End Schedule
+|i_Sched_To	||M	||	||	||	||	||	||
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Start Schedule
-|-
+|i_Sched_From	||M	||	||	||	||	||	||
-|From Date	||O	||TODAY	||	||	||	||	||
 |}
-==Trip and Order Detail Extract==
+==Slot Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,655: / Line 6,769: @@
 !'''Procedure for Scheduling'''
 |-
-|Trip and Order  Detail Extract
+|Slot Extract
-|Trip_Order_Detail_Extract
+|Slot_Extract
-|CSV.Trip_Order_Detail_Extract
+|DP_CSV3.Slot_Extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Location Type
+|I_LOC_TYPE	||O	||String	||ALL	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Day
+|I_DAY	||O	||String	||ALL	||	||	||	||
 |-
-|Location Type	||M	||	||ALL	||	||	||	||
+|Slot Type
-|-
+|I_SLOT_TYPE	||O	||String	||ALL	||	||	||	||
-|Start Schedule	||M	||	||	||	||	||	||
 |}
-==Trunking Report==
+== Store PVA ==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,678: / Line 6,794: @@
 !'''Procedure for Scheduling'''
 |-
-|Trunking Report
+|Store PVA
-|Trunking_Report
+|STORE_PVA
-|CSV.Trunking_Report
+|DP_CSV_DUN.STORE_PVA
 |}
 Parameters:
 {| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!Title
+!Name
+!Mand
+!Def Type
+!Def Val
+!LOV
+!Column 1
+!Column 2
+!Column 3
 |-
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
+|Delivery Date
-|-
+|P_DEL_DATE
-|End Schedule	||M	||	||	||	||	||	||
+|M
-|-
+|
-|Start Schedule	||M	||	||	||	||	||	||
+|
-|-
+|
-|Report Type	||M	||STRING	||Revenue	||	||	||	||
+|
+|
+|
 |}
-==UNISON Interface Results==
+==Store Pre Warning==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,701: / Line 6,827: @@
 !'''Procedure for Scheduling'''
 |-
-|UNISON Interface  Results
+|Store Pre Warning
-|UNSION_interface_results
+|Store_Pre_Warning
-|CSV.UNISON_if_res
+|CSV.Store_Pre_Warning
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Depot	||O	||	||	||Depot	||Location Id	||Name	||
+|Depot
+|i_Depot	||O	|| || ||	Depot||	Location Id||	Name||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Store
+|i_store	||O	||	||	||Store	||Location  Id	||Name	||
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Sched Name
+|i_sched_name	||M	|| ||	|| || || ||
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|Show empty Slots
+|i_show_empty_slots	||O	||	STRING||	N|| ||	||	||
 |}
-==User Activity Extract==
+==Sub Contractor==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,724: / Line 6,855: @@
 !'''Procedure for Scheduling'''
 |-
-|User Activity  Extract
+|Sub Contractor
-|User_Activity_Extract
+|SUB_CONTRACTOR
-|CSV.User_Activity_Extract
+|DP_CSV_GEN.SUB_CONTRACTOR
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Cost Centre
+|P_CC	||M	||	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|To Sched
+|P_END_SCHED	||M	||	||	||	||	||	||
+|-
+|From Sched
+|P_START_SCHED	||M	||	||	||	||	||	||
 |}
-==User Last Logon Extract==
+==Supplier DUs==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,743: / Line 6,880: @@
 !'''Procedure for Scheduling'''
 |-
-|User Last Logon  Extract
+|Supplier DUs
-|USER_LAST_LOGON
+|SUPPLIER_DU_EXTRACT
-|CSV.user_logon_export
+|DP_CSV_GEN.SUPPLIER_DU_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Days since logon	||M	||STRING	||90	||	||	||	||
+|From
+|P_FROM	||M	||	||TODAY	||	||	||	||
+|-
+|To
+|P_TO	||M	||	||TODAY	||	||	||	||
 |}
-==Variance Analysis Store Detail==
+==Supplier DUs By Store==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,760: / Line 6,902: @@
 !'''Procedure for Scheduling'''
 |-
-|Variance Analysis  Store Detail
+|Supplier DUs By  Store
-|VAR_ANLYS_STORE_DTL
+|SUPPLIER_DU_BY_STORE_EXTRACT
-|CSV.VARIANCE_ANALYSIS_STORE_DTL
+|DP_CSV_GEN.DU_STORE_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!
+|-
+|Supplier DUs By  Store
+|Start Schedule	||P_START_SCHED	||	M|| || || || ||
+|
+|-
+|Supplier DUs By Store
+|End  Schedule	||P_END_SCHED	||	M|| ||	||	||	||
+|
+|-
+|Supplier DUs By Store
+|Store	||P_STORE	||	O|| ||	||	Store||	Location  ID||Name
+|
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Supplier DUs By Store
+|Order  Status	||P_STATUS	||	O|| ||	||	||	||
+|
 |}
-==Variance Analysis Summary==
+==Supplier Invoice==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,777: / Line 6,935: @@
 !'''Procedure for Scheduling'''
 |-
-|Variance Analysis  Summary
+|Supplier Invoice
-|VAR_ANLYSIS_SUM
+|Supplier_Invoice
-|CSV.VARIANCE_ANALYSIS_SUMMARY
+|DP_CSV5.SUPPLIER_INVOICE
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|End Date
+|P_END_DATE	||O	||	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Start Date
+|P_START_DATE	||O	||	||	||	||	||	||
+|-
+|Invoice ID
+|P_INVOICE_ID	||O	||STRING	||	||	||	||	||
 |}
-==Variance Analysis Trip Detail==
+==Supplier Revenue==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,796: / Line 6,960: @@
 !'''Procedure for Scheduling'''
 |-
-|Variance Analysis  Trip Detail
+|Supplier Revenue
-|VAR_ANLYS_TRIP_DTL
+|SUPPLIER_REVENUE_EXTRACT
-|CSV.VARIANCE_ANALYSIS_TRIP_DTL
+|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Start Schedule
+|P_START_SCHED	||M	||	|| || ||	||	||
+|-
+|End Schedule
+|P_END_SCHED	||M	||	|| || ||	||	||
 |}
-==Vehicle Utilisation==
+==Supplier Revenue 2==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,813: / Line 6,982: @@
 !'''Procedure for Scheduling'''
 |-
-|Vehicle Utilisation
+|Supplier Revenue 2
-|vehicle_util
+|SUPPLIER_REVENUE_2_EXTRACT
-|dp_csv_nr.vehicle_utilisation
+|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Revenue End
+|P_REVENUE_END	||M	|| ||TODAY	|| || || ||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Revenue Start
+|P_REVENUE_START	||M	|| ||TODAY	|| || || ||
 |}
-==Vehicle Utilisation Heavy==
+==TYRE SUMMARY EXTRACT==
+{{Note}} Can be run from Trip Waterfall screen.
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,832: / Line 7,005: @@
 !'''Procedure for Scheduling'''
 |-
-|Vehicle Utilisation  Heavy
+|TYRE SUMMARY  EXTRACT
-|hvy_vehicle_util
+|TYRE_SUMMARY_EXTRACT
-|dp_csv_nr.heavy_vehicle_utilisation
+|DP_CSV6.TYRE_SUMMARY_EXTRACT
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Carrier Code	||O	||	||	||	||	||	||
+|Schedule
-|-
+|i_sched_name	||M	||	||	||	||	||	||
-|Carrier Group	||O	||	||	||	||	||	||
-|-
-|Cost Centre	||O	||	||	||	||	||	||
-|-
-|Customer Group	||O	||	||	||	||	||	||
-|-
-|End Schedule	||M	||	||	||	||	||	||
-|-
-|Start Schedule	||M	||	||	||	||	||	||
 |}
-==Vehicle Utilisation Non-Heavy==
+==Trip Actuals==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,859: / Line 7,024: @@
 !'''Procedure for Scheduling'''
 |-
-|Vehicle Utilisation  Non-Heavy
+|Trip Actuals
-|vehicle_util
+|TRIP_ACTUALS
-|dp_csv_nr.vehicle_utilisation
+|CSV.TRIP_ACTUALS
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Carrier Group	||O	||	||	||	||	||	||
+|Schedule
-|-
+|i_schedule	||M	||	||	||	||	||	||
-|Customer Group	||O	||	||	||	||	||	||
-|-
-|Cost Centre	||O	||	||	||	||	||	||
-|-
-|End Schedule	||M	||	||	||	||	||	||
-|-
-|Start Schedule	||M	||	||	||	||	||	||
-|-
-|Carrier Code	||O	||	||	||	||	||	||
 |}
-==Volume Deviation Extract==
+==Trip Assessment Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,886: / Line 7,043: @@
 !'''Procedure for Scheduling'''
 |-
-|Volume Deviation  Extract
+|Trip Assessment  Extract
-|VOLUME_DEVIATION_EXTRACT
+|chk_trips
-|DP_CSV5.volume_deviation_report
+|dp_csv_lfs.chk_trips
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Carrier	||O	||	||ALL	||	||	||	||
+|Schedule
-|-
+|i_sched	||M	||	||	||	||	||	||
-|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==
+==Trip Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,917: / Line 7,062: @@
 !'''Procedure for Scheduling'''
 |-
-|Volume or Activity
+|Trip Extract
-|VOLUME_ACTIVITY
+|Trip_Extract
-|DP_CSV6.VOLUME_ACTIVITY
+|CSV.Trip_Extract
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|From Date
+|i_from_date	||O	||	TODAY|| ||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|To Date
+|i_to_date	||O	||TODAY	||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|Carrier
-|-
+|i_carrier	||O	|| || ||	||	||	||
-|Customer	||O	||	||	||	||	||	||
-|-
-|Dealer	||O	||	||	||	||	||	||
-|-
-|Depot	||O	||	||	||	||	||	||
-|-
-|Media Type	||O	||	||	||	||	||	||
 |}
-==WCS Location Snapshot==
+==Trip and Order Detail Extract==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,946: / Line 7,087: @@
 !'''Procedure for Scheduling'''
 |-
-|WCS Location  Snapshot
+|Trip and Order  Detail Extract
-|WCS_LOC_SANPSHOT
+|Trip_Order_Detail_Extract
-|DP_CSV2.wcs_loc_snapshot
+|CSV.Trip_Order_Detail_Extract
 |}
 Parameters:
-==WCS Order Items Extract==
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Start Schedule
+|P_START_SCHED	||M	|| ||	||	||	||	||
+|-
+|Location Type
+|i_loc_type	||M	||	||	ALL|| ||	||	||
+|-
+|Carrier
+|i_carrier_id	||O	|| || || ||	||	||
+|-
+|End Schedule
+|P_END_SCHED	||M	||	||	||	||	||	||
+|}
+==Trunking Report==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,957: / Line 7,115: @@
 !'''Procedure for Scheduling'''
 |-
-|WCS Order Items  Extract
+|Trunking Report
-|WCS_ORDER_ITEMS_EXTRACT
+|Trunking_Report
-|DP_CSV2.WCS_ORDER_ITEMS_EXTRACT
+|CSV.Trunking_Report
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Depot
+|p_Depot	||M	||	||	||Depot	||Location Id	||Name	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|End Schedule
+|P_END_SCHED	||M	||	||	||	||	||	||
 |-
-|Order	||O	||STRING	||	||	||	||	||
+|Start Schedule
+|P_START_SCHED	||M	||	||	||	||	||	||
 |-
-|Trip	||O	||STRING	||	||	||	||	||
+|Report Type
+|p_report_type	||M	||STRING	||Revenue	||	||	||	||
 |}
-==Weekly Transport Report ==
+==UNISON Interface Results==
 {| class="wikitable"
 !'''Report Name'''
@@ Line 5,980: / Line 7,143: @@
 !'''Procedure for Scheduling'''
 |-
-|Weekly Transport  Report
+|UNISON Interface  Results
-|Weekly_Transport
+|UNSION_interface_results
-|DP_CSV_BNL.Weekly_Transport
+|CSV.UNISON_if_res
 |}
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Sched	||M	||	||	||	||	||	||
+|Depot
+|i_depot	||O	||	||	||Depot	||Location Id	||Name	||
 |-
-|To Sched	||M	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |-
-|Carrier	||ALL	||	||	||	|| ||
+|To Date
+|i_to_date	||O	||TODAY	||	||	||	||	||
+|-
+|From Date
+|i_from_date	||O	||TODAY	||	||	||	||	||
+|}
+==User Activity Extract==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|User Activity  Extract
+|User_Activity_Extract
+|CSV.User_Activity_Extract
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|To Date
+|i_End_Date_Time	||M	||TODAY	||	||	||	||	||
+|-
+|From Date
+|i_Start_Date_Time	||M	||TODAY	||	||	||	||	||
+|}
+==User Last Logon Extract==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|User Last Logon  Extract
+|USER_LAST_LOGON
+|CSV.user_logon_export
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Days since logon
+|I_NO_DAYS	||M	||STRING	||90	||	||	||	||
+|}
+==Variance Analysis Store Detail==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Variance Analysis  Store Detail
+|VAR_ANLYS_STORE_DTL
+|CSV.VARIANCE_ANALYSIS_STORE_DTL
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Schedule
+|i_Schedule	||M	||	||	||	||	||	||
+|}
+==Variance Analysis Summary==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Variance Analysis  Summary
+|VAR_ANLYSIS_SUM
+|CSV.VARIANCE_ANALYSIS_SUMMARY
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|From Date
+|i_Start_Date_Time	||M	||TODAY	||	||	||	||	||
+|-
+|To Date
+|i_End_Date_Time	||M	||TODAY	||	||	||	||	||
+|}
+==Variance Analysis Trip Detail==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Variance Analysis  Trip Detail
+|VAR_ANLYS_TRIP_DTL
+|CSV.VARIANCE_ANALYSIS_TRIP_DTL
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Schedule
+|i_Schedule	||M	||	||	||	||	||	||
+|}
+==Vehicle Utilisation==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Vehicle Utilisation
+|vehicle_util
+|dp_csv_nr.vehicle_utilisation
+|}
+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'''
+|-
+|Vehicle Utilisation  Heavy
+|hvy_vehicle_util
+|dp_csv_nr.heavy_vehicle_utilisation
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|End Schedule
+|i_Sched_To	||M	|| ||	||	||	||	||
+|-
+|Carrier Code
+|i_carrier_code	||O	||	||	||	||	||	||
+|-
+|Carrier Group
+|i_carrier_group	||O	||	||	||	||	||	||
+|-
+|Customer Group
+|i_cust_group	||O	||	||	||	||	||	||
+|-
+|Cost Centre
+|i_cost_centre	||O	|| ||	||	||	||	||
+|-
+|Start Schedule
+|i_Sched_From	||M	||	||	||	||	||	||
+|}
+==Vehicle Utilisation Non-Heavy==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Vehicle Utilisation  Non-Heavy
+|vehicle_util
+|dp_csv_nr.vehicle_utilisation
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|End Schedule
+|i_Sched_To	||M	|| ||	||	||	||	||
+|-
+|Customer Group
+|i_cust_group	||O	||	||	||	||	||	||
+|-
+|Carrier Group
+|i_carrier_group	||O	||	||	||	||	||	||
+|-
+|Carrier Code
+|i_carrier_code	||O	|| ||	||	||	||	||
+|-
+|Start Schedule
+|i_Sched_From	||M	||	||	||	||	||	||
+|-
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
+|}
+==Volume Deviation Extract==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Volume Deviation  Extract
+|VOLUME_DEVIATION_EXTRACT
+|DP_CSV5.volume_deviation_report
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|To Date
+|i_date_to	||M	||	TODAY|| || ||	||	||
+|-
+|Carrier
+|i_carrier	||O	|| ||	ALL|| ||	||	||
+|-
+|Trip Leg
+|i_trip_leg	||O	||STRING	||	ALL|| ||	||	||
+|-
+|Schedule
+|i_Sched_name	||O	||	||	||	||	||	||
+|-
+|From Date
+|i_date_from	||M	||	TODAY|| || ||	||	||
+|-
+|Deviation
+|i_deviation	||O	||STRING	||ALL	||	||	||	||
+|-
+|Cost Centre
+|I_COST_CENTRE	||O	|| ||ALL	|| ||	||	||
+|-
+|Include Unpacked
+|i_inc_unpacked	||O	||STRING	||Y	|| ||	||	||
+|}
+==Volume or Activity==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Volume or Activity
+|VOLUME_ACTIVITY
+|DP_CSV6.VOLUME_ACTIVITY
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|Schedule From
+|i_sched_from	||M	||	||	||	||	||	||
+|-
+|Customer
+|i_customer	||O	|| ||	||	||	||	||
+|-
+|Media Type
+|i_media	||O	||	||	||	||	||	||
+|-
+|Schedule To
+|i_sched_to	||M	|| ||	||	||	||	||
+|-
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
+|-
+|Depot
+|i_depot	||O	||	||	||	||	||	||
+|-
+|Route Code
+|i_route	||O	||	||	||	||	||	||
+|}
+==WCS Location Snapshot==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|WCS Location  Snapshot
+|WCS_LOC_SANPSHOT
+|DP_CSV2.wcs_loc_snapshot
+|}
+No parameters.
+==WCS Order Items Extract==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|WCS Order Items  Extract
+|WCS_ORDER_ITEMS_EXTRACT
+|DP_CSV2.WCS_ORDER_ITEMS_EXTRACT
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+|-
+|To Date
+|i_end_date	||M	||TODAY	||	||	||	||	||
+|-
+|Trip
+|i_trip	||O	||STRING	|| ||	||	||	||
+|-
+|Customer
+|i_customer	||O	|| || ||	||	||	||
+|-
+|From Date
+|i_start_date	||M	||TODAY	|| ||	||	||	||
+|-
+|Crossdock Depot
+|i_depot
+|O
+|
+|
+|Crossdock  Depot
+|Location  Id
+|Name
+|
+|-
+|Order
+|i_order
+|O
+|STRING
+|
+|
+|
+|
+|
+|}
+==Weekly Transport Report ==
+{| class="wikitable"
+!'''Report Name'''
+!'''Filename'''
+!'''Procedure for Scheduling'''
+|-
+|Weekly Transport  Report
+|Weekly_Transport
+|DP_CSV_BNL.Weekly_Transport
+|}
+Parameters:
+{| class="wikitable"
+!Title
+!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
+!
+|-
+|Weekly  Transport Report
+|To Sched	||i_sched_to	||	M|| ||	||	||	||
+|
+|-
+|Weekly Transport Report
+|From  Sched	||i_sched_from	||	M|| ||	||	||	||
+|
+|-
+|Weekly Transport Report
+|Carrier	||i_carrier	|| ||	||	ALL|| ||
+|
+|
 |}

Anonymous

Search

Extracts Details: Difference between revisions

Latest revision as of 12:37, 31 July 2025

10.6 Customer By Product Export

10.6 Customer Location Export

10.6 Customer Product By Arrival

10.6 Data Extract

10.6 Load Status Export

10.6 Matthew Clark Data Extract

10.6 Planning Export

10.6 Tokairo Export

10.6 Warehouse Extract

1POD Delivery Extract

AA Trip and Order Detail

ACC Missing Payments

ACTIVITY_EXTRACT

Accruals

Actual Load

Actual Unload

Additional Reporting Requirements

Amazon Resources

Amazon Resources Update

Approved Price Report

Asset History

Asset Status

Asset Utilisation

Assets On Time Delivery

Automotive Planning Report

BGW Trip and Order Detail

BGW_DEBRIEF

BMW Asset Dwell

Backing Sheet

Baxter CSR

Baxter Download Id Orders

CARGOWISE Header

CN Data Extract

CN Equipment Moves

CN Planning Export

CN Tokairo Export

CN Trip and Order Detail

CN Warehouse Loading

CN Warehouse Extract

CTM Carrier Responsiveness

CTM Trips Not Responded To

Call Collection OTIF Day

Call Collection OTIF Time Window

Call Delivery OTIF Day

Call Delivery OTIF Time Window

Campus KPI Extract

Carrier DUs Shipped

Carrier Delivery Report

Carrier Invoice

Carrier Self Billing

Catalyst Extract

Co-ordinate Non-Conformities

Commercial

Compliance Report

Concurrent Logon Export

Contracts

Cross Dock

Customer Invoice

Customer Invoice By Dates

Customer Invoice Extract

Cut Offs Extract

D365 Extract

DELIVERY_OVERVIEW

DOOD Rpt

DUs Despatched

DUs Not Loaded

DUs Not Received

Daily Manifest E-OT-L

Daily Receiving E-OT-L

Daily Transport Plan

Daily Unscheduled Orders

Debrief Performance

Del Scans

Delivery Conf

Delivery Schedule Extract

Depot Exits by Hour (Loads)