Extracts Details: Difference between revisions

From CTMS
(Updated parameters and extract names)
(Updated parameters and extract names)
Line 2,183: Line 2,183:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Failed Shipment
|
|FAILED_SHIPMENT
|
|dp_csv3.failed_shipment
|}
|}
Parameters:
Parameters:
Line 2,204: Line 2,204:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Fixed Routes  Extract
|
|Routes_Extract
|
|CSV.FIXED_ROUTES_EXPORT
|}
|}
Parameters:
Parameters:
Line 2,225: Line 2,225:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|GREENE KING  Interface Results
|
|GREENE_KING_interface_results
|
|CSV.GREENE_KING_if_res
|}
|}
Parameters:
Parameters:
Line 2,248: Line 2,248:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|GYP EFX Export
|
|GYP_EFX_Export
|
|DP_CSV5.GYP_EFX_EXPORT
|}
|}
Parameters:
Parameters:
Line 2,273: Line 2,273:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|HC Booking In Form
|
|HC_BOOKING_IN_FORM
|
|DP_CSV5.P_HC_BOOKING_IN_FORM
|}
|}
Parameters:
Parameters:
Line 2,304: Line 2,304:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|HC Haulier Trip  Sheet
|
|HAULIER_TRIP_SHEET
|
|DP_CSV2.HAULIER_TRIP_SHEET
|}
|}
Parameters:
Parameters:
Line 2,343: Line 2,343:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|HCR Customer Orders
|
|HCR_CUSTOMER_ORDERS
|
|DP_CSV_DHL.HCR_CUSTOMER_ORDERS
|}
|}
Parameters:
Parameters:
Line 2,366: Line 2,366:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|HCR Loading Sheet  CSV
|
|HCR_LOADING_SHEET
|
|DP_CSV5.HCR_LOADING_SHEET
|}
|}
Parameters:
Parameters:
Line 2,397: Line 2,397:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Haulier Invoice
|
|Haulier_Invoice
|
|DP_CSV5.HAULIER_INVOICE
|}
|}
Parameters:
Parameters:
Line 2,419: Line 2,419:


==Heavy Vehicle Utilisation==
==Heavy Vehicle Utilisation==
{{Warning}}Missing
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,464: Line 2,465:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|IND Trip and Order  Detail
|
|IND_Trip_Order_Detail_Extract
|
|DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT
|}
|}
Parameters:
Parameters:
Line 2,491: Line 2,492:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|ISC Finance (2)  Export
|
|FINANCE_2_EXPORT
|
|DP_CSV2.FINANCE_EXPORT_V2
|}
|}
Parameters:
Parameters:
Line 2,506: Line 2,507:
|}
|}


==Interface Errors Failures==
== ISC Finance (3) Export ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,512: Line 2,513:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|ISC Finance (3)  Export
|
|FINANCE_2_EXPORT
|
|CSV6.ISC_FINANCE_2_EXPORT
|}
|}
Parameters:
Parameters:
Line 2,520: Line 2,521:
!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
|-
|-
|External Ref ||O ||STRING || || || || ||
|Customer ||M ||STRING ||ALL || || || ||
|-
|-
|Customer ||O || || ||Customer || || ||
|End Schedule ||M || || || || || ||
|-
|Source System ||O || || || || || ||
|-
|-
|End Date ||M ||TODAY || || || || ||
|Start Schedule ||M || || || || || ||
|-
|Start Date ||M ||TODAY || || || || ||
|}
|}


==Invalid Orders==
== ISC Finance (4) Export ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,537: Line 2,534:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|ISC Finance (4)  Export
|
|FINANCE_2_EXPORT
|
|CSV7.FINANCE_EXPORT_V2
|}
|}
Parameters:
Parameters:
Line 2,545: Line 2,542:
!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 ||M ||STRING ||ALL || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Customer ||0 || || || || || ||
|Start Schedule ||M || || || || || ||
|}
|}


==Item Movements==
==Interface Errors Failures==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,558: Line 2,555:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Interface Errors  Failures
|
|Interface_Errors_Failures
|
|DP_CSV5.INTERFACE_ERRORS_FAILURES
|}
|}
Parameters:
Parameters:
Line 2,566: Line 2,563:
!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 To Date ||M ||TODAY || || || || ||
|External Ref ||O ||STRING || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|Customer ||O || || ||Customer || || ||
|-
|-
|Supplier ||O || || || || || ||
|Source System ||O || || || || || ||
|-
|-
|DU Type ||O || || || || || ||
|End Date ||M ||TODAY || || || || ||
|-
|-
|Store ||O || || || || || ||
|Start Date ||M ||TODAY || || || || ||
|-
|Manifest Number ||O || || || || || ||
|-
|P/O Number ||O || || || || || ||
|}
|}


==Item Movements 2==
==Invalid Orders==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,587: Line 2,580:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Invalid Orders
|
|Invalid_Orders
|
|DP_CSV6.INVALID_ORDERS
|}
|}
Parameters:
Parameters:
Line 2,595: Line 2,588:
!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
|-
|-
|DU Type ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Supplier ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|Customer ||0 || || || || || ||
|-
|Actual To Date ||M ||TODAY || || || || ||
|-
|P/O Number ||O || || || || || ||
|-
|Store ||O || || || || || ||
|-
|Manifest Number ||O || || || || || ||
|}
|}


==Item Movements 3==
==Item Movements==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,616: Line 2,601:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Item Movements
|
|ITEM_MOVEMENTS_EXTRACT
|
|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT
|}
|}
Parameters:
Parameters:
Line 2,624: Line 2,609:
!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 || || || || || ||
|Actual To Date ||M ||TODAY || || || || ||
|-
|-
|Store ||O || || || || || ||
|Actual From Date ||M ||TODAY || || || || ||
|-
|-
|Manifest Number ||O || || || || || ||
|Supplier ||O || || || || || ||
|-
|-
|DU Type ||O || || || || || ||
|DU Type ||O || || || || || ||
|-
|-
|Supplier ||O || || || || || ||
|Store ||O || || || || || ||
|-
|-
|Actual To Date ||M ||TODAY || || || || ||
|Manifest Number ||O || || || || || ||
|-
|-
|Actual From Date ||M ||TODAY || || || || ||
|P/O Number ||O || || || || || ||
|}
|}


==Items Not Scanned By Date==
==Item Movements 2==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,645: Line 2,630:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Item Movements 2
|
|ITEM_MOVEMENTS_2_EXTRACT
|
|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2
|}
|}
Parameters:
Parameters:
Line 2,653: Line 2,638:
!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 || || || || || ||
|DU Type ||O || || || || || ||
|-
|Supplier ||O || || || || || ||
|-
|Actual From Date ||M ||TODAY || || || || ||
|-
|Actual To Date ||M ||TODAY || || || || ||
|-
|P/O Number ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Store ||O || || || || || ||
|-
|-
|Depot ||M || || || || || ||
|Manifest Number ||O || || || || || ||
|}
|}


==Items Not Scanned By Trip==
==Item Movements 3==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,666: Line 2,659:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Item Movements 3
|
|ITEM_MOVEMENTS_3_EXTRACT
|
|DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3
|}
|}
Parameters:
Parameters:
Line 2,674: Line 2,667:
!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 || || || || || ||
|P/O Number ||O || || || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Store ||O || || || || || ||
|-
|Manifest Number ||O || || || || || ||
|-
|DU Type ||O || || || || || ||
|-
|Supplier ||O || || || || || ||
|-
|Actual To Date ||M ||TODAY || || || || ||
|-
|Actual From Date ||M ||TODAY || || || || ||
|}
|}


==JEYES Interface Results==
==Items Not Scanned By Date==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,685: Line 2,688:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Items Not Scanned  By Date
|
|Items_Not_Scanned
|
|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE
|}
|}
Parameters:
Parameters:
Line 2,693: Line 2,696:
!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 || || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|Depot ||M || || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|}
|}


==KPI By Lane==
==Items Not Scanned By Trip==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,708: Line 2,709:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Items Not Scanned  By Trip
|
|Items_Not_Scanned
|
|DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP
|}
|}
Parameters:
Parameters:
Line 2,716: Line 2,717:
!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 || || || || || ||
|Trip ||M || || || || || ||
|-
|-
|End Date ||M || || || || || ||
|Schedule ||M || || || || || ||
|-
|Show Detail ||M ||STRING ||Y || || || ||
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|-
|End Date ||M ||TODAY || || || || ||
|-
|Start Date ||M ||TODAY || || || || ||
|-
|Start Date ||M || || || || || ||
|-
|Tolerance(days) ||O || || || || || ||
|-
|Separate Pages ||M ||STRING ||N || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|}
|}


==Kraft KPI==
==JEYES Interface Results==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,745: Line 2,728:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|JEYES Interface  Results
|
|JEYES_interface_results
|
|CSV.JEYES_if_res
|}
|}
Parameters:
Parameters:
Line 2,753: Line 2,736:
!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 || || || || ||
|To Date ||O ||TODAY || || || || ||
|-
|Customer ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|Depot ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|From Date ||O ||TODAY || || || || ||
|}
|}


==LFS Packages==
==Job Notes==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,766: Line 2,751:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Job Notes
|
|Job_Notes
|
|DP_CSV5.JOB_NOTES
|}
|}
Parameters:
Parameters:
{| class="wikitable"
==KPI By Lane==
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule ||M || || || || || ||
|-
|Order Status ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|External Ref ||O || || || || || ||
|}
 
