Extracts Details: Difference between revisions

From CTMS
(Initial Creation)
 
(Added details of Receiving extract)
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
This is a full list of all extracts in the system.
This is a full list of all extracts in the system.


==AA Trip and Order Detail==
== 10.6 Customer By Product Export ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
!
|-
|10.6 Customer By  Product Export
|Cust_By_Product
| colspan="2" |CSV.Cust_By_Product
|}
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 || || || ||
|Customer
|i_customer
|M
|
|
|
|
|
|
|-
|-
|Group Name ||M || || || || || ||
|To Schedule
|i_to_sched
|M
|
|
|
|
|
|
|-
|-
|Start Schedule ||M || || || || || ||
|From Schedule
|i_from_sched
|M
|
|
|
|
|
|
|}
 
== 10.6 Customer Location Export ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|10.6 Customer  Location Export
|-
|Customer_Location
|Carrier ||O || || || || || ||
|CSV.Customer_Location
|}
|}
== ACC Missing Payments ==
No parameters
== 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 || || || || || ||
|Customer
|i_customer
|M
|
|
|
|
|
|
|-
|-
|Owning Depot ||O || || || || || ||
|To Schedule
|i_to_sched
|M
|
|
|
|
|
|
|-
|-
|From Schedule ||M || || || || || ||
|From Schedule
|i_from_sched
|M
|
|
|
|
|
|
|}
|}


==Accruals==
== 10.6 Customer Product By Arrival ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|10.6 Customer  Product By Arrival
|Cust_Product_By_Arrive
|CSV.Cust_Product_By_Arrive
|}
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 || || || || || ||
|To Schedule
|i_to_sched
|M
|
|
|
|
|
|
|-
|-
|Revenue Before ||O || || || || || ||
|From Schedule
|i_from_sched
|M
|
|
|
|
|
|
|-
|-
|Customer Group ||O || || || || || ||
|Customer
|-
|i_customer
|Debit Account ||O || || || || || ||
|M
|
|
|
|
|
|
|}
 
== 10.6 Data Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Credit Account ||O || || || || || ||
|10.6 Data Extract
|Data_Extract
|CSV.Data_Extract
|}
|}
== Actual Load==
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'''
|-
|Group Name
|i_group_name
|O
|
|
|
|
|
|
|-
|From Date
|i_from_date
|M
|TODAY
|
|
|
|
|
|-
|-
|!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|To Date
|i_to_date
|M
|TODAY
|
|
|
|
|
|-
|-
|Load Date To ||M || || || || || ||
|Customer
|i_customer
|O
|
|
|
|
|
|
|-
|-
|Load Date From ||M || || || || || ||
|Depot
|i_depot
|O
|
|
|Depot
|Location  Id
|Name
|
|}
|}


== Actual Unload==
== 10.6 Load Status Export ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Load Date To ||M || || || || || ||
|10.6 Load Status  Export
|-
|Load_Status_Export
|Load Date From ||M || || || || || ||
|CSV.Load_Status_Export
|}
|}
==Additional Reporting Requirements==
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 || || || || || ||
|Status
|i_status
|O
|
|
|
|
|
|
|-
|-
|End Schedule ||M || || || || || ||
|Carrier
|i_carrier
|O
|
|
|
|
|
|
|-
|-
|Customer Group ||O || || || || || ||
|To Schedule
|i_to_sched
|M
|
|
|
|
|
|
|-
|-
|Customer ||O || || || || || ||
|Customer
|i_customer
|O
|
|
|
|
|
|
|-
|-
|Cost Centre ||O || || || || || ||
|From Schedule
|i_from_sched
|M
|
|
|
|
|
|
|}
|}


==Amazon Resources==
== 10.6 Matthew Clark Data Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|10.6 Matthew Clark  Data Extract
|Matt_Clark_Data_Extract
|CSV.Matt_Clark_Data_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'''
|-
|-
|Arrival Time To ||O || || || || || ||
|To Schedule
|i_to_sched
|M
|
|
|
|
|
|
|-
|-
|Arrival Time From ||O || || || || || ||
|From Schedule
|i_from_sched
|M
|
|
|
|
|
|
|}
|}


==Amazon Resources Update==
== 10.6 Planning Export ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Update After (HHMI) ||O || || || || || ||
!'''Procedure for Scheduling'''
|-
|Arrival Time To ||O || || || || || ||
|-
|-
|Arrival Time From ||O || || || || || ||
|10.6 Planning  Export
|Planning_Export
|CSV.Planning_Export
|}
|}
==Approved Price Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Title'''
|-
!'''Name'''
|From Date ||M ||TODAY || || || || ||
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|To Date ||M ||TODAY || || || || ||
|Current Depot
|i_current_depot
|M
|
|
|Current  Depot
|Location  Id
|Name
|
|-
|-
|Cost Centre ||O || || || || || ||
|Group Name
|i_group_name
|O
|
|
|
|
|
|
|-
|-
|Customer Group ||O || || || || || ||
|From Date
|i_from_date
|M
|TODAY
|
|
|
|
|
|-
|-
|Customer ||O || || || || || ||
|To Date
|i_to_date
|M
|TODAY
|
|
|
|
|
|}
|}


==Asset History==
== 10.6 Tokairo Export ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Date From ||M ||TODAY || || || || ||
|10.6 Tokairo Export
|Tokairo_Export
|CSV.Tokairo_Export
|}
Parameters:
{| class="wikitable"
!'''Title'''
!'''Name'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|Driver/User ||O ||STRING || || || || ||
|End Date
|i_to_date
|M
|TODAY
|
|
|
|
|
|-
|-
|Asset Id ||O ||STRING ||ALL ||Asset ||Asset ID ||Asset ID ||
|Start Date
|i_from_date
|M
|TODAY
|
|
|
|
|
|}
 
== 10.6 Warehouse Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Date To ||M ||TODAY || || || || ||
|10.6 Warehouse  Extract
|Warehouse_Extract
|CSV.Warehouse_Extract
|}
Parameters:
{| class="wikitable"
!'''Title'''
!'''Name'''
!'''Mand'''
!'''Def Type'''
!'''Def Val'''
!'''LOV'''
!'''Column 1'''
!'''Column 2'''
!'''Column 3'''
|-
|-
|Customer ||O ||STRING ||ALL || || || ||
|From Location
|i_from_loc
|M
|
|
|From  Location
|Location  Id
|Name
|
|-
|-
|Asset Id ||O ||STRING ||ALL ||Asset ||Asset ID ||Asset ID ||
|Owning Depot
|i_depot
|M
|
|
|Depot
|Location  Id
|Name
|
|-
|-
|Last Scan Location ||O ||STRING ||ALL ||Last Scan Location ||Location ID ||Name ||
|To Date
|i_to_date
|M
|TODAY
|
|
|
|
|
|-
|-
|Customer ||O ||STRING ||ALL || || || ||
|From Date
|i_from_date
|M
|TODAY
|
|
|
|
|
|-
|Group Name
|i_group_name
|O
|
|
|
|
|
|
|}
|}


==Asset Utilisation==
== 1POD Delivery Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|1POD Delivery  Extract
|POD_Delivery_Extract
|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'''
|-
|> Days Outstanding
|p_outstanding
|O
|STRING
|0
|
|
|
|
|-
|Scanning Depot
|p_scan_depot
|O
|STRING
|ALL
|Depot
|Location  Id
|Name
|
|-
|-
|Customer ||O || || || || || ||
|POD Status
|p_pod
|O
|STRING
|ALL
|
|
|
|
|-
|-
|Route ||O || || || || || ||
|Del Msg Sent
|p_del_msg_sent
|O
|STRING
|ALL
|
|
|
|
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Schedule
|p_from_date
|M
|
|
|
|
|
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Customer
|p_customer
|O
|STRING
|ALL
|
|
|
|
|-
|-
|Vehicle ||O || || || || || ||
|Group
|p_group_name
|O
|STRING
|ALL
|
|
|
|
|-
|-
|Current Location ||O || || ||Location ||Location ||Location Name ||
|To Schedule
|p_to_date
|M
|
|
|
|
|
|
|-
|-
|Location ||O || || ||Location ||Location ||Location Name ||
|Carrier
|p_carrier
|O
|STRING
|ALL
|
|
|
|
|}
|}


==Assets On Time Delivery==
== AA Trip and Order Detail ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|AA Trip and Order  Detail
|AA_Trip_Order_Detail_Extract
|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'''
|-
|-
|Customer ||O || || || || || ||
|Start Schedule ||P_START_SCHED ||M || || || || ||
|
|-
|-
|Location ||O || || ||Location ||Location ||Location Name ||
|End Schedule ||P_END_SCHED || M|| || || || ||
|
|-
|-
|Route ||O || || || || || ||
|Carrier ||i_carrier_id || O|| || || || ||
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Group Name ||i_group_name || M|| || || || ||
|
|-
|-
|From Date ||M ||TODAY || || || || ||
|Activity ||i_activity_name || M|| STRING|| Both|| || ||
|
|}
|}


==Automotive Planning Report==
== ACC Missing Payments ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|ACC Missing  Payments
|ACC_Missing_Payment
|DP_CSV_DUN.ACC_MISSING_PAYMENT
|}
No parameters
== ACTIVITY_EXTRACT ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Utilisation > ||O ||STRING ||0 || || || ||
|ACTIVITY_EXTRACT
|ACTIVITY_EXTRACT
|dp_csv3.activity_extract
|}
Parameters:
{| class="wikitable"
!'''Title'''!! '''Name'''!! '''Mand'''!! '''Def Type'''!! '''Def Val'''!! '''LOV'''!! '''Column 1'''!! '''Column 2'''
!'''Column 3'''
|-
|-
|Utilisation < ||O ||STRING ||999 || || || ||
|From Schedule ||P_START_SCHED || M|| || || || ||
|
|-
|-
|End Schedule ||M || || || || || ||
|Owning Depot ||P_OWNING_DEPOT || O|| || || || ||
|
|-
|-
|Depot ||M ||STRING ||ALL || || || ||
|To Schedule ||P_END_SCHED || M|| || || || ||
|
|}
 
==Accruals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Level ||M ||STRING ||SUMMARY || || || ||
|Accruals
|ACCRUALS
|CSV.ACCRUALS
|}
|}
==BGW Trip and Order Detail==
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 || || || || || ||
|Revenue After ||i_revenue_after || O|| || || || ||
|
|-
|-
|End Schedule ||M || || || || || ||
|Revenue Before ||i_revenue_before || O|| || || || ||
|
|-
|-
|Carrier ||O || || || || || ||
|Customer Group ||i_cust_group || O|| || || || ||
|
|-
|-
|Loaded At ||O || || || || || ||
|Debit Account ||i_debit_acc || O|| || || || ||
|
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|Credit Account ||i_credit_acc || O|| || || || ||
|
|}
 
== Actual Load==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group Name ||M || || || || || ||
|Actual Load
|ACTUAL_LOAD_EXTRACT
|DP_CSV_GEN.DAILY_EXT_LOAD
|}
|}
==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
|-
|-
|Cost Centre ||O || || || || || ||
|Load Date From
|i_date_from
|M
|
|
|
|
|
|
|-
|-
|From Date ||M ||TODAY || || || || ||
|Load Date To
|-
|i_date_to ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
 
== Actual Unload==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|Actual Unload
|ACTUAL_UNLOAD_EXTRACT
|DP_CSV_GEN.DAILY_EXT_UNLOAD
|}
|}
==BMW Asset Dwell==
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 || || || || || ||
|Load Date From
|i_date_from ||M || || || || || ||
|-
|Load Date To
|i_date_to ||M || || || || || ||
|}
|}


==Backing Sheet==
==Additional Reporting Requirements==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Additional  Reporting Requirements
|nr_additional_rep
|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
|-
|-
|Sched To ||O || || || || || ||
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|End Schedule
|i_Sched_To ||M || || || || || ||
|-
|-
|Manifest ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Sched From ||O || || || || || ||
|Start Schedule
|i_Sched_From ||M || || || || || ||
|}
|}


==Baxter CSR==
==Amazon Resources==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Amazon Resources
|FMC_BULK_UPLOAD
|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 ||M ||STRING ||ALL || || || ||
|Arrival Time To
|i_date_to ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Arrival Time From
|-
|i_date_from ||O || || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
 
==Amazon Resources Update==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cost Centre ||O || || || || || ||
|Amazon Resources  Update
|FMC_UPDATE
|DP_CSV_CSS.AMAZON_RESOURCE_UPDATE
|}
|}
==Baxter Download Id Orders==
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 || || || || ||
|Arrival Time To
|i_date_to ||O || || || || || ||
|-
|Update After (HHMI)
|i_changed ||O || || || || || ||
|-
|Arrival Time From
|i_date_from ||O || || || || || ||
|}
|}


==CN Data Extract==
==Approved Price Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Approved Price  Report
|approved_price_rep
|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
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date
|i_End_Date_Time ||M || TODAY|| || || || ||
|}
|}


==CN Planning Export==
==Asset History==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Asset History
|ASSET_HISTORY
|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
|-
|-
|Group Name ||O || || || || || ||
|Customer
|i_customer ||O ||STRING || ALL|| || || ||
|-
|Asset Id
|i_asset_id ||O ||STRING || ALL|| Asset|| Asset ID|| Asset ID||
|-
|-
|Current Depot ||M || || ||Current Depot ||Location Id ||Name ||
|Driver/User
|i_action_by ||O ||STRING || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Date To
|i_date_to ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Date From
|i_date_from ||M ||TODAY || || || || ||
|}
|}


==CN Tokairo Export==
==Asset Status==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Asset Status
|ASSET_STATUS
|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
|-
|-
|To Date ||M ||TODAY || || || || ||
|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==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Asset Utilisation
|ASSET_UTILISATION
|dp_csv4.asset_utilisation
|}
|}
==CN Trip and Order Detail==
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 || || || || || ||
|Current Location
|I_CURRENT_LOCATION ||O || || || Location|| Location|| Location Name||
|-
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|To Date
|I_DATE_TO ||M ||TODAY || || || || ||
|-
|-
|Loaded At ||O || || || || || ||
|From Date
|I_DATE_FROM ||M ||TODAY || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Vehicle
|I_VEHICLE ||O || || || || || ||
|-
|-
|Group Name ||M || || || || || ||
|Route
|I_ROUTE ||O || || || || || ||
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|Location
|I_LOCATION ||O || || ||Location ||Location ||Location  Name ||
|}
|}


==CN Warehouse Extract==
==Assets On Time Delivery==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Assets On Time  Delivery
|ASSET_ON_TIME_DELIV
|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
|-
|-
|From Location ||M || || ||From Location ||Location Id ||Name ||
|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 || || || || ||
|-
|-
|Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|Location
|I_LOCATION ||O || || || Location|| Location|| Location  Name||
|}
 
==Automotive Planning Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group Name ||O || || || || || ||
|Automotive Planning  Report
|Planning_Report
|DP_CSV2.PLANNING_REPORT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Utilisation >
|I_UTIL_FROM ||O || STRING|| 0|| || || ||
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Utilisation <
|I_UTIL_TO ||O ||STRING ||999 || || || ||
|-
|-
|Carrier ||O || || || || || ||
|End Schedule
|I_END_DATE ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Level
|I_LEVEL ||M || STRING|| SUMMARY|| || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Depot
|I_DEPOT ||M ||STRING ||ALL || || || ||
|-
|-
|Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
|Start Schedule
|I_START_DATE ||M || || || || || ||
|}
|}


==CTM Carrier Responsiveness==
==BGW Trip and Order Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|BGW Trip and Order  Detail
|BGW_Trip_Order_Detail_Extract
|DP_CSV3.BGW_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
|-
|-
|Start Schedule ||O || || || || || ||
|Start Schedule
|P_START_SCHED ||M || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|End Schedule
|P_END_SCHED ||M || || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|Loaded At
|i_loaded_at ||O || || || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|Activity
|i_activity_name ||M || STRING|| Both|| || || ||
|-
|-
|Carrier ||O || || || || || ||
|Group Name
|i_group_name ||M || || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|Carrier
|i_carrier_id ||O || || || || || ||
|}
|}


==Call Collection OTIF Day==
==BGW_DEBRIEF==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''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
|-
|-
|Carrier ||O || || || || || ||
|Cost Centre
|P_COST_CENTRE ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|From Date
|P_START_DATETIME ||M ||TODAY || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|To Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|Customer
|P_CUSTOMER ||O || || || || || ||
|}
 
==BMW Asset Dwell==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||O || || || || || ||
|BMW Asset Dwell
|AUTO_ASSET_DWELL
|DP_CSV3.AUTO_AFTERMARKET_BMW
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||O || || || || || ||
|Asset Type
|-
|i_asset_type ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
 
==Backing Sheet==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M ||TODAY || || || || ||
|Backing Sheet
|BACKING_SHEET_EXTRACT
|DP_CSV_GEN.BACKING_SHEET
|}
|}
==Call Collection OTIF Time 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
|-
|-
|Carrier ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|Sched To
|i_end_sched ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Sched From
|i_start_sched ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Manifest
|i_booking ||O || || || || || ||
|}
 
==Baxter CSR==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Product Type ||O || || || || || ||
|Baxter CSR
|Baxter_csr
|DP_CSV5.BAXTER_CSR
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|End Schedule ||O || || || || || ||
|Customer
|I_CUSTOMER ||M ||STRING ||ALL || || || ||
|-
|-
|Start Schedule ||O || || || || || ||
|To Date
|I_DATE_TO ||M ||TODAY || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date
|I_DATE_FROM ||M || TODAY|| || || || ||
|}
|}


==Call Delivery OTIF Day==
==Baxter Download Id Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Baxter Download Id  Orders
|Baxter Download
|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
|-
|-
|Carrier ||O || || || || || ||
|Download Id
|P_DOWNLOAD_ID ||M ||STRING || || || || ||
|}
 
==CARGOWISE Header==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|CARGOWISE Header
|CARGOWISE_HEADER
|OF_INT.WRITE_CARGOWISE_HEADER
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||M ||TODAY || || || || ||
|Export_id
|-
|i_exp_id ||M || || || || || ||
|Start Schedule ||O || || || || || ||
|}
|-
==CN Data Extract==
|End Schedule ||O || || || || || ||
{{Warning}}Missing
|-
{| class="wikitable"
|Product Type ||O || || || || || ||
!'''Report Name'''
|-
!'''Filename'''
|Customer Group ||O || || || || || ||
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|
|
|
|}
|}
==Call Delivery OTIF Time Window==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!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 || || || || || ||
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|-
|Product Type ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Group Name ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
 
