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
|
| 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
|
| 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
|
| Report Name
|
Filename
|
Procedure for Scheduling
|
| 10.6 Warehouse Extract
|
Warehouse_Extract
|
CSV.Warehouse_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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
|
|
|
|
|
| Report Name
|
Filename
|
Procedure for Scheduling
|
| CARGOWISE Header
|
CARGOWISE_HEADER
|
OF_INT.WRITE_CARGOWISE_HEADER
|
Parameters:
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:
CN Planning Export
Warning: Missing
| Report Name
|
Filename
|
Procedure for Scheduling
|
|
|
|
|
Parameters:
| Name |
Mand |
Def Type |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| Group Name |
O |
|
|
|
|
|
|
| Current Depot |
M |
|
|
Current Depot |
Location Id |
Name |
|
| To Date |
M |
TODAY |
|
|
|
|
|
| From Date |
M |
TODAY |
|
|
|
|
|
CN Tokairo Export
Warning: Missing
| Report Name
|
Filename
|
Procedure for Scheduling
|
|
|
|
|
Parameters:
| Name |
Mand |
Def Type |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| To Date |
M |
TODAY |
|
|
|
|
|
| From Date |
M |
TODAY |
|
|
|
|
|
CN Trip and Order Detail
| Report Name
|
Filename
|
Procedure for Scheduling
|
| CN Trip and Order Detail
|
CN_Trip_Order_Detail_Extract
|
CSV.CN_Trip_Order_Detail_Extract
|
Parameters:
| Name |
Mand |
Def Type |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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:
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:
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| End Schedule |
O |
|
|
|
|
|
|
| Product Type |
O |
|
|
|
|
|
|
| Customer Group |
O |
|
|
|
|
|
|
| Customer |
O |
|
|
|
|
|
|
| Carrier |
O |
|
|
|
|
|
|
| From Date |
M |
TODAY |
|
|
|
|
|
| To Date |
M |
TODAY |
|
|
|
|
|
| Start Schedule |
O |
|
|
|
|
|
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
|
|
|
|
|
|
| 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 Type |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| Type |
M |
|
M |
|
|
|
|
| Owning Depot |
O |
|
|
|
|
|
|
| Cost Centre |
M |
|
|
|
|
|
|
| To Actual date |
M |
TODAY |
|
|
|
|
|
| From Actual date |
M |
TODAY |
|
|
|
|
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Type |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| From Date |
O |
TODAY |
|
|
|
|
|
| Carrier |
O |
|
|
|
|
|
|
| To Date |
O |
TODAY |
|
|
|
|
|
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dixons Trip Extract
|
Dixons_Trip_Extract
|
CSV.Dixons_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 |
|
|
|
|
|
Driver Hours
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Driver Hours
|
driver_hours
|
dp_csv_nr.driver_hours
|
Parameters:
| Name |
Mand |
Def Type |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
|
|
|
|
|
|
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm DUs Despatched Extract
|
DUNELM_DUS_DESPATCHED_EXTRACT
|
DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT
|
Parameters:
| 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 |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| Manifest Number |
O |
|
|
|
|
|
|
| Actual To Date |
M |
TODAY |
|
|
|
|
|
| Actual From Date |
M |
TODAY |
|
|
|
|
|
| DU Type |
O |
|
|
|
|
|
|
| Supplier |
O |
|
|
|
|
|
|
| P/O Number |
O |
|
|
|
|
|
|
| Store |
O |
|
|
|
|
|
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
|
|
|
|
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Column 3
|
| Trip Id (Optional) |
O |
|
|
|
|
|
|
| Days Back |
M |
STRING |
30 |
|
|
|
|
| Store (Optional) |
O |
|
|
Store |
Location Id |
Name |
|
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Loading Extract
|
DUNELM_LOADING_EXTRACT
|
DP_CSV2.DUN_LOADING
|
Parameters:
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Manifest E-OT-L Extract
|
DUNELM_MANIFESTED_EOL
|
DP_CSV_DUN.daily_ext_manifest
|
Parameters:
| 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 |
|
|
|
|
|
|
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Receiving Extract
|
DUNELM_RECEIVING_EXTRACT
|
DP_CSV2.DUN_RECEIVING
|
Parameters:
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Recieving E-OT-L Extract
|
DUNELM_RECEIPTED_EOL
|
DP_CSV_DUN.daily_ext_receipting
|
Parameters:
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Supplier DU Extract
|
DUNELM_SUPPLIER_DU_EXTRACT
|
DP_CSV2.DUN_SUPPLIER_DU_EXTRACT
|
Parameters:
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Supplier DU Extract by Store
|
DUNELM_DU_STORE_EXTRACT
|
DP_CSV2.DUN_DU_STORE_EXTRACT
|
Parameters:
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Supplier Revenue Extract
|
DUNELM_SUPPLIER_REVENUE_EXTRACT
|
DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT
|
Parameters:
| Report Name
|
Filename
|
Procedure for Scheduling
|
| Dunelm Supplier Revenue Extract New
|
DUNELM_SUPPLIER_REVENUE_NEW
|
DP_CSV2.DUN_SUPPLIER_REVENUE_NEW
|
Parameters:
| 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 |
Def Type |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| 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 |
Def Val |
LOV |
Column 1 |
Column 2 |
Column 3
|
| Owning Depot |
O |
|
|
|
|
|
|
| Customer |
O |
|
|
|
|
|
|
| To Date |
M |
TODAY |
|
|
|
|
|
| From Date |
M |
TODAY |
|
|
|
|
|
| Carrier |
O |
|
|
|
|
|
|
| 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 |
|
|
|
|
| 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: 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 |
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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:
| 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 |
|
|
|
|
|
|
| Report Name
|
Filename
|
Procedure for Scheduling
|
| OPS KPI Extract
|
OPS_KPI_Extract
|
KPI.KPI_OPS_EXTRACT
|
Parameters:
| 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:
| 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 |
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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
|
| 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:
| 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 |
|
| 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 |
|
|
|
|
|
|
| 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
|
| 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 |
|
|
|
|
| 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 |
|
|
|
|
|
| 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 |
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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 |
|
|
|
|
|
| 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 |
|
|
|
|
|
| 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 |
|
|
|
|
|
|
| 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:
| 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