==Lane Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,789: Line 2,762:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|KPI By Lane
|
|KPI_BY_LANE
|
|CSV.KPI_BY_LANE
|}
|}
Parameters:
Parameters:
Line 2,797: Line 2,770:
!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 ||O || || || || || ||
|-
|End Date ||M || || || || || ||
|-
|Show Detail ||M ||STRING ||Y || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|-
|-
|To Loc ||O || || ||To Loc ||Location Id ||Name ||
|End Date ||M ||TODAY || || || || ||
|-
|-
|From Loc ||O || || ||From Loc ||Location Id ||Name ||
|Start Date ||M ||TODAY || || || || ||
|}
|-
 
|Start Date ||M || || || || || ||
==Left Offs==
|-
|Tolerance(days) ||O || || || || || ||
|-
|Separate Pages ||M ||STRING ||N || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Grouping ||M ||STRING ||CUST_GROUP || || || ||
|}
 
==KPI Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|KPI Extract
|CN_KPI_Extract
|KPI_EXTRACT.KPI_EXTRACT
|}
Parameters:
==Kraft KPI==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,812: Line 2,810:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Kraft KPI
|
|KRAFT_KPI
|
|CSV.Trips_with_Orders
|}
|}
Parameters:
Parameters:
Line 2,820: Line 2,818:
!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 ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Days Back ||M ||STRING ||30 || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Trip ID (optional) ||O || || || || || ||
|Cost Centre ||O || || || || || ||
|}
|}


==Loading Extract==
==LFS Packages==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,833: Line 2,831:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|LFS Packages
|
|LFS_Packages
|
|DP_CSV_LFS.LFS_PACKAGES
|}
|}
Parameters:
Parameters:
Line 2,841: Line 2,839:
!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 || || || || || ||
|Schedule ||M || || || || || ||
|-
|Order Status ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|External Ref ||O || || || || || ||
|}
|}


==Loading Schedule CSV==
==Lane Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,850: Line 2,854:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Lane Extract
|
|Lane_Extract
|
|CSV.LANE_EXPORT
|}
|}
Parameters:
Parameters:
Line 2,858: Line 2,862:
!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 ||
|Customer ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Loc ||O || || ||To Loc ||Location Id ||Name ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Loc ||O || || ||From Loc ||Location Id ||Name ||
|}
|}


==Location Export==
==Left Offs==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,871: Line 2,877:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Left Offs
|
|LEFT_OFFS_EXTRACT
|
|DP_CSV_GEN.LEFT_OFFS_EXTRACT
|}
|}
Parameters:
Parameters:
Line 2,879: Line 2,885:
!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
|-
|-
|Country ||O || || || || || ||
|Store (optional) ||O || || ||Store ||Location ID ||Name ||
|}
|-
|Days Back ||M ||STRING ||30 || || || ||
|-
|Trip ID (optional) ||O || || || || || ||
|}


==Location Pre-Warning==
==Loading Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,888: Line 2,898:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Loading Extract
|
|LOADING_EXTRACT
|
|DP_CSV_GEN.EXT_LOADING
|}
|}
Parameters:
Parameters:
Line 2,896: Line 2,906:
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Load Type ||M ||STRING ||ALL || || || ||
|Schedule ||M || || || || || ||
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|Load Type ||M ||STRING ||ALL || || || ||
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|}
|}


==MDD Code 03 Exceptions==
==Loading Schedule CSV==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,923: Line 2,915:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Loading Schedule  CSV
|
|Loading_Schedule
|
|CSV.LOADING_SCHEDULE
|}
|}
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
|-
|-
|From Date ||M ||TODAY || || || || ||
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|}
|}


==Manual Loaded Items==
==Location Export==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,942: Line 2,936:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Location Export
|
|Location_Export
|
|DP_CSV2.LOCATION_EXPORT
|}
|}
Parameters:
Parameters:
Line 2,950: Line 2,944:
!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 || || || || || ||
|Country ||O || || || || || ||
|-
|To Date ||O || || || || || ||
|}
|}


==Master and Child Locations==
==Location Export GL==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,961: Line 2,953:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Location Export GL
|
|Location_Export
|
|CSV.LOCATION_EXPORT_GL
|}
|}
Parameters:
Parameters:
Line 2,969: Line 2,961:
!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 || || ||
|Country ||O || || || || || ||
|-
|Show Mapped ||O || || ||Show Mapped || || ||
|}
 
== Message Maintenance ==
== || || || || || || || || ||
|}
|}


==Missing Lat Long Report==
==Location Export GPR==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 2,984: Line 2,970:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Location Export GL
|
|Location_Export
|
|CSV.LOCATION_EXPORT_GPR
|}
|}
Parameters:
Parameters:
Line 2,992: Line 2,978:
!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 || || || ||
|Country ||O || || || || || ||
|}
|}


==Missing Steps Report==
==Location Pre-Warning==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,001: Line 2,987:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Location  Pre-Warning
|
|Loc_Del_Pre_Warn
|
|CSV.Loc_Del_Pre_Warning
|}
|}
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
|-
|Load Type ||M ||STRING ||ALL || || || ||
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Missing Step ||O ||STRING ||ALL || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|Load Type ||M ||STRING ||ALL || || || ||
|-
|Trip Status ||M ||STRING ||ALL || || || ||
|}
|}


==Month End Accruals==
==MDD Code 03 Exceptions==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,022: Line 3,022:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|MDD Code 03  Exceptions
|
|MDD Code 03 Exceptions
|
|CSV.MDD_Code_03_Exceptions
|}
|}
Parameters:
Parameters:
Line 3,032: Line 3,032:
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|}
|Cost Centre ||O || || || || || ||
 
==MTS Finance Export==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Customer ||O || || || || || ||
|MTS Finance Export
|FINANCE_EXPORT
|CSV.finance_export_v2
|}
Parameters:
==MTS Finance Export V2==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cust Group ||O || || || || || ||
|MTS Finance Export
|FINANCE_EXPORT_V2
|CSV.finance_export_v2
|}
|}
 
Parameters:
==NR Finance Extract==
==Manual Loaded Items==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,047: Line 3,063:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Manual Loaded Items
|
|MANUAL_LOADED_ITEMS_EXTRACT
|
|DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT
|}
|}
Parameters:
Parameters:
Line 3,055: Line 3,071:
!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 || || || || ||
|From Date ||O || || || || || ||
|-
|-
|Debriefed ||M || || || || || ||
|To Date ||O || || || || || ||
|}
 
==Master and Child Locations==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Carrier ||O || || || || || ||
|Master and Child  Locations
|-
|Master_and_Child
|To Region ||M ||STRING ||ALL || || || ||
|DP_CSV5.MASTER_AND_CHILD
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|To Date ||M ||TODAY || || || || ||
|Show UnMapped ||O || || ||Show UnMapped || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Show Mapped ||O || || ||Show Mapped || || ||
|-
|}
|Strategy ||O || || || || || ||
 
== Message Maintenance ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Cost Centre ||O || || || || || ||
|Message Maintenance
|-
|Message_Maintenance
|Customer ||O || || || || || ||
|CSV.msg_maint
|-
|From Region ||M ||STRING ||ALL || || || ||
|}
|}
 
Parameters:
==NR Invoice==
==Missing Lat Long Report==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,082: Line 3,112:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Missing Lat Long  Report
|
|MISSING_LAT_LONGS
|
|dp_csv3.missing_lat_long_extract
|}
|}
Parameters:
Parameters:
Line 3,090: Line 3,120:
!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 || || || || ||
|Cost Centre ||M || ||ALL || || || ||
|-
|}
|From Date ||M ||TODAY || || || || ||
 
|-
==Missing Steps Report==
|Debriefed ||M || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|To Region ||M ||STRING ||ALL || || || ||
|-
|From Region ||M ||STRING ||ALL || || || ||
|-
|Carrier Group ||O || || || || || ||
|-
|Strategy ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|}
 
==OTM Export==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,117: Line 3,129:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Missing Steps  Report
|
|Missing_Steps_Report
|
|DP_CSV5.Missing_Steps_Report
|}
|}
Parameters:
Parameters:
Line 3,125: Line 3,137:
!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 || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Date From ||M ||TODAY || || || || ||
|Missing Step ||O ||STRING ||ALL || || || ||
|-
|-
|Carrier ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|}
|}


==On Time Arrivals==
==Month End Accruals==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,138: Line 3,150:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Month End Accruals
|
|month_end_accruals
|
|dp_csv_nr.month_end_accruals
|}
|}
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
|-
|-
|Outbase ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Cost Centre ||O || || || || || ||
|-
|Dealer ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Cust Group ||O || || || || || ||
|}
 
==NR Additional Report==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Schedule From ||M || || || || || ||
|NR Additional  Report
|nr_additional_rep
|dp_csv_nr.nr_additional_report
|}
|}
 
Parameters:
==On Time Drops==
==NR Finance Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,167: Line 3,186:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|NR Finance Extract
|
|NR_Finance_Extract
|
|DP_CSV_NR.NR_FINANCE_EXTRACT
|}
|}
Parameters:
Parameters:
Line 3,175: Line 3,194:
!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 || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Debriefed ||M || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Carrier ||O || || || || || ||
|-
|To Region ||M ||STRING ||ALL || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|-
|Carrier Group ||O || || || || || ||
|-
|Strategy ||O || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Cost Centre ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|From Region ||M ||STRING ||ALL || || || ||
|-
|Dealer ||O || || || || || ||
|}
|}


