Extracts Details: Difference between revisions

Revision as of 11:28, 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:

Order Charges Extract

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

Parameters:

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

Order Extract

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

Parameters:

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

Order Interface Results

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

Parameters:

Name	Mand	Def Type
Customer	O
To Date	O	TODAY
From Date	O	TODAY
Depot	O
Message Type	O

Order Items POD Debriefed

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

Parameters:

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

Order Savings

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

Parameters:

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

Order Tracking

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

Parameters:

Name	Mand	Def Type	Def Val
Customer	O	STRING	OPENFIELD
Month	M
Week Offset	O
Year	M
Cost Centre	O	STRING	OPENFIELDCC

Orders for Relabelling

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

Parameters:

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

Orders to LogiX

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

Parameters:

Orders to Paragon

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

Parameters:

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

Outbound Shortage

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

Parameters:

Name	Mand	Def Type
Schedule To	M
Schedule From	M
Dealer	O	STRING
Media Type	O	STRING
Route	O	STRING
Depot	O	STRING
Customer	O	STRING

PAYMENT_DTLS

Report Name	Filename	Procedure for Scheduling
PAYMENT_DTLS	PAYMENT_DTLS	OF_INT.WRITE_PAYMENT_DETAILS

Parameters:

Name	Mand	Def Type
End Date	M	TODAY
From Date	M	TODAY
Customer	M

POC to SAP Extract

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

Parameters:

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

POC to SAP Extract(A)

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

Parameters:

Name	Mand	Def Type	Def Val	LOV	Column 1	Column 2	Column 3
Resend All?	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:

POD Delivery Extract

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

Parameters:

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

POD Generation Extract

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

Parameters:

Name	Mand	Def Type
POD Flow	M
Date To	M	TODAY
Date From	M	TODAY
Schedule	O

POD to SAP Extract

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

Parameters:

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

POD to SAP Extract(A)

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

Parameters:

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

PORSCHE19 Invoice Extract

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

Parameters:

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

PROVIDER_REVENUE

Report Name	Filename	Procedure for Scheduling
PROVIDER_REVENUE	PROVIDER_REVENUE	dp_csv3.provider_revenue

Parameters:

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

Parts and Empites

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

Parameters:

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

PostCode Matrix

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

Parameters:

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

Pre Invoice Check

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

Parameters:

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

Process Items Audit

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

Parameters:

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:

Name	Mand	Def Type	Def Val
Incl. Reprocessed	M	STRING	N
Start Date	M	TODAY
End Date	M	TODAY
Record Status	M	STRING	ALL

Provisional Booking Exceptions

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

Parameters:

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

Purchase Order Extract

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

Parameters:

Name	Mand	Def Type	Def Val
Status	O	STRING	All
To Date	O	TODAY	TODAY
From Date	O	TODAY	TODAY

Reason Listings

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

Parameters:

Name	Mand	Def Type	Def Val
Date From	M	DATETIME	TODAY:00:01
Depot	M
Date To	M	DATETIME	TODAY:23:59

Receipt Scanning

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

Parameters:

Name	Mand	Def Type
Dealer	O	STRING
Route	O	STRING
Media Type	O	STRING
Customer	O	STRING
Date To	M	TODAY
Date From	M	TODAY
Depot	O	STRING

Receiving Extract

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

Parameters:

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

Revenue Check (Account)

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

Parameters:

Name	Mand	Def Type
From Date	M	TODAY
From Date	M	TODAY
Cost Centre	O
Cust Group	O
Customer	O

SMS Email Summary Report

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

Parameters:

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

STL Trip and Order Extract

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

Parameters:

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

Sales Margin Extract

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

Parameters:

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

Savings Extract

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

Parameters:

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

Schedule

Report Name	Filename	Procedure for Scheduling
Schedule	Schedule	CSV.SCHEDULE

Parameters:

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

Schedule Details

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

Parameters:

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

Schedule Trips CS

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

Parameters:

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

Scheduled and Cancelled Orders

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

Parameters:

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

Scheduled and Cancelled Orders v2

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

Parameters:

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

Short Rail Report

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

Parameters:

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

Slot Extract

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

Parameters:

Name	Mand	Def Type	Def Val
Day	O	String	ALL
Slot Type	O	String	ALL
Location Type	O	String	ALL

Store PVA

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

Parameters:

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

