Extracts Details: Difference between revisions

From CTMS
(Updated parameters and extract names)
(Updated parameters and extract names)
Line 117: Line 117:
|Cust_Product_By_Arrive
|Cust_Product_By_Arrive
|CSV.Cust_Product_By_Arrive
|CSV.Cust_Product_By_Arrive
|}
Parameters:
{| class="wikitable"
!'''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
|
|
|
|
|
|
|}
|}


Line 129: Line 171:
|CSV.Data_Extract
|CSV.Data_Extract
|}
|}
 
Parameters:
== 10.6 Load Status Export ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Title'''
!'''Filename'''
!'''Name'''
!'''Procedure for Scheduling'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|10.6 Load Status  Export
|Group Name
|Load_Status_Export
|i_group_name
|CSV.Load_Status_Export
|O
|}
|
 
|
== 10.6 Matthew Clark Data Extract ==
|
{| class="wikitable"
|
!'''Report Name'''
|
!'''Filename'''
|
!'''Procedure for Scheduling'''
|-
|-
|10.6 Matthew Clark Data Extract
|From Date
|Matt_Clark_Data_Extract
|i_from_date
|CSV.Matt_Clark_Data_Extract
|M
|}
|TODAY
|
|
|
|
|
|-
|To Date
|i_to_date
|M
|TODAY
|
|
|
|
|
|-
|Customer
|i_customer
|O
|
|
|
|
|
|
|-
|Depot
|i_depot
|O
|
|
|Depot
|Location Id
|Name
|
|}


== 10.6 Planning Export ==
== 10.6 Load Status Export ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 158: Line 240:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|10.6 Planning Export
|10.6 Load Status Export
|Planning_Export
|Load_Status_Export
|CSV.Planning_Export
|CSV.Load_Status_Export
|}
|}
 
Parameters:
== 10.6 Tokairo Export ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Title'''
!'''Filename'''
!'''Name'''
!'''Procedure for Scheduling'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|10.6 Tokairo Export
|Status
|Tokairo_Export
|i_status
|CSV.Tokairo_Export
|O
|}
|
 
|
== 10.6 Warehouse Extract ==
|
{| class="wikitable"
|
!'''Report Name'''
|
!'''Filename'''
|
!'''Procedure for Scheduling'''
|-
|-
|10.6 Warehouse  Extract
|Carrier
|Warehouse_Extract
|i_carrier
|CSV.Warehouse_Extract
|O
|
|
|
|
|
|
|-
|To Schedule
|i_to_sched
|M
|
|
|
|
|
|
|-
|Customer
|i_customer
|O
|
|
|
|
|
|
|-
|From Schedule
|i_from_sched
|M
|
|
|
|
|
|
|}
|}


== 1POD Delivery Extract ==
== 10.6 Matthew Clark Data Extract ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 191: Line 313:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|1POD Delivery Extract
|10.6 Matthew Clark Data Extract
|POD_Delivery_Extract
|Matt_Clark_Data_Extract
|DP_CSV2.POD_DELIVERY_EXTRACT
|CSV.Matt_Clark_Data_Extract
|}
Parameters:
{| class="wikitable"
!'''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
|
|
|
|
|
|
|}
|}


== AA Trip and Order Detail ==
== 10.6 Planning Export ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 202: Line 356:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|AA Trip and Order Detail
|10.6 Planning Export
|AA_Trip_Order_Detail_Extract
|Planning_Export
|CSV.AA_Trip_Order_Detail_Extract
|CSV.Planning_Export
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''
!'''Name'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|Current Depot
|i_current_depot
|M
|
|
|Current  Depot
|Location  Id
|Name
|
|-
|-
|Group Name ||M || || || || || ||
|Group Name
|i_group_name
|O
|
|
|
|
|
|
|-
|-
|Start Schedule ||M || || || || || ||
|From Date
|i_from_date
|M
|TODAY
|
|
|
|
|
|-
|-
|End Schedule ||M || || || || || ||
|To Date
|-
|i_to_date
|Carrier ||O || || || || || ||
|M
|TODAY
|
|
|
|
|
|}
|}


== ACC Missing Payments ==
== 10.6 Tokairo Export ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 227: Line 419:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|ACC Missing  Payments
|10.6 Tokairo Export
|ACC_Missing_Payment
|Tokairo_Export
|DP_CSV_DUN.ACC_MISSING_PAYMENT
|CSV.Tokairo_Export
|}
No parameters
== ACTIVITY_EXTRACT ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|ACTIVITY_EXTRACT
|ACTIVITY_EXTRACT
|dp_csv3.activity_extract
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''
!'''Name'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|To Schedule ||M || || || || || ||
|End Date
|i_to_date
|M
|TODAY
|
|
|
|
|
|-
|-
|Owning Depot ||O || || || || || ||
|Start Date
|-
|i_from_date
|From Schedule ||M || || || || || ||
|M
|TODAY
|
|
|
|
|
|}
|}


==Accruals==
== 10.6 Warehouse Extract ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 259: Line 462:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Accruals
|10.6 Warehouse  Extract
|ACCRUALS
|Warehouse_Extract
|CSV.ACCRUALS
|CSV.Warehouse_Extract
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''
!'''Name'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|Revenue After ||O || || || || || ||
|From Location
|i_from_loc
|M
|
|
|From  Location
|Location  Id
|Name
|
|-
|-
|Revenue Before ||O || || || || || ||
|Owning Depot
|i_depot
|M
|
|
|Depot
|Location  Id
|Name
|
|-
|-
|Customer Group ||O || || || || || ||
|To Date
|i_to_date
|M
|TODAY
|
|
|
|
|
|-
|-
|Debit Account ||O || || || || || ||
|From Date
|-
|i_from_date
|Credit Account ||O || || || || || ||
|M
|TODAY
|
|
|
|
|
|-
|Group Name
|i_group_name
|O
|
|
|
|
|
|
|}
|}


== Actual Load==
== 1POD Delivery Extract ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 284: Line 535:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Actual Load
|1POD Delivery  Extract
|ACTUAL_LOAD_EXTRACT
|POD_Delivery_Extract
|DP_CSV_GEN.DAILY_EXT_LOAD
|DP_CSV2.POD_DELIVERY_EXTRACT
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''
!'''Name'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|> Days Outstanding
|p_outstanding
|O
|STRING
|0
|
|
|
|
|-
|-
|Load Date To ||M || || || || || ||
|Scanning Depot
|p_scan_depot
|O
|STRING
|ALL
|Depot
|Location  Id
|Name
|
|-
|-
|Load Date From ||M || || || || || ||
|POD Status
|}
|p_pod
 