==On Time Items==
==NR Invoice==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,196: Line 3,221:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|NR Invoice
|
|NR_Invoice
|
|DP_CSV_NR.NR_INVOICE
|}
|}
Parameters:
Parameters:
Line 3,204: Line 3,229:
!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 || || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|Outbase ||O || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Debriefed ||M || || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|To Region ||M ||STRING ||ALL || || || ||
|-
|-
|Media Type ||O || || || || || ||
|From Region ||M ||STRING ||ALL || || || ||
|-
|Carrier Group ||O || || || || || ||
|-
|Strategy ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|}
|}


==On Time Items (Assets)==
==OPS KPI Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,225: Line 3,256:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|OPS KPI Extract
|
|OPS_KPI_Extract
|
|KPI.KPI_OPS_EXTRACT
|}
|}
Parameters:
Parameters:
==OPS KPI Extract2==
{| class="wikitable"
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!'''Report Name'''
|-
!'''Filename'''
|Schedule From ||M || || || || || ||
!'''Procedure for Scheduling'''
|-
|Customer ||O || || || || || ||
|-
|-
|Dealer ||O || || || || || ||
|OPS KPI Extract2
|-
|OPS_KPI_Extract
|Outbase ||O || || || || || ||
|KPI.KPI_OPUS_EXTRACT
|-
|Route Code ||O || || || || || ||
|-
|Media Type ||O || || || || || ||
|-
|Schedule To ||M || || || || || ||
|}
|}
 
Parameters:
==On Time Returns==
==OTM Export==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,254: Line 3,278:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|OTM Export
|
|OTM_Export
|
|DP_CSV_DHL.OTM_EXPORT
|}
|}
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
|-
|Date To ||M ||TODAY || || || || ||
|-
|Date From ||M ||TODAY || || || || ||
|-
|Carrier ||O || || || || || ||
|}
==On Time Arrivals==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|On Time Arrivals
|ON_TIME_ARRIVALS
|DP_CSV6.ON_TIME_ARRIVALS
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Outbase ||O || || || || || ||
|-
|-
|Media Type ||O || || || || || ||
|Media Type ||O || || || || || ||
|-
|-
|Route Code ||O || || || || || ||
|Route Code ||O || || || || || ||
|-
|Outbase ||O || || || || || ||
|-
|-
|Dealer ||O || || || || || ||
|Dealer ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|Schedule To ||M || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Schedule From ||M || || || || || ||
|-
|Schedule To ||M || || || || || ||
|}
|}


==Order Charges Extract==
==On Time Drops==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,283: Line 3,328:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|On Time Drops
|
|ON_TIME_DROPS
|
|DP_CSV6.ON_TIME_DROPS
|}
|}
Parameters:
Parameters:
Line 3,291: Line 3,336:
!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 ||M ||TODAY || || || || ||
|Outbase ||O || || || || || ||
|-
|Route Code ||O || || || || || ||
|-
|Media Type ||O || || || || || ||
|-
|Schedule To ||M || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|Dealer ||O || || || || || ||
|}
|}


==Order Extract==
==On Time Items==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,300: Line 3,357:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|On Time Items
|
|ON_TIME_ITEMS
|
|DP_CSV6.ON_TIME_ITEMS
|}
|}
Parameters:
Parameters:
Line 3,308: Line 3,365:
!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 || || || || || ||
|Dealer ||O || || || || || ||
|-
|Outbase ||O || || || || || ||
|-
|Route Code ||O || || || || || ||
|-
|Schedule To ||M || || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|Media Type ||O || || || || || ||
|-
|-
|Start Sched ||M || || || || || ||
|Customer ||O || || || || || ||
|}
|}


==Order Interface Results==
==On Time Items (Assets)==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,319: Line 3,386:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|On Time Items  (Assets)
|
|ON_TIME_ITEMS
|
|DP_CSV6.ON_TIME_ITEMS_ASSETS
|}
|}
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
|-
|Schedule From ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|Dealer ||O || || || || || ||
|-
|Outbase ||O || || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Route Code ||O || || || || || ||
|-
|-
|Depot ||O || || || || || ||
|Media Type ||O || || || || || ||
|-
|-
|Message Type ||O || || || || || ||
|Schedule To ||M || || || || || ||
|}
|}


==Order Items POD Debriefed==
==On Time Returns==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,344: Line 3,415:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|On Time Returns
|
|ON_TIME_RETURNS
|
|DP_CSV6.ON_TIME_RETURNS
|}
|}
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
|-
|Media Type ||O || || || || || ||
|-
|Route Code ||O || || || || || ||
|-
|Outbase ||O || || || || || ||
|-
|Dealer ||O || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|End Schedule ||O || || || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Schedule To ||M || || || || || ||
|}
|}


==Order Savings==
==Operational Information==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,365: Line 3,444:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Operational  Information
|
|Operational_Information
|
|DP_CSV2.OPERATIONAL_INFO
|}
|}
Parameters:
Parameters:
{| class="wikitable"
==Order Charges Extract==
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Start Schedule ||M || || || || || ||
|-
|End Schedule ||O || || || || || ||
|-
|Show Neg Savings ||M || || || || || ||
|}
 
==Order Tracking==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,386: Line 3,455:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Order Charges  Extract
|
|ORD_CHARGE
|
|DP_CSV5.ORD_CHARGE_REPORT
|}
|}
Parameters:
Parameters:
Line 3,394: Line 3,463:
!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 ||OPENFIELD || || || ||
|Date ||M ||TODAY || || || || ||
|-
|Month ||M || || || || || ||
|-
|Week Offset ||O || || || || || ||
|-
|Year ||M || || || || || ||
|-
|Cost Centre ||O ||STRING ||OPENFIELDCC || || || ||
|}
|}


==Orders for Relabelling==
==Order Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,411: Line 3,472:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Order Extract
|
|ORDER_EXTRACT.csv
|
|DP_CSV2.HCR_ORDER_EXTRACT
|}
|}
Parameters:
Parameters:
Line 3,419: Line 3,480:
!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 Sched ||M || || || || || ||
|-
|Start Sched ||M || || || || || ||
|}
|}


== Orders to LogiX ==
==Order Interface Results==
== || || || || || || || || ||
|}
 
==Orders to Paragon==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,432: Line 3,491:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Order Interface  Results
|
|ORDER_INTERFACE_RESULTS
|
|CSV.ORDER_INTERFACE_RESULTS
|}
|}
Parameters:
Parameters:
Line 3,440: Line 3,499:
!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 || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|-
|Depot ||O || || || || || ||
|-
|Message Type ||O || || || || || ||
|}
|}


==Outbound Shortage==
==Order Items POD Debriefed==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,448: Line 3,516:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Order Items POD  Debriefed
|
|Order_Items_POD_Debriefed
|
|DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED
|}
|}
Parameters:
Parameters:
Line 3,456: Line 3,524:
!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 || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|End Schedule ||O || || || || || ||
|-
|-
|Dealer ||O ||STRING || || || || ||
|Start Schedule ||M || || || || || ||
|-
|}
|Media Type ||O ||STRING || || || || ||
|-
|Route ||O ||STRING || || || || ||
|-
|Depot ||O ||STRING || || || || ||
|-
|Customer ||O ||STRING || || || || ||
|}


==PAYMENT_DTLS==
==Order Savings==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,477: Line 3,537:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Order Savings
|
|ORDER_SAVINGS
|
|CSV.Order_savings
|}
|}
Parameters:
Parameters:
Line 3,485: Line 3,545:
!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 || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|End Schedule ||O || || || || || ||
|-
|-
|Customer ||M || || || || || ||
|Show Neg Savings ||M || || || || || ||
|}
|}


==POC to SAP Extract==
==Order Tracking==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,498: Line 3,558:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Order Tracking
|
|Order_Tracking
|
|DP_CSV5.ORDER_TRACKING
|}
|}
Parameters:
Parameters:
Line 3,506: Line 3,566:
!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 ||OPENFIELD || || || ||
 
==POC to SAP Extract(A)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|
|Month ||M || || || || || ||
|
|-
|
|Week Offset ||O || || || || || ||
|-
|Year ||M || || || || || ||
|-
|Cost Centre ||O ||STRING ||OPENFIELDCC || || || ||
|}
 
==Orders for Relabelling==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Orders for  Relabelling
|ORDERS_FOR_RELABELLING
|DP_CSV_DHL.ORDERS_FOR_RELABELLING
|}
|}
Parameters:
Parameters:
Line 3,522: Line 3,591:
!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
|-
|-
|Resend All? ||M ||STRING ||No || || || ||
|Schedule ||M || || || || || ||
|}
|}


==POD Delivery Extract==
== Orders to LogiX ==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Orders to LogiX
|LogiX_Orders
|DP_LOGIX.ORDER_EXPORT
|}
Parameters:
==Orders to Paragon==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,531: Line 3,611:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Orders to Paragon
|
|Paragon_Orders
|
|CSV.Orders_to_Paragon
|}
|}
Parameters:
Parameters:
Line 3,539: Line 3,619:
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|From Schedule ||M || || || || || ||
|}
 