Store Pre Warning

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

Parameters:

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

Sub Contractor

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

Parameters:

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

Supplier DUs

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

Parameters:

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

Supplier DUs By Store

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

Parameters:

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

Supplier Invoice

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

Parameters:

Name	Mand	Def Type
Start Date	O
End Date	O
Invoice ID	O	STRING
End Date	O
Invoice ID	O	STRING
Start Date	O
Start Schedule	M
End Schedule	M

Supplier Revenue

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

Parameters:

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

Supplier Revenue 2

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

Parameters:

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

TYRE SUMMARY EXTRACT

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

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

Trip Actuals

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

Parameters:

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

Trip Assessment Extract

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

Parameters:

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

Trip Extract

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

Parameters:

Name	Mand	Def Type
Carrier	O
To Date	O	TODAY
From Date	O	TODAY

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:

Name	Mand	Def Val
Carrier	O
End Schedule	M
Location Type	M	ALL
Start Schedule	M

Trunking Report

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

Parameters:

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

UNISON Interface Results

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

Parameters:

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

User Activity Extract

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

Parameters:

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

User Last Logon Extract

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

Parameters:

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

Variance Analysis Store Detail

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

Parameters:

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

Variance Analysis Summary

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

Parameters:

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

Variance Analysis Trip Detail

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

Parameters:

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

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

Vehicle Utilisation Non-Heavy

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

Parameters:

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

Volume Deviation Extract

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

Parameters:

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

Volume or Activity

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

Parameters:

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

WCS Location Snapshot

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

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:

Name	Mand	Def Type
From Date	M	TODAY
To Date	M	TODAY
Order	O	STRING
Trip	O	STRING

Weekly Transport Report

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

Parameters:

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

XML Order Interface Export

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

No Parameters

@@ Line 3,721: / Line 3,721: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Sched End	||M	||	||	||	||	||	||
+|DHL Carriers
+|i_dhl_carr	||M	||	||	||	||	||	||
 |-
-|Sched Start	||M	||	||	||	||	||	||
+|Detail Level
+|i_detail	||M	||	||	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Sched Start
+|i_sched_from	||M	|| ||	||	||	||	||
 |-
-|DHL Carriers	||M	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	|| ||	||	||	||	||
 |-
-|Detail Level	||M	||	||	||	||	||	||
+|Sched End
+|i_sched_to	||M	||	||	||	||	||	||
 |}
@@ Line 3,746: / Line 3,752: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Owning Depot	||O	||	||	||	||	||	||
+|Owning depot
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|To Date
+|i_date_to	||M	||TODAY	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_date_from	||M	||TODAY	||	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |}
@@ Line 3,771: / Line 3,783: @@
 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	||
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||Cost Centre	||Location Id	||Name	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |}
@@ Line 3,790: / Line 3,805: @@
 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	||	||	||	||	||	||
 |-
-|Customer	||O	||STRING	||OPENFIELD	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||STRING	||OPENFIELD	||	||	||	||
 |}
@@ Line 3,811: / Line 3,830: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Show Active / Inactive	||M	||STRING	||B	||	||	||	||
+|Show Active / Inactive
+|i_inactive	||M	||STRING	||B	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |-
-|Depot	||O	||	||	||Depot	||Location Id	||Name	||
+|Depot
+|i_depot	||O	||	||	||Depot	||Location  Id	||Name	||
 |}
@@ Line 3,832: / Line 3,855: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |-
-|Depot	||O	||	||	||	||	||	||
+|Depot
+|i_depot	||O	||	||	||	||	||	||
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|To Date
+|i_to_date	||O	||TODAY	||	||	||	||	||
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|From Date
+|i_from_date	||O	||TODAY	||	||	||	||	||
 |}
@@ Line 3,855: / Line 3,883: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip Status	||O	||	||	||	||	||	||
+|Trip Status
+|I_STATUS	||O	||	||	||	||	||	||
 |-
-|To Schedule	||M	||	||	||	||	||	||
+|To Schedule
+|P_END_SCHED	||M	||	||	||	||	||	||
 |-
-|From Schedule	||M	||	||	||	||	||	||
+|From Schedule
+|P_START_SCHED	||M	||	||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||	||	||	||
 |-
-|Customer Group	||O	||	||	||	||	||	||
+|Customer Group
+|I_CUST_GRP	||O	||	||	||	||	||	||
 |}