|O
== Actual Unload==
|STRING
{| class="wikitable"
|ALL
!'''Report Name'''
|
!'''Filename'''
|
!'''Procedure for Scheduling'''
|
|
|-
|-
|Actual Unload
|Del Msg Sent
|ACTUAL_UNLOAD_EXTRACT
|p_del_msg_sent
|DP_CSV_GEN.DAILY_EXT_UNLOAD
|O
|}
|STRING
Parameters:
|ALL
{| class="wikitable"
|
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|
|
|
|-
|-
|Load Date To ||M || || || || || ||
|From Schedule
|p_from_date
|M
|
|
|
|
|
|
|-
|-
|Load Date From ||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
|
|
|
|
|}
|}


==Additional Reporting Requirements==
== AA Trip and Order Detail ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 324: Line 648:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Additional Reporting Requirements
|AA Trip and Order Detail
|nr_additional_rep
|AA_Trip_Order_Detail_Extract
|dp_csv_nr.nr_additional_report
|CSV.AA_Trip_Order_Detail_Extract
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''!! '''Name'''!! '''Mand'''!! '''Def Type'''!! '''Def Val'''!! '''LOV'''!! '''Column 1'''!! '''Column 2'''
!'''Column 3'''
|-
|-
|Start Schedule ||M || || || || || ||
|Start Schedule ||P_START_SCHED ||M || || || || ||
|
|-
|-
|End Schedule ||M || || || || || ||
|End Schedule ||P_END_SCHED || M|| || || || ||
|
|-
|-
|Customer Group ||O || || || || || ||
|Carrier ||i_carrier_id || O|| || || || ||
|
|-
|-
|Customer ||O || || || || || ||
|Group Name ||i_group_name || M|| || || || ||
|
|-
|-
|Cost Centre ||O || || || || || ||
|Activity ||i_activity_name || M|| STRING|| Both|| || ||
|
|}
|}


==Amazon Resources==
== ACC Missing Payments ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 349: Line 679:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Amazon Resources
|ACC Missing  Payments
|FMC_BULK_UPLOAD
|ACC_Missing_Payment
|DP_CSV_CSS.AMAZON_RESOURCES
|DP_CSV_DUN.ACC_MISSING_PAYMENT
|}
|}
Parameters:
No parameters
== ACTIVITY_EXTRACT ==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Arrival Time To ||O || || || || || ||
|ACTIVITY_EXTRACT
|-
|ACTIVITY_EXTRACT
|Arrival Time From ||O || || || || || ||
|dp_csv3.activity_extract
|}
 
==Amazon Resources Update==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Amazon Resources  Update
|FMC_UPDATE
|DP_CSV_CSS.AMAZON_RESOURCE_UPDATE
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''!! '''Name'''!! '''Mand'''!! '''Def Type'''!! '''Def Val'''!! '''LOV'''!! '''Column 1'''!! '''Column 2'''
!'''Column 3'''
|-
|-
|Update After (HHMI) ||O || || || || || ||
|From Schedule ||P_START_SCHED || M|| || || || ||
|
|-
|-
|Arrival Time To ||O || || || || || ||
|Owning Depot ||P_OWNING_DEPOT || O|| || || || ||
|
|-
|-
|Arrival Time From ||O || || || || || ||
|To Schedule ||P_END_SCHED || M|| || || || ||
|
|}
|}