==Outbound Shortage==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|To Schedule ||M || || || || || ||
|Outbound Shortage
|OUTBOUND_SHORTAGE
|DP_CSV6.OUTBOUND_SHORTAGE
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Del Msg Sent ||O ||STRING ||ALL || || || ||
|Schedule To ||M || || || || || ||
|-
|-
|POD Status ||O ||STRING ||ALL || || || ||
|Schedule From ||M || || || || || ||
|-
|-
|Carrier ||O ||STRING ||ALL || || || ||
|Dealer ||O ||STRING || || || || ||
|-
|-
|> Days Outstanding ||O ||STRING ||0 || || || ||
|Media Type ||O ||STRING || || || || ||
|-
|-
|Group ||O ||STRING ||ALL || || || ||
|Route ||O ||STRING || || || || ||
|-
|-
|Customer ||O ||STRING ||ALL || || || ||
|Depot ||O ||STRING || || || || ||
|-
|-
|Scanning Depot ||O ||STRING ||ALL ||Depot ||Location Id ||Name ||
|Customer ||O ||STRING || || || || ||
|}
|}


==POD Generation Extract==
==PAYMENT_DTLS==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,564: Line 3,656:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|PAYMENT_DTLS
|
|PAYMENT_DTLS
|
|OF_INT.WRITE_PAYMENT_DETAILS
|}
|}
Parameters:
Parameters:
Line 3,572: Line 3,664:
!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 || || || || || ||
|End Date ||M ||TODAY || || || || ||
|-
|-
|Date To ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|-
|Date From ||M ||TODAY || || || || ||
|Customer ||M || || || || || ||
|-
|Schedule ||O || || || || || ||
|}
|}


==POD to SAP Extract==
==POC to SAP Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,587: Line 3,677:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|POC to SAP Extract
|
|POC to SAP Extract
|
|CSV.POC_to_Sap_Extract
|}
|}
Parameters:
Parameters:
Line 3,597: Line 3,687:
|}
|}


==POD to SAP Extract(A)==
==POC to SAP Extract(A)==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,603: Line 3,693:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|POC to SAP  Extract(A)
|
|POC to SAP Extract(A)
|
|CSV.POC_to_Sap_Extract
|}
|}
Parameters:
Parameters:
Line 3,614: Line 3,704:
|}
|}


==PORSCHE19 Invoice Extract==
==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:
==POD Delivery Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,620: Line 3,721:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|POD Delivery  Extract
|
|POD_Delivery_Extract
|
|DP_CSV2.POD_DELIVERY_EXTRACT
|}
|}
Parameters:
Parameters:
Line 3,628: Line 3,729:
!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 ||PORSCHE19 || || || ||
|From Schedule ||M || || || || || ||
|-
|-
|Sub Debit Account ||O ||STRING ||ALL || || || ||
|To Schedule ||M || || || || || ||
|-
|-
|Trip ID ||O ||STRING ||ALL || || || ||
|Del Msg Sent ||O ||STRING ||ALL || || || ||
|-
|POD Status ||O ||STRING ||ALL || || || ||
|-
|-
|Sub Credit Account ||O ||STRING ||ALL || || || ||
|Carrier ||O ||STRING ||ALL || || || ||
|-
|-
|Invoice ID ||O ||STRING ||0 || || || ||
|> Days Outstanding ||O ||STRING ||0 || || || ||
|-
|-
|Export ID ||O ||STRING ||0 || || || ||
|Group ||O ||STRING ||ALL || || || ||
|}
 
== PROVIDER_REVENUE ==
== || ||Owning Depot ||O || || || || || ||
|-
|-
|To Schedule ||M || || || || || ||
|Customer ||O ||STRING ||ALL || || || ||
|-
|-
|From Schedule ||M || || || || || ||
|Scanning Depot ||O ||STRING ||ALL ||Depot ||Location Id ||Name ||
|}
|}


==Parts and Empites==
==POD Generation Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,655: Line 3,754:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|POD Generation  Extract
|
|POD_GEN
|
|DP_CSV5.POD_REPORT
|}
|}
Parameters:
Parameters:
Line 3,663: Line 3,762:
!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
|-
|-
|Export Type ||M || || || || || ||
|POD Flow ||M || || || || || ||
|-
|-
|Schedule From ||M || || || || || ||
|Date To ||M ||TODAY || || || || ||
|-
|-
|Schedule To ||M || || || || || ||
|Date From ||M ||TODAY || || || || ||
|-
|-
|Location From ||O || || || || || ||
|Schedule ||O || || || || || ||
|-
|Customer ||M || || || || || ||
|}
|}


==PostCode Matrix==
==POD to SAP Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,680: Line 3,777:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|POD to SAP Extract
|
|POD to SAP Extract
|
|CSV.POD_to_Sap_Extract
|}
|}
Parameters:
Parameters:
Line 3,690: Line 3,787:
|}
|}


==Pre Invoice Check==
==POD to SAP Extract(A)==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,696: Line 3,793:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|POD to SAP  Extract(A)
|
|POD to SAP Extract(A)
|
|CSV.POD_to_Sap_Extract
|}
|}
Parameters:
Parameters:
Line 3,704: Line 3,801:
!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
|-
|-
|Cut-off Date ||M ||TODAY || || || || ||
|Resend All? ||M ||STRING ||No || || || ||
|}
|}


==Process Items Interface Audit==
==PORSCHE19 Invoice Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,713: Line 3,810:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|PORSCHE19 Invoice  Extract
|
|Invoice_Extract
|
|DP_CSV2.Invoice_Extract
|}
|}
Parameters:
Parameters:
Line 3,721: Line 3,818:
!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 || || || ||
|Customer ||M ||STRING ||PORSCHE19 || || || ||
|-
|Sub Debit Account ||O ||STRING ||ALL || || || ||
|-
|Trip ID ||O ||STRING ||ALL || || || ||
|-
|-
|Start Date ||M ||TODAY || || || || ||
|Sub Credit Account ||O ||STRING ||ALL || || || ||
|-
|-
|End Date ||M ||TODAY || || || || ||
|Invoice ID ||O ||STRING ||0 || || || ||
|-
|-
|Record Status ||M ||STRING ||ALL || || || ||
|Export ID ||O ||STRING ||0 || || || ||
|}
|}


==Provisional Booking Exceptions==
== PROVIDER_REVENUE ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,736: Line 3,837:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|PROVIDER_REVENUE
|
|PROVIDER_REVENUE
|
|dp_csv3.provider_revenue
|}
|}
Parameters:
Parameters:
{| class="wikitable"
 
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
== || ||Owning Depot ||O || || || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Schedule ||M || || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Schedule ||M || || || || || ||
|}
|}


==Purchase Order Extract==
==Parts and Empites==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,755: Line 3,856:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Parts and Empites
|
|Parts_and_Empties
|
|DP_CSV5.PARTS_AND_EMPTIES
|}
|}
Parameters:
Parameters:
Line 3,763: Line 3,864:
!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 || || || ||
|Export Type ||M || || || || || ||
|-
|Schedule From ||M || || || || || ||
|-
|Schedule To ||M || || || || || ||
|-
|-
|To Date ||O ||TODAY ||TODAY || || || ||
|Location From ||O || || || || || ||
|-
|-
|From Date ||O ||TODAY ||TODAY || || || ||
|Customer ||M || || || || || ||
|}
|}


==Reason Listings==
==PostCode Matrix==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,776: Line 3,881:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|PostCode Matrix
|
|POSTCODE_MATRIX
|
|dp_csv3.postcode_matrix
|}
|}
Parameters:
Parameters:
Line 3,784: Line 3,889:
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Date From ||M ||DATETIME ||TODAY:00:01 || || || ||
|}
|-
|Depot ||M || || || || || ||
|-
|Date To ||M ||DATETIME ||TODAY:23:59 || || || ||
|}


==Receipt Scanning==
==Pre Invoice Check==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,797: Line 3,897:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Pre Invoice Check
|
|Pre_Invoice_Check
|
|CSV.PRE_INVOICE_CHECK
|}
|}
Parameters:
Parameters:
Line 3,805: Line 3,905:
!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 ||STRING || || || || ||
|Cut-off Date ||M ||TODAY || || || || ||
|-
|Route ||O ||STRING || || || || ||
|-
|Media Type ||O ||STRING || || || || ||
|-
|Customer ||O ||STRING || || || || ||
|-
|Date To ||M ||TODAY || || || || ||
|-
|Date From ||M ||TODAY || || || || ||
|-
|Depot ||O ||STRING || || || || ||
|}
|}


==Receiving Extract==
==Process Items Audit==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,826: Line 3,914:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Process Items Audit
|
|PROCESS_ITEMS_AUDIT
|
|DP_CSV6.PROCESS_ITEMS_AUDIT
|}
|}
Parameters:
Parameters:
==Process Items Interface Audit==
{| 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 || || || || || ||
|Process Items  Interface Audit
|}
|PROCESS_ITEMS_INTERFACE_AUDIT
 
|DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT
==Revenue Check (Account)==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|
|
|
|}
|}
Parameters:
Parameters:
Line 3,851: Line 3,933:
!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 || || || || ||
|Incl. Reprocessed ||M ||STRING ||N || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Start Date ||M ||TODAY || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|End Date ||M ||TODAY || || || || ||
|-
|-
|Cust Group ||O || || || || || ||
|Record Status ||M ||STRING ||ALL || || || ||
|-
|Customer ||O || || || || || ||
|}
|}


