Extracts Details

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

10.6 Customer By Product Export

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

10.6 Customer Location Export

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

10.6 Customer Product By Arrival

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

10.6 Data Extract

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

10.6 Load Status Export

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

10.6 Matthew Clark Data Extract

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

10.6 Planning Export

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

10.6 Tokairo Export

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

10.6 Warehouse Extract

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

1POD Delivery Extract

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

AA Trip and Order Detail

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

Parameters:

Name	Mand	Def Type	Def Val
Activity	M	STRING	Both
Group Name	M
Start Schedule	M
End Schedule	M
Carrier	O

ACC Missing Payments

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

No parameters

ACTIVITY_EXTRACT

Report Name	Filename	Procedure for Scheduling
ACTIVITY_EXTRACT	ACTIVITY_EXTRACT	dp_csv3.activity_extract

Parameters:

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

Accruals

Report Name	Filename	Procedure for Scheduling
Accruals	ACCRUALS	CSV.ACCRUALS

Parameters:

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

Actual Load

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

Parameters:

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

Actual Unload

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

Parameters:

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

Additional Reporting Requirements

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

Parameters:

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

Amazon Resources

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

Parameters:

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

Amazon Resources Update

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

Parameters:

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

Approved Price Report

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

Parameters:

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

Asset History

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

Parameters:

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

Asset Status

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

Parameters:

Asset Utilisation

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

Parameters:

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

Assets On Time Delivery

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

Parameters:

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

Automotive Planning Report

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

Parameters:

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

BGW Trip and Order Detail

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

Parameters:

Name	Mand	Def Type	Def Val
Start Schedule	M
End Schedule	M
Carrier	O
Loaded At	O
Activity	M	STRING	Both
Group Name	M

BGW_DEBRIEF

Report Name	Filename	Procedure for Scheduling
BGW_DEBRIEF	BGW_DEBRIEF	dp_csv3.bgw_debrief

Parameters:

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

BMW Asset Dwell

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

Parameters:

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

Backing Sheet

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

Parameters:

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

Baxter CSR

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

Parameters:

Name	Mand	Def Type	Def Val
Customer	M	STRING	ALL
From Date	M	TODAY
To Date	M	TODAY
Cost Centre	O

Baxter Download Id Orders

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

Parameters:

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

CARGOWISE Header

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

Parameters:

CN Data Extract

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

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:

Name	Mand	Def Type	Def Val
End Schedule	M
Start Schedule	M
Loaded At	O
Carrier	O
Group Name	M
Activity	M	STRING	Both

CN Warehouse Loading

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

Parameters:

CN Warehouse Extract

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

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

CTM Trips Not Responded To

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

Parameters:

Call Collection OTIF Day

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

Parameters:

Name	Mand	Def Type
Carrier	O
Customer	O
Customer Group	O
Product Type	O
End Schedule	O
Start Schedule	O
From Date	M	TODAY
To Date	M	TODAY

Call Collection OTIF Time Window

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

Parameters:

Name	Mand	Def Type
Carrier	O
Customer	O
Customer Group	O
Product Type	O
End Schedule	O
Start Schedule	O
To Date	M	TODAY
From Date	M	TODAY

Call Delivery OTIF Day

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

Parameters:

Name	Mand	Def Type
Carrier	O
From Date	M	TODAY
To Date	M	TODAY
Start Schedule	O
End Schedule	O
Product Type	O
Customer Group	O
Customer	O

Call Delivery OTIF Time Window

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

Parameters:

Name	Mand	Def Type
End Schedule	O
Product Type	O
Customer Group	O
Customer	O
Carrier	O
From Date	M	TODAY
To Date	M	TODAY
Start Schedule	O

Campus KPI Extract

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

Parameters:

Carrier DUs Shipped

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

Parameters:

Name	Mand	Def Type	Def Val
Carrier	O	STRING	ALL
To Date	M	TODAY
From Date	M	TODAY

Carrier Delivery Report

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

Parameters:

Name	Mand	Def Type	Def Val
Sched Name	M
Carrier	M
Depot	M
Trip ID	O	STRING	ALL

Carrier Invoice

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

Parameters:

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

Carrier Self Billing

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

Parameters:

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

Catalyst Extract

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

Parameters:

Co-ordinate Non-Conformities

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

Parameters:

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

Commercial

Report Name	Filename	Procedure for Scheduling
Commercial	COMMERCIAL	CSV.Commercial_Orders

Parameters:

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

Compliance Report

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

Parameters:

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

Concurrent Logon Export

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

Parameters:

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

Contracts

Report Name	Filename	Procedure for Scheduling
Contracts	CONTRACTS	CSV.CONTRACTS

No Parameters

Cross Dock

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

Parameters:

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

Customer Invoice

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

Parameters:

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

Customer Invoice By Dates

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

Parameters:

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

Customer Invoice Extract

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

Parameters:

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

Cut Offs Extract

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

Parameters:

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

D365 Extract

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

Parameters:

DELIVERY_OVERVIEW

Report Name	Filename	Procedure for Scheduling
DELIVERY_OVERVIEW	DELIVERY_OVERVIEW	dp_csv3.delivery_overview

Parameters:

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

DOOD Rpt

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

Parameters:

Name	Mand	Def Type	Def Val
Schedule To	M
Schedule From	M
Customer	O	STRING	OPENFIELD

DUs Despatched

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

Parameters:

Name	Mand	Def Type
Consignment Num	O	STRING
Start Sched	O
Manifest	O	STRING
PO Number	O	STRING
Supplier	O
End Sched	O

DUs Not Loaded

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

Parameters:

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

DUs Not Received

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

Parameters:

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

Daily Manifest E-OT-L

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

Parameters:

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

Daily Receiving E-OT-L

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

Parameters:

Daily Transport Plan

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

Parameters:

Name	Mand	Def Type	Def Val
Order Status	M	STRING	ALL
Supplier	M	STRING	ALL
To Date	M
From Date	M

Daily Unscheduled Orders

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

Parameters:

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

Debrief Performance

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

Parameters:

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

Del Scans

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

Parameters:

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

Delivery Conf

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

Parameters:

Name	Mand	Def Type	Def Val
Type	M		M
Owning Depot	O
Cost Centre	M
To Actual date	M	TODAY
From Actual date	M	TODAY

Delivery Schedule Extract

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

Parameters:

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

Depot Exits by Hour (Loads)

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

Parameters:

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

Depot Exits by Hour (RPEs)

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

Parameters:

Detailed Interface Report

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

Parameters:

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

Dixons Catalyst Report

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

Parameters:

Name	Mand	LOV	Column 1	Column 2
End Schedule	M
Carrier	O
Depot	O	Depot	Location Id	Name
Start Schedule	M

Dixons Order Export

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

Parameters:

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

Dixons Trip Extract

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

Parameters:

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

Driver Hours

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

Parameters:

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

Driver Scanning

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

Parameters:

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

Dunelm Actual Load

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

Parameters:

Dunelm Actual Unload

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

Parameters:

Dunelm Backing Sheet

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

Parameters:

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

Dunelm DUs Despatched Extract

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

Parameters:

Dunelm DUs Not Loaded Extract

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

Parameters:

Dunelm DUs Not Received

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

Parameters:

Dunelm Inventory Transactions

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

Parameters:

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

Dunelm Item Movements 3

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

Parameters:

Name	Mand	Def Type
Manifest Number	O
Actual To Date	M	TODAY
Actual From Date	M	TODAY
DU Type	O
Supplier	O
P/O Number	O
Store	O

Dunelm Item Movements Extract

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

Parameters:

Name	Mand	Def Type
Manifest Number	O	STRING
P/O Number	O
Store	O
DU Type	O
Supplier	O
Actual To Date	M	TODAY
Actual From Date	M	TODAY

Dunelm Item Movements Extract New

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

Parameters:

Name	Mand	Def Type
P/O Number	O
Manifest Number	O	STRING
Store	O
DU Type	O
Supplier	O
Actual From Date	M	TODAY
Actual To Date	M	TODAY

Dunelm Left Offs

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

Parameters:

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

Dunelm Loading Extract

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

Parameters:

Dunelm Manifest E-OT-L Extract

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

Parameters:

Dunelm Manual Loaded Items Extract

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

Parameters:

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

Dunelm Receiving Extract

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

Parameters:

Dunelm Recieving E-OT-L Extract

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

Parameters:

Dunelm Supplier DU Extract

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

Parameters:

Dunelm Supplier DU Extract by Store

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

Parameters:

Dunelm Supplier Revenue Extract

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

Parameters:

Dunelm Supplier Revenue Extract New

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

Parameters:

Dunelm Supplier Trends Extract

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

Parameters:

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

Dunelm Transport Plan

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

Parameters:

Dunelm Unsched Orders

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

Parameters:

Duplicate Postcodes

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

Parameters:

Name	Mand	LOV	Column 1	Column 2
Ignore Inactive?	O
Location From	O	Location From	Location Id	Location Name
Location To	O	Location To	Location Id	Location Name

EFX Inbound Errors

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

Parameters:

ERC

Report Name	Filename	Procedure for Scheduling
ERC	ERC	DP_CSV_DHL.ERC

Parameters:

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

Equipment Moves

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

Parameters:

Name	Mand	Def Type
Owning Depot	O
Customer	O
To Date	M	TODAY
From Date	M	TODAY
Carrier	O

Extract Lane

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

Parameters:

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

Failed Shipment

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	Def Val
Schedule To	M
Schedule From	M
Customer	O	STRING	OPENFIELD

Fixed Routes Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

GREENE KING Interface Results

Report Name	Filename	Procedure for Scheduling

Parameters:

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

GYP EFX Export

Report Name	Filename	Procedure for Scheduling

Parameters:

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

HC Booking In Form

Report Name	Filename	Procedure for Scheduling

Parameters:

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

HC Haulier Trip Sheet

Report Name	Filename	Procedure for Scheduling

Parameters:

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

HCR Customer Orders

Report Name	Filename	Procedure for Scheduling

Parameters:

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

HCR Loading Sheet CSV

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Haulier Invoice

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Heavy Vehicle Utilisation

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Historical Lane Based Orders

Report Name	Filename	Procedure for Scheduling

Parameters:

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

IND Trip and Order Detail

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	Def Val
Activity	M	STRING	Both
End Schedule	M
Carrier	O
Loaded At	O
Start Schedule	M
Group Name	M

ISC Finance (2) Export

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	Def Val
Customer	M	STRING	ALL
End Schedule	M
Start Schedule	M

Interface Errors Failures

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	LOV
External Ref	O	STRING
Customer	O		Customer
Source System	O
End Date	M	TODAY
Start Date	M	TODAY

Invalid Orders

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Item Movements

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type
Actual To Date	M	TODAY
Actual From Date	M	TODAY
Supplier	O
DU Type	O
Store	O
Manifest Number	O
P/O Number	O

Item Movements 2

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type
DU Type	O
Supplier	O
Actual From Date	M	TODAY
Actual To Date	M	TODAY
P/O Number	O
Store	O
Manifest Number	O

Item Movements 3

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type
P/O Number	O
Store	O
Manifest Number	O
DU Type	O
Supplier	O
Actual To Date	M	TODAY
Actual From Date	M	TODAY

Items Not Scanned By Date

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Items Not Scanned By Trip

Report Name	Filename	Procedure for Scheduling

Parameters:

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

JEYES Interface Results

Report Name	Filename	Procedure for Scheduling

Parameters:

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

KPI By Lane

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Kraft KPI

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type
From Date	M	TODAY
To Date	M	TODAY
Cost Centre	O

LFS Packages

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Lane Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	LOV	Column 1	Column 2
Customer	O
Cost Centre	O
To Loc	O	To Loc	Location Id	Name
From Loc	O	From Loc	Location Id	Name