@@ Line 3,880: / Line 3,914: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Schedule
+|I_SCHED_NAME	||M	||	||	||	||	||	||
 |-
-|Group Name	||O	||	||	||	||	||	||
+|Group Name
+|I_GROUP_NAME	||O	||	||	||	||	||	||
 |-
-|Delivery Location	||O	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Delivery Location
-|-
+|I_DEL_LOCATION	||O	||	||	||	||	||	||
-|Group Name	||O	||	||	||	||	||	||
-|-
-|Schedule	||M	||	||	||	||	||	||
-|-
-|Delivery Location	||O	||	||	||	||	||	||
-|-
-|Customer	||O	||	||	||	||	||	||
 |}
@@ Line 3,911: / Line 3,942: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip ID (optional)	||O	||	||	||	||	||	||
+|Trip ID (optional)
+|i_trip_id	||O	||	||	||	||	||	||
 |-
-|Owning Depot	||O	||	||	||Depot	||Location Id	||Name	||
+|Owning Depot
+|i_depot	||O	||	||	||Depot	||Location  Id	||Name	||
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Load Location
+|i_load_loc	||O	|| ||	||	Loading  Location||	Location  Id||	Name||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Group Name
+|i_group_name	||O	||	||	||	||	||	||
 |-
-|Group Name	||O	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |-
-|Load Location	||O	||	||	||Loading Location	||Location Id	||Name	||
+|Schedule
-|-
+|i_sched	||M	|| ||	|| || || ||
-|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	||
 |}
@@ Line 3,950: / Line 3,976: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||	||	||	||	||	||
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||	||	||	||
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Depot
+|P_LOCATION	||O	|| ||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	||	||	||	||	||	||
 |-
-|Depot	||O	||	||	||	||	||	||
+|Schedule
+|I_SCHED_NAME	||M	|| ||	||	||	||	||
 |}
@@ Line 3,973: / Line 4,004: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip ID (optional)	||O	||	||	||	||	||	||
+|Carrier
+|P_CARRIER	||O	||	||	||	||	||	||
 |-
-|Load Location	||O	||	||	||Loading Location	||Loading Location	||Name	||
+|Group Name
+|P_GROUP_NAME	||O	||	||	|| || || ||
 |-
-|Owning Depot	||O	||	||	||Depot	||Loading Location	||Name	||
+|Owning Depot
+|P_OWNING_DEPOT	||O	||	||	||Depot	||Loading  Location	||Name	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Customer
+|P_CUSTOMER	||O	|| ||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Schedule To
+|P_SCHED_TO	||M	||	||	||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Trip ID (optional)
+|P_TRIP_ID	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Load Location
+|P_LOAD_LOC	||O	||	||	||	Loading  Location||	Loading  Location||	Name||
 |-
-|Group Name	||O	||	||	||	||	||	||
+|Schedule From
+|P_SCHED_FROM	||M	|| ||	||	||	||	||
 |}
@@ Line 4,004: / Line 4,044: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|End Date	||O	||	||	||	||	||	||
+|Invoice ID
-|-
+|P_INVOICE_ID	||O	||	STRING|| ||	||	||	||
-|Start Date	||O	||	||	||	||	||	||
-|-
-|Invoice ID	||O	||STRING	||	||	||	||	||
-|-
-|End Date	||O	||	||	||	||	||	||
-|-
-|Start Date	||O	||	||	||	||	||	||
-|-
-|Invoice ID	||O	||STRING	||	||	||	||	||
 |}
@@ Line 4,053: / Line 4,085: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|From Date
+|I_FROM_DATE	||M	||TODAY	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|To Date
+|I_TO_DATE	||O	||TODAY	||	||	||	||	||
 |}
@@ Line 4,072: / Line 4,107: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Activity	||M	||STRING	||Both	||	||	||	||
+|End Schedule
+|P_END_SCHED	||M	|| || || ||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Activity
+|i_activity_name	||M	||	STRING||	Both|| ||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Loaded At
+|i_loaded_at	||O	||	||	||	||	||	||
 |-
-|Loaded At	||O	||	||	||	||	||	||
+|Start Schedule
+|P_START_SCHED	||M	|| ||	||	||	||	||
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Carrier
+|i_carrier_id	||O	|| ||	||	||	||	||
 |-