==SMS Email Summary Report==
==Provisional Booking Exceptions==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,868: Line 3,948:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Provisional Booking  Exceptions
|
|Provisional Booking Exceptions
|
|CSV.Provisional_Booking_Exceptions
|}
|}
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
|-
|To Date ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||M ||STRING ||ALL || || || ||
|}
|}


==STL Trip and Order Extract==
==Purchase Order Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,887: Line 3,967:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Purchase Order  Extract
|
|po_extract
|
|DP_CSV2.PURCHASE_ORDER_EXTRACT
|}
|}
Parameters:
Parameters:
Line 3,895: Line 3,975:
!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 || || || || || ||
|Status ||O ||STRING ||All || || || ||
|-
|-
|End Trip Schedule ||M || || || || || ||
|To Date ||O ||TODAY ||TODAY || || || ||
|-
|-
|Order Status ||O || || || || || ||
|From Date ||O ||TODAY ||TODAY || || || ||
|-
|Carrier ||O || || || || || ||
|-
|Location Type ||O || || || || || ||
|}
|}


==Sales Margin Extract==
==Reason Listings==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,912: Line 3,988:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Reason Listings
|
|REASON_LISTING_
|
|dp_csv3.reasons_listing
|}
|}
Parameters:
Parameters:
Line 3,920: Line 3,996:
!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 || || || || || ||
|Date From ||M ||DATETIME ||TODAY:00:01 || || || ||
|-
|-
|Schedule ||M || || || || || ||
|Depot ||M || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Date To ||M ||DATETIME ||TODAY:23:59 || || || ||
|-
|Last Schedule ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|}
|}


==Savings Extract==
==Receipt Scanning==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,937: Line 4,009:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Receipt Scanning
|
|RECEIPT_SCANNING
|
|DP_CSV6.RECEIPT_SCANNING
|}
|}
Parameters:
Parameters:
Line 3,945: Line 4,017:
!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 || || || || ||
|Dealer ||O ||STRING || || || || ||
|-
|-
|Credit Acc ||O || || || || || ||
|Route ||O ||STRING || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Media Type ||O ||STRING || || || || ||
|-
|-
|To Cty Code ||O || || || || || ||
|Customer ||O ||STRING || || || || ||
|-
|-
|From Cty Code ||O || || || || || ||
|Date To ||M ||TODAY || || || || ||
|-
|-
|Lane Id ||O || || || || || ||
|Date From ||M ||TODAY || || || || ||
|-
|-
|From Date ||O ||TODAY || || || || ||
|Depot ||O ||STRING || || || || ||
|-
|Debit Acc ||O || || || || || ||
|-
|Saving (> or <) ||O ||STRING || || || || ||
|}
|}


==Schedule==
==Receiving Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,970: Line 4,038:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Receiving Extract
|
|RECEIVING_EXTRACT
|
|DP_CSV_GEN.EXT_RECEIVING
|}
|}
Parameters:
Parameters:
Line 3,978: Line 4,046:
!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 ||M || || || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|}
|}


==Schedule Details==
==Revenue Check (Account)==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 3,989: Line 4,055:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Revenue Check  (Account)
|
|revenue_report
|
|dp_csv_nr.revenue_report
|}
|}
Parameters:
Parameters:
Line 3,997: Line 4,063:
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Start Schedule ||M || || || || || ||
|From Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|Cust Group ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Customer ||O || || || || || ||
|}
|}


==Schedule Trips CS==
==SMS Email Summary Report==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,008: Line 4,080:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|SMS Email Summary  Report
|
|sms_email_summary
|
|DP_CSV5.SMS_EMAIL_SUMMARY
|}
|}
Parameters:
Parameters:
Line 4,016: Line 4,088:
!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 ||M ||TODAY || || || || ||
|-
|Cost Centre ||M ||STRING ||ALL || || || ||
|}
|}


==Schedule Trips CS==
==STL Trip and Order Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,025: Line 4,099:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|STL Trip and Order  Extract
|
|STL_Trip_Order_Extract
|
|DP_CSV2.STL_TRIP_ORDER_EXTRACT
|}
|}
Parameters:
Parameters:
Line 4,033: Line 4,107:
!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 || || || || || ||
|Start Trip Schedule ||M || || || || || ||
|-
|End Trip Schedule ||M || || || || || ||
|-
|Order Status ||O || || || || || ||
|-
|Carrier ||O || || || || || ||
|-
|Location Type ||O || || || || || ||
|}
|}


==Scheduled and Cancelled Orders==
==Sales Margin Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,042: Line 4,124:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Sales Margin  Extract
|
|sme
|
|CSV.order_costs
|}
|}
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
|-
|Schedule ||M || || || || || ||
|-
|Last Schedule ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|-
|Carrier Group ||O || || || || || ||
|Carrier Group ||O || || || || || ||
|}
== Scheduled and Cancelled Orders v2 ==
|-
|-
|Schedule ||M || || || || || ||
|Schedule ||M || || || || || ||
|-
|-
|Customer ||O || || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|Last Schedule ||O || || || || || ||
|Last Schedule ||O || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|Carrier Group ||O || || || || || ||
|}
|}


==Short Rail Report==
==Savings Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,080: Line 4,149:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Savings Extract
|
|Savings
|
|CSV.SAVINGS_EXTRACT
|}
|}
Parameters:
Parameters:
Line 4,088: Line 4,157:
!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 || || || || || ||
|To Date ||O ||TODAY || || || || ||
|-
|-
|Product Type ||O || || || || || ||
|Credit Acc ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|To Cty Code ||O || || || || || ||
|-
|From Cty Code ||O || || || || || ||
|-
|Lane Id ||O || || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|-
|Debit Acc ||O || || || || || ||
|-
|Saving (> or <) ||O ||STRING || || || || ||
|}
|}


==Slot Extract==
==Schedule==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,103: Line 4,182:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Schedule
|
|Schedule
|
|CSV.SCHEDULE
|}
|}
Parameters:
Parameters:
Line 4,111: Line 4,190:
!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 ||M ||TODAY || || || || ||
|-
|-
|Slot Type ||O ||String ||ALL || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|Location Type ||O ||String ||ALL || || || ||
|}
|}


== Store PVA ==
==Schedule Details==
|| ||Del
|-
|ivery Date ||M || || || || || ||
|}
 
==Store Pre Warning==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,130: Line 4,201:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Schedule Details
|
|schedule_details
|
|DP_CSV_GEN.SCHEDULE
|}
|}
Parameters:
Parameters:
Line 4,138: Line 4,209:
!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 empty Slots ||O ||STRING ||N || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Depot ||O || || ||Depot ||Location Id ||Name ||
|End Schedule ||M || || || || || ||
|-
|Store ||O || || ||Store ||Location Id ||Name ||
|-
|Sched Name ||M || || || || || ||
|}
|}


==Sub Contractor==
==Schedule Trips CS==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,153: Line 4,220:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Schedule Trips CS
|
|SCHED_TRIPS_CS
|
|CSV.SCHEDULE_TRIPS_CS
|}
|}
Parameters:
Parameters:
Line 4,161: Line 4,228:
!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 Sched ||M || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Cost Centre ||M || || || || || ||
|Schedule
|-
|M
|From Sched ||M || || || || || ||
|
|
|
|
|
|
|}
|}


==Supplier DUs==
==Scheduled and Cancelled Orders==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,174: Line 4,246:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Scheduled and  Cancelled Orders
|
|Schedule_Orders
|
|CSV.SCHEDULE_ORDERS_VS
|}
|}
Parameters:
Parameters:
Line 4,182: Line 4,254:
!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 || || || ||
|Schedule ||M || || || || || ||
|-
|-
|From ||M || ||TODAY || || || ||
|Last Schedule ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Carrier Group ||O || || || || || ||
|}
|}


==Supplier DUs By Store==
== Scheduled and Cancelled Orders v2 ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,193: Line 4,271:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Scheduled and  Cancelled Orders v2
|
|fn
|
|CSV.SCHEDULE_ORDERS_VS_V2
|}
|}
Parameters:
Parameters:
Line 4,201: Line 4,279:
!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 ||
|Schedule ||M || || || || || ||
|-
|Last Schedule ||O || || || || || ||
|-
|-
|Order Status ||O || || || || || ||
|Customer Group ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Carrier Group ||O || || || || || ||
|}
|}


==Supplier Invoice==
== Short Rail Report ==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,216: Line 4,296:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Short Rail Report
|
|short_rail_rep
|
|dp_csv_nr.short_rail_report
|}
|}
Parameters:
Parameters:
Line 4,224: Line 4,304:
!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 Date ||O || || || || || ||
|Cost Centre ||O || || || || || ||
|-
|-
|End Date ||O || || || || || ||
|Product Type ||O || || || || || ||
|-
|Invoice ID ||O ||STRING || || || || ||
|-
|End Date ||O || || || || || ||
|-
|Invoice ID ||O ||STRING || || || || ||
|-
|Start Date ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Start Schedule ||M || || || || || ||
Line 4,241: Line 4,313:
|}
|}


==Supplier Revenue 2==
==Slot Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,247: Line 4,319:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Slot Extract
|
|Slot_Extract
|
|DP_CSV3.Slot_Extract
|}
|}
Parameters:
Parameters:
Line 4,255: Line 4,327:
!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 || || || ||
|Day ||O ||String ||ALL || || || ||
|-
|Slot Type ||O ||String ||ALL || || || ||
|-
|-
|Revenue End ||M || ||TODAY || || || ||
|Location Type ||O ||String ||ALL || || || ||
|}
|}