==Approved Price Report==
==Accruals==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 389: Line 715:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Approved Price  Report
|Accruals
|approved_price_rep
|ACCRUALS
|dp_csv_nr.approved_price_report
|CSV.ACCRUALS
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''!! '''Name'''!! '''Mand'''!! '''Def Type'''!! '''Def Val'''!! '''LOV'''!! '''Column 1'''!! '''Column 2'''
!'''Column 3'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Revenue After ||i_revenue_after || O|| || || || ||
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Revenue Before ||i_revenue_before || O|| || || || ||
|
|-
|-
|Cost Centre ||O || || || || || ||
|Customer Group ||i_cust_group || O|| || || || ||
|
|-
|-
|Customer Group ||O || || || || || ||
|Debit Account ||i_debit_acc || O|| || || || ||
|
|-
|-
|Customer ||O || || || || || ||
|Credit Account ||i_credit_acc || O|| || || || ||
|
|}
|}


==Asset History==
== Actual Load==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 414: Line 746:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Asset History
|Actual Load
|ASSET_HISTORY
|ACTUAL_LOAD_EXTRACT
|DP_CSV6.ASSET_HISTORY_EXTRACT
|DP_CSV_GEN.DAILY_EXT_LOAD
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Date From ||M ||TODAY || || || || ||
|Load Date From
|i_date_from
|M
|
|
|
|
|
|
|-
|-
|Driver/User ||O ||STRING || || || || ||
|Load Date To
|-
|i_date_to ||M || || || || || ||
|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==
== Actual Unload==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 445: Line 775:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Asset Status
|Actual Unload
|ASSET_STATUS
|ACTUAL_UNLOAD_EXTRACT
|DP_CSV6.ASSET_STATUS
|DP_CSV_GEN.DAILY_EXT_UNLOAD
|}
|}
Parameters:
Parameters:
==Asset Utilisation==
{| class="wikitable"
!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==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 456: Line 797:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Asset Utilisation
|Additional  Reporting Requirements
|ASSET_UTILISATION
|nr_additional_rep
|dp_csv4.asset_utilisation
|dp_csv_nr.nr_additional_report
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Customer ||O || || || || || ||
|Customer Group
|-
|i_cust_group ||O || || || || || ||
|Route ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|End Schedule
|i_Sched_To ||M || || || || || ||
|-
|-
|Vehicle ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Current Location ||O || || ||Location ||Location ||Location Name ||
|Start Schedule
|-
|i_Sched_From ||M || || || || || ||
|Location ||O || || ||Location ||Location ||Location Name ||
|}
|}


==Assets On Time Delivery==
==Amazon Resources==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 485: Line 828:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Assets On Time  Delivery
|Amazon Resources
|ASSET_ON_TIME_DELIV
|FMC_BULK_UPLOAD
|dp_csv4.asset_on_time_deliv
|DP_CSV_CSS.AMAZON_RESOURCES
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Customer ||O || || || || || ||
|Arrival Time To
|-
|i_date_to ||O || || || || || ||
|Location ||O || || ||Location ||Location ||Location Name ||
|-
|-
|Route ||O || || || || || ||
|Arrival Time From
|-
|i_date_from ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|}
|}


==Automotive Planning Report==
==Amazon Resources Update==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 510: Line 850:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Automotive Planning Report
|Amazon Resources Update
|Planning_Report
|FMC_UPDATE
|DP_CSV2.PLANNING_REPORT
|DP_CSV_CSS.AMAZON_RESOURCE_UPDATE
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Start Schedule ||M || || || || || ||
|Arrival Time To
|-
|i_date_to ||O || || || || || ||
|Utilisation > ||O ||STRING ||0 || || || ||
|-
|Utilisation < ||O ||STRING ||999 || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Update After (HHMI)
|i_changed ||O || || || || || ||
|-
|-
|Depot ||M ||STRING ||ALL || || || ||
|Arrival Time From
|-
|i_date_from ||O || || || || || ||
|Level ||M ||STRING ||SUMMARY || || || ||
|}
|}


==BGW Trip and Order Detail==
==Approved Price Report==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 537: Line 875:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|BGW Trip and Order Detail
|Approved Price Report
|BGW_Trip_Order_Detail_Extract
|approved_price_rep
|DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT
|dp_csv_nr.approved_price_report
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Start Schedule ||M || || || || || ||
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|-
|Loaded At ||O || || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|To Date
|-
|i_End_Date_Time ||M || TODAY|| || || || ||
|Group Name ||M || || || || || ||
|}
|}


==BGW_DEBRIEF==
==Asset History==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 564: Line 906:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|BGW_DEBRIEF
|Asset History
|BGW_DEBRIEF
|ASSET_HISTORY
|dp_csv3.bgw_debrief
|DP_CSV6.ASSET_HISTORY_EXTRACT
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Cost Centre ||O || || || || || ||
|Customer
|i_customer ||O ||STRING || ALL|| || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Asset Id
|i_asset_id ||O ||STRING || ALL|| Asset|| Asset ID|| Asset ID||
|-
|Driver/User
|i_action_by ||O ||STRING || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Date To
|i_date_to ||M ||TODAY || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Date From
|i_date_from ||M ||TODAY || || || || ||
|}
|}


==BMW Asset Dwell==
==Asset Status==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 587: Line 937:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|BMW Asset Dwell
|Asset Status
|AUTO_ASSET_DWELL
|ASSET_STATUS
|DP_CSV3.AUTO_AFTERMARKET_BMW
|DP_CSV6.ASSET_STATUS
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Asset Type ||O || || || || || ||
|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==
==Backing Sheet==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 604: Line 961:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Backing Sheet
|Asset Utilisation
|BACKING_SHEET_EXTRACT
|ASSET_UTILISATION
|DP_CSV_GEN.BACKING_SHEET
|dp_csv4.asset_utilisation
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Sched To ||O || || || || || ||
|Current Location
|I_CURRENT_LOCATION ||O || || || Location|| Location|| Location Name||
|-
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|To Date
|I_DATE_TO ||M ||TODAY || || || || ||
|-
|From Date
|I_DATE_FROM ||M ||TODAY || || || || ||
|-
|Vehicle
|I_VEHICLE ||O || || || || || ||
|-
|-
|Manifest ||O || || || || || ||
|Route
|I_ROUTE ||O || || || || || ||
|-
|-
|Sched From ||O || || || || || ||
|Location
|I_LOCATION ||O || || ||Location ||Location ||Location  Name ||
|}
|}


==Baxter CSR==
==Assets On Time Delivery==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 627: Line 998:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Baxter CSR
|Assets On Time  Delivery
|Baxter_csr
|ASSET_ON_TIME_DELIV
|DP_CSV5.BAXTER_CSR
|dp_csv4.asset_on_time_deliv
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Customer ||M ||STRING ||ALL || || || ||
|Route
|I_ROUTE ||O || || || || || ||
|-
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date
|I_DATE_FROM ||M || TODAY|| || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date
|I_DATE_TO ||M ||TODAY || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Location
|I_LOCATION ||O || || || Location|| Location|| Location  Name||
|}
|}


==Baxter Download Id Orders==
==Automotive Planning Report==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 650: Line 1,029:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Baxter Download Id Orders
|Automotive Planning Report
|Baxter Download
|Planning_Report
|DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER
|DP_CSV2.PLANNING_REPORT
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Download Id ||M ||STRING || || || || ||
|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 || || || || || ||
|}
|}


==CARGOWISE Header==
==BGW Trip and Order Detail==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 667: Line 1,063:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|CARGOWISE Header
|BGW Trip and Order  Detail
|CARGOWISE_HEADER
|BGW_Trip_Order_Detail_Extract
|OF_INT.WRITE_CARGOWISE_HEADER
|DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT
|}
|}
Parameters:
Parameters:
==CN Data Extract==
{| class="wikitable"
{{Warning}}Missing
!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==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 679: Line 1,097:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|BGW_DEBRIEF
|
|BGW_DEBRIEF
|
|dp_csv3.bgw_debrief
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|Cost Centre
|P_COST_CENTRE ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date
|P_START_DATETIME ||M ||TODAY || || || || ||
|-
|-
|Customer ||O || || || || || ||
|To Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Customer
|-
|P_CUSTOMER ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
|}


==CN Equipment Moves==
==BMW Asset Dwell==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 704: Line 1,125:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|CN Equipment Moves
|BMW Asset Dwell
|Equip_Move
|AUTO_ASSET_DWELL
|DP_CSV2.CN_EQUIP_MOVE
|DP_CSV3.AUTO_AFTERMARKET_BMW
|}
|}
Parameters:
Parameters:
==CN Planning Export==
{| class="wikitable"
{{Warning}}Missing
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Asset Type
|i_asset_type ||O || || || || || ||
|}
 
==Backing Sheet==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 716: Line 1,144:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Backing Sheet
|
|BACKING_SHEET_EXTRACT
|
|DP_CSV_GEN.BACKING_SHEET
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Group Name ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Current Depot ||M || || ||Current Depot ||Location Id ||Name ||
|Sched To
|i_end_sched ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Sched From
|i_start_sched ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Manifest
|i_booking ||O || || || || || ||
|}
|}


==CN Tokairo Export==
==Baxter CSR==
{{Warning}}Missing
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 740: Line 1,172:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Baxter CSR
|
|Baxter_csr
|
|DP_CSV5.BAXTER_CSR
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|To Date ||M ||TODAY || || || || ||
|Customer
|I_CUSTOMER ||M ||STRING ||ALL || || || ||
|-
|To Date
|I_DATE_TO ||M ||TODAY || || || || ||
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date
|I_DATE_FROM ||M || TODAY|| || || || ||
|}
|}


==CN Trip and Order Detail==
==Baxter Download Id Orders==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 759: Line 1,200:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|CN Trip and Order Detail
|Baxter Download Id Orders
|CN_Trip_Order_Detail_Extract
|Baxter Download
|CSV.CN_Trip_Order_Detail_Extract
|DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|End Schedule ||M || || || || || ||
|Download Id
|-
|P_DOWNLOAD_ID ||M ||STRING || || || || ||
|Start Schedule ||M || || || || || ||
|-
|Loaded At ||O || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|Group Name ||M || || || || || ||
|-
|Activity ||M ||STRING ||Both || || || ||
|}
|}


==CN Warehouse Loading==
==CARGOWISE Header==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 786: Line 1,219:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|CN Warehouse  Loading
|CARGOWISE Header
|CN_Warehouse_Loading
|CARGOWISE_HEADER
|DP_CSV_DHL.p_warehouse_loading
|OF_INT.WRITE_CARGOWISE_HEADER
|}
|}
Parameters:
Parameters:
==CN Warehouse Extract==
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Export_id
|i_exp_id ||M || || || || || ||
|}
==CN Data Extract==
{{Warning}}Missing
{{Warning}}Missing
{| class="wikitable"
{| class="wikitable"
Line 806: Line 1,246:
!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
|-
|-
|From Location ||M || || ||From Location ||Location Id ||Name ||
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Customer ||O || || || || || ||
|-
|Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|Group Name ||O || || || || || ||
|Group Name ||O || || || || || ||
|-
|-
|Trip ID (optional) ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
 
==CN Equipment Moves==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|CN Equipment Moves
|Equip_Move
|DP_CSV2.CN_EQUIP_MOVE
|}
Parameters:
{| class="wikitable"
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|Carrier ||O || || || || || ||
|To Date
|i_date_to
|M
|TODAY
|
|
|
|
|-
|-
|Start Schedule ||M || || || || || ||
|Group Name
|i_group_name
|O
|
|
|
|
|
|-
|-
|End Schedule ||M || || || || || ||
|Customer
|i_customer
|O
|
|
|
|
|
|-
|-
|Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
|From Date
|}
|i_date_from
 
|M
==CTM Carrier Responsiveness==
|TODAY
|
|
|
|
|}
 
==CN Planning Export==
{{Warning}}Missing
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 835: Line 1,322:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|CTM Carrier  Responsiveness
|
|CTM_CARRIER_RESPONSIVENESS
|
|CSV.CTM_CARRIER_RESPONSIVENESS
|
|}
|}
Parameters:
Parameters:
Line 843: Line 1,330:
!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
|-
|-
|Start Schedule ||O || || || || || ||
|Group Name ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Current Depot ||M || || ||Current Depot ||Location Id ||Name ||
|-
|-
|End Schedule ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|End Schedule ||O || || || || || ||
|}
|}


==CTM Trips Not Responded To==
==CN Tokairo Export==
{{Warning}}Missing
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 862: Line 1,346:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|CTM Trips Not  Responded To
|
|CTM_TRIPS_NO_RESPONSE
|
|CSV.CTM_TRIPS_NO_RESPONSE
|
|}
|}
Parameters:
Parameters:
==Call Collection OTIF Day==
{| class="wikitable"
!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==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 873: Line 1,365:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Call Collection OTIF Day
|CN Trip and Order Detail
|coll_OTIF_date_window
|CN_Trip_Order_Detail_Extract
|dp_csv_nr.coll_otif_date_window
|CSV.CN_Trip_Order_Detail_Extract
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Carrier ||O || || || || || ||
|Activity
|i_activity_name ||M || STRING|| Both|| || || ||
|-
|-
|Customer ||O || || || || || ||
|Group Name
|i_group_name ||M || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Start Schedule
|P_START_SCHED ||M || || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|End Schedule
|P_END_SCHED ||M || || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|Carrier
|i_carrier_id ||O || || || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|Loaded At
|-
|i_loaded_at ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|}
|}


==Call Collection OTIF Time Window==
==CN Warehouse Loading==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 904: Line 1,399:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Call Collection OTIF Time Window
|CN Warehouse Loading
|coll_OTIF_window
|CN_Warehouse_Loading
|dp_csv_nr.coll_otif_window
|DP_CSV_DHL.p_warehouse_loading
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Carrier ||O || || || || || ||
|Customer
|i_customer ||O || || || Customer|| CUSTOMER_ID|| CUSTOMER_NAME||
|-
|-
|Customer ||O || || || || || ||
|Depot
|i_depot
|M
|
|
|Depot
|Location  Id
|Name
|
|-
|-
|Customer Group ||O || || || || || ||
|Trip ID (optional)
|i_trip_id
|O
|
|
|
|
|
|
|-
|-
|Product Type ||O || || || || || ||
|Carrier
|-
|i_carrier
|End Schedule ||O || || || || || ||
|O
|
|
|
|
|
|
|-
|-
|Start Schedule ||O || || || || || ||
|End Schedule
|i_end_sched
|M
|
|
|
|
|
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Start Schedule
|-
|i_start_sched
|From Date ||M ||TODAY || || || || ||
|M
|
|
|
|
|
|
|}
|}
 
==CN Warehouse Extract==
==Call Delivery OTIF Day==
{{Warning}}Missing
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 935: Line 1,468:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Call Delivery OTIF  Day
|
|del_OTIF_date_window
|
|dp_csv_nr.del_otif_date_window
|
|}
|}
Parameters:
Parameters:
Line 943: Line 1,476:
!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
|-
|-
|Carrier ||O || || || || || ||
|From Location ||M || || ||From Location ||Location Id ||Name ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
Line 949: Line 1,482:
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|Group Name ||O || || || || || ||
|-
|Trip ID (optional) ||O || || || || || ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|End Schedule ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
|}
|}


==Call Delivery OTIF Time Window==
==CTM Carrier Responsiveness==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 966: Line 1,505:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Call Delivery OTIF Time Window
|CTM Carrier Responsiveness
|del_OTIF_window
|CTM_CARRIER_RESPONSIVENESS
|dp_csv_nr.del_otif_window
|CSV.CTM_CARRIER_RESPONSIVENESS
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|End Schedule ||O || || || || || ||
|Start Schedule
|P_START_SCHED ||O || || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|Carrier
|P_HAULIER ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|End Schedule
|P_END_SCHED ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|
|Start Schedule ||O || || || || || ||
|-
|-
|
|Carrier ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|
|-
|End Schedule ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|Start Schedule ||O || || || || || ||
|}
|}


==Campus KPI Extract==
==CTM Trips Not Responded To==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 997: Line 1,539:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Campus KPI Extract
|CTM Trips Not  Responded To
|Campus_KPI_Extract
|CTM_TRIPS_NO_RESPONSE
|KPI.KPI_CAMPUS_EXTRACT
|CSV.CTM_TRIPS_NO_RESPONSE
|}
|}
Parameters:
Parameters:
==Carrier DUs Shipped==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!Title
!'''Filename'''
!Name
!'''Procedure for Scheduling'''
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|Carrier DUs Shipped
|End Schedule
|CARRIER_DUS_SHIPPED
|P_END_SCHED
|DP_CSV5.CARRIER_DUS_SHIPPED
|O
|}
|
Parameters:
|
{| class="wikitable"
|
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|
|
|
|-
|-
|Carrier ||O ||STRING ||ALL || || || ||
|Start Schedule
|P_START_SCHED
|O
|
|
|
|
|
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Carrier
|-
|P_HAULIER
|From Date ||M ||TODAY || || || || ||
|O
|
|
|
|
|
|
|}
|}


==Carrier Delivery Report==
==Call Collection OTIF Day==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,029: Line 1,592:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier Delivery Report
|Call Collection OTIF Day
|Carrier_Delivery_Report
|coll_OTIF_date_window
|DP_CSV5.CARRIER_DELIVERY
|dp_csv_nr.coll_otif_date_window
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Sched Name ||M || || || || || ||
|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|| || || || ||
|-
|-
|Carrier ||M || || || || || ||
|Start Schedule
|i_Sched_From ||O || || || || || ||
|-
|-
|Depot ||M || || || || || ||
|Product Type
|i_product_type ||O || || || || || ||
|-
|-
|Trip ID ||O ||STRING ||ALL || || || ||
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|Customer
|i_customer ||O || || || || || ||
|}
|}


==Carrier Invoice==
==Call Collection OTIF Time Window==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,052: Line 1,632:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier Invoice
|Call Collection  OTIF Time Window
|Carrier_Invoice
|coll_OTIF_window
|CSV.CARRIER_INVOICE
|dp_csv_nr.coll_otif_window
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Invoice No ||M || || || || || ||
|To Date
|i_End_Date_Time ||M || TODAY|| || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Start Schedule
|i_Sched_From ||O || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|End Schedule
|i_Sched_To ||O || || || || || ||
|-
|-
|Invoice No ||M || || || || || ||
|Product Type
|i_product_type ||O || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|Carrier
|i_carrier ||O || || || || || ||
|-
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|}
|}


==Carrier Self Billing==
==Call Delivery OTIF Day==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,079: Line 1,672:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier Self Billing
|Call Delivery OTIF Day
|Carrier_Self_billing
|del_OTIF_date_window
|DP_CSV_BNL.CARRIER_SELF_BILLING
|dp_csv_nr.del_otif_date_window
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|End Schedule ||M || || || || || ||
|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 || || || || || ||
|-
|-
|Carrier ||0 || || || || || ||
|From Date
|i_Start_Date_Time ||M || TODAY|| || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|To Date
|i_End_Date_Time ||M || TODAY|| || || || ||
|}
|}


==Catalyst Extract==
==Call Delivery OTIF Time Window==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,100: Line 1,712:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Catalyst Extract
|Call Delivery OTIF  Time Window
|CATALYST_EXTRACT
|del_OTIF_window
|CSV.CATALYST_EXTRACT
|dp_csv_nr.del_otif_window
|}
|}
Parameters:
Parameters:
==Co-ordinate Non-Conformities==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!Title
!'''Filename'''
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Procedure for Scheduling'''
|-
|Customer
|i_customer ||O || || || || || ||
|-
|Carrier
|i_carrier ||O || || || || || ||
|-
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|-
|Co-ordinate  Non-Conformities
|Product Type
|Co_Ord_Non_Conf
|i_product_type ||O || || || || || ||
|DP_CSV6.CO_ORD_NON_CONFORM
|}
Parameters:
{| class="wikitable"
!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 || || || ||
|End Schedule
|i_Sched_To ||O || || || || || ||
|-
|-
|Driver ||O || || || || || ||
|Start Schedule
|i_Sched_From ||O || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|To Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|From Date
|i_Start_Date_Time ||M || TODAY|| || || || ||
|}
|}


