Extracts Details: Difference between revisions
(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: | ||
|} | |} | ||
== | == 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 | ||
|- | |- | ||
| | |Customer ||M ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
|Start Schedule ||M || || || || || || | |||
|Start | |||
|} | |} | ||
== | == 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 | ||
|- | |- | ||
| | |Customer ||M ||STRING ||ALL || || || || | ||
|- | |- | ||
|End Schedule ||M || || || || || || | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |External Ref ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Customer ||O || || ||Customer || || || | ||
|- | |- | ||
| | |Source System ||O || || || || || || | ||
|- | |- | ||
| | |End Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Start Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Customer ||0 || || || || || || | ||
|} | |} | ||
==Item Movements | ==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 | ||
|- | |- | ||
| | |Actual To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Actual From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Supplier ||O || || || || || || | ||
|- | |- | ||
|DU Type ||O || || || || || || | |DU Type ||O || || || || || || | ||
|- | |- | ||
| | |Store ||O || || || || || || | ||
|- | |- | ||
| | |Manifest Number ||O || || || || || || | ||
|- | |- | ||
| | |P/O Number ||O || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |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== | ||
{| 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 | ||
|- | |- | ||
| | |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== | ||
{| 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 | |Schedule To ||M || || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |- | ||
|Depot || | |Depot ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Trip ||M || || || || || || | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |To Date ||O ||TODAY || || || || || | ||
|- | |||
|Customer ||O || || || || || || | |||
|- | |- | ||
| | |Depot ||O || || || || || || | ||
|- | |- | ||
| | |From Date ||O ||TODAY || || || || || | ||
|} | |} | ||
== | ==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: | ||
==KPI By Lane== | |||
==Lane | |||
{| 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 || || || || | |||
|- | |- | ||
| | |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== | |||
{| 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 | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|} | |} | ||
== | ==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 || || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |||
|Cost Centre ||O || || || || || || | |||
|- | |- | ||
|To | |To Loc ||O || || ||To Loc ||Location Id ||Name || | ||
|- | |- | ||
|From | |From Loc ||O || || ||From Loc ||Location Id ||Name || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Store (optional) ||O || || ||Store ||Location ID ||Name || | ||
|} | |- | ||
|Days Back ||M ||STRING ||30 || || || || | |||
|- | |||
|Trip ID (optional) ||O || || || || || || | |||
|} | |||
== | ==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 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Depot ||M || || ||Depot ||Location Id ||Name || | ||
|- | |- | ||
|To Date ||M ||TODAY || || || || || | |To Date ||M ||TODAY || || || || || | ||
|- | |||
|From Date ||M ||TODAY || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Country ||O || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Country ||O || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Country ||O || || || || || || | ||
|} | |} | ||
== | ==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 || || || || || | ||
|- | |- | ||
| | |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 || || || || | |||
|} | |} | ||
== | ==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 || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
| | |} | ||
| | |||
==MTS Finance Export== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |MTS Finance Export | ||
|FINANCE_EXPORT | |||
|CSV.finance_export_v2 | |||
|} | |||
Parameters: | |||
==MTS Finance Export V2== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |MTS Finance Export | ||
|FINANCE_EXPORT_V2 | |||
|CSV.finance_export_v2 | |||
|} | |} | ||
Parameters: | |||
== | ==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 || | |From Date ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||O || || || || || || | ||
|} | |||
==Master and Child Locations== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Master and Child Locations | ||
| | |Master_and_Child | ||
|DP_CSV5.MASTER_AND_CHILD | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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 == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Message Maintenance | ||
|Message_Maintenance | |||
|CSV.msg_maint | |||
| | |||
| | |||
|} | |} | ||
Parameters: | |||
== | ==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 | ||
|- | |- | ||
| | |Cost Centre ||M || ||ALL || || || || | ||
|} | |||
==Missing Steps Report== | |||
|} | |||
== | |||
{| 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 Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Missing Step ||O ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|- | |- | ||
|Customer ||O || || || || || || | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Cust Group ||O || || || || || || | ||
|} | |||
==NR Additional Report== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |NR Additional Report | ||
|nr_additional_rep | |||
|dp_csv_nr.nr_additional_report | |||
|} | |} | ||
Parameters: | |||
== | ==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 | ||
|- | |- | ||
| | |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 || || || || || || | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |From Region ||M ||STRING ||ALL || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |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 || || || || || || | |Customer ||O || || || || || || | ||
|- | |||
|Cost Centre ||O || || || || || || | |||
|} | |} | ||
== | ==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 !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |OPS KPI Extract2 | ||
|OPS_KPI_Extract | |||
|KPI.KPI_OPUS_EXTRACT | |||
| | |||
| | |||
|} | |} | ||
Parameters: | |||
== | ==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 || || || || || || | ||
|- | |- | ||
|Dealer ||O || || || || || || | |Dealer ||O || || || || || || | ||
|- | |- | ||
|Customer ||O || || || || || || | |Customer ||O || || || || || || | ||
|- | |||
|Schedule To ||M || || || || || || | |||
|- | |- | ||
|Schedule From ||M || || || || || || | |Schedule From ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Outbase ||O || || || || || || | ||
|- | |||
|Route Code ||O || || || || || || | |||
|- | |||
|Media Type ||O || || || || || || | |||
|- | |||
|Schedule To ||M || || || || || || | |||
|- | |||
|Customer ||O || || || || || || | |||
|- | |||
|Schedule From ||M || || || || || || | |||
|- | |||
|Dealer ||O || || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Dealer ||O || || || || || || | ||
|- | |||
|Outbase ||O || || || || || || | |||
|- | |||
|Route Code ||O || || || || || || | |||
|- | |||
|Schedule To ||M || || || || || || | |||
|- | |||
|Schedule From ||M || || || || || || | |||
|- | |||
|Media Type ||O || || || || || || | |||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|} | |} | ||
== | ==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 || || || || || || | ||
|- | |- | ||
| | |Dealer ||O || || || || || || | ||
|- | |||
|Outbase ||O || || || || || || | |||
|- | |- | ||
| | |Route Code ||O || || || || || || | ||
|- | |- | ||
| | |Media Type ||O || || || || || || | ||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|} | |} | ||
== | ==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 || || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|} | |} | ||
== | ==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: | ||
==Order Charges Extract== | |||
==Order | |||
{| 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 | ||
|- | |- | ||
| | |Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |End Sched ||M || || || || || || | ||
|- | |||
|Start Sched ||M || || || || || || | |||
|} | |} | ||
== | ==Order Interface Results== | ||
{| 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 || || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
|Schedule | |End Schedule ||O || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|} | |||
|} | |||
== | ==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 | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|- | |- | ||
| | |End Schedule ||O || || || || || || | ||
|- | |- | ||
| | |Show Neg Savings ||M || || || || || || | ||
|} | |} | ||
== | ==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 || || || || | ||
|- | |- | ||
| | |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 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | == 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 | ||
|- | |- | ||
| | |} | ||
==Outbound Shortage== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Outbound Shortage | ||
|OUTBOUND_SHORTAGE | |||
|DP_CSV6.OUTBOUND_SHORTAGE | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | ||
{| 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 | ||
|- | |- | ||
| | |End Date ||M ||TODAY || || || || || | ||
|- | |- | ||
|Date | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Customer ||M || || || || || || | ||
|} | |} | ||
== | ==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: | ||
|} | |} | ||
== | ==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: | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |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== | ||
{| 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 | ||
|- | |- | ||
| | |POD Flow ||M || || || || || || | ||
|- | |- | ||
| | |Date To ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Date From ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Schedule ||O || || || || || || | ||
|} | |} | ||
== | ==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: | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Resend All? ||M ||STRING ||No || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |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 == | ||
{| 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: | ||
== || ||Owning Depot ||O || || || || || || | |||
|- | |- | ||
|To | |To Schedule ||M || || || || || || | ||
|- | |- | ||
|From | |From Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Export Type ||M || || || || || || | ||
|- | |||
|Schedule From ||M || || || || || || | |||
|- | |||
|Schedule To ||M || || || || || || | |||
|- | |- | ||
| | |Location From ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
|} | |||
|} | |||
== | ==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 | ||
|- | |- | ||
| | |Cut-off Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==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 !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Process Items Interface Audit | ||
|PROCESS_ITEMS_INTERFACE_AUDIT | |||
|DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT | |||
| | |||
| | |||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Incl. Reprocessed ||M ||STRING ||N || || || || | ||
|- | |- | ||
| | |Start Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |End Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Record Status ||M ||STRING ||ALL || || || || | ||
|} | |} | ||
== | ==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 || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Status ||O ||STRING ||All || || || || | ||
|- | |- | ||
| | |To Date ||O ||TODAY ||TODAY || || || || | ||
|- | |- | ||
| | |From Date ||O ||TODAY ||TODAY || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Date From ||M ||DATETIME ||TODAY:00:01 || || || || | ||
|- | |- | ||
| | |Depot ||M || || || || || || | ||
|- | |- | ||
| | |Date To ||M ||DATETIME ||TODAY:23:59 || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |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== | ||
{| 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 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |||
|From Date ||M ||TODAY || || || || || | |||
|- | |||
|Cost Centre ||O || || || || || || | |||
|- | |||
|Cust Group ||O || || || || || || | |||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |||
|Cost Centre ||M ||STRING ||ALL || || || || | |||
|} | |} | ||
== | ==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 || || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
|Carrier Group ||O || || || || || || | |Carrier Group ||O || || || || || || | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule ||M || || || || || || | ||
|- | |- | ||
|Customer ||O || || || || || || | |Customer Group ||O || || || || || || | ||
|- | |- | ||
|Last Schedule ||O || || || || || || | |Last Schedule ||O || || || || || || | ||
|- | |- | ||
|Customer | |Customer ||O || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |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== | ||
{| 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 | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==Schedule Details== | ||
{| 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 | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Schedule | ||
| | |M | ||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Last Schedule ||O || || || || || || | ||
|- | |||
|Customer Group ||O || || || || || || | |||
|- | |||
|Customer ||O || || || || || || | |||
|- | |||
|Carrier Group ||O || || || || || || | |||
|} | |} | ||
== | == 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 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|- | |||
|Last Schedule ||O || || || || || || | |||
|- | |- | ||
| | |Customer Group ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Carrier Group ||O || || || || || || | ||
|} | |} | ||
== | == 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 | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|- | |- | ||
| | |Product Type ||O || || || || || || | ||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule ||M || || || || || || | ||
Line 4,241: | Line 4,313: | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Day ||O ||String ||ALL || || || || | ||
|- | |||
|Slot Type ||O ||String ||ALL || || || || | |||
|- | |- | ||
| | |Location Type ||O ||String ||ALL || || || || | ||
|} | |} | ||
== | == Store PVA == | ||
{| 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: | ||
|| ||Del | |||
|- | |- | ||
| | |ivery Date ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Show empty Slots ||O ||STRING ||N || || || || | ||
|} | |- | ||
|Depot ||O || || ||Depot ||Location Id ||Name || | |||
== | |- | ||
|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 | ||
|- | |- | ||
| | |To Sched ||M || || || || || || | ||
|- | |||
|Cost Centre ||M || || || || || || | |||
|- | |||
|From Sched ||M || || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |To ||M || ||TODAY || || || || | ||
|- | |- | ||
| | |From ||M || ||TODAY || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Store ||O || || ||Store ||Location ID ||Name || | ||
|- | |||
|Order Status ||O || || || || || || | |||
|- | |- | ||
|End Schedule ||M || || || || || || | |End Schedule ||M || || || || || || | ||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Start Date ||O || || || || || || | ||
|- | |||
|End Date ||O || || || || || || | |||
|- | |||
|Invoice ID ||O ||STRING || || || || || | |||
|- | |||
|End Date ||O || || || || || || | |||
|- | |||
|Invoice ID ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Start Date ||O || || || || || || | ||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule ||M || || || || || || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Revenue Start ||M || ||TODAY || || || || | ||
|- | |- | ||
| | |Revenue End ||M || ||TODAY || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Revenue Start ||M || ||TODAY || || || || | ||
|- | |- | ||
| | |Revenue End ||M || ||TODAY || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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: | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |||
|To Date ||O ||TODAY || || || || || | |||
|- | |||
|From Date ||O ||TODAY || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
|End Schedule ||M || || || || || || | |End Schedule ||M || || || || || || | ||
|- | |||
|Location Type ||M || ||ALL || || || || | |||
|- | |||
|Start Schedule ||M || || || || || || | |||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Depot ||M || || ||Depot ||Location Id ||Name || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Report Type ||M ||STRING ||Revenue || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
| | |Depot ||O || || ||Depot ||Location Id ||Name || | ||
|- | |- | ||
|Customer | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||O ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||O ||TODAY || || || || || | ||
|} | |} | ||
== | ==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 | ||
|- | |- | ||
|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 | |||
|- | |- | ||
| | |Days since logon ||M ||STRING ||90 || || || || | ||
| | |} | ||
| | |||
==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 || || || || || || | |||
|} | |} | ||
== | ==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: | ||
==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: Missing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Depot | O | Depot | Location Id | Name | |||
From Date | M | TODAY | |||||
Customer | O | ||||||
Group Name | O | ||||||
To Date | M | TODAY |
CN Equipment Moves
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CN Equipment Moves | Equip_Move | DP_CSV2.CN_EQUIP_MOVE |
Parameters:
CN Planning Export
Warning: Missing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Group Name | O | ||||||
Current Depot | M | Current Depot | Location Id | Name | |||
To Date | M | TODAY | |||||
From Date | M | TODAY |
CN Tokairo Export
Warning: Missing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | M | TODAY | |||||
From Date | M | TODAY |
CN Trip and Order Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CN Trip and Order Detail | CN_Trip_Order_Detail_Extract | CSV.CN_Trip_Order_Detail_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
End Schedule | M | ||||||
Start Schedule | M | ||||||
Loaded At | O | ||||||
Carrier | O | ||||||
Group Name | M | ||||||
Activity | M | STRING | Both |
CN Warehouse Loading
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CN Warehouse Loading | CN_Warehouse_Loading | DP_CSV_DHL.p_warehouse_loading |
Parameters:
CN Warehouse Extract
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: 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: 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