Extracts Details

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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Column 3
> 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	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Column 3
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	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	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

Baxter CSR

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

Parameters:

Title	Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
Depot	O			Depot	Location Id	Name
From Date	M	TODAY
Customer	O
Group Name	O
To Date	M	TODAY

CN Equipment Moves

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

Parameters:

Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
Group Name	O
Current Depot	M			Current Depot	Location Id	Name
To Date	M	TODAY
From Date	M	TODAY

CN Tokairo Export

Warning: 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	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
From Location	M			From Location	Location Id	Name
From Date	M	TODAY
To Date	M	TODAY
Owning Depot	M			Depot	Location Id	Name
Group Name	O
Trip ID (optional)	O
Depot	M			Depot	Location Id	Name
Carrier	O
Start Schedule	M
End Schedule	M
Customer	O			Customer	CUSTOMER_ID	CUSTOMER_NAME

CTM Carrier Responsiveness

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

Parameters:

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

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

Parameters:

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

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	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	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

Order Savings

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

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	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	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	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
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	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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

This extract reports on the Items and Items Reasons. That will include all scanning events from WCS, MCS, EPOD and APOD.

Note: The report is based off the actual arrival date/time and the depot. If the trip for that depot and order has not been debriefed yet, then the items and reasons will not be displayed.

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

Parameters:

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

Columns:

• Trip - the trip on which the item was moved.
• Route - the route (if present) from the trip.
• Stop Name - the location name.
• PO Reference - the order's booking reference.
• Customer Reference - the order's eternal reference.
• Reason Code - the reason code.
• Reason Text - the reason description.
• Comment User - any comment against that item reason.
• Line DU - the item type.
• Line Planned Qty - the planned quantity in total of that type.
• Line Delivered Qty - the delivered quantity in total of that type.
• Line Variance - any variance between the quantity in total of that type.
• Item ID - the individual item ID.
• Item Desc - the description of that item.
• Item Planned Qty - the planned quantity of that item.
• Item Delivered Qty - the delivered quantity of that item.
• Item Variance - any variance between the planned and delivered quantity of that item.

Receipt Scanning

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

Parameters:

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

This is an extract of unloaded items at the depot.

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

The report shows a summary per date in the selection, and the details in the selection. Both sections contains the same fields:

• Date
• Customer
• Dealer
• Dealer Name
• Origin Depot
• Depot Name
• Route Code
• Media Type
• Asset
• Child Asset
• Pallet ID
• Item Weight
• Item Volume
• Items Created
• Positive Load Scan
• Variance

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	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
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	LOV	Column 1	Column 2	Column 3
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	Column 3
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	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
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	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
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	Def Val	LOV	Column 1	Column 2	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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 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

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	Column 3
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	Def Val	LOV	Column 1	Column 2	Column 3
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	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

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

Parameters:

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

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	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

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

Parameters:

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

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	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

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

Parameters:

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

XML Order Interface Export

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

No Parameters