Extracts Details

From CTMS
Revision as of 09:18, 31 July 2025 by Anw (talk | contribs) (Updated parameters and extract names)

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

10.6 Customer By Product Export

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

Parameters:

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

10.6 Customer Location Export

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

Parameters:

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

10.6 Customer Product By Arrival

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

Parameters:

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

10.6 Data Extract

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

Parameters:

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

10.6 Load Status Export

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Status i_status O
Carrier i_carrier O
To Schedule i_to_sched M
Customer i_customer O
From Schedule i_from_sched M

10.6 Matthew Clark Data Extract

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

Parameters:

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

10.6 Planning Export

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

Parameters:

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

10.6 Tokairo Export

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

Parameters:

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

10.6 Warehouse Extract

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

Parameters:

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

1POD Delivery Extract

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

Parameters:

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

AA Trip and Order Detail

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

Parameters:

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

ACC Missing Payments

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

No parameters

ACTIVITY_EXTRACT

Report Name Filename Procedure for Scheduling
ACTIVITY_EXTRACT ACTIVITY_EXTRACT dp_csv3.activity_extract

Parameters:

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

Accruals

Report Name Filename Procedure for Scheduling
Accruals ACCRUALS CSV.ACCRUALS

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Revenue After i_revenue_after O
Revenue Before i_revenue_before O
Customer Group i_cust_group O
Debit Account i_debit_acc O
Credit Account i_credit_acc O

Actual Load

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

Parameters:

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

Actual Unload

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

Parameters:

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

Additional Reporting Requirements

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer Group i_cust_group O
Cost Centre i_cost_centre O
End Schedule i_Sched_To M
Customer i_customer O
Start Schedule i_Sched_From M

Amazon Resources

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

Parameters:

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

Amazon Resources Update

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

Parameters:

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

Approved Price Report

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date i_Start_Date_Time M TODAY
Customer i_customer O
Customer Group i_cust_group O
Cost Centre i_cost_centre O
To Date i_End_Date_Time M TODAY

Asset History

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

Parameters:

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

Asset Status

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

Parameters:

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

Asset Utilisation

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Current Location I_CURRENT_LOCATION O Location Location Location Name
Customer I_CUSTOMER O
To Date I_DATE_TO M TODAY
From Date I_DATE_FROM M TODAY
Vehicle I_VEHICLE O
Route I_ROUTE O
Location I_LOCATION O Location Location Location Name

Assets On Time Delivery

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

Parameters:

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

Automotive Planning Report

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

Parameters:

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

BGW Trip and Order Detail

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

Parameters:

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

BGW_DEBRIEF

Report Name Filename Procedure for Scheduling
BGW_DEBRIEF BGW_DEBRIEF dp_csv3.bgw_debrief

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre P_COST_CENTRE O
From Date P_START_DATETIME M TODAY
To Date P_END_DATETIME M TODAY
Customer P_CUSTOMER O

BMW Asset Dwell

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

Parameters:

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

Backing Sheet

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer i_customer O
Sched To i_end_sched O
Sched From i_start_sched O
Manifest i_booking O

Baxter CSR

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

Parameters:

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

Baxter Download Id Orders

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

Parameters:

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

CARGOWISE Header

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

Parameters:

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

CN Data Extract

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

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

CN Equipment Moves

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date i_date_to M TODAY
Group Name i_group_name O
Customer i_customer O
From Date i_date_from M TODAY

CN Planning Export

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

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

CN Tokairo Export

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

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

CN Trip and Order Detail

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

Parameters:

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

CN Warehouse Loading

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

Parameters:

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

CN Warehouse Extract

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

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

CTM Carrier Responsiveness

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

Parameters:

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

CTM Trips Not Responded To

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

Parameters:

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

Call Collection OTIF Day

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

Parameters:

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

Call Collection OTIF Time Window

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

Parameters:

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

Call Delivery OTIF Day

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

Parameters:

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

Call Delivery OTIF Time Window

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

Parameters:

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

Campus KPI Extract

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

Parameters:

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

Carrier DUs Shipped

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

Parameters:

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