==CN Equipment Moves==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|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
|-
|To Date
|i_date_to
|M
|TODAY
|
|
|
|
|-
|Group Name
|i_group_name
|O
|
|
|
|
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Customer
|i_customer
|O
|
|
|
|
|
|-
|-
|Start Schedule ||O || || || || || ||
|From Date
|i_date_from
|M
|TODAY
|
|
|
|
|}
|}


==Carrier DUs Shipped==
==CN Planning Export==
{{Warning}}Missing
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!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 ||STRING ||ALL || || || ||
|Group Name ||O || || || || || ||
|-
|Current Depot ||M || || ||Current Depot ||Location Id ||Name ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
Line 481: Line 1,339:
|}
|}


==Carrier Delivery Report==
==CN Tokairo Export==
{{Warning}}Missing
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!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 || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Carrier ||M || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|}
|Depot ||M || || || || || ||
 
==CN Trip and Order Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Trip ID ||O ||STRING ||ALL || || || ||
|CN Trip and Order  Detail
|CN_Trip_Order_Detail_Extract
|CSV.CN_Trip_Order_Detail_Extract
|}
|}
==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 || || || || || ||
|Activity
|i_activity_name ||M || STRING|| Both|| || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Group Name
|i_group_name ||M || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|Start Schedule
|P_START_SCHED ||M || || || || || ||
|-
|-
|Invoice No ||M || || || || || ||
|End Schedule
|P_END_SCHED ||M || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Carrier
|i_carrier_id ||O || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|Loaded At
|i_loaded_at ||O || || || || || ||
|}
|}


==Carrier Self Billing==
==CN Warehouse Loading==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|CN Warehouse  Loading
|-
|CN_Warehouse_Loading
|Carrier ||0 || || || || || ||
|DP_CSV_DHL.p_warehouse_loading
|-
|Start Schedule ||M || || || || || ||
|}
|}
==Co-ordinate Non-Conformities==
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 || || || || || ||
|Customer
|i_customer ||O || || || Customer|| CUSTOMER_ID|| CUSTOMER_NAME||
|-
|-
|Discrepancy Dist ||0 || ||1 || || || ||
|Depot
|i_depot
|M
|
|
|Depot
|Location  Id
|Name
|
|-
|-
|TomTom,Epod,Both ||M || ||B || || || ||
|Trip ID (optional)
|i_trip_id
|O
|
|
|
|
|
|
|-
|-
|Driver ||O || || || || || ||
|Carrier
|i_carrier
|O
|
|
|
|
|
|
|-
|-
|Depot ||O || || || || || ||
|End Schedule
|i_end_sched
|M
|
|
|
|
|
|
|-
|-
|End Schedule ||M || || || || || ||
|Start Schedule
|i_start_sched
|M
|
|
|
|
|
|
|}
|}
 
==CN Warehouse Extract==
==Commercial==
{{Warning}}Missing
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|
|
|
|}
|}
==Compliance Report==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!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
|-
|-
|Collection Date ||M || || || || || ||
|From Location ||M || || ||From Location ||Location Id ||Name ||
|}
|-
 
|From Date ||M ||TODAY || || || || ||
==Concurrent Logon Export==
|-
Parameters:
|To Date ||M ||TODAY || || || || ||
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Date ||O ||TODAY || || || || ||
|Owning Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Group Name ||O || || || || || ||
|}
 
==Contracts== || || || || || || || || ||
No Parameters
 
==Cross Dock==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Media Type ||O ||STRING || || || || ||
|Trip ID (optional) ||O || || || || || ||
|-
|-
|Route ||O ||STRING || || || || ||
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|Schedule From ||M || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Depot ||O ||STRING || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME ||
|}
 
==CTM Carrier Responsiveness==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O ||STRING || || || || ||
|CTM Carrier  Responsiveness
|CTM_CARRIER_RESPONSIVENESS
|CSV.CTM_CARRIER_RESPONSIVENESS
|}
|}
==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
|-
|-
|Invoice No ||M || || || || || ||
|Start Schedule
|P_START_SCHED ||O || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|Carrier
|P_HAULIER ||O || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|End Schedule
|-
|P_END_SCHED ||O || || || || || ||
|Invoice No ||M || || || || || ||
|}
|-
 
|Debit Acc ||M || || || || || ||
==CTM Trips Not Responded To==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Credit Acc ||M || || || || || ||
|CTM Trips Not  Responded To
|CTM_TRIPS_NO_RESPONSE
|CSV.CTM_TRIPS_NO_RESPONSE
|}
|}
==Customer Invoice By Dates==
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
|-
|-
|Payment Status ||O || || || || || ||
|End Schedule
|P_END_SCHED
|O
|
|
|
|
|
|
|-
|-
|Customer ||M || || || || || ||
|Start Schedule
|P_START_SCHED
|O
|
|
|
|
|
|
|-
|-
|From Date ||M || || || || || ||
|Carrier
|P_HAULIER
|O
|
|
|
|
|
|
|}
 
==Call Collection OTIF Day==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M || || || || || ||
|Call Collection  OTIF Day
|coll_OTIF_date_window
|dp_csv_nr.coll_otif_date_window
|}
|}
==Customer Invoice 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
|-
|-
|Invoice No ||M || || || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|-
|-
|Credit Acc ||M || || || || || ||
|End Schedule
|i_Sched_To ||O || || || || || ||
|-
|-
|Debit Acc ||M || || || || || ||
|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 || || || || || ||
|}
|}


==Cut Offs Extract==
==Call Collection OTIF Time Window==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Call Collection  OTIF Time Window
|coll_OTIF_window
|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
|-
|-
|End Schedule ||M || || || || || ||
|To Date
|i_End_Date_Time ||M || TODAY|| || || || ||
|-
|Start Schedule
|i_Sched_From ||O || || || || || ||
|-
|-
|Customer ||0 || || || || || ||
|End Schedule
|i_Sched_To ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Product Type
|}
|i_product_type ||O || || || || || ||
 
==DELIVERY_OVERVIEW==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Schedule ||M || || || || || ||
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|-
|To Schedule ||M || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Owning Depot ||O || || || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|-
|-
|POD Confirmed ||O || || || || || ||
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|}
|}


==DOOD Rpt==
==Call Delivery OTIF Day==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Schedule To ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|Schedule From ||M || || || || || ||
|-
|-
|Customer ||O ||STRING ||OPENFIELD || || || ||
|Call Delivery OTIF  Day
|del_OTIF_date_window
|dp_csv_nr.del_otif_date_window
|}
|}
==DUs Despatched==
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 || || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|-
|Customer
|i_customer ||O || || || || || ||
|-
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|-
|Start Sched ||O || || || || || ||
|Product Type
|i_product_type ||O || || || || || ||
|-
|-
|Manifest ||O ||STRING || || || || ||
|End Schedule
|i_Sched_To ||O || || || || || ||
|-
|-
|PO Number ||O ||STRING || || || || ||
|Start Schedule
|i_Sched_From ||O || || || || || ||
|-
|-
|Supplier ||O || || || || || ||
|From Date
|i_Start_Date_Time ||M || TODAY|| || || || ||
|-
|-
|End Sched ||O || || || || || ||
|To Date
|i_End_Date_Time ||M || TODAY|| || || || ||
|}
|}


==DUs Not Loaded==
==Call Delivery OTIF Time Window==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Call Delivery OTIF  Time Window
|del_OTIF_window
|dp_csv_nr.del_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
|-
|-
|Store ||O || || ||Store ||Location ID ||Name ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|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|| || || || ||
|}
|}


==DUs Not Received
==Campus KPI Extract==
|-
{| class="wikitable"
|To Date ||M || || || || || ||
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M || || || || || ||
|Campus KPI Extract
|Campus_KPI_Extract
|KPI.KPI_CAMPUS_EXTRACT
|}
|}
==Daily Manifest E-OT-L==
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
|i_date_from
|M
|TODAY
|
|
|
|
|
|-
|Carrier
|i_carrier
|O
|
|ALL
|
|
|
|
|-
|Cost Centre
|i_cost_centre
|O
|
|ALL
|
|
|
|
|-
|-
|From Date ||M || || || || || ||
|Date Range Type
|i_date_type
|M
|String
|
|
|
|
|
|-
|-
|To Date ||M || || || || || ||
|Depot
|i_depot
|O
|
|ALL
|
|Location  Id
|Name
|
|-
|-
|End Schedule ||M || || || || || ||
|To Date
|i_date_to
|M
|TODAY
|
|
|
|
|
|-
|-
|Start Schedule ||M || || || || || ||
|Client
|i_client
|O
|
|ALL
|
|
|
|
|}
|}


==Daily Transport Plan==
==Carrier DUs Shipped==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Carrier DUs Shipped
|CARRIER_DUS_SHIPPED
|DP_CSV5.CARRIER_DUS_SHIPPED
|}
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_DATE_FROM ||M ||TODAY || || || || ||
|Supplier ||M ||STRING ||ALL || || || ||
|-
|-
|To Date ||M || || || || || ||
|Carrier
|P_CARRIER ||O ||STRING || ALL|| || || ||
|-
|-
|From Date ||M || || || || || ||
|To Date
|I_DATE_TO ||M ||TODAY || || || || ||
|}
|}


==Daily Unscheduled Orders==
==Carrier Delivery Report==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|To Date ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M || || || || || ||
|Carrier Delivery  Report
|Carrier_Delivery_Report
|DP_CSV5.CARRIER_DELIVERY
|}
|}
==Debrief Performance==
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 || || || || || ||
|Sched Name
|P_SCHED_NAME ||M || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Trip ID
|P_TRIP ||O || STRING|| ALL|| || || ||
|-
|-
|Customer ||O || || || || || ||
|Carrier
|P_CARRIER ||M || || || || || ||
|-
|-
|Cust Group ||O || || || || || ||
|Depot
|-
|P_DEPOT ||M || || || || || ||
|Cost Centre ||O || || || || || ||
|}
 
==Carrier Invoice==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Carrier Invoice
|-
|Carrier_Invoice
|From Date ||M ||TODAY || || || || ||
|CSV.CARRIER_INVOICE
|}
|}
==Del Scans==
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 || || || || || ||
|Invoice No
|I_INVOICE_NO ||M || || || || || ||
|-
|Credit Acc
|I_CREDIT_ACC ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Debit Acc
|I_DEBIT_ACC ||M || || || || || ||
|}
|}


==Delivery Conf==
==Carrier Self Billing==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Carrier Self  Billing
|Carrier_Self_billing
|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
|-
|-
|Type ||M || ||M || || || ||
|Start Schedule
|i_start_sched ||M || || || || || ||
|-
|-
|Owning Depot ||O || || || || || ||
|Carrier
|i_carrier ||0 || || || || || ||
|-
|-
|Cost Centre ||M || || || || || ||
|End Schedule
|i_end_sched ||M || || || || || ||
|}
 
==Catalyst Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Catalyst Extract
|CATALYST_EXTRACT
|CSV.CATALYST_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|To Actual date ||M ||TODAY || || || || ||
|End Schedule
|P_END_SCHED
|M
|
|
|
|
|
|
|-
|-
|From Actual date ||M ||TODAY || || || || ||
|Start Schedule
|P_START_SCHED
|M
|
|
|
|
|
|
|}
|}


==Delivery Schedule Extract==
==Co-ordinate Non-Conformities==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Show Dates ||Y || || || || || ||
|Co-ordinate  Non-Conformities
|Co_Ord_Non_Conf
|DP_CSV6.CO_ORD_NON_CONFORM
|}
|}
==Depot Exits by Hour (Loads)==
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 ||M || || ||Depot ||Location Id ||Name ||
|Start Schedule
|i_sched_from ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|End Schedule
|i_sched_to ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Driver
|i_driver ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|TomTom,Epod,Both
|i_inc ||M || || B|| || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Discrepancy Dist
|i_disc_dist ||0 || || 1|| || || ||
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Depot
|i_depot ||O || || || || || ||
|}
|}


==Detailed Interface Report==
==Commercial==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Commercial
|COMMERCIAL
|CSV.Commercial_Orders
|}
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 Group ||O || || || || || ||
|Schedule
|-
|I_SCHEDULE ||M || || || || || ||
|To Date ||O ||TODAY || || || || ||
|}
|-
 
|Customer ||O || || || || || ||
==Compliance Report==
|-
{| class="wikitable"
|From Date ||O ||TODAY || || || || ||
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Status ||M ||STRING ||All || || || ||
|Compliance Report
|COMPLIANCE_REPORT
|DP_CSV_DUN.COMPLIANCE_REPORT
|}
|}
==Dixons Catalyst 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
|-
|-
|End Schedule ||M || || || || || ||
|Collection Date
|-
|P_COL_DATE ||M || || || || || ||
|Carrier ||O || || || || || ||
|}
|-
 
|Depot ||O || || ||Depot ||Location Id ||Name ||
==Concurrent Logon Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|Concurrent Logon  Export
|Concurrent_Logon_Export
|CSV.Concurrent_Logon
|}
|}
==Dixons Order Export==
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 Date ||O ||TODAY || || || || ||
|From Date
|-
|i_from_date ||O ||TODAY || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|To Date
|i_to_date ||O ||TODAY || || || || ||
|}
|}


==Dixons Trip Extract==
== Contracts ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|Contracts
|-
|CONTRACTS
|To Date ||O ||TODAY || || || || ||
|CSV.CONTRACTS
|-
|From Date ||O ||TODAY || || || || ||
|}
|}
No Parameters


==Driver Hours==
==Cross Dock==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Cross Dock
|-
|CROSS_DOCK
|Customer Group ||O || || || || || ||
|DP_CSV6.CROSS_DOCK
|-
|To Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||O || || || || || ||
|}
|}
==Driver Scanning==
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 ||STRING || || || || ||
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|-
|Depot ||O ||STRING || || || || ||
|Customer
|i_customer ||O || STRING|| || || || ||
|-
|-
|Route ||O ||STRING || || || || ||
|Media Type
|i_media_type ||O ||STRING || || || || ||
|-
|-
|Media Type ||O ||STRING || || || || ||
|Depot
|i_depot ||O ||STRING || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Route
|i_route ||O || STRING|| || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Dealer
|i_dealer ||O ||STRING || || || || ||
|}
 
==Customer Invoice==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Activity ||O ||STRING || || || || ||
|Customer Invoice
|Customer_Invoice
|CSV.Customer_Invoice
|}
|}
==Dunelm 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
|-
|-
|Manifest ||O || || || || || ||
|Invoice No
|I_INVOICE_NO ||M || || || || || ||
|-
|-
|Customer ||M || || || || || ||
|Credit Acc
|I_CREDIT_ACC ||M || || || || || ||
|-
|-
|Sched To ||M || || || || || ||
|Debit Acc
|I_DEBIT_ACC ||M || || || || || ||
|}
 
==Customer Invoice By Dates==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Sched From ||M || || || || || ||
|Customer Invoice By  Dates
|Customer_Invoice_By_Dates
|CSV.Customer_Invoice_By_Dates
|}
|}
==Dunelm Inventory Transactions==
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
|-
|-
|Delivery Trip ||O || || || || || ||
|Payment Status
|-
|i_act_or_prov ||O || || || || || ||
|Trunk Trip ||O || || || || || ||
|-
|Collection Trip ||O || || || || || ||
|-
|Store ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|-
|Date Type ||M ||STRING ||C || || || ||
|From Date
|I_START_DATETIME ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY ||TODAY:23:59 || || || ||
|To Date
|I_END_DATETIME ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY ||TODAY:00:00 || || || ||
|Customer
|I_CUSTOMER ||M || || || || || ||
|}
|}


==Dunelm Item Movements 3==
==Customer Invoice Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Customer Invoice  Extract
|Customer_Invoice
|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
|-
|-
|Manifest Number ||O || || || || || ||
|Debit Acc
|I_DEBIT_ACC ||M || || || || || ||
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|Invoice No
|I_INVOICE_NO ||M || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|Credit Acc
|I_CREDIT_ACC ||M || || || || || ||
|}
 
==Cut Offs Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|DU Type ||O || || || || || ||
|Cut Offs Extract
|-
|Cut_offs_extract
|Supplier ||O || || || || || ||
|DP_CSV6.CUT_OFF_EXTRACT
|-
|P/O Number ||O || || || || || ||
|-
|Store ||O || || || || || ||
|}
|}
==Dunelm Item Movements 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
|-
|-
|Manifest Number ||O ||STRING || || || || ||
|End Schedule
|i_end_sched ||M || || || || || ||
|-
|-
|P/O Number ||O || || || || || ||
|Customer
|i_customer ||0 || || || || || ||
|-
|-
|Store ||O || || || || || ||
|Start Schedule
|i_start_sched ||M || || || || || ||
|}
 
==D365 Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|DU Type ||O || || || || || ||
|D365 Extract
|-
|DP_FINANCE.D365_EXPORT
|Supplier ||O || || || || || ||
|D365_EXPORT_
|-
|}
|Actual To Date ||M ||TODAY || || || || ||
No parameters.
==DELIVERY_OVERVIEW==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|DELIVERY_OVERVIEW
|DELIVERY_OVERVIEW
|dp_csv3.delivery_overview
|}
|}
==Dunelm Item Movements Extract New==
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
|-
|-
|P/O Number ||O || || || || || ||
|POD Confirmed
|P_POD ||O || || || || || ||
|-
|-
|Manifest Number ||O ||STRING || || || || ||
|Owning Depot
|P_OWNING_DEPOT ||O || || || || || ||
|-
|-
|Store ||O || || || || || ||
|To Schedule
|P_END_SCHED ||M || || || || || ||
|-
|-
|DU Type ||O || || || || || ||
|From Schedule
|-
|P_START_SCHED ||M || || || || || ||
|Supplier ||O || || || || || ||
|}
|-
 
|Actual From Date ||M ||TODAY || || || || ||
==DOOD Rpt==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|DOOD Rpt
|DOOD_RPT
|dp_csv_dood.dood_rpt
|}
|}
==Dunelm Left Offs==
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
|-
|-
|Trip Id (Optional) ||O || || || || || ||
|Schedule To
|I_SCHED_TO ||M || || || || || ||
|-
|-
|Days Back ||M ||STRING ||30 || || || ||
|Schedule From
|I_SCHED_FROM ||M || || || || || ||
|-
|-
|Store (Optional) ||O || || ||Store ||Location Id ||Name ||
|Customer
|I_CUSTOMER ||O ||STRING ||OPENFIELD || || || ||
|}
|}