==TYRE SUMMARY EXTRACT==
== Store PVA ==
{{Note}} Can be run from Trip Waterfall screen.
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,267: Line 4,340:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Store PVA
|
|STORE_PVA
|
|DP_CSV_DUN.STORE_PVA
|}
|}
Parameters:
Parameters:
{| class="wikitable"
 
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|| ||Del
|-
|-
|Schedule ||M || || || || || ||
|ivery Date ||M || || || || || ||
|}
|}


==Trip Actuals==
==Store Pre Warning==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,284: Line 4,357:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Store Pre Warning
|
|Store_Pre_Warning
|
|CSV.Store_Pre_Warning
|}
|}
Parameters:
Parameters:
Line 4,292: Line 4,365:
!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 || || || || || ||
|Show empty Slots ||O ||STRING ||N || || || ||
|}
|-
 
|Depot ||O || || ||Depot ||Location Id ||Name ||
==Trip Assessment Extract==
|-
|Store ||O || || ||Store ||Location Id ||Name ||
|-
|Sched Name ||M || || || || || ||
|}
 
==Sub Contractor==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,301: Line 4,380:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Sub Contractor
|
|SUB_CONTRACTOR
|
|DP_CSV_GEN.SUB_CONTRACTOR
|}
|}
Parameters:
Parameters:
Line 4,309: Line 4,388:
!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 Sched ||M || || || || || ||
|-
|Cost Centre ||M || || || || || ||
|-
|From Sched ||M || || || || || ||
|}
|}


==Trip Extract==
==Supplier DUs==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,318: Line 4,401:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Supplier DUs
|
|SUPPLIER_DU_EXTRACT
|
|DP_CSV_GEN.SUPPLIER_DU_EXTRACT
|}
|}
Parameters:
Parameters:
Line 4,326: Line 4,409:
!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 || || || || || ||
|To ||M || ||TODAY || || || ||
|-
|-
|To Date ||O ||TODAY || || || || ||
|From ||M || ||TODAY || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|}
|}


==Trip and Order Detail Extract==
==Supplier DUs By Store==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,339: Line 4,420:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Supplier DUs By  Store
|
|SUPPLIER_DU_BY_STORE_EXTRACT
|
|DP_CSV_GEN.DU_STORE_EXTRACT
|}
|}
Parameters:
Parameters:
Line 4,347: Line 4,428:
!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 || || || || || ||
|Store ||O || || ||Store ||Location ID ||Name ||
|-
|Order Status ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|End Schedule ||M || || || || || ||
|-
|Location Type ||M || ||ALL || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Start Schedule ||M || || || || || ||
|}
|}


==Trunking Report==
==Supplier Invoice==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,362: Line 4,443:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Supplier Invoice
|
|Supplier_Invoice
|
|DP_CSV5.SUPPLIER_INVOICE
|}
|}
Parameters:
Parameters:
Line 4,370: Line 4,451:
!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 Date ||O || || || || || ||
|-
|End Date ||O || || || || || ||
|-
|Invoice ID ||O ||STRING || || || || ||
|-
|End Date ||O || || || || || ||
|-
|Invoice ID ||O ||STRING || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|Start Date ||O || || || || || ||
|-
|-
|Start Schedule ||M || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Report Type ||M ||STRING ||Revenue || || || ||
|End Schedule ||M || || || || || ||
|}
|}


==UNISON Interface Results==
==Supplier Revenue==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,385: Line 4,474:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Supplier Revenue
|
|SUPPLIER_REVENUE_EXTRACT
|
|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT
|}
|}
Parameters:
Parameters:
Line 4,393: Line 4,482:
!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 ||
|Revenue Start ||M || ||TODAY || || || ||
|-
|-
|Customer ||O || || || || || ||
|Revenue End ||M || ||TODAY || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|}
|}


==User Activity Extract==
==Supplier Revenue 2==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,408: Line 4,493:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Supplier Revenue 2
|
|SUPPLIER_REVENUE_2_EXTRACT
|
|DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2
|}
|}
Parameters:
Parameters:
Line 4,416: Line 4,501:
!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 || || || || ||
|Revenue Start ||M || ||TODAY || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|Revenue End ||M || ||TODAY || || || ||
|}
|}


==User Last Logon Extract==
==TYRE SUMMARY EXTRACT==
{{Note}} Can be run from Trip Waterfall screen.
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,427: Line 4,513:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|TYRE SUMMARY  EXTRACT
|
|TYRE_SUMMARY_EXTRACT
|
|DP_CSV6.TYRE_SUMMARY_EXTRACT
|}
|}
Parameters:
Parameters:
Line 4,435: Line 4,521:
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Days since logon ||M ||STRING ||90 || || || ||
|Schedule ||M || || || || || ||
|}
|}


==Variance Analysis Store Detail==
==Trip Actuals==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,444: Line 4,530:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Trip Actuals
|
|TRIP_ACTUALS
|
|CSV.TRIP_ACTUALS
|}
|}
Parameters:
Parameters:
Line 4,455: Line 4,541:
|}
|}


==Variance Analysis Summary==
==Trip Assessment Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,461: Line 4,547:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Trip Assessment  Extract
|
|chk_trips
|
|dp_csv_lfs.chk_trips
|}
|}
Parameters:
Parameters:
Line 4,469: Line 4,555:
!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 ||M || || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|}
|}


==Variance Analysis Trip Detail==
==Trip Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,480: Line 4,564:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Trip Extract
|
|Trip_Extract
|
|CSV.Trip_Extract
|}
|}
Parameters:
Parameters:
Line 4,488: Line 4,572:
!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 || || || || || ||
|Carrier ||O || || || || || ||
|-
|To Date ||O ||TODAY || || || || ||
|-
|From Date ||O ||TODAY || || || || ||
|}
|}


==Vehicle Utilisation==
==Trip and Order Detail Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,497: Line 4,585:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Trip and Order  Detail Extract
|
|Trip_Order_Detail_Extract
|
|CSV.Trip_Order_Detail_Extract
|}
|}
Parameters:
Parameters:
Line 4,505: Line 4,593:
!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 || || || || || ||
|Carrier ||O || || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|End Schedule ||M || || || || || ||
|-
|Location Type ||M || ||ALL || || || ||
|-
|Start Schedule ||M || || || || || ||
|}
|}


==Vehicle Utilisation Heavy==
==Trunking Report==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,516: Line 4,608:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Trunking Report
|
|Trunking_Report
|
|CSV.Trunking_Report
|}
|}
Parameters:
Parameters:
Line 4,524: Line 4,616:
!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 || || || || || ||
|Depot ||M || || ||Depot ||Location Id ||Name ||
|-
|-
|Carrier Group ||O || || || || || ||
|End Schedule ||M || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|Start Schedule ||M || || || || || ||
|-
|-
|Customer Group ||O || || || || || ||
|Report Type ||M ||STRING ||Revenue || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|}
|}


==Vehicle Utilisation Non-Heavy==
==UNISON Interface Results==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,543: Line 4,631:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|UNISON Interface  Results
|
|UNSION_interface_results
|
|CSV.UNISON_if_res
|}
|}
Parameters:
Parameters:
Line 4,551: Line 4,639:
!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 || || || || || ||
|Depot ||O || || ||Depot ||Location Id ||Name ||
|-
|-
|Customer Group ||O || || || || || ||
|Customer ||O || || || || || ||
|-
|-
|Cost Centre ||O || || || || || ||
|To Date ||O ||TODAY || || || || ||
|-
|-
|End Schedule ||M || || || || || ||
|From Date ||O ||TODAY || || || || ||
|-
|Start Schedule ||M || || || || || ||
|-
|Carrier Code ||O || || || || || ||
|}
|}


==Volume Deviation Extract==
==User Activity Extract==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,570: Line 4,654:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|User Activity  Extract
|
|User_Activity_Extract
|
|CSV.User_Activity_Extract
|}
|}
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 || ||ALL || || || ||
|-
|-
|To Date ||M ||TODAY || || || || ||
|To Date ||M ||TODAY || || || || ||
|-
|-
|From Date ||M ||TODAY || || || || ||
|From Date ||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"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|-
|Schedule ||O || || || || || ||
|Days since logon ||M ||STRING ||90 || || || ||
|-
|}
|Cost Centre ||O || ||ALL || || || ||
 
==Variance Analysis Store Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|-
|Trip Leg ||O ||STRING ||ALL || || || ||
|Variance Analysis  Store Detail
|VAR_ANLYS_STORE_DTL
|CSV.VARIANCE_ANALYSIS_STORE_DTL
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|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"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|}
 
==Variance Analysis Trip Detail==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Variance Analysis  Trip Detail
|VAR_ANLYS_TRIP_DTL
|CSV.VARIANCE_ANALYSIS_TRIP_DTL
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|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"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier Code ||O || || || || || ||
|-
|Carrier Group ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|}
 
==Vehicle Utilisation Non-Heavy==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Vehicle Utilisation  Non-Heavy
|vehicle_util
|dp_csv_nr.vehicle_utilisation
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier Group ||O || || || || || ||
|-
|Customer Group ||O || || || || || ||
|-
|Cost Centre ||O || || || || || ||
|-
|End Schedule ||M || || || || || ||
|-
|Start Schedule ||M || || || || || ||
|-
|Carrier Code ||O || || || || || ||
|}
 