==Commercial==
==Campus KPI Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,138: Line 1,752:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Commercial
|Campus KPI Extract
|COMMERCIAL
|Campus_KPI_Extract
|CSV.Commercial_Orders
|KPI.KPI_CAMPUS_EXTRACT
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|Schedule ||M || || || || || ||
|From Date
|}
|i_date_from
 
|M
==Compliance Report==
|TODAY
{| class="wikitable"
|
!'''Report Name'''
|
!'''Filename'''
|
!'''Procedure for Scheduling'''
|
|
|-
|-
|Compliance Report
|Carrier
|COMPLIANCE_REPORT
|i_carrier
|DP_CSV_DUN.COMPLIANCE_REPORT
|O
|}
|
Parameters:
|ALL
{| class="wikitable"
|
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|
|
|
|-
|-
|Collection Date ||M || || || || || ||
|Cost Centre
|}
|i_cost_centre
 
|O
==Concurrent Logon Export==
|
{| class="wikitable"
|ALL
!'''Report Name'''
|
!'''Filename'''
|
!'''Procedure for Scheduling'''
|
|
|-
|-
|Concurrent Logon  Export
|Date Range Type
|Concurrent_Logon_Export
|i_date_type
|CSV.Concurrent_Logon
|M
|}
|String
Parameters:
|
{| class="wikitable"
|
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|
|
|
|-
|Depot
|i_depot
|O
|
|ALL
|
|Location  Id
|Name
|
|-
|-
|From Date ||O ||TODAY || || || || ||
|To Date
|i_date_to
|M
|TODAY
|
|
|
|
|
|-
|-
|To Date ||O ||TODAY || || || || ||
|Client
|i_client
|O
|
|ALL
|
|
|
|
|}
|}


