Extracts Details: Difference between revisions
(Updated parameters and extract names) |
(Updated parameters and extract names) |
||
Line 117: | Line 117: | ||
|Cust_Product_By_Arrive | |Cust_Product_By_Arrive | ||
|CSV.Cust_Product_By_Arrive | |CSV.Cust_Product_By_Arrive | ||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!'''Title''' | |||
!'''Name''' | |||
!'''Mand''' | |||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |||
|To Schedule | |||
|i_to_sched | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|From Schedule | |||
|i_from_sched | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Customer | |||
|i_customer | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Line 129: | Line 171: | ||
|CSV.Data_Extract | |CSV.Data_Extract | ||
|} | |} | ||
Parameters: | |||
{| class="wikitable" | {| class="wikitable" | ||
!''' | !'''Title''' | ||
!''' | !'''Name''' | ||
!''' | !'''Mand''' | ||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |- | ||
| | |Group Name | ||
| | |i_group_name | ||
| | |O | ||
| | | | ||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |From Date | ||
| | |i_from_date | ||
| | |M | ||
|} | |TODAY | ||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|To Date | |||
|i_to_date | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Customer | |||
|i_customer | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Depot | |||
|i_depot | |||
|O | |||
| | |||
| | |||
|Depot | |||
|Location Id | |||
|Name | |||
| | |||
|} | |||
== 10.6 | == 10.6 Load Status Export == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 158: | Line 240: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
|10.6 | |10.6 Load Status Export | ||
| | |Load_Status_Export | ||
|CSV. | |CSV.Load_Status_Export | ||
|} | |} | ||
Parameters: | |||
{| class="wikitable" | {| class="wikitable" | ||
!''' | !'''Title''' | ||
!''' | !'''Name''' | ||
!''' | !'''Mand''' | ||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |- | ||
| | |Status | ||
| | |i_status | ||
| | |O | ||
| | | | ||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Carrier | ||
| | |i_carrier | ||
| | |O | ||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|To Schedule | |||
|i_to_sched | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Customer | |||
|i_customer | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|From Schedule | |||
|i_from_sched | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | == 10.6 Matthew Clark Data Extract == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 191: | Line 313: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |10.6 Matthew Clark Data Extract | ||
| | |Matt_Clark_Data_Extract | ||
| | |CSV.Matt_Clark_Data_Extract | ||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!'''Title''' | |||
!'''Name''' | |||
!'''Mand''' | |||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |||
|To Schedule | |||
|i_to_sched | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|From Schedule | |||
|i_from_sched | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | == 10.6 Planning Export == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 202: | Line 356: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |10.6 Planning Export | ||
| | |Planning_Export | ||
|CSV. | |CSV.Planning_Export | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name ! | !'''Title''' | ||
!'''Name''' | |||
!'''Mand''' | |||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |- | ||
| | |Current Depot | ||
|i_current_depot | |||
|M | |||
| | |||
| | |||
|Current Depot | |||
|Location Id | |||
|Name | |||
| | |||
|- | |- | ||
|Group Name || | |Group Name | ||
|i_group_name | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |From Date | ||
|i_from_date | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |To Date | ||
| | |i_to_date | ||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | == 10.6 Tokairo Export == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 227: | Line 419: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |10.6 Tokairo Export | ||
|Tokairo_Export | |||
|CSV.Tokairo_Export | |||
| | |||
| | |||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name ! | !'''Title''' | ||
!'''Name''' | |||
!'''Mand''' | |||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |- | ||
| | |End Date | ||
|i_to_date | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Start Date | ||
| | |i_from_date | ||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | == 10.6 Warehouse Extract == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 259: | Line 462: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |10.6 Warehouse Extract | ||
| | |Warehouse_Extract | ||
|CSV. | |CSV.Warehouse_Extract | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name ! | !'''Title''' | ||
!'''Name''' | |||
!'''Mand''' | |||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |- | ||
| | |From Location | ||
|i_from_loc | |||
|M | |||
| | |||
| | |||
|From Location | |||
|Location Id | |||
|Name | |||
| | |||
|- | |- | ||
| | |Owning Depot | ||
|i_depot | |||
|M | |||
| | |||
| | |||
|Depot | |||
|Location Id | |||
|Name | |||
| | |||
|- | |- | ||
| | |To Date | ||
|i_to_date | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |From Date | ||
|- | |i_from_date | ||
| | |M | ||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Group Name | |||
|i_group_name | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | == 1POD Delivery Extract == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 284: | Line 535: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |1POD Delivery Extract | ||
| | |POD_Delivery_Extract | ||
| | |DP_CSV2.POD_DELIVERY_EXTRACT | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name ! | !'''Title''' | ||
!'''Name''' | |||
!'''Mand''' | |||
!'''Def Type''' | |||
!'''Def Val''' | |||
!'''LOV''' | |||
!'''Column 1''' | |||
!'''Column 2''' | |||
!'''Column 3''' | |||
|- | |- | ||
| | |> Days Outstanding | ||
|p_outstanding | |||
|O | |||
|STRING | |||
|0 | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Scanning Depot | ||
|p_scan_depot | |||
|O | |||
|STRING | |||
|ALL | |||
|Depot | |||
|Location Id | |||
|Name | |||
| | |||
|- | |- | ||
| | |POD Status | ||
| | |p_pod | ||
|O | |||
|STRING | |||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Del Msg Sent | ||
| | |p_del_msg_sent | ||
| | |O | ||
| | |STRING | ||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |From Schedule | ||
|p_from_date | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Customer | ||
|p_customer | |||
|O | |||
|STRING | |||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Group | |||
|p_group_name | |||
|O | |||
|STRING | |||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|To Schedule | |||
|p_to_date | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Carrier | |||
|p_carrier | |||
|O | |||
|STRING | |||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | == AA Trip and Order Detail == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 324: | Line 648: | ||
!'''Procedure for Scheduling''' | !'''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 ! | !'''Title'''!! '''Name'''!! '''Mand'''!! '''Def Type'''!! '''Def Val'''!! '''LOV'''!! '''Column 1'''!! '''Column 2''' | ||
!'''Column 3''' | |||
|- | |- | ||
|Start Schedule ||M || || || || || | |Start Schedule ||P_START_SCHED ||M || || || || || | ||
| | |||
|- | |- | ||
|End Schedule ||M || || || || || | |End Schedule ||P_END_SCHED || M|| || || || || | ||
| | |||
|- | |- | ||
| | |Carrier ||i_carrier_id || O|| || || || || | ||
| | |||
|- | |- | ||
| | |Group Name ||i_group_name || M|| || || || || | ||
| | |||
|- | |- | ||
| | |Activity ||i_activity_name || M|| STRING|| Both|| || || | ||
| | |||
|} | |} | ||
== | == ACC Missing Payments == | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 349: | Line 679: | ||
!'''Procedure for Scheduling''' | !'''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 ! | !'''Title'''!! '''Name'''!! '''Mand'''!! '''Def Type'''!! '''Def Val'''!! '''LOV'''!! '''Column 1'''!! '''Column 2''' | ||
!'''Column 3''' | |||
|- | |- | ||
| | |From Schedule ||P_START_SCHED || M|| || || || || | ||
| | |||
|- | |- | ||
| | |Owning Depot ||P_OWNING_DEPOT || O|| || || || || | ||
| | |||
|- | |- | ||
| | |To Schedule ||P_END_SCHED || M|| || || || || | ||
| | |||
|} | |} | ||
== | ==Accruals== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 389: | Line 715: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Accruals | ||
| | |ACCRUALS | ||
| | |CSV.ACCRUALS | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 ! | !'''Title'''!! '''Name'''!! '''Mand'''!! '''Def Type'''!! '''Def Val'''!! '''LOV'''!! '''Column 1'''!! '''Column 2''' | ||
!'''Column 3''' | |||
|- | |- | ||
| | |Revenue After ||i_revenue_after || O|| || || || || | ||
| | |||
|- | |- | ||
| | |Revenue Before ||i_revenue_before || O|| || || || || | ||
| | |||
|- | |- | ||
| | |Customer Group ||i_cust_group || O|| || || || || | ||
| | |||
|- | |- | ||
| | |Debit Account ||i_debit_acc || O|| || || || || | ||
| | |||
|- | |- | ||
| | |Credit Account ||i_credit_acc || O|| || || || || | ||
| | |||
|} | |} | ||
== | == Actual Load== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 414: | Line 746: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Actual Load | ||
| | |ACTUAL_LOAD_EXTRACT | ||
| | |DP_CSV_GEN.DAILY_EXT_LOAD | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Date From ||M || | |Load Date From | ||
|i_date_from | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Load Date To | ||
|i_date_to ||M || || || || || || | |||
| | |||
| | |||
|} | |} | ||
== | == Actual Unload== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 445: | Line 775: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Actual Unload | ||
| | |ACTUAL_UNLOAD_EXTRACT | ||
| | |DP_CSV_GEN.DAILY_EXT_UNLOAD | ||
|} | |} | ||
Parameters: | Parameters: | ||
== | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Load Date From | |||
|i_date_from ||M || || || || || || | |||
|- | |||
|Load Date To | |||
|i_date_to ||M || || || || || || | |||
|} | |||
==Additional Reporting Requirements== | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 456: | Line 797: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Additional Reporting Requirements | ||
| | |nr_additional_rep | ||
| | |dp_csv_nr.nr_additional_report | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Customer | |Customer Group | ||
|i_cust_group ||O || || || || || || | |||
| | |||
|- | |- | ||
| | |Cost Centre | ||
|i_cost_centre ||O || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|i_Sched_To ||M || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |- | ||
| | |Start Schedule | ||
|i_Sched_From ||M || || || || || || | |||
| | |||
|} | |} | ||
== | ==Amazon Resources== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 485: | Line 828: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Amazon Resources | ||
| | |FMC_BULK_UPLOAD | ||
| | |DP_CSV_CSS.AMAZON_RESOURCES | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Arrival Time To | ||
|i_date_to ||O || || || || || || | |||
| | |||
|- | |- | ||
| | |Arrival Time From | ||
|i_date_from ||O || || || || || || | |||
| | |||
|} | |} | ||
== | ==Amazon Resources Update== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 510: | Line 850: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Amazon Resources Update | ||
| | |FMC_UPDATE | ||
| | |DP_CSV_CSS.AMAZON_RESOURCE_UPDATE | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Arrival Time To | ||
|i_date_to ||O || || || || || || | |||
| | |||
|- | |- | ||
| | |Update After (HHMI) | ||
|i_changed ||O || || || || || || | |||
|- | |- | ||
| | |Arrival Time From | ||
|i_date_from ||O || || || || || || | |||
| | |||
|} | |} | ||
== | ==Approved Price Report== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 537: | Line 875: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Approved Price Report | ||
| | |approved_price_rep | ||
| | |dp_csv_nr.approved_price_report | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |From Date | ||
|i_Start_Date_Time ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |- | ||
| | |Customer Group | ||
|i_cust_group ||O || || || || || || | |||
|- | |- | ||
| | |Cost Centre | ||
|i_cost_centre ||O || || || || || || | |||
|- | |- | ||
| | |To Date | ||
|i_End_Date_Time ||M || TODAY|| || || || || | |||
| | |||
|} | |} | ||
== | ==Asset History== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 564: | Line 906: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Asset History | ||
| | |ASSET_HISTORY | ||
| | |DP_CSV6.ASSET_HISTORY_EXTRACT | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer | ||
|i_customer ||O ||STRING || ALL|| || || || | |||
|- | |- | ||
| | |Asset Id | ||
|i_asset_id ||O ||STRING || ALL|| Asset|| Asset ID|| Asset ID|| | |||
|- | |||
|Driver/User | |||
|i_action_by ||O ||STRING || || || || || | |||
|- | |- | ||
|To | |Date To | ||
|i_date_to ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Date From | ||
|i_date_from ||M ||TODAY || || || || || | |||
|} | |} | ||
== | ==Asset Status== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 587: | Line 937: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Asset Status | ||
| | |ASSET_STATUS | ||
| | |DP_CSV6.ASSET_STATUS | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Asset | |Asset Id | ||
|i_asset_id ||O ||STRING ||ALL ||Asset ||Asset ID ||Asset ID || | |||
|- | |||
|Customer | |||
|i_customer ||O ||STRING ||ALL || || || || | |||
|- | |||
|Last Scan Location | |||
|i_last_scan_loc ||O ||STRING ||ALL || Last Scan Location|| Location ID|| Name|| | |||
|} | |} | ||
==Asset Utilisation== | |||
== | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 604: | Line 961: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Asset Utilisation | ||
| | |ASSET_UTILISATION | ||
| | |dp_csv4.asset_utilisation | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Current Location | ||
|I_CURRENT_LOCATION ||O || || || Location|| Location|| Location Name|| | |||
|- | |||
|Customer | |||
|I_CUSTOMER ||O || || || || || || | |||
|- | |- | ||
| | |To Date | ||
|I_DATE_TO ||M ||TODAY || || || || || | |||
|- | |||
|From Date | |||
|I_DATE_FROM ||M ||TODAY || || || || || | |||
|- | |||
|Vehicle | |||
|I_VEHICLE ||O || || || || || || | |||
|- | |- | ||
| | |Route | ||
|I_ROUTE ||O || || || || || || | |||
|- | |- | ||
| | |Location | ||
|I_LOCATION ||O || || ||Location ||Location ||Location Name || | |||
|} | |} | ||
== | ==Assets On Time Delivery== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 627: | Line 998: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Assets On Time Delivery | ||
| | |ASSET_ON_TIME_DELIV | ||
| | |dp_csv4.asset_on_time_deliv | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Customer || | |Route | ||
|I_ROUTE ||O || || || || || || | |||
|- | |||
|Customer | |||
|I_CUSTOMER ||O || || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|I_DATE_FROM ||M || TODAY|| || || || || | |||
|- | |- | ||
|To Date ||M ||TODAY || || || || || | |To Date | ||
|I_DATE_TO ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Location | ||
|I_LOCATION ||O || || || Location|| Location|| Location Name|| | |||
|} | |} | ||
== | ==Automotive Planning Report== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 650: | Line 1,029: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Automotive Planning Report | ||
| | |Planning_Report | ||
| | |DP_CSV2.PLANNING_REPORT | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Utilisation > | ||
|I_UTIL_FROM ||O || STRING|| 0|| || || || | |||
|- | |||
|Utilisation < | |||
|I_UTIL_TO ||O ||STRING ||999 || || || || | |||
|- | |||
|End Schedule | |||
|I_END_DATE ||M || || || || || || | |||
|- | |||
|Level | |||
|I_LEVEL ||M || STRING|| SUMMARY|| || || || | |||
|- | |||
|Depot | |||
|I_DEPOT ||M ||STRING ||ALL || || || || | |||
|- | |||
|Start Schedule | |||
|I_START_DATE ||M || || || || || || | |||
|} | |} | ||
== | ==BGW Trip and Order Detail== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 667: | Line 1,063: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |BGW Trip and Order Detail | ||
| | |BGW_Trip_Order_Detail_Extract | ||
| | |DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT | ||
|} | |} | ||
Parameters: | Parameters: | ||
== | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Start Schedule | |||
|P_START_SCHED ||M || || || || || || | |||
|- | |||
|End Schedule | |||
|P_END_SCHED ||M || || || || || || | |||
|- | |||
|Loaded At | |||
|i_loaded_at ||O || || || || || || | |||
|- | |||
|Activity | |||
|i_activity_name ||M || STRING|| Both|| || || || | |||
|- | |||
|Group Name | |||
|i_group_name ||M || || || || || || | |||
|- | |||
|Carrier | |||
|i_carrier_id ||O || || || || || || | |||
|} | |||
==BGW_DEBRIEF== | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 679: | Line 1,097: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |BGW_DEBRIEF | ||
| | |BGW_DEBRIEF | ||
| | |dp_csv3.bgw_debrief | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Cost Centre | ||
|P_COST_CENTRE ||O || || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|P_START_DATETIME ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |To Date | ||
|P_END_DATETIME ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Customer | ||
|P_CUSTOMER ||O || || || || || || | |||
| | |||
|} | |} | ||
== | ==BMW Asset Dwell== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 704: | Line 1,125: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |BMW Asset Dwell | ||
| | |AUTO_ASSET_DWELL | ||
| | |DP_CSV3.AUTO_AFTERMARKET_BMW | ||
|} | |} | ||
Parameters: | Parameters: | ||
== | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Asset Type | |||
|i_asset_type ||O || || || || || || | |||
|} | |||
==Backing Sheet== | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 716: | Line 1,144: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Backing Sheet | ||
| | |BACKING_SHEET_EXTRACT | ||
| | |DP_CSV_GEN.BACKING_SHEET | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |- | ||
| | |Sched To | ||
|i_end_sched ||O || || || || || || | |||
|- | |- | ||
| | |Sched From | ||
|i_start_sched ||O || || || || || || | |||
|- | |- | ||
| | |Manifest | ||
|i_booking ||O || || || || || || | |||
|} | |} | ||
== | ==Baxter CSR== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 740: | Line 1,172: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Baxter CSR | ||
| | |Baxter_csr | ||
| | |DP_CSV5.BAXTER_CSR | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|To Date ||M ||TODAY || || || || || | |Customer | ||
|I_CUSTOMER ||M ||STRING ||ALL || || || || | |||
|- | |||
|To Date | |||
|I_DATE_TO ||M ||TODAY || || || || || | |||
|- | |||
|Cost Centre | |||
|i_cost_centre ||O || || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|I_DATE_FROM ||M || TODAY|| || || || || | |||
|} | |} | ||
== | ==Baxter Download Id Orders== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 759: | Line 1,200: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Baxter Download Id Orders | ||
| | |Baxter Download | ||
| | |DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Download Id | ||
|P_DOWNLOAD_ID ||M ||STRING || || || || || | |||
| | |||
|} | |} | ||
== | ==CARGOWISE Header== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 786: | Line 1,219: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |CARGOWISE Header | ||
| | |CARGOWISE_HEADER | ||
| | |OF_INT.WRITE_CARGOWISE_HEADER | ||
|} | |} | ||
Parameters: | Parameters: | ||
==CN | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Export_id | |||
|i_exp_id ||M || || || || || || | |||
|} | |||
==CN Data Extract== | |||
{{Warning}}Missing | {{Warning}}Missing | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 806: | Line 1,246: | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Depot ||O || || ||Depot ||Location Id ||Name || | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |Customer ||O || || || || || || | ||
|- | |- | ||
|Group Name ||O || || || || || || | |Group Name ||O || || || || || || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|} | |||
==CN Equipment Moves== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |- | ||
| | |CN Equipment Moves | ||
|Equip_Move | |||
|DP_CSV2.CN_EQUIP_MOVE | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Name | |||
!Mand | |||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |- | ||
| | |To Date | ||
|i_date_to | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Group Name | ||
|i_group_name | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Customer | ||
|i_customer | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |From Date | ||
|} | |i_date_from | ||
|M | |||
== | |TODAY | ||
| | |||
| | |||
| | |||
| | |||
|} | |||
==CN Planning Export== | |||
{{Warning}}Missing | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 835: | Line 1,322: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | | | ||
| | | | ||
| | | | ||
|} | |} | ||
Parameters: | Parameters: | ||
Line 843: | Line 1,330: | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Group Name ||O || || || || || || | ||
|- | |- | ||
| | |Current Depot ||M || || ||Current Depot ||Location Id ||Name || | ||
|- | |- | ||
| | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |From Date ||M ||TODAY || || || || || | ||
|} | |} | ||
== | ==CN Tokairo Export== | ||
{{Warning}}Missing | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 862: | Line 1,346: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | | | ||
| | | | ||
| | | | ||
|} | |} | ||
Parameters: | Parameters: | ||
== | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|To Date ||M ||TODAY || || || || || | |||
|- | |||
|From Date ||M ||TODAY || || || || || | |||
|} | |||
==CN Trip and Order Detail== | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 873: | Line 1,365: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |CN Trip and Order Detail | ||
| | |CN_Trip_Order_Detail_Extract | ||
| | |CSV.CN_Trip_Order_Detail_Extract | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Activity | ||
|i_activity_name ||M || STRING|| Both|| || || || | |||
|- | |- | ||
| | |Group Name | ||
|i_group_name ||M || || || || || || | |||
|- | |- | ||
| | |Start Schedule | ||
|P_START_SCHED ||M || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|P_END_SCHED ||M || || || || || || | |||
|- | |- | ||
| | |Carrier | ||
|i_carrier_id ||O || || || || || || | |||
|- | |- | ||
| | |Loaded At | ||
|i_loaded_at ||O || || || || || || | |||
| | |||
|} | |} | ||
== | ==CN Warehouse Loading== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 904: | Line 1,399: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |CN Warehouse Loading | ||
| | |CN_Warehouse_Loading | ||
| | |DP_CSV_DHL.p_warehouse_loading | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || Customer|| CUSTOMER_ID|| CUSTOMER_NAME|| | |||
|- | |- | ||
| | |Depot | ||
|i_depot | |||
|M | |||
| | |||
| | |||
|Depot | |||
|Location Id | |||
|Name | |||
| | |||
|- | |- | ||
| | |Trip ID (optional) | ||
|i_trip_id | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Carrier | ||
| | |i_carrier | ||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |End Schedule | ||
|i_end_sched | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Start Schedule | ||
| | |i_start_sched | ||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
==CN Warehouse Extract== | |||
== | {{Warning}}Missing | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 935: | Line 1,468: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | | | ||
| | | | ||
| | | | ||
|} | |} | ||
Parameters: | Parameters: | ||
Line 943: | Line 1,476: | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |From Location ||M || || ||From Location ||Location Id ||Name || | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date ||M ||TODAY || || || || || | ||
Line 949: | Line 1,482: | ||
|To Date ||M ||TODAY || || || || || | |To Date ||M ||TODAY || || || || || | ||
|- | |- | ||
| | |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 ||O || || ||Customer ||CUSTOMER_ID ||CUSTOMER_NAME || | ||
|} | |} | ||
== | ==CTM Carrier Responsiveness== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 966: | Line 1,505: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |CTM Carrier Responsiveness | ||
| | |CTM_CARRIER_RESPONSIVENESS | ||
| | |CSV.CTM_CARRIER_RESPONSIVENESS | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Start Schedule | ||
|P_START_SCHED ||O || || || || || || | |||
|- | |- | ||
| | |Carrier | ||
|P_HAULIER ||O || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|P_END_SCHED ||O || || || || || || | |||
|- | |- | ||
| | | | ||
|Start Schedule ||O || || || || || || | |||
|- | |- | ||
| | |||
|Carrier ||O || || || || || || | |Carrier ||O || || || || || || | ||
|- | |- | ||
| | | | ||
|End Schedule ||O || || || || || || | |||
| | |||
|} | |} | ||
== | ==CTM Trips Not Responded To== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 997: | Line 1,539: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |CTM Trips Not Responded To | ||
| | |CTM_TRIPS_NO_RESPONSE | ||
| | |CSV.CTM_TRIPS_NO_RESPONSE | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
! | !Title | ||
! | !Name | ||
! | !Mand | ||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |- | ||
| | |End Schedule | ||
| | |P_END_SCHED | ||
| | |O | ||
| | | | ||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Start Schedule | ||
|P_START_SCHED | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Carrier | ||
| | |P_HAULIER | ||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | ==Call Collection OTIF Day== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,029: | Line 1,592: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Call Collection OTIF Day | ||
| | |coll_OTIF_date_window | ||
| | |dp_csv_nr.coll_otif_date_window | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Carrier | ||
|i_carrier ||O || || || || || || | |||
|- | |||
|End Schedule | |||
|i_Sched_To ||O || || || || || || | |||
|- | |||
|From Date | |||
|i_Start_Date_Time ||M || TODAY|| || || || || | |||
|- | |||
|To Date | |||
|i_End_Date_Time ||M || TODAY|| || || || || | |||
|- | |- | ||
| | |Start Schedule | ||
|i_Sched_From ||O || || || || || || | |||
|- | |- | ||
| | |Product Type | ||
|i_product_type ||O || || || || || || | |||
|- | |- | ||
| | |Customer Group | ||
|i_cust_group ||O || || || || || || | |||
|- | |||
|Customer | |||
|i_customer ||O || || || || || || | |||
|} | |} | ||
== | ==Call Collection OTIF Time Window== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,052: | Line 1,632: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Call Collection OTIF Time Window | ||
| | |coll_OTIF_window | ||
| | |dp_csv_nr.coll_otif_window | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |To Date | ||
|i_End_Date_Time ||M || TODAY|| || || || || | |||
|- | |- | ||
| | |Start Schedule | ||
|i_Sched_From ||O || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|i_Sched_To ||O || || || || || || | |||
|- | |- | ||
| | |Product Type | ||
|i_product_type ||O || || || || || || | |||
|- | |- | ||
| | |Customer Group | ||
|i_cust_group ||O || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |||
|Carrier | |||
|i_carrier ||O || || || || || || | |||
|- | |||
|From Date | |||
|i_Start_Date_Time ||M ||TODAY || || || || || | |||
|} | |} | ||
== | ==Call Delivery OTIF Day== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,079: | Line 1,672: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Call Delivery OTIF Day | ||
| | |del_OTIF_date_window | ||
| | |dp_csv_nr.del_otif_date_window | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|End Schedule || | |Carrier | ||
|i_carrier ||O || || || || || || | |||
|- | |||
|Customer | |||
|i_customer ||O || || || || || || | |||
|- | |||
|Customer Group | |||
|i_cust_group ||O || || || || || || | |||
|- | |||
|Product Type | |||
|i_product_type ||O || || || || || || | |||
|- | |||
|End Schedule | |||
|i_Sched_To ||O || || || || || || | |||
|- | |||
|Start Schedule | |||
|i_Sched_From ||O || || || || || || | |||
|- | |- | ||
| | |From Date | ||
|i_Start_Date_Time ||M || TODAY|| || || || || | |||
|- | |- | ||
| | |To Date | ||
|i_End_Date_Time ||M || TODAY|| || || || || | |||
|} | |} | ||
== | ==Call Delivery OTIF Time Window== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,100: | Line 1,712: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Call Delivery OTIF Time Window | ||
| | |del_OTIF_window | ||
| | |dp_csv_nr.del_otif_window | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
! | !Title | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Customer | |||
|i_customer ||O || || || || || || | |||
|- | |||
|Carrier | |||
|i_carrier ||O || || || || || || | |||
|- | |||
|Customer Group | |||
|i_cust_group ||O || || || || || || | |||
|- | |- | ||
| | |Product Type | ||
|i_product_type ||O || || || || || || | |||
| | |||
|- | |- | ||
| | |End Schedule | ||
|i_Sched_To ||O || || || || || || | |||
|- | |- | ||
| | |Start Schedule | ||
|i_Sched_From ||O || || || || || || | |||
|- | |- | ||
| | |To Date | ||
|i_End_Date_Time ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |From Date | ||
|i_Start_Date_Time ||M || TODAY|| || || || || | |||
|} | |} | ||
== | ==Campus KPI Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,138: | Line 1,752: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Campus KPI Extract | ||
| | |Campus_KPI_Extract | ||
| | |KPI.KPI_CAMPUS_EXTRACT | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name | !Title | ||
!Name | |||
!Mand | |||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |- | ||
| | |From Date | ||
| | |i_date_from | ||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Carrier | ||
| | |i_carrier | ||
| | |O | ||
| | | | ||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Cost Centre | ||
| | |i_cost_centre | ||
|O | |||
| | |||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Date Range Type | ||
| | |i_date_type | ||
| | |M | ||
| | |String | ||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Depot | |||
|i_depot | |||
|O | |||
| | |||
|ALL | |||
| | |||
|Location Id | |||
|Name | |||
| | |||
|- | |- | ||
| | |To Date | ||
|i_date_to | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Client | ||
|i_client | |||
|O | |||
| | |||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | ==Carrier DUs Shipped== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,191: | Line 1,845: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Carrier DUs Shipped | ||
| | |CARRIER_DUS_SHIPPED | ||
| | |DP_CSV5.CARRIER_DUS_SHIPPED | ||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|From Date | |||
|I_DATE_FROM ||M ||TODAY || || || || || | |||
|- | |||
|Carrier | |||
|P_CARRIER ||O ||STRING || ALL|| || || || | |||
|- | |||
|To Date | |||
|I_DATE_TO ||M ||TODAY || || || || || | |||
|} | |} | ||
== | ==Carrier Delivery Report== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,203: | Line 1,870: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Carrier Delivery Report | ||
| | |Carrier_Delivery_Report | ||
| | |DP_CSV5.CARRIER_DELIVERY | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Sched Name | ||
|P_SCHED_NAME ||M || || || || || || | |||
| | |||
|- | |- | ||
| | |Trip ID | ||
|P_TRIP ||O || STRING|| ALL|| || || || | |||
|- | |- | ||
| | |Carrier | ||
|P_CARRIER ||M || || || || || || | |||
|- | |- | ||
| | |Depot | ||
|P_DEPOT ||M || || || || || || | |||
| | |||
|} | |} | ||
== | ==Carrier Invoice== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,232: | Line 1,898: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Carrier Invoice | ||
| | |Carrier_Invoice | ||
|CSV. | |CSV.CARRIER_INVOICE | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Invoice No | |Invoice No | ||
|I_INVOICE_NO ||M || || || || || || | |||
| | |||
|- | |- | ||
| | |Credit Acc | ||
|I_CREDIT_ACC ||M || || || || || || | |||
|- | |- | ||
| | |Debit Acc | ||
|I_DEBIT_ACC ||M || || || || || || | |||
|} | |} | ||
== | ==Carrier Self Billing== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,259: | Line 1,923: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Carrier Self Billing | ||
| | |Carrier_Self_billing | ||
| | |DP_CSV_BNL.CARRIER_SELF_BILLING | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Start Schedule | ||
|i_start_sched ||M || || || || || || | |||
|- | |- | ||
| | |Carrier | ||
|i_carrier ||0 || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|i_end_sched ||M || || || || || || | |||
| | |||
|} | |} | ||
== | ==Catalyst Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,282: | Line 1,948: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Catalyst Extract | ||
| | |CATALYST_EXTRACT | ||
|CSV. | |CSV.CATALYST_EXTRACT | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name | !Title | ||
!Name | |||
!Mand | |||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |- | ||
| | |End Schedule | ||
|P_END_SCHED | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |Start Schedule | ||
| | |P_START_SCHED | ||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
== | ==Co-ordinate Non-Conformities== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,303: | Line 1,991: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Co-ordinate Non-Conformities | ||
| | |Co_Ord_Non_Conf | ||
|DP_CSV6. | |DP_CSV6.CO_ORD_NON_CONFORM | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|End Schedule ||M || || || || || || | |Start Schedule | ||
|i_sched_from ||M || || || || || || | |||
|- | |||
|End Schedule | |||
|i_sched_to ||M || || || || || || | |||
|- | |||
|Driver | |||
|i_driver ||O || || || || || || | |||
|- | |||
|TomTom,Epod,Both | |||
|i_inc ||M || || B|| || || || | |||
|- | |- | ||
| | |Discrepancy Dist | ||
|i_disc_dist ||0 || || 1|| || || || | |||
|- | |- | ||
| | |Depot | ||
|i_depot ||O || || || || || || | |||
|} | |} | ||
== | ==Commercial== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,324: | Line 2,025: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Commercial | ||
| | |COMMERCIAL | ||
| | |CSV.Commercial_Orders | ||
|} | |} | ||
Parameters: | Parameters: | ||
== | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule | |||
|I_SCHEDULE ||M || || || || || || | |||
|} | |||
==Compliance Report== | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,335: | Line 2,044: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Compliance Report | ||
| | |COMPLIANCE_REPORT | ||
| | |DP_CSV_DUN.COMPLIANCE_REPORT | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Collection Date | ||
|P_COL_DATE ||M || || || || || || | |||
| | |||
|} | |} | ||
== | ==Concurrent Logon Export== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,358: | Line 2,063: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Concurrent Logon Export | ||
| | |Concurrent_Logon_Export | ||
| | |CSV.Concurrent_Logon | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |From Date | ||
|i_from_date ||O ||TODAY || || || || || | |||
|- | |- | ||
| | |To Date | ||
|i_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" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,379: | Line 2,097: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Cross Dock | ||
| | |CROSS_DOCK | ||
| | |DP_CSV6.CROSS_DOCK | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Schedule From | ||
|i_sched_from ||M || || || || || || | |||
|- | |- | ||
| | |Schedule To | ||
|i_sched_to ||M || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || STRING|| || || || || | |||
|- | |- | ||
| | |Media Type | ||
|i_media_type ||O ||STRING || || || || || | |||
|- | |||
|Depot | |||
|i_depot ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Route | ||
|i_route ||O || STRING|| || || || || | |||
|- | |- | ||
| | |Dealer | ||
|i_dealer ||O ||STRING || || || || || | |||
|} | |} | ||
== | ==Customer Invoice== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,406: | Line 2,134: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Customer Invoice | ||
| | |Customer_Invoice | ||
| | |CSV.Customer_Invoice | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Invoice No | ||
|I_INVOICE_NO ||M || || || || || || | |||
|- | |- | ||
| | |Credit Acc | ||
|I_CREDIT_ACC ||M || || || || || || | |||
|- | |||
|Debit Acc | |||
|I_DEBIT_ACC ||M || || || || || || | |||
|} | |} | ||
== | ==Customer Invoice By Dates== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,425: | Line 2,159: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
| | |Customer Invoice By Dates | ||
| | |Customer_Invoice_By_Dates | ||
| | |CSV.Customer_Invoice_By_Dates | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Payment Status | |||
|i_act_or_prov ||O || || || || || || | |||
|- | |||
|From Date | |||
|I_START_DATETIME ||M || || || || || || | |||
|- | |- | ||
|To Date ||M || || || || || || | |To Date | ||
|I_END_DATETIME ||M || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|I_CUSTOMER ||M || || || || || || | |||
|} | |} | ||
== | ==Customer Invoice Extract== | ||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Customer Invoice Extract | |||
|Customer_Invoice | |||
|CSV.Customer_Invoice | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Debit Acc | |||
|I_DEBIT_ACC ||M || || || || || || | |||
|- | |||
|Invoice No | |||
|I_INVOICE_NO ||M || || || || || || | |||
|- | |||
|Credit Acc | |||
|I_CREDIT_ACC ||M || || || || || || | |||
|} | |||
==Cut Offs Extract== | |||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 1,443: | Line 2,212: | ||
!'''Procedure for Scheduling''' | !'''Procedure for Scheduling''' | ||
|- | |- | ||
|Daily Manifest E-OT-L | |Cut Offs Extract | ||
|DAILY_MANIFEST_E_OT_L_EXTRACT | |Cut_offs_extract | ||
|DP_CSV6.CUT_OFF_EXTRACT | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|End Schedule | |||
|i_end_sched ||M || || || || || || | |||
|- | |||
|Customer | |||
|i_customer ||0 || || || || || || | |||
|- | |||
|Start Schedule | |||
|i_start_sched ||M || || || || || || | |||
|} | |||
==D365 Extract== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|D365 Extract | |||
|DP_FINANCE.D365_EXPORT | |||
|D365_EXPORT_ | |||
|} | |||
No parameters. | |||
==DELIVERY_OVERVIEW== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|DELIVERY_OVERVIEW | |||
|DELIVERY_OVERVIEW | |||
|dp_csv3.delivery_overview | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|POD Confirmed | |||
|P_POD ||O || || || || || || | |||
|- | |||
|Owning Depot | |||
|P_OWNING_DEPOT ||O || || || || || || | |||
|- | |||
|To Schedule | |||
|P_END_SCHED ||M || || || || || || | |||
|- | |||
|From Schedule | |||
|P_START_SCHED ||M || || || || || || | |||
|} | |||
==DOOD Rpt== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|DOOD Rpt | |||
|DOOD_RPT | |||
|dp_csv_dood.dood_rpt | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule To | |||
|I_SCHED_TO ||M || || || || || || | |||
|- | |||
|Schedule From | |||
|I_SCHED_FROM ||M || || || || || || | |||
|- | |||
|Customer | |||
|I_CUSTOMER ||O ||STRING ||OPENFIELD || || || || | |||
|} | |||
==DUs Despatched== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|DUs Despatched | |||
|DUS_DESPATCHED_EXTRACT | |||
|DP_CSV_GEN.DUS_DESPATCHED_EXTRACT | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
| | |||
|Consignment Num ||O ||STRING || || || || || | |||
|- | |||
| | |||
|Start Sched ||O || || || || || || | |||
|- | |||
| | |||
|Manifest ||O ||STRING || || || || || | |||
|- | |||
| | |||
|PO Number ||O ||STRING || || || || || | |||
|- | |||
| | |||
|Supplier ||O || || || || || || | |||
|- | |||
| | |||
|End Sched ||O || || || || || || | |||
|} | |||
==DUs Not Loaded== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|DUs Not Loaded | |||
|DUS_NOT_LOADED_EXTRACT | |||
|DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|Schedule | |||
|p_sched_date ||M || || || || || || | |||
|- | |||
|Store | |||
|p_store ||O || || || Store|| Location ID|| Name|| | |||
|} | |||
== DUs Not Received == | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|DUs Not Received | |||
|DUS_NOT_RECEIVED_EXTRACT | |||
|DP_CSV_GEN.DAILY_EXT_NOT_RECD | |||
|} | |||
Parameters: | |||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|To Date | |||
|i_avail_to ||M || || || || || || | |||
|- | |||
|From Date | |||
|i_avail_from ||M || || || || || || | |||
|} | |||
==Daily Manifest E-OT-L== | |||
{| class="wikitable" | |||
!'''Report Name''' | |||
!'''Filename''' | |||
!'''Procedure for Scheduling''' | |||
|- | |||
|Daily Manifest E-OT-L | |||
|DAILY_MANIFEST_E_OT_L_EXTRACT | |||
|DP_CSV_GEN.DAILY_EXT_MANIFEST | |DP_CSV_GEN.DAILY_EXT_MANIFEST | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Title | ||
|- | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
| | |- | ||
| | |To Date | ||
|i_avail_to ||M || || || || || || | |||
|- | |- | ||
| | |From Date | ||
| | |i_avail_from ||M || || || || || || | ||
|} | |||
|} | |||
==Daily Receiving E-OT-L== | |||
==Daily Receiving E-OT-L== | {| class="wikitable" | ||
{| class="wikitable" | !'''Report Name''' | ||
!'''Report Name''' | !'''Filename''' | ||
!'''Filename''' | !'''Procedure for Scheduling''' | ||
!'''Procedure for Scheduling''' | |- | ||
|- | |Daily Receiving E-OT-L | ||
|Daily Receiving E-OT-L | |RECEIVING_E_OT_L_EXTRACT | ||
|RECEIVING_E_OT_L_EXTRACT | |DP_CSV_GEN.DAILY_EXT_RECEIPTING | ||
|DP_CSV_GEN.DAILY_EXT_RECEIPTING | |} | ||
|} | Parameters: | ||
Parameters: | {| class="wikitable" | ||
!Title !! Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 | |||
!Column 3 | |||
|- | |||
|End Schedule | |||
|i_sched_to | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Start Schedule | |||
|i_sched_from | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |||
==Daily Transport Plan== | ==Daily Transport Plan== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 1,483: | Line 2,442: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |From Date | ||
|i_avail_from ||M || || || || || || | |||
|- | |- | ||
|Supplier ||M ||STRING ||ALL || || || || | |Supplier | ||
|i_supplier ||M ||STRING ||ALL || || || || | |||
|- | |- | ||
|To Date ||M || || || || || || | |To Date | ||
|i_avail_to ||M || || || || || || | |||
|- | |- | ||
| | |Order Status | ||
|i_ord_status ||M || STRING|| ALL|| || || || | |||
|} | |} | ||
Line 1,506: | Line 2,470: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |From Date | ||
|i_avail_from ||M || || || || || || | |||
|- | |- | ||
| | |To Date | ||
|i_avail_to ||M || || || || || || | |||
|} | |} | ||
Line 1,525: | Line 2,492: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Cust Group | ||
|i_cust_group ||O || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |- | ||
| | |Carrier Group | ||
|i_carrier_group ||O || || || || || || | |||
|- | |- | ||
| | |Cost Centre | ||
|i_cost_centre ||O || || || || || || | |||
|- | |- | ||
| | |From Date | ||
|i_Start_Date_Time ||M || TODAY|| || || || || | |||
|- | |- | ||
| | |Carrier Code | ||
|i_carrier_code ||O || || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|i_End_Date_Time ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 1,554: | Line 2,529: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|End Schedule ||M || || || || || || | |End Schedule | ||
|i_end_sched ||M || || || || || || | |||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule | ||
|i_start_sched ||M || || || || || || | |||
|} | |} | ||
Line 1,573: | Line 2,551: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Owning Depot | ||
|p_own ||O || || || || || || | |||
|- | |- | ||
| | |Cost Centre | ||
|p_cost ||M || || || || || || | |||
|- | |- | ||
| | |To Actual date | ||
|p_to_date ||M || TODAY|| || || || || | |||
|- | |- | ||
| | |Type | ||
|p_type ||M || || M|| || || || | |||
|- | |- | ||
|From Actual date ||M ||TODAY || || || || || | |From Actual date | ||
|p_from_date ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 1,598: | Line 2,582: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Show Dates ||Y || || || || || || | |Show Dates | ||
|P_DATE_SELECT ||Y || || || || || || | |||
|} | |} | ||
Revision as of 09:52, 31 July 2025
This is a full list of all extracts in the system.
10.6 Customer By Product Export
Report Name | Filename | Procedure for Scheduling | |
---|---|---|---|
10.6 Customer By Product Export | Cust_By_Product | CSV.Cust_By_Product |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | M | ||||||
To Schedule | i_to_sched | M | ||||||
From Schedule | i_from_sched | M |
10.6 Customer Location Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Customer Location Export | Customer_Location | CSV.Customer_Location |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | M | ||||||
To Schedule | i_to_sched | M | ||||||
From Schedule | i_from_sched | M |
10.6 Customer Product By Arrival
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Customer Product By Arrival | Cust_Product_By_Arrive | CSV.Cust_Product_By_Arrive |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Schedule | i_to_sched | M | ||||||
From Schedule | i_from_sched | M | ||||||
Customer | i_customer | M |
10.6 Data Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Data Extract | Data_Extract | CSV.Data_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Group Name | i_group_name | O | ||||||
From Date | i_from_date | M | TODAY | |||||
To Date | i_to_date | M | TODAY | |||||
Customer | i_customer | O | ||||||
Depot | i_depot | O | Depot | Location Id | Name |
10.6 Load Status Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Load Status Export | Load_Status_Export | CSV.Load_Status_Export |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Status | i_status | O | ||||||
Carrier | i_carrier | O | ||||||
To Schedule | i_to_sched | M | ||||||
Customer | i_customer | O | ||||||
From Schedule | i_from_sched | M |
10.6 Matthew Clark Data Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Matthew Clark Data Extract | Matt_Clark_Data_Extract | CSV.Matt_Clark_Data_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Schedule | i_to_sched | M | ||||||
From Schedule | i_from_sched | M |
10.6 Planning Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Planning Export | Planning_Export | CSV.Planning_Export |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Current Depot | i_current_depot | M | Current Depot | Location Id | Name | |||
Group Name | i_group_name | O | ||||||
From Date | i_from_date | M | TODAY | |||||
To Date | i_to_date | M | TODAY |
10.6 Tokairo Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Tokairo Export | Tokairo_Export | CSV.Tokairo_Export |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Date | i_to_date | M | TODAY | |||||
Start Date | i_from_date | M | TODAY |
10.6 Warehouse Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
10.6 Warehouse Extract | Warehouse_Extract | CSV.Warehouse_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Location | i_from_loc | M | From Location | Location Id | Name | |||
Owning Depot | i_depot | M | Depot | Location Id | Name | |||
To Date | i_to_date | M | TODAY | |||||
From Date | i_from_date | M | TODAY | |||||
Group Name | i_group_name | O |
1POD Delivery Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
1POD Delivery Extract | POD_Delivery_Extract | DP_CSV2.POD_DELIVERY_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
> Days Outstanding | p_outstanding | O | STRING | 0 | ||||
Scanning Depot | p_scan_depot | O | STRING | ALL | Depot | Location Id | Name | |
POD Status | p_pod | O | STRING | ALL | ||||
Del Msg Sent | p_del_msg_sent | O | STRING | ALL | ||||
From Schedule | p_from_date | M | ||||||
Customer | p_customer | O | STRING | ALL | ||||
Group | p_group_name | O | STRING | ALL | ||||
To Schedule | p_to_date | M | ||||||
Carrier | p_carrier | O | STRING | ALL |
AA Trip and Order Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
AA Trip and Order Detail | AA_Trip_Order_Detail_Extract | CSV.AA_Trip_Order_Detail_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | M | ||||||
Carrier | i_carrier_id | O | ||||||
Group Name | i_group_name | M | ||||||
Activity | i_activity_name | M | STRING | Both |
ACC Missing Payments
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ACC Missing Payments | ACC_Missing_Payment | DP_CSV_DUN.ACC_MISSING_PAYMENT |
No parameters
ACTIVITY_EXTRACT
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ACTIVITY_EXTRACT | ACTIVITY_EXTRACT | dp_csv3.activity_extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Schedule | P_START_SCHED | M | ||||||
Owning Depot | P_OWNING_DEPOT | O | ||||||
To Schedule | P_END_SCHED | M |
Accruals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Accruals | ACCRUALS | CSV.ACCRUALS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Revenue After | i_revenue_after | O | ||||||
Revenue Before | i_revenue_before | O | ||||||
Customer Group | i_cust_group | O | ||||||
Debit Account | i_debit_acc | O | ||||||
Credit Account | i_credit_acc | O |
Actual Load
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Actual Load | ACTUAL_LOAD_EXTRACT | DP_CSV_GEN.DAILY_EXT_LOAD |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Load Date From | i_date_from | M | ||||||
Load Date To | i_date_to | M |
Actual Unload
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Actual Unload | ACTUAL_UNLOAD_EXTRACT | DP_CSV_GEN.DAILY_EXT_UNLOAD |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Load Date From | i_date_from | M | ||||||
Load Date To | i_date_to | M |
Additional Reporting Requirements
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Additional Reporting Requirements | nr_additional_rep | dp_csv_nr.nr_additional_report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer Group | i_cust_group | O | ||||||
Cost Centre | i_cost_centre | O | ||||||
End Schedule | i_Sched_To | M | ||||||
Customer | i_customer | O | ||||||
Start Schedule | i_Sched_From | M |
Amazon Resources
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Amazon Resources | FMC_BULK_UPLOAD | DP_CSV_CSS.AMAZON_RESOURCES |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Arrival Time To | i_date_to | O | ||||||
Arrival Time From | i_date_from | O |
Amazon Resources Update
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Amazon Resources Update | FMC_UPDATE | DP_CSV_CSS.AMAZON_RESOURCE_UPDATE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Arrival Time To | i_date_to | O | ||||||
Update After (HHMI) | i_changed | O | ||||||
Arrival Time From | i_date_from | O |
Approved Price Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Approved Price Report | approved_price_rep | dp_csv_nr.approved_price_report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_Start_Date_Time | M | TODAY | |||||
Customer | i_customer | O | ||||||
Customer Group | i_cust_group | O | ||||||
Cost Centre | i_cost_centre | O | ||||||
To Date | i_End_Date_Time | M | TODAY |
Asset History
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Asset History | ASSET_HISTORY | DP_CSV6.ASSET_HISTORY_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | O | STRING | ALL | ||||
Asset Id | i_asset_id | O | STRING | ALL | Asset | Asset ID | Asset ID | |
Driver/User | i_action_by | O | STRING | |||||
Date To | i_date_to | M | TODAY | |||||
Date From | i_date_from | M | TODAY |
Asset Status
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Asset Status | ASSET_STATUS | DP_CSV6.ASSET_STATUS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Asset Id | i_asset_id | O | STRING | ALL | Asset | Asset ID | Asset ID | |
Customer | i_customer | O | STRING | ALL | ||||
Last Scan Location | i_last_scan_loc | O | STRING | ALL | Last Scan Location | Location ID | Name |
Asset Utilisation
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Asset Utilisation | ASSET_UTILISATION | dp_csv4.asset_utilisation |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Current Location | I_CURRENT_LOCATION | O | Location | Location | Location Name | |||
Customer | I_CUSTOMER | O | ||||||
To Date | I_DATE_TO | M | TODAY | |||||
From Date | I_DATE_FROM | M | TODAY | |||||
Vehicle | I_VEHICLE | O | ||||||
Route | I_ROUTE | O | ||||||
Location | I_LOCATION | O | Location | Location | Location Name |
Assets On Time Delivery
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Assets On Time Delivery | ASSET_ON_TIME_DELIV | dp_csv4.asset_on_time_deliv |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Route | I_ROUTE | O | ||||||
Customer | I_CUSTOMER | O | ||||||
From Date | I_DATE_FROM | M | TODAY | |||||
To Date | I_DATE_TO | M | TODAY | |||||
Location | I_LOCATION | O | Location | Location | Location Name |
Automotive Planning Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Automotive Planning Report | Planning_Report | DP_CSV2.PLANNING_REPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Utilisation > | I_UTIL_FROM | O | STRING | 0 | ||||
Utilisation < | I_UTIL_TO | O | STRING | 999 | ||||
End Schedule | I_END_DATE | M | ||||||
Level | I_LEVEL | M | STRING | SUMMARY | ||||
Depot | I_DEPOT | M | STRING | ALL | ||||
Start Schedule | I_START_DATE | M |
BGW Trip and Order Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
BGW Trip and Order Detail | BGW_Trip_Order_Detail_Extract | DP_CSV3.BGW_TRIP_ORDER_DETAIL_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | M | ||||||
Loaded At | i_loaded_at | O | ||||||
Activity | i_activity_name | M | STRING | Both | ||||
Group Name | i_group_name | M | ||||||
Carrier | i_carrier_id | O |
BGW_DEBRIEF
Report Name | Filename | Procedure for Scheduling |
---|---|---|
BGW_DEBRIEF | BGW_DEBRIEF | dp_csv3.bgw_debrief |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | P_COST_CENTRE | O | ||||||
From Date | P_START_DATETIME | M | TODAY | |||||
To Date | P_END_DATETIME | M | TODAY | |||||
Customer | P_CUSTOMER | O |
BMW Asset Dwell
Report Name | Filename | Procedure for Scheduling |
---|---|---|
BMW Asset Dwell | AUTO_ASSET_DWELL | DP_CSV3.AUTO_AFTERMARKET_BMW |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Asset Type | i_asset_type | O |
Backing Sheet
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Backing Sheet | BACKING_SHEET_EXTRACT | DP_CSV_GEN.BACKING_SHEET |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | O | ||||||
Sched To | i_end_sched | O | ||||||
Sched From | i_start_sched | O | ||||||
Manifest | i_booking | O |
Baxter CSR
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Baxter CSR | Baxter_csr | DP_CSV5.BAXTER_CSR |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | I_CUSTOMER | M | STRING | ALL | ||||
To Date | I_DATE_TO | M | TODAY | |||||
Cost Centre | i_cost_centre | O | ||||||
From Date | I_DATE_FROM | M | TODAY |
Baxter Download Id Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Baxter Download Id Orders | Baxter Download | DP_CSV5.BAXTER_DOWNLOAD_ID_ORDER |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Download Id | P_DOWNLOAD_ID | M | STRING |
CARGOWISE Header
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CARGOWISE Header | CARGOWISE_HEADER | OF_INT.WRITE_CARGOWISE_HEADER |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Export_id | i_exp_id | M |
CN Data Extract
Warning: Missing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Depot | O | Depot | Location Id | Name | |||
From Date | M | TODAY | |||||
Customer | O | ||||||
Group Name | O | ||||||
To Date | M | TODAY |
CN Equipment Moves
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CN Equipment Moves | Equip_Move | DP_CSV2.CN_EQUIP_MOVE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | i_date_to | M | TODAY | ||||
Group Name | i_group_name | O | |||||
Customer | i_customer | O | |||||
From Date | i_date_from | M | TODAY |
CN Planning Export
Warning: 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:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Activity | i_activity_name | M | STRING | Both | ||||
Group Name | i_group_name | M | ||||||
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | M | ||||||
Carrier | i_carrier_id | O | ||||||
Loaded At | i_loaded_at | O |
CN Warehouse Loading
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CN Warehouse Loading | CN_Warehouse_Loading | DP_CSV_DHL.p_warehouse_loading |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | O | Customer | CUSTOMER_ID | CUSTOMER_NAME | |||
Depot | i_depot | M | Depot | Location Id | Name | |||
Trip ID (optional) | i_trip_id | O | ||||||
Carrier | i_carrier | O | ||||||
End Schedule | i_end_sched | M | ||||||
Start Schedule | i_start_sched | M |
CN Warehouse Extract
Warning: Missing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Location | M | From Location | Location Id | Name | |||
From Date | M | TODAY | |||||
To Date | M | TODAY | |||||
Owning Depot | M | Depot | Location Id | Name | |||
Group Name | O | ||||||
Trip ID (optional) | O | ||||||
Depot | M | Depot | Location Id | Name | |||
Carrier | O | ||||||
Start Schedule | M | ||||||
End Schedule | M | ||||||
Customer | O | Customer | CUSTOMER_ID | CUSTOMER_NAME |
CTM Carrier Responsiveness
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CTM Carrier Responsiveness | CTM_CARRIER_RESPONSIVENESS | CSV.CTM_CARRIER_RESPONSIVENESS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | O | ||||||
Carrier | P_HAULIER | O | ||||||
End Schedule | P_END_SCHED | O | ||||||
Start Schedule | O | |||||||
Carrier | O | |||||||
End Schedule | O |
CTM Trips Not Responded To
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CTM Trips Not Responded To | CTM_TRIPS_NO_RESPONSE | CSV.CTM_TRIPS_NO_RESPONSE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | P_END_SCHED | O | ||||||
Start Schedule | P_START_SCHED | O | ||||||
Carrier | P_HAULIER | O |
Call Collection OTIF Day
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Collection OTIF Day | coll_OTIF_date_window | dp_csv_nr.coll_otif_date_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Carrier | i_carrier | O | ||||||
End Schedule | i_Sched_To | O | ||||||
From Date | i_Start_Date_Time | M | TODAY | |||||
To Date | i_End_Date_Time | M | TODAY | |||||
Start Schedule | i_Sched_From | O | ||||||
Product Type | i_product_type | O | ||||||
Customer Group | i_cust_group | O | ||||||
Customer | i_customer | O |
Call Collection OTIF Time Window
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Collection OTIF Time Window | coll_OTIF_window | dp_csv_nr.coll_otif_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_End_Date_Time | M | TODAY | |||||
Start Schedule | i_Sched_From | O | ||||||
End Schedule | i_Sched_To | O | ||||||
Product Type | i_product_type | O | ||||||
Customer Group | i_cust_group | O | ||||||
Customer | i_customer | O | ||||||
Carrier | i_carrier | O | ||||||
From Date | i_Start_Date_Time | M | TODAY |
Call Delivery OTIF Day
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Delivery OTIF Day | del_OTIF_date_window | dp_csv_nr.del_otif_date_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Carrier | i_carrier | O | ||||||
Customer | i_customer | O | ||||||
Customer Group | i_cust_group | O | ||||||
Product Type | i_product_type | O | ||||||
End Schedule | i_Sched_To | O | ||||||
Start Schedule | i_Sched_From | O | ||||||
From Date | i_Start_Date_Time | M | TODAY | |||||
To Date | i_End_Date_Time | M | TODAY |
Call Delivery OTIF Time Window
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Delivery OTIF Time Window | del_OTIF_window | dp_csv_nr.del_otif_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | O | ||||||
Carrier | i_carrier | O | ||||||
Customer Group | i_cust_group | O | ||||||
Product Type | i_product_type | O | ||||||
End Schedule | i_Sched_To | O | ||||||
Start Schedule | i_Sched_From | O | ||||||
To Date | i_End_Date_Time | M | TODAY | |||||
From Date | i_Start_Date_Time | M | TODAY |
Campus KPI Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Campus KPI Extract | Campus_KPI_Extract | KPI.KPI_CAMPUS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_date_from | M | TODAY | |||||
Carrier | i_carrier | O | ALL | |||||
Cost Centre | i_cost_centre | O | ALL | |||||
Date Range Type | i_date_type | M | String | |||||
Depot | i_depot | O | ALL | Location Id | Name | |||
To Date | i_date_to | M | TODAY | |||||
Client | i_client | O | ALL |
Carrier DUs Shipped
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier DUs Shipped | CARRIER_DUS_SHIPPED | DP_CSV5.CARRIER_DUS_SHIPPED |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | I_DATE_FROM | M | TODAY | |||||
Carrier | P_CARRIER | O | STRING | ALL | ||||
To Date | I_DATE_TO | M | TODAY |
Carrier Delivery Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier Delivery Report | Carrier_Delivery_Report | DP_CSV5.CARRIER_DELIVERY |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Sched Name | P_SCHED_NAME | M | ||||||
Trip ID | P_TRIP | O | STRING | ALL | ||||
Carrier | P_CARRIER | M | ||||||
Depot | P_DEPOT | M |
Carrier Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier Invoice | Carrier_Invoice | CSV.CARRIER_INVOICE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Invoice No | I_INVOICE_NO | M | ||||||
Credit Acc | I_CREDIT_ACC | M | ||||||
Debit Acc | I_DEBIT_ACC | M |
Carrier Self Billing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier Self Billing | Carrier_Self_billing | DP_CSV_BNL.CARRIER_SELF_BILLING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | i_start_sched | M | ||||||
Carrier | i_carrier | 0 | ||||||
End Schedule | i_end_sched | M |
Catalyst Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Catalyst Extract | CATALYST_EXTRACT | CSV.CATALYST_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | P_END_SCHED | M | ||||||
Start Schedule | P_START_SCHED | M |
Co-ordinate Non-Conformities
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Co-ordinate Non-Conformities | Co_Ord_Non_Conf | DP_CSV6.CO_ORD_NON_CONFORM |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | i_sched_from | M | ||||||
End Schedule | i_sched_to | M | ||||||
Driver | i_driver | O | ||||||
TomTom,Epod,Both | i_inc | M | B | |||||
Discrepancy Dist | i_disc_dist | 0 | 1 | |||||
Depot | i_depot | O |
Commercial
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Commercial | COMMERCIAL | CSV.Commercial_Orders |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | I_SCHEDULE | M |
Compliance Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Compliance Report | COMPLIANCE_REPORT | DP_CSV_DUN.COMPLIANCE_REPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Collection Date | P_COL_DATE | M |
Concurrent Logon Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Concurrent Logon Export | Concurrent_Logon_Export | CSV.Concurrent_Logon |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_from_date | O | TODAY | |||||
To Date | i_to_date | O | TODAY |
Contracts
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Contracts | CONTRACTS | CSV.CONTRACTS |
No Parameters
Cross Dock
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Cross Dock | CROSS_DOCK | DP_CSV6.CROSS_DOCK |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule From | i_sched_from | M | ||||||
Schedule To | i_sched_to | M | ||||||
Customer | i_customer | O | STRING | |||||
Media Type | i_media_type | O | STRING | |||||
Depot | i_depot | O | STRING | |||||
Route | i_route | O | STRING | |||||
Dealer | i_dealer | O | STRING |
Customer Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Customer Invoice | Customer_Invoice | CSV.Customer_Invoice |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Invoice No | I_INVOICE_NO | M | ||||||
Credit Acc | I_CREDIT_ACC | M | ||||||
Debit Acc | I_DEBIT_ACC | M |
Customer Invoice By Dates
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Customer Invoice By Dates | Customer_Invoice_By_Dates | CSV.Customer_Invoice_By_Dates |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Payment Status | i_act_or_prov | O | ||||||
From Date | I_START_DATETIME | M | ||||||
To Date | I_END_DATETIME | M | ||||||
Customer | I_CUSTOMER | M |
Customer Invoice Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Customer Invoice Extract | Customer_Invoice | CSV.Customer_Invoice |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Debit Acc | I_DEBIT_ACC | M | ||||||
Invoice No | I_INVOICE_NO | M | ||||||
Credit Acc | I_CREDIT_ACC | M |
Cut Offs Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Cut Offs Extract | Cut_offs_extract | DP_CSV6.CUT_OFF_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_end_sched | M | ||||||
Customer | i_customer | 0 | ||||||
Start Schedule | i_start_sched | M |
D365 Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
D365 Extract | DP_FINANCE.D365_EXPORT | D365_EXPORT_ |
No parameters.
DELIVERY_OVERVIEW
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DELIVERY_OVERVIEW | DELIVERY_OVERVIEW | dp_csv3.delivery_overview |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
POD Confirmed | P_POD | O | ||||||
Owning Depot | P_OWNING_DEPOT | O | ||||||
To Schedule | P_END_SCHED | M | ||||||
From Schedule | P_START_SCHED | M |
DOOD Rpt
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DOOD Rpt | DOOD_RPT | dp_csv_dood.dood_rpt |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule To | I_SCHED_TO | M | ||||||
Schedule From | I_SCHED_FROM | M | ||||||
Customer | I_CUSTOMER | O | STRING | OPENFIELD |
DUs Despatched
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DUs Despatched | DUS_DESPATCHED_EXTRACT | DP_CSV_GEN.DUS_DESPATCHED_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Consignment Num | O | STRING | ||||||
Start Sched | O | |||||||
Manifest | O | STRING | ||||||
PO Number | O | STRING | ||||||
Supplier | O | |||||||
End Sched | O |
DUs Not Loaded
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DUs Not Loaded | DUS_NOT_LOADED_EXTRACT | DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | p_sched_date | M | ||||||
Store | p_store | O | Store | Location ID | Name |
DUs Not Received
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DUs Not Received | DUS_NOT_RECEIVED_EXTRACT | DP_CSV_GEN.DAILY_EXT_NOT_RECD |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_avail_to | M | ||||||
From Date | i_avail_from | M |
Daily Manifest E-OT-L
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Manifest E-OT-L | DAILY_MANIFEST_E_OT_L_EXTRACT | DP_CSV_GEN.DAILY_EXT_MANIFEST |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_avail_to | M | ||||||
From Date | i_avail_from | M |
Daily Receiving E-OT-L
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Receiving E-OT-L | RECEIVING_E_OT_L_EXTRACT | DP_CSV_GEN.DAILY_EXT_RECEIPTING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_sched_to | M | ||||||
Start Schedule | i_sched_from | M |
Daily Transport Plan
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Transport Plan | DAILY_TRANSPORT_PLAN_EXTRACT | DP_CSV_GEN.DAILY_TRANSPORT_PLAN |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_avail_from | M | ||||||
Supplier | i_supplier | M | STRING | ALL | ||||
To Date | i_avail_to | M | ||||||
Order Status | i_ord_status | M | STRING | ALL |
Daily Unscheduled Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Unscheduled Orders | DAILY_UNSCHEDULED_ORDERS_EXTRACT | DP_CSV_GEN.DAILY_UNSCHED_ORD |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_avail_from | M | ||||||
To Date | i_avail_to | M |
Debrief Performance
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Debrief Performance | debrief_performance | dp_csv_nr.debrief_performance |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cust Group | i_cust_group | O | ||||||
Customer | i_customer | O | ||||||
Carrier Group | i_carrier_group | O | ||||||
Cost Centre | i_cost_centre | O | ||||||
From Date | i_Start_Date_Time | M | TODAY | |||||
Carrier Code | i_carrier_code | O | ||||||
From Date | i_End_Date_Time | M | TODAY |
Del Scans
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Del Scans | DEL_SCANS | DP_CSV6.DEL_SCANS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_end_sched | M | ||||||
Start Schedule | i_start_sched | M |
Delivery Conf
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Delivery Conf | BGYP_DELCONF_ | DP_CSV5.DELIVERY_CONF |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Owning Depot | p_own | O | ||||||
Cost Centre | p_cost | M | ||||||
To Actual date | p_to_date | M | TODAY | |||||
Type | p_type | M | M | |||||
From Actual date | p_from_date | M | TODAY |
Delivery Schedule Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Delivery Schedule Extract | Delivery_Schedule | DP_CSV_DHL.DELIVERY_SCHEDULE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Show Dates | P_DATE_SELECT | Y |
Depot Exits by Hour (Loads)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Depot Exits by Hour (Loads) | DEPOT_EXITS_LOADS | CSV.DEPOT_EXITS_BY_HOUR_LOADS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Depot | M | Depot | Location Id | Name | |||
From Date | M | TODAY | |||||
To Date | M | TODAY | |||||
From Date | M | TODAY | |||||
To Date | M | TODAY | |||||
Depot | M | Depot | Location Id | Name |
Depot Exits by Hour (RPEs)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Depot Exits by Hour (RPEs) | DEPOT_EXITS_RPE | CSV.DEPOT_EXITS_BY_HOUR_RPE |
Parameters:
Detailed Interface Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Detailed Interface Report | Detailed_Interface_Report | CSV.Detailed_Interface_Report |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer Group | O | ||||||
To Date | O | TODAY | |||||
Customer | O | ||||||
From Date | O | TODAY | |||||
Status | M | STRING | All |
Dixons Catalyst Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dixons Catalyst Report | fn | CSV.Dixons_Catalyst_Report |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
End Schedule | M | ||||||
Carrier | O | ||||||
Depot | O | Depot | Location Id | Name | |||
Start Schedule | M |
Dixons Order Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dixons Order Export | Dixons_Order_Export | CSV.Dixons_Order_Export |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | O | TODAY | |||||
Carrier | O | ||||||
To Date | O | TODAY |
Dixons Trip Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dixons Trip Extract | Dixons_Trip_Extract | CSV.Dixons_Trip_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Carrier | O | ||||||
To Date | O | TODAY | |||||
From Date | O | TODAY |
Driver Hours
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Driver Hours | driver_hours | dp_csv_nr.driver_hours |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
Customer Group | O | ||||||
To Date | M | TODAY | |||||
Cost Centre | O |
Driver Scanning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Driver Scanning | DRIVER_SCANNING | DP_CSV6.DRIVER_SCANNING |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | STRING | |||||
Dealer | O | STRING | |||||
Depot | O | STRING | |||||
Route | O | STRING | |||||
Media Type | O | STRING | |||||
Schedule To | M | ||||||
Schedule From | M | ||||||
Activity | O | STRING |
Dunelm Actual Load
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Actual Load | DUNELM_ACTUAL_LOAD | DP_CSV_DUN.daily_ext_load |
Parameters:
Dunelm Actual Unload
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Actual Unload | DUNELM_ACTUAL_UNLOAD | DP_CSV_DUN.daily_ext_unload |
Parameters:
Dunelm Backing Sheet
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Backing Sheet | BACKING_SHEET | DP_CSV2.BACKING_SHEET |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Manifest | O | ||||||
Customer | M | ||||||
Sched To | M | ||||||
Sched From | M |
Dunelm DUs Despatched Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm DUs Despatched Extract | DUNELM_DUS_DESPATCHED_EXTRACT | DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT |
Parameters:
Dunelm DUs Not Loaded Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm DUs Not Loaded Extract | DUNELM_DUS_NOT_LOADED_EXTRACT | DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT |
Parameters:
Dunelm DUs Not Received
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm DUs Not Received | DUNELM_DUS_NOT_RECEIVED | DP_CSV_DUN.daily_ext_not_recd |
Parameters:
Dunelm Inventory Transactions
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Inventory Transactions | DUN_INVENTORY_TRANS | DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Delivery Trip | O | ||||||
Trunk Trip | O | ||||||
Collection Trip | O | ||||||
Store | O | ||||||
Customer | O | ||||||
Date Type | M | STRING | C | ||||
To Date | M | TODAY | TODAY:23:59 | ||||
From Date | M | TODAY | TODAY:00:00 |
Dunelm Item Movements 3
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Item Movements 3 | DUN_ITEM_MOVEMENTS_EXTRACT | DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Manifest Number | O | ||||||
Actual To Date | M | TODAY | |||||
Actual From Date | M | TODAY | |||||
DU Type | O | ||||||
Supplier | O | ||||||
P/O Number | O | ||||||
Store | O |
Dunelm Item Movements Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Item Movements Extract | DUN_ITEM_MOVEMENTS_EXTRACT | DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Manifest Number | O | STRING | |||||
P/O Number | O | ||||||
Store | O | ||||||
DU Type | O | ||||||
Supplier | O | ||||||
Actual To Date | M | TODAY | |||||
Actual From Date | M | TODAY |
Dunelm Item Movements Extract New
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Item Movements Extract New | DUN_ITEM_MOVEMENTS_EXTRACT | DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
P/O Number | O | ||||||
Manifest Number | O | STRING | |||||
Store | O | ||||||
DU Type | O | ||||||
Supplier | O | ||||||
Actual From Date | M | TODAY | |||||
Actual To Date | M | TODAY |
Dunelm Left Offs
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Left Offs | Left_Offs_Extract | DP_CSV_DUN.left_offs_extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Trip Id (Optional) | O | ||||||
Days Back | M | STRING | 30 | ||||
Store (Optional) | O | Store | Location Id | Name |
Dunelm Loading Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Loading Extract | DUNELM_LOADING_EXTRACT | DP_CSV2.DUN_LOADING |
Parameters:
Dunelm Manifest E-OT-L Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Manifest E-OT-L Extract | DUNELM_MANIFESTED_EOL | DP_CSV_DUN.daily_ext_manifest |
Parameters:
Dunelm Manual Loaded Items Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Manual Loaded Items Extract | MANL_SCAN_ORDER_DETAIL_EXTRACT | DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | O | ||||||
To Date | O |
Dunelm Receiving Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Receiving Extract | DUNELM_RECEIVING_EXTRACT | DP_CSV2.DUN_RECEIVING |
Parameters:
Dunelm Recieving E-OT-L Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Recieving E-OT-L Extract | DUNELM_RECEIPTED_EOL | DP_CSV_DUN.daily_ext_receipting |
Parameters:
Dunelm Supplier DU Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier DU Extract | DUNELM_SUPPLIER_DU_EXTRACT | DP_CSV2.DUN_SUPPLIER_DU_EXTRACT |
Parameters:
Dunelm Supplier DU Extract by Store
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier DU Extract by Store | DUNELM_DU_STORE_EXTRACT | DP_CSV2.DUN_DU_STORE_EXTRACT |
Parameters:
Dunelm Supplier Revenue Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier Revenue Extract | DUNELM_SUPPLIER_REVENUE_EXTRACT | DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT |
Parameters:
Dunelm Supplier Revenue Extract New
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier Revenue Extract New | DUNELM_SUPPLIER_REVENUE_NEW | DP_CSV2.DUN_SUPPLIER_REVENUE_NEW |
Parameters:
Dunelm Supplier Trends Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier Trends Extract | DUN_SUPPLIER_TRENDS | dp_csv_dun.dun_du_rpe_revenue_extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Year | M | ||||||
Week | M |
Dunelm Transport Plan
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Transport Plan | DUNELM_TRANSPORT_PLAN | DP_CSV_DUN.daily_transport_plan |
Parameters:
Dunelm Unsched Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Unsched Orders | DUNELM_UNSCHED_ORD | DP_CSV_DUN.daily_unsched_ord |
Parameters:
Duplicate Postcodes
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Duplicate Postcodes | DUPLICATE_POSTCODES | dp_csv2.duplicate_postcodes_extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Ignore Inactive? | O | ||||||
Location From | O | Location From | Location Id | Location Name | |||
Location To | O | Location To | Location Id | Location Name |
EFX Inbound Errors
Report Name | Filename | Procedure for Scheduling |
---|---|---|
EFX Inbound Errors | EFX_Inbound_Errors | DP_CSV2.EFX_In_Errs_Extract |
Parameters:
ERC
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ERC | ERC | DP_CSV_DHL.ERC |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Sched End | M | ||||||
Sched Start | M | ||||||
Carrier | O | ||||||
DHL Carriers | M | ||||||
Detail Level | M |
Equipment Moves
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Equipment Moves | Equip_Move | DP_CSV2.EQUIP_MOVE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Owning Depot | O | ||||||
Customer | O | ||||||
To Date | M | TODAY | |||||
From Date | M | TODAY | |||||
Carrier | O |
Extract Lane
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Extract Lane | EXTRACT_LANE | CSV.EXTRACT_BY_LANE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Cost Centre | O | Cost Centre | Location Id | Name | |||
Customer | O |
Failed Shipment
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Failed Shipment | FAILED_SHIPMENT | dp_csv3.failed_shipment |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule To | M | ||||||
Schedule From | M | ||||||
Customer | O | STRING | OPENFIELD |
Fixed Routes Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Fixed Routes Extract | Routes_Extract | CSV.FIXED_ROUTES_EXPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Show Active / Inactive | M | STRING | B | ||||
Carrier | O | ||||||
Depot | O | Depot | Location Id | Name |
GREENE KING Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
GREENE KING Interface Results | GREENE_KING_interface_results | CSV.GREENE_KING_if_res |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | ||||||
Depot | O | ||||||
To Date | O | TODAY | |||||
From Date | O | TODAY |
GYP EFX Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
GYP EFX Export | GYP_EFX_Export | DP_CSV5.GYP_EFX_EXPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Trip Status | O | ||||||
To Schedule | M | ||||||
From Schedule | M | ||||||
Cost Centre | O | ||||||
Customer Group | O |
HC Booking In Form
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HC Booking In Form | HC_BOOKING_IN_FORM | DP_CSV5.P_HC_BOOKING_IN_FORM |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M | ||||||
Group Name | O | ||||||
Delivery Location | O | ||||||
Customer | O | ||||||
Group Name | O | ||||||
Schedule | M | ||||||
Delivery Location | O | ||||||
Customer | O |
HC Haulier Trip Sheet
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HC Haulier Trip Sheet | HAULIER_TRIP_SHEET | DP_CSV2.HAULIER_TRIP_SHEET |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Trip ID (optional) | O | ||||||
Owning Depot | O | Depot | Location Id | Name | |||
Schedule | M | ||||||
Carrier | O | ||||||
Group Name | O | ||||||
Load Location | O | Loading Location | Location Id | Name | |||
Owning Depot | O | Depot | Location Id | Name | |||
Trip ID (optional) | O | ||||||
Schedule | M | ||||||
Carrier | O | ||||||
Group Name | O | ||||||
Load Location | O | Loading Location | Location Id | Name |
HCR Customer Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HCR Customer Orders | HCR_CUSTOMER_ORDERS | DP_CSV_DHL.HCR_CUSTOMER_ORDERS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | ||||||
Schedule | M | ||||||
Cost Centre | O | ||||||
Depot | O |
HCR Loading Sheet CSV
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HCR Loading Sheet CSV | HCR_LOADING_SHEET | DP_CSV5.HCR_LOADING_SHEET |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Trip ID (optional) | O | ||||||
Load Location | O | Loading Location | Loading Location | Name | |||
Owning Depot | O | Depot | Loading Location | Name | |||
Schedule From | M | ||||||
Schedule To | M | ||||||
Carrier | O | ||||||
Customer | O | ||||||
Group Name | O |
Haulier Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Haulier Invoice | Haulier_Invoice | DP_CSV5.HAULIER_INVOICE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
End Date | O | ||||||
Start Date | O | ||||||
Invoice ID | O | STRING | |||||
End Date | O | ||||||
Start Date | O | ||||||
Invoice ID | O | STRING |
Heavy Vehicle Utilisation
Warning: Missing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Schedule | M | ||||||
End Schedule | M | ||||||
Customer Group | O |
Historical Lane Based Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | O | TODAY | |||||
From Date | M | TODAY |
IND Trip and Order Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
IND Trip and Order Detail | IND_Trip_Order_Detail_Extract | DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Activity | M | STRING | Both | ||||
End Schedule | M | ||||||
Carrier | O | ||||||
Loaded At | O | ||||||
Start Schedule | M | ||||||
Group Name | M |
ISC Finance (2) Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ISC Finance (2) Export | FINANCE_2_EXPORT | DP_CSV2.FINANCE_EXPORT_V2 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | M | STRING | ALL | ||||
End Schedule | M | ||||||
Start Schedule | M |
ISC Finance (3) Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ISC Finance (3) Export | FINANCE_2_EXPORT | CSV6.ISC_FINANCE_2_EXPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | M | STRING | ALL | ||||
End Schedule | M | ||||||
Start Schedule | M |
ISC Finance (4) Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ISC Finance (4) Export | FINANCE_2_EXPORT | CSV7.FINANCE_EXPORT_V2 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | M | STRING | ALL | ||||
End Schedule | M | ||||||
Start Schedule | M |
Interface Errors Failures
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Interface Errors Failures | Interface_Errors_Failures | DP_CSV5.INTERFACE_ERRORS_FAILURES |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
External Ref | O | STRING | |||||
Customer | O | Customer | |||||
Source System | O | ||||||
End Date | M | TODAY | |||||
Start Date | M | TODAY |
Invalid Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Invalid Orders | Invalid_Orders | DP_CSV6.INVALID_ORDERS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Schedule | M | ||||||
End Schedule | M | ||||||
Customer | 0 |
Item Movements
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Item Movements | ITEM_MOVEMENTS_EXTRACT | DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Actual To Date | M | TODAY | |||||
Actual From Date | M | TODAY | |||||
Supplier | O | ||||||
DU Type | O | ||||||
Store | O | ||||||
Manifest Number | O | ||||||
P/O Number | O |
Item Movements 2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Item Movements 2 | ITEM_MOVEMENTS_2_EXTRACT | DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
DU Type | O | ||||||
Supplier | O | ||||||
Actual From Date | M | TODAY | |||||
Actual To Date | M | TODAY | |||||
P/O Number | O | ||||||
Store | O | ||||||
Manifest Number | O |
Item Movements 3
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Item Movements 3 | ITEM_MOVEMENTS_3_EXTRACT | DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
P/O Number | O | ||||||
Store | O | ||||||
Manifest Number | O | ||||||
DU Type | O | ||||||
Supplier | O | ||||||
Actual To Date | M | TODAY | |||||
Actual From Date | M | TODAY |
Items Not Scanned By Date
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Items Not Scanned By Date | Items_Not_Scanned | DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule To | M | ||||||
Schedule From | M | ||||||
Depot | M |
Items Not Scanned By Trip
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Items Not Scanned By Trip | Items_Not_Scanned | DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Trip | M | ||||||
Schedule | M |
JEYES Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
JEYES Interface Results | JEYES_interface_results | CSV.JEYES_if_res |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | O | TODAY | |||||
Customer | O | ||||||
Depot | O | ||||||
From Date | O | TODAY |
Job Notes
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Job Notes | Job_Notes | DP_CSV5.JOB_NOTES |
Parameters:
KPI By Lane
Report Name | Filename | Procedure for Scheduling |
---|---|---|
KPI By Lane | KPI_BY_LANE | CSV.KPI_BY_LANE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer Group | O | ||||||
End Date | M | ||||||
Show Detail | M | STRING | Y | ||||
Grouping | M | STRING | CUST_GROUP | ||||
End Date | M | TODAY | |||||
Start Date | M | TODAY | |||||
Start Date | M | ||||||
Tolerance(days) | O | ||||||
Separate Pages | M | STRING | N | ||||
Customer Group | O | ||||||
Grouping | M | STRING | CUST_GROUP |
KPI Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
KPI Extract | CN_KPI_Extract | KPI_EXTRACT.KPI_EXTRACT |
Parameters:
Kraft KPI
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Kraft KPI | KRAFT_KPI | CSV.Trips_with_Orders |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
To Date | M | TODAY | |||||
Cost Centre | O |
LFS Packages
Report Name | Filename | Procedure for Scheduling |
---|---|---|
LFS Packages | LFS_Packages | DP_CSV_LFS.LFS_PACKAGES |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M | ||||||
Order Status | O | ||||||
Customer | O | ||||||
External Ref | O |
Lane Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Lane Extract | Lane_Extract | CSV.LANE_EXPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | ||||||
Cost Centre | O | ||||||
To Loc | O | To Loc | Location Id | Name | |||
From Loc | O | From Loc | Location Id | Name |
Left Offs
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Left Offs | LEFT_OFFS_EXTRACT | DP_CSV_GEN.LEFT_OFFS_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Store (optional) | O | Store | Location ID | Name | |||
Days Back | M | STRING | 30 | ||||
Trip ID (optional) | O |
Loading Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Loading Extract | LOADING_EXTRACT | DP_CSV_GEN.EXT_LOADING |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Loading Schedule CSV
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Loading Schedule CSV | Loading_Schedule | CSV.LOADING_SCHEDULE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Depot | M | Depot | Location Id | Name | |||
To Date | M | TODAY | |||||
From Date | M | TODAY |
Location Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Export | Location_Export | DP_CSV2.LOCATION_EXPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Country | O |
Location Export GL
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Export GL | Location_Export | CSV.LOCATION_EXPORT_GL |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Country | O |
Location Export GPR
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Export GL | Location_Export | CSV.LOCATION_EXPORT_GPR |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Country | O |
Location Pre-Warning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Pre-Warning | Loc_Del_Pre_Warn | CSV.Loc_Del_Pre_Warning |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Load Type | M | STRING | ALL | ||||
Trip Status | M | STRING | ALL | ||||
To Date | M | TODAY | |||||
To Date | M | TODAY | |||||
From Date | M | TODAY | |||||
Depot | M | Depot | Location Id | Name | |||
Depot | M | Depot | Location Id | Name | |||
From Date | M | TODAY | |||||
Load Type | M | STRING | ALL | ||||
Trip Status | M | STRING | ALL |
MDD Code 03 Exceptions
Report Name | Filename | Procedure for Scheduling |
---|---|---|
MDD Code 03 Exceptions | MDD Code 03 Exceptions | CSV.MDD_Code_03_Exceptions |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
To Date | M | TODAY |
MTS Finance Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
MTS Finance Export | FINANCE_EXPORT | CSV.finance_export_v2 |
Parameters:
MTS Finance Export V2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
MTS Finance Export | FINANCE_EXPORT_V2 | CSV.finance_export_v2 |
Parameters:
Manual Loaded Items
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Manual Loaded Items | MANUAL_LOADED_ITEMS_EXTRACT | DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | O | ||||||
To Date | O |
Master and Child Locations
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Master and Child Locations | Master_and_Child | DP_CSV5.MASTER_AND_CHILD |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Show UnMapped | O | Show UnMapped | |||||
Show Mapped | O | Show Mapped |
Message Maintenance
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Message Maintenance | Message_Maintenance | CSV.msg_maint |
Parameters:
Missing Lat Long Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Missing Lat Long Report | MISSING_LAT_LONGS | dp_csv3.missing_lat_long_extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Cost Centre | M | ALL |
Missing Steps Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Missing Steps Report | Missing_Steps_Report | DP_CSV5.Missing_Steps_Report |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | M | TODAY | |||||
Missing Step | O | STRING | ALL | ||||
From Date | M | TODAY |
Month End Accruals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Month End Accruals | month_end_accruals | dp_csv_nr.month_end_accruals |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
From Date | M | TODAY | |||||
Cost Centre | O | ||||||
Customer | O | ||||||
Cust Group | O |
NR Additional Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
NR Additional Report | nr_additional_rep | dp_csv_nr.nr_additional_report |
Parameters:
NR Finance Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
NR Finance Extract | NR_Finance_Extract | DP_CSV_NR.NR_FINANCE_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
Debriefed | M | ||||||
Carrier | O | ||||||
To Region | M | STRING | ALL | ||||
To Date | M | TODAY | |||||
Carrier Group | O | ||||||
Strategy | O | ||||||
Cost Centre | O | ||||||
Customer | O | ||||||
From Region | M | STRING | ALL |
NR Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
NR Invoice | NR_Invoice | DP_CSV_NR.NR_INVOICE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | M | TODAY | |||||
From Date | M | TODAY | |||||
Debriefed | M | ||||||
Carrier | O | ||||||
To Region | M | STRING | ALL | ||||
From Region | M | STRING | ALL | ||||
Carrier Group | O | ||||||
Strategy | O | ||||||
Customer | O | ||||||
Cost Centre | O |
OPS KPI Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
OPS KPI Extract | OPS_KPI_Extract | KPI.KPI_OPS_EXTRACT |
Parameters:
OPS KPI Extract2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
OPS KPI Extract2 | OPS_KPI_Extract | KPI.KPI_OPUS_EXTRACT |
Parameters:
OTM Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
OTM Export | OTM_Export | DP_CSV_DHL.OTM_EXPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Date To | M | TODAY | |||||
Date From | M | TODAY | |||||
Carrier | O |
On Time Arrivals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Arrivals | ON_TIME_ARRIVALS | DP_CSV6.ON_TIME_ARRIVALS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Outbase | O | ||||||
Media Type | O | ||||||
Route Code | O | ||||||
Dealer | O | ||||||
Customer | O | ||||||
Schedule To | M | ||||||
Schedule From | M |
On Time Drops
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Drops | ON_TIME_DROPS | DP_CSV6.ON_TIME_DROPS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Outbase | O | ||||||
Route Code | O | ||||||
Media Type | O | ||||||
Schedule To | M | ||||||
Customer | O | ||||||
Schedule From | M | ||||||
Dealer | O |
On Time Items
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Items | ON_TIME_ITEMS | DP_CSV6.ON_TIME_ITEMS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Dealer | O | ||||||
Outbase | O | ||||||
Route Code | O | ||||||
Schedule To | M | ||||||
Schedule From | M | ||||||
Media Type | O | ||||||
Customer | O |
On Time Items (Assets)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Items (Assets) | ON_TIME_ITEMS | DP_CSV6.ON_TIME_ITEMS_ASSETS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule From | M | ||||||
Customer | O | ||||||
Dealer | O | ||||||
Outbase | O | ||||||
Route Code | O | ||||||
Media Type | O | ||||||
Schedule To | M |
On Time Returns
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Returns | ON_TIME_RETURNS | DP_CSV6.ON_TIME_RETURNS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Media Type | O | ||||||
Route Code | O | ||||||
Outbase | O | ||||||
Dealer | O | ||||||
Customer | O | ||||||
Schedule From | M | ||||||
Schedule To | M |
Operational Information
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Operational Information | Operational_Information | DP_CSV2.OPERATIONAL_INFO |
Parameters:
Order Charges Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Charges Extract | ORD_CHARGE | DP_CSV5.ORD_CHARGE_REPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Date | M | TODAY |
Order Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Extract | ORDER_EXTRACT.csv | DP_CSV2.HCR_ORDER_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
End Sched | M | ||||||
Start Sched | M |
Order Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Interface Results | ORDER_INTERFACE_RESULTS | CSV.ORDER_INTERFACE_RESULTS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | ||||||
To Date | O | TODAY | |||||
From Date | O | TODAY | |||||
Depot | O | ||||||
Message Type | O |
Order Items POD Debriefed
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Items POD Debriefed | Order_Items_POD_Debriefed | DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | ||||||
End Schedule | O | ||||||
Start Schedule | M |
Order Savings
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Savings | ORDER_SAVINGS | CSV.Order_savings |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Schedule | M | ||||||
End Schedule | O | ||||||
Show Neg Savings | M |
Order Tracking
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Tracking | Order_Tracking | DP_CSV5.ORDER_TRACKING |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | STRING | OPENFIELD | ||||
Month | M | ||||||
Week Offset | O | ||||||
Year | M | ||||||
Cost Centre | O | STRING | OPENFIELDCC |
Orders for Relabelling
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Orders for Relabelling | ORDERS_FOR_RELABELLING | DP_CSV_DHL.ORDERS_FOR_RELABELLING |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Orders to LogiX
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Orders to LogiX | LogiX_Orders | DP_LOGIX.ORDER_EXPORT |
Parameters:
Orders to Paragon
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Orders to Paragon | Paragon_Orders | CSV.Orders_to_Paragon |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|
Outbound Shortage
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Outbound Shortage | OUTBOUND_SHORTAGE | DP_CSV6.OUTBOUND_SHORTAGE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule To | M | ||||||
Schedule From | M | ||||||
Dealer | O | STRING | |||||
Media Type | O | STRING | |||||
Route | O | STRING | |||||
Depot | O | STRING | |||||
Customer | O | STRING |
PAYMENT_DTLS
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PAYMENT_DTLS | PAYMENT_DTLS | OF_INT.WRITE_PAYMENT_DETAILS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
End Date | M | TODAY | |||||
From Date | M | TODAY | |||||
Customer | M |
POC to SAP Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POC to SAP Extract | POC to SAP Extract | CSV.POC_to_Sap_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|
POC to SAP Extract(A)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POC to SAP Extract(A) | POC to SAP Extract(A) | CSV.POC_to_Sap_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Resend All? | M | STRING | No |
POC-POD Reprocessing Team Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POC-POD Reprocessing Team Export | POC_POD_REPOROCESSING | DP_CSV.POC_POD_REPROCESSING |
Parameters:
POD Delivery Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD Delivery Extract | POD_Delivery_Extract | DP_CSV2.POD_DELIVERY_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Schedule | M | ||||||
To Schedule | M | ||||||
Del Msg Sent | O | STRING | ALL | ||||
POD Status | O | STRING | ALL | ||||
Carrier | O | STRING | ALL | ||||
> Days Outstanding | O | STRING | 0 | ||||
Group | O | STRING | ALL | ||||
Customer | O | STRING | ALL | ||||
Scanning Depot | O | STRING | ALL | Depot | Location Id | Name |
POD Generation Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD Generation Extract | POD_GEN | DP_CSV5.POD_REPORT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
POD Flow | M | ||||||
Date To | M | TODAY | |||||
Date From | M | TODAY | |||||
Schedule | O |
POD to SAP Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD to SAP Extract | POD to SAP Extract | CSV.POD_to_Sap_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|
POD to SAP Extract(A)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD to SAP Extract(A) | POD to SAP Extract(A) | CSV.POD_to_Sap_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Resend All? | M | STRING | No |
PORSCHE19 Invoice Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PORSCHE19 Invoice Extract | Invoice_Extract | DP_CSV2.Invoice_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | M | STRING | PORSCHE19 | ||||
Sub Debit Account | O | STRING | ALL | ||||
Trip ID | O | STRING | ALL | ||||
Sub Credit Account | O | STRING | ALL | ||||
Invoice ID | O | STRING | 0 | ||||
Export ID | O | STRING | 0 |
PROVIDER_REVENUE
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PROVIDER_REVENUE | PROVIDER_REVENUE | dp_csv3.provider_revenue |
Parameters:
== || ||Owning Depot ||O || || || || || || |- |To Schedule ||M || || || || || || |- |From Schedule ||M || || || || || || |}
Parts and Empites
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parts and Empites | Parts_and_Empties | DP_CSV5.PARTS_AND_EMPTIES |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Export Type | M | ||||||
Schedule From | M | ||||||
Schedule To | M | ||||||
Location From | O | ||||||
Customer | M |
PostCode Matrix
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PostCode Matrix | POSTCODE_MATRIX | dp_csv3.postcode_matrix |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|
Pre Invoice Check
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Pre Invoice Check | Pre_Invoice_Check | CSV.PRE_INVOICE_CHECK |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Cut-off Date | M | TODAY |
Process Items Audit
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Process Items Audit | PROCESS_ITEMS_AUDIT | DP_CSV6.PROCESS_ITEMS_AUDIT |
Parameters:
Process Items Interface Audit
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Process Items Interface Audit | PROCESS_ITEMS_INTERFACE_AUDIT | DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Incl. Reprocessed | M | STRING | N | ||||
Start Date | M | TODAY | |||||
End Date | M | TODAY | |||||
Record Status | M | STRING | ALL |
Provisional Booking Exceptions
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Provisional Booking Exceptions | Provisional Booking Exceptions | CSV.Provisional_Booking_Exceptions |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | M | TODAY | |||||
From Date | M | TODAY |
Purchase Order Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Purchase Order Extract | po_extract | DP_CSV2.PURCHASE_ORDER_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Status | O | STRING | All | ||||
To Date | O | TODAY | TODAY | ||||
From Date | O | TODAY | TODAY |
Reason Listings
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Reason Listings | REASON_LISTING_ | dp_csv3.reasons_listing |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Date From | M | DATETIME | TODAY:00:01 | ||||
Depot | M | ||||||
Date To | M | DATETIME | TODAY:23:59 |
Receipt Scanning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Receipt Scanning | RECEIPT_SCANNING | DP_CSV6.RECEIPT_SCANNING |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Dealer | O | STRING | |||||
Route | O | STRING | |||||
Media Type | O | STRING | |||||
Customer | O | STRING | |||||
Date To | M | TODAY | |||||
Date From | M | TODAY | |||||
Depot | O | STRING |
Receiving Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Receiving Extract | RECEIVING_EXTRACT | DP_CSV_GEN.EXT_RECEIVING |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Revenue Check (Account)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Revenue Check (Account) | revenue_report | dp_csv_nr.revenue_report |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
From Date | M | TODAY | |||||
Cost Centre | O | ||||||
Cust Group | O | ||||||
Customer | O |
SMS Email Summary Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
SMS Email Summary Report | sms_email_summary | DP_CSV5.SMS_EMAIL_SUMMARY |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
Cost Centre | M | STRING | ALL |
STL Trip and Order Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
STL Trip and Order Extract | STL_Trip_Order_Extract | DP_CSV2.STL_TRIP_ORDER_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Trip Schedule | M | ||||||
End Trip Schedule | M | ||||||
Order Status | O | ||||||
Carrier | O | ||||||
Location Type | O |
Sales Margin Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Sales Margin Extract | sme | CSV.order_costs |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Carrier Group | O | ||||||
Schedule | M | ||||||
Customer Group | O | ||||||
Last Schedule | O | ||||||
Customer | O |
Savings Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Savings Extract | Savings | CSV.SAVINGS_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | O | TODAY | |||||
Credit Acc | O | ||||||
Customer Group | O | ||||||
To Cty Code | O | ||||||
From Cty Code | O | ||||||
Lane Id | O | ||||||
From Date | O | TODAY | |||||
Debit Acc | O | ||||||
Saving (> or <) | O | STRING |
Schedule
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Schedule | Schedule | CSV.SCHEDULE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
To Date | M | TODAY |
Schedule Details
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Schedule Details | schedule_details | DP_CSV_GEN.SCHEDULE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Schedule | M | ||||||
End Schedule | M |
Schedule Trips CS
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Schedule Trips CS | SCHED_TRIPS_CS | CSV.SCHEDULE_TRIPS_CS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Customer | O | ||||||
Schedule | M |
Scheduled and Cancelled Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Scheduled and Cancelled Orders | Schedule_Orders | CSV.SCHEDULE_ORDERS_VS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M | ||||||
Last Schedule | O | ||||||
Customer Group | O | ||||||
Customer | O | ||||||
Carrier Group | O |
Scheduled and Cancelled Orders v2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Scheduled and Cancelled Orders v2 | fn | CSV.SCHEDULE_ORDERS_VS_V2 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M | ||||||
Last Schedule | O | ||||||
Customer Group | O | ||||||
Customer | O | ||||||
Carrier Group | O |
Short Rail Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Short Rail Report | short_rail_rep | dp_csv_nr.short_rail_report |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Cost Centre | O | ||||||
Product Type | O | ||||||
Start Schedule | M | ||||||
End Schedule | M |
Slot Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Slot Extract | Slot_Extract | DP_CSV3.Slot_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Day | O | String | ALL | ||||
Slot Type | O | String | ALL | ||||
Location Type | O | String | ALL |
Store PVA
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Store PVA | STORE_PVA | DP_CSV_DUN.STORE_PVA |
Parameters:
|| ||Del |- |ivery Date ||M || || || || || || |}
Store Pre Warning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Store Pre Warning | Store_Pre_Warning | CSV.Store_Pre_Warning |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Show empty Slots | O | STRING | N | ||||
Depot | O | Depot | Location Id | Name | |||
Store | O | Store | Location Id | Name | |||
Sched Name | M |
Sub Contractor
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Sub Contractor | SUB_CONTRACTOR | DP_CSV_GEN.SUB_CONTRACTOR |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Sched | M | ||||||
Cost Centre | M | ||||||
From Sched | M |
Supplier DUs
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier DUs | SUPPLIER_DU_EXTRACT | DP_CSV_GEN.SUPPLIER_DU_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To | M | TODAY | |||||
From | M | TODAY |
Supplier DUs By Store
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier DUs By Store | SUPPLIER_DU_BY_STORE_EXTRACT | DP_CSV_GEN.DU_STORE_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Store | O | Store | Location ID | Name | |||
Order Status | O | ||||||
End Schedule | M | ||||||
Start Schedule | M |
Supplier Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier Invoice | Supplier_Invoice | DP_CSV5.SUPPLIER_INVOICE |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Date | O | ||||||
End Date | O | ||||||
Invoice ID | O | STRING | |||||
End Date | O | ||||||
Invoice ID | O | STRING | |||||
Start Date | O | ||||||
Start Schedule | M | ||||||
End Schedule | M |
Supplier Revenue
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier Revenue | SUPPLIER_REVENUE_EXTRACT | DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Revenue Start | M | TODAY | |||||
Revenue End | M | TODAY |
Supplier Revenue 2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier Revenue 2 | SUPPLIER_REVENUE_2_EXTRACT | DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2 |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Revenue Start | M | TODAY | |||||
Revenue End | M | TODAY |
TYRE SUMMARY EXTRACT
Note: Can be run from Trip Waterfall screen.
Report Name | Filename | Procedure for Scheduling |
---|---|---|
TYRE SUMMARY EXTRACT | TYRE_SUMMARY_EXTRACT | DP_CSV6.TYRE_SUMMARY_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Trip Actuals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip Actuals | TRIP_ACTUALS | CSV.TRIP_ACTUALS |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Trip Assessment Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip Assessment Extract | chk_trips | dp_csv_lfs.chk_trips |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Trip Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip Extract | Trip_Extract | CSV.Trip_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Carrier | O | ||||||
To Date | O | TODAY | |||||
From Date | O | TODAY |
Trip and Order Detail Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip and Order Detail Extract | Trip_Order_Detail_Extract | CSV.Trip_Order_Detail_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Carrier | O | ||||||
End Schedule | M | ||||||
Location Type | M | ALL | |||||
Start Schedule | M |
Trunking Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trunking Report | Trunking_Report | CSV.Trunking_Report |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Depot | M | Depot | Location Id | Name | |||
End Schedule | M | ||||||
Start Schedule | M | ||||||
Report Type | M | STRING | Revenue |
UNISON Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
UNISON Interface Results | UNSION_interface_results | CSV.UNISON_if_res |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Depot | O | Depot | Location Id | Name | |||
Customer | O | ||||||
To Date | O | TODAY | |||||
From Date | O | TODAY |
User Activity Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
User Activity Extract | User_Activity_Extract | CSV.User_Activity_Extract |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | M | TODAY | |||||
From Date | M | TODAY |
User Last Logon Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
User Last Logon Extract | USER_LAST_LOGON | CSV.user_logon_export |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Days since logon | M | STRING | 90 |
Variance Analysis Store Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Variance Analysis Store Detail | VAR_ANLYS_STORE_DTL | CSV.VARIANCE_ANALYSIS_STORE_DTL |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Variance Analysis Summary
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Variance Analysis Summary | VAR_ANLYSIS_SUM | CSV.VARIANCE_ANALYSIS_SUMMARY |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
To Date | M | TODAY | |||||
From Date | M | TODAY |
Variance Analysis Trip Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Variance Analysis Trip Detail | VAR_ANLYS_TRIP_DTL | CSV.VARIANCE_ANALYSIS_TRIP_DTL |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule | M |
Vehicle Utilisation
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Vehicle Utilisation | vehicle_util | dp_csv_nr.vehicle_utilisation |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Schedule | M | ||||||
End Schedule | M |
Vehicle Utilisation Heavy
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Vehicle Utilisation Heavy | hvy_vehicle_util | dp_csv_nr.heavy_vehicle_utilisation |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Carrier Code | O | ||||||
Carrier Group | O | ||||||
Cost Centre | O | ||||||
Customer Group | O | ||||||
End Schedule | M | ||||||
Start Schedule | M |
Vehicle Utilisation Non-Heavy
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Vehicle Utilisation Non-Heavy | vehicle_util | dp_csv_nr.vehicle_utilisation |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Carrier Group | O | ||||||
Customer Group | O | ||||||
Cost Centre | O | ||||||
End Schedule | M | ||||||
Start Schedule | M | ||||||
Carrier Code | O |
Volume Deviation Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Volume Deviation Extract | VOLUME_DEVIATION_EXTRACT | DP_CSV5.volume_deviation_report |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Carrier | O | ALL | |||||
To Date | M | TODAY | |||||
From Date | M | TODAY | |||||
Schedule | O | ||||||
Cost Centre | O | ALL | |||||
Trip Leg | O | STRING | ALL | ||||
Include Unpacked | O | STRING | Y | ||||
Deviation | O | STRING | ALL |
Volume or Activity
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Volume or Activity | VOLUME_ACTIVITY | DP_CSV6.VOLUME_ACTIVITY |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Schedule From | M | ||||||
Schedule To | M | ||||||
Route Code | O | ||||||
Customer | O | ||||||
Dealer | O | ||||||
Depot | O | ||||||
Media Type | O |
WCS Location Snapshot
Report Name | Filename | Procedure for Scheduling |
---|---|---|
WCS Location Snapshot | WCS_LOC_SANPSHOT | DP_CSV2.wcs_loc_snapshot |
Parameters:
WCS Order Items Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
WCS Order Items Extract | WCS_ORDER_ITEMS_EXTRACT | DP_CSV2.WCS_ORDER_ITEMS_EXTRACT |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Date | M | TODAY | |||||
To Date | M | TODAY | |||||
Order | O | STRING | |||||
Trip | O | STRING |
Weekly Transport Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Weekly Transport Report | Weekly_Transport | DP_CSV_BNL.Weekly_Transport |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
From Sched | M | ||||||
To Sched | M | ||||||
Carrier | ALL |
XML Order Interface Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
XML Order Interface Export | XML_Order_Interface | DP_CSV3.XML_ORDER_INTERFACE |
No Parameters