==Volume Deviation Extract==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Volume Deviation  Extract
|VOLUME_DEVIATION_EXTRACT
|DP_CSV5.volume_deviation_report
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Carrier ||O || ||ALL || || || ||
|-
|To Date ||M ||TODAY || || || || ||
|-
|From Date ||M ||TODAY || || || || ||
|-
|Schedule ||O || || || || || ||
|-
|Cost Centre ||O || ||ALL || || || ||
|-
|Trip Leg ||O ||STRING ||ALL || || || ||
|-
|-
|Include Unpacked ||O ||STRING ||Y || || || ||
|Include Unpacked ||O ||STRING ||Y || || || ||
|-
|-
|Deviation ||O ||STRING ||ALL || || || ||
|Deviation ||O ||STRING ||ALL || || || ||
|}
 
==Volume or Activity==
{| class="wikitable"
!'''Report Name'''
!'''Filename'''
!'''Procedure for Scheduling'''
|-
|Volume or Activity
|VOLUME_ACTIVITY
|DP_CSV6.VOLUME_ACTIVITY
|}
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule From ||M || || || || || ||
|-
|Schedule To ||M || || || || || ||
|-
|Route Code ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Dealer ||O || || || || || ||
|-
|Depot ||O || || || || || ||
|-
|Media Type ||O || || || || || ||
|}
|}


==Volume or Activity==
==WCS Location Snapshot==
{| class="wikitable"
{| class="wikitable"
!'''Report Name'''
!'''Report Name'''
Line 4,601: Line 4,876:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|WCS Location  Snapshot
|
|WCS_LOC_SANPSHOT
|
|DP_CSV2.wcs_loc_snapshot
|}
|}
Parameters:
Parameters:
{| class="wikitable"
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3
|-
|Schedule From ||M || || || || || ||
|-
|Schedule To ||M || || || || || ||
|-
|Route Code ||O || || || || || ||
|-
|Customer ||O || || || || || ||
|-
|Dealer ||O || || || || || ||
|-
|Depot ||O || || || || || ||
|-
|Media Type ||O || || || || || ||
|}
==WCS Order Items Extract==
==WCS Order Items Extract==
{| class="wikitable"
{| class="wikitable"
Line 4,630: Line 4,887:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|WCS Order Items  Extract
|
|WCS_ORDER_ITEMS_EXTRACT
|
|DP_CSV2.WCS_ORDER_ITEMS_EXTRACT
|}
|}
Parameters:
Parameters:
Line 4,653: Line 4,910:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|Weekly Transport  Report
|
|Weekly_Transport
|
|DP_CSV_BNL.Weekly_Transport
|}
|}
Parameters:
Parameters:
Line 4,674: Line 4,931:
!'''Procedure for Scheduling'''
!'''Procedure for Scheduling'''
|-
|-
|
|XML Order Interface  Export
|
|XML_Order_Interface
|
|DP_CSV3.XML_ORDER_INTERFACE
|}
|}
No Parameters
No Parameters

Revision as of 17:44, 30 July 2025

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

10.6 Customer By Product Export

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

10.6 Customer Location Export

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

10.6 Customer Product By Arrival

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

10.6 Data Extract

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

10.6 Load Status Export

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

10.6 Matthew Clark Data Extract

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

10.6 Planning Export

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

10.6 Tokairo Export

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

10.6 Warehouse Extract

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

1POD Delivery Extract

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

AA Trip and Order Detail

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

Parameters:

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

ACC Missing Payments

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

No parameters

ACTIVITY_EXTRACT

Report Name Filename Procedure for Scheduling
ACTIVITY_EXTRACT ACTIVITY_EXTRACT dp_csv3.activity_extract

Parameters:

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

Accruals

Report Name Filename Procedure for Scheduling
Accruals ACCRUALS CSV.ACCRUALS

Parameters:

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

Actual Load

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

Parameters:

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

Actual Unload

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

Parameters:

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

Additional Reporting Requirements

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

Parameters:

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

Amazon Resources

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

Parameters:

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

Amazon Resources Update

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

Parameters:

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

Approved Price Report

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

Parameters:

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

Asset History

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

Parameters:

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

Asset Status

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

Parameters:

Asset Utilisation

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

Parameters:

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

Assets On Time Delivery

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

Parameters:

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

Automotive Planning Report

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

Parameters:

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

BGW Trip and Order Detail

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

Parameters:

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

BGW_DEBRIEF

Report Name Filename Procedure for Scheduling
BGW_DEBRIEF BGW_DEBRIEF dp_csv3.bgw_debrief

Parameters:

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

BMW Asset Dwell

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

Parameters:

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

Backing Sheet

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

Parameters:

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

Baxter CSR

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

Parameters:

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

Baxter Download Id Orders

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

Parameters:

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

CARGOWISE Header

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

Parameters:

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:

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:

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

CN Warehouse Loading

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

Parameters:

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:

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

CTM Trips Not Responded To

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

Parameters:

Call Collection OTIF Day

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
Customer O
Customer Group O
Product Type O
End Schedule O
Start Schedule O
From Date M TODAY
To Date M TODAY

Call Collection OTIF Time Window

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
Customer O
Customer Group O
Product Type O
End Schedule O
Start Schedule O
To Date M TODAY
From Date M TODAY

Call Delivery OTIF Day

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Carrier O
From Date M TODAY
To Date M TODAY
Start Schedule O
End Schedule O
Product Type O
Customer Group O
Customer O

Call Delivery OTIF Time Window

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
End Schedule O
Product Type O
Customer Group O
Customer O
Carrier O
From Date M TODAY
To Date M TODAY
Start Schedule O

Campus KPI Extract

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

Parameters:

Carrier DUs Shipped

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

Parameters:

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

Carrier Delivery Report

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Sched Name M
Carrier M
Depot M
Trip ID O STRING ALL

Carrier Invoice

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

Parameters:

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

Carrier Self Billing

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

Parameters:

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

Catalyst Extract

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

Parameters:

Co-ordinate Non-Conformities

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

Parameters:

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

Commercial

Report Name Filename Procedure for Scheduling
Commercial COMMERCIAL CSV.Commercial_Orders

Parameters:

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

Compliance Report

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

Parameters:

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

Concurrent Logon Export

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

Parameters:

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

Contracts

Report Name Filename Procedure for Scheduling
Contracts CONTRACTS CSV.CONTRACTS

No Parameters

Cross Dock

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

Parameters:

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

Customer Invoice

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

Parameters:

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

Customer Invoice By Dates

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

Parameters:

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

Customer Invoice Extract

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

Parameters:

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

Cut Offs Extract

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

Parameters:

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

D365 Extract

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

Parameters:

DELIVERY_OVERVIEW

Report Name Filename Procedure for Scheduling
DELIVERY_OVERVIEW DELIVERY_OVERVIEW dp_csv3.delivery_overview

Parameters:

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

DOOD Rpt

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

Parameters:

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

DUs Despatched

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Consignment Num O STRING
Start Sched O
Manifest O STRING
PO Number O STRING
Supplier O
End Sched O

DUs Not Loaded

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

Parameters:

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

DUs Not Received

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

Parameters:

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

Daily Manifest E-OT-L

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

Parameters:

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

Daily Receiving E-OT-L

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

Parameters:

Daily Transport Plan

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Order Status M STRING ALL
Supplier M STRING ALL
To Date M
From Date M

Daily Unscheduled Orders

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

Parameters:

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

Debrief Performance

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

Parameters:

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

Del Scans

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

Parameters:

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

Delivery Conf

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Type M M
Owning Depot O
Cost Centre M
To Actual date M TODAY
From Actual date M TODAY

Delivery Schedule Extract

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

Parameters:

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

Depot Exits by Hour (Loads)

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

Parameters:

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

Depot Exits by Hour (RPEs)

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

Parameters:

Detailed Interface Report

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer Group O
To Date O TODAY
Customer O
From Date O TODAY
Status M STRING All

Dixons Catalyst Report

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

Parameters:

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

Dixons Order Export

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

Parameters:

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

Dixons Trip Extract

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

Parameters:

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

Driver Hours

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

Parameters:

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

Driver Scanning

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

Parameters:

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

Dunelm Actual Load

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

Parameters:

Dunelm Actual Unload

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

Parameters:

Dunelm Backing Sheet

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

Parameters:

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

Dunelm DUs Despatched Extract

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

Parameters:

Dunelm DUs Not Loaded Extract

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

Parameters:

Dunelm DUs Not Received

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

Parameters:

Dunelm Inventory Transactions

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

Parameters:

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

Dunelm Item Movements 3

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

Parameters:

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

Dunelm Item Movements Extract

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

Parameters:

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

Dunelm Item Movements Extract New

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

Parameters:

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

Dunelm Left Offs

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

Parameters:

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

Dunelm Loading Extract

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

Parameters:

Dunelm Manifest E-OT-L Extract

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

Parameters:

Dunelm Manual Loaded Items Extract

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

Parameters:

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

Dunelm Receiving Extract

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

Parameters:

Dunelm Recieving E-OT-L Extract

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

Parameters:

Dunelm Supplier DU Extract

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

Parameters:

Dunelm Supplier DU Extract by Store

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

Parameters:

Dunelm Supplier Revenue Extract

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

Parameters:

Dunelm Supplier Revenue Extract New

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

Parameters:

Dunelm Supplier Trends Extract

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

Parameters:

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

Dunelm Transport Plan

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