== Contracts ==
==Carrier DUs Shipped==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,191: Line 1,845:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Contracts
|Carrier DUs Shipped
|CONTRACTS
|CARRIER_DUS_SHIPPED
|CSV.CONTRACTS
|DP_CSV5.CARRIER_DUS_SHIPPED
|}
Parameters:
{| class="wikitable"
!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 || || || || ||
|}
|}
No Parameters


==Cross Dock==
==Carrier Delivery Report==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,203: Line 1,870:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Cross Dock
|Carrier Delivery  Report
|CROSS_DOCK
|Carrier_Delivery_Report
|DP_CSV6.CROSS_DOCK
|DP_CSV5.CARRIER_DELIVERY
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Media Type ||O ||STRING || || || || ||
|Sched Name
|-
|P_SCHED_NAME ||M || || || || || ||
|Route ||O ||STRING || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Trip ID
|P_TRIP ||O || STRING|| ALL|| || || ||
|-
|-
|Depot ||O ||STRING || || || || ||
|Carrier
|P_CARRIER ||M || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Depot
|-
|P_DEPOT ||M || || || || || ||
|Customer ||O ||STRING || || || || ||
|}
|}


==Customer Invoice==
==Carrier Invoice==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,232: Line 1,898:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Customer Invoice
|Carrier Invoice
|Customer_Invoice
|Carrier_Invoice
|CSV.Customer_Invoice
|CSV.CARRIER_INVOICE
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Invoice No ||M || || || || || ||
|Invoice No
|-
|I_INVOICE_NO ||M || || || || || ||
|Credit Acc ||M || || || || || ||
|-
|Debit Acc ||M || || || || || ||
|-
|Invoice No ||M || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|Credit Acc
|I_CREDIT_ACC ||M || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Debit Acc
|I_DEBIT_ACC ||M || || || || || ||
|}
|}