Carrier Delivery Report

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched Name P_SCHED_NAME M
Trip ID P_TRIP O STRING ALL
Carrier P_CARRIER M
Depot P_DEPOT M

Carrier Invoice

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

Parameters:

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

Carrier Self Billing

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

Parameters:

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

Catalyst Extract

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

Parameters:

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

Co-ordinate Non-Conformities

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

Parameters:

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

Commercial

Report Name Filename Procedure for Scheduling
Commercial COMMERCIAL CSV.Commercial_Orders

Parameters:

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

Compliance Report

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

Parameters:

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

Concurrent Logon Export

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

Parameters:

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

Contracts

Report Name Filename Procedure for Scheduling
Contracts CONTRACTS CSV.CONTRACTS

No Parameters

Cross Dock

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule From i_sched_from M
Schedule To i_sched_to M
Customer i_customer O STRING
Media Type i_media_type O STRING
Depot i_depot O STRING
Route i_route O STRING
Dealer i_dealer O STRING

Customer Invoice

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

Parameters:

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

Customer Invoice By Dates

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Payment Status i_act_or_prov O
From Date I_START_DATETIME M
To Date I_END_DATETIME M
Customer I_CUSTOMER M

Customer Invoice Extract

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

Parameters:

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

Cut Offs Extract

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

Parameters:

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

D365 Extract

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

No parameters.

DELIVERY_OVERVIEW

Report Name Filename Procedure for Scheduling
DELIVERY_OVERVIEW DELIVERY_OVERVIEW dp_csv3.delivery_overview

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
POD Confirmed P_POD O
Owning Depot P_OWNING_DEPOT O
To Schedule P_END_SCHED M
From Schedule P_START_SCHED M

DOOD Rpt

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

Parameters:

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

DUs Despatched

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Sched p_start_sched O
PO Number p_external O STRING
Consignment Num p_oms O STRING
End Sched p_end_sched O
Manifest p_manifest O STRING
Supplier p_customer O

DUs Not Loaded

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

Parameters:

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

DUs Not Received

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

Parameters:

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

Daily Manifest E-OT-L

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

Parameters:

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

Daily Receiving E-OT-L

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

Parameters:

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

Daily Transport Plan

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date i_avail_from M
Supplier i_supplier M STRING ALL
To Date i_avail_to M
Order Status i_ord_status M STRING ALL

Daily Unscheduled Orders

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

Parameters:

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

Debrief Performance

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

Parameters:

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

Del Scans

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

Parameters:

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

Delivery Conf

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

Parameters:

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

Delivery Schedule Extract

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

Parameters:

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

Depot Exits by Hour (Loads)

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

Parameters:

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

Depot Exits by Hour (RPEs)

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

Parameters:

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

Detailed Interface Report

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

Parameters:

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

Dixons Catalyst Report

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

Parameters:

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

Dixons Order Export

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

Parameters:

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

Dixons Trip Extract

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

Parameters:

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

Driver Hours

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

Parameters:

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

Driver Scanning

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

Parameters:

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

Dunelm Actual Load

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

Parameters:

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

Dunelm Actual Unload

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

Parameters:

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

Dunelm Backing Sheet

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer i_customer O
Sched To i_end_sched O
Sched From i_start_sched O
Manifest i_booking O

Dunelm DUs Despatched Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
PO Number p_external O STRING
Manifest p_manifest O STRING
Supplier p_customer O
Start Sched p_start_sched O
End Sched p_end_sched O
Consignment Num p_oms O STRING

Dunelm DUs Not Loaded Extract

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

Parameters:

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

Dunelm DUs Not Received

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

Parameters:

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

Dunelm Inventory Transactions

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

Parameters:

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

Dunelm Item Movements 3

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

Parameters:

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

Dunelm Item Movements Extract

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

Parameters:

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

Dunelm Item Movements Extract New

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

Parameters:

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

Dunelm Left Offs

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

Parameters:

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

Dunelm Loading Extract

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

Parameters:

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

Dunelm Manifest E-OT-L Extract

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

Parameters:

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

Dunelm Manual Loaded Items Extract

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

Parameters:

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

Dunelm Receiving Extract

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

Parameters:

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

Dunelm Recieving E-OT-L Extract

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

Parameters:

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