Parameters:

Dunelm Unsched Orders

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

Parameters:

Duplicate Postcodes

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

Parameters:

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

EFX Inbound Errors

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

Parameters:

ERC

Report Name Filename Procedure for Scheduling
ERC ERC DP_CSV_DHL.ERC

Parameters:

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

Equipment Moves

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

Parameters:

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

Extract Lane

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

Parameters:

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

Failed Shipment

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

Parameters:

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

Fixed Routes Extract

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

Parameters:

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

GREENE KING Interface Results

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

Parameters:

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

GYP EFX Export

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

Parameters:

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

HC Booking In Form

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

Parameters:

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

HC Haulier Trip Sheet

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

Parameters:

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

HCR Customer Orders

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

Parameters:

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

HCR Loading Sheet CSV

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

Parameters:

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

Haulier Invoice

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

Parameters:

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

Heavy Vehicle Utilisation

Warning Warning: Missing

Report Name Filename Procedure for Scheduling

Parameters:

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

Historical Lane Based Orders

Report Name Filename Procedure for Scheduling

Parameters:

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

IND Trip and Order Detail

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

Parameters:

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

ISC Finance (2) Export

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

Parameters:

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

ISC Finance (3) Export

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

Parameters:

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

ISC Finance (4) Export

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

Parameters:

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

Interface Errors Failures

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

Parameters:

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

Invalid Orders

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

Parameters:

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

Item Movements

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

Parameters:

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

Item Movements 2

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

Parameters:

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

Item Movements 3

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

Parameters:

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

Items Not Scanned By Date

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

Parameters:

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

Items Not Scanned By Trip

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

Parameters:

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

JEYES Interface Results

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

Parameters:

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

Job Notes

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

Parameters:

KPI By Lane

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

Parameters:

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

KPI Extract

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

Parameters:

Kraft KPI

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

Parameters:

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

LFS Packages

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

Parameters:

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

Lane Extract

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

Parameters:

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

Left Offs

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

Parameters:

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

Loading Extract

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

Parameters:

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

Loading Schedule CSV

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

Parameters:

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

Location Export

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

Parameters:

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

Location Export GL

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

Parameters:

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

Location Export GPR

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

Parameters:

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

Location Pre-Warning

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

Parameters:

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

MDD Code 03 Exceptions

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

Parameters:

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

MTS Finance Export

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

Parameters:

MTS Finance Export V2

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

Parameters:

Manual Loaded Items

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

Parameters:

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

Master and Child Locations

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

Parameters:

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

Message Maintenance

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

Parameters:

Missing Lat Long Report

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

Parameters:

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

Missing Steps Report

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

Parameters:

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

Month End Accruals

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

Parameters:

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

NR Additional Report

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

Parameters:

NR Finance Extract

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

Parameters:

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

NR Invoice

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

Parameters:

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

OPS KPI Extract

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

Parameters:

OPS KPI Extract2

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

Parameters:

OTM Export

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

Parameters:

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

On Time Arrivals

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

Parameters:

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

On Time Drops

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

Parameters:

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

On Time Items

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

Parameters:

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

On Time Items (Assets)

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

Parameters:

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

On Time Returns

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

Parameters:

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

Operational Information

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

Parameters:

Order Charges Extract

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

Parameters:

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

Order Extract

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

Parameters:

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

Order Interface Results

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

Parameters:

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

Order Items POD Debriefed

Report Name Filename Procedure for Scheduling
Order Items POD Debriefed Order_Items_POD_Debriefed DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED

Parameters:

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

Order Savings

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

Parameters:

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

Order Tracking

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

Parameters:

Name Mand Def Type Def Val LOV Column 1 Column 2 Column 3
Customer O STRING OPENFIELD
Month M
Week Offset O
Year M
Cost Centre O STRING OPENFIELDCC

Orders for Relabelling

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

Parameters:

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

Orders to LogiX

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

Parameters:

Orders to Paragon

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

Parameters:

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

Outbound Shortage

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

Parameters:

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

PAYMENT_DTLS

Report Name Filename Procedure for Scheduling
PAYMENT_DTLS PAYMENT_DTLS OF_INT.WRITE_PAYMENT_DETAILS

Parameters:

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

POC to SAP Extract

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

Parameters:

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

POC to SAP Extract(A)

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

Parameters:

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

POC-POD Reprocessing Team Export

Report Name Filename Procedure for Scheduling
POC-POD Reprocessing Team Export POC_POD_REPOROCESSING DP_CSV.POC_POD_REPROCESSING

Parameters:

POD Delivery Extract

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

Parameters:

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

POD Generation Extract

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

Parameters:

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

POD to SAP Extract

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

Parameters:

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

POD to SAP Extract(A)

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

Parameters:

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

PORSCHE19 Invoice Extract

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

Parameters:

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

PROVIDER_REVENUE

Report Name Filename Procedure for Scheduling
PROVIDER_REVENUE PROVIDER_REVENUE dp_csv3.provider_revenue

Parameters:

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

Parts and Empites

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

Parameters:

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

PostCode Matrix

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

Parameters:

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

Pre Invoice Check

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

Parameters:

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

Process Items Audit

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

Parameters:

Process Items Interface Audit

Report Name Filename Procedure for Scheduling
Process Items Interface Audit PROCESS_ITEMS_INTERFACE_AUDIT DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT

Parameters:

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

Provisional Booking Exceptions

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

Parameters:

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

Purchase Order Extract

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

Parameters:

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

Reason Listings

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

Parameters:

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

Receipt Scanning

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

Parameters:

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

Receiving Extract

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

Parameters:

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

Revenue Check (Account)

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

Parameters:

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

SMS Email Summary Report

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

Parameters:

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

STL Trip and Order Extract

Report Name Filename Procedure for Scheduling
STL Trip and Order Extract STL_Trip_Order_Extract DP_CSV2.STL_TRIP_ORDER_EXTRACT

Parameters:

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

Sales Margin Extract

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

Parameters:

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

Savings Extract

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

Parameters:

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

Schedule

Report Name Filename Procedure for Scheduling
Schedule Schedule CSV.SCHEDULE

Parameters:

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

Schedule Details

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

Parameters:

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

Schedule Trips CS

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

Parameters:

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

Scheduled and Cancelled Orders

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

Parameters:

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

Scheduled and Cancelled Orders v2

Report Name Filename Procedure for Scheduling
Scheduled and Cancelled Orders v2 fn CSV.SCHEDULE_ORDERS_VS_V2

Parameters:

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

Short Rail Report

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

Parameters:

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

Slot Extract

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

Parameters:

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

Store PVA

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

Parameters:

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

Store Pre Warning

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

Parameters:

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

Sub Contractor

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

Parameters:

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

Supplier DUs

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

Parameters:

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

Supplier DUs By Store

Report Name Filename Procedure for Scheduling
Supplier DUs By Store SUPPLIER_DU_BY_STORE_EXTRACT DP_CSV_GEN.DU_STORE_EXTRACT

Parameters:

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

Supplier Invoice

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

Parameters:

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

Supplier Revenue

Report Name Filename Procedure for Scheduling
Supplier Revenue SUPPLIER_REVENUE_EXTRACT DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT

Parameters:

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

Supplier Revenue 2

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

Parameters:

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

TYRE SUMMARY EXTRACT

Note Note: Can be run from Trip Waterfall screen.

Report Name Filename Procedure for Scheduling
TYRE SUMMARY EXTRACT TYRE_SUMMARY_EXTRACT DP_CSV6.TYRE_SUMMARY_EXTRACT

Parameters:

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

Trip Actuals

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

Parameters:

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

Trip Assessment Extract

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

Parameters:

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

Trip Extract

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

Parameters:

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

Trip and Order Detail Extract

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

Parameters:

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

Trunking Report

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

Parameters:

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

UNISON Interface Results

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

Parameters:

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

User Activity Extract

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

Parameters:

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

User Last Logon Extract

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

Parameters:

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

Variance Analysis Store Detail

Report Name Filename Procedure for Scheduling
Variance Analysis Store Detail VAR_ANLYS_STORE_DTL CSV.VARIANCE_ANALYSIS_STORE_DTL

Parameters:

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

Variance Analysis Summary

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

Parameters:

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

Variance Analysis Trip Detail

Report Name Filename Procedure for Scheduling
Variance Analysis Trip Detail VAR_ANLYS_TRIP_DTL CSV.VARIANCE_ANALYSIS_TRIP_DTL

Parameters:

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

Vehicle Utilisation

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

Parameters:

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

Vehicle Utilisation Heavy

Report Name Filename Procedure for Scheduling
Vehicle Utilisation Heavy hvy_vehicle_util dp_csv_nr.heavy_vehicle_utilisation

Parameters:

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

Vehicle Utilisation Non-Heavy

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

Parameters:

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

Volume Deviation Extract

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

Parameters:

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

Volume or Activity

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

Parameters:

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

WCS Location Snapshot

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

Parameters:

WCS Order Items Extract

Report Name Filename Procedure for Scheduling
WCS Order Items Extract WCS_ORDER_ITEMS_EXTRACT DP_CSV2.WCS_ORDER_ITEMS_EXTRACT

Parameters:

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

Weekly Transport Report

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

Parameters:

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

XML Order Interface Export

Report Name Filename Procedure for Scheduling
XML Order Interface Export XML_Order_Interface DP_CSV3.XML_ORDER_INTERFACE

No Parameters