==Customer Invoice By Dates==
==Carrier Self Billing==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,259: Line 1,923:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Customer Invoice By Dates
|Carrier Self Billing
|Customer_Invoice_By_Dates
|Carrier_Self_billing
|CSV.Customer_Invoice_By_Dates
|DP_CSV_BNL.CARRIER_SELF_BILLING
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Payment Status ||O || || || || || ||
|Start Schedule
|i_start_sched ||M || || || || || ||
|-
|-
|Customer ||M || || || || || ||
|Carrier
|i_carrier ||0 || || || || || ||
|-
|-
|From Date ||M || || || || || ||
|End Schedule
|-
|i_end_sched ||M || || || || || ||
|To Date ||M || || || || || ||
|}
|}


==Customer Invoice Extract==
==Catalyst Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,282: Line 1,948:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Customer Invoice  Extract
|Catalyst Extract
|Customer_Invoice
|CATALYST_EXTRACT
|CSV.Customer_Invoice
|CSV.CATALYST_EXTRACT
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|Invoice No ||M || || || || || ||
|End Schedule
|P_END_SCHED
|M
|
|
|
|
|
|
|-
|-
|Credit Acc ||M || || || || || ||
|Start Schedule
|-
|P_START_SCHED
|Debit Acc ||M || || || || || ||
|M
|
|
|
|
|
|
|}
|}