Dunelm Supplier DU Extract

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

Parameters:

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

Dunelm Supplier DU Extract by Store

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

Parameters:

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

Dunelm Supplier Revenue Extract

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

Parameters:

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

Dunelm Supplier Revenue Extract New

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

Parameters:

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

Dunelm Supplier Trends Extract

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

Parameters:

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

Dunelm Transport Plan

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date i_avail_from M
Order Status i_ord_status M STRING ALL
Supplier i_supplier M STRING ALL
To Date i_avail_to M

Dunelm Unsched Orders

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

Parameters:

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

Duplicate Postcodes

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

Parameters:

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

EFX Inbound Errors

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

No parameters.

ERC

Report Name Filename Procedure for Scheduling
ERC ERC DP_CSV_DHL.ERC

Parameters:

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

Equipment Moves

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

Parameters:

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

Extract Lane

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

Parameters:

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

Failed Shipment

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

Parameters:

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

Fixed Routes Extract

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

Parameters:

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

GREENE KING Interface Results

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

Parameters:

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

GYP EFX Export

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

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
HC Booking In Form HC_BOOKING_IN_FORM DP_CSV5.P_HC_BOOKING_IN_FORM

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
HC Haulier Trip Sheet HAULIER_TRIP_SHEET DP_CSV2.HAULIER_TRIP_SHEET

Parameters:

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

HCR Customer Orders

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

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
HCR Loading Sheet CSV HCR_LOADING_SHEET DP_CSV5.HCR_LOADING_SHEET

Parameters:

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

Haulier Invoice

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

Parameters:

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

Heavy Vehicle Utilisation

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

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
IND Trip and Order Detail IND_Trip_Order_Detail_Extract DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT

Parameters:

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

ISC Finance (2) Export

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

Parameters:

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

ISC Finance (3) Export

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

Parameters:

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

ISC Finance (4) Export

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

Parameters:

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

Interface Errors Failures

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

Parameters:

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

Invalid Orders

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

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
Item Movements ITEM_MOVEMENTS_EXTRACT DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT

Parameters:

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

Item Movements 2

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

Parameters:

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

Item Movements 3

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

Parameters:

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

Items Not Scanned By Date

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

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
Items Not Scanned By Trip Items_Not_Scanned DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP

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
JEYES Interface Results JEYES_interface_results CSV.JEYES_if_res

Parameters:

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

Job Notes

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

Parameters:

KPI By Lane

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

Parameters:

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

KPI Extract

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

Parameters:

Kraft KPI

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

Parameters:

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

LFS Packages

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

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
Lane Extract Lane_Extract CSV.LANE_EXPORT

Parameters:

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

Left Offs

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

Parameters:

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

Loading Extract

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

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
Loading Schedule CSV Loading_Schedule CSV.LOADING_SCHEDULE

Parameters:

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

Location Export

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

Parameters:

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

Location Export GL

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

Parameters:

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

Location Export GPR

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

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
Location Pre-Warning Loc_Del_Pre_Warn CSV.Loc_Del_Pre_Warning

Parameters:

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

MDD Code 03 Exceptions

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

Parameters:

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

MTS Finance Export

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

Parameters:

MTS Finance Export V2

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

Parameters:

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:

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
Master and Child Locations Master_and_Child DP_CSV5.MASTER_AND_CHILD

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

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

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:

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
Missing Steps Report Missing_Steps_Report DP_CSV5.Missing_Steps_Report

Parameters:

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

Month End Accruals

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

Parameters:

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

NR Additional Report

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

Parameters:

NR Finance Extract

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

Parameters:

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

NR Invoice

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

Parameters:

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

OPS KPI Extract

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

Parameters:

OPS KPI Extract2

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

Parameters:

OTM Export

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

Parameters:

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

On Time Arrivals

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

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
On Time Drops ON_TIME_DROPS DP_CSV6.ON_TIME_DROPS

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
On Time Items ON_TIME_ITEMS DP_CSV6.ON_TIME_ITEMS

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
On Time Items (Assets) ON_TIME_ITEMS DP_CSV6.ON_TIME_ITEMS_ASSETS

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
On Time Returns ON_TIME_RETURNS DP_CSV6.ON_TIME_RETURNS

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

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 Def Val LOV Column 1 Column 2 Column 3
Customer O
To Date O TODAY
From Date O TODAY
Depot O
Message Type O