==Dunelm Manual Loaded Items Extract==
==DUs Despatched==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|DUs Despatched
|DUS_DESPATCHED_EXTRACT
|DP_CSV_GEN.DUS_DESPATCHED_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
|-
|-
|From Date ||O || || || || || ||
|Start Sched
|p_start_sched ||O || || || || || ||
|-
|-
|To Date ||O || || || || || ||
|PO Number
|p_external ||O || STRING|| || || || ||
|-
|Consignment Num
|p_oms ||O ||STRING || || || || ||
|-
|End Sched
|p_end_sched ||O || || || || || ||
|-
|Manifest
|p_manifest ||O || STRING|| || || || ||
|-
|Supplier
|p_customer ||O || || || || || ||
|}
|}


==Dunelm Supplier Trends Extract==
==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:
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
|-
|-
|Year ||M || || || || || ||
|Schedule
|p_sched_date ||M || || || || || ||
|-
|-
|Week ||M || || || || || ||
|Store
|p_store ||O || || || Store|| Location  ID|| Name||
|}
|}


==Duplicate Postcodes==
== 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:
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
|-
|-
|Ignore Inactive? ||O || || || || || ||
|To Date
|i_avail_to ||M || || || || || ||
|-
|-
|Location From ||O || || ||Location From ||Location Id ||Location Name ||
|From Date
|i_avail_from ||M || || || || || ||
|}
 
==Daily Manifest E-OT-L==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Location To ||O || || ||Location To ||Location Id ||Location Name ||
|Daily Manifest  E-OT-L
|DAILY_MANIFEST_E_OT_L_EXTRACT
|DP_CSV_GEN.DAILY_EXT_MANIFEST
|}
|}
==ERC==
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 End ||M || || || || || ||
|To Date
|i_avail_to ||M || || || || || ||
|-
|-
|Sched Start ||M || || || || || ||
|From Date
|-
|i_avail_from ||M || || || || || ||
|Carrier ||O || || || || || ||
|}
|-
 
|DHL Carriers ||M || || || || || ||
==Daily Receiving E-OT-L==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Detail Level ||M || || || || || ||
|Daily Receiving  E-OT-L
|RECEIVING_E_OT_L_EXTRACT
|DP_CSV_GEN.DAILY_EXT_RECEIPTING
|}
|}
==Equipment Moves==
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
|-
|-
|Owning Depot ||O || || || || || ||
|End Schedule
|i_sched_to
|M
|
|
|
|
|
|
|-
|-
|Customer ||O || || || || || ||
|Start Schedule
|i_sched_from
|M
|
|
|
|
|
|
|}
==Daily Transport Plan==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M ||TODAY || || || || ||
|Daily Transport  Plan
|-
|DAILY_TRANSPORT_PLAN_EXTRACT
|From Date ||M ||TODAY || || || || ||
|DP_CSV_GEN.DAILY_TRANSPORT_PLAN
|-
|Carrier ||O || || || || || ||
|}
|}
==Extract Lane==
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 || || ||Cost Centre ||Location Id ||Name ||
|From Date
|i_avail_from ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Supplier
|i_supplier ||M ||STRING ||ALL || || || ||
|-
|To Date
|i_avail_to ||M || || || || || ||
|-
|Order Status
|i_ord_status ||M || STRING|| ALL|| || || ||
|}
|}


==Failed Shipment==
==Daily Unscheduled Orders==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule To ||M || || || || || ||
|Daily Unscheduled  Orders
|-
|DAILY_UNSCHEDULED_ORDERS_EXTRACT
|Schedule From ||M || || || || || ||
|DP_CSV_GEN.DAILY_UNSCHED_ORD
|-
|Customer ||O ||STRING ||OPENFIELD || || || ||
|}
|}
==Fixed Routes 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
|-
|-
|Show Active / Inactive ||M ||STRING ||B || || || ||
|From Date
|-
|i_avail_from ||M || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|To Date
|i_avail_to ||M || || || || || ||
|}
|}


==GREENE KING Interface Results==
==Debrief Performance==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Customer ||O || || || || || ||
!'''Procedure for Scheduling'''
|-
|Depot ||O || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Debrief Performance
|debrief_performance
|dp_csv_nr.debrief_performance
|}
|}
==GYP EFX Export==
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
|-
|-
|Trip Status ||O || || || || || ||
|Cust Group
|i_cust_group ||O || || || || || ||
|-
|-
|To Schedule ||M || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|From Schedule ||M || || || || || ||
|Carrier Group
|i_carrier_group ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|From Date
|i_Start_Date_Time ||M || TODAY|| || || || ||
|-
|Carrier Code
|i_carrier_code ||O || || || || || ||
|-
|From Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|}
|}


==HC Booking In Form==
==Del Scans==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Del Scans
|DEL_SCANS
|DP_CSV6.DEL_SCANS
|}
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 ||M || || || || || ||
|End Schedule
|i_end_sched ||M || || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Start Schedule
|i_start_sched ||M || || || || || ||
|}
 
==Delivery Conf==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Delivery Location ||O || || || || || ||
|Delivery Conf
|BGYP_DELCONF_
|DP_CSV5.DELIVERY_CONF
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Owning Depot
|p_own ||O || || || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Cost Centre
|p_cost ||M || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|To Actual date
|p_to_date ||M || TODAY|| || || || ||
|-
|-
|Delivery Location ||O || || || || || ||
|Type
|p_type ||M || || M|| || || ||
|-
|-
|Customer ||O || || || || || ||
|From Actual date
|p_from_date ||M ||TODAY || || || || ||
|}
|}


==HC Haulier Trip Sheet==
==Delivery Schedule Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Delivery Schedule  Extract
|Delivery_Schedule
|DP_CSV_DHL.DELIVERY_SCHEDULE
|}
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
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Show Dates
|P_DATE_SELECT ||Y || || || || || ||
|}
 
==Depot Exits by Hour (Loads)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Owning Depot ||O || || ||Depot ||Location Id ||Name ||
|Depot Exits by Hour  (Loads)
|-
|DEPOT_EXITS_LOADS
|Schedule ||M || || || || || ||
|CSV.DEPOT_EXITS_BY_HOUR_LOADS
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|To Date
|i_End_Date_Time ||M || TODAY|| || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Depot
|i_Depot_Loc_Id ||M || || || Depot|| Location  Id|| Name||
|-
|-
|Load Location ||O || || ||Loading Location ||Location Id ||Name ||
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|}
 
==Depot Exits by Hour (RPEs)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Owning Depot ||O || || ||Depot ||Location Id ||Name ||
|Depot Exits by Hour  (RPEs)
|DEPOT_EXITS_RPE
|CSV.DEPOT_EXITS_BY_HOUR_RPE
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Depot
|i_Depot_Loc_ID ||M || || || Depot|| Location  Id|| Name||
|-
|-
|Schedule ||M || || || || || ||
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|To Date
|i_End_Date_Time ||M || TODAY|| || || || ||
|}
==Detailed Interface Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Group Name ||O || || || || || ||
|Detailed Interface  Report
|-
|Detailed_Interface_Report
|Load Location ||O || || ||Loading Location ||Location Id ||Name ||
|CSV.Detailed_Interface_Report
|}
|}
==HCR Customer Orders==
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_group_name ||O || || || || || ||
|-
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Status
|i_status ||M || STRING|| All|| || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|To Date
|i_to_date ||O ||TODAY || || || || ||
|-
|-
|Depot ||O || || || || || ||
|From Date
|i_from_date ||O ||TODAY || || || || ||
|}
|}


==HCR Loading Sheet CSV==
==Dixons Catalyst Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dixons Catalyst  Report
|fn
|CSV.Dixons_Catalyst_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
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Start Schedule
|P_START_SCHED ||M || || || || || ||
|-
|-
|Load Location ||O || || ||Loading Location ||Loading Location ||Name ||
|End Schedule
|P_END_SCHED ||M || || || || || ||
|-
|-
|Owning Depot ||O || || ||Depot ||Loading Location ||Name ||
|Depot
|i_Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|-
|Schedule From ||M || || || || || ||
|Carrier
|P_HAULIER ||O || || || || || ||
|}
 
==Dixons Order Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule To ||M || || || || || ||
|Dixons Order Export
|Dixons_Order_Export
|CSV.Dixons_Order_Export
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O || || || || || ||
|From Date
|i_from_date ||O ||TODAY || || || || ||
|-
|-
|Customer ||O || || || || || ||
|To Date
|i_to_date ||O || TODAY|| || || || ||
|-
|-
|Group Name ||O || || || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|}
|}


==Haulier Invoice==
==Dixons Trip Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dixons Trip Extract
|Dixons_Trip_Extract
|CSV.Dixons_Trip_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
|-
|-
|End Date ||O || || || || || ||
|To Date
|i_to_date ||O || TODAY|| || || || ||
|-
|-
|Start Date ||O || || || || || ||
|From Date
|i_from_date ||O ||TODAY || || || || ||
|-
|-
|Invoice ID ||O ||STRING || || || || ||
|Carrier
|-
|i_carrier ||O || || || || || ||
|End Date ||O || || || || || ||
|}
 
==Driver Hours==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Date ||O || || || || || ||
|Driver Hours
|-
|driver_hours
|Invoice ID ||O ||STRING || || || || ||
|dp_csv_nr.driver_hours
|}
|}
==Heavy Vehicle 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
|-
|-
|Start Schedule ||M || || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|To Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|From Date
|i_Start_Date_Time ||M || TODAY|| || || || ||
|}
|}


==Historical Lane Based Orders==
==Driver Scanning==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|To Date ||O ||TODAY || || || || ||
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Driver Scanning
|DRIVER_SCANNING
|DP_CSV6.DRIVER_SCANNING
|}
|}
==IND Trip and Order Detail==
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
|-
|-
|Activity ||M ||STRING ||Both || || || ||
|Depot
|i_depot ||O ||STRING || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Media Type
|i_media_type ||O ||STRING || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Route
|i_route ||O ||STRING || || || || ||
|-
|-
|Loaded At ||O || || || || || ||
|Customer
|i_customer ||O ||STRING || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Dealer
|i_dealer ||O ||STRING || || || || ||
|-
|Activity
|i_activity ||O || STRING|| || || || ||
|-
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|-
|Group Name ||M || || || || || ||
|Schedule From
|i_sched_from ||M || || || || || ||
|}
|}


==ISC Finance (2) Export==
==Dunelm Actual Load==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Actual Load
|DUNELM_ACTUAL_LOAD
|DP_CSV_DUN.daily_ext_load
|}
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
|-
|-
|Customer ||M ||STRING ||ALL || || || ||
|Load Date From
|i_date_from
|M
|
|
|
|
|
|
|-
|-
|End Schedule ||M || || || || || ||
|Load Date To
|i_date_to
|M
|
|
|
|
|
|
|}
 
==Dunelm Actual Unload==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|Dunelm Actual  Unload
|DUNELM_ACTUAL_UNLOAD
|DP_CSV_DUN.daily_ext_unload
|}
|}
==Interface Errors Failures==
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
|-
|-
|External Ref ||O ||STRING || || || || ||
|Unload Date From
|i_date_from
|M
|
|
|
|
|
|
|-
|-
|Customer ||O || || ||Customer || || ||
|Unload Date To
|-
|i_date_to
|Source System ||O || || || || || ||
|M
|-
|
|End Date ||M ||TODAY || || || || ||
|
|
|
|
|
|}
 
==Dunelm Backing Sheet==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Date ||M ||TODAY || || || || ||
|Dunelm Backing  Sheet
|BACKING_SHEET
|DP_CSV2.BACKING_SHEET
|}
|}
==Invalid Orders==
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 || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|Sched To
|i_end_sched ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Sched From
|i_start_sched ||O || || || || || ||
|-
|-
|Customer ||0 || || || || || ||
|Manifest
|i_booking ||O || || || || || ||
|}
|}


==Item Movements==
== Dunelm DUs Despatched Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm DUs  Despatched Extract
|DUNELM_DUS_DESPATCHED_EXTRACT
|DP_CSV_DUN.DUN_DU_DESPATCHED_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
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|PO Number
|p_external
|O
|STRING
|
|
|
|
|
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|Manifest
|p_manifest
|O
|STRING
|
|
|
|
|
|-
|-
|Supplier ||O || || || || || ||
|Supplier
|p_customer
|O
|
|
|
|
|
|
|-
|-
|DU Type ||O || || || || || ||
|Start Sched
|p_start_sched
|O
|
|
|
|
|
|
|-
|-
|Store ||O || || || || || ||
|End Sched
|p_end_sched
|O
|
|
|
|
|
|
|-
|-
|Manifest Number ||O || || || || || ||
|Consignment Num
|-
|p_oms
|P/O Number ||O || || || || || ||
|O
|STRING
|
|
|
|
|
|}
|}