==Cut Offs Extract==
==Co-ordinate Non-Conformities==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,303: Line 1,991:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Cut Offs Extract
|Co-ordinate  Non-Conformities
|Cut_offs_extract
|Co_Ord_Non_Conf
|DP_CSV6.CUT_OFF_EXTRACT
|DP_CSV6.CO_ORD_NON_CONFORM
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|End Schedule ||M || || || || || ||
|Start Schedule
|i_sched_from ||M || || || || || ||
|-
|End Schedule
|i_sched_to ||M || || || || || ||
|-
|Driver
|i_driver ||O || || || || || ||
|-
|TomTom,Epod,Both
|i_inc ||M || || B|| || || ||
|-
|-
|Customer ||0 || || || || || ||
|Discrepancy Dist
|i_disc_dist ||0 || || 1|| || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Depot
|i_depot ||O || || || || || ||
|}
|}


==D365 Extract==
==Commercial==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,324: Line 2,025:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|D365 Extract
|Commercial
|DP_FINANCE.D365_EXPORT
|COMMERCIAL
|D365_EXPORT_
|CSV.Commercial_Orders
|}
|}
Parameters:
Parameters:
==DELIVERY_OVERVIEW==
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|I_SCHEDULE ||M || || || || || ||
|}
 
==Compliance Report==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,335: Line 2,044:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|DELIVERY_OVERVIEW
|Compliance Report
|DELIVERY_OVERVIEW
|COMPLIANCE_REPORT
|dp_csv3.delivery_overview
|DP_CSV_DUN.COMPLIANCE_REPORT
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|From Schedule ||M || || || || || ||
|Collection Date
|-
|P_COL_DATE ||M || || || || || ||
|To Schedule ||M || || || || || ||
|-
|Owning Depot ||O || || || || || ||
|-
|POD Confirmed ||O || || || || || ||
|}
|}


==DOOD Rpt==
==Concurrent Logon Export==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,358: Line 2,063:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|DOOD Rpt
|Concurrent Logon  Export
|DOOD_RPT
|Concurrent_Logon_Export
|dp_csv_dood.dood_rpt
|CSV.Concurrent_Logon
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Schedule To ||M || || || || || ||
|From Date
|i_from_date ||O ||TODAY || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|To Date
|i_to_date ||O ||TODAY || || || || ||
|}
 
== Contracts ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O ||STRING ||OPENFIELD || || || ||
|Contracts
|CONTRACTS
|CSV.CONTRACTS
|}
|}
No Parameters


==DUs Despatched==
==Cross Dock==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,379: Line 2,097:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|DUs Despatched
|Cross Dock
|DUS_DESPATCHED_EXTRACT
|CROSS_DOCK
|DP_CSV_GEN.DUS_DESPATCHED_EXTRACT
|DP_CSV6.CROSS_DOCK
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Consignment Num ||O ||STRING || || || || ||
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|-
|Start Sched ||O || || || || || ||
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|-
|Manifest ||O ||STRING || || || || ||
|Customer
|i_customer ||O || STRING|| || || || ||
|-
|-
|PO Number ||O ||STRING || || || || ||
|Media Type
|i_media_type ||O ||STRING || || || || ||
|-
|Depot
|i_depot ||O ||STRING || || || || ||
|-
|-
|Supplier ||O || || || || || ||
|Route
|i_route ||O || STRING|| || || || ||
|-
|-
|End Sched ||O || || || || || ||
|Dealer
|i_dealer ||O ||STRING || || || || ||
|}
|}


==DUs Not Loaded==
==Customer Invoice==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,406: Line 2,134:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|DUs Not Loaded
|Customer Invoice
|DUS_NOT_LOADED_EXTRACT
|Customer_Invoice
|DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT
|CSV.Customer_Invoice
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Store ||O || || ||Store ||Location ID ||Name ||
|Invoice No
|I_INVOICE_NO ||M || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Credit Acc
|I_CREDIT_ACC ||M || || || || || ||
|-
|Debit Acc
|I_DEBIT_ACC ||M || || || || || ||
|}
|}


== DUs Not Received ==
==Customer Invoice By Dates==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,425: Line 2,159:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|DUs Not Received
|Customer Invoice By  Dates
|DUS_NOT_RECEIVED_EXTRACT
|Customer_Invoice_By_Dates
|DP_CSV_GEN.DAILY_EXT_NOT_RECD
|CSV.Customer_Invoice_By_Dates
|}
|}
Parameters:
Parameters:
 
{| class="wikitable"
!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 ||M || || || || || ||
|To Date
|I_END_DATETIME ||M || || || || || ||
|-
|-
|From Date ||M || || || || || ||
|Customer
|I_CUSTOMER ||M || || || || || ||
|}
|}