Order Items POD Debriefed

Report Name Filename Procedure for Scheduling
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 LOV Column 1 Column 2 Column 3
Customer O STRING OPENFIELD
Month M
Week Offset O
Year M
Cost Centre O STRING OPENFIELDCC

Orders for Relabelling

Report Name Filename Procedure for Scheduling
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 Def Val LOV Column 1 Column 2 Column 3
Schedule To M
Schedule From M
Dealer O STRING
Media Type O STRING
Route O STRING
Depot O STRING
Customer O STRING

PAYMENT_DTLS

Report Name Filename Procedure for Scheduling
PAYMENT_DTLS PAYMENT_DTLS OF_INT.WRITE_PAYMENT_DETAILS

Parameters:

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

POC to SAP Extract

Report Name Filename Procedure for Scheduling
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 Column 3
From Schedule M
To Schedule M
Del Msg Sent O STRING ALL
POD Status O STRING ALL
Carrier O STRING ALL
> Days Outstanding O STRING 0
Group O STRING ALL
Customer O STRING ALL
Scanning Depot O STRING ALL Depot Location Id Name

POD Generation Extract

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

Parameters:

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

POD to SAP Extract

Report Name Filename Procedure for Scheduling
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 LOV Column 1 Column 2 Column 3
Customer M STRING PORSCHE19
Sub Debit Account O STRING ALL
Trip ID O STRING ALL
Sub Credit Account O STRING ALL
Invoice ID O STRING 0
Export ID O STRING 0

PROVIDER_REVENUE

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 LOV Column 1 Column 2 Column 3
Incl. Reprocessed M STRING N
Start Date M TODAY
End Date M TODAY
Record Status M STRING ALL

Provisional Booking Exceptions

Report Name Filename Procedure for Scheduling
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 LOV Column 1 Column 2 Column 3
Status O STRING All
To Date O TODAY TODAY
From Date O TODAY TODAY

Reason Listings

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

Parameters:

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

Receipt Scanning

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

Parameters:

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

Receiving Extract

Report Name Filename Procedure for Scheduling
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 Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
From Date M TODAY
Cost Centre O
Cust Group O
Customer O

SMS Email Summary Report

Report Name Filename Procedure for Scheduling
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 Def Val LOV Column 1 Column 2 Column 3
To Date O TODAY
Credit Acc O
Customer Group O
To Cty Code O
From Cty Code O
Lane Id O
From Date O TODAY
Debit Acc O
Saving (> or <) O STRING

Schedule

Report Name Filename Procedure for Scheduling
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 LOV Column 1 Column 2 Column 3
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 Column 3
Show empty Slots O STRING N
Depot O Depot Location Id Name
Store O Store Location Id Name
Sched Name M

Sub Contractor

Report Name Filename Procedure for Scheduling
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 Def Type Def Val LOV Column 1 Column 2 Column 3
Store O Store Location ID Name
Order Status O
End Schedule M
Start Schedule M

Supplier Invoice

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

Parameters:

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

Supplier Revenue

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 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 Def Val LOV Column 1 Column 2 Column 3
Carrier O
To Date O TODAY
From Date O TODAY

Trip and Order Detail Extract

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

Parameters:

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

Trunking Report

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

Parameters:

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

UNISON Interface Results

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

Parameters:

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

User Activity Extract

Report Name Filename Procedure for Scheduling
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 LOV Column 1 Column 2 Column 3
Carrier O ALL
To Date M TODAY
From Date M TODAY
Schedule O
Cost Centre O ALL
Trip Leg O STRING ALL
Include Unpacked O STRING Y
Deviation O STRING ALL

Volume or Activity

Report Name Filename Procedure for Scheduling
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 Def Val LOV Column 1 Column 2 Column 3
From Date M TODAY
To Date M TODAY
Order O STRING
Trip O STRING

Weekly Transport Report

Report Name Filename Procedure for Scheduling
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

Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/MTS/index.php?title=Extracts_Details&oldid=7946’