Left Offs

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Loading Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Loading Schedule CSV

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Location Export

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Location Pre-Warning

Report Name	Filename	Procedure for Scheduling

Parameters:

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

MDD Code 03 Exceptions

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Manual Loaded Items

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Master and Child Locations

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Message Maintenance

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

Missing Lat Long Report

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Missing Steps Report

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	Def Val
To Date	M	TODAY
Missing Step	O	STRING	ALL
From Date	M	TODAY

Month End Accruals

Report Name	Filename	Procedure for Scheduling

Parameters:

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

NR Finance Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

NR Invoice

Report Name	Filename	Procedure for Scheduling

Parameters:

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

OTM Export

Report Name	Filename	Procedure for Scheduling

Parameters:

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

On Time Arrivals

Report Name	Filename	Procedure for Scheduling

Parameters:

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

On Time Drops

Report Name	Filename	Procedure for Scheduling

Parameters:

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

On Time Items

Report Name	Filename	Procedure for Scheduling

Parameters:

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

On Time Items (Assets)

Report Name	Filename	Procedure for Scheduling

Parameters:

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

On Time Returns

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Order Charges Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Order Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Order Interface Results

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Order Items POD Debriefed

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Order Savings

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Order Tracking

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Orders for Relabelling

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Orders to LogiX

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

Orders to Paragon

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Outbound Shortage

Report Name	Filename	Procedure for Scheduling

Parameters:

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

PAYMENT_DTLS

Report Name	Filename	Procedure for Scheduling

Parameters:

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

POC to SAP Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

POC to SAP Extract(A)

Report Name	Filename	Procedure for Scheduling

Parameters:

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

POD Delivery Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

POD Generation Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

POD to SAP Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

POD to SAP Extract(A)

Report Name	Filename	Procedure for Scheduling

Parameters:

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

PORSCHE19 Invoice Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

PROVIDER_REVENUE

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

Parts and Empites

Report Name	Filename	Procedure for Scheduling

Parameters:

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

PostCode Matrix

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Pre Invoice Check

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Process Items Interface Audit

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Provisional Booking Exceptions

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Purchase Order Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Reason Listings

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Receipt Scanning

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Receiving Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Revenue Check (Account)

Report Name	Filename	Procedure for Scheduling

Parameters:

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

SMS Email Summary Report

Report Name	Filename	Procedure for Scheduling

Parameters:

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

STL Trip and Order Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Sales Margin Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Savings Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Schedule

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Schedule Details

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Schedule Trips CS

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Schedule Trips CS

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Scheduled and Cancelled Orders

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Scheduled and Cancelled Orders v2

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

Short Rail Report

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Slot Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Store PVA

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

Store Pre Warning

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Sub Contractor

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Supplier DUs

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Supplier DUs By Store

Report Name	Filename	Procedure for Scheduling

Parameters:

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

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 2

Report Name	Filename	Procedure for Scheduling

Parameters:

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

TYRE SUMMARY EXTRACT

Note: Can be run from Trip Waterfall screen.

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Trip Actuals

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Trip Assessment Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Trip Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Trip and Order Detail Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Trunking Report

Report Name	Filename	Procedure for Scheduling

Parameters:

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

UNISON Interface Results

Report Name	Filename	Procedure for Scheduling

Parameters:

Name	Mand	Def Type	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

Parameters:

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

User Last Logon Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Variance Analysis Store Detail

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Variance Analysis Summary

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Variance Analysis Trip Detail

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Vehicle Utilisation

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Vehicle Utilisation Heavy

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Vehicle Utilisation Non-Heavy

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Volume Deviation Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Volume or Activity

Report Name	Filename	Procedure for Scheduling

Parameters:

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

WCS Order Items Extract

Report Name	Filename	Procedure for Scheduling

Parameters:

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

Weekly Transport Report

Report Name	Filename	Procedure for Scheduling

Parameters:

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

XML Order Interface Export

Report Name	Filename	Procedure for Scheduling

No Parameters

Anonymous

Search

Extracts Details

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)

Depot Exits by Hour (RPEs)