==Daily Manifest E-OT-L==
==Customer Invoice Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Customer Invoice  Extract
|Customer_Invoice
|CSV.Customer_Invoice
|}
Parameters:
{| class="wikitable"
!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==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 1,443: Line 2,212:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Daily Manifest  E-OT-L
|Cut Offs Extract
|DAILY_MANIFEST_E_OT_L_EXTRACT
|Cut_offs_extract
|DP_CSV6.CUT_OFF_EXTRACT
|}
Parameters:
{| class="wikitable"
!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==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|D365 Extract
|DP_FINANCE.D365_EXPORT
|D365_EXPORT_
|}
No parameters.
==DELIVERY_OVERVIEW==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DELIVERY_OVERVIEW
|DELIVERY_OVERVIEW
|dp_csv3.delivery_overview
|}
Parameters:
{| class="wikitable"
!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==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DOOD Rpt
|DOOD_RPT
|dp_csv_dood.dood_rpt
|}
Parameters:
{| class="wikitable"
!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==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DUs Despatched
|DUS_DESPATCHED_EXTRACT
|DP_CSV_GEN.DUS_DESPATCHED_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!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==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DUs Not Loaded
|DUS_NOT_LOADED_EXTRACT
|DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT
|}
Parameters:
{| class="wikitable"
!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 ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DUs Not Received
|DUS_NOT_RECEIVED_EXTRACT
|DP_CSV_GEN.DAILY_EXT_NOT_RECD
|}
Parameters:
{| class="wikitable"
!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==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Daily Manifest  E-OT-L
|DAILY_MANIFEST_E_OT_L_EXTRACT
|DP_CSV_GEN.DAILY_EXT_MANIFEST
|DP_CSV_GEN.DAILY_EXT_MANIFEST
|}
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Title
|-
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|From Date ||M || || || || || ||
|-
|-
|To Date
|To Date ||M || || || || || ||
|i_avail_to ||M || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|From Date
|-
|i_avail_from ||M || || || || || ||
|Start Schedule ||M || || || || || ||
|}
|}
 
 
==Daily Receiving E-OT-L==
==Daily Receiving E-OT-L==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
!'''Filename'''
!'''Filename'''
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|Daily Receiving  E-OT-L
|Daily Receiving  E-OT-L
|RECEIVING_E_OT_L_EXTRACT
|RECEIVING_E_OT_L_EXTRACT
|DP_CSV_GEN.DAILY_EXT_RECEIPTING
|DP_CSV_GEN.DAILY_EXT_RECEIPTING
|}
|}
Parameters:
Parameters:
{| class="wikitable"
!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==
==Daily Transport Plan==
{| class="wikitable"
{| class="wikitable"
Line 1,483: Line 2,442:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Order Status ||M ||STRING ||ALL || || || ||
|From Date
|i_avail_from ||M || || || || || ||
|-
|-
|Supplier ||M ||STRING ||ALL || || || ||
|Supplier
|i_supplier ||M ||STRING ||ALL || || || ||
|-
|-
|To Date ||M || || || || || ||
|To Date
|i_avail_to ||M || || || || || ||
|-
|-
|From Date ||M || || || || || ||
|Order Status
|i_ord_status ||M || STRING|| ALL|| || || ||
|}
|}


Line 1,506: Line 2,470:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|To Date ||M || || || || || ||
|From Date
|i_avail_from ||M || || || || || ||
|-
|-
|From Date ||M || || || || || ||
|To Date
|i_avail_to ||M || || || || || ||
|}
|}


Line 1,525: Line 2,492:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Carrier Code ||O || || || || || ||
|Cust Group
|i_cust_group ||O || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Carrier Group
|i_carrier_group ||O || || || || || ||
|-
|-
|Cust Group ||O || || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|From Date
|i_Start_Date_Time ||M || TODAY|| || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Carrier Code
|i_carrier_code ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|}
|}


Line 1,554: Line 2,529:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|End Schedule ||M || || || || || ||
|End Schedule
|i_end_sched ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Start Schedule
|i_start_sched ||M || || || || || ||
|}
|}


Line 1,573: Line 2,551:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Type ||M || ||M || || || ||
|Owning Depot
|p_own ||O || || || || || ||
|-
|-
|Owning Depot ||O || || || || || ||
|Cost Centre
|p_cost ||M || || || || || ||
|-
|-
|Cost Centre ||M || || || || || ||
|To Actual date
|p_to_date ||M || TODAY|| || || || ||
|-
|-
|To Actual date ||M ||TODAY || || || || ||
|Type
|p_type ||M || || M|| || || ||
|-
|-
|From Actual date ||M ||TODAY || || || || ||
|From Actual date
|p_from_date ||M ||TODAY || || || || ||
|}
|}


Line 1,598: Line 2,582:
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Title
!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
|-
|-
|Show Dates ||Y || || || || || ||
|Show Dates
|P_DATE_SELECT ||Y || || || || || ||
|}
|}



Revision as of 09:52, 31 July 2025

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

10.6 Customer By Product Export

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

Parameters:

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

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

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:

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

Dixons Trip Extract

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

Dunelm DUs Despatched Extract

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

Parameters:

Dunelm DUs Not Loaded Extract

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

Parameters:

Dunelm DUs Not Received

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

Parameters:

Dunelm Inventory Transactions

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

Parameters:

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

Dunelm Item Movements Extract

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

Parameters:

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

Dunelm Item Movements Extract New

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

Parameters:

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

Dunelm Loading Extract

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

Parameters:

Dunelm Manifest E-OT-L Extract

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

Parameters:

Dunelm Manual Loaded Items Extract

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

Parameters:

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

Dunelm Receiving Extract

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

Parameters:

Dunelm Recieving E-OT-L Extract

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

Parameters:

Dunelm Supplier DU Extract

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

Parameters:

Dunelm Supplier DU Extract by Store

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

Parameters:

Dunelm Supplier Revenue Extract

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

Parameters:

Dunelm Supplier Revenue Extract New

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

Parameters:

Dunelm Supplier Trends Extract

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

Parameters:

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

Dunelm Transport Plan

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

Parameters:

Dunelm Unsched Orders

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

Parameters:

Duplicate Postcodes

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

Parameters:

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

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