Extracts Details: Difference between revisions
(Initial Creation) |
(Updated parameters and extract names) |
||
Line 1: | Line 1: | ||
This is a full list of all extracts in the system. | This is a full list of all extracts in the system. | ||
== | == 10.6 Customer By Product Export == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
! | |||
|- | |- | ||
| | |10.6 Customer By Product Export | ||
|Cust_By_Product | |||
| colspan="2" |CSV.Cust_By_Product | |||
|} | |||
== 10.6 Customer Location Export == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |10.6 Customer Location Export | ||
|Customer_Location | |||
|CSV.Customer_Location | |||
|} | |||
== 10.6 Customer Product By Arrival == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |10.6 Customer Product By Arrival | ||
|Cust_Product_By_Arrive | |||
|CSV.Cust_Product_By_Arrive | |||
|} | |||
== 10.6 Data Extract == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |10.6 Data Extract | ||
|Data_Extract | |||
|CSV.Data_Extract | |||
|} | |||
== 10.6 Load Status Export == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |10.6 Load Status Export | ||
|Load_Status_Export | |||
|CSV.Load_Status_Export | |||
|} | |} | ||
== | == 10.6 Matthew Clark Data Extract == | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|10.6 Matthew Clark Data Extract | |||
|Matt_Clark_Data_Extract | |||
|CSV.Matt_Clark_Data_Extract | |||
|} | |||
== | == 10.6 Planning Export == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |10.6 Planning Export | ||
|Planning_Export | |||
|CSV.Planning_Export | |||
| | |||
| | |||
|} | |} | ||
== | == 10.6 Tokairo Export == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |10.6 Tokairo Export | ||
|Tokairo_Export | |||
|CSV.Tokairo_Export | |||
| | |} | ||
== 10.6 Warehouse Extract == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |10.6 Warehouse Extract | ||
|Warehouse_Extract | |||
|CSV.Warehouse_Extract | |||
|} | |} | ||
== | == 1POD Delivery Extract == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name ! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |1POD Delivery Extract | ||
|POD_Delivery_Extract | |||
|DP_CSV2.POD_DELIVERY_EXTRACT | |||
|} | |} | ||
== | == AA Trip and Order Detail == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |AA Trip and Order Detail | ||
| | |AA_Trip_Order_Detail_Extract | ||
| | |CSV.AA_Trip_Order_Detail_Extract | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |||
|Activity ||M ||STRING ||Both || || || || | |||
|- | |||
|Group Name ||M || || || || || || | |||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule ||M || || || || || || | ||
Line 80: | Line 134: | ||
|End Schedule ||M || || || || || || | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
| | |} | ||
| | |||
== ACC Missing Payments == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |ACC Missing Payments | ||
|ACC_Missing_Payment | |||
|DP_CSV_DUN.ACC_MISSING_PAYMENT | |||
|} | |} | ||
No parameters | |||
== | == ACTIVITY_EXTRACT == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |ACTIVITY_EXTRACT | ||
| | |ACTIVITY_EXTRACT | ||
| | |dp_csv3.activity_extract | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |To Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Owning Depot ||O || || || || || || | ||
|- | |- | ||
| | |From Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Accruals== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Accruals | |||
|ACCRUALS | |||
|CSV.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 | ||
|- | |- | ||
| | |Revenue After ||O || || || || || || | ||
|- | |- | ||
| | |Revenue Before ||O || || || || || || | ||
|- | |- | ||
| | |Customer Group ||O || || || || || || | ||
|- | |- | ||
| | |Debit Account ||O || || || || || || | ||
|- | |- | ||
| | |Credit Account ||O || || || || || || | ||
|} | |} | ||
== | == Actual Load== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Actual Load | |||
|ACTUAL_LOAD_EXTRACT | |||
|DP_CSV_GEN.DAILY_EXT_LOAD | |||
|} | |||
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 | ||
|- | |- | ||
| | |!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Load Date To ||M || || || || || || | ||
|- | |- | ||
| | |Load Date From ||M || || || || || || | ||
|} | |||
== Actual Unload== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Actual Unload | ||
|ACTUAL_UNLOAD_EXTRACT | |||
|DP_CSV_GEN.DAILY_EXT_UNLOAD | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |Load Date To ||M || || || || || || | ||
|- | |- | ||
| | |Load Date From ||M || || || || || || | ||
|} | |||
==Additional Reporting Requirements== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Additional Reporting Requirements | ||
| | |nr_additional_rep | ||
| | |dp_csv_nr.nr_additional_report | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! 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 Group ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|} | |||
==Amazon Resources== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Amazon Resources | ||
| | |FMC_BULK_UPLOAD | ||
| | |DP_CSV_CSS.AMAZON_RESOURCES | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Arrival Time To ||O || || || || || || | ||
|- | |- | ||
| | |Arrival Time From ||O || || || || || || | ||
| | |} | ||
| | |||
==Amazon Resources Update== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Amazon Resources Update | ||
|FMC_UPDATE | |||
|DP_CSV_CSS.AMAZON_RESOURCE_UPDATE | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !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== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Approved Price Report | ||
| | |approved_price_rep | ||
| | |dp_csv_nr.approved_price_report | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
|To Date ||M ||TODAY || || || || || | |To Date ||M ||TODAY || || || || || | ||
|- | |||
|Cost Centre ||O || || || || || || | |||
|- | |||
|Customer Group ||O || || || || || || | |||
|- | |- | ||
|Customer ||O || || || || || || | |Customer ||O || || || || || || | ||
|} | |} | ||
== | ==Asset History== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Asset History | |||
|ASSET_HISTORY | |||
|DP_CSV6.ASSET_HISTORY_EXTRACT | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Asset | |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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Asset Status | |||
|ASSET_STATUS | |||
|DP_CSV6.ASSET_STATUS | |||
|} | |||
Parameters: | Parameters: | ||
==Asset Utilisation== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Asset Utilisation | ||
|ASSET_UTILISATION | |||
|dp_csv4.asset_utilisation | |||
|} | |} | ||
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 | ||
|- | |- | ||
|Customer || | |Customer ||O || || || || || || | ||
|- | |||
|Route ||O || || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
Line 266: | Line 388: | ||
|To 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== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Assets On Time Delivery | ||
|ASSET_ON_TIME_DELIV | |||
|dp_csv4.asset_on_time_deliv | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! 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 || || || || || || | ||
|- | |- | ||
| | |Location ||O || || ||Location ||Location ||Location Name || | ||
|- | |- | ||
| | |Route ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==Automotive Planning Report== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Automotive Planning Report | ||
| | |Planning_Report | ||
| | |DP_CSV2.PLANNING_REPORT | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|BGW Trip and Order Detail | |||
|BGW_Trip_Order_Detail_Extract | |||
|DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! 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 || || || || || || | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
|Loaded At ||O || || || || || || | |Loaded At ||O || || || || || || | ||
|- | |- | ||
| | |Activity ||M ||STRING ||Both || || || || | ||
|- | |- | ||
|Group Name ||M || || || || || || | |Group Name ||M || || || || || || | ||
|} | |||
==BGW_DEBRIEF== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |BGW_DEBRIEF | ||
|BGW_DEBRIEF | |||
|dp_csv3.bgw_debrief | |||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
Line 346: | Line 494: | ||
|To Date ||M ||TODAY || || || || || | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|} | |||
==BMW Asset Dwell== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |BMW Asset Dwell | ||
|AUTO_ASSET_DWELL | |||
|DP_CSV3.AUTO_AFTERMARKET_BMW | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |Asset Type ||O || || || || || || | ||
|} | |||
==Backing Sheet== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Backing Sheet | ||
|BACKING_SHEET_EXTRACT | |||
|DP_CSV_GEN.BACKING_SHEET | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Baxter CSR | |||
|Baxter_csr | |||
|DP_CSV5.BAXTER_CSR | |||
|} | |||
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 | ||
|- | |- | ||
| | |Customer ||M ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|} | |||
==Baxter Download Id Orders== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Baxter Download Id Orders | ||
| | |Baxter Download | ||
| | |DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Download Id ||M ||STRING || || || || || | ||
|} | |||
==CARGOWISE Header== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |CARGOWISE Header | ||
|CARGOWISE_HEADER | |||
|OF_INT.WRITE_CARGOWISE_HEADER | |||
|} | |||
Parameters: | |||
==CN Data Extract== | |||
{{Warning}}Missing | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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 || || || || || | |To Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==CN Equipment Moves== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |CN Equipment Moves | ||
|Equip_Move | |||
|DP_CSV2.CN_EQUIP_MOVE | |||
|} | |||
Parameters: | |||
==CN Planning Export== | |||
{{Warning}}Missing | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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 || || || || || | |To Date ||M ||TODAY || || || || || | ||
Line 425: | Line 649: | ||
|} | |} | ||
== | ==CN Tokairo Export== | ||
{{Warning}}Missing | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
|} | |||
==CN Trip and Order Detail== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |CN Trip and Order Detail | ||
|CN_Trip_Order_Detail_Extract | |||
|CSV.CN_Trip_Order_Detail_Extract | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|CN Warehouse Loading | |||
|CN_Warehouse_Loading | |||
|DP_CSV_DHL.p_warehouse_loading | |||
|} | |||
Parameters: | |||
==CN Warehouse Extract== | |||
{{Warning}}Missing | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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 ||O || || || || || || | |Start Schedule ||M || || || || || || | ||
|- | |||
|End Schedule ||M || || || || || || | |||
|- | |||
|Customer ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME || | |||
|} | |} | ||
==Carrier | ==CTM Carrier Responsiveness== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |CTM Carrier Responsiveness | ||
| | |CTM_CARRIER_RESPONSIVENESS | ||
| | |CSV.CTM_CARRIER_RESPONSIVENESS | ||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Start Schedule ||O || || || || || || | ||
|- | |||
|Carrier ||O || || || || || || | |||
|- | |||
|End Schedule ||O || || || || || || | |||
|- | |- | ||
| | |Start Schedule ||O || || || || || || | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
| | |End Schedule ||O || || || || || || | ||
|} | |} | ||
== | ==CTM Trips Not Responded To== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|CTM Trips Not Responded To | |||
|CTM_TRIPS_NO_RESPONSE | |||
|CSV.CTM_TRIPS_NO_RESPONSE | |||
|} | |||
Parameters: | Parameters: | ||
==Call Collection OTIF Day== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Call Collection OTIF Day | ||
|coll_OTIF_date_window | |||
|dp_csv_nr.coll_otif_date_window | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Call Collection OTIF Time Window | ||
|coll_OTIF_window | |||
|dp_csv_nr.coll_otif_window | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||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== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Call Delivery OTIF Day | ||
|del_OTIF_date_window | |||
|dp_csv_nr.del_otif_date_window | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Start Schedule ||O || || || || || || | ||
|- | |- | ||
|Schedule | |End Schedule ||O || || || || || || | ||
|- | |- | ||
| | |Product Type ||O || || || || || || | ||
|- | |- | ||
| | |Customer Group ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|} | |||
==Call Delivery OTIF Time Window== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Call Delivery OTIF Time Window | ||
|del_OTIF_window | |||
|dp_csv_nr.del_otif_window | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |End Schedule ||O || || || || || || | ||
|- | |||
|Product Type ||O || || || || || || | |||
|- | |||
|Customer Group ||O || || || || || || | |||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Start Schedule ||O || || || || || || | ||
|} | |} | ||
== | ==Campus KPI Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Campus KPI Extract | ||
| | |Campus_KPI_Extract | ||
|KPI.KPI_CAMPUS_EXTRACT | |||
|} | |||
Parameters: | |||
==Carrier DUs Shipped== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Carrier DUs Shipped | ||
|CARRIER_DUS_SHIPPED | |||
|DP_CSV5.CARRIER_DUS_SHIPPED | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Carrier ||O ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==Carrier Delivery Report== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Carrier Delivery Report | |||
|Carrier_Delivery_Report | |||
|DP_CSV5.CARRIER_DELIVERY | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Sched Name ||M || || || || || || | ||
|- | |||
|Carrier ||M || || || || || || | |||
|- | |- | ||
| | |Depot ||M || || || || || || | ||
|- | |- | ||
| | |Trip ID ||O ||STRING ||ALL || || || || | ||
|} | |} | ||
== | ==Carrier Invoice== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Carrier Invoice | ||
|Carrier_Invoice | |||
|CSV.CARRIER_INVOICE | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Carrier Self Billing | |||
|Carrier_Self_billing | |||
|DP_CSV_BNL.CARRIER_SELF_BILLING | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! 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 | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Carrier ||0 || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Catalyst Extract== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Catalyst Extract | |||
|CATALYST_EXTRACT | |||
|CSV.CATALYST_EXTRACT | |||
|} | |||
Parameters: | Parameters: | ||
==Co-ordinate Non-Conformities== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
|Start | |Co-ordinate Non-Conformities | ||
|Co_Ord_Non_Conf | |||
|DP_CSV6.CO_ORD_NON_CONFORM | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Start Schedule ||M || || || || || || | |||
|- | |||
|Discrepancy Dist ||0 || ||1 || || || || | |||
|- | |- | ||
| | |TomTom,Epod,Both ||M || ||B || || || || | ||
|- | |- | ||
| | |Driver ||O || || || || || || | ||
|- | |- | ||
| | |Depot ||O || || || || || || | ||
|- | |- | ||
|End | |End Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Commercial== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Commercial | |||
|COMMERCIAL | |||
|CSV.Commercial_Orders | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Compliance Report== | ||
| | {| class="wikitable" | ||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Compliance Report | ||
|COMPLIANCE_REPORT | |||
|DP_CSV_DUN.COMPLIANCE_REPORT | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Collection Date ||M || || || || || || | ||
| | |} | ||
| | |||
==Concurrent Logon Export== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Concurrent Logon Export | ||
| | |Concurrent_Logon_Export | ||
| | |CSV.Concurrent_Logon | ||
|} | |} | ||
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 ||O ||TODAY || || || || || | ||
|- | |- | ||
| | |To Date ||O ||TODAY || || || || || | ||
| | |} | ||
| | |||
== Contracts == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Contracts | ||
|CONTRACTS | |||
|CSV.CONTRACTS | |||
|} | |} | ||
No Parameters | |||
== | ==Cross Dock== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Cross Dock | ||
| | |CROSS_DOCK | ||
| | |DP_CSV6.CROSS_DOCK | ||
|} | |} | ||
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 ||STRING || || || || || | ||
|- | |- | ||
| | |Route ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |- | ||
| | |Dealer ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Depot ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|- | |- | ||
| | |Customer ||O ||STRING || || || || || | ||
|} | |} | ||
== | ==Customer Invoice== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Customer Invoice | ||
| | |Customer_Invoice | ||
| | |CSV.Customer_Invoice | ||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Invoice No ||M || || || || || || | ||
|- | |||
|Credit Acc ||M || || || || || || | |||
|- | |- | ||
| | |Debit Acc ||M || || || || || || | ||
|- | |- | ||
| | |Invoice No ||M || || || || || || | ||
|- | |- | ||
| | |Debit Acc ||M || || || || || || | ||
|- | |- | ||
| | |Credit Acc ||M || || || || || || | ||
|} | |} | ||
== | ==Customer Invoice By Dates== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Customer Invoice By Dates | ||
|Customer_Invoice_By_Dates | |||
|CSV.Customer_Invoice_By_Dates | |||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Payment Status ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||M || || || || || || | ||
|- | |- | ||
| | |From Date ||M || || || || || || | ||
|- | |- | ||
| | |To Date ||M || || || || || || | ||
|} | |||
==Customer Invoice Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Customer Invoice Extract | ||
| | |Customer_Invoice | ||
| | |CSV.Customer_Invoice | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Invoice No ||M || || || || || || | ||
|- | |- | ||
| | |Credit Acc ||M || || || || || || | ||
|- | |- | ||
| | |Debit Acc ||M || || || || || || | ||
| | |} | ||
| | |||
==Cut Offs Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Cut Offs Extract | ||
|Cut_offs_extract | |||
|DP_CSV6.CUT_OFF_EXTRACT | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 842: | Line 1,229: | ||
|End Schedule ||M || || || || || || | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Customer ||0 || || || || || || | ||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==D365 Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |D365 Extract | ||
|DP_FINANCE.D365_EXPORT | |||
|D365_EXPORT_ | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
==DELIVERY_OVERVIEW== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |DELIVERY_OVERVIEW | ||
|DELIVERY_OVERVIEW | |||
|dp_csv3.delivery_overview | |||
| | |||
| | |||
|} | |} | ||
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 | |From Schedule ||M || || || || || || | ||
|- | |- | ||
| | |To Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Owning Depot ||O || || || || || || | ||
|- | |- | ||
| | |POD Confirmed ||O || || || || || || | ||
|} | |} | ||
== | ==DOOD Rpt== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|DOOD Rpt | |||
|DOOD_RPT | |||
|dp_csv_dood.dood_rpt | |||
|} | |||
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 To ||M || || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |- | ||
| | |Customer ||O ||STRING ||OPENFIELD || || || || | ||
| | |} | ||
| | ==DUs Despatched== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |DUs Despatched | ||
| | |DUS_DESPATCHED_EXTRACT | ||
| | |DP_CSV_GEN.DUS_DESPATCHED_EXTRACT | ||
|} | |} | ||
Parameters: | 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 | ||
|- | |- | ||
|Manifest ||O || || || || || || | |Consignment Num ||O ||STRING || || || || || | ||
|- | |||
|Start Sched ||O || || || || || || | |||
|- | |||
|Manifest ||O ||STRING || || || || || | |||
|- | |- | ||
| | |PO Number ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Supplier ||O || || || || || || | ||
|- | |- | ||
|Sched | |End Sched ||O || || || || || || | ||
|} | |} | ||
== | ==DUs Not Loaded== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|DUs Not Loaded | |||
|DUS_NOT_LOADED_EXTRACT | |||
|DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT | |||
|} | |||
Parameters: | 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 | ||
|- | |- | ||
| | |Store ||O || || ||Store ||Location ID ||Name || | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |||
== DUs Not Received == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |DUs Not Received | ||
|DUS_NOT_RECEIVED_EXTRACT | |||
|DP_CSV_GEN.DAILY_EXT_NOT_RECD | |||
|} | |||
Parameters: | |||
|- | |- | ||
| | |To Date ||M || || || || || || | ||
|- | |- | ||
| | |From Date ||M || || || || || || | ||
|- | |} | ||
| | |||
==Daily Manifest E-OT-L== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Daily Manifest E-OT-L | ||
|DAILY_MANIFEST_E_OT_L_EXTRACT | |||
|DP_CSV_GEN.DAILY_EXT_MANIFEST | |||
|} | |} | ||
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 || || || || || || | ||
|- | |- | ||
| | |To Date ||M || || || || || || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Daily Receiving E-OT-L== | ||
{| class="wikitable" | |||
!'''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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Daily Transport Plan | |||
|DAILY_TRANSPORT_PLAN_EXTRACT | |||
|DP_CSV_GEN.DAILY_TRANSPORT_PLAN | |||
|} | |||
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 | ||
|- | |- | ||
| | |Order Status ||M ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |Supplier ||M ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |To Date ||M || || || || || || | ||
|- | |- | ||
| | |From Date ||M || || || || || || | ||
|} | |||
==Daily Unscheduled Orders== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Daily Unscheduled Orders | ||
|DAILY_UNSCHEDULED_ORDERS_EXTRACT | |||
|DP_CSV_GEN.DAILY_UNSCHED_ORD | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |To Date ||M || || || || || || | ||
|- | |- | ||
| | |From Date ||M || || || || || || | ||
|} | |} | ||
== | ==Debrief Performance== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Debrief Performance | |||
|debrief_performance | |||
|dp_csv_nr.debrief_performance | |||
|} | |||
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 Code ||O || || || || || || | ||
|- | |- | ||
| | |Carrier Group ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Cust Group ||O || || || || || || | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==Del Scans== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Del Scans | ||
|DEL_SCANS | |||
|DP_CSV6.DEL_SCANS | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Delivery Conf== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Delivery Conf | ||
| | |BGYP_DELCONF_ | ||
| | |DP_CSV5.DELIVERY_CONF | ||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Type ||M || ||M || || || || | ||
|- | |||
|Owning Depot ||O || || || || || || | |||
|- | |||
|Cost Centre ||M || || || || || || | |||
|- | |- | ||
| | |To Actual date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Actual date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==Delivery Schedule Extract== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Delivery Schedule Extract | |||
|Delivery_Schedule | |||
|DP_CSV_DHL.DELIVERY_SCHEDULE | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Show Dates ||Y || || || || || || | ||
|} | |||
==Depot Exits by Hour (Loads)== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Depot Exits by Hour (Loads) | ||
|DEPOT_EXITS_LOADS | |||
|CSV.DEPOT_EXITS_BY_HOUR_LOADS | |||
| | |||
| | |||
|} | |} | ||
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 || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
|To Date ||M ||TODAY || || || || || | |To Date ||M ||TODAY || || || || || | ||
Line 1,078: | Line 1,541: | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |||
|Depot ||M || || ||Depot ||Location Id ||Name || | |||
|} | |} | ||
== | ==Depot Exits by Hour (RPEs)== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Depot Exits by Hour (RPEs) | |||
|DEPOT_EXITS_RPE | |||
|CSV.DEPOT_EXITS_BY_HOUR_RPE | |||
|} | |||
Parameters: | Parameters: | ||
==Detailed Interface Report== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Detailed Interface Report | ||
|Detailed_Interface_Report | |||
|CSV.Detailed_Interface_Report | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer Group ||O || || || || || || | ||
|- | |||
|To Date ||O ||TODAY || || || || || | |||
|- | |||
|Customer ||O || || || || || || | |||
|- | |- | ||
| | |From Date ||O ||TODAY || || || || || | ||
|- | |- | ||
| | |Status ||M ||STRING ||All || || || || | ||
|} | |} | ||
== | ==Dixons Catalyst Report== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Dixons Catalyst Report | |||
|fn | |||
|CSV.Dixons_Catalyst_Report | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
|Carrier ||O || || || || || || | |Carrier ||O || || || || || || | ||
|- | |- | ||
|Depot ||O || || ||Depot ||Location Id ||Name || | |Depot ||O || || ||Depot ||Location Id ||Name || | ||
|- | |||
|Start Schedule ||M || || || || || || | |||
|} | |} | ||
== | ==Dixons Order Export== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Dixons Order Export | |||
|Dixons_Order_Export | |||
|CSV.Dixons_Order_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 | ||
|- | |- | ||
| | |From Date ||O ||TODAY || || || || || | ||
|- | |||
|Carrier ||O || || || || || || | |||
|- | |||
|To Date ||O ||TODAY || || || || || | |||
|} | |||
==Dixons Trip Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Dixons Trip Extract | |||
|Dixons_Trip_Extract | |||
|CSV.Dixons_Trip_Extract | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
|To Date ||O ||TODAY || || || || || | |To Date ||O ||TODAY || || || || || | ||
Line 1,129: | Line 1,647: | ||
|} | |} | ||
== | ==Driver Hours== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Driver Hours | |||
|driver_hours | |||
|dp_csv_nr.driver_hours | |||
|} | |||
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 || || || || || | ||
|- | |- | ||
| | |Customer Group ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
|Cost Centre ||O || || || || || || | |Cost Centre ||O || || || || || || | ||
|} | |||
==Driver Scanning== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Driver Scanning | ||
|DRIVER_SCANNING | |||
|DP_CSV6.DRIVER_SCANNING | |||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Customer ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Dealer ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Depot ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Route ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Media Type ||O ||STRING || || || || || | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule To ||M || || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |- | ||
| | |Activity ||O ||STRING || || || || || | ||
|} | |} | ||
== | ==Dunelm Actual Load== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Dunelm Actual Load | |||
|DUNELM_ACTUAL_LOAD | |||
|DP_CSV_DUN.daily_ext_load | |||
|} | |||
Parameters: | Parameters: | ||
==Dunelm Actual Unload== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Actual Unload | ||
|DUNELM_ACTUAL_UNLOAD | |||
|DP_CSV_DUN.daily_ext_unload | |||
|} | |||
Parameters: | |||
==Dunelm Backing Sheet== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Backing Sheet | ||
|BACKING_SHEET | |||
|DP_CSV2.BACKING_SHEET | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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 == | |||
{| class="wikitable" | |||
!'''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 == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm DUs Not Loaded Extract | ||
|DUNELM_DUS_NOT_LOADED_EXTRACT | |||
|DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT | |||
|} | |||
Parameters: | |||
== Dunelm DUs Not Received == | |||
{| class="wikitable" | |||
!'''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 == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Inventory Transactions | ||
|DUN_INVENTORY_TRANS | |||
|DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS | |||
| | |||
| | |||
|} | |} | ||
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 | ||
|- | |- | ||
| | |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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Dunelm Item Movements 3 | |||
|DUN_ITEM_MOVEMENTS_EXTRACT | |||
|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3 | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Manifest Number ||O || || || || || || | ||
|- | |- | ||
| | |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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Item Movements Extract | ||
|DUN_ITEM_MOVEMENTS_EXTRACT | |||
|DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Manifest Number ||O ||STRING || || || || || | ||
|- | |||
|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== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Item Movements Extract New | ||
| | |DUN_ITEM_MOVEMENTS_EXTRACT | ||
| | |DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2 | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! 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 || || || || || || | ||
|- | |- | ||
| | |Manifest Number ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Store ||O || || || || || || | ||
|- | |- | ||
| | |DU Type ||O || || || || || || | ||
|- | |- | ||
| | |Supplier ||O || || || || || || | ||
|- | |- | ||
| | |Actual From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Actual To Date ||M ||TODAY || || || || || | ||
|} | |||
==Dunelm Left Offs== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Left Offs | ||
|Left_Offs_Extract | |||
|DP_CSV_DUN.left_offs_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 | ||
|- | |- | ||
| | |Trip Id (Optional) ||O || || || || || || | ||
|- | |- | ||
| | |Days Back ||M ||STRING ||30 || || || || | ||
|- | |- | ||
| | |Store (Optional) ||O || || ||Store ||Location Id ||Name || | ||
|} | |} | ||
== | ==Dunelm Loading Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Loading Extract | ||
|DUNELM_LOADING_EXTRACT | |||
|DP_CSV2.DUN_LOADING | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
==Dunelm Manifest E-OT-L Extract== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Manual Loaded Items Extract | ||
| | |MANL_SCAN_ORDER_DETAIL_EXTRACT | ||
| | |DP_CSV2.MANL_SCAN_ORDER_DETAIL_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 | ||
|- | |- | ||
| | |From Date ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||O || || || || || || | ||
|} | |||
== Dunelm Receiving Extract == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Receiving Extract | ||
|DUNELM_RECEIVING_EXTRACT | |||
|DP_CSV2.DUN_RECEIVING | |||
|} | |||
Parameters: | |||
== Dunelm Recieving E-OT-L Extract == | |||
{| class="wikitable" | |||
!'''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 == | |||
{| class="wikitable" | |||
!'''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 == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
|DU | |Dunelm Supplier DU Extract by Store | ||
|DUNELM_DU_STORE_EXTRACT | |||
|DP_CSV2.DUN_DU_STORE_EXTRACT | |||
|} | |||
Parameters: | |||
== Dunelm Supplier Revenue Extract == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
|Supplier || | |Dunelm Supplier Revenue Extract | ||
|DUNELM_SUPPLIER_REVENUE_EXTRACT | |||
|DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT | |||
|} | |||
Parameters: | |||
== Dunelm Supplier Revenue Extract New == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Supplier Revenue Extract New | ||
|DUNELM_SUPPLIER_REVENUE_NEW | |||
|DP_CSV2.DUN_SUPPLIER_REVENUE_NEW | |||
|} | |||
Parameters: | |||
== Dunelm Supplier Trends Extract == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Supplier Trends Extract | ||
|DUN_SUPPLIER_TRENDS | |||
|dp_csv_dun.dun_du_rpe_revenue_extract | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |Year ||M || || || || || || | ||
|- | |- | ||
| | |Week ||M || || || || || || | ||
|} | |||
==Dunelm Transport Plan== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Dunelm Transport Plan | ||
|DUNELM_TRANSPORT_PLAN | |||
|DP_CSV_DUN.daily_transport_plan | |||
|} | |} | ||
Parameters: | |||
== | == Dunelm Unsched Orders == | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Dunelm Unsched Orders | |||
|DUNELM_UNSCHED_ORD | |||
|DP_CSV_DUN.daily_unsched_ord | |||
|} | |||
Parameters: | Parameters: | ||
==Duplicate Postcodes== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Duplicate Postcodes | ||
|DUPLICATE_POSTCODES | |||
|dp_csv2.duplicate_postcodes_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 | ||
|- | |- | ||
| | |Ignore Inactive? ||O || || || || || || | ||
|- | |- | ||
| | |Location From ||O || || ||Location From ||Location Id ||Location Name || | ||
|- | |- | ||
| | |Location To ||O || || ||Location To ||Location Id ||Location Name || | ||
|} | |} | ||
== | ==EFX Inbound Errors== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|EFX Inbound Errors | |||
|EFX_Inbound_Errors | |||
|DP_CSV2.EFX_In_Errs_Extract | |||
|} | |||
Parameters: | Parameters: | ||
==ERC== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |ERC | ||
|ERC | |||
|DP_CSV_DHL.ERC | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Sched End ||M || || || || || || | ||
|- | |- | ||
| | |Sched Start ||M || || || || || || | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |||
|DHL Carriers ||M || || || || || || | |||
|- | |- | ||
| | |Detail Level ||M || || || || || || | ||
|} | |} | ||
== | ==Equipment Moves== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Equipment Moves | |||
|Equip_Move | |||
|DP_CSV2.EQUIP_MOVE | |||
|} | |||
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 | ||
|- | |- | ||
| | |Owning Depot ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|} | |} | ||
== | ==Extract Lane== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |Extract Lane | ||
|EXTRACT_LANE | |||
|CSV.EXTRACT_BY_LANE | |||
| | |||
| | |||
|} | |} | ||
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 | ||
|- | |- | ||
| | |Cost Centre ||O || || ||Cost Centre ||Location Id ||Name || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
| | |} | ||
| | |||
==Failed Shipment== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |- | ||
| | |Customer ||O ||STRING ||OPENFIELD || || || || | ||
|} | |||
==Fixed Routes Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Show Active / Inactive ||M ||STRING ||B || || || || | ||
|- | |- | ||
| | |Carrier ||O || || || || || || | ||
|- | |- | ||
| | |Depot ||O || || ||Depot ||Location Id ||Name || | ||
|} | |} | ||
== | ==GREENE KING Interface Results== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Depot || | |Customer ||O || || || || || || | ||
|- | |||
|Depot ||O || || || || || || | |||
|- | |- | ||
|To Date || | |To Date ||O ||TODAY || || || || || | ||
|- | |- | ||
|From Date || | |From Date ||O ||TODAY || || || || || | ||
|} | |} | ||
== | ==GYP EFX Export== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Trip Status ||O || || || || || || | ||
|- | |- | ||
| | |To Schedule ||M || || || || || || | ||
|- | |- | ||
| | |From Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|- | |- | ||
| | |Customer Group ||O || || || || || || | ||
|} | |||
==HC Booking In Form== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | | | ||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |||
|Schedule ||M || || || || || || | |||
|- | |- | ||
| | |Cost Centre ||O || || || || || || | ||
|- | |- | ||
| | |Depot ||O || || || || || || | ||
|} | |} | ||
== | ==HCR Loading Sheet CSV== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|From | |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 || || || || || || | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Group Name ||O || || || || || || | ||
|} | |} | ||
== | ==Haulier Invoice== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |End Date ||O || || || || || || | ||
|- | |- | ||
| | |Start Date ||O || || || || || || | ||
|- | |- | ||
| | |Invoice ID ||O ||STRING || || || || || | ||
|- | |- | ||
| | |End Date ||O || || || || || || | ||
|- | |- | ||
| | |Start Date ||O || || || || || || | ||
|- | |- | ||
| | |Invoice ID ||O ||STRING || || || || || | ||
|} | |||
==Heavy Vehicle Utilisation== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|To Date || | |To Date ||O ||TODAY || || || || || | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
|} | |||
==IND Trip and Order Detail== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer ||M ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Interface Errors Failures== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |External Ref ||O ||STRING || || || || || | ||
|- | |- | ||
| | |Customer ||O || || ||Customer || || || | ||
|- | |- | ||
| | |Source System ||O || || || || || || | ||
|- | |- | ||
| | |End Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Start Date ||M ||TODAY || || || || || | ||
|} | |||
==Invalid Orders== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | | | ||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|- | |- | ||
| | |End Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Customer ||0 || || || || || || | ||
| | |} | ||
| | |||
==Item Movements== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|- | |||
|Schedule From ||M || || || || || || | |||
|- | |- | ||
| | |Depot ||M || || || || || || | ||
|} | |} | ||
== | ==Items Not Scanned By Trip== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |Trip ||M || || || || || || | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |||
==JEYES Interface Results== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | | | ||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |||
|To Date ||O ||TODAY || || || || || | |||
|- | |- | ||
|Customer ||O || || || || || || | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Depot ||O || || || || || || | ||
|- | |- | ||
| | |From Date ||O ||TODAY || || || || || | ||
|} | |} | ||
== | ==KPI By Lane== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Customer ||O ||STRING || | |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 || || || || | ||
|} | |} | ||
== | ==Kraft KPI== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | | | ||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |||
|- | |||
|To Date ||M ||TODAY || || || || || | |||
|- | |||
|Cost Centre ||O || || || || || || | |||
|} | |} | ||
== | ==LFS Packages== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule | |Schedule ||M || || || || || || | ||
|- | |- | ||
| | |Order Status ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |External Ref ||O || || || || || || | ||
| | |} | ||
| | |||
==Lane Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |||
|Cost Centre ||O || || || || || || | |||
|- | |- | ||
| | |To Loc ||O || || ||To Loc ||Location Id ||Name || | ||
|- | |- | ||
| | |From Loc ||O || || ||From Loc ||Location Id ||Name || | ||
|} | |} | ||
== | ==Left Offs== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Store (optional) ||O || || ||Store ||Location ID ||Name || | |||
|- | |||
|Days Back ||M ||STRING ||30 || || || || | |||
|- | |||
|Trip ID (optional) ||O || || || || || || | |||
|} | |} | ||
== | ==Loading Extract== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Loading Schedule CSV== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Depot ||M || || ||Depot ||Location Id ||Name || | ||
|- | |- | ||
|To | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|} | |||
==Location Export== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |Country ||O || || || || || || | ||
|- | |} | ||
| | |||
==Location Pre-Warning== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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 || | |||
|- | |- | ||
|Date | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Load Type ||M ||STRING ||ALL || || || || | ||
|- | |- | ||
| | |Trip Status ||M ||STRING ||ALL || || || || | ||
|} | |} | ||
== | ==MDD Code 03 Exceptions== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |||
|- | |||
|To Date ||M ||TODAY || || || || || | |||
|} | |} | ||
== | ==Manual Loaded Items== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |From Date ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||O || || || || || || | ||
|} | |} | ||
== | ==Master and Child Locations== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Show UnMapped ||O || || ||Show UnMapped || || || | ||
|- | |- | ||
| | |Show Mapped ||O || || ||Show Mapped || || || | ||
| | |} | ||
== Message Maintenance == | |||
| | == || || || || || || || || || | ||
| | |||
|} | |} | ||
== | ==Missing Lat Long Report== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Cost Centre ||M || ||ALL || || || || | ||
|} | |} | ||
== | ==Missing Steps Report== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 2,062: | Line 3,010: | ||
|- | |- | ||
|To Date ||M ||TODAY || || || || || | |To Date ||M ||TODAY || || || || || | ||
|- | |||
|Missing Step ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==Month End Accruals== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |||
|Cost Centre ||O || || || || || || | |||
|- | |||
|Customer ||O || || || || || || | |||
|- | |- | ||
| | |Cust Group ||O || || || || || || | ||
|} | |} | ||
== | ==NR Finance Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |||
|To Date ||M ||TODAY || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
|From | |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 || || || || || || | |||
|} | |} | ||
== | ==OTM Export== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Date To ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Date From ||M ||TODAY || || || || || | ||
|- | |||
|Carrier ||O || || || || || || | |||
|} | |} | ||
== | ==On Time Arrivals== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Outbase ||O || || || || || || | ||
|- | |||
|Media Type ||O || || || || || || | |||
|- | |||
|Route Code ||O || || || || || || | |||
|- | |- | ||
| | |Dealer ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|} | |} | ||
== | ==On Time Drops== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Outbase ||O || || || || || || | ||
|- | |- | ||
| | |Route Code ||O || || || || || || | ||
|- | |- | ||
| | |Media Type ||O || || || || || || | ||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|- | |- | ||
|Customer ||O || || || || || || | |Customer ||O || || || || || || | ||
|- | |||
|Schedule From ||M || || || || || || | |||
|- | |||
|Dealer ||O || || || || || || | |||
|} | |} | ||
== | ==On Time Items== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Dealer ||O || || || || || || | ||
|- | |- | ||
| | |Outbase ||O || || || || || || | ||
|- | |- | ||
| | |Route Code ||O || || || || || || | ||
|- | |- | ||
|To | |Schedule To ||M || || || || || || | ||
|- | |- | ||
|From | |Schedule From ||M || || || || || || | ||
|- | |- | ||
| | |Media Type ||O || || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|} | |} | ||
== | ==On Time Items (Assets)== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | | | ||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |||
|Customer ||O || || || || || || | |||
|- | |||
|Dealer ||O || || || || || || | |||
|- | |||
|Outbase ||O || || || || || || | |||
|- | |||
|Route Code ||O || || || || || || | |||
|- | |||
|Media Type ||O || || || || || || | |||
|- | |- | ||
| | |Schedule To ||M || || || || || || | ||
|} | |} | ||
== | ==On Time Returns== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Media Type ||O || || || || || || | ||
| | |||
|- | |- | ||
| | |Route Code ||O || || || || || || | ||
|- | |- | ||
| | |Outbase ||O || || || || || || | ||
|- | |- | ||
| | |Dealer ||O || || || || || || | ||
|- | |- | ||
|Customer ||O || || || || || || | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |Schedule From ||M || || || || || || | ||
|- | |||
|Schedule To ||M || || || || || || | |||
|} | |} | ||
== | ==Order Charges Extract== | ||
| | {| class="wikitable" | ||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | | | ||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Date ||M ||TODAY || || || || || | ||
|} | |||
==Order Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |End Sched ||M || || || || || || | ||
|- | |- | ||
| | |Start Sched ||M || || || || || || | ||
|} | |} | ||
== | ==Order Interface Results== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |||
|To Date ||O ||TODAY || || || || || | |||
|- | |- | ||
| | |From Date ||O ||TODAY || || || || || | ||
|- | |- | ||
| | |Depot ||O || || || || || || | ||
|- | |- | ||
| | |Message Type ||O || || || || || || | ||
|} | |} | ||
== | ==Order Items POD Debriefed== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
| | |End Schedule ||O || || || || || || | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|} | |} | ||
== | ==Order Savings== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |||
| | | | ||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Start Schedule ||M || || || || || || | ||
|- | |- | ||
| | |End Schedule ||O || || || || || || | ||
|- | |- | ||
| | |Show Neg Savings ||M || || || || || || | ||
|} | |||
==Order Tracking== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Schedule ||M || || || || || || | ||
|} | |} | ||
== | == Orders to LogiX == | ||
== || || || || || || || || || | |||
|} | |||
==Orders to Paragon== | |||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|} | |} | ||
== | ==Outbound Shortage== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |End Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Customer ||M || || || || || || | ||
|} | |||
==POC to SAP Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |} | ||
==POC to SAP Extract(A)== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |- | ||
| | |Resend All? ||M ||STRING ||No || || || || | ||
|} | |||
==POD Delivery Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|To Date ||M ||TODAY || || || || || | |POD Flow ||M || || || || || || | ||
|- | |||
|Date To ||M ||TODAY || || || || || | |||
|- | |||
|Date From ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Schedule ||O || || || || || || | ||
|} | |} | ||
== | ==POD to SAP Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! | !'''Report Name''' | ||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|} | |} | ||
== | ==POD to SAP Extract(A)== | ||
Parameters: | {| class="wikitable" | ||
{| class="wikitable" | !'''Report Name''' | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !'''Filename''' | ||
|- | !'''Procedure for Scheduling''' | ||
| | |- | ||
| | | | ||
| | |||
| | |||
|} | |||
= | Parameters: | ||
{| class="wikitable" | |||
{| class="wikitable" | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
!Name !! | |- | ||
|- | |Resend All? ||M ||STRING ||No || || || || | ||
| | |} | ||
| | |||
==PORSCHE19 Invoice Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | | | ||
|- | | | ||
| | | | ||
|} | |} | ||
Parameters: | |||
== | {| class="wikitable" | ||
!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 == | ||
== || ||Owning Depot ||O || || || || || || | |||
|- | |||
Parameters: | |To Schedule ||M || || || || || || | ||
{| class="wikitable" | |- | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |From Schedule ||M || || || || || || | ||
|- | |} | ||
==Parts and Empites== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|} | |||
==Pre Invoice Check== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Cut-off Date ||M ||TODAY || || || || || | |||
|} | |||
==Process Items Interface Audit== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|To Date ||M ||TODAY || || || || || | |||
|- | |||
|From Date ||M ||TODAY || || || || || | |||
|} | |||
==Purchase Order Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule ||M || || || || || || | |||
|} | |||
==Revenue Check (Account)== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Start Schedule ||M || || || || || || | |||
|- | |||
|End Schedule ||M || || || || || || | |||
|} | |||
==Schedule Trips CS== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Customer ||O || || || || || || | |||
|} | |||
==Schedule Trips CS== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule ||M || || || || || || | |||
|} | |||
==Scheduled and Cancelled Orders== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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 == | |||
|- | |||
|Schedule ||M || || || || || || | |||
|- | |||
|Customer ||O || || || || || || | |||
|- | |||
|Last Schedule ||O || || || || || || | |||
|- | |||
|Customer Group ||O || || || || || || | |||
|- | |||
|Carrier Group ||O || || || || || || | |||
|} | |||
==Short Rail Report== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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 == | |||
|| ||Del | |||
|- | |||
|ivery Date ||M || || || || || || | |||
|} | |||
==Store Pre Warning== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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 2== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule ||M || || || || || || | |||
|} | |||
==Trip Actuals== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule ||M || || || || || || | |||
|} | |||
==Trip Assessment Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule ||M || || || || || || | |||
|} | |||
==Trip Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!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== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
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''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
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''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
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''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
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''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
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''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
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''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Carrier Group ||O || || || || || || | |Carrier Group ||O || || || || || || | ||
|- | |- | ||
Line 2,549: | Line 4,565: | ||
==Volume Deviation Extract== | ==Volume Deviation Extract== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 2,571: | Line 4,596: | ||
==Volume or Activity== | ==Volume or Activity== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 2,591: | Line 4,625: | ||
==WCS Order Items Extract== | ==WCS Order Items Extract== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 2,605: | Line 4,648: | ||
==Weekly Transport Report == | ==Weekly Transport Report == | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 2,617: | Line 4,669: | ||
==XML Order Interface Export== | ==XML Order Interface Export== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
| | |||
| | |||
| | |||
|} | |||
No Parameters | No Parameters |
Revision as of 16:59, 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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
KPI By Lane
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
Kraft KPI
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
To Date | M | TODAY |
Manual Loaded Items
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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
== || || || || || || || || || |}
Missing Lat Long Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 Finance Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
OTM Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
Order Charges Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Orders to LogiX
== || || || || || || || || || |}
Orders to Paragon
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|
Outbound Shortage
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Resend All? | M | STRING | No |
POD Delivery Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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
== || ||Owning Depot ||O || || || || || || |- |To Schedule ||M || || || || || || |- |From Schedule ||M || || || || || || |}
Parts and Empites
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|
Pre Invoice Check
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Cut-off Date | M | TODAY |
Process Items Interface Audit
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O |
Schedule Trips CS
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Scheduled and Cancelled Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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
|- |Schedule ||M || || || || || || |- |Customer ||O || || || || || || |- |Last Schedule ||O || || || || || || |- |Customer Group ||O || || || || || || |- |Carrier Group ||O || || || || || || |}
Short Rail Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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
|| ||Del |- |ivery Date ||M || || || || || || |}
Store Pre Warning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Trip Actuals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Trip Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Vehicle Utilisation
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 |
Vehicle Utilisation Heavy
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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 Order Items Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
No Parameters