-|Group Name	||M	||	||	||	||	||	||
+|Group Name
+|i_group_name	||M	||	||	||	||	||	||
 |}
@@ Line 4,099: / Line 4,141: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||M	||STRING	||ALL	||	||	||	||
+|Customer
+|I_CUSTOMER	||M	||STRING	||ALL	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|Start Schedule
+|I_FROM_SCHED_NAME	||M	||	||	||	||	||	||
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|End Schedule
+|I_TO_SCHED_NAME	||M	||	||	||	||	||	||
 |}
@@ Line 4,120: / Line 4,166: @@
 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
 |-
-|Customer	||M	||STRING	||ALL	|| || || ||
+|Customer	||I_CUSTOMER	||M	||STRING	|| ALL|| || ||
+|
 |-
-|End Schedule	||M	|| || || || || ||
+|Start Schedule	||I_FROM_SCHED_NAME	|| M|| || || || ||
+|
 |-
-|Start Schedule	||M	|| || || || || ||
+|End Schedule	||I_TO_SCHED_NAME	|| M|| || || || ||
+|
 |}
@@ Line 4,141: / Line 4,191: @@
 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
 |-
-|Customer	||M	||STRING	||ALL	|| || || ||
+|Customer	||I_CUSTOMER	||M	||STRING	|| ALL|| || ||
+|
 |-
-|End Schedule	||M	|| || || || || ||
+|Start Schedule	||I_FROM_SCHED_NAME	|| M|| || || || ||
+|
 |-
-|Start Schedule	||M	|| || || || || ||
+|End Schedule	||I_TO_SCHED_NAME	|| M|| || || || ||
+|
 |}
@@ Line 4,162: / Line 4,216: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|External Ref	||O	||STRING	||	||	||	||	||
+|Source System
+|P_SOURCE_SYSTEM	||O	|| || ||	Source System|| ||	||
 |-
-|Customer	||O	||	||	||Customer	||	||	||
+|Customer
+|P_CUSTOMER	||O	||	||	||Customer	||	||	||
 |-
-|Source System	||O	||	||	||	||	||	||
+|External Ref
+|P_EXTERNAL_REF	||O	||	STRING|| ||	||	||	||
 |-
-|End Date	||M	||TODAY	||	||	||	||	||
+|End Date
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Start Date	||M	||TODAY	||	||	||	||	||
+|Start Date
+|P_START_DATETIME	||M	||TODAY	||	||	||	||	||
 |}
@@ Line 4,187: / Line 4,247: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Start Schedule	||M	||	||	||	||	||	||
+|Customer
+|i_customer	||0	|| ||	||	||	||	||
 |-
-|End Schedule	||M	||	||	||	||	||	||
+|End Schedule
+|i_end_sched	||M	||	||	||	||	||	||
 |-
-|Customer	||0	||	||	||	||	||	||
+|Start Schedule
+|i_start_sched	||M	|| ||	||	||	||	||
 |}
@@ Line 4,208: / Line 4,272: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Actual To Date	||M	||TODAY	||	||	||	||	||
+|Actual From Date
+|P_START_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|Actual To Date
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Supplier	||O	||	||	||	||	||	||
+|Supplier
+|P_SUPPLIER	||O	||	||	||	||	||	||
 |-
-|DU Type	||O	||	||	||	||	||	||
+|DU Type
+|P_DU_TYPE	||O	||	||	||	||	||	||
 |-
-|Store	||O	||	||	||	||	||	||
+|Manifest Number
+|P_MANF_NO	||O	||	||	||	||	||	||
 |-
-|Manifest Number	||O	||	||	||	||	||	||
+|P/O Number
+|P_PO_NO	||O	||	||	||	||	||	||
 |-
-|P/O Number	||O	||	||	||	||	||	||
+|Store
+|P_STORE	||O	||	||	||	||	||	||
 |}
@@ Line 4,237: / Line 4,309: @@
 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	||	||	||	||	||	||
+|Actual From Date	||P_START_DATETIME	||	M||	TODAY|| ||	||	||
+|
 |-
-|Supplier	||O	||	||	||	||	||	||
+|Actual To Date	||P_END_DATETIME	||	M||	TODAY|| ||	||	||
+|
 |-
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|Supplier	||P_SUPPLIER	||O	|| ||	||	||	||
+|
 |-