==Item Movements 2==
== Dunelm DUs Not Loaded Extract ==
{| class="wikitable"
!'''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:
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
|-
|-
|DU Type ||O || || || || || ||
|Store
|p_store
|O
|
|
|Store
|Location Id
|Name
|
|-
|-
|Supplier ||O || || || || || ||
|Schedule
|p_sched_date
|M
|
|
|
|
|
|
|}
 
== Dunelm DUs Not Received ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|Dunelm DUs Not  Received
|DUNELM_DUS_NOT_RECEIVED
|DP_CSV_DUN.daily_ext_not_recd
|}
Parameters:
{| class="wikitable"
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|To Date
|i_avail_to
|M
|
|
|
|
|
|
|-
|-
|P/O Number ||O || || || || || ||
|From Date
|-
|i_avail_from
|Store ||O || || || || || ||
|M
|
|
|
|
|
|
|}
 
== Dunelm Inventory Transactions ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Manifest Number ||O || || || || || ||
|Dunelm Inventory  Transactions
|DUN_INVENTORY_TRANS
|DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS
|}
|}
==Item Movements 3==
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
|-
|-
|P/O Number ||O || || || || || ||
|To Date
|P_DATE_TO ||M || TODAY|| TODAY:23:59|| || || ||
|-
|-
|Store ||O || || || || || ||
|Trunk Trip
|P_TRUNK_TRIP ||O || || || || || ||
|-
|-
|Manifest Number ||O || || || || || ||
|Delivery Trip
|P_DEL_TRIP ||O || || || || || ||
|-
|-
|DU Type ||O || || || || || ||
|Collection Trip
|P_COL_TRIP ||O || || || || || ||
|-
|-
|Supplier ||O || || || || || ||
|Date Type
|P_DATE_TYPE ||M || STRING|| C|| || || ||
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|From Date
|P_DATE_FROM ||M ||TODAY ||TODAY:00:00 || || || ||
|-
|Store
|i_dealer ||O || || || || || ||
|}
|}


==Items Not Scanned By Date==
==Dunelm Item Movements 3==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Item  Movements 3
|DUN_ITEM_MOVEMENTS_EXTRACT
|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3
|}
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 || || || || || ||
|Manifest Number
|P_MANF_NO ||O ||STRING || || || || ||
|-
|Store
|P_STORE ||O || || || || || ||
|-
|Supplier
|P_SUPPLIER ||O || || || || || ||
|-
|Actual From Date
|P_START_DATETIME ||M || TODAY|| || || || ||
|-
|P/O Number
|P_PO_NO ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|DU Type
|P_DU_TYPE ||O || || || || || ||
|-
|-
|Depot ||M || || || || || ||
|Actual To Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|}
|}


==Items Not Scanned By Trip==
==Dunelm Item Movements Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Item  Movements Extract
|DUN_ITEM_MOVEMENTS_EXTRACT
|DP_CSV_DUN.ITEM_MOVEMENTS_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
|-
|-
|Trip ||M || || || || || ||
|Supplier
|P_SUPPLIER ||O || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Actual To Date
|}
|P_END_DATETIME ||M ||TODAY || || || || ||
 
|-
==JEYES Interface Results==
|Actual From Date
Parameters:
|P_START_DATETIME ||M ||TODAY || || || || ||
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||O ||TODAY || || || || ||
|DU Type
|P_DU_TYPE ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Store
|P_STORE ||O || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|P/O Number
|P_PO_NO ||O || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Manifest Number
|P_MANF_NO ||O || || || || || ||
|}
|}


==KPI By Lane==
==Dunelm Item Movements Extract New==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Item  Movements Extract New
|DUN_ITEM_MOVEMENTS_EXTRACT
|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2
|}
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 Group ||O || || || || || ||
|Actual To Date
|P_END_DATETIME ||M || TODAY|| || || || ||
|-
|-
|End Date ||M || || || || || ||
|Store
|P_STORE ||O || || || || || ||
|-
|-
|Show Detail ||M ||STRING ||Y || || || ||
|P/O Number
|P_PO_NO ||O || || || || || ||
|-
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|Manifest Number
|P_MANF_NO ||O || STRING|| || || || ||
|-
|-
|End Date ||M ||TODAY || || || || ||
|Actual From Date
|P_START_DATETIME ||M || TODAY|| || || || ||
|-
|-
|Start Date ||M ||TODAY || || || || ||
|Supplier
|P_SUPPLIER ||O || || || || || ||
|-
|-
|Start Date ||M || || || || || ||
|DU Type
|P_DU_TYPE ||O || || || || || ||
|}
 
==Dunelm Left Offs==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Tolerance(days) ||O || || || || || ||
|Dunelm Left Offs
|Left_Offs_Extract
|DP_CSV_DUN.left_offs_extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Separate Pages ||M ||STRING ||N || || || ||
|Store (Optional)
|P_STORE ||O || || || Store|| Location Id|| Name||
|-
|-
|Customer Group ||O || || || || || ||
|Trip Id (Optional)
|P_TRIP_ID ||O || || || || || ||
|-
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|Days Back
|P_DAYS_BACK ||M || STRING|| 30|| || || ||
|}
|}


==Kraft KPI==
==Dunelm Loading Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Loading  Extract
|DUNELM_LOADING_EXTRACT
|DP_CSV2.DUN_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
|-
|-
|From Date ||M ||TODAY || || || || ||
|Schedule
|-
|P_SCHED_DATE ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|}
==Dunelm Manifest E-OT-L Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cost Centre ||O || || || || || ||
|Dunelm Manifest  E-OT-L Extract
|DUNELM_MANIFESTED_EOL
|DP_CSV_DUN.daily_ext_manifest
|}
|}
==LFS Packages==
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 ||M || || || || || ||
|To Date
|i_avail_to ||M || || || || || ||
|-
|-
|Order Status ||O || || || || || ||
|From Date
|i_avail_from ||M || || || || || ||
|}
==Dunelm Manual Loaded Items Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|Dunelm Manual  Loaded Items Extract
|-
|MANL_SCAN_ORDER_DETAIL_EXTRACT
|External Ref ||O || || || || || ||
|DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT
|}
|}
==Lane 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
|-
|-
|Customer ||O || || || || || ||
|From Date
|P_START_DATE ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|To Date
|-
|P_END_DATE ||O || || || || || ||
|To Loc ||O || || ||To Loc ||Location Id ||Name ||
|}
 
== Dunelm Receiving Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Loc ||O || || ||From Loc ||Location Id ||Name ||
|Dunelm Receiving  Extract
|DUNELM_RECEIVING_EXTRACT
|DP_CSV2.DUN_RECEIVING
|}
|}
==Left Offs==
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 (optional) ||O || || ||Store ||Location ID ||Name ||
|Schedule
|-
|P_SCHED_DATE ||M || || || || || ||
|Days Back ||M ||STRING ||30 || || || ||
|-
|Trip ID (optional) ||O || || || || || ||
|}
|}


==Loading Extract==
== Dunelm Recieving E-OT-L Extract ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|Dunelm Recieving  E-OT-L Extract
|DUNELM_RECEIPTED_EOL
|DP_CSV_DUN.daily_ext_receipting
|}
|}
==Loading Schedule CSV==
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 ||M || || ||Depot ||Location Id ||Name ||
|Start Schedule
|-
|i_sched_from ||M || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|End Schedule
|i_sched_to
|M
|
|
|
|
|
|
|}
|}


==Location Export==
== Dunelm Supplier DU Extract ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Country ||O || || || || || ||
|Dunelm Supplier DU  Extract
|DUNELM_SUPPLIER_DU_EXTRACT
|DP_CSV2.DUN_SUPPLIER_DU_EXTRACT
|}
|}
==Location Pre-Warning==
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
|-
|-
|Load Type ||M ||STRING ||ALL || || || ||
|To
|P_TO
|M
|
|TODAY
|
|
|
|
|-
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|From
|-
|P_FROM
|To Date ||M ||TODAY || || || || ||
|M
|
|TODAY
|
|
|
|
|}
 
== Dunelm Supplier DU Extract by Store ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Date ||M ||TODAY || || || || ||
|Dunelm Supplier DU  Extract by Store
|DUNELM_DU_STORE_EXTRACT
|DP_CSV2.DUN_DU_STORE_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|From Date ||M ||TODAY || || || || ||
|Order Status
|P_STATUS
|O
|
|
|
|
|
|
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Start Schedule
|P_START_SCHED
|M
|
|
|
|
|
|
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|End Schedule
|P_END_SCHED
|M
|
|
|
|
|
|
|-
|-
|From Date ||M ||TODAY || || || || ||
|Store
|-
|P_STORE
|Load Type ||M ||STRING ||ALL || || || ||
|O
|
|
|Store
|Location  Id
|Name
|
|}
 
== Dunelm Supplier Revenue Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|Dunelm Supplier  Revenue Extract
|DUNELM_SUPPLIER_REVENUE_EXTRACT
|DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT
|}
|}
==MDD Code 03 Exceptions==
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 || || || || ||
|End Schedule
|P_END_SCHED
|M
|
|
|
|
|
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Start Schedule
|P_START_SCHED
|M
|
|
|
|
|
|
|}
|}


==Manual Loaded Items==
== Dunelm Supplier Revenue Extract New ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Supplier  Revenue Extract New
|DUNELM_SUPPLIER_REVENUE_NEW
|DP_CSV2.DUN_SUPPLIER_REVENUE_NEW
|}
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 ||O || || || || || ||
|Revenue End
|P_REVENUE_END
|M
|
|TODAY
|
|
|
|
|-
|-
|To Date ||O || || || || || ||
|Revenue Start
|P_REVENUE_START
|M
|
|TODAY
|
|
|
|
|}
|}


==Master and Child Locations==
== Dunelm Supplier Trends Extract ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Supplier  Trends Extract
|DUN_SUPPLIER_TRENDS
|dp_csv_dun.dun_du_rpe_revenue_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
|-
|-
|Show UnMapped ||O || || ||Show UnMapped || || ||
|Week
|i_week_no ||M || || || || || ||
|-
|-
|Show Mapped ||O || || ||Show Mapped || || ||
|Year
|i_year ||M || || || || || ||
|}
|}


==Message Maintenance== || || || || || || || || ||
==Dunelm Transport Plan==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Transport  Plan
|DUNELM_TRANSPORT_PLAN
|DP_CSV_DUN.daily_transport_plan
|}
|}
==Missing Lat Long 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
|-
|-
|Cost Centre ||M || ||ALL || || || ||
|From Date
|i_avail_from ||M || || || || || ||
|-
|Order Status
|i_ord_status ||M || STRING|| ALL|| || || ||
|-
|Supplier
|i_supplier
|M
|STRING
|ALL
|
|
|
|
|-
|To Date
|i_avail_to
|M
|
|
|
|
|
|
|}
|}


==Missing Steps Report==
== Dunelm Unsched Orders ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Dunelm Unsched  Orders
|DUNELM_UNSCHED_ORD
|DP_CSV_DUN.daily_unsched_ord
|}
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 Date ||M ||TODAY || || || || ||
|To Date
|i_avail_to
|M
|
|
|
|
|
|
|-
|-
|Missing Step ||O ||STRING ||ALL || || || ||
|From Date
|i_avail_from
|M
|
|
|
|
|
|
|}
 
==Duplicate Postcodes==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|Duplicate Postcodes
|DUPLICATE_POSTCODES
|dp_csv2.duplicate_postcodes_extract
|}
|}
==Month End Accruals==
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 Date ||M ||TODAY || || || || ||
|Location To
|P_LOCATION_TO ||O || || || Location To|| Location Id|| Location Name||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Ignore Inactive?
|P_IGNORE_INACTIVE ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Location From
|P_LOCATION_FROM ||O || || ||Location  From ||Location  Id ||Location  Name ||
|}
 
==EFX Inbound Errors==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|EFX Inbound Errors
|EFX_Inbound_Errors
|DP_CSV2.EFX_In_Errs_Extract
|}
No parameters.
==ERC==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cust Group ||O || || || || || ||
|ERC
|ERC
|DP_CSV_DHL.ERC
|}
|}
==NR Finance 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
|-
|-
|From Date ||M ||TODAY || || || || ||
|DHL Carriers
|-
|i_dhl_carr ||M || || || || || ||
|Debriefed ||M || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Detail Level
|i_detail ||M || || || || || ||
|-
|-
|To Region ||M ||STRING ||ALL || || || ||
|Sched Start
|i_sched_from ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Sched End
|i_sched_to ||M || || || || || ||
|}
 
==Equipment Moves==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Strategy ||O || || || || || ||
|Equipment Moves
|-
|Equip_Move
|Cost Centre ||O || || || || || ||
|DP_CSV2.EQUIP_MOVE
|-
|Customer ||O || || || || || ||
|-
|From Region ||M ||STRING ||ALL || || || ||
|}
|}
==NR 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
|-
|-
|To Date ||M ||TODAY || || || || ||
|Owning depot
|i_depot ||O || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Debriefed ||M || || || || || ||
|To Date
|i_date_to ||M ||TODAY || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|From Date
|i_date_from ||M ||TODAY || || || || ||
|-
|-
|To Region ||M ||STRING ||ALL || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|}
 
==Extract Lane==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Region ||M ||STRING ||ALL || || || ||
|Extract Lane
|EXTRACT_LANE
|CSV.EXTRACT_BY_LANE
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier Group ||O || || || || || ||
|Cost Centre
|I_COST_CENTRE ||O || || ||Cost Centre ||Location Id ||Name ||
|-
|-
|Strategy ||O || || || || || ||
|Customer
|-
|I_CUSTOMER ||O || || || || || ||
|Customer ||O || || || || || ||
|}
 
==Failed Shipment==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cost Centre ||O || || || || || ||
|Failed Shipment
|FAILED_SHIPMENT
|dp_csv3.failed_shipment
|}
|}
==OTM Export==
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 To ||M ||TODAY || || || || ||
|Schedule To
|I_SCHED_TO ||M || || || || || ||
|-
|-
|Date From ||M ||TODAY || || || || ||
|Schedule From
|I_SCHED_FROM ||M || || || || || ||
|-
|-
|Carrier ||O || || || || || ||
|Customer
|I_CUSTOMER ||O ||STRING ||OPENFIELD || || || ||
|}
|}


==On Time Arrivals==
==Fixed Routes Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Fixed Routes  Extract
|Routes_Extract
|CSV.FIXED_ROUTES_EXPORT
|}
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
|-
|-
|Outbase ||O || || || || || ||
|Show Active / Inactive
|i_inactive ||M ||STRING ||B || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Depot
|i_depot ||O || || ||Depot ||Location  Id ||Name ||
|}
 
==GREENE KING Interface Results==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Dealer ||O || || || || || ||
|GREENE KING  Interface Results
|GREENE_KING_interface_results
|CSV.GREENE_KING_if_res
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|Depot
|i_depot ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|To Date
|i_to_date ||O ||TODAY || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|From Date
|i_from_date ||O ||TODAY || || || || ||
|}
|}


==On Time Drops==
==GYP EFX Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|GYP EFX Export
|GYP_EFX_Export
|DP_CSV5.GYP_EFX_EXPORT
|}
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
|-
|-
|Outbase ||O || || || || || ||
|Trip Status
|I_STATUS ||O || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|To Schedule
|P_END_SCHED ||M || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|From Schedule
|P_START_SCHED ||M || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Cost Centre
|I_COST_CENTRE ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer Group
|-
|I_CUST_GRP ||O || || || || || ||
|Schedule From ||M || || || || || ||
|}
 
==HC Booking In Form==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Dealer ||O || || || || || ||
|HC Booking In Form
|HC_BOOKING_IN_FORM
|DP_CSV5.P_HC_BOOKING_IN_FORM
|}
|}
==On Time Items==
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
|-
|-
|Dealer ||O || || || || || ||
|Schedule
|I_SCHED_NAME ||M || || || || || ||
|-
|-
|Outbase ||O || || || || || ||
|Group Name
|I_GROUP_NAME ||O || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Delivery Location
|-
|I_DEL_LOCATION ||O || || || || || ||
|Schedule From ||M || || || || || ||
|}
|-
 
|Media Type ||O || || || || || ||
==HC Haulier Trip Sheet==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|HC Haulier Trip  Sheet
|HAULIER_TRIP_SHEET
|DP_CSV2.HAULIER_TRIP_SHEET
|}
|}
==On Time Items (Assets)==
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 From ||M || || || || || ||
|Trip ID (optional)
|i_trip_id ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Owning Depot
|i_depot ||O || || ||Depot ||Location  Id ||Name ||
|-
|-
|Dealer ||O || || || || || ||
|Load Location
|i_load_loc ||O || || || Loading  Location|| Location  Id|| Name||
|-
|-
|Outbase ||O || || || || || ||
|Group Name
|i_group_name ||O || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Carrier
|i_carrier ||O || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Schedule
|i_sched ||M || || || || || ||
|}
 
==HCR Customer Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule To ||M || || || || || ||
|HCR Customer Orders
|HCR_CUSTOMER_ORDERS
|DP_CSV_DHL.HCR_CUSTOMER_ORDERS
|}
|}
==On Time Returns==
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 || || || || || ||
|Cost Centre
|-
|I_COST_CENTRE ||O || || || || || ||
|Route Code ||O || || || || || ||
|-
|Outbase ||O || || || || || ||
|-
|-
|Dealer ||O || || || || || ||
|Depot
|P_LOCATION ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Schedule
|-
|I_SCHED_NAME ||M || || || || || ||
|Schedule To ||M || || || || || ||
|}
|}


==Order Charges Extract==
==HCR Loading Sheet CSV==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Date ||M ||TODAY || || || || ||
|HCR Loading Sheet  CSV
|HCR_LOADING_SHEET
|DP_CSV5.HCR_LOADING_SHEET
|}
|}
==Order 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
|-
|-
|End Sched ||M || || || || || ||
|Carrier
|P_CARRIER ||O || || || || || ||
|-
|-
|Start Sched ||M || || || || || ||
|Group Name
|}
|P_GROUP_NAME ||O || || || || || ||
 
|-
==Order Interface Results==
|Owning Depot
Parameters:
|P_OWNING_DEPOT ||O || || ||Depot ||Loading  Location ||Name ||
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Customer
|P_CUSTOMER ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Schedule To
|P_SCHED_TO ||M || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Trip ID (optional)
|P_TRIP_ID ||O || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|Load Location
|P_LOAD_LOC ||O || || || Loading  Location|| Loading  Location|| Name||
|-
|-
|Message Type ||O || || || || || ||
|Schedule From
|P_SCHED_FROM ||M || || || || || ||
|}
|}


==Order Items POD Debriefed==
==Haulier Invoice==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Haulier Invoice
|Haulier_Invoice
|DP_CSV5.HAULIER_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
|-
|-
|Customer ||O || || || || || ||
|Invoice ID
|P_INVOICE_ID ||O || STRING|| || || || ||
|}
 
==Heavy Vehicle Utilisation==
{{Warning}}Missing
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||O || || || || || ||
|
|-
|
|Start Schedule ||M || || || || || ||
|
|}
|}
==Order Savings==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
Line 1,847: Line 4,068:
|Start Schedule ||M || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Show Neg Savings ||M || || || || || ||
|Customer Group ||O || || || || || ||
|}
|}


==Order Tracking==
==Historical Lane Based Orders==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Customer ||O ||STRING ||OPENFIELD || || || ||
!'''Procedure for Scheduling'''
|-
|Month ||M || || || || || ||
|-
|Week Offset ||O || || || || || ||
|-
|Year ||M || || || || || ||
|-
|-
|Cost Centre ||O ||STRING ||OPENFIELDCC || || || ||
|
|
|
|}
|}
==Orders for Relabelling==
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 ||M || || || || || ||
|From Date
|I_FROM_DATE ||M ||TODAY || || || || ||
|-
|To Date
|I_TO_DATE ||O ||TODAY || || || || ||
|}
|}


==Orders to LogiX== || || || || || || || || ||
==IND Trip and Order Detail==
|}
 
==Orders to Paragon==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|IND Trip and Order  Detail
|IND_Trip_Order_Detail_Extract
|DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT
|}
|}
==Outbound Shortage==
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 || || || || || ||
|End Schedule
|P_END_SCHED ||M || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Activity
|i_activity_name ||M || STRING|| Both|| || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Loaded At
|i_loaded_at ||O || || || || || ||
|-
|-
|Media Type ||O ||STRING || || || || ||
|Start Schedule
|P_START_SCHED ||M || || || || || ||
|-
|-
|Route ||O ||STRING || || || || ||
|Carrier
|i_carrier_id ||O || || || || || ||
|-
|-
|Depot ||O ||STRING || || || || ||
|Group Name
|i_group_name ||M || || || || || ||
|}
 
==ISC Finance (2) Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O ||STRING || || || || ||
|ISC Finance (2)  Export
|FINANCE_2_EXPORT
|DP_CSV2.FINANCE_EXPORT_V2
|}
|}
==PAYMENT_DTLS==
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 Date ||M ||TODAY || || || || ||
|Customer
|I_CUSTOMER ||M ||STRING ||ALL || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Start Schedule
|I_FROM_SCHED_NAME ||M || || || || || ||
|-
|-
|Customer ||M || || || || || ||
|End Schedule
|I_TO_SCHED_NAME ||M || || || || || ||
|}
|}


==POC to SAP Extract==
== ISC Finance (3) Export ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|ISC Finance (3)  Export
|FINANCE_2_EXPORT
|CSV6.ISC_FINANCE_2_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
|-
|Customer ||I_CUSTOMER ||M ||STRING || ALL|| || ||
|
|-
|Start Schedule ||I_FROM_SCHED_NAME || M|| || || || ||
|
|-
|-
|End Schedule ||I_TO_SCHED_NAME || M|| || || || ||
|
|}
|}


==POC to SAP Extract(A)==
== ISC Finance (4) Export ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Resend All? ||M ||STRING ||No || || || ||
|ISC Finance (4)  Export
|FINANCE_2_EXPORT
|CSV7.FINANCE_EXPORT_V2
|}
|}
==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
|-
|-
|From Schedule ||M || || || || || ||
|Customer ||I_CUSTOMER ||M ||STRING || ALL|| || ||
|
|-
|-
|To Schedule ||M || || || || || ||
|Start Schedule ||I_FROM_SCHED_NAME || M|| || || || ||
|
|-
|-
|Del Msg Sent ||O ||STRING ||ALL || || || ||
|End Schedule ||I_TO_SCHED_NAME || M|| || || || ||
|
|}
 
==Interface Errors Failures==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|POD Status ||O ||STRING ||ALL || || || ||
|Interface Errors  Failures
|Interface_Errors_Failures
|DP_CSV5.INTERFACE_ERRORS_FAILURES
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Carrier ||O ||STRING ||ALL || || || ||
|Source System
|P_SOURCE_SYSTEM ||O || || || Source System|| || ||
|-
|-
|> Days Outstanding ||O ||STRING ||0 || || || ||
|Customer
|P_CUSTOMER ||O || || ||Customer || || ||
|-
|-
|Group ||O ||STRING ||ALL || || || ||
|External Ref
|P_EXTERNAL_REF ||O || STRING|| || || || ||
|-
|-
|Customer ||O ||STRING ||ALL || || || ||
|End Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|-
|-
|Scanning Depot ||O ||STRING ||ALL ||Depot ||Location Id ||Name ||
|Start Date
|P_START_DATETIME ||M ||TODAY || || || || ||
|}
|}


==POD Generation Extract==
==Invalid Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Invalid Orders
|Invalid_Orders
|DP_CSV6.INVALID_ORDERS
|}
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
|-
|-
|POD Flow ||M || || || || || ||
|Customer
|i_customer ||0 || || || || || ||
|-
|-
|Date To ||M ||TODAY || || || || ||
|End Schedule
|i_end_sched ||M || || || || || ||
|-
|-
|Date From ||M ||TODAY || || || || ||
|Start Schedule
|i_start_sched ||M || || || || || ||
|}
 
==Item Movements==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||O || || || || || ||
|Item Movements
|ITEM_MOVEMENTS_EXTRACT
|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT
|}
|}
==POD to SAP 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
|-
|-
|Actual From Date
|P_START_DATETIME ||M ||TODAY || || || || ||
|-
|Actual To Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|-
|Supplier
|P_SUPPLIER ||O || || || || || ||
|-
|DU Type
|P_DU_TYPE ||O || || || || || ||
|-
|Manifest Number
|P_MANF_NO ||O || || || || || ||
|-
|P/O Number
|P_PO_NO ||O || || || || || ||
|-
|Store
|P_STORE ||O || || || || || ||
|}
|}


==POD to SAP Extract(A)==
==Item Movements 2==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Resend All? ||M ||STRING ||No || || || ||
|Item Movements 2
|ITEM_MOVEMENTS_2_EXTRACT
|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2
|}
|}
==PORSCHE19 Invoice 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
|-
|Actual From Date ||P_START_DATETIME || M|| TODAY|| || || ||
|
|-
|-
|Customer ||M ||STRING ||PORSCHE19 || || || ||
|Actual To Date ||P_END_DATETIME || M|| TODAY|| || || ||
|
|-
|-
|Sub Debit Account ||O ||STRING ||ALL || || || ||
|Supplier ||P_SUPPLIER ||O || || || || ||
|
|-
|-
|Trip ID ||O ||STRING ||ALL || || || ||
|DU Type ||P_DU_TYPE ||O || || || || ||
|
|-
|-
|Sub Credit Account ||O ||STRING ||ALL || || || ||
|Manifest Number ||P_MANF_NO || O|| || || || ||
|
|-
|-
|Invoice ID ||O ||STRING ||0 || || || ||
|P/O Number ||P_PO_NO || O|| || || || ||
|
|-
|-
|Export ID ||O ||STRING ||0 || || || ||
|Store ||P_STORE || O|| || || || ||
|
|}
|}


==PROVIDER_REVENUE== || ||Owning Depot ||O || || || || || ||
==Item Movements 3==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Schedule ||M || || || || || ||
|Item Movements 3
|-
|ITEM_MOVEMENTS_3_EXTRACT
|From Schedule ||M || || || || || ||
|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3
|}
|}
==Parts and Empites==
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
|-
|Actual From Date ||P_START_DATETIME || M|| TODAY|| || || ||
|
|-
|-
|Export Type ||M || || || || || ||
|Actual To Date ||P_END_DATETIME || M|| TODAY|| || || ||
|
|-
|-
|Schedule From ||M || || || || || ||
|Supplier ||P_SUPPLIER || O|| || || || ||
|
|-
|-
|Schedule To ||M || || || || || ||
|DU Type ||P_DU_TYPE || O|| || || || ||
|
|-
|-
|Location From ||O || || || || || ||
|Manifest Number ||P_MANF_NO || O|| || || || ||
|
|-
|-
|Customer ||M || || || || || ||
|P/O Number ||P_PO_NO ||O || || || || ||
|}
|
 
==PostCode Matrix==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Store ||P_STORE ||O || || || || ||
|
|}
|}


==Pre Invoice Check==
==Items Not Scanned By Date==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cut-off Date ||M ||TODAY || || || || ||
|Items Not Scanned  By Date
|Items_Not_Scanned
|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE
|}
|}
==Process Items Interface Audit==
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
|-
|-
|Incl. Reprocessed ||M ||STRING ||N || || || ||
|Depot
|P_DEPOT ||M || || || || || ||
|-
|-
|Start Date ||M ||TODAY || || || || ||
|Schedule To
|P_END_SCHED ||M || || || || || ||
|-
|-
|End Date ||M ||TODAY || || || || ||
|Schedule From
|-
|P_START_SCHED ||M || || || || || ||
|Record Status ||M ||STRING ||ALL || || || ||
|}
|}


==Provisional Booking Exceptions==
==Items Not Scanned By Trip==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Items Not Scanned  By Trip
|Items_Not_Scanned
|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP
|}
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 || || || || ||
|Schedule
|P_SCHED ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Trip
|P_TRIP_ID ||M || || || || || ||
|}
|}


==Purchase Order Extract==
==JEYES Interface Results==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|JEYES Interface  Results
|JEYES_interface_results
|CSV.JEYES_if_res
|}
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
|-
|-
|Status ||O ||STRING ||All || || || ||
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|Depot
|i_depot ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY ||TODAY || || || ||
|From Date
|i_from_date ||O || TODAY|| || || || ||
|-
|-
|From Date ||O ||TODAY ||TODAY || || || ||
|To Date
|i_to_date ||O ||TODAY || || || || ||
|}
|}


==Reason Listings==
==Job Notes==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Date From ||M ||DATETIME ||TODAY:00:01 || || || ||
|Job Notes
|-
|Job_Notes
|Depot ||M || || || || || ||
|DP_CSV5.JOB_NOTES
|-
|Date To ||M ||DATETIME ||TODAY:23:59 || || || ||
|}
|}
==Receipt Scanning==
Parameters:
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Title
|-
!Name
|Dealer ||O ||STRING || || || || ||
!Mand
|-
!Def Type
|Route ||O ||STRING || || || || ||
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|-
|Media Type ||O ||STRING || || || || ||
|Date from
|i_date_from
|M
|
|
|
|
|
|
|-
|-
|Customer ||O ||STRING || || || || ||
|OMS Ref To
|i_oms_to
|O
|
|
|
|
|
|
|-
|-
|Date To ||M ||TODAY || || || || ||
|OMS Ref From
|i_oms_from
|O
|
|
|
|
|
|
|-
|-
|Date From ||M ||TODAY || || || || ||
|Date to
|i_date_to
|M
|
|
|
|
|
|
|-
|-
|Depot ||O ||STRING || || || || ||
|Customer
|i_customer
|O
|
|
|
|
|
|
|}
|}


==Receiving Extract==
==KPI By Lane==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|KPI By Lane
|KPI_BY_LANE
|CSV.KPI_BY_LANE
|}
|}
==Revenue Check (Account)==
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 Date ||M ||TODAY || || || || ||
|Start Date
|I_START_DATE_TIME ||M || TODAY|| || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Tolerance(days)
|I_TOLERANCE ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Customer Group
|I_CUST_GROUP ||O || || || || || ||
|-
|-
|Cust Group ||O || || || || || ||
|End Date
|I_END_DATE_TIME ||M ||TODAY || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Grouping
|I_GROUP_BY ||M ||STRING || CUST_GROUP|| || || ||
|}
|}


==SMS Email Summary Report==
==KPI Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Date ||M ||TODAY || || || || ||
|KPI Extract
|-
|CN_KPI_Extract
|Cost Centre ||M ||STRING ||ALL || || || ||
|KPI_EXTRACT.KPI_EXTRACT
|}
|}
==STL Trip and Order 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
|-
|-
|Start Trip Schedule ||M || || || || || ||
|Owning Depot
|i_owning_depot ||O || || || Depot|| Location Id|| Name||
|-
|-
|End Trip Schedule ||M || || || || || ||
|Start Schedule
|i_start_sched
|M
|
|
|
|
|
|
|-
|-
|Order Status ||O || || || || || ||
|Group Name
|i_group_name
|O
|STRING
|ALL
|
|
|
|
|-
|-
|Carrier ||O || || || || || ||
|End Schedule
|i_end_sched
|M
|
|
|
|
|
|
|}
==Kraft KPI==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Location Type ||O || || || || || ||
|Kraft KPI
|KRAFT_KPI
|CSV.Trips_with_Orders
|}
|}
==Sales Margin 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 Group ||O || || || || || ||
|From Date
|I_START_DATETIME ||M ||TODAY || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|To Date
|I_END_DATETIME ||M ||TODAY || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Cost Centre
|-
|I_COST_CENTRE ||O || || || || || ||
|Last Schedule ||O || || || || || ||
|}
 
==LFS Packages==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|LFS Packages
|LFS_Packages
|DP_CSV_LFS.LFS_PACKAGES
|}
|}
==Savings 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
|-
|-
|To Date ||O ||TODAY || || || || ||
|External Ref
|i_ext_ref ||O || || || || || ||
|-
|-
|Credit Acc ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Schedule
|i_sched ||M || || || || || ||
|-
|-
|To Cty Code ||O || || || || || ||
|Order Status
|i_ord_status ||O || || || || || ||
|}
 
==Lane Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|From Cty Code ||O || || || || || ||
|Lane Extract
|Lane_Extract
|CSV.LANE_EXPORT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Lane Id ||O || || || || || ||
|From Loc
|p_from_loc ||O || || || From Loc|| Location Id|| Name||
|-
|-
|From Date ||O ||TODAY || || || || ||
|To Loc
|p_to_loc ||O || || || To Loc|| Location  Id|| Name||
|-
|-
|Debit Acc ||O || || || || || ||
|Customer
|p_customer ||O || || || || || ||
|-
|-
|Saving (> or <) ||O ||STRING || || || || ||
|Cost Centre
|p_cost_centre ||O || || || || || ||
|}
|}


==Schedule==
==Left Offs==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Left Offs
|LEFT_OFFS_EXTRACT
|DP_CSV_GEN.LEFT_OFFS_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
|-
|-
|From Date ||M ||TODAY || || || || ||
|Trip ID (optional)
|P_TRIP_ID ||O || || || || || ||
|-
|Store (optional)
|P_STORE ||O || || || Store|| Location  ID|| Name||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Days Back
|P_DAYS_BACK ||M || STRING|| 30|| || || ||
|}
|}


==Schedule Details==
==Loading Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Start Schedule ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|-
|End Schedule ||M || || || || || ||
|Loading Extract
|LOADING_EXTRACT
|DP_CSV_GEN.EXT_LOADING
|}
|}
==Schedule Trips CS==
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 || || || || || ||
|Schedule
|P_SCHED_DATE ||M || || || || || ||
|}
|}


==Schedule Trips CS==
==Loading Schedule CSV==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|Loading Schedule CSV
|Loading_Schedule
|CSV.LOADING_SCHEDULE
|}
|}
==Scheduled and Cancelled Orders==
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 ||M || || || || || ||
|To Date
|-
|i_End_Time ||M || TODAY|| || || || ||
|Last Schedule ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|From Date
|i_Start_Time ||M ||TODAY || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Depot
|i_Depot ||M || || || Depot|| Location  Id|| Name||
|}
|}


==Scheduled and Cancelled Orders v2
==Location Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|Location Export
|Location_Export
|DP_CSV2.LOCATION_EXPORT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Customer ||O || || || || || ||
|Location Group
|I_CUST_GROUP ||O || || || || || ||
|-
|-
|Last Schedule ||O || || || || || ||
|Country
|i_country
|O
|
|
|
|
|
|
|}
 
==Location Export GL==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer Group ||O || || || || || ||
|Location Export GL
|Location_Export
|CSV.LOCATION_EXPORT_GL
|}
No parameters
==Location Export GPR==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Location Export GL
|Location_Export
|CSV.LOCATION_EXPORT_GPR
|}
No parameters.
==Location Pre-Warning==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier Group ||O || || || || || ||
|Location  Pre-Warning
|Loc_Del_Pre_Warn
|CSV.Loc_Del_Pre_Warning
|}
|}
==Short Rail 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
|-
|-
|Cost Centre ||O || || || || || ||
|Depot
|i_depot ||M || || || Depot|| Location Id|| Name||
|-
|From Date
|i_start_date_time ||M ||TODAY || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|Load Type
|i_load_type ||M ||STRING || ALL|| || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|To Date
|i_end_date_time ||M ||TODAY || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Trip Status
|i_trip_status ||M ||STRING || ALL|| || || ||
|}
|}


==Slot Extract==
==MDD Code 03 Exceptions==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|MDD Code 03  Exceptions
|MDD Code 03 Exceptions
|CSV.MDD_Code_03_Exceptions
|}
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
|-
|-
|Day ||O ||String ||ALL || || || ||
|From Date
|-
|P_START_DATETIME ||M ||TODAY || || || || ||
|Slot Type ||O ||String ||ALL || || || ||
|-
|-
|Location Type ||O ||String ||ALL || || || ||
|To Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|}
|}


==Store PVA || ||Del
==MTS Finance Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|ivery Date ||M || || || || || ||
|MTS Finance Export
|FINANCE_EXPORT
|CSV.finance_export_v2
|}
|}
==Store Pre Warning==
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
|-
|-
|Show empty Slots ||O ||STRING ||N || || || ||
|End Schedule
|i_to_sched_name
|M
|
|
|
|
|
|
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|Start Schedule
|i_from_sched_name
|M
|
|
|
|
|
|
|-
|-
|Store ||O || || ||Store ||Location Id ||Name ||
|Customer
|I_CUSTOMER
|M
|STRING
|ALL
|
|
|
|
|}
 
==MTS Finance Export V2==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Sched Name ||M || || || || || ||
|MTS Finance Export
|FINANCE_EXPORT_V2
|CSV.finance_export_v2
|}
|}
==Sub Contractor==
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 Sched ||M || || || || || ||
|End Schedule
|i_to_sched_name
|M
|
|
|
|
|
|
|-
|-
|Cost Centre ||M || || || || || ||
|Start Schedule
|i_from_sched_name
|M
|
|
|
|
|
|
|-
|-
|From Sched ||M || || || || || ||
|Customer
|I_CUSTOMER
|M
|STRING
|ALL
|
|
|
|
|}
|}


==Supplier DUs==
==Manual Loaded Items==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Manual Loaded Items
|MANUAL_LOADED_ITEMS_EXTRACT
|DP_CSV_GEN.MANL_SCAN_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
|-
|-
|To ||M || ||TODAY || || || ||
|From Date
|P_START_DATE ||O || || || || || ||
|-
|-
|From ||M || ||TODAY || || || ||
|To Date
|P_END_DATE ||O || || || || || ||
|}
|}


==Supplier DUs By Store==
==Master and Child Locations==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Master and Child  Locations
|Master_and_Child
|DP_CSV5.MASTER_AND_CHILD
|}
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 ||
|Show Mapped
|-
|P_SHOW_MAPPED ||O || || ||Show Mapped || || ||
|Order Status ||O || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Show UnMapped
|P_SHOW_UNMAPPED ||O || || ||Show  UnMapped || || ||
|}
|}


==Supplier Invoice==
== Message Maintenance ==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Date ||O || || || || || ||
|Message Maintenance
|-
|Message_Maintenance
|End Date ||O || || || || || ||
|CSV.msg_maint
|-
|}
|Invoice ID ||O ||STRING || || || || ||
No parameters
|-
==Missing Lat Long Report==
|End Date ||O || || || || || ||
{| class="wikitable"
|-
!'''Report Name'''
|Invoice ID ||O ||STRING || || || || ||
!'''Filename'''
|-
!'''Procedure for Scheduling'''
|Start Date ||O || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Missing Lat Long  Report
|MISSING_LAT_LONGS
|dp_csv3.missing_lat_long_extract
|}
|}
==Supplier Revenue 2==
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
|-
|-
|Revenue Start ||M || ||TODAY || || || ||
|Cost Centre
|-
|i_cost_centre ||M || ||ALL || || || ||
|Revenue End ||M || ||TODAY || || || ||
|}
|}


==TYRE SUMMARY EXTRACT==
==Missing Steps Report==
{{Note}} Can be run from Trip Waterfall screen.
 
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|Missing Steps  Report
|Missing_Steps_Report
|DP_CSV5.Missing_Steps_Report
|}
|}
==Trip Actuals==
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 ||M || || || || || ||
|Missing Step
|i_step ||O ||STRING || ALL|| || || ||
|-
|To Date
|i_date_to ||M ||TODAY || || || || ||
|-
|From Date
|i_date_from ||M ||TODAY || || || || ||
|}
|}


==Trip Assessment Extract==
==Month End Accruals==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|Month End Accruals
|month_end_accruals
|dp_csv_nr.month_end_accruals
|}
|}
==Trip 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 || || || || || ||
|From Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|-
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Cust Group
|i_cust_group ||O || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Customer
|i_customer ||O || || || || || ||
|}
|}


==Trip and Order Detail Extract==
==NR Additional Report==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|NR Additional  Report
|-
|nr_additional_rep
|End Schedule ||M || || || || || ||
|dp_csv_nr.nr_additional_report
|-
|}
|Location Type ||M || ||ALL || || || ||
No parameters
==NR Finance Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Start Schedule ||M || || || || || ||
|NR Finance Extract
|NR_Finance_Extract
|DP_CSV_NR.NR_FINANCE_EXTRACT
|}
|}
==Trunking 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
|-
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|Debriefed
|i_debriefed ||M || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|From Date
|i_from_date ||M || TODAY|| || || || ||
|-
|Carrier
|i_carrier ||O || || || || || ||
|-
|To Region
|i_to_region ||M ||STRING ||ALL || || || ||
|-
|From Region
|i_from_region ||M ||STRING || ALL|| || || ||
|-
|Carrier Group
|i_carrier_group ||O || || || || || ||
|-
|Strategy
|i_strategy ||O || || || || || ||
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Report Type ||M ||STRING ||Revenue || || || ||
|To Date
|i_to_date ||M ||TODAY || || || || ||
|}
|}


==UNISON Interface Results==
==NR Invoice==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|NR Invoice
|NR_Invoice
|DP_CSV_NR.NR_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
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|From Date
|i_from_date ||M ||TODAY || || || || ||
|-
|Carrier
|i_carrier ||O || || || || || ||
|-
|To Region
|i_to_region ||M || STRING|| ALL|| || || ||
|-
|From Region
|i_from_region ||M || STRING|| ALL|| || || ||
|-
|Debriefed
|i_debriefed ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Strategy
|i_strategy ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Customer
|}
|i_customer ||O || || || || || ||
 
==User Activity Extract==
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date
|i_to_date ||M || TODAY|| || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Carrier Group
|i_carrier_group ||O || || || || || ||
|}
|}


==User Last Logon Extract==
==OPS KPI Extract==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Days since logon ||M ||STRING ||90 || || || ||
|OPS KPI Extract
|OPS_KPI_Extract
|KPI.KPI_OPS_EXTRACT
|}
|}
==Variance Analysis Store Detail==
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 || || || || || ||
|Cost Centre
|i_cost_centre
|O
|
|ALL
|
|
|
|
|-
|To Date
|i_date_to
|M
|TODAY
|
|
|
|
|
|-
|From Date
|i_date_from
|M
|TODAY
|
|
|
|
|
|-
|Client
|i_client
|O
|
|ALL
|
|
|
|
|-
|Carrier
|i_carrier
|O
|
|ALL
|
|
|
|
|-
|Depot
|i_depot
|O
|
|ALL
|
|Location  Id
|Name
|
|-
|Date Range Type
|i_date_type
|M
|String
|
|
|
|
|
|}
|}


==Variance Analysis Summary==
==OPS KPI Extract2==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|OPS KPI Extract2
|OPS_KPI_Extract
|KPI.KPI_OPUS_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
|-
|Cost Centre
|i_cost_centre
|O
|
|ALL
|
|
|
|
|-
|To Date
|i_date_to
|M
|TODAY
|
|
|
|
|
|-
|From Date
|i_date_from
|M
|TODAY
|
|
|
|
|
|-
|Client
|i_client
|O
|
|ALL
|
|
|
|
|-
|Carrier
|i_carrier
|O
|
|ALL
|
|
|
|
|-
|-
|To Date ||M ||TODAY || || || || ||
|Depot
|i_depot
|O
|
|ALL
|
|Location  Id
|Name
|
|-
|-
|From Date ||M ||TODAY || || || || ||
|Date Range Type
|i_date_type
|M
|String
|
|
|
|
|
|}
|}


==Variance Analysis Trip Detail==
==OTM Export==
Parameters:
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule ||M || || || || || ||
|OTM Export
|OTM_Export
|DP_CSV_DHL.OTM_EXPORT
|}
|}
==Vehicle 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
|-
|-
|Start Schedule ||M || || || || || ||
|Date To
|i_date_to ||M ||TODAY || || || || ||
|-
|Carrier
|i_carrier ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Date From
|i_date_from ||M || TODAY|| || || || ||
|}
|}


==Vehicle Utilisation Heavy==
==On Time Arrivals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|On Time Arrivals
|ON_TIME_ARRIVALS
|DP_CSV6.ON_TIME_ARRIVALS
|}
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 || || || || || ||
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Outbase
|i_depot ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Route Code
|i_route ||O || || || || || ||
|-
|Media Type
|i_media ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Dealer
|i_dealer ||O || || || || || ||
|}
|}


==Vehicle Utilisation Non-Heavy==
==On Time Drops==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|On Time Drops
|ON_TIME_DROPS
|DP_CSV6.ON_TIME_DROPS
|}
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 Group ||O || || || || || ||
|Route Code
|i_route ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Outbase
|i_depot ||O || || || || || ||
|-
|Dealer
|i_dealer ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Media Type
|i_media ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|-
|Carrier Code ||O || || || || || ||
|Schedule To
|i_sched_to ||M || || || || || ||
|}
|}


==Volume Deviation Extract==
==On Time Items==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|On Time Items
|ON_TIME_ITEMS
|DP_CSV6.ON_TIME_ITEMS
|}
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 || ||ALL || || || ||
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Schedule ||O || || || || || ||
|Media Type
|i_media ||O || || || || || ||
|-
|-
|Cost Centre ||O || ||ALL || || || ||
|Route Code
|i_route ||O || || || || || ||
|-
|-
|Trip Leg ||O ||STRING ||ALL || || || ||
|Dealer
|i_dealer ||O || || || || || ||
|-
|-
|Include Unpacked ||O ||STRING ||Y || || || ||
|Outbase
|i_depot ||O || || || || || ||
|}
 
==On Time Items (Assets)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Deviation ||O ||STRING ||ALL || || || ||
|On Time Items  (Assets)
|ON_TIME_ITEMS
|DP_CSV6.ON_TIME_ITEMS_ASSETS
|}
|}
==Volume or Activity==
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 From ||M || || || || || ||
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Route Code
|i_route ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Outbase
|i_depot ||O || || || || || ||
|-
|-
|Dealer ||O || || || || || ||
|Dealer
|i_dealer ||O || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|Customer
|i_customer ||O || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Media Type
|i_media ||O || || || || || ||
|}
|}


==WCS Order Items Extract==
==On Time Returns==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|On Time Returns
|ON_TIME_RETURNS
|DP_CSV6.ON_TIME_RETURNS
|}
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 Date ||M ||TODAY || || || || ||
|Route Code
|i_route ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Media Type
|i_media ||O || || || || || ||
|-
|-
|Order ||O ||STRING || || || || ||
|Outbase
|i_depot ||O || || || || || ||
|-
|-
|Trip ||O ||STRING || || || || ||
|Dealer
|i_dealer ||O || || || || || ||
|-
|Customer
|i_customer ||O || || || || || ||
|-
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|Schedule From
|i_sched_from ||M || || || || || ||
|}
|}


==Weekly Transport Report ==
==Operational Information==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Operational  Information
|Operational_Information
|DP_CSV2.OPERATIONAL_INFO
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date
|P_END_DATE ||M || TODAY|| || || || ||
|-
|POD
|P_POD
|O
|
|
|
|
|
|
|-
|Carrier
|I_FROM_LOC
|O
|
|
|Carrier
|Carrier  Name
|Carrier  ID
|
|-
|Location From
|P_FROM_LOC
|O
|STRING
|
|Location  From
|Location  ID
|Name
|
|-
|From Date
|P_START_DATE
|M
|TODAY
|
|
|
|
|
|}
==Order Charges Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Order Charges  Extract
|ORD_CHARGE
|DP_CSV5.ORD_CHARGE_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 Sched ||M || || || || || ||
|Date
|P_DELIVERY_DATE ||M ||TODAY || || || || ||
|}
 
==Order Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Order Extract
|ORDER_EXTRACT.csv
|DP_CSV2.HCR_ORDER_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Sched ||M || || || || || ||
|Start Sched
|P_START_SCHED ||M || || || || || ||
|-
|-
|Carrier ||ALL || || || || ||
|End Sched
|P_END_SCHED ||M || || || || || ||
|}
 
==Order Interface Results==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Order Interface  Results
|ORDER_INTERFACE_RESULTS
|CSV.ORDER_INTERFACE_RESULTS
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date
|i_to_date ||O || TODAY|| || || || ||
|-
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|From Date
|i_from_date ||O ||TODAY || || || || ||
|-
|Depot
|i_depot ||O || || || || || ||
|-
|
|Message Type ||O || || || || || ||
|}
 
==Order Items POD Debriefed==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Order Items POD  Debriefed
|Order_Items_POD_Debriefed
|DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED
|}
Parameters:
{| class="wikitable"
!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 ||O || || || || || ||
|-
|Customer
|P_CUSTOMER ||O || || || || || ||
|}
 
==Order Savings==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Order Savings
|ORDER_SAVINGS
|CSV.Order_savings
|}
Parameters:
{| class="wikitable"
!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 ||O || || || || || ||
|-
|Show Neg Savings
|p_show_only_negative ||M || || || || || ||
|}
 
==Order Tracking==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Order Tracking
|Order_Tracking
|DP_CSV5.ORDER_TRACKING
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Month
|P_MONTH ||M || || || || || ||
|-
|Week Offset
|P_WEEK_OFFSET ||O || || || || || ||
|-
|Year
|P_YEAR ||M || || || || || ||
|-
|Customer
|P_CUSTOMER ||O || STRING|| OPENFIELD|| || || ||
|-
|Cost Centre
|P_COST_CENTRE ||O ||STRING ||EXEL || || || ||
|}
 
==Orders for Relabelling==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Orders for  Relabelling
|ORDERS_FOR_RELABELLING
|DP_CSV_DHL.ORDERS_FOR_RELABELLING
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|p_schedule ||M || || || || || ||
|}
 
== Orders to LogiX ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Orders to LogiX
|LogiX_Orders
|DP_LOGIX.ORDER_EXPORT
|}
No parameters
==Orders to Paragon==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Orders to Paragon
|Paragon_Orders
|CSV.Orders_to_Paragon
|}
No parameters
==Outbound Shortage==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Outbound Shortage
|OUTBOUND_SHORTAGE
|DP_CSV6.OUTBOUND_SHORTAGE
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Dealer
|i_dealer ||O || STRING|| || || || ||
|-
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|Customer
|i_customer ||O ||STRING || || || || ||
|-
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|Depot
|i_depot ||O ||STRING || || || || ||
|-
|Route
|i_route ||O ||STRING || || || || ||
|-
|Media Type
|i_media_type ||O ||STRING || || || || ||
|}
 
==PAYMENT_DTLS==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|PAYMENT_DTLS
|PAYMENT_DTLS
|OF_INT.WRITE_PAYMENT_DETAILS
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Customer
|i_cust ||M || || || || || ||
|-
|From Date
|i_from_date ||M ||TODAY || || || || ||
|-
|End Date
|i_to_date ||M || TODAY|| || || || ||
|}
 
==POC to SAP Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|POC to SAP Extract
|POC to SAP Extract
|CSV.POC_to_Sap_Extract
|}
No parameters
==POC to SAP Extract(A)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|POC to SAP  Extract(A)
|POC to SAP Extract(A)
|CSV.POC_to_Sap_Extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Resend All?
|p_resend_flag ||M ||STRING ||No || || || ||
|}
 
==POC-POD  Reprocessing Team Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|POC-POD  Reprocessing Team Export
|POC_POD_REPOROCESSING
|DP_CSV.POC_POD_REPROCESSING
|}
Parameters:
{| class="wikitable"
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|To Date
|P_END_DATETIME
|M
|YESTERDAY
|YESTERDAY
|
|
|
|
|-
|Date From
|P_START_DATETIME
|M
|TODAY
|YESTERDAY:20:00
|
|
|
|
|}
 
==POD Delivery Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|POD Delivery  Extract
|POD_Delivery_Extract
|DP_CSV2.POD_DELIVERY_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Customer Group
|p_group_name ||O || STRING|| ALL|| || || ||
|-
|Scanning Depot
|p_scan_depot ||O || STRING|| ALL|| Depot|| Location  Id|| Name||
|-
|> Days Outstanding
|p_outstanding ||O ||STRING ||0 || || || ||
|-
|POD Status
|p_pod ||O ||STRING ||ALL || || || ||
|-
|Carrier
|p_carrier ||O ||STRING ||ALL || || || ||
|-
|To Schedule
|p_to_date ||M || || || || || ||
|-
|From Schedule
|p_from_date ||M || || || || || ||
|-
|Customer
|p_customer ||O ||STRING ||ALL || || || ||
|-
|Del Msg Sent
|p_del_msg_sent ||O ||STRING ||ALL || || || ||
|}
 
==POD Generation Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|POD Generation  Extract
|POD_GEN
|DP_CSV5.POD_REPORT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|POD Flow
|P_FLOW ||M || || || || || ||
|-
|Schedule
|P_SCHED ||O || || || || || ||
|-
|Date From
|P_DATE_FROM ||M ||TODAY || || || || ||
|-
|Date To
|P_DATE_TO ||M || TODAY|| || || || ||
|}
 
==POD to SAP Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|POD to SAP Extract
|POD to SAP Extract
|CSV.POD_to_Sap_Extract
|}
No parameters
==POD to SAP Extract(A)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|POD to SAP  Extract(A)
|POD to SAP Extract(A)
|CSV.POD_to_Sap_Extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Resend All?
|p_resend_flag ||M ||STRING ||No || || || ||
|}
 
==PORSCHE19 Invoice Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|PORSCHE19 Invoice  Extract
|Invoice_Extract
|DP_CSV2.Invoice_Extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Sub Credit Account
|p_sub_credit_acc ||O ||STRING ||ALL || || || ||
|-
|Trip ID
|p_trip ||O ||STRING ||ALL || || || ||
|-
|Export ID
|p_export ||O ||STRING ||0 || || || ||
|-
|Customer
|p_customer ||M ||STRING ||PORSCHE19 || || || ||
|-
|Sub Debit Account
|p_sub_debit_acc ||O ||STRING ||ALL || || || ||
|-
|Invoice ID
|p_invoice ||O ||STRING ||0 || || || ||
|}
 
== PROVIDER_REVENUE ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|PROVIDER_REVENUE
|PROVIDER_REVENUE
|dp_csv3.provider_revenue
|}
Parameters:
{| class="wikitable"
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|Owning Depot
|P_OWNING_DEPOT
|O
|
|
|
|
|
|
|-
|From Schedule
|P_START_SCHED
|M
|
|
|
|
|
|
|-
|To Schedule
|P_END_SCHED
|M
|
|
|
|
|
|
|}
 
==Parts and Empties==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Parts and Empites
|Parts_and_Empties
|DP_CSV5.PARTS_AND_EMPTIES
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule From
|P_SCHED_FROM ||M || || || || || ||
|-
|Schedule To
|P_SCHED_TO ||M || || || || || ||
|-
|Location From
|P_LOCATION ||O || || || || || ||
|-
|Export Type
|P_EXPORT_TYPE ||M || || || || || ||
|-
|Customer
|P_CUSTOMER ||M || || || || || ||
|}
 
==PostCode Matrix==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|PostCode Matrix
|POSTCODE_MATRIX
|dp_csv3.postcode_matrix
|}
No parameters
==Pre Invoice Check==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Pre Invoice Check
|Pre_Invoice_Check
|CSV.PRE_INVOICE_CHECK
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Cut-off Date
|i_cutoff_date ||M ||TODAY || || || || ||
|}
 
==Process Items Audit==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Process Items Audit
|PROCESS_ITEMS_AUDIT
|DP_CSV6.PROCESS_ITEMS_AUDIT
|}
Parameters:
{| class="wikitable"
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|Record Status
|i_record_status
|M
|STRING
|ALL
|
|
|
|
|-
|End Date
|i_end_datetime
|M
|TODAY
|
|
|
|
|
|-
|Start Date
|i_start_datetime
|M
|TODAY
|
|
|
|
|
|-
|Incl. Reprocessed
|i_incl_reprocessed
|M
|STRING
|N
|
|
|
|
|}
 
==Process Items Interface Audit==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Process Items  Interface Audit
|PROCESS_ITEMS_INTERFACE_AUDIT
|DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Incl. Reprocessed
|i_incl_reprocessed ||M ||STRING ||N || || || ||
|-
|Record Status
|i_record_status ||M ||STRING || ALL|| || || ||
|-
|End Date
|i_end_datetime ||M ||TODAY || || || || ||
|-
|Start Date
|i_start_datetime ||M ||TODAY || || || || ||
|}
 
==Provisional Booking Exceptions==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Provisional Booking  Exceptions
|Provisional Booking Exceptions
|CSV.Provisional_Booking_Exceptions
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date
|P_START_DATETIME ||M ||TODAY || || || || ||
|-
|To Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|}
 
==Purchase Order Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Purchase Order  Extract
|po_extract
|DP_CSV2.PURCHASE_ORDER_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date
|i_end_date ||O ||TODAY ||TODAY || || || ||
|-
|From Date
|i_start_date ||O ||TODAY ||TODAY || || || ||
|-
|Status
|i_status_id ||O ||STRING ||All || || || ||
|}
 
==Reason Listings==
This extract reports on the Items and Items Reasons. That will include all scanning events from WCS, MCS, EPOD and APOD.
 
{{Note}} The report is based off the actual arrival date/time and the depot. If the trip for that depot and order has not been debriefed yet, then the items and reasons will not be displayed.
 
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Reason Listings
|REASON_LISTING_
|dp_csv3.reasons_listing
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Date To
|p_end_datetime ||M ||TODAY ||TODAY:00:01 || || || ||
|-
|Depot
|p_depot ||M || || || || || ||
|-
|Date From
|p_start_datetime ||M ||TODAY ||TODAY:23:59 || || || ||
|}
 
Columns:
* Trip - the trip on which the item was moved.
* Route - the route (if present) from the trip.
* Stop Name - the location name.
* PO Reference - the order's booking reference.
* Customer Reference - the order's eternal reference.
* Reason Code - the reason code.
* Reason Text - the reason description.
* Comment User - any comment against that item reason.
* Line DU - the item type.
* Line Planned Qty - the planned quantity in total of that type.
* Line Delivered Qty - the delivered quantity in total of that type.
* Line Variance - any variance between the quantity in total of that type.
* Item ID - the individual item ID.
* Item Desc - the description of that item.
* Item Planned Qty - the planned quantity of that item.
* Item Delivered Qty - the delivered quantity of that item.
* Item Variance - any variance between the planned and delivered quantity of that item.
 
==Receipt Scanning==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Receipt Scanning
|RECEIPT_SCANNING
|DP_CSV6.RECEIPT_SCANNING
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Depot
|i_depot ||O ||STRING || || || || ||
|-
|Dealer
|i_dealer ||O ||STRING || || || || ||
|-
|Media Type
|i_media_type ||O ||STRING || || || || ||
|-
|Route
|i_route ||O ||STRING || || || || ||
|-
|Customer
|i_customer ||O ||STRING || || || || ||
|-
|Date To
|i_date_to ||M ||TODAY || || || || ||
|-
|Date From
|i_date_from ||M ||TODAY || || || || ||
|}
 
==Receiving Extract==
This is an extract of unloaded items at the depot.
 
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Receiving Extract
|RECEIVING_EXTRACT
|DP_CSV_GEN.EXT_RECEIVING
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|P_SCHED_DATE ||M || || || || || ||
|}
The report shows a summary per date in the selection, and the details in the selection. Both sections contains the same fields:
* Date
* Customer
* Dealer
* Dealer Name
* Origin Depot
* Depot Name
* Route Code
* Media Type
* Asset
* Child Asset
* Pallet ID
* Item Weight
* Item Volume
* Items Created
* Positive Load Scan
* Variance
 
==Revenue Check (Account)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Revenue Check  (Account)
|revenue_report
|dp_csv_nr.revenue_report
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|-
|From Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|-
|Customer
|i_customer ||O || || || || || ||
|-
|Cust Group
|i_cust_group ||O || || || || || ||
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|}
 
==SMS Email Summary Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|SMS Email Summary  Report
|sms_email_summary
|DP_CSV5.SMS_EMAIL_SUMMARY
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date
|I_DATE_FROM ||M ||TODAY || || || || ||
|-
|Cost Centre
|I_COST_CENTRE ||M ||STRING ||ALL || || || ||
|}
 
==STL Trip and Order Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|STL Trip and Order  Extract
|STL_Trip_Order_Extract
|DP_CSV2.STL_TRIP_ORDER_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Order Status
|I_ORDER_STATUS ||O || || || || || ||
|-
|End Trip Schedule
|I_END_SCHED ||M || || || || || ||
|-
|Location Type
|I_LOC_TYPE ||O || || || || || ||
|-
|Start Trip Schedule
|I_START_SCHED ||M || || || || || ||
|-
|Carrier
|I_CARRIER_ID ||O || || || || || ||
|}
 
==Sales Margin Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Sales Margin  Extract
|sme
|CSV.order_costs
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Customer
|i_CUSTOMER ||O || || || || || ||
|-
|Customer Group
|i_CUST_GROUP ||O || || || || || ||
|-
|Last Schedule
|i_sched_to ||O || || || || || ||
|-
|Schedule
|i_Sched ||M || || || || || ||
|-
|Carrier Group
|i_carr_group ||O || || || || || ||
|}
 
==Savings Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Savings Extract
|Savings
|CSV.SAVINGS_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Credit Acc
|I_CREDIT_ACC ||O || || || || || ||
|-
|Saving (> or <)
|I_SAVING ||O || STRING|| || || || ||
|-
|Lane Id
|I_LANE_ID ||O || || || || || ||
|-
|Customer Group
|I_CUST_GROUP ||O || || || || || ||
|-
|To Cty Code
|I_TO_CTY ||O || || || || || ||
|-
|From Cty Code
|I_FROM_CTY ||O || || || || || ||
|-
|From Date
|I_FROM_DATE ||O ||TODAY || || || || ||
|-
|To Date
|I_TO_DATE ||O || TODAY|| || || || ||
|-
|Debit Acc
|I_DEBIT_ACC ||O || || || || || ||
|}
 
==Schedule==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Schedule
|Schedule
|CSV.SCHEDULE
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date
|P_END_DATETIME ||M ||TODAY || || || || ||
|-
|From Date
|P_START_DATETIME ||M ||TODAY || || || || ||
|}
 
==Schedule Details==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Schedule Details
|schedule_details
|DP_CSV_GEN.SCHEDULE
|}
Parameters:
{| class="wikitable"
!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 || || || || || ||
|}
 
==Schedule Trips CS==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Schedule Trips CS
|SCHED_TRIPS_CS
|CSV.SCHEDULE_TRIPS_CS
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Customer
|i_customer ||O || || || || || ||
|-
|Schedule
|i_Sched
|M
|
|
|
|
|
|
|}
 
==Scheduled and Cancelled Orders==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Scheduled and  Cancelled Orders
|Schedule_Orders
|CSV.SCHEDULE_ORDERS_VS
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Customer
|i_CUSTOMER ||O || || || || || ||
|-
|Carrier Group
|i_carr_group ||O || || || || || ||
|-
|Last Schedule
|i_sched_to ||O || || || || || ||
|-
|Schedule
|i_Sched ||M || || || || || ||
|-
|Customer Group
|i_CUST_GROUP ||O || || || || || ||
|}
 
== Scheduled and Cancelled Orders v2 ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Scheduled and  Cancelled Orders v2
|fn
|CSV.SCHEDULE_ORDERS_VS_V2
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Customer
|i_CUSTOMER ||O || || || || || ||
|-
|Carrier Group
|i_carr_group ||O || || || || || ||
|-
|Last Schedule
|i_sched_to ||O || || || || || ||
|-
|Schedule
|i_Sched ||M || || || || || ||
|-
|Customer Group
|i_CUST_GROUP ||O || || || || || ||
|}
 
== Short Rail Report ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Short Rail Report
|short_rail_rep
|dp_csv_nr.short_rail_report
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|Product Type
|i_product_type ||O || || || || || ||
|-
|End Schedule
|i_Sched_To ||M || || || || || ||
|-
|Start Schedule
|i_Sched_From ||M || || || || || ||
|}
 
==Slot Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Slot Extract
|Slot_Extract
|DP_CSV3.Slot_Extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Location Type
|I_LOC_TYPE ||O ||String ||ALL || || || ||
|-
|Day
|I_DAY ||O ||String ||ALL || || || ||
|-
|Slot Type
|I_SLOT_TYPE ||O ||String ||ALL || || || ||
|}
 
== Store PVA ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Store PVA
|STORE_PVA
|DP_CSV_DUN.STORE_PVA
|}
Parameters:
{| class="wikitable"
!Title
!Name
!Mand
!Def Type
!Def Val
!LOV
!Column 1
!Column 2
!Column 3
|-
|Delivery Date
|P_DEL_DATE
|M
|
|
|
|
|
|
|}
 
==Store Pre Warning==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Store Pre Warning
|Store_Pre_Warning
|CSV.Store_Pre_Warning
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Depot
|i_Depot ||O || || || Depot|| Location Id|| Name||
|-
|Store
|i_store ||O || || ||Store ||Location  Id ||Name ||
|-
|Sched Name
|i_sched_name ||M || || || || || ||
|-
|Show empty Slots
|i_show_empty_slots ||O || STRING|| N|| || || ||
|}
 
==Sub Contractor==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Sub Contractor
|SUB_CONTRACTOR
|DP_CSV_GEN.SUB_CONTRACTOR
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Cost Centre
|P_CC ||M || || || || || ||
|-
|To Sched
|P_END_SCHED ||M || || || || || ||
|-
|From Sched
|P_START_SCHED ||M || || || || || ||
|}
 
==Supplier DUs==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Supplier DUs
|SUPPLIER_DU_EXTRACT
|DP_CSV_GEN.SUPPLIER_DU_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From
|P_FROM ||M || ||TODAY || || || ||
|-
|To
|P_TO ||M || ||TODAY || || || ||
|}
 
==Supplier DUs By Store==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Supplier DUs By  Store
|SUPPLIER_DU_BY_STORE_EXTRACT
|DP_CSV_GEN.DU_STORE_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!
|-
|Supplier DUs By  Store
|Start Schedule ||P_START_SCHED || M|| || || || ||
|
|-
|Supplier DUs By Store
|End  Schedule ||P_END_SCHED || M|| || || || ||
|
|-
|Supplier DUs By Store
|Store ||P_STORE || O|| || || Store|| Location  ID||Name
|
|-
|Supplier DUs By Store
|Order  Status ||P_STATUS || O|| || || || ||
|
|}
 
==Supplier Invoice==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Supplier Invoice
|Supplier_Invoice
|DP_CSV5.SUPPLIER_INVOICE
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|End Date
|P_END_DATE ||O || || || || || ||
|-
|Start Date
|P_START_DATE ||O || || || || || ||
|-
|Invoice ID
|P_INVOICE_ID ||O ||STRING || || || || ||
|}
 
==Supplier Revenue==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Supplier Revenue
|SUPPLIER_REVENUE_EXTRACT
|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT
|}
Parameters:
{| class="wikitable"
!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 || || || || || ||
|}
 
==Supplier Revenue 2==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Supplier Revenue 2
|SUPPLIER_REVENUE_2_EXTRACT
|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Revenue End
|P_REVENUE_END ||M || ||TODAY || || || ||
|-
|Revenue Start
|P_REVENUE_START ||M || ||TODAY || || || ||
|}
 
==TYRE SUMMARY EXTRACT==
{{Note}} Can be run from Trip Waterfall screen.
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|TYRE SUMMARY  EXTRACT
|TYRE_SUMMARY_EXTRACT
|DP_CSV6.TYRE_SUMMARY_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|i_sched_name ||M || || || || || ||
|}
 
==Trip Actuals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Trip Actuals
|TRIP_ACTUALS
|CSV.TRIP_ACTUALS
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|i_schedule ||M || || || || || ||
|}
 
==Trip Assessment Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Trip Assessment  Extract
|chk_trips
|dp_csv_lfs.chk_trips
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|i_sched ||M || || || || || ||
|}
 
==Trip Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Trip Extract
|Trip_Extract
|CSV.Trip_Extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date
|i_from_date ||O || TODAY|| || || || ||
|-
|To Date
|i_to_date ||O ||TODAY || || || || ||
|-
|Carrier
|i_carrier ||O || || || || || ||
|}
 
==Trip and Order Detail Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Trip and Order  Detail Extract
|Trip_Order_Detail_Extract
|CSV.Trip_Order_Detail_Extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Schedule
|P_START_SCHED ||M || || || || || ||
|-
|Location Type
|i_loc_type ||M || || ALL|| || || ||
|-
|Carrier
|i_carrier_id ||O || || || || || ||
|-
|End Schedule
|P_END_SCHED ||M || || || || || ||
|}
 
==Trunking Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Trunking Report
|Trunking_Report
|CSV.Trunking_Report
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Depot
|p_Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|End Schedule
|P_END_SCHED ||M || || || || || ||
|-
|Start Schedule
|P_START_SCHED ||M || || || || || ||
|-
|Report Type
|p_report_type ||M ||STRING ||Revenue || || || ||
|}
 
==UNISON Interface Results==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|UNISON Interface  Results
|UNSION_interface_results
|CSV.UNISON_if_res
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Depot
|i_depot ||O || || ||Depot ||Location Id ||Name ||
|-
|Customer
|I_CUSTOMER ||O || || || || || ||
|-
|To Date
|i_to_date ||O ||TODAY || || || || ||
|-
|From Date
|i_from_date ||O ||TODAY || || || || ||
|}
 
==User Activity Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|User Activity  Extract
|User_Activity_Extract
|CSV.User_Activity_Extract
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|-
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|}
 
==User Last Logon Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|User Last Logon  Extract
|USER_LAST_LOGON
|CSV.user_logon_export
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Days since logon
|I_NO_DAYS ||M ||STRING ||90 || || || ||
|}
 
==Variance Analysis Store Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Variance Analysis  Store Detail
|VAR_ANLYS_STORE_DTL
|CSV.VARIANCE_ANALYSIS_STORE_DTL
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|i_Schedule ||M || || || || || ||
|}
 
==Variance Analysis Summary==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Variance Analysis  Summary
|VAR_ANLYSIS_SUM
|CSV.VARIANCE_ANALYSIS_SUMMARY
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|From Date
|i_Start_Date_Time ||M ||TODAY || || || || ||
|-
|To Date
|i_End_Date_Time ||M ||TODAY || || || || ||
|}
 
==Variance Analysis Trip Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Variance Analysis  Trip Detail
|VAR_ANLYS_TRIP_DTL
|CSV.VARIANCE_ANALYSIS_TRIP_DTL
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule
|i_Schedule ||M || || || || || ||
|}
 
==Vehicle Utilisation==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Vehicle Utilisation
|vehicle_util
|dp_csv_nr.vehicle_utilisation
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Schedule ||M || || || || || ||
|-
|End Schedule ||M || || || || || ||
|}
 
==Vehicle Utilisation Heavy==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Vehicle Utilisation  Heavy
|hvy_vehicle_util
|dp_csv_nr.heavy_vehicle_utilisation
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|End Schedule
|i_Sched_To ||M || || || || || ||
|-
|Carrier Code
|i_carrier_code ||O || || || || || ||
|-
|Carrier Group
|i_carrier_group ||O || || || || || ||
|-
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|-
|Start Schedule
|i_Sched_From ||M || || || || || ||
|}
 
==Vehicle Utilisation Non-Heavy==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Vehicle Utilisation  Non-Heavy
|vehicle_util
|dp_csv_nr.vehicle_utilisation
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|End Schedule
|i_Sched_To ||M || || || || || ||
|-
|Customer Group
|i_cust_group ||O || || || || || ||
|-
|Carrier Group
|i_carrier_group ||O || || || || || ||
|-
|Carrier Code
|i_carrier_code ||O || || || || || ||
|-
|Start Schedule
|i_Sched_From ||M || || || || || ||
|-
|Cost Centre
|i_cost_centre ||O || || || || || ||
|}
 
==Volume Deviation Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Volume Deviation  Extract
|VOLUME_DEVIATION_EXTRACT
|DP_CSV5.volume_deviation_report
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date
|i_date_to ||M || TODAY|| || || || ||
|-
|Carrier
|i_carrier ||O || || ALL|| || || ||
|-
|Trip Leg
|i_trip_leg ||O ||STRING || ALL|| || || ||
|-
|Schedule
|i_Sched_name ||O || || || || || ||
|-
|From Date
|i_date_from ||M || TODAY|| || || || ||
|-
|Deviation
|i_deviation ||O ||STRING ||ALL || || || ||
|-
|Cost Centre
|I_COST_CENTRE ||O || ||ALL || || || ||
|-
|Include Unpacked
|i_inc_unpacked ||O ||STRING ||Y || || || ||
|}
 
==Volume or Activity==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Volume or Activity
|VOLUME_ACTIVITY
|DP_CSV6.VOLUME_ACTIVITY
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule From
|i_sched_from ||M || || || || || ||
|-
|Customer
|i_customer ||O || || || || || ||
|-
|Media Type
|i_media ||O || || || || || ||
|-
|Schedule To
|i_sched_to ||M || || || || || ||
|-
|Dealer
|i_dealer ||O || || || || || ||
|-
|Depot
|i_depot ||O || || || || || ||
|-
|Route Code
|i_route ||O || || || || || ||
|}
 
==WCS Location Snapshot==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|WCS Location  Snapshot
|WCS_LOC_SANPSHOT
|DP_CSV2.wcs_loc_snapshot
|}
No parameters.
==WCS Order Items Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|WCS Order Items  Extract
|WCS_ORDER_ITEMS_EXTRACT
|DP_CSV2.WCS_ORDER_ITEMS_EXTRACT
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date
|i_end_date ||M ||TODAY || || || || ||
|-
|Trip
|i_trip ||O ||STRING || || || || ||
|-
|Customer
|i_customer ||O || || || || || ||
|-
|From Date
|i_start_date ||M ||TODAY || || || || ||
|-
|Crossdock Depot
|i_depot
|O
|
|
|Crossdock  Depot
|Location  Id
|Name
|
|-
|Order
|i_order
|O
|STRING
|
|
|
|
|
|}
 
==Weekly Transport Report ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Weekly Transport  Report
|Weekly_Transport
|DP_CSV_BNL.Weekly_Transport
|}
Parameters:
{| class="wikitable"
!Title
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!
|-
|Weekly  Transport Report
|To Sched ||i_sched_to || M|| || || || ||
|
|-
|Weekly Transport Report
|From  Sched ||i_sched_from || M|| || || || ||
|
|-
|Weekly Transport Report
|Carrier ||i_carrier || || || ALL|| ||
|
|
|}
|}


==XML Order Interface Export==
==XML Order Interface Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|XML Order Interface  Export
|XML_Order_Interface
|DP_CSV3.XML_ORDER_INTERFACE
|}
No Parameters
No Parameters

Latest revision as of 13:30, 1 September 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

CTM Trips Not Responded To

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

Parameters:

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

Call Collection OTIF Day

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

Parameters:

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

Call Collection OTIF Time Window

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

Parameters:

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

Call Delivery OTIF Day

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

Parameters:

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

Call Delivery OTIF Time Window

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

Parameters:

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

Campus KPI Extract

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

Parameters:

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

Carrier DUs Shipped

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

Parameters:

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

Carrier Delivery Report

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

Parameters:

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

Carrier Invoice

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

Parameters:

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

Carrier Self Billing

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

Parameters:

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

Catalyst Extract

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

Parameters:

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

Co-ordinate Non-Conformities

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

Parameters:

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

Commercial

Report Name Filename Procedure for Scheduling
Commercial COMMERCIAL CSV.Commercial_Orders

Parameters:

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

Compliance Report

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

Parameters:

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

Concurrent Logon Export

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

Parameters:

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

Contracts

Report Name Filename Procedure for Scheduling
Contracts CONTRACTS CSV.CONTRACTS

No Parameters

Cross Dock

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

Parameters:

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

Customer Invoice

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

Parameters:

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

Customer Invoice By Dates

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

Parameters:

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

Customer Invoice Extract

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

Parameters:

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

Cut Offs Extract

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

Parameters:

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

D365 Extract

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

No parameters.

DELIVERY_OVERVIEW

Report Name Filename Procedure for Scheduling
DELIVERY_OVERVIEW DELIVERY_OVERVIEW dp_csv3.delivery_overview

Parameters:

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

DOOD Rpt

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

Parameters:

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

DUs Despatched

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

Parameters:

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

DUs Not Loaded

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

Parameters:

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

DUs Not Received

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

Parameters:

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

Daily Manifest E-OT-L

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

Parameters:

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

Daily Receiving E-OT-L

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

Parameters:

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

Daily Transport Plan

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

Parameters:

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

Daily Unscheduled Orders

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

Parameters:

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

Debrief Performance

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

Parameters:

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

Del Scans

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

Parameters:

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

Delivery Conf

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

Parameters:

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

Delivery Schedule Extract

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

Parameters:

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

Depot Exits by Hour (Loads)

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

Parameters:

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

Depot Exits by Hour (RPEs)

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

Parameters:

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

Detailed Interface Report

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

Parameters:

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

Dixons Catalyst Report

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

Parameters:

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

Dixons Order Export

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

Parameters:

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

Dixons Trip Extract

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

Parameters:

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

Driver Hours

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

Parameters:

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

Driver Scanning

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

Parameters:

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

Dunelm Actual Load

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

Parameters:

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

Dunelm Actual Unload

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

Parameters:

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

Dunelm Backing Sheet

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

Parameters:

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

Dunelm DUs Despatched Extract

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

Parameters:

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

Dunelm DUs Not Loaded Extract

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

Parameters:

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

Dunelm DUs Not Received

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

Parameters:

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

Dunelm Inventory Transactions

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

Parameters:

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

Dunelm Item Movements 3

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

Parameters:

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

Dunelm Item Movements Extract

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

Parameters:

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

Dunelm Item Movements Extract New

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

Parameters:

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

Dunelm Left Offs

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

Parameters:

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

Dunelm Loading Extract

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

Parameters:

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

Dunelm Manifest E-OT-L Extract

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

Parameters:

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

Dunelm Manual Loaded Items Extract

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

Parameters:

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

Dunelm Receiving Extract

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

Parameters:

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

Dunelm Recieving E-OT-L Extract

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

Parameters:

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

Dunelm Supplier DU Extract

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

Parameters:

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

Dunelm Supplier DU Extract by Store

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

Parameters:

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

Dunelm Supplier Revenue Extract

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

Parameters:

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

Dunelm Supplier Revenue Extract New

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

Parameters:

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

Dunelm Supplier Trends Extract

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

Parameters:

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

Dunelm Transport Plan

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

Parameters:

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

Dunelm Unsched Orders

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

Parameters:

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

Duplicate Postcodes

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

Parameters:

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

EFX Inbound Errors

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

No parameters.

ERC

Report Name Filename Procedure for Scheduling
ERC ERC DP_CSV_DHL.ERC

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
DHL Carriers i_dhl_carr M
Detail Level i_detail M
Sched Start i_sched_from M
Carrier i_carrier O
Sched End i_sched_to M

Equipment Moves

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Owning depot i_depot O
Customer i_customer O
To Date i_date_to M TODAY
From Date i_date_from M TODAY
Carrier i_carrier O

Extract Lane

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

Parameters:

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

Failed Shipment

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

Parameters:

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

Fixed Routes Extract

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

Parameters:

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

GREENE KING Interface Results

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

Parameters:

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

GYP EFX Export

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip Status I_STATUS O
To Schedule P_END_SCHED M
From Schedule P_START_SCHED M
Cost Centre I_COST_CENTRE O
Customer Group I_CUST_GRP O

HC Booking In Form

Report Name Filename Procedure for Scheduling
HC Booking In Form HC_BOOKING_IN_FORM DP_CSV5.P_HC_BOOKING_IN_FORM

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule I_SCHED_NAME M
Group Name I_GROUP_NAME O
Customer I_CUSTOMER O
Delivery Location I_DEL_LOCATION O

HC Haulier Trip Sheet

Report Name Filename Procedure for Scheduling
HC Haulier Trip Sheet HAULIER_TRIP_SHEET DP_CSV2.HAULIER_TRIP_SHEET

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Trip ID (optional) i_trip_id O
Owning Depot i_depot O Depot Location Id Name
Load Location i_load_loc O Loading Location Location Id Name
Group Name i_group_name O
Carrier i_carrier O
Schedule i_sched M

HCR Customer Orders

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre I_COST_CENTRE O
Depot P_LOCATION O
Customer I_CUSTOMER O
Schedule I_SCHED_NAME M

HCR Loading Sheet CSV

Report Name Filename Procedure for Scheduling
HCR Loading Sheet CSV HCR_LOADING_SHEET DP_CSV5.HCR_LOADING_SHEET

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier P_CARRIER O
Group Name P_GROUP_NAME O
Owning Depot P_OWNING_DEPOT O Depot Loading Location Name
Customer P_CUSTOMER O
Schedule To P_SCHED_TO M
Trip ID (optional) P_TRIP_ID O
Load Location P_LOAD_LOC O Loading Location Loading Location Name
Schedule From P_SCHED_FROM M

Haulier Invoice

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Invoice ID P_INVOICE_ID O STRING

Heavy Vehicle Utilisation

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

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

Historical Lane Based Orders

Report Name Filename Procedure for Scheduling

Parameters:

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

IND Trip and Order Detail

Report Name Filename Procedure for Scheduling
IND Trip and Order Detail IND_Trip_Order_Detail_Extract DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT

Parameters:

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

ISC Finance (2) Export

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

Parameters:

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

ISC Finance (3) Export

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

Parameters:

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

ISC Finance (4) Export

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

Parameters:

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

Interface Errors Failures

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Source System P_SOURCE_SYSTEM O Source System
Customer P_CUSTOMER O Customer
External Ref P_EXTERNAL_REF O STRING
End Date P_END_DATETIME M TODAY
Start Date P_START_DATETIME M TODAY

Invalid Orders

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

Parameters:

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

Item Movements

Report Name Filename Procedure for Scheduling
Item Movements ITEM_MOVEMENTS_EXTRACT DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT

Parameters:

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

Item Movements 2

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

Parameters:

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

Item Movements 3

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

Parameters:

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

Items Not Scanned By Date

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

Parameters:

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

Items Not Scanned By Trip

Report Name Filename Procedure for Scheduling
Items Not Scanned By Trip Items_Not_Scanned DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP

Parameters:

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

JEYES Interface Results

Report Name Filename Procedure for Scheduling
JEYES Interface Results JEYES_interface_results CSV.JEYES_if_res

Parameters:

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

Job Notes

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Date from i_date_from M
OMS Ref To i_oms_to O
OMS Ref From i_oms_from O
Date to i_date_to M
Customer i_customer O

KPI By Lane

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Date I_START_DATE_TIME M TODAY
Tolerance(days) I_TOLERANCE O
Customer Group I_CUST_GROUP O
End Date I_END_DATE_TIME M TODAY
Grouping I_GROUP_BY M STRING CUST_GROUP

KPI Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Owning Depot i_owning_depot O Depot Location Id Name
Start Schedule i_start_sched M
Group Name i_group_name O STRING ALL
End Schedule i_end_sched M

Kraft KPI

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

Parameters:

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

LFS Packages

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
External Ref i_ext_ref O
Customer i_customer O
Schedule i_sched M
Order Status i_ord_status O

Lane Extract

Report Name Filename Procedure for Scheduling
Lane Extract Lane_Extract CSV.LANE_EXPORT

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Loc p_from_loc O From Loc Location Id Name
To Loc p_to_loc O To Loc Location Id Name
Customer p_customer O
Cost Centre p_cost_centre O

Left Offs

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

Parameters:

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

Loading Extract

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

Parameters:

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

Loading Schedule CSV

Report Name Filename Procedure for Scheduling
Loading Schedule CSV Loading_Schedule CSV.LOADING_SCHEDULE

Parameters:

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

Location Export

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Location Group I_CUST_GROUP O
Country i_country O

Location Export GL

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

No parameters

Location Export GPR

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

No parameters.

Location Pre-Warning

Report Name Filename Procedure for Scheduling
Location Pre-Warning Loc_Del_Pre_Warn CSV.Loc_Del_Pre_Warning

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot i_depot M Depot Location Id Name
From Date i_start_date_time M TODAY
Load Type i_load_type M STRING ALL
To Date i_end_date_time M TODAY
Trip Status i_trip_status M STRING ALL

MDD Code 03 Exceptions

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

Parameters:

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

MTS Finance Export

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

Parameters:

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

MTS Finance Export V2

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

Parameters:

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

Manual Loaded Items

Report Name Filename Procedure for Scheduling
Manual Loaded Items MANUAL_LOADED_ITEMS_EXTRACT DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT

Parameters:

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

Master and Child Locations

Report Name Filename Procedure for Scheduling
Master and Child Locations Master_and_Child DP_CSV5.MASTER_AND_CHILD

Parameters:

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

Message Maintenance

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

No parameters

Missing Lat Long Report

Report Name Filename Procedure for Scheduling
Missing Lat Long Report MISSING_LAT_LONGS dp_csv3.missing_lat_long_extract

Parameters:

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

Missing Steps Report

Report Name Filename Procedure for Scheduling
Missing Steps Report Missing_Steps_Report DP_CSV5.Missing_Steps_Report

Parameters:

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

Month End Accruals

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

Parameters:

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

NR Additional Report

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

No parameters

NR Finance Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Debriefed i_debriefed M
From Date i_from_date M TODAY
Carrier i_carrier O
To Region i_to_region M STRING ALL
From Region i_from_region M STRING ALL
Carrier Group i_carrier_group O
Strategy i_strategy O
Cost Centre i_cost_centre O
Customer i_customer O
To Date i_to_date M TODAY

NR Invoice

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date i_from_date M TODAY
Carrier i_carrier O
To Region i_to_region M STRING ALL
From Region i_from_region M STRING ALL
Debriefed i_debriefed M
Strategy i_strategy O
Cost Centre i_cost_centre O
Customer i_customer O
To Date i_to_date M TODAY
Carrier Group i_carrier_group O

OPS KPI Extract

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

Parameters:

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

OPS KPI Extract2

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

Parameters:

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

OTM Export

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

Parameters:

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

On Time Arrivals

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

Parameters:

Title Name Mand 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
Outbase i_depot O
Route Code i_route O
Media Type i_media O
Dealer i_dealer O

On Time Drops

Report Name Filename Procedure for Scheduling
On Time Drops ON_TIME_DROPS DP_CSV6.ON_TIME_DROPS

Parameters:

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

On Time Items

Report Name Filename Procedure for Scheduling
On Time Items ON_TIME_ITEMS DP_CSV6.ON_TIME_ITEMS

Parameters:

Title Name Mand 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
Media Type i_media O
Route Code i_route O
Dealer i_dealer O
Outbase i_depot O

On Time Items (Assets)

Report Name Filename Procedure for Scheduling
On Time Items (Assets) ON_TIME_ITEMS DP_CSV6.ON_TIME_ITEMS_ASSETS

Parameters:

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

On Time Returns

Report Name Filename Procedure for Scheduling
On Time Returns ON_TIME_RETURNS DP_CSV6.ON_TIME_RETURNS

Parameters:

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

Operational Information

Report Name Filename Procedure for Scheduling
Operational Information Operational_Information DP_CSV2.OPERATIONAL_INFO

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date P_END_DATE M TODAY
POD P_POD O
Carrier I_FROM_LOC O Carrier Carrier Name Carrier ID
Location From P_FROM_LOC O STRING Location From Location ID Name
From Date P_START_DATE M TODAY

Order Charges Extract

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

Parameters:

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

Order Extract

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

Parameters:

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

Order Interface Results

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date i_to_date O TODAY
Customer I_CUSTOMER O
From Date i_from_date O TODAY
Depot i_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:

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 O
Customer P_CUSTOMER O

Order Savings

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

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 O
Show Neg Savings p_show_only_negative M

Order Tracking

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Month P_MONTH M
Week Offset P_WEEK_OFFSET O
Year P_YEAR M
Customer P_CUSTOMER O STRING OPENFIELD
Cost Centre P_COST_CENTRE O STRING EXEL

Orders for Relabelling

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

Parameters:

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

Orders to LogiX

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

No parameters

Orders to Paragon

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

No parameters

Outbound Shortage

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

Parameters:

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

PAYMENT_DTLS

Report Name Filename Procedure for Scheduling
PAYMENT_DTLS PAYMENT_DTLS OF_INT.WRITE_PAYMENT_DETAILS

Parameters:

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

POC to SAP Extract

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

No parameters

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:

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

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date P_END_DATETIME M YESTERDAY YESTERDAY
Date From P_START_DATETIME M TODAY YESTERDAY:20:00

POD Delivery Extract

Report Name Filename Procedure for Scheduling
POD 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
Customer Group p_group_name O STRING ALL
Scanning Depot p_scan_depot O STRING ALL Depot Location Id Name
> Days Outstanding p_outstanding O STRING 0
POD Status p_pod O STRING ALL
Carrier p_carrier O STRING ALL
To Schedule p_to_date M
From Schedule p_from_date M
Customer p_customer O STRING ALL
Del Msg Sent p_del_msg_sent O STRING ALL

POD Generation Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
POD Flow P_FLOW M
Schedule P_SCHED O
Date From P_DATE_FROM M TODAY
Date To P_DATE_TO M TODAY

POD to SAP Extract

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

No parameters

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:

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

PORSCHE19 Invoice Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sub Credit Account p_sub_credit_acc O STRING ALL
Trip ID p_trip O STRING ALL
Export ID p_export O STRING 0
Customer p_customer M STRING PORSCHE19
Sub Debit Account p_sub_debit_acc O STRING ALL
Invoice ID p_invoice O STRING 0

PROVIDER_REVENUE

Report Name Filename Procedure for Scheduling
PROVIDER_REVENUE PROVIDER_REVENUE dp_csv3.provider_revenue

Parameters:

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

Parts and Empties

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Schedule From P_SCHED_FROM M
Schedule To P_SCHED_TO M
Location From P_LOCATION O
Export Type P_EXPORT_TYPE M
Customer P_CUSTOMER M

PostCode Matrix

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

No parameters

Pre Invoice Check

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

Parameters:

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

Process Items Audit

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Record Status i_record_status M STRING ALL
End Date i_end_datetime M TODAY
Start Date i_start_datetime M TODAY
Incl. Reprocessed i_incl_reprocessed M STRING N

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:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Incl. Reprocessed i_incl_reprocessed M STRING N
Record Status i_record_status M STRING ALL
End Date i_end_datetime M TODAY
Start Date i_start_datetime M TODAY

Provisional Booking Exceptions

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

Parameters:

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

Purchase Order Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date i_end_date O TODAY TODAY
From Date i_start_date O TODAY TODAY
Status i_status_id O STRING All

Reason Listings

This extract reports on the Items and Items Reasons. That will include all scanning events from WCS, MCS, EPOD and APOD.

Note Note: The report is based off the actual arrival date/time and the depot. If the trip for that depot and order has not been debriefed yet, then the items and reasons will not be displayed.

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

Parameters:

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

Columns:

  • Trip - the trip on which the item was moved.
  • Route - the route (if present) from the trip.
  • Stop Name - the location name.
  • PO Reference - the order's booking reference.
  • Customer Reference - the order's eternal reference.
  • Reason Code - the reason code.
  • Reason Text - the reason description.
  • Comment User - any comment against that item reason.
  • Line DU - the item type.
  • Line Planned Qty - the planned quantity in total of that type.
  • Line Delivered Qty - the delivered quantity in total of that type.
  • Line Variance - any variance between the quantity in total of that type.
  • Item ID - the individual item ID.
  • Item Desc - the description of that item.
  • Item Planned Qty - the planned quantity of that item.
  • Item Delivered Qty - the delivered quantity of that item.
  • Item Variance - any variance between the planned and delivered quantity of that item.

Receipt Scanning

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot i_depot O STRING
Dealer i_dealer O STRING
Media Type i_media_type O STRING
Route i_route O STRING
Customer i_customer O STRING
Date To i_date_to M TODAY
Date From i_date_from M TODAY

Receiving Extract

This is an extract of unloaded items at the depot.

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

Parameters:

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

The report shows a summary per date in the selection, and the details in the selection. Both sections contains the same fields:

  • Date
  • Customer
  • Dealer
  • Dealer Name
  • Origin Depot
  • Depot Name
  • Route Code
  • Media Type
  • Asset
  • Child Asset
  • Pallet ID
  • Item Weight
  • Item Volume
  • Items Created
  • Positive Load Scan
  • Variance

Revenue Check (Account)

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

Parameters:

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

SMS Email Summary Report

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date I_DATE_FROM M TODAY
Cost Centre I_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:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Order Status I_ORDER_STATUS O
End Trip Schedule I_END_SCHED M
Location Type I_LOC_TYPE O
Start Trip Schedule I_START_SCHED M
Carrier I_CARRIER_ID O

Sales Margin Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer i_CUSTOMER O
Customer Group i_CUST_GROUP O
Last Schedule i_sched_to O
Schedule i_Sched M
Carrier Group i_carr_group O

Savings Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Credit Acc I_CREDIT_ACC O
Saving (> or <) I_SAVING O STRING
Lane Id I_LANE_ID O
Customer Group I_CUST_GROUP O
To Cty Code I_TO_CTY O
From Cty Code I_FROM_CTY O
From Date I_FROM_DATE O TODAY
To Date I_TO_DATE O TODAY
Debit Acc I_DEBIT_ACC O

Schedule

Report Name Filename Procedure for Scheduling
Schedule Schedule CSV.SCHEDULE

Parameters:

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

Schedule Details

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

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

Schedule Trips CS

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

Parameters:

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

Scheduled and Cancelled Orders

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer i_CUSTOMER O
Carrier Group i_carr_group O
Last Schedule i_sched_to O
Schedule i_Sched M
Customer Group i_CUST_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:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer i_CUSTOMER O
Carrier Group i_carr_group O
Last Schedule i_sched_to O
Schedule i_Sched M
Customer Group i_CUST_GROUP O

Short Rail Report

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Cost Centre i_cost_centre O
Product Type i_product_type O
End Schedule i_Sched_To M
Start Schedule i_Sched_From M

Slot Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Location Type I_LOC_TYPE O String ALL
Day I_DAY O String ALL
Slot Type I_SLOT_TYPE O String ALL

Store PVA

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Delivery Date P_DEL_DATE M

Store Pre Warning

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot i_Depot O Depot Location Id Name
Store i_store O Store Location Id Name
Sched Name i_sched_name M
Show empty Slots i_show_empty_slots O STRING N

Sub Contractor

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

Parameters:

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

Supplier DUs

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From P_FROM M TODAY
To P_TO 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:

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

Supplier Invoice

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

Parameters:

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

Supplier Revenue

Report Name Filename Procedure for Scheduling
Supplier Revenue SUPPLIER_REVENUE_EXTRACT DP_CSV_GEN.SUPPLIER_REVENUE_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

Supplier Revenue 2

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

Parameters:

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

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:

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

Trip Actuals

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

Parameters:

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

Trip Assessment Extract

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

Parameters:

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

Trip Extract

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

Parameters:

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

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:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Start Schedule P_START_SCHED M
Location Type i_loc_type M ALL
Carrier i_carrier_id O
End Schedule P_END_SCHED M

Trunking Report

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Depot p_Depot M Depot Location Id Name
End Schedule P_END_SCHED M
Start Schedule P_START_SCHED M
Report Type p_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:

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

User Activity Extract

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

Parameters:

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

User Last Logon Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Days since logon I_NO_DAYS 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:

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

Variance Analysis Summary

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
From Date i_Start_Date_Time M TODAY
To Date i_End_Date_Time 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:

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

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

Vehicle Utilisation Non-Heavy

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

Parameters:

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

Volume Deviation Extract

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date i_date_to M TODAY
Carrier i_carrier O ALL
Trip Leg i_trip_leg O STRING ALL
Schedule i_Sched_name O
From Date i_date_from M TODAY
Deviation i_deviation O STRING ALL
Cost Centre I_COST_CENTRE O ALL
Include Unpacked i_inc_unpacked O STRING Y

Volume or Activity

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

Parameters:

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

WCS Location Snapshot

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

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

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
To Date i_end_date M TODAY
Trip i_trip O STRING
Customer i_customer O
From Date i_start_date M TODAY
Crossdock Depot i_depot O Crossdock Depot Location Id Name
Order i_order O STRING

Weekly Transport Report

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

Parameters:

Title Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Weekly Transport Report To Sched i_sched_to M
Weekly Transport Report From Sched i_sched_from M
Weekly Transport Report Carrier i_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