Extracts Details: Difference between revisions
(Updated parameters and extract names) |
(Updated parameters and extract names) |
||
Line 5,598: | Line 5,598: | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | |||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | |||
|- | |||
|To Date | |||
|P_END_DATE ||M || TODAY|| || || || || | |||
|- | |||
|POD | |||
|P_POD | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Carrier | |||
|I_FROM_LOC | |||
|O | |||
| | |||
| | |||
|Carrier | |||
|Carrier Name | |||
|Carrier ID | |||
| | |||
|- | |||
|Location From | |||
|P_FROM_LOC | |||
|O | |||
|STRING | |||
| | |||
|Location From | |||
|Location ID | |||
|Name | |||
| | |||
|- | |||
|From Date | |||
|P_START_DATE | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |||
==Order Charges Extract== | ==Order Charges Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 5,610: | Line 5,657: | ||
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 ||M ||TODAY || || || || || | |Date | ||
|P_DELIVERY_DATE ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 5,627: | Line 5,676: | ||
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 Sched | ||
|P_START_SCHED ||M || || || || || || | |||
|- | |- | ||
| | |End Sched | ||
|P_END_SCHED ||M || || || || || || | |||
|} | |} | ||
Line 5,646: | Line 5,698: | ||
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_to_date ||O || TODAY|| || || || || | |||
|- | |- | ||
| | |Customer | ||
|I_CUSTOMER ||O || || || || || || | |||
|- | |- | ||
|From Date ||O ||TODAY || || || || || | |From Date | ||
|i_from_date ||O ||TODAY || || || || || | |||
|- | |- | ||
|Depot ||O || || || || || || | |Depot | ||
|i_depot ||O || || || || || || | |||
|- | |- | ||
| | |||
|Message Type ||O || || || || || || | |Message Type ||O || || || || || || | ||
|} | |} | ||
Line 5,671: | Line 5,729: | ||
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 ||M || || || || || || | |||
|- | |- | ||
|End Schedule ||O || || || || || || | |End Schedule | ||
|P_END_SCHED ||O || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|P_CUSTOMER ||O || || || || || || | |||
|} | |} | ||
Line 5,692: | Line 5,754: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule | ||
|P_START_SCHED ||M || || || || || || | |||
|- | |- | ||
|End Schedule ||O || || || || || || | |End Schedule | ||
|P_END_SCHED ||O || || || || || || | |||
|- | |- | ||
|Show Neg Savings ||M || || || || || || | |Show Neg Savings | ||
|p_show_only_negative ||M || || || || || || | |||
|} | |} | ||
Line 5,713: | Line 5,779: | ||
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 | ||
|- | |- | ||
| | |Month | ||
|P_MONTH ||M || || || || || || | |||
|- | |- | ||
| | |Week Offset | ||
|P_WEEK_OFFSET ||O || || || || || || | |||
|- | |- | ||
| | |Year | ||
|P_YEAR ||M || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|P_CUSTOMER ||O || STRING|| OPENFIELD|| || || || | |||
|- | |- | ||
|Cost Centre ||O ||STRING || | |Cost Centre | ||
|P_COST_CENTRE ||O ||STRING ||EXEL || || || || | |||
|} | |} | ||
Line 5,738: | Line 5,810: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule | ||
|p_schedule ||M || || || || || || | |||
|} | |} | ||
Line 5,753: | Line 5,827: | ||
|DP_LOGIX.ORDER_EXPORT | |DP_LOGIX.ORDER_EXPORT | ||
|} | |} | ||
No parameters | |||
==Orders to Paragon== | ==Orders to Paragon== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 5,764: | Line 5,838: | ||
|CSV.Orders_to_Paragon | |CSV.Orders_to_Paragon | ||
|} | |} | ||
No parameters | |||
==Outbound Shortage== | ==Outbound Shortage== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 5,782: | Line 5,851: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Dealer | ||
|i_dealer ||O || STRING|| || || || || | |||
|- | |- | ||
|Schedule From ||M || || || || || || | |Schedule From | ||
|i_sched_from ||M || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Schedule To | ||
|i_sched_to ||M || || || || || || | |||
|- | |- | ||
| | |Depot | ||
|i_depot ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Route | ||
|i_route ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Media Type | ||
|i_media_type ||O ||STRING || || || || || | |||
|} | |} | ||
Line 5,811: | Line 5,888: | ||
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_cust ||M || || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|i_from_date ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |End Date | ||
|i_to_date ||M || TODAY|| || || || || | |||
|} | |} | ||
Line 5,830: | Line 5,911: | ||
|CSV.POC_to_Sap_Extract | |CSV.POC_to_Sap_Extract | ||
|} | |} | ||
No parameters | |||
==POC to SAP Extract(A)== | ==POC to SAP Extract(A)== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 5,848: | Line 5,924: | ||
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 | ||
|- | |- | ||
|Resend All? ||M ||STRING ||No || || || || | |Resend All? | ||
|p_resend_flag ||M ||STRING ||No || || || || | |||
|} | |} | ||
Line 5,864: | Line 5,942: | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | |||
!Title | |||
!Name | |||
!Mand | |||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |||
|To Date | |||
|P_END_DATETIME | |||
|M | |||
|YESTERDAY | |||
|YESTERDAY | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Date From | |||
|P_START_DATETIME | |||
|M | |||
|TODAY | |||
|YESTERDAY:20:00 | |||
| | |||
| | |||
| | |||
| | |||
|} | |||
==POD Delivery Extract== | ==POD Delivery Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 5,876: | Line 5,986: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Customer Group | ||
|p_group_name ||O || STRING|| ALL|| || || || | |||
|- | |- | ||
| | |Scanning Depot | ||
|p_scan_depot ||O || STRING|| ALL|| Depot|| Location Id|| Name|| | |||
|- | |- | ||
| | |> Days Outstanding | ||
|p_outstanding ||O ||STRING ||0 || || || || | |||
|- | |- | ||
|POD Status ||O ||STRING ||ALL || || || || | |POD Status | ||
|p_pod ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
|Carrier ||O ||STRING ||ALL || || || || | |Carrier | ||
|p_carrier ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
| | |To Schedule | ||
|p_to_date ||M || || || || || || | |||
|- | |- | ||
| | |From Schedule | ||
|p_from_date ||M || || || || || || | |||
|- | |- | ||
|Customer ||O ||STRING ||ALL || || || || | |Customer | ||
|p_customer ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
| | |Del Msg Sent | ||
|p_del_msg_sent ||O ||STRING ||ALL || || || || | |||
|} | |} | ||
Line 5,909: | Line 6,029: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|POD Flow ||M || || || || || || | |POD Flow | ||
|P_FLOW ||M || || || || || || | |||
|- | |- | ||
| | |Schedule | ||
|P_SCHED ||O || || || || || || | |||
|- | |- | ||
|Date From ||M ||TODAY || || || || || | |Date From | ||
|P_DATE_FROM ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Date To | ||
|P_DATE_TO ||M || TODAY|| || || || || | |||
|} | |} | ||
Line 5,930: | Line 6,055: | ||
|CSV.POD_to_Sap_Extract | |CSV.POD_to_Sap_Extract | ||
|} | |} | ||
No parameters | |||
==POD to SAP Extract(A)== | ==POD to SAP Extract(A)== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 5,948: | Line 6,068: | ||
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 | ||
|- | |- | ||
|Resend All? ||M ||STRING ||No || || || || | |Resend All? | ||
|p_resend_flag ||M ||STRING ||No || || || || | |||
|} | |} | ||
Line 5,965: | Line 6,087: | ||
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 | ||
|- | |- | ||
| | |Sub Credit Account | ||
|p_sub_credit_acc ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
| | |Trip ID | ||
|p_trip ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
| | |Export ID | ||
|p_export ||O ||STRING ||0 || || || || | |||
|- | |- | ||
| | |Customer | ||
|p_customer ||M ||STRING ||PORSCHE19 || || || || | |||
|- | |- | ||
| | |Sub Debit Account | ||
|p_sub_debit_acc ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
| | |Invoice ID | ||
|p_invoice ||O ||STRING ||0 || || || || | |||
|} | |} | ||
Line 5,991: | Line 6,120: | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | |||
!Title | |||
!Name | |||
!Mand | |||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |||
|Owning Depot | |||
|P_OWNING_DEPOT | |||
|O | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |From Schedule | ||
|P_START_SCHED | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |- | ||
| | |To Schedule | ||
|P_END_SCHED | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
==Parts and | ==Parts and Empties== | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Report Name''' | !'''Report Name''' | ||
Line 6,011: | Line 6,174: | ||
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 | ||
|P_SCHED_FROM ||M || || || || || || | |||
|- | |- | ||
|Schedule | |Schedule To | ||
|P_SCHED_TO ||M || || || || || || | |||
|- | |- | ||
| | |Location From | ||
|P_LOCATION ||O || || || || || || | |||
|- | |- | ||
| | |Export Type | ||
|P_EXPORT_TYPE ||M || || || || || || | |||
|- | |- | ||
|Customer ||M || || || || || || | |Customer | ||
|P_CUSTOMER ||M || || || || || || | |||
|} | |} | ||
Line 6,034: | Line 6,203: | ||
|dp_csv3.postcode_matrix | |dp_csv3.postcode_matrix | ||
|} | |} | ||
No parameters | |||
==Pre Invoice Check== | ==Pre Invoice Check== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 6,052: | Line 6,216: | ||
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 | ||
|- | |- | ||
|Cut-off Date ||M ||TODAY || || || || || | |Cut-off Date | ||
|i_cutoff_date ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 6,068: | Line 6,234: | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | |||
!Title | |||
!Name | |||
!Mand | |||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |||
|Record Status | |||
|i_record_status | |||
|M | |||
|STRING | |||
|ALL | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|End Date | |||
|i_end_datetime | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Start Date | |||
|i_start_datetime | |||
|M | |||
|TODAY | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
|Incl. Reprocessed | |||
|i_incl_reprocessed | |||
|M | |||
|STRING | |||
|N | |||
| | |||
| | |||
| | |||
| | |||
|} | |||
==Process Items Interface Audit== | ==Process Items Interface Audit== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 6,080: | Line 6,298: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Incl. Reprocessed ||M ||STRING ||N || || || || | |Incl. Reprocessed | ||
|i_incl_reprocessed ||M ||STRING ||N || || || || | |||
|- | |- | ||
| | |Record Status | ||
|i_record_status ||M ||STRING || ALL|| || || || | |||
|- | |- | ||
|End Date ||M ||TODAY || || || || || | |End Date | ||
|i_end_datetime ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Start Date | ||
|i_start_datetime ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 6,103: | Line 6,326: | ||
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 | ||
|P_START_DATETIME ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |To Date | ||
|P_END_DATETIME ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 6,122: | Line 6,348: | ||
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 ||O ||TODAY ||TODAY || || || || | |||
|- | |- | ||
| | |From Date | ||
|i_start_date ||O ||TODAY ||TODAY || || || || | |||
|- | |- | ||
| | |Status | ||
|i_status_id ||O ||STRING ||All || || || || | |||
|} | |} | ||
Line 6,143: | Line 6,373: | ||
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 | |Date To | ||
|p_end_datetime ||M ||TODAY ||TODAY:00:01 || || || || | |||
|- | |- | ||
|Depot ||M || || || || || || | |Depot | ||
|p_depot ||M || || || || || || | |||
|- | |- | ||
|Date | |Date From | ||
|p_start_datetime ||M ||TODAY ||TODAY:23:59 || || || || | |||
|} | |} | ||
Line 6,164: | Line 6,398: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Depot | ||
|i_depot ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Dealer | ||
|i_dealer ||O ||STRING || || || || || | |||
|- | |- | ||
|Media Type ||O ||STRING || || || || || | |Media Type | ||
|i_media_type ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Route | ||
|i_route ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O ||STRING || || || || || | |||
|- | |- | ||
|Date | |Date To | ||
|i_date_to ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Date From | ||
|i_date_from ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 6,193: | Line 6,435: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule | ||
|P_SCHED_DATE ||M || || || || || || | |||
|} | |} | ||
Line 6,210: | Line 6,454: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|i_Start_Date_Time ||M ||TODAY || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|i_End_Date_Time ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |- | ||
|Cust Group ||O || || || || || || | |Cust Group | ||
|i_cust_group ||O || || || || || || | |||
|- | |- | ||
| | |Cost Centre | ||
|i_cost_centre ||O || || || || || || | |||
|} | |} | ||
Line 6,235: | Line 6,485: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|I_DATE_FROM ||M ||TODAY || || || || || | |||
|- | |- | ||
|Cost Centre ||M ||STRING ||ALL || || || || | |Cost Centre | ||
|I_COST_CENTRE ||M ||STRING ||ALL || || || || | |||
|} | |} | ||
Line 6,254: | Line 6,507: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Order Status | ||
|I_ORDER_STATUS ||O || || || || || || | |||
|- | |- | ||
|End Trip Schedule ||M || || || || || || | |End Trip Schedule | ||
|I_END_SCHED ||M || || || || || || | |||
|- | |- | ||
| | |Location Type | ||
|I_LOC_TYPE ||O || || || || || || | |||
|- | |- | ||
| | |Start Trip Schedule | ||
|I_START_SCHED ||M || || || || || || | |||
|- | |- | ||
| | |Carrier | ||
|I_CARRIER_ID ||O || || || || || || | |||
|} | |} | ||
Line 6,279: | Line 6,538: | ||
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 Group | ||
|i_CUST_GROUP ||O || || || || || || | |||
|- | |- | ||
| | |Last Schedule | ||
|i_sched_to ||O || || || || || || | |||
|- | |- | ||
| | |Schedule | ||
|i_Sched ||M || || || || || || | |||
|- | |- | ||
| | |Carrier Group | ||
|i_carr_group ||O || || || || || || | |||
|} | |} | ||
Line 6,304: | Line 6,569: | ||
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 | ||
|- | |- | ||
| | |Credit Acc | ||
|I_CREDIT_ACC ||O || || || || || || | |||
|- | |- | ||
| | |Saving (> or <) | ||
|I_SAVING ||O || STRING|| || || || || | |||
|- | |- | ||
| | |Lane Id | ||
|I_LANE_ID ||O || || || || || || | |||
|- | |- | ||
| | |Customer Group | ||
|I_CUST_GROUP ||O || || || || || || | |||
|- | |- | ||
| | |To Cty Code | ||
|I_TO_CTY ||O || || || || || || | |||
|- | |- | ||
| | |From Cty Code | ||
|I_FROM_CTY ||O || || || || || || | |||
|- | |- | ||
|From Date ||O ||TODAY || || || || || | |From Date | ||
|I_FROM_DATE ||O ||TODAY || || || || || | |||
|- | |- | ||
| | |To Date | ||
|I_TO_DATE ||O || TODAY|| || || || || | |||
|- | |- | ||
| | |Debit Acc | ||
|I_DEBIT_ACC ||O || || || || || || | |||
|} | |} | ||
Line 6,337: | Line 6,612: | ||
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 | ||
|P_END_DATETIME ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |From Date | ||
|P_START_DATETIME ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 6,356: | Line 6,634: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule | ||
|P_START_SCHED ||M || || || || || || | |||
|- | |- | ||
|End Schedule ||M || || || || || || | |End Schedule | ||
|P_END_SCHED ||M || || || || || || | |||
|} | |} | ||
Line 6,375: | Line 6,656: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Customer ||O || || || || || || | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |- | ||
|Schedule | |Schedule | ||
|i_Sched | |||
|M | |M | ||
| | | | ||
Line 6,401: | Line 6,685: | ||
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 || || || || || || | |||
|- | |- | ||
| | |Carrier Group | ||
|i_carr_group ||O || || || || || || | |||
|- | |- | ||
| | |Last Schedule | ||
|i_sched_to ||O || || || || || || | |||
|- | |- | ||
| | |Schedule | ||
|i_Sched ||M || || || || || || | |||
|- | |- | ||
| | |Customer Group | ||
|i_CUST_GROUP ||O || || || || || || | |||
|} | |} | ||
Line 6,426: | Line 6,716: | ||
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 || || || || || || | |||
|- | |- | ||
| | |Carrier Group | ||
|i_carr_group ||O || || || || || || | |||
|- | |- | ||
| | |Last Schedule | ||
|i_sched_to ||O || || || || || || | |||
|- | |- | ||
| | |Schedule | ||
|i_Sched ||M || || || || || || | |||
|- | |- | ||
| | |Customer Group | ||
|i_CUST_GROUP ||O || || || || || || | |||
|} | |} | ||
Line 6,451: | Line 6,747: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Cost Centre ||O || || || || || || | |Cost Centre | ||
|i_cost_centre ||O || || || || || || | |||
|- | |- | ||
|Product Type ||O || || || || || || | |Product Type | ||
|i_product_type ||O || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|i_Sched_To ||M || || || || || || | |||
|- | |- | ||
| | |Start Schedule | ||
|i_Sched_From ||M || || || || || || | |||
|} | |} | ||
Line 6,474: | Line 6,775: | ||
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 | ||
|- | |- | ||
| | |Location Type | ||
|I_LOC_TYPE ||O ||String ||ALL || || || || | |||
|- | |- | ||
| | |Day | ||
|I_DAY ||O ||String ||ALL || || || || | |||
|- | |- | ||
| | |Slot Type | ||
|I_SLOT_TYPE ||O ||String ||ALL || || || || | |||
|} | |} | ||
Line 6,494: | Line 6,799: | ||
|} | |} | ||
Parameters: | Parameters: | ||
{| class="wikitable" | |||
!Title | |||
!Name | |||
!Mand | |||
!Def Type | |||
!Def Val | |||
!LOV | |||
!Column 1 | |||
!Column 2 | |||
!Column 3 | |||
|- | |- | ||
| | |Delivery Date | ||
|P_DEL_DATE | |||
|M | |||
| | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Line 6,512: | Line 6,833: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |Depot | ||
|i_Depot ||O || || || Depot|| Location Id|| Name|| | |||
|- | |- | ||
| | |Store | ||
|i_store ||O || || ||Store ||Location Id ||Name || | |||
|- | |- | ||
| | |Sched Name | ||
|i_sched_name ||M || || || || || || | |||
|- | |- | ||
| | |Show empty Slots | ||
|i_show_empty_slots ||O || STRING|| N|| || || || | |||
|} | |} | ||
Line 6,535: | Line 6,861: | ||
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_CC ||M || || || || || || | |||
|- | |- | ||
| | |To Sched | ||
|P_END_SCHED ||M || || || || || || | |||
|- | |- | ||
|From Sched ||M || || || || || || | |From Sched | ||
|P_START_SCHED ||M || || || || || || | |||
|} | |} | ||
Line 6,556: | Line 6,886: | ||
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 | ||
|P_FROM ||M || ||TODAY || || || || | |||
|- | |- | ||
| | |To | ||
|P_TO ||M || ||TODAY || || || || | |||
|} | |} | ||
Line 6,575: | Line 6,908: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
! | |||
|- | |- | ||
|Store || | |Supplier DUs By Store | ||
|Start Schedule ||P_START_SCHED || M|| || || || || | |||
| | |||
|- | |- | ||
| | |Supplier DUs By Store | ||
|End Schedule ||P_END_SCHED || M|| || || || || | |||
| | |||
|- | |- | ||
| | |Supplier DUs By Store | ||
|Store ||P_STORE || O|| || || Store|| Location ID||Name | |||
| | |||
|- | |- | ||
| | |Supplier DUs By Store | ||
|Order Status ||P_STATUS || O|| || || || || | |||
| | |||
|} | |} | ||
Line 6,598: | Line 6,941: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
| | |End Date | ||
| | |P_END_DATE ||O || || || || || || | ||
|- | |- | ||
| | |Start Date | ||
|P_START_DATE ||O || || || || || || | |||
|- | |- | ||
|Invoice ID | |||
|P_INVOICE_ID ||O ||STRING || || || || || | |||
|Invoice ID | |||
| | |||
|} | |} | ||
Line 6,629: | Line 6,966: | ||
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 ||M || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|P_END_SCHED ||M || || || || || || | |||
|} | |} | ||
Line 6,648: | Line 6,988: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Revenue | |Revenue End | ||
|P_REVENUE_END ||M || ||TODAY || || || || | |||
|- | |- | ||
|Revenue | |Revenue Start | ||
|P_REVENUE_START ||M || ||TODAY || || || || | |||
|} | |} | ||
Line 6,668: | Line 7,011: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule | ||
|i_sched_name ||M || || || || || || | |||
|} | |} | ||
Line 6,685: | Line 7,030: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule | ||
|i_schedule ||M || || || || || || | |||
|} | |} | ||
Line 6,702: | Line 7,049: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule | ||
|i_sched ||M || || || || || || | |||
|} | |} | ||
Line 6,719: | Line 7,068: | ||
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 ||O ||TODAY || || || || || | |To Date | ||
|i_to_date ||O ||TODAY || || || || || | |||
|- | |- | ||
| | |Carrier | ||
|i_carrier ||O || || || || || || | |||
|} | |} | ||
Line 6,740: | Line 7,093: | ||
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 ||M || || || || || || | |||
|- | |- | ||
| | |Location Type | ||
|i_loc_type ||M || || ALL|| || || || | |||
|- | |- | ||
| | |Carrier | ||
|i_carrier_id ||O || || || || || || | |||
|- | |- | ||
| | |End Schedule | ||
|P_END_SCHED ||M || || || || || || | |||
|} | |} | ||
Line 6,763: | Line 7,121: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Depot ||M || || ||Depot ||Location Id ||Name || | |Depot | ||
|p_Depot ||M || || ||Depot ||Location Id ||Name || | |||
|- | |- | ||
|End Schedule ||M || || || || || || | |End Schedule | ||
|P_END_SCHED ||M || || || || || || | |||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule | ||
|P_START_SCHED ||M || || || || || || | |||
|- | |- | ||
|Report Type ||M ||STRING ||Revenue || || || || | |Report Type | ||
|p_report_type ||M ||STRING ||Revenue || || || || | |||
|} | |} | ||
Line 6,786: | Line 7,149: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Depot ||O || || ||Depot ||Location Id ||Name || | |Depot | ||
|i_depot ||O || || ||Depot ||Location Id ||Name || | |||
|- | |- | ||
|Customer ||O || || || || || || | |Customer | ||
|I_CUSTOMER ||O || || || || || || | |||
|- | |- | ||
|To Date ||O ||TODAY || || || || || | |To Date | ||
|i_to_date ||O ||TODAY || || || || || | |||
|- | |- | ||
|From Date ||O ||TODAY || || || || || | |From Date | ||
|i_from_date ||O ||TODAY || || || || || | |||
|} | |} | ||
Line 6,809: | Line 7,177: | ||
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 || || || || || | |To Date | ||
|i_End_Date_Time ||M ||TODAY || || || || || | |||
|- | |- | ||
|From Date ||M ||TODAY || || || || || | |From Date | ||
|i_Start_Date_Time ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 6,828: | Line 7,199: | ||
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 | ||
|- | |- | ||
|Days since logon ||M ||STRING ||90 || || || || | |Days since logon | ||
|I_NO_DAYS ||M ||STRING ||90 || || || || | |||
|} | |} | ||
Line 6,845: | Line 7,218: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule | ||
|i_Schedule ||M || || || || || || | |||
|} | |} | ||
Line 6,862: | Line 7,237: | ||
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 || || || || || | |||
|- | |- | ||
| | |To Date | ||
|i_End_Date_Time ||M ||TODAY || || || || || | |||
|} | |} | ||
Line 6,881: | Line 7,259: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule ||M || || || || || || | |Schedule | ||
|i_Schedule ||M || || || || || || | |||
|} | |} | ||
Line 6,917: | Line 7,297: | ||
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 | ||
|i_Sched_To ||M || || || || || || | |||
|- | |- | ||
|Carrier | |Carrier Code | ||
|i_carrier_code ||O || || || || || || | |||
|- | |- | ||
| | |Carrier Group | ||
|i_carrier_group ||O || || || || || || | |||
|- | |- | ||
|Customer Group ||O || || || || || || | |Customer Group | ||
|i_cust_group ||O || || || || || || | |||
|- | |- | ||
| | |Cost Centre | ||
|i_cost_centre ||O || || || || || || | |||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule | ||
|i_Sched_From ||M || || || || || || | |||
|} | |} | ||
Line 6,944: | Line 7,331: | ||
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 | ||
|i_Sched_To ||M || || || || || || | |||
|- | |- | ||
|Customer Group ||O || || || || || || | |Customer Group | ||
|i_cust_group ||O || || || || || || | |||
|- | |- | ||
| | |Carrier Group | ||
|i_carrier_group ||O || || || || || || | |||
|- | |- | ||
| | |Carrier Code | ||
|i_carrier_code ||O || || || || || || | |||
|- | |- | ||
|Start Schedule ||M || || || || || || | |Start Schedule | ||
|i_Sched_From ||M || || || || || || | |||
|- | |- | ||
| | |Cost Centre | ||
|i_cost_centre ||O || || || || || || | |||
|} | |} | ||
Line 6,971: | Line 7,365: | ||
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_date_to ||M || TODAY|| || || || || | |||
|- | |- | ||
| | |Carrier | ||
|i_carrier ||O || || ALL|| || || || | |||
|- | |- | ||
| | |Trip Leg | ||
|i_trip_leg ||O ||STRING || ALL|| || || || | |||
|- | |- | ||
|Schedule ||O || || || || || || | |Schedule | ||
|i_Sched_name ||O || || || || || || | |||
|- | |- | ||
| | |From Date | ||
|i_date_from ||M || TODAY|| || || || || | |||
|- | |- | ||
| | |Deviation | ||
|i_deviation ||O ||STRING ||ALL || || || || | |||
|- | |- | ||
| | |Cost Centre | ||
|I_COST_CENTRE ||O || ||ALL || || || || | |||
|- | |- | ||
| | |Include Unpacked | ||
|i_inc_unpacked ||O ||STRING ||Y || || || || | |||
|} | |} | ||
Line 7,002: | Line 7,405: | ||
Parameters: | Parameters: | ||
{| class="wikitable" | {| class="wikitable" | ||
!Title | |||
!Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | !Name !! Mand !! Def Type !! Def Val !! LOV !! Column 1 !! Column 2 !! Column 3 | ||
|- | |- | ||
|Schedule From ||M || || || || || || | |Schedule From | ||
|i_sched_from ||M || || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |- | ||
| | |Media Type | ||
|i_media ||O || || || || || || | |||
|- | |- | ||
| | |Schedule To | ||
|i_sched_to ||M || || || || || || | |||
|- | |- | ||
|Dealer ||O || || || || || || | |Dealer | ||
|i_dealer ||O || || || || || || | |||
|- | |- | ||
|Depot ||O || || || || || || | |Depot | ||
|i_depot ||O || || || || || || | |||
|- | |- | ||
| | |Route Code | ||
|i_route ||O || || || || || || | |||
|} | |} | ||
Line 7,029: | Line 7,440: | ||
|DP_CSV2.wcs_loc_snapshot | |DP_CSV2.wcs_loc_snapshot | ||
|} | |} | ||
No parameters. | |||
==WCS Order Items Extract== | ==WCS Order Items Extract== | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 7,042: | Line 7,453: | ||
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 ||M ||TODAY || || || || || | |||
|- | |- | ||
| | |Trip | ||
|i_trip ||O ||STRING || || || || || | |||
|- | |- | ||
| | |Customer | ||
|i_customer ||O || || || || || || | |||
|- | |||
|From Date | |||
|i_start_date ||M ||TODAY || || || || || | |||
|- | |||
|Crossdock Depot | |||
|i_depot | |||
|O | |||
| | |||
| | |||
|Crossdock Depot | |||
|Location Id | |||
|Name | |||
| | |||
|- | |- | ||
| | |Order | ||
|i_order | |||
|O | |||
|STRING | |||
| | |||
| | |||
| | |||
| | |||
| | |||
|} | |} | ||
Line 7,065: | Line 7,501: | ||
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 | ||
! | |||
|- | |- | ||
| | |Weekly Transport Report | ||
|To Sched ||i_sched_to || M|| || || || || | |||
| | |||
|- | |- | ||
| | |Weekly Transport Report | ||
|From Sched ||i_sched_from || M|| || || || || | |||
| | |||
|- | |- | ||
|Carrier || | |Weekly Transport Report | ||
|Carrier ||i_carrier || || || ALL|| || | |||
| | |||
| | |||
|} | |} | ||
Latest revision as of 12:37, 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 |
CTM Trips Not Responded To
Report Name | Filename | Procedure for Scheduling |
---|---|---|
CTM Trips Not Responded To | CTM_TRIPS_NO_RESPONSE | CSV.CTM_TRIPS_NO_RESPONSE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | P_END_SCHED | O | ||||||
Start Schedule | P_START_SCHED | O | ||||||
Carrier | P_HAULIER | O |
Call Collection OTIF Day
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Collection OTIF Day | coll_OTIF_date_window | dp_csv_nr.coll_otif_date_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Carrier | i_carrier | O | ||||||
End Schedule | i_Sched_To | O | ||||||
From Date | i_Start_Date_Time | M | TODAY | |||||
To Date | i_End_Date_Time | M | TODAY | |||||
Start Schedule | i_Sched_From | O | ||||||
Product Type | i_product_type | O | ||||||
Customer Group | i_cust_group | O | ||||||
Customer | i_customer | O |
Call Collection OTIF Time Window
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Collection OTIF Time Window | coll_OTIF_window | dp_csv_nr.coll_otif_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_End_Date_Time | M | TODAY | |||||
Start Schedule | i_Sched_From | O | ||||||
End Schedule | i_Sched_To | O | ||||||
Product Type | i_product_type | O | ||||||
Customer Group | i_cust_group | O | ||||||
Customer | i_customer | O | ||||||
Carrier | i_carrier | O | ||||||
From Date | i_Start_Date_Time | M | TODAY |
Call Delivery OTIF Day
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Delivery OTIF Day | del_OTIF_date_window | dp_csv_nr.del_otif_date_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Carrier | i_carrier | O | ||||||
Customer | i_customer | O | ||||||
Customer Group | i_cust_group | O | ||||||
Product Type | i_product_type | O | ||||||
End Schedule | i_Sched_To | O | ||||||
Start Schedule | i_Sched_From | O | ||||||
From Date | i_Start_Date_Time | M | TODAY | |||||
To Date | i_End_Date_Time | M | TODAY |
Call Delivery OTIF Time Window
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Call Delivery OTIF Time Window | del_OTIF_window | dp_csv_nr.del_otif_window |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | O | ||||||
Carrier | i_carrier | O | ||||||
Customer Group | i_cust_group | O | ||||||
Product Type | i_product_type | O | ||||||
End Schedule | i_Sched_To | O | ||||||
Start Schedule | i_Sched_From | O | ||||||
To Date | i_End_Date_Time | M | TODAY | |||||
From Date | i_Start_Date_Time | M | TODAY |
Campus KPI Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Campus KPI Extract | Campus_KPI_Extract | KPI.KPI_CAMPUS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_date_from | M | TODAY | |||||
Carrier | i_carrier | O | ALL | |||||
Cost Centre | i_cost_centre | O | ALL | |||||
Date Range Type | i_date_type | M | String | |||||
Depot | i_depot | O | ALL | Location Id | Name | |||
To Date | i_date_to | M | TODAY | |||||
Client | i_client | O | ALL |
Carrier DUs Shipped
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier DUs Shipped | CARRIER_DUS_SHIPPED | DP_CSV5.CARRIER_DUS_SHIPPED |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | I_DATE_FROM | M | TODAY | |||||
Carrier | P_CARRIER | O | STRING | ALL | ||||
To Date | I_DATE_TO | M | TODAY |
Carrier Delivery Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier Delivery Report | Carrier_Delivery_Report | DP_CSV5.CARRIER_DELIVERY |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Sched Name | P_SCHED_NAME | M | ||||||
Trip ID | P_TRIP | O | STRING | ALL | ||||
Carrier | P_CARRIER | M | ||||||
Depot | P_DEPOT | M |
Carrier Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier Invoice | Carrier_Invoice | CSV.CARRIER_INVOICE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Invoice No | I_INVOICE_NO | M | ||||||
Credit Acc | I_CREDIT_ACC | M | ||||||
Debit Acc | I_DEBIT_ACC | M |
Carrier Self Billing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Carrier Self Billing | Carrier_Self_billing | DP_CSV_BNL.CARRIER_SELF_BILLING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | i_start_sched | M | ||||||
Carrier | i_carrier | 0 | ||||||
End Schedule | i_end_sched | M |
Catalyst Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Catalyst Extract | CATALYST_EXTRACT | CSV.CATALYST_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | P_END_SCHED | M | ||||||
Start Schedule | P_START_SCHED | M |
Co-ordinate Non-Conformities
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Co-ordinate Non-Conformities | Co_Ord_Non_Conf | DP_CSV6.CO_ORD_NON_CONFORM |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | i_sched_from | M | ||||||
End Schedule | i_sched_to | M | ||||||
Driver | i_driver | O | ||||||
TomTom,Epod,Both | i_inc | M | B | |||||
Discrepancy Dist | i_disc_dist | 0 | 1 | |||||
Depot | i_depot | O |
Commercial
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Commercial | COMMERCIAL | CSV.Commercial_Orders |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | I_SCHEDULE | M |
Compliance Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Compliance Report | COMPLIANCE_REPORT | DP_CSV_DUN.COMPLIANCE_REPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Collection Date | P_COL_DATE | M |
Concurrent Logon Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Concurrent Logon Export | Concurrent_Logon_Export | CSV.Concurrent_Logon |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_from_date | O | TODAY | |||||
To Date | i_to_date | O | TODAY |
Contracts
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Contracts | CONTRACTS | CSV.CONTRACTS |
No Parameters
Cross Dock
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Cross Dock | CROSS_DOCK | DP_CSV6.CROSS_DOCK |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule From | i_sched_from | M | ||||||
Schedule To | i_sched_to | M | ||||||
Customer | i_customer | O | STRING | |||||
Media Type | i_media_type | O | STRING | |||||
Depot | i_depot | O | STRING | |||||
Route | i_route | O | STRING | |||||
Dealer | i_dealer | O | STRING |
Customer Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Customer Invoice | Customer_Invoice | CSV.Customer_Invoice |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Invoice No | I_INVOICE_NO | M | ||||||
Credit Acc | I_CREDIT_ACC | M | ||||||
Debit Acc | I_DEBIT_ACC | M |
Customer Invoice By Dates
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Customer Invoice By Dates | Customer_Invoice_By_Dates | CSV.Customer_Invoice_By_Dates |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Payment Status | i_act_or_prov | O | ||||||
From Date | I_START_DATETIME | M | ||||||
To Date | I_END_DATETIME | M | ||||||
Customer | I_CUSTOMER | M |
Customer Invoice Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Customer Invoice Extract | Customer_Invoice | CSV.Customer_Invoice |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Debit Acc | I_DEBIT_ACC | M | ||||||
Invoice No | I_INVOICE_NO | M | ||||||
Credit Acc | I_CREDIT_ACC | M |
Cut Offs Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Cut Offs Extract | Cut_offs_extract | DP_CSV6.CUT_OFF_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_end_sched | M | ||||||
Customer | i_customer | 0 | ||||||
Start Schedule | i_start_sched | M |
D365 Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
D365 Extract | DP_FINANCE.D365_EXPORT | D365_EXPORT_ |
No parameters.
DELIVERY_OVERVIEW
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DELIVERY_OVERVIEW | DELIVERY_OVERVIEW | dp_csv3.delivery_overview |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
POD Confirmed | P_POD | O | ||||||
Owning Depot | P_OWNING_DEPOT | O | ||||||
To Schedule | P_END_SCHED | M | ||||||
From Schedule | P_START_SCHED | M |
DOOD Rpt
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DOOD Rpt | DOOD_RPT | dp_csv_dood.dood_rpt |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule To | I_SCHED_TO | M | ||||||
Schedule From | I_SCHED_FROM | M | ||||||
Customer | I_CUSTOMER | O | STRING | OPENFIELD |
DUs Despatched
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DUs Despatched | DUS_DESPATCHED_EXTRACT | DP_CSV_GEN.DUS_DESPATCHED_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Sched | p_start_sched | O | ||||||
PO Number | p_external | O | STRING | |||||
Consignment Num | p_oms | O | STRING | |||||
End Sched | p_end_sched | O | ||||||
Manifest | p_manifest | O | STRING | |||||
Supplier | p_customer | O |
DUs Not Loaded
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DUs Not Loaded | DUS_NOT_LOADED_EXTRACT | DP_CSV_GEN.DUS_NOT_LOADED_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | p_sched_date | M | ||||||
Store | p_store | O | Store | Location ID | Name |
DUs Not Received
Report Name | Filename | Procedure for Scheduling |
---|---|---|
DUs Not Received | DUS_NOT_RECEIVED_EXTRACT | DP_CSV_GEN.DAILY_EXT_NOT_RECD |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_avail_to | M | ||||||
From Date | i_avail_from | M |
Daily Manifest E-OT-L
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Manifest E-OT-L | DAILY_MANIFEST_E_OT_L_EXTRACT | DP_CSV_GEN.DAILY_EXT_MANIFEST |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_avail_to | M | ||||||
From Date | i_avail_from | M |
Daily Receiving E-OT-L
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Receiving E-OT-L | RECEIVING_E_OT_L_EXTRACT | DP_CSV_GEN.DAILY_EXT_RECEIPTING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_sched_to | M | ||||||
Start Schedule | i_sched_from | M |
Daily Transport Plan
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Transport Plan | DAILY_TRANSPORT_PLAN_EXTRACT | DP_CSV_GEN.DAILY_TRANSPORT_PLAN |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_avail_from | M | ||||||
Supplier | i_supplier | M | STRING | ALL | ||||
To Date | i_avail_to | M | ||||||
Order Status | i_ord_status | M | STRING | ALL |
Daily Unscheduled Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Daily Unscheduled Orders | DAILY_UNSCHEDULED_ORDERS_EXTRACT | DP_CSV_GEN.DAILY_UNSCHED_ORD |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_avail_from | M | ||||||
To Date | i_avail_to | M |
Debrief Performance
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Debrief Performance | debrief_performance | dp_csv_nr.debrief_performance |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cust Group | i_cust_group | O | ||||||
Customer | i_customer | O | ||||||
Carrier Group | i_carrier_group | O | ||||||
Cost Centre | i_cost_centre | O | ||||||
From Date | i_Start_Date_Time | M | TODAY | |||||
Carrier Code | i_carrier_code | O | ||||||
From Date | i_End_Date_Time | M | TODAY |
Del Scans
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Del Scans | DEL_SCANS | DP_CSV6.DEL_SCANS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_end_sched | M | ||||||
Start Schedule | i_start_sched | M |
Delivery Conf
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Delivery Conf | BGYP_DELCONF_ | DP_CSV5.DELIVERY_CONF |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Owning Depot | p_own | O | ||||||
Cost Centre | p_cost | M | ||||||
To Actual date | p_to_date | M | TODAY | |||||
Type | p_type | M | M | |||||
From Actual date | p_from_date | M | TODAY |
Delivery Schedule Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Delivery Schedule Extract | Delivery_Schedule | DP_CSV_DHL.DELIVERY_SCHEDULE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Show Dates | P_DATE_SELECT | Y |
Depot Exits by Hour (Loads)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Depot Exits by Hour (Loads) | DEPOT_EXITS_LOADS | CSV.DEPOT_EXITS_BY_HOUR_LOADS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_End_Date_Time | M | TODAY | |||||
Depot | i_Depot_Loc_Id | M | Depot | Location Id | Name | |||
From Date | i_Start_Date_Time | M | TODAY |
Depot Exits by Hour (RPEs)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Depot Exits by Hour (RPEs) | DEPOT_EXITS_RPE | CSV.DEPOT_EXITS_BY_HOUR_RPE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | i_Depot_Loc_ID | M | Depot | Location Id | Name | |||
From Date | i_Start_Date_Time | M | TODAY | |||||
To Date | i_End_Date_Time | M | TODAY |
Detailed Interface Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Detailed Interface Report | Detailed_Interface_Report | CSV.Detailed_Interface_Report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer Group | i_group_name | O | ||||||
Customer | i_customer | O | ||||||
Status | i_status | M | STRING | All | ||||
To Date | i_to_date | O | TODAY | |||||
From Date | i_from_date | O | TODAY |
Dixons Catalyst Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dixons Catalyst Report | fn | CSV.Dixons_Catalyst_Report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | M | ||||||
Depot | i_Depot | O | Depot | Location Id | Name | |||
Carrier | P_HAULIER | O |
Dixons Order Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dixons Order Export | Dixons_Order_Export | CSV.Dixons_Order_Export |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_from_date | O | TODAY | |||||
To Date | i_to_date | O | TODAY | |||||
Carrier | i_carrier | O |
Dixons Trip Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dixons Trip Extract | Dixons_Trip_Extract | CSV.Dixons_Trip_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_to_date | O | TODAY | |||||
From Date | i_from_date | O | TODAY | |||||
Carrier | i_carrier | O |
Driver Hours
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Driver Hours | driver_hours | dp_csv_nr.driver_hours |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | i_cost_centre | O | ||||||
Customer Group | i_cust_group | O | ||||||
To Date | i_End_Date_Time | M | TODAY | |||||
From Date | i_Start_Date_Time | M | TODAY |
Driver Scanning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Driver Scanning | DRIVER_SCANNING | DP_CSV6.DRIVER_SCANNING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | i_depot | O | STRING | |||||
Media Type | i_media_type | O | STRING | |||||
Route | i_route | O | STRING | |||||
Customer | i_customer | O | STRING | |||||
Dealer | i_dealer | O | STRING | |||||
Activity | i_activity | O | STRING | |||||
Schedule To | i_sched_to | M | ||||||
Schedule From | i_sched_from | M |
Dunelm Actual Load
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Actual Load | DUNELM_ACTUAL_LOAD | DP_CSV_DUN.daily_ext_load |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Load Date From | i_date_from | M | ||||||
Load Date To | i_date_to | M |
Dunelm Actual Unload
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Actual Unload | DUNELM_ACTUAL_UNLOAD | DP_CSV_DUN.daily_ext_unload |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Unload Date From | i_date_from | M | ||||||
Unload Date To | i_date_to | M |
Dunelm Backing Sheet
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Backing Sheet | BACKING_SHEET | DP_CSV2.BACKING_SHEET |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | O | ||||||
Sched To | i_end_sched | O | ||||||
Sched From | i_start_sched | O | ||||||
Manifest | i_booking | O |
Dunelm DUs Despatched Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm DUs Despatched Extract | DUNELM_DUS_DESPATCHED_EXTRACT | DP_CSV_DUN.DUN_DU_DESPATCHED_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
PO Number | p_external | O | STRING | |||||
Manifest | p_manifest | O | STRING | |||||
Supplier | p_customer | O | ||||||
Start Sched | p_start_sched | O | ||||||
End Sched | p_end_sched | O | ||||||
Consignment Num | p_oms | O | STRING |
Dunelm DUs Not Loaded Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm DUs Not Loaded Extract | DUNELM_DUS_NOT_LOADED_EXTRACT | DP_CSV_DUN.DUN_DU_NOT_LOADED_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Store | p_store | O | Store | Location Id | Name | |||
Schedule | p_sched_date | M |
Dunelm DUs Not Received
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm DUs Not Received | DUNELM_DUS_NOT_RECEIVED | DP_CSV_DUN.daily_ext_not_recd |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_avail_to | M | ||||||
From Date | i_avail_from | M |
Dunelm Inventory Transactions
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Inventory Transactions | DUN_INVENTORY_TRANS | DP_CSV_DUN.DUN_INVENTORY_TRANSACTIONS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | P_DATE_TO | M | TODAY | TODAY:23:59 | ||||
Trunk Trip | P_TRUNK_TRIP | O | ||||||
Delivery Trip | P_DEL_TRIP | O | ||||||
Collection Trip | P_COL_TRIP | O | ||||||
Date Type | P_DATE_TYPE | M | STRING | C | ||||
Customer | i_customer | O | ||||||
From Date | P_DATE_FROM | M | TODAY | TODAY:00:00 | ||||
Store | i_dealer | O |
Dunelm Item Movements 3
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Item Movements 3 | DUN_ITEM_MOVEMENTS_EXTRACT | DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_3 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Manifest Number | P_MANF_NO | O | STRING | |||||
Store | P_STORE | O | ||||||
Supplier | P_SUPPLIER | O | ||||||
Actual From Date | P_START_DATETIME | M | TODAY | |||||
P/O Number | P_PO_NO | O | ||||||
DU Type | P_DU_TYPE | O | ||||||
Actual To Date | P_END_DATETIME | M | TODAY |
Dunelm Item Movements Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Item Movements Extract | DUN_ITEM_MOVEMENTS_EXTRACT | DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Supplier | P_SUPPLIER | O | ||||||
Actual To Date | P_END_DATETIME | M | TODAY | |||||
Actual From Date | P_START_DATETIME | M | TODAY | |||||
DU Type | P_DU_TYPE | O | ||||||
Store | P_STORE | O | ||||||
P/O Number | P_PO_NO | O | ||||||
Manifest Number | P_MANF_NO | O |
Dunelm Item Movements Extract New
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Item Movements Extract New | DUN_ITEM_MOVEMENTS_EXTRACT | DP_CSV_DUN.ITEM_MOVEMENTS_EXTRACT_2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Actual To Date | P_END_DATETIME | M | TODAY | |||||
Store | P_STORE | O | ||||||
P/O Number | P_PO_NO | O | ||||||
Manifest Number | P_MANF_NO | O | STRING | |||||
Actual From Date | P_START_DATETIME | M | TODAY | |||||
Supplier | P_SUPPLIER | O | ||||||
DU Type | P_DU_TYPE | O |
Dunelm Left Offs
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Left Offs | Left_Offs_Extract | DP_CSV_DUN.left_offs_extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Store (Optional) | P_STORE | O | Store | Location Id | Name | |||
Trip Id (Optional) | P_TRIP_ID | O | ||||||
Days Back | P_DAYS_BACK | M | STRING | 30 |
Dunelm Loading Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Loading Extract | DUNELM_LOADING_EXTRACT | DP_CSV2.DUN_LOADING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | P_SCHED_DATE | M |
Dunelm Manifest E-OT-L Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Manifest E-OT-L Extract | DUNELM_MANIFESTED_EOL | DP_CSV_DUN.daily_ext_manifest |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_avail_to | M | ||||||
From Date | i_avail_from | M |
Dunelm Manual Loaded Items Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Manual Loaded Items Extract | MANL_SCAN_ORDER_DETAIL_EXTRACT | DP_CSV2.MANL_SCAN_ORDER_DETAIL_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | P_START_DATE | O | ||||||
To Date | P_END_DATE | O |
Dunelm Receiving Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Receiving Extract | DUNELM_RECEIVING_EXTRACT | DP_CSV2.DUN_RECEIVING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | P_SCHED_DATE | M |
Dunelm Recieving E-OT-L Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Recieving E-OT-L Extract | DUNELM_RECEIPTED_EOL | DP_CSV_DUN.daily_ext_receipting |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | i_sched_from | M | ||||||
End Schedule | i_sched_to | M |
Dunelm Supplier DU Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier DU Extract | DUNELM_SUPPLIER_DU_EXTRACT | DP_CSV2.DUN_SUPPLIER_DU_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To | P_TO | M | TODAY | |||||
From | P_FROM | M | TODAY |
Dunelm Supplier DU Extract by Store
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier DU Extract by Store | DUNELM_DU_STORE_EXTRACT | DP_CSV2.DUN_DU_STORE_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Order Status | P_STATUS | O | ||||||
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | M | ||||||
Store | P_STORE | O | Store | Location Id | Name |
Dunelm Supplier Revenue Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier Revenue Extract | DUNELM_SUPPLIER_REVENUE_EXTRACT | DP_CSV2.DUN_SUPPLIER_REVENUE_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | P_END_SCHED | M | ||||||
Start Schedule | P_START_SCHED | M |
Dunelm Supplier Revenue Extract New
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier Revenue Extract New | DUNELM_SUPPLIER_REVENUE_NEW | DP_CSV2.DUN_SUPPLIER_REVENUE_NEW |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Revenue End | P_REVENUE_END | M | TODAY | |||||
Revenue Start | P_REVENUE_START | M | TODAY |
Dunelm Supplier Trends Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Supplier Trends Extract | DUN_SUPPLIER_TRENDS | dp_csv_dun.dun_du_rpe_revenue_extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Week | i_week_no | M | ||||||
Year | i_year | M |
Dunelm Transport Plan
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Transport Plan | DUNELM_TRANSPORT_PLAN | DP_CSV_DUN.daily_transport_plan |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_avail_from | M | ||||||
Order Status | i_ord_status | M | STRING | ALL | ||||
Supplier | i_supplier | M | STRING | ALL | ||||
To Date | i_avail_to | M |
Dunelm Unsched Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Dunelm Unsched Orders | DUNELM_UNSCHED_ORD | DP_CSV_DUN.daily_unsched_ord |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_avail_to | M | ||||||
From Date | i_avail_from | M |
Duplicate Postcodes
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Duplicate Postcodes | DUPLICATE_POSTCODES | dp_csv2.duplicate_postcodes_extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Location To | P_LOCATION_TO | O | Location To | Location Id | Location Name | |||
Ignore Inactive? | P_IGNORE_INACTIVE | O | ||||||
Location From | P_LOCATION_FROM | O | Location From | Location Id | Location Name |
EFX Inbound Errors
Report Name | Filename | Procedure for Scheduling |
---|---|---|
EFX Inbound Errors | EFX_Inbound_Errors | DP_CSV2.EFX_In_Errs_Extract |
No parameters.
ERC
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ERC | ERC | DP_CSV_DHL.ERC |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
DHL Carriers | i_dhl_carr | M | ||||||
Detail Level | i_detail | M | ||||||
Sched Start | i_sched_from | M | ||||||
Carrier | i_carrier | O | ||||||
Sched End | i_sched_to | M |
Equipment Moves
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Equipment Moves | Equip_Move | DP_CSV2.EQUIP_MOVE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Owning depot | i_depot | O | ||||||
Customer | i_customer | O | ||||||
To Date | i_date_to | M | TODAY | |||||
From Date | i_date_from | M | TODAY | |||||
Carrier | i_carrier | O |
Extract Lane
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Extract Lane | EXTRACT_LANE | CSV.EXTRACT_BY_LANE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | I_COST_CENTRE | O | Cost Centre | Location Id | Name | |||
Customer | I_CUSTOMER | O |
Failed Shipment
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Failed Shipment | FAILED_SHIPMENT | dp_csv3.failed_shipment |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule To | I_SCHED_TO | M | ||||||
Schedule From | I_SCHED_FROM | M | ||||||
Customer | I_CUSTOMER | O | STRING | OPENFIELD |
Fixed Routes Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Fixed Routes Extract | Routes_Extract | CSV.FIXED_ROUTES_EXPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Show Active / Inactive | i_inactive | M | STRING | B | ||||
Carrier | i_carrier | O | ||||||
Depot | i_depot | O | Depot | Location Id | Name |
GREENE KING Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
GREENE KING Interface Results | GREENE_KING_interface_results | CSV.GREENE_KING_if_res |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | I_CUSTOMER | O | ||||||
Depot | i_depot | O | ||||||
To Date | i_to_date | O | TODAY | |||||
From Date | i_from_date | O | TODAY |
GYP EFX Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
GYP EFX Export | GYP_EFX_Export | DP_CSV5.GYP_EFX_EXPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Trip Status | I_STATUS | O | ||||||
To Schedule | P_END_SCHED | M | ||||||
From Schedule | P_START_SCHED | M | ||||||
Cost Centre | I_COST_CENTRE | O | ||||||
Customer Group | I_CUST_GRP | O |
HC Booking In Form
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HC Booking In Form | HC_BOOKING_IN_FORM | DP_CSV5.P_HC_BOOKING_IN_FORM |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | I_SCHED_NAME | M | ||||||
Group Name | I_GROUP_NAME | O | ||||||
Customer | I_CUSTOMER | O | ||||||
Delivery Location | I_DEL_LOCATION | O |
HC Haulier Trip Sheet
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HC Haulier Trip Sheet | HAULIER_TRIP_SHEET | DP_CSV2.HAULIER_TRIP_SHEET |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Trip ID (optional) | i_trip_id | O | ||||||
Owning Depot | i_depot | O | Depot | Location Id | Name | |||
Load Location | i_load_loc | O | Loading Location | Location Id | Name | |||
Group Name | i_group_name | O | ||||||
Carrier | i_carrier | O | ||||||
Schedule | i_sched | M |
HCR Customer Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HCR Customer Orders | HCR_CUSTOMER_ORDERS | DP_CSV_DHL.HCR_CUSTOMER_ORDERS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | I_COST_CENTRE | O | ||||||
Depot | P_LOCATION | O | ||||||
Customer | I_CUSTOMER | O | ||||||
Schedule | I_SCHED_NAME | M |
HCR Loading Sheet CSV
Report Name | Filename | Procedure for Scheduling |
---|---|---|
HCR Loading Sheet CSV | HCR_LOADING_SHEET | DP_CSV5.HCR_LOADING_SHEET |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Carrier | P_CARRIER | O | ||||||
Group Name | P_GROUP_NAME | O | ||||||
Owning Depot | P_OWNING_DEPOT | O | Depot | Loading Location | Name | |||
Customer | P_CUSTOMER | O | ||||||
Schedule To | P_SCHED_TO | M | ||||||
Trip ID (optional) | P_TRIP_ID | O | ||||||
Load Location | P_LOAD_LOC | O | Loading Location | Loading Location | Name | |||
Schedule From | P_SCHED_FROM | M |
Haulier Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Haulier Invoice | Haulier_Invoice | DP_CSV5.HAULIER_INVOICE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Invoice ID | P_INVOICE_ID | O | STRING |
Heavy Vehicle Utilisation
Warning: Missing
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Schedule | M | ||||||
End Schedule | M | ||||||
Customer Group | O |
Historical Lane Based Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | I_FROM_DATE | M | TODAY | |||||
To Date | I_TO_DATE | O | TODAY |
IND Trip and Order Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
IND Trip and Order Detail | IND_Trip_Order_Detail_Extract | DP_CSV2.IND_TRIP_ORDER_DETAIL_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | P_END_SCHED | M | ||||||
Activity | i_activity_name | M | STRING | Both | ||||
Loaded At | i_loaded_at | O | ||||||
Start Schedule | P_START_SCHED | M | ||||||
Carrier | i_carrier_id | O | ||||||
Group Name | i_group_name | M |
ISC Finance (2) Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ISC Finance (2) Export | FINANCE_2_EXPORT | DP_CSV2.FINANCE_EXPORT_V2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | I_CUSTOMER | M | STRING | ALL | ||||
Start Schedule | I_FROM_SCHED_NAME | M | ||||||
End Schedule | I_TO_SCHED_NAME | M |
ISC Finance (3) Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ISC Finance (3) Export | FINANCE_2_EXPORT | CSV6.ISC_FINANCE_2_EXPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | I_CUSTOMER | M | STRING | ALL | ||||
Start Schedule | I_FROM_SCHED_NAME | M | ||||||
End Schedule | I_TO_SCHED_NAME | M |
ISC Finance (4) Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
ISC Finance (4) Export | FINANCE_2_EXPORT | CSV7.FINANCE_EXPORT_V2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | I_CUSTOMER | M | STRING | ALL | ||||
Start Schedule | I_FROM_SCHED_NAME | M | ||||||
End Schedule | I_TO_SCHED_NAME | M |
Interface Errors Failures
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Interface Errors Failures | Interface_Errors_Failures | DP_CSV5.INTERFACE_ERRORS_FAILURES |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Source System | P_SOURCE_SYSTEM | O | Source System | |||||
Customer | P_CUSTOMER | O | Customer | |||||
External Ref | P_EXTERNAL_REF | O | STRING | |||||
End Date | P_END_DATETIME | M | TODAY | |||||
Start Date | P_START_DATETIME | M | TODAY |
Invalid Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Invalid Orders | Invalid_Orders | DP_CSV6.INVALID_ORDERS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | 0 | ||||||
End Schedule | i_end_sched | M | ||||||
Start Schedule | i_start_sched | M |
Item Movements
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Item Movements | ITEM_MOVEMENTS_EXTRACT | DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Actual From Date | P_START_DATETIME | M | TODAY | |||||
Actual To Date | P_END_DATETIME | M | TODAY | |||||
Supplier | P_SUPPLIER | O | ||||||
DU Type | P_DU_TYPE | O | ||||||
Manifest Number | P_MANF_NO | O | ||||||
P/O Number | P_PO_NO | O | ||||||
Store | P_STORE | O |
Item Movements 2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Item Movements 2 | ITEM_MOVEMENTS_2_EXTRACT | DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Actual From Date | P_START_DATETIME | M | TODAY | |||||
Actual To Date | P_END_DATETIME | M | TODAY | |||||
Supplier | P_SUPPLIER | O | ||||||
DU Type | P_DU_TYPE | O | ||||||
Manifest Number | P_MANF_NO | O | ||||||
P/O Number | P_PO_NO | O | ||||||
Store | P_STORE | O |
Item Movements 3
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Item Movements 3 | ITEM_MOVEMENTS_3_EXTRACT | DP_CSV_GEN.ITEM_MOVEMENTS_EXTRACT_3 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Actual From Date | P_START_DATETIME | M | TODAY | |||||
Actual To Date | P_END_DATETIME | M | TODAY | |||||
Supplier | P_SUPPLIER | O | ||||||
DU Type | P_DU_TYPE | O | ||||||
Manifest Number | P_MANF_NO | O | ||||||
P/O Number | P_PO_NO | O | ||||||
Store | P_STORE | O |
Items Not Scanned By Date
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Items Not Scanned By Date | Items_Not_Scanned | DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_DATE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | P_DEPOT | M | ||||||
Schedule To | P_END_SCHED | M | ||||||
Schedule From | P_START_SCHED | M |
Items Not Scanned By Trip
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Items Not Scanned By Trip | Items_Not_Scanned | DP_CSV_DUN.ITEMS_NOT_SCANNED_BY_TRIP |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | P_SCHED | M | ||||||
Trip | P_TRIP_ID | M |
JEYES Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
JEYES Interface Results | JEYES_interface_results | CSV.JEYES_if_res |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | I_CUSTOMER | O | ||||||
Depot | i_depot | O | ||||||
From Date | i_from_date | O | TODAY | |||||
To Date | i_to_date | O | TODAY |
Job Notes
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Job Notes | Job_Notes | DP_CSV5.JOB_NOTES |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Date from | i_date_from | M | ||||||
OMS Ref To | i_oms_to | O | ||||||
OMS Ref From | i_oms_from | O | ||||||
Date to | i_date_to | M | ||||||
Customer | i_customer | O |
KPI By Lane
Report Name | Filename | Procedure for Scheduling |
---|---|---|
KPI By Lane | KPI_BY_LANE | CSV.KPI_BY_LANE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Date | I_START_DATE_TIME | M | TODAY | |||||
Tolerance(days) | I_TOLERANCE | O | ||||||
Customer Group | I_CUST_GROUP | O | ||||||
End Date | I_END_DATE_TIME | M | TODAY | |||||
Grouping | I_GROUP_BY | M | STRING | CUST_GROUP |
KPI Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
KPI Extract | CN_KPI_Extract | KPI_EXTRACT.KPI_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Owning Depot | i_owning_depot | O | Depot | Location Id | Name | |||
Start Schedule | i_start_sched | M | ||||||
Group Name | i_group_name | O | STRING | ALL | ||||
End Schedule | i_end_sched | M |
Kraft KPI
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Kraft KPI | KRAFT_KPI | CSV.Trips_with_Orders |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | I_START_DATETIME | M | TODAY | |||||
To Date | I_END_DATETIME | M | TODAY | |||||
Cost Centre | I_COST_CENTRE | O |
LFS Packages
Report Name | Filename | Procedure for Scheduling |
---|---|---|
LFS Packages | LFS_Packages | DP_CSV_LFS.LFS_PACKAGES |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
External Ref | i_ext_ref | O | ||||||
Customer | i_customer | O | ||||||
Schedule | i_sched | M | ||||||
Order Status | i_ord_status | O |
Lane Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Lane Extract | Lane_Extract | CSV.LANE_EXPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Loc | p_from_loc | O | From Loc | Location Id | Name | |||
To Loc | p_to_loc | O | To Loc | Location Id | Name | |||
Customer | p_customer | O | ||||||
Cost Centre | p_cost_centre | O |
Left Offs
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Left Offs | LEFT_OFFS_EXTRACT | DP_CSV_GEN.LEFT_OFFS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Trip ID (optional) | P_TRIP_ID | O | ||||||
Store (optional) | P_STORE | O | Store | Location ID | Name | |||
Days Back | P_DAYS_BACK | M | STRING | 30 |
Loading Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Loading Extract | LOADING_EXTRACT | DP_CSV_GEN.EXT_LOADING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | P_SCHED_DATE | M |
Loading Schedule CSV
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Loading Schedule CSV | Loading_Schedule | CSV.LOADING_SCHEDULE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_End_Time | M | TODAY | |||||
From Date | i_Start_Time | M | TODAY | |||||
Depot | i_Depot | M | Depot | Location Id | Name |
Location Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Export | Location_Export | DP_CSV2.LOCATION_EXPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Location Group | I_CUST_GROUP | O | ||||||
Country | i_country | O |
Location Export GL
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Export GL | Location_Export | CSV.LOCATION_EXPORT_GL |
No parameters
Location Export GPR
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Export GL | Location_Export | CSV.LOCATION_EXPORT_GPR |
No parameters.
Location Pre-Warning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Location Pre-Warning | Loc_Del_Pre_Warn | CSV.Loc_Del_Pre_Warning |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | i_depot | M | Depot | Location Id | Name | |||
From Date | i_start_date_time | M | TODAY | |||||
Load Type | i_load_type | M | STRING | ALL | ||||
To Date | i_end_date_time | M | TODAY | |||||
Trip Status | i_trip_status | M | STRING | ALL |
MDD Code 03 Exceptions
Report Name | Filename | Procedure for Scheduling |
---|---|---|
MDD Code 03 Exceptions | MDD Code 03 Exceptions | CSV.MDD_Code_03_Exceptions |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | P_START_DATETIME | M | TODAY | |||||
To Date | P_END_DATETIME | M | TODAY |
MTS Finance Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
MTS Finance Export | FINANCE_EXPORT | CSV.finance_export_v2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_to_sched_name | M | ||||||
Start Schedule | i_from_sched_name | M | ||||||
Customer | I_CUSTOMER | M | STRING | ALL |
MTS Finance Export V2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
MTS Finance Export | FINANCE_EXPORT_V2 | CSV.finance_export_v2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_to_sched_name | M | ||||||
Start Schedule | i_from_sched_name | M | ||||||
Customer | I_CUSTOMER | M | STRING | ALL |
Manual Loaded Items
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Manual Loaded Items | MANUAL_LOADED_ITEMS_EXTRACT | DP_CSV_GEN.MANL_SCAN_ORDER_DETAIL_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | P_START_DATE | O | ||||||
To Date | P_END_DATE | O |
Master and Child Locations
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Master and Child Locations | Master_and_Child | DP_CSV5.MASTER_AND_CHILD |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Show Mapped | P_SHOW_MAPPED | O | Show Mapped | |||||
Show UnMapped | P_SHOW_UNMAPPED | O | Show UnMapped |
Message Maintenance
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Message Maintenance | Message_Maintenance | CSV.msg_maint |
No parameters
Missing Lat Long Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Missing Lat Long Report | MISSING_LAT_LONGS | dp_csv3.missing_lat_long_extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | i_cost_centre | M | ALL |
Missing Steps Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Missing Steps Report | Missing_Steps_Report | DP_CSV5.Missing_Steps_Report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Missing Step | i_step | O | STRING | ALL | ||||
To Date | i_date_to | M | TODAY | |||||
From Date | i_date_from | M | TODAY |
Month End Accruals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Month End Accruals | month_end_accruals | dp_csv_nr.month_end_accruals |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_End_Date_Time | M | TODAY | |||||
From Date | i_Start_Date_Time | M | TODAY | |||||
Cost Centre | i_cost_centre | O | ||||||
Cust Group | i_cust_group | O | ||||||
Customer | i_customer | O |
NR Additional Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
NR Additional Report | nr_additional_rep | dp_csv_nr.nr_additional_report |
No parameters
NR Finance Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
NR Finance Extract | NR_Finance_Extract | DP_CSV_NR.NR_FINANCE_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Debriefed | i_debriefed | M | ||||||
From Date | i_from_date | M | TODAY | |||||
Carrier | i_carrier | O | ||||||
To Region | i_to_region | M | STRING | ALL | ||||
From Region | i_from_region | M | STRING | ALL | ||||
Carrier Group | i_carrier_group | O | ||||||
Strategy | i_strategy | O | ||||||
Cost Centre | i_cost_centre | O | ||||||
Customer | i_customer | O | ||||||
To Date | i_to_date | M | TODAY |
NR Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
NR Invoice | NR_Invoice | DP_CSV_NR.NR_INVOICE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_from_date | M | TODAY | |||||
Carrier | i_carrier | O | ||||||
To Region | i_to_region | M | STRING | ALL | ||||
From Region | i_from_region | M | STRING | ALL | ||||
Debriefed | i_debriefed | M | ||||||
Strategy | i_strategy | O | ||||||
Cost Centre | i_cost_centre | O | ||||||
Customer | i_customer | O | ||||||
To Date | i_to_date | M | TODAY | |||||
Carrier Group | i_carrier_group | O |
OPS KPI Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
OPS KPI Extract | OPS_KPI_Extract | KPI.KPI_OPS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | i_cost_centre | O | ALL | |||||
To Date | i_date_to | M | TODAY | |||||
From Date | i_date_from | M | TODAY | |||||
Client | i_client | O | ALL | |||||
Carrier | i_carrier | O | ALL | |||||
Depot | i_depot | O | ALL | Location Id | Name | |||
Date Range Type | i_date_type | M | String |
OPS KPI Extract2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
OPS KPI Extract2 | OPS_KPI_Extract | KPI.KPI_OPUS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | i_cost_centre | O | ALL | |||||
To Date | i_date_to | M | TODAY | |||||
From Date | i_date_from | M | TODAY | |||||
Client | i_client | O | ALL | |||||
Carrier | i_carrier | O | ALL | |||||
Depot | i_depot | O | ALL | Location Id | Name | |||
Date Range Type | i_date_type | M | String |
OTM Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
OTM Export | OTM_Export | DP_CSV_DHL.OTM_EXPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Date To | i_date_to | M | TODAY | |||||
Carrier | i_carrier | O | ||||||
Date From | i_date_from | M | TODAY |
On Time Arrivals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Arrivals | ON_TIME_ARRIVALS | DP_CSV6.ON_TIME_ARRIVALS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule From | i_sched_from | M | ||||||
Schedule To | i_sched_to | M | ||||||
Customer | i_customer | O | ||||||
Outbase | i_depot | O | ||||||
Route Code | i_route | O | ||||||
Media Type | i_media | O | ||||||
Dealer | i_dealer | O |
On Time Drops
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Drops | ON_TIME_DROPS | DP_CSV6.ON_TIME_DROPS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Route Code | i_route | O | ||||||
Outbase | i_depot | O | ||||||
Dealer | i_dealer | O | ||||||
Customer | i_customer | O | ||||||
Media Type | i_media | O | ||||||
Schedule From | i_sched_from | M | ||||||
Schedule To | i_sched_to | M |
On Time Items
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Items | ON_TIME_ITEMS | DP_CSV6.ON_TIME_ITEMS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule From | i_sched_from | M | ||||||
Schedule To | i_sched_to | M | ||||||
Customer | i_customer | O | ||||||
Media Type | i_media | O | ||||||
Route Code | i_route | O | ||||||
Dealer | i_dealer | O | ||||||
Outbase | i_depot | O |
On Time Items (Assets)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Items (Assets) | ON_TIME_ITEMS | DP_CSV6.ON_TIME_ITEMS_ASSETS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule To | i_sched_to | M | ||||||
Schedule From | i_sched_from | M | ||||||
Route Code | i_route | O | ||||||
Outbase | i_depot | O | ||||||
Dealer | i_dealer | O | ||||||
Customer | i_customer | O | ||||||
Media Type | i_media | O |
On Time Returns
Report Name | Filename | Procedure for Scheduling |
---|---|---|
On Time Returns | ON_TIME_RETURNS | DP_CSV6.ON_TIME_RETURNS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Route Code | i_route | O | ||||||
Media Type | i_media | O | ||||||
Outbase | i_depot | O | ||||||
Dealer | i_dealer | O | ||||||
Customer | i_customer | O | ||||||
Schedule To | i_sched_to | M | ||||||
Schedule From | i_sched_from | M |
Operational Information
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Operational Information | Operational_Information | DP_CSV2.OPERATIONAL_INFO |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | P_END_DATE | M | TODAY | |||||
POD | P_POD | O | ||||||
Carrier | I_FROM_LOC | O | Carrier | Carrier Name | Carrier ID | |||
Location From | P_FROM_LOC | O | STRING | Location From | Location ID | Name | ||
From Date | P_START_DATE | M | TODAY |
Order Charges Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Charges Extract | ORD_CHARGE | DP_CSV5.ORD_CHARGE_REPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Date | P_DELIVERY_DATE | M | TODAY |
Order Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Extract | ORDER_EXTRACT.csv | DP_CSV2.HCR_ORDER_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Sched | P_START_SCHED | M | ||||||
End Sched | P_END_SCHED | M |
Order Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Interface Results | ORDER_INTERFACE_RESULTS | CSV.ORDER_INTERFACE_RESULTS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_to_date | O | TODAY | |||||
Customer | I_CUSTOMER | O | ||||||
From Date | i_from_date | O | TODAY | |||||
Depot | i_depot | O | ||||||
Message Type | O |
Order Items POD Debriefed
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Items POD Debriefed | Order_Items_POD_Debriefed | DP_CSV_GEN.ORDER_ITEMS_POD_DEBRIEFED |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | O | ||||||
Customer | P_CUSTOMER | O |
Order Savings
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Savings | ORDER_SAVINGS | CSV.Order_savings |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | O | ||||||
Show Neg Savings | p_show_only_negative | M |
Order Tracking
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Order Tracking | Order_Tracking | DP_CSV5.ORDER_TRACKING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Month | P_MONTH | M | ||||||
Week Offset | P_WEEK_OFFSET | O | ||||||
Year | P_YEAR | M | ||||||
Customer | P_CUSTOMER | O | STRING | OPENFIELD | ||||
Cost Centre | P_COST_CENTRE | O | STRING | EXEL |
Orders for Relabelling
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Orders for Relabelling | ORDERS_FOR_RELABELLING | DP_CSV_DHL.ORDERS_FOR_RELABELLING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | p_schedule | M |
Orders to LogiX
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Orders to LogiX | LogiX_Orders | DP_LOGIX.ORDER_EXPORT |
No parameters
Orders to Paragon
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Orders to Paragon | Paragon_Orders | CSV.Orders_to_Paragon |
No parameters
Outbound Shortage
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Outbound Shortage | OUTBOUND_SHORTAGE | DP_CSV6.OUTBOUND_SHORTAGE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Dealer | i_dealer | O | STRING | |||||
Schedule From | i_sched_from | M | ||||||
Customer | i_customer | O | STRING | |||||
Schedule To | i_sched_to | M | ||||||
Depot | i_depot | O | STRING | |||||
Route | i_route | O | STRING | |||||
Media Type | i_media_type | O | STRING |
PAYMENT_DTLS
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PAYMENT_DTLS | PAYMENT_DTLS | OF_INT.WRITE_PAYMENT_DETAILS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_cust | M | ||||||
From Date | i_from_date | M | TODAY | |||||
End Date | i_to_date | M | TODAY |
POC to SAP Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POC to SAP Extract | POC to SAP Extract | CSV.POC_to_Sap_Extract |
No parameters
POC to SAP Extract(A)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POC to SAP Extract(A) | POC to SAP Extract(A) | CSV.POC_to_Sap_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Resend All? | p_resend_flag | M | STRING | No |
POC-POD Reprocessing Team Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POC-POD Reprocessing Team Export | POC_POD_REPOROCESSING | DP_CSV.POC_POD_REPROCESSING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | P_END_DATETIME | M | YESTERDAY | YESTERDAY | ||||
Date From | P_START_DATETIME | M | TODAY | YESTERDAY:20:00 |
POD Delivery Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD Delivery Extract | POD_Delivery_Extract | DP_CSV2.POD_DELIVERY_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer Group | p_group_name | O | STRING | ALL | ||||
Scanning Depot | p_scan_depot | O | STRING | ALL | Depot | Location Id | Name | |
> Days Outstanding | p_outstanding | O | STRING | 0 | ||||
POD Status | p_pod | O | STRING | ALL | ||||
Carrier | p_carrier | O | STRING | ALL | ||||
To Schedule | p_to_date | M | ||||||
From Schedule | p_from_date | M | ||||||
Customer | p_customer | O | STRING | ALL | ||||
Del Msg Sent | p_del_msg_sent | O | STRING | ALL |
POD Generation Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD Generation Extract | POD_GEN | DP_CSV5.POD_REPORT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
POD Flow | P_FLOW | M | ||||||
Schedule | P_SCHED | O | ||||||
Date From | P_DATE_FROM | M | TODAY | |||||
Date To | P_DATE_TO | M | TODAY |
POD to SAP Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD to SAP Extract | POD to SAP Extract | CSV.POD_to_Sap_Extract |
No parameters
POD to SAP Extract(A)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
POD to SAP Extract(A) | POD to SAP Extract(A) | CSV.POD_to_Sap_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Resend All? | p_resend_flag | M | STRING | No |
PORSCHE19 Invoice Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PORSCHE19 Invoice Extract | Invoice_Extract | DP_CSV2.Invoice_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Sub Credit Account | p_sub_credit_acc | O | STRING | ALL | ||||
Trip ID | p_trip | O | STRING | ALL | ||||
Export ID | p_export | O | STRING | 0 | ||||
Customer | p_customer | M | STRING | PORSCHE19 | ||||
Sub Debit Account | p_sub_debit_acc | O | STRING | ALL | ||||
Invoice ID | p_invoice | O | STRING | 0 |
PROVIDER_REVENUE
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PROVIDER_REVENUE | PROVIDER_REVENUE | dp_csv3.provider_revenue |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Owning Depot | P_OWNING_DEPOT | O | ||||||
From Schedule | P_START_SCHED | M | ||||||
To Schedule | P_END_SCHED | M |
Parts and Empties
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Parts and Empites | Parts_and_Empties | DP_CSV5.PARTS_AND_EMPTIES |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule From | P_SCHED_FROM | M | ||||||
Schedule To | P_SCHED_TO | M | ||||||
Location From | P_LOCATION | O | ||||||
Export Type | P_EXPORT_TYPE | M | ||||||
Customer | P_CUSTOMER | M |
PostCode Matrix
Report Name | Filename | Procedure for Scheduling |
---|---|---|
PostCode Matrix | POSTCODE_MATRIX | dp_csv3.postcode_matrix |
No parameters
Pre Invoice Check
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Pre Invoice Check | Pre_Invoice_Check | CSV.PRE_INVOICE_CHECK |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cut-off Date | i_cutoff_date | M | TODAY |
Process Items Audit
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Process Items Audit | PROCESS_ITEMS_AUDIT | DP_CSV6.PROCESS_ITEMS_AUDIT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Record Status | i_record_status | M | STRING | ALL | ||||
End Date | i_end_datetime | M | TODAY | |||||
Start Date | i_start_datetime | M | TODAY | |||||
Incl. Reprocessed | i_incl_reprocessed | M | STRING | N |
Process Items Interface Audit
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Process Items Interface Audit | PROCESS_ITEMS_INTERFACE_AUDIT | DP_CSV6.PROCESS_ITEMS_INTERFACE_AUDIT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Incl. Reprocessed | i_incl_reprocessed | M | STRING | N | ||||
Record Status | i_record_status | M | STRING | ALL | ||||
End Date | i_end_datetime | M | TODAY | |||||
Start Date | i_start_datetime | M | TODAY |
Provisional Booking Exceptions
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Provisional Booking Exceptions | Provisional Booking Exceptions | CSV.Provisional_Booking_Exceptions |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | P_START_DATETIME | M | TODAY | |||||
To Date | P_END_DATETIME | M | TODAY |
Purchase Order Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Purchase Order Extract | po_extract | DP_CSV2.PURCHASE_ORDER_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_end_date | O | TODAY | TODAY | ||||
From Date | i_start_date | O | TODAY | TODAY | ||||
Status | i_status_id | O | STRING | All |
Reason Listings
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Reason Listings | REASON_LISTING_ | dp_csv3.reasons_listing |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Date To | p_end_datetime | M | TODAY | TODAY:00:01 | ||||
Depot | p_depot | M | ||||||
Date From | p_start_datetime | M | TODAY | TODAY:23:59 |
Receipt Scanning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Receipt Scanning | RECEIPT_SCANNING | DP_CSV6.RECEIPT_SCANNING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | i_depot | O | STRING | |||||
Dealer | i_dealer | O | STRING | |||||
Media Type | i_media_type | O | STRING | |||||
Route | i_route | O | STRING | |||||
Customer | i_customer | O | STRING | |||||
Date To | i_date_to | M | TODAY | |||||
Date From | i_date_from | M | TODAY |
Receiving Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Receiving Extract | RECEIVING_EXTRACT | DP_CSV_GEN.EXT_RECEIVING |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | P_SCHED_DATE | M |
Revenue Check (Account)
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Revenue Check (Account) | revenue_report | dp_csv_nr.revenue_report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_Start_Date_Time | M | TODAY | |||||
From Date | i_End_Date_Time | M | TODAY | |||||
Customer | i_customer | O | ||||||
Cust Group | i_cust_group | O | ||||||
Cost Centre | i_cost_centre | O |
SMS Email Summary Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
SMS Email Summary Report | sms_email_summary | DP_CSV5.SMS_EMAIL_SUMMARY |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | I_DATE_FROM | M | TODAY | |||||
Cost Centre | I_COST_CENTRE | M | STRING | ALL |
STL Trip and Order Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
STL Trip and Order Extract | STL_Trip_Order_Extract | DP_CSV2.STL_TRIP_ORDER_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Order Status | I_ORDER_STATUS | O | ||||||
End Trip Schedule | I_END_SCHED | M | ||||||
Location Type | I_LOC_TYPE | O | ||||||
Start Trip Schedule | I_START_SCHED | M | ||||||
Carrier | I_CARRIER_ID | O |
Sales Margin Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Sales Margin Extract | sme | CSV.order_costs |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_CUSTOMER | O | ||||||
Customer Group | i_CUST_GROUP | O | ||||||
Last Schedule | i_sched_to | O | ||||||
Schedule | i_Sched | M | ||||||
Carrier Group | i_carr_group | O |
Savings Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Savings Extract | Savings | CSV.SAVINGS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Credit Acc | I_CREDIT_ACC | O | ||||||
Saving (> or <) | I_SAVING | O | STRING | |||||
Lane Id | I_LANE_ID | O | ||||||
Customer Group | I_CUST_GROUP | O | ||||||
To Cty Code | I_TO_CTY | O | ||||||
From Cty Code | I_FROM_CTY | O | ||||||
From Date | I_FROM_DATE | O | TODAY | |||||
To Date | I_TO_DATE | O | TODAY | |||||
Debit Acc | I_DEBIT_ACC | O |
Schedule
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Schedule | Schedule | CSV.SCHEDULE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | P_END_DATETIME | M | TODAY | |||||
From Date | P_START_DATETIME | M | TODAY |
Schedule Details
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Schedule Details | schedule_details | DP_CSV_GEN.SCHEDULE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | M |
Schedule Trips CS
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Schedule Trips CS | SCHED_TRIPS_CS | CSV.SCHEDULE_TRIPS_CS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_customer | O | ||||||
Schedule | i_Sched | M |
Scheduled and Cancelled Orders
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Scheduled and Cancelled Orders | Schedule_Orders | CSV.SCHEDULE_ORDERS_VS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_CUSTOMER | O | ||||||
Carrier Group | i_carr_group | O | ||||||
Last Schedule | i_sched_to | O | ||||||
Schedule | i_Sched | M | ||||||
Customer Group | i_CUST_GROUP | O |
Scheduled and Cancelled Orders v2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Scheduled and Cancelled Orders v2 | fn | CSV.SCHEDULE_ORDERS_VS_V2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Customer | i_CUSTOMER | O | ||||||
Carrier Group | i_carr_group | O | ||||||
Last Schedule | i_sched_to | O | ||||||
Schedule | i_Sched | M | ||||||
Customer Group | i_CUST_GROUP | O |
Short Rail Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Short Rail Report | short_rail_rep | dp_csv_nr.short_rail_report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | i_cost_centre | O | ||||||
Product Type | i_product_type | O | ||||||
End Schedule | i_Sched_To | M | ||||||
Start Schedule | i_Sched_From | M |
Slot Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Slot Extract | Slot_Extract | DP_CSV3.Slot_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Location Type | I_LOC_TYPE | O | String | ALL | ||||
Day | I_DAY | O | String | ALL | ||||
Slot Type | I_SLOT_TYPE | O | String | ALL |
Store PVA
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Store PVA | STORE_PVA | DP_CSV_DUN.STORE_PVA |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Delivery Date | P_DEL_DATE | M |
Store Pre Warning
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Store Pre Warning | Store_Pre_Warning | CSV.Store_Pre_Warning |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | i_Depot | O | Depot | Location Id | Name | |||
Store | i_store | O | Store | Location Id | Name | |||
Sched Name | i_sched_name | M | ||||||
Show empty Slots | i_show_empty_slots | O | STRING | N |
Sub Contractor
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Sub Contractor | SUB_CONTRACTOR | DP_CSV_GEN.SUB_CONTRACTOR |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Cost Centre | P_CC | M | ||||||
To Sched | P_END_SCHED | M | ||||||
From Sched | P_START_SCHED | M |
Supplier DUs
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier DUs | SUPPLIER_DU_EXTRACT | DP_CSV_GEN.SUPPLIER_DU_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From | P_FROM | M | TODAY | |||||
To | P_TO | M | TODAY |
Supplier DUs By Store
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier DUs By Store | SUPPLIER_DU_BY_STORE_EXTRACT | DP_CSV_GEN.DU_STORE_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 | |
---|---|---|---|---|---|---|---|---|---|
Supplier DUs By Store | Start Schedule | P_START_SCHED | M | ||||||
Supplier DUs By Store | End Schedule | P_END_SCHED | M | ||||||
Supplier DUs By Store | Store | P_STORE | O | Store | Location ID | Name | |||
Supplier DUs By Store | Order Status | P_STATUS | O |
Supplier Invoice
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier Invoice | Supplier_Invoice | DP_CSV5.SUPPLIER_INVOICE |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Date | P_END_DATE | O | ||||||
Start Date | P_START_DATE | O | ||||||
Invoice ID | P_INVOICE_ID | O | STRING |
Supplier Revenue
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier Revenue | SUPPLIER_REVENUE_EXTRACT | DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
End Schedule | P_END_SCHED | M |
Supplier Revenue 2
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Supplier Revenue 2 | SUPPLIER_REVENUE_2_EXTRACT | DP_CSV_GEN.SUPPLIER_REVENUE_EXTRACT_2 |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Revenue End | P_REVENUE_END | M | TODAY | |||||
Revenue Start | P_REVENUE_START | M | TODAY |
TYRE SUMMARY EXTRACT
Note: Can be run from Trip Waterfall screen.
Report Name | Filename | Procedure for Scheduling |
---|---|---|
TYRE SUMMARY EXTRACT | TYRE_SUMMARY_EXTRACT | DP_CSV6.TYRE_SUMMARY_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | i_sched_name | M |
Trip Actuals
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip Actuals | TRIP_ACTUALS | CSV.TRIP_ACTUALS |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | i_schedule | M |
Trip Assessment Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip Assessment Extract | chk_trips | dp_csv_lfs.chk_trips |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | i_sched | M |
Trip Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip Extract | Trip_Extract | CSV.Trip_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_from_date | O | TODAY | |||||
To Date | i_to_date | O | TODAY | |||||
Carrier | i_carrier | O |
Trip and Order Detail Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trip and Order Detail Extract | Trip_Order_Detail_Extract | CSV.Trip_Order_Detail_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Start Schedule | P_START_SCHED | M | ||||||
Location Type | i_loc_type | M | ALL | |||||
Carrier | i_carrier_id | O | ||||||
End Schedule | P_END_SCHED | M |
Trunking Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Trunking Report | Trunking_Report | CSV.Trunking_Report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | p_Depot | M | Depot | Location Id | Name | |||
End Schedule | P_END_SCHED | M | ||||||
Start Schedule | P_START_SCHED | M | ||||||
Report Type | p_report_type | M | STRING | Revenue |
UNISON Interface Results
Report Name | Filename | Procedure for Scheduling |
---|---|---|
UNISON Interface Results | UNSION_interface_results | CSV.UNISON_if_res |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Depot | i_depot | O | Depot | Location Id | Name | |||
Customer | I_CUSTOMER | O | ||||||
To Date | i_to_date | O | TODAY | |||||
From Date | i_from_date | O | TODAY |
User Activity Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
User Activity Extract | User_Activity_Extract | CSV.User_Activity_Extract |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_End_Date_Time | M | TODAY | |||||
From Date | i_Start_Date_Time | M | TODAY |
User Last Logon Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
User Last Logon Extract | USER_LAST_LOGON | CSV.user_logon_export |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Days since logon | I_NO_DAYS | M | STRING | 90 |
Variance Analysis Store Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Variance Analysis Store Detail | VAR_ANLYS_STORE_DTL | CSV.VARIANCE_ANALYSIS_STORE_DTL |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | i_Schedule | M |
Variance Analysis Summary
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Variance Analysis Summary | VAR_ANLYSIS_SUM | CSV.VARIANCE_ANALYSIS_SUMMARY |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
From Date | i_Start_Date_Time | M | TODAY | |||||
To Date | i_End_Date_Time | M | TODAY |
Variance Analysis Trip Detail
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Variance Analysis Trip Detail | VAR_ANLYS_TRIP_DTL | CSV.VARIANCE_ANALYSIS_TRIP_DTL |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule | i_Schedule | M |
Vehicle Utilisation
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Vehicle Utilisation | vehicle_util | dp_csv_nr.vehicle_utilisation |
Parameters:
Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|
Start Schedule | M | ||||||
End Schedule | M |
Vehicle Utilisation Heavy
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Vehicle Utilisation Heavy | hvy_vehicle_util | dp_csv_nr.heavy_vehicle_utilisation |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_Sched_To | M | ||||||
Carrier Code | i_carrier_code | O | ||||||
Carrier Group | i_carrier_group | O | ||||||
Customer Group | i_cust_group | O | ||||||
Cost Centre | i_cost_centre | O | ||||||
Start Schedule | i_Sched_From | M |
Vehicle Utilisation Non-Heavy
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Vehicle Utilisation Non-Heavy | vehicle_util | dp_csv_nr.vehicle_utilisation |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
End Schedule | i_Sched_To | M | ||||||
Customer Group | i_cust_group | O | ||||||
Carrier Group | i_carrier_group | O | ||||||
Carrier Code | i_carrier_code | O | ||||||
Start Schedule | i_Sched_From | M | ||||||
Cost Centre | i_cost_centre | O |
Volume Deviation Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Volume Deviation Extract | VOLUME_DEVIATION_EXTRACT | DP_CSV5.volume_deviation_report |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_date_to | M | TODAY | |||||
Carrier | i_carrier | O | ALL | |||||
Trip Leg | i_trip_leg | O | STRING | ALL | ||||
Schedule | i_Sched_name | O | ||||||
From Date | i_date_from | M | TODAY | |||||
Deviation | i_deviation | O | STRING | ALL | ||||
Cost Centre | I_COST_CENTRE | O | ALL | |||||
Include Unpacked | i_inc_unpacked | O | STRING | Y |
Volume or Activity
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Volume or Activity | VOLUME_ACTIVITY | DP_CSV6.VOLUME_ACTIVITY |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
Schedule From | i_sched_from | M | ||||||
Customer | i_customer | O | ||||||
Media Type | i_media | O | ||||||
Schedule To | i_sched_to | M | ||||||
Dealer | i_dealer | O | ||||||
Depot | i_depot | O | ||||||
Route Code | i_route | O |
WCS Location Snapshot
Report Name | Filename | Procedure for Scheduling |
---|---|---|
WCS Location Snapshot | WCS_LOC_SANPSHOT | DP_CSV2.wcs_loc_snapshot |
No parameters.
WCS Order Items Extract
Report Name | Filename | Procedure for Scheduling |
---|---|---|
WCS Order Items Extract | WCS_ORDER_ITEMS_EXTRACT | DP_CSV2.WCS_ORDER_ITEMS_EXTRACT |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 |
---|---|---|---|---|---|---|---|---|
To Date | i_end_date | M | TODAY | |||||
Trip | i_trip | O | STRING | |||||
Customer | i_customer | O | ||||||
From Date | i_start_date | M | TODAY | |||||
Crossdock Depot | i_depot | O | Crossdock Depot | Location Id | Name | |||
Order | i_order | O | STRING |
Weekly Transport Report
Report Name | Filename | Procedure for Scheduling |
---|---|---|
Weekly Transport Report | Weekly_Transport | DP_CSV_BNL.Weekly_Transport |
Parameters:
Title | Name | Mand | Def Type | Def Val | LOV | Column 1 | Column 2 | Column 3 | |
---|---|---|---|---|---|---|---|---|---|
Weekly Transport Report | To Sched | i_sched_to | M | ||||||
Weekly Transport Report | From Sched | i_sched_from | M | ||||||
Weekly Transport Report | Carrier | i_carrier | ALL |
XML Order Interface Export
Report Name | Filename | Procedure for Scheduling |
---|---|---|
XML Order Interface Export | XML_Order_Interface | DP_CSV3.XML_ORDER_INTERFACE |
No Parameters