-|Actual To Date	||M	||TODAY	||	||	||	||	||
+|DU Type	||P_DU_TYPE	||O	|| ||	||	||	||
+|
 |-
-|P/O Number	||O	||	||	||	||	||	||
+|Manifest Number	||P_MANF_NO	||	O|| ||	||	||	||
+|
 |-
-|Store	||O	||	||	||	||	||	||
+|P/O Number	||P_PO_NO	||	O|| ||	||	||	||
+|
 |-
-|Manifest Number	||O	||	||	||	||	||	||
+|Store	||P_STORE	||	O|| ||	||	||	||
+|
 |}
@@ Line 4,266: / Line 4,346: @@
 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	||	||	||	||	||	||
+|Actual From Date	||P_START_DATETIME	||	M||	TODAY|| ||	||	||
+|
 |-
-|Store	||O	||	||	||	||	||	||
+|Actual To Date	||P_END_DATETIME	||	M||	TODAY|| ||	||	||
+|
 |-
-|Manifest Number	||O	||	||	||	||	||	||
+|Supplier	||P_SUPPLIER	||	O|| ||	||	||	||
+|
 |-
-|DU Type	||O	||	||	||	||	||	||
+|DU Type	||P_DU_TYPE	||	O|| ||	||	||	||
+|
 |-
-|Supplier	||O	||	||	||	||	||	||
+|Manifest Number	||P_MANF_NO	||	O|| ||	||	||	||
+|
 |-
-|Actual To Date	||M	||TODAY	||	||	||	||	||
+|P/O Number	||P_PO_NO	||O	|| ||	||	||	||
+|
 |-
-|Actual From Date	||M	||TODAY	||	||	||	||	||
+|Store	||P_STORE	||O	|| ||	||	||	||
+|
 |}
@@ Line 4,295: / Line 4,383: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Depot
+|P_DEPOT	||M	||	||	||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Schedule To
+|P_END_SCHED	||M	||	||	||	||	||	||
 |-
-|Depot	||M	||	||	||	||	||	||
+|Schedule From
+|P_START_SCHED	||M	||	||	||	||	||	||
 |}
@@ Line 4,316: / Line 4,408: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Trip	||M	||	||	||	||	||	||
+|Schedule
+|P_SCHED	||M	||	||	||	||	||	||
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Trip
+|P_TRIP_ID	||M	||	||	||	||	||	||
 |}
@@ Line 4,335: / Line 4,430: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||O	||TODAY	||	||	||	||	||
+|Customer
+|I_CUSTOMER	||O	|| || ||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Depot
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Depot	||O	||	||	||	||	||	||
+|From Date
+|i_from_date	||O	||	TODAY|| ||	||	||	||
 |-
-|From Date	||O	||TODAY	||	||	||	||	||
+|To Date
+|i_to_date	||O	||TODAY	||	||	||	||	||
 |}
@@ Line 4,357: / Line 4,457: @@
 |}
 Parameters:
+{| class="wikitable"
+!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==
 {| class="wikitable"
@@ Line 4,369: / Line 4,531: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer Group	||O	||	||	||	||	||	||
+|Start Date
-|-
+|I_START_DATE_TIME	||M	||	TODAY|| ||	||	||	||
-|End Date	||M	||	||	||	||	||	||
 |-
-|Show Detail	||M	||STRING	||Y	||	||	||	||
+|Tolerance(days)
+|I_TOLERANCE	||O	|| ||	||	||	||	||
 |-
-|Grouping	||M	||STRING	||CUST_GROUP	||	||	||	||
+|Customer Group
+|I_CUST_GROUP	||O	|| || || ||	||	||
 |-
-|End Date	||M	||TODAY	||	||	||	||	||
+|End Date
+|I_END_DATE_TIME	||M	||TODAY	|| || ||	||	||
 |-
-|Start Date	||M	||TODAY	||	||	||	||	||
+|Grouping
-|-
+|I_GROUP_BY	||M	||STRING	||	CUST_GROUP|| ||	||	||
-|Start Date	||M	||	||	||	||	||	||
-|-
-|Tolerance(days)	||O	||	||	||	||	||	||
-|-
-|Separate Pages	||M	||STRING	||N	||	||	||	||
-|-
-|Customer Group	||O	||	||	||	||	||	||
-|-
-|Grouping	||M	||STRING	||CUST_GROUP	||	||	||	||
 |}
@@ Line 4,405: / Line 4,561: @@
 |}
 Parameters:
+{| class="wikitable"
+!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==
 {| class="wikitable"
@@ Line 4,417: / Line 4,610: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|I_START_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|To Date
+|I_END_DATETIME	||M	||TODAY	||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Cost Centre
+|I_COST_CENTRE	||O	||	||	||	||	||	||
 |}
@@ Line 4,438: / Line 4,635: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule 	||M	||	||	||	||	||	||
+|External Ref
+|i_ext_ref 	||O	|| ||	||	||	||	||
 |-
-|Order Status 	||O	||	||	||	||	||	||
+|Customer
+|i_customer 	||O	||	||	||	||	||	||
 |-
-|Customer 	||O	||	||	||	||	||	||
+|Schedule
+|i_sched 	||M	|| ||	||	||	||	||
 |-
-|External Ref	||O	||	||	||	||	||	||
+|Order Status
+|i_ord_status	||O	||	||	||	||	||	||
 |}
@@ Line 4,461: / Line 4,663: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Customer	||O	||	||	||	||	||	||
+|From Loc
+|p_from_loc	||O	||	||	||	From Loc||	Location Id||	Name||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|To Loc
+|p_to_loc	||O	||	||	||	To Loc||	Location  Id||	Name||
 |-
-|To Loc	||O	||	||	||To Loc	||Location Id	||Name	||
+|Customer
+|p_customer	||O	||	||	|| || || ||
 |-
-|From Loc	||O	||	||	||From Loc	||Location Id	||Name	||
+|Cost Centre
+|p_cost_centre	||O	||	||	|| || || ||
 |}
@@ Line 4,484: / Line 4,691: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Store (optional)	||O	||	||	||Store	||Location ID	||Name	||
+|Trip ID (optional)
+|P_TRIP_ID	||O	||	||	|| || || ||
 |-
-|Days Back	||M	||STRING	||30	||	||	||	||
+|Store (optional)
+|P_STORE	||O	|| || ||	Store||	Location  ID||	Name||
 |-
-|Trip ID (optional)	||O	||	||	||	||	||	||
+|Days Back
+|P_DAYS_BACK	||M	||	STRING||	30|| ||	||	||
 |}
@@ Line 4,505: / Line 4,716: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule	||M	||	||	||	||	||	||
+|Schedule
+|P_SCHED_DATE	||M	||	||	||	||	||	||
 |}
@@ Line 4,522: / Line 4,735: @@
 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_Time	||M	||	TODAY|| || || || ||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_Start_Time	||M	||TODAY	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Depot
+|i_Depot	||M	|| || ||	Depot||	Location  Id||	Name||
 |}
@@ Line 4,543: / Line 4,760: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Country	||O	||	||	||	||	||	||
+|Location Group
+|I_CUST_GROUP	||O	||	||	||	||	||	||
+|-
+|Country
+|i_country
+|O
+|
+|
+|
+|
+|
+|
 |}
@@ Line 4,558: / Line 4,787: @@
 |CSV.LOCATION_EXPORT_GL
 |}
-Parameters:
+No parameters
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
-|-
-|Country	||O	|| || || || || ||
-|}
 ==Location Export GPR==
 {| class="wikitable"
@@ Line 4,575: / Line 4,798: @@
 |CSV.LOCATION_EXPORT_GPR
 |}
-Parameters:
+No parameters.
-{| class="wikitable"
-!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
-|-
-|Country	||O	|| || || || || ||
-|}
 ==Location Pre-Warning==
 {| class="wikitable"
@@ Line 4,594: / Line 4,811: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Load Type	||M	||STRING	||ALL	||	||	||	||
+|Depot
-|-
+|i_depot	||M	|| || ||	Depot||	Location Id||	Name||
-|Trip Status	||M	||STRING	||ALL	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_start_date_time	||M	||TODAY	|| || ||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Load Type
+|i_load_type	||M	||STRING	||	ALL|| ||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|To Date
+|i_end_date_time	||M	||TODAY	||	||	||	||	||
 |-
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
+|Trip Status
-|-
+|i_trip_status	||M	||STRING	||	ALL|| ||	||	||
-|Depot	||M	||	||	||Depot	||Location Id	||Name	||
-|-
-|From Date	||M	||TODAY	||	||	||	||	||
-|-
-|Load Type	||M	||STRING	||ALL	||	||	||	||
-|-
-|Trip Status	||M	||STRING	||ALL	||	||	||	||
 |}
@@ Line 4,629: / Line 4,842: @@
 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	||	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|To Date
+|P_END_DATETIME	||M	||TODAY	||	||	||	||	||
 |}
@@ Line 4,647: / Line 4,863: @@
 |}
 Parameters:
+{| class="wikitable"
+!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==
 {| class="wikitable"
@@ Line 4,658: / Line 4,916: @@
 |}
 Parameters:
+{| class="wikitable"
+!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==
 {| class="wikitable"
@@ Line 4,670: / Line 4,970: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||O	||	||	||	||	||	||
+|From Date
+|P_START_DATE	||O	||	||	||	||	||	||
 |-
-|To Date	||O	||	||	||	||	||	||
+|To Date
+|P_END_DATE	||O	||	||	||	||	||	||
 |}
@@ Line 4,689: / Line 4,992: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Show UnMapped	||O	||	||	||Show UnMapped	||	||	||
+|Show Mapped
+|P_SHOW_MAPPED	||O	||	||	||Show Mapped	|| ||	||
 |-
-|Show Mapped	||O	||	||	||Show Mapped	||	||	||
+|Show UnMapped
+|P_SHOW_UNMAPPED	||O	||	||	||Show  UnMapped	|| ||	||
 |}
@@ Line 4,706: / Line 5,012: @@
 |CSV.msg_maint
 |}
-Parameters:
+No parameters
 ==Missing Lat Long Report==
 {| class="wikitable"
@@ Line 4,719: / Line 5,025: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Cost Centre	||M	||	||ALL	||	||	||	||
+|Cost Centre
+|i_cost_centre	||M	||	||ALL	||	||	||	||
 |}
@@ Line 4,736: / Line 5,044: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|Missing Step
+|i_step	||O	||STRING	||	ALL|| ||	||	||
 |-
-|Missing Step	||O	||STRING	||ALL	||	||	||	||
+|To Date
+|i_date_to	||M	||TODAY	|| || ||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_date_from	||M	||TODAY	||	||	||	||	||
 |}
@@ Line 4,757: / Line 5,069: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_End_Date_Time	||M	||TODAY	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_Start_Date_Time	||M	||TODAY	||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Cust Group
+|i_cust_group	||O	||	||	||	||	||	||
 |-
-|Cust Group	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |}
@@ Line 4,780: / Line 5,098: @@
 |dp_csv_nr.nr_additional_report
 |}
-Parameters:
+No parameters
 ==NR Finance Extract==
 {| class="wikitable"
@@ Line 4,793: / Line 5,111: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Debriefed
+|i_debriefed	||M	|| || ||	||	||	||
 |-
-|Debriefed	||M	||	||	||	||	||	||
+|From Date
+|i_from_date	||M	||	TODAY|| ||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Carrier
+|i_carrier	||O	||	||	||	||	||	||
 |-
-|To Region	||M	||STRING	||ALL	||	||	||	||
+|To Region
+|i_to_region	||M	||STRING	||ALL	||	||	||	||
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|From Region
+|i_from_region	||M	||STRING	||	ALL|| ||	||	||
 |-
-|Carrier Group	||O	||	||	||	||	||	||
+|Carrier Group
+|i_carrier_group	||O	||	||	||	||	||	||
 |-
-|Strategy	||O	||	||	||	||	||	||
+|Strategy
+|i_strategy	||O	||	||	||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|From Region	||M	||STRING	||ALL	||	||	||	||
+|To Date
+|i_to_date	||M	||TODAY	|| || ||	||	||
 |}
@@ Line 4,828: / Line 5,157: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|To Date	||M	||TODAY	||	||	||	||	||
+|From Date
+|i_from_date	||M	||TODAY	||	||	||	||	||
 |-
-|From Date	||M	||TODAY	||	||	||	||	||
+|Carrier
+|i_carrier	||O	|| || ||	||	||	||
 |-
-|Debriefed	||M	||	||	||	||	||	||
+|To Region
+|i_to_region	||M	||	STRING||	ALL|| ||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|From Region
+|i_from_region	||M	||	STRING||	ALL|| ||	||	||
 |-
-|To Region	||M	||STRING	||ALL	||	||	||	||
+|Debriefed
+|i_debriefed	||M	|| || || ||	||	||
 |-
-|From Region	||M	||STRING	||ALL	||	||	||	||
+|Strategy
+|i_strategy	||O	|| || || ||	||	||
 |-
-|Carrier Group	||O	||	||	||	||	||	||
+|Cost Centre
+|i_cost_centre	||O	||	||	||	||	||	||
 |-
-|Strategy	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|To Date
+|i_to_date	||M	||	TODAY|| ||	||	||	||
 |-
-|Cost Centre	||O	||	||	||	||	||	||
+|Carrier Group
+|i_carrier_group	||O	||	||	||	||	||	||
 |}
@@ Line 4,862: / Line 5,202: @@
 |}
 Parameters:
+{| class="wikitable"
+!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==
 {| class="wikitable"
@@ Line 4,873: / Line 5,295: @@
 |}
 Parameters:
+{| class="wikitable"
+!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==
 {| class="wikitable"
@@ Line 4,885: / Line 5,389: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Date To	||M	||TODAY	||	||	||	||	||
+|Date To
+|i_date_to	||M	||TODAY	||	||	||	||	||
 |-
-|Date From	||M	||TODAY	||	||	||	||	||
+|Carrier
+|i_carrier	||O	|| || ||	||	||	||
 |-
-|Carrier	||O	||	||	||	||	||	||
+|Date From
+|i_date_from	||M	||	TODAY|| ||	||	||	||
 |}
@@ Line 4,906: / Line 5,414: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Outbase	||O	||	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	|| ||	||	||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Schedule To
+|i_sched_to	||M	|| ||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Dealer	||O	||	||	||	||	||	||
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Route Code
+|i_route	||O	||	||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Media Type
+|i_media	||O	|| ||	||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Dealer
+|i_dealer	||O	|| ||	||	||	||	||
 |}
@@ Line 4,935: / Line 5,451: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Outbase	||O	||	||	||	||	||	||
+|Route Code
+|i_route	||O	||	||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Customer
+|i_customer	||O	|| ||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Media Type
+|i_media	||O	||	||	||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	||	||	||	||	||	||
 |-
-|Dealer	||O	||	||	||	||	||	||
+|Schedule To
+|i_sched_to	||M	|| ||	||	||	||	||
 |}
@@ Line 4,964: / Line 5,488: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Dealer	||O	||	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	|| ||	||	||	||	||
 |-
-|Outbase	||O	||	||	||	||	||	||
+|Schedule To
+|i_sched_to	||M	|| ||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Media Type
+|i_media	||O	|| ||	||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Route Code
+|i_route	||O	|| ||	||	||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |}
@@ Line 4,993: / Line 5,525: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Schedule To
+|i_sched_to	||M	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	|| ||	||	||	||	||
 |-
-|Dealer	||O	||	||	||	||	||	||
+|Route Code
+|i_route	||O	||	||	||	||	||	||
 |-
-|Outbase	||O	||	||	||	||	||	||
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Media Type
+|i_media	||O	|| ||	||	||	||	||
 |}
@@ Line 5,022: / Line 5,562: @@
 Parameters:
 {| class="wikitable"
+!Title
 !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
 |-
-|Media Type	||O	||	||	||	||	||	||
+|Route Code
+|i_route	||O	||	||	||	||	||	||
 |-
-|Route Code	||O	||	||	||	||	||	||
+|Media Type
+|i_media	||O	||	||	||	||	||	||
 |-
-|Outbase	||O	||	||	||	||	||	||
+|Outbase
+|i_depot	||O	||	||	||	||	||	||
 |-
-|Dealer	||O	||	||	||	||	||	||
+|Dealer
+|i_dealer	||O	||	||	||	||	||	||
 |-
-|Customer	||O	||	||	||	||	||	||
+|Customer
+|i_customer	||O	||	||	||	||	||	||
 |-
-|Schedule From	||M	||	||	||	||	||	||
+|Schedule To
+|i_sched_to	||M	||	||	||	||	||	||
 |-
-|Schedule To	||M	||	||	||	||	||	||
+|Schedule From
+|i_sched_from	||M	||	||	||	||	||	||
 |}

Anonymous

Search

Extracts Details: Difference between revisions

Revision as of 11:28, 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)