Get reporting records for order items

get

https://api.anvyl.com/api/v1/teams/{team_id}/reporting/order_items

Get reporting records for order items; using pagination

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Path Params

team_id

int32

required

Query Params

filter[id_neq]

string

Filter records with id value not equal to all provided values

filter[id_eq]

string

Filter records with id value equal to any of the provided values

filter[id_lte]

string

Filter records with id value equal to or less than provided value

filter[id_lt]

string

Filter records with id value less than provided value

filter[id_gte]

string

Filter records with id value equal to or greater than provided value

filter[id_gt]

string

Filter records with id value greater than provided value

filter[actual_freight_cost_neq]

string

Filter records with actual_freight_cost value not equal to all provided values

filter[actual_freight_cost_eq]

string

Filter records with actual_freight_cost value equal to any of the provided values

filter[actual_freight_cost_lte]

string

Filter records with actual_freight_cost value equal to or less than provided value

filter[actual_freight_cost_lt]

string

Filter records with actual_freight_cost value less than provided value

filter[actual_freight_cost_gte]

string

Filter records with actual_freight_cost value equal to or greater than provided value

filter[actual_freight_cost_gt]

string

Filter records with actual_freight_cost value greater than provided value

filter[all_order_items_in_consolidations_neq]

string

Filter records with all_order_items_in_consolidations value not equal to all provided values

filter[all_order_items_in_consolidations_eq]

string

Filter records with all_order_items_in_consolidations value equal to any of the provided values

filter[confirmed_cargo_ready_date_neq]

string

Filter records with confirmed_cargo_ready_date value not equal to all provided values

filter[confirmed_cargo_ready_date_eq]

string

Filter records with confirmed_cargo_ready_date value equal to any of the provided values

filter[confirmed_cargo_ready_date_lte]

string

Filter records with confirmed_cargo_ready_date value equal to or less than provided value

filter[confirmed_cargo_ready_date_lt]

string

Filter records with confirmed_cargo_ready_date value less than provided value

filter[confirmed_cargo_ready_date_gte]

string

Filter records with confirmed_cargo_ready_date value equal to or greater than provided value

filter[confirmed_cargo_ready_date_gt]

string

Filter records with confirmed_cargo_ready_date value greater than provided value

filter[confirmed_delivery_date_neq]

string

Filter records with confirmed_delivery_date value not equal to all provided values

filter[confirmed_delivery_date_eq]

string

Filter records with confirmed_delivery_date value equal to any of the provided values

filter[confirmed_delivery_date_lte]

string

Filter records with confirmed_delivery_date value equal to or less than provided value

filter[confirmed_delivery_date_lt]

string

Filter records with confirmed_delivery_date value less than provided value

filter[confirmed_delivery_date_gte]

string

Filter records with confirmed_delivery_date value equal to or greater than provided value

filter[confirmed_delivery_date_gt]

string

Filter records with confirmed_delivery_date value greater than provided value

filter[confirmed_po_accepted_date_neq]

string

Filter records with confirmed_po_accepted_date value not equal to all provided values

filter[confirmed_po_accepted_date_eq]

string

Filter records with confirmed_po_accepted_date value equal to any of the provided values

filter[confirmed_po_accepted_date_lte]

string

Filter records with confirmed_po_accepted_date value equal to or less than provided value

filter[confirmed_po_accepted_date_lt]

string

Filter records with confirmed_po_accepted_date value less than provided value

filter[confirmed_po_accepted_date_gte]

string

Filter records with confirmed_po_accepted_date value equal to or greater than provided value

filter[confirmed_po_accepted_date_gt]

string

Filter records with confirmed_po_accepted_date value greater than provided value

filter[confirmed_production_end_date_neq]

string

Filter records with confirmed_production_end_date value not equal to all provided values

filter[confirmed_production_end_date_eq]

string

Filter records with confirmed_production_end_date value equal to any of the provided values

filter[confirmed_production_end_date_lte]

string

Filter records with confirmed_production_end_date value equal to or less than provided value

filter[confirmed_production_end_date_lt]

string

Filter records with confirmed_production_end_date value less than provided value

filter[confirmed_production_end_date_gte]

string

Filter records with confirmed_production_end_date value equal to or greater than provided value

filter[confirmed_production_end_date_gt]

string

Filter records with confirmed_production_end_date value greater than provided value

filter[confirmed_production_start_date_neq]

string

Filter records with confirmed_production_start_date value not equal to all provided values

filter[confirmed_production_start_date_eq]

string

Filter records with confirmed_production_start_date value equal to any of the provided values

filter[confirmed_production_start_date_lte]

string

Filter records with confirmed_production_start_date value equal to or less than provided value

filter[confirmed_production_start_date_lt]

string

Filter records with confirmed_production_start_date value less than provided value

filter[confirmed_production_start_date_gte]

string

Filter records with confirmed_production_start_date value equal to or greater than provided value

filter[confirmed_production_start_date_gt]

string

Filter records with confirmed_production_start_date value greater than provided value

filter[confirmed_received_date_neq]

string

Filter records with confirmed_received_date value not equal to all provided values

filter[confirmed_received_date_eq]

string

Filter records with confirmed_received_date value equal to any of the provided values

filter[confirmed_received_date_lte]

string

Filter records with confirmed_received_date value equal to or less than provided value

filter[confirmed_received_date_lt]

string

Filter records with confirmed_received_date value less than provided value

filter[confirmed_received_date_gte]

string

Filter records with confirmed_received_date value equal to or greater than provided value

filter[confirmed_received_date_gt]

string

Filter records with confirmed_received_date value greater than provided value

filter[confirmed_ship_date_neq]

string

Filter records with confirmed_ship_date value not equal to all provided values

filter[confirmed_ship_date_eq]

string

Filter records with confirmed_ship_date value equal to any of the provided values

filter[confirmed_ship_date_lte]

string

Filter records with confirmed_ship_date value equal to or less than provided value

filter[confirmed_ship_date_lt]

string

Filter records with confirmed_ship_date value less than provided value

filter[confirmed_ship_date_gte]

string

Filter records with confirmed_ship_date value equal to or greater than provided value

filter[confirmed_ship_date_gt]

string

Filter records with confirmed_ship_date value greater than provided value

filter[currency_neq]

string

Filter records with currency value not equal to all provided values

filter[currency_eq]

string

Filter records with currency value equal to any of the provided values

filter[currency_ncontains]

string

Filter records with currency value not containing all provided values

filter[currency_contains]

string

Filter records with currency value containing any of the provided values

filter[currency_lte]

string

Filter records with currency value equal to or less than provided value

filter[currency_lt]

string

Filter records with currency value less than provided value

filter[currency_gte]

string

Filter records with currency value equal to or greater than provided value

filter[currency_gt]

string

Filter records with currency value greater than provided value

filter[current_milestone_name_neq]

string

Filter records with current_milestone_name value not equal to all provided values

filter[current_milestone_name_eq]

string

Filter records with current_milestone_name value equal to any of the provided values

filter[current_milestone_name_ncontains]

string

Filter records with current_milestone_name value not containing all provided values

filter[current_milestone_name_contains]

string

Filter records with current_milestone_name value containing any of the provided values

filter[current_milestone_name_lte]

string

Filter records with current_milestone_name value equal to or less than provided value

filter[current_milestone_name_lt]

string

Filter records with current_milestone_name value less than provided value

filter[current_milestone_name_gte]

string

Filter records with current_milestone_name value equal to or greater than provided value

filter[current_milestone_name_gt]

string

Filter records with current_milestone_name value greater than provided value

filter[current_milestone_status_neq]

string

Filter records with current_milestone_status value not equal to all provided values

filter[current_milestone_status_eq]

string

Filter records with current_milestone_status value equal to any of the provided values

filter[current_milestone_status_ncontains]

string

Filter records with current_milestone_status value not containing all provided values

filter[current_milestone_status_contains]

string

Filter records with current_milestone_status value containing any of the provided values

filter[current_milestone_status_lte]

string

Filter records with current_milestone_status value equal to or less than provided value

filter[current_milestone_status_lt]

string

Filter records with current_milestone_status value less than provided value

filter[current_milestone_status_gte]

string

Filter records with current_milestone_status value equal to or greater than provided value

filter[current_milestone_status_gt]

string

Filter records with current_milestone_status value greater than provided value

filter[current_milestone_type_neq]

string

Filter records with current_milestone_type value not equal to all provided values

filter[current_milestone_type_eq]

string

Filter records with current_milestone_type value equal to any of the provided values

filter[current_milestone_type_ncontains]

string

Filter records with current_milestone_type value not containing all provided values

filter[current_milestone_type_contains]

string

Filter records with current_milestone_type value containing any of the provided values

filter[current_milestone_type_lte]

string

Filter records with current_milestone_type value equal to or less than provided value

filter[current_milestone_type_lt]

string

Filter records with current_milestone_type value less than provided value

filter[current_milestone_type_gte]

string

Filter records with current_milestone_type value equal to or greater than provided value

filter[current_milestone_type_gt]

string

Filter records with current_milestone_type value greater than provided value

filter[description_neq]

string

Filter records with description value not equal to all provided values

filter[description_eq]

string

Filter records with description value equal to any of the provided values

filter[description_ncontains]

string

Filter records with description value not containing all provided values

filter[description_contains]

string

Filter records with description value containing any of the provided values

filter[description_lte]

string

Filter records with description value equal to or less than provided value

filter[description_lt]

string

Filter records with description value less than provided value

filter[description_gte]

string

Filter records with description value equal to or greater than provided value

filter[description_gt]

string

Filter records with description value greater than provided value

filter[directory_supplier_id_neq]

string

Filter records with directory_supplier_id value not equal to all provided values

filter[directory_supplier_id_eq]

string

Filter records with directory_supplier_id value equal to any of the provided values

filter[directory_supplier_id_lte]

string

Filter records with directory_supplier_id value equal to or less than provided value

filter[directory_supplier_id_lt]

string

Filter records with directory_supplier_id value less than provided value

filter[directory_supplier_id_gte]

string

Filter records with directory_supplier_id value equal to or greater than provided value

filter[directory_supplier_id_gt]

string

Filter records with directory_supplier_id value greater than provided value

filter[effective_ship_date_neq]

string

Filter records with effective_ship_date value not equal to all provided values

filter[effective_ship_date_eq]

string

Filter records with effective_ship_date value equal to any of the provided values

filter[effective_ship_date_lte]

string

Filter records with effective_ship_date value equal to or less than provided value

filter[effective_ship_date_lt]

string

Filter records with effective_ship_date value less than provided value

filter[effective_ship_date_gte]

string

Filter records with effective_ship_date value equal to or greater than provided value

filter[effective_ship_date_gt]

string

Filter records with effective_ship_date value greater than provided value

filter[estimated_cargo_ready_date_neq]

string

Filter records with estimated_cargo_ready_date value not equal to all provided values

filter[estimated_cargo_ready_date_eq]

string

Filter records with estimated_cargo_ready_date value equal to any of the provided values

filter[estimated_cargo_ready_date_lte]

string

Filter records with estimated_cargo_ready_date value equal to or less than provided value

filter[estimated_cargo_ready_date_lt]

string

Filter records with estimated_cargo_ready_date value less than provided value

filter[estimated_cargo_ready_date_gte]

string

Filter records with estimated_cargo_ready_date value equal to or greater than provided value

filter[estimated_cargo_ready_date_gt]

string

Filter records with estimated_cargo_ready_date value greater than provided value

filter[estimated_delivery_date_neq]

string

Filter records with estimated_delivery_date value not equal to all provided values

filter[estimated_delivery_date_eq]

string

Filter records with estimated_delivery_date value equal to any of the provided values

filter[estimated_delivery_date_lte]

string

Filter records with estimated_delivery_date value equal to or less than provided value

filter[estimated_delivery_date_lt]

string

Filter records with estimated_delivery_date value less than provided value

filter[estimated_delivery_date_gte]

string

Filter records with estimated_delivery_date value equal to or greater than provided value

filter[estimated_delivery_date_gt]

string

Filter records with estimated_delivery_date value greater than provided value

filter[estimated_payment_due_date_neq]

string

Filter records with estimated_payment_due_date value not equal to all provided values

filter[estimated_payment_due_date_eq]

string

Filter records with estimated_payment_due_date value equal to any of the provided values

filter[estimated_payment_due_date_lte]

string

Filter records with estimated_payment_due_date value equal to or less than provided value

filter[estimated_payment_due_date_lt]

string

Filter records with estimated_payment_due_date value less than provided value

filter[estimated_payment_due_date_gte]

string

Filter records with estimated_payment_due_date value equal to or greater than provided value

filter[estimated_payment_due_date_gt]

string

Filter records with estimated_payment_due_date value greater than provided value

filter[estimated_production_end_date_neq]

string

Filter records with estimated_production_end_date value not equal to all provided values

filter[estimated_production_end_date_eq]

string

Filter records with estimated_production_end_date value equal to any of the provided values

filter[estimated_production_end_date_lte]

string

Filter records with estimated_production_end_date value equal to or less than provided value

filter[estimated_production_end_date_lt]

string

Filter records with estimated_production_end_date value less than provided value

filter[estimated_production_end_date_gte]

string

Filter records with estimated_production_end_date value equal to or greater than provided value

filter[estimated_production_end_date_gt]

string

Filter records with estimated_production_end_date value greater than provided value

filter[estimated_production_start_date_neq]

string

Filter records with estimated_production_start_date value not equal to all provided values

filter[estimated_production_start_date_eq]

string

Filter records with estimated_production_start_date value equal to any of the provided values

filter[estimated_production_start_date_lte]

string

Filter records with estimated_production_start_date value equal to or less than provided value

filter[estimated_production_start_date_lt]

string

Filter records with estimated_production_start_date value less than provided value

filter[estimated_production_start_date_gte]

string

Filter records with estimated_production_start_date value equal to or greater than provided value

filter[estimated_production_start_date_gt]

string

Filter records with estimated_production_start_date value greater than provided value

filter[estimated_received_date_neq]

string

Filter records with estimated_received_date value not equal to all provided values

filter[estimated_received_date_eq]

string

Filter records with estimated_received_date value equal to any of the provided values

filter[estimated_received_date_lte]

string

Filter records with estimated_received_date value equal to or less than provided value

filter[estimated_received_date_lt]

string

Filter records with estimated_received_date value less than provided value

filter[estimated_received_date_gte]

string

Filter records with estimated_received_date value equal to or greater than provided value

filter[estimated_received_date_gt]

string

Filter records with estimated_received_date value greater than provided value

filter[estimated_ship_date_neq]

string

Filter records with estimated_ship_date value not equal to all provided values

filter[estimated_ship_date_eq]

string

Filter records with estimated_ship_date value equal to any of the provided values

filter[estimated_ship_date_lte]

string

Filter records with estimated_ship_date value equal to or less than provided value

filter[estimated_ship_date_lt]

string

Filter records with estimated_ship_date value less than provided value

filter[estimated_ship_date_gte]

string

Filter records with estimated_ship_date value equal to or greater than provided value

filter[estimated_ship_date_gt]

string

Filter records with estimated_ship_date value greater than provided value

filter[exact_quantities_shipped_neq]

string

Filter records with exact_quantities_shipped value not equal to all provided values

filter[exact_quantities_shipped_eq]

string

Filter records with exact_quantities_shipped value equal to any of the provided values

filter[fulfilled_percent_neq]

string

Filter records with fulfilled_percent value not equal to all provided values

filter[fulfilled_percent_eq]

string

Filter records with fulfilled_percent value equal to any of the provided values

filter[fulfilled_percent_lte]

string

Filter records with fulfilled_percent value equal to or less than provided value

filter[fulfilled_percent_lt]

string

Filter records with fulfilled_percent value less than provided value

filter[fulfilled_percent_gte]

string

Filter records with fulfilled_percent value equal to or greater than provided value

filter[fulfilled_percent_gt]

string

Filter records with fulfilled_percent value greater than provided value

filter[hts_code_neq]

string

Filter records with hts_code value not equal to all provided values

filter[hts_code_eq]

string

Filter records with hts_code value equal to any of the provided values

filter[hts_code_ncontains]

string

Filter records with hts_code value not containing all provided values

filter[hts_code_contains]

string

Filter records with hts_code value containing any of the provided values

filter[hts_code_lte]

string

Filter records with hts_code value equal to or less than provided value

filter[hts_code_lt]

string

Filter records with hts_code value less than provided value

filter[hts_code_gte]

string

Filter records with hts_code value equal to or greater than provided value

filter[hts_code_gt]

string

Filter records with hts_code value greater than provided value

filter[incoterms_neq]

string

Filter records with incoterms value not equal to all provided values

filter[incoterms_eq]

string

Filter records with incoterms value equal to any of the provided values

filter[incoterms_ncontains]

string

Filter records with incoterms value not containing all provided values

filter[incoterms_contains]

string

Filter records with incoterms value containing any of the provided values

filter[incoterms_lte]

string

Filter records with incoterms value equal to or less than provided value

filter[incoterms_lt]

string

Filter records with incoterms value less than provided value

filter[incoterms_gte]

string

Filter records with incoterms value equal to or greater than provided value

filter[incoterms_gt]

string

Filter records with incoterms value greater than provided value

filter[invoiced_quantity_neq]

string

Filter records with invoiced_quantity value not equal to all provided values

filter[invoiced_quantity_eq]

string

Filter records with invoiced_quantity value equal to any of the provided values

filter[invoiced_quantity_lte]

string

Filter records with invoiced_quantity value equal to or less than provided value

filter[invoiced_quantity_lt]

string

Filter records with invoiced_quantity value less than provided value

filter[invoiced_quantity_gte]

string

Filter records with invoiced_quantity value equal to or greater than provided value

filter[invoiced_quantity_gt]

string

Filter records with invoiced_quantity value greater than provided value

filter[invoiced_total_neq]

string

Filter records with invoiced_total value not equal to all provided values

filter[invoiced_total_eq]

string

Filter records with invoiced_total value equal to any of the provided values

filter[invoiced_total_lte]

string

Filter records with invoiced_total value equal to or less than provided value

filter[invoiced_total_lt]

string

Filter records with invoiced_total value less than provided value

filter[invoiced_total_gte]

string

Filter records with invoiced_total value equal to or greater than provided value

filter[invoiced_total_gt]

string

Filter records with invoiced_total value greater than provided value

filter[invoiced_unit_prices_neq]

string

Filter records with invoiced_unit_prices value not equal to all provided values

filter[invoiced_unit_prices_eq]

string

Filter records with invoiced_unit_prices value equal to any of the provided values

filter[invoiced_unit_prices_lte]

string

Filter records with invoiced_unit_prices value equal to or less than provided value

filter[invoiced_unit_prices_lt]

string

Filter records with invoiced_unit_prices value less than provided value

filter[invoiced_unit_prices_gte]

string

Filter records with invoiced_unit_prices value equal to or greater than provided value

filter[invoiced_unit_prices_gt]

string

Filter records with invoiced_unit_prices value greater than provided value

filter[isbn_neq]

string

Filter records with isbn value not equal to all provided values

filter[isbn_eq]

string

Filter records with isbn value equal to any of the provided values

filter[isbn_ncontains]

string

Filter records with isbn value not containing all provided values

filter[isbn_contains]

string

Filter records with isbn value containing any of the provided values

filter[isbn_lte]

string

Filter records with isbn value equal to or less than provided value

filter[isbn_lt]

string

Filter records with isbn value less than provided value

filter[isbn_gte]

string

Filter records with isbn value equal to or greater than provided value

filter[isbn_gt]

string

Filter records with isbn value greater than provided value

filter[last_po_issued_date_neq]

string

Filter records with last_po_issued_date value not equal to all provided values

filter[last_po_issued_date_eq]

string

Filter records with last_po_issued_date value equal to any of the provided values

filter[last_po_issued_date_lte]

string

Filter records with last_po_issued_date value equal to or less than provided value

filter[last_po_issued_date_lt]

string

Filter records with last_po_issued_date value less than provided value

filter[last_po_issued_date_gte]

string

Filter records with last_po_issued_date value equal to or greater than provided value

filter[last_po_issued_date_gt]

string

Filter records with last_po_issued_date value greater than provided value

filter[last_po_revision_date_neq]

string

Filter records with last_po_revision_date value not equal to all provided values

filter[last_po_revision_date_eq]

string

Filter records with last_po_revision_date value equal to any of the provided values

filter[last_po_revision_date_lte]

string

Filter records with last_po_revision_date value equal to or less than provided value

filter[last_po_revision_date_lt]

string

Filter records with last_po_revision_date value less than provided value

filter[last_po_revision_date_gte]

string

Filter records with last_po_revision_date value equal to or greater than provided value

filter[last_po_revision_date_gt]

string

Filter records with last_po_revision_date value greater than provided value

filter[lead_time_neq]

string

Filter records with lead_time value not equal to all provided values

filter[lead_time_eq]

string

Filter records with lead_time value equal to any of the provided values

filter[lead_time_lte]

string

Filter records with lead_time value equal to or less than provided value

filter[lead_time_lt]

string

Filter records with lead_time value less than provided value

filter[lead_time_gte]

string

Filter records with lead_time value equal to or greater than provided value

filter[lead_time_gt]

string

Filter records with lead_time value greater than provided value

filter[notes_neq]

string

Filter records with notes value not equal to all provided values

filter[notes_eq]

string

Filter records with notes value equal to any of the provided values

filter[notes_ncontains]

string

Filter records with notes value not containing all provided values

filter[notes_contains]

string

Filter records with notes value containing any of the provided values

filter[notes_lte]

string

Filter records with notes value equal to or less than provided value

filter[notes_lt]

string

Filter records with notes value less than provided value

filter[notes_gte]

string

Filter records with notes value equal to or greater than provided value

filter[notes_gt]

string

Filter records with notes value greater than provided value

filter[number_of_estimated_ship_date_changes_neq]

string

Filter records with number_of_estimated_ship_date_changes value not equal to all provided values

filter[number_of_estimated_ship_date_changes_eq]

string

Filter records with number_of_estimated_ship_date_changes value equal to any of the provided values

filter[number_of_estimated_ship_date_changes_lte]

string

Filter records with number_of_estimated_ship_date_changes value equal to or less than provided value

filter[number_of_estimated_ship_date_changes_lt]

string

Filter records with number_of_estimated_ship_date_changes value less than provided value

filter[number_of_estimated_ship_date_changes_gte]

string

Filter records with number_of_estimated_ship_date_changes value equal to or greater than provided value

filter[number_of_estimated_ship_date_changes_gt]

string

Filter records with number_of_estimated_ship_date_changes value greater than provided value

filter[number_of_part_items_in_order_neq]

string

Filter records with number_of_part_items_in_order value not equal to all provided values

filter[number_of_part_items_in_order_eq]

string

Filter records with number_of_part_items_in_order value equal to any of the provided values

filter[number_of_part_items_in_order_lte]

string

Filter records with number_of_part_items_in_order value equal to or less than provided value

filter[number_of_part_items_in_order_lt]

string

Filter records with number_of_part_items_in_order value less than provided value

filter[number_of_part_items_in_order_gte]

string

Filter records with number_of_part_items_in_order value equal to or greater than provided value

filter[number_of_part_items_in_order_gt]

string

Filter records with number_of_part_items_in_order value greater than provided value

filter[number_of_production_start_date_changes_neq]

string

Filter records with number_of_production_start_date_changes value not equal to all provided values

filter[number_of_production_start_date_changes_eq]

string

Filter records with number_of_production_start_date_changes value equal to any of the provided values

filter[number_of_production_start_date_changes_lte]

string

Filter records with number_of_production_start_date_changes value equal to or less than provided value

filter[number_of_production_start_date_changes_lt]

string

Filter records with number_of_production_start_date_changes value less than provided value

filter[number_of_production_start_date_changes_gte]

string

Filter records with number_of_production_start_date_changes value equal to or greater than provided value

filter[number_of_production_start_date_changes_gt]

string

Filter records with number_of_production_start_date_changes value greater than provided value

filter[order_currency_neq]

string

Filter records with order_currency value not equal to all provided values

filter[order_currency_eq]

string

Filter records with order_currency value equal to any of the provided values

filter[order_currency_ncontains]

string

Filter records with order_currency value not containing all provided values

filter[order_currency_contains]

string

Filter records with order_currency value containing any of the provided values

filter[order_currency_lte]

string

Filter records with order_currency value equal to or less than provided value

filter[order_currency_lt]

string

Filter records with order_currency value less than provided value

filter[order_currency_gte]

string

Filter records with order_currency value equal to or greater than provided value

filter[order_currency_gt]

string

Filter records with order_currency value greater than provided value

filter[order_id_neq]

string

Filter records with order_id value not equal to all provided values

filter[order_id_eq]

string

Filter records with order_id value equal to any of the provided values

filter[order_id_lte]

string

Filter records with order_id value equal to or less than provided value

filter[order_id_lt]

string

Filter records with order_id value less than provided value

filter[order_id_gte]

string

Filter records with order_id value equal to or greater than provided value

filter[order_id_gt]

string

Filter records with order_id value greater than provided value

filter[order_item_id_neq]

string

Filter records with order_item_id value not equal to all provided values

filter[order_item_id_eq]

string

Filter records with order_item_id value equal to any of the provided values

filter[order_item_id_lte]

string

Filter records with order_item_id value equal to or less than provided value

filter[order_item_id_lt]

string

Filter records with order_item_id value less than provided value

filter[order_item_id_gte]

string

Filter records with order_item_id value equal to or greater than provided value

filter[order_item_id_gt]

string

Filter records with order_item_id value greater than provided value

filter[order_ship_status_neq]

string

Filter records with order_ship_status value not equal to all provided values

filter[order_ship_status_eq]

string

Filter records with order_ship_status value equal to any of the provided values

filter[order_ship_status_ncontains]

string

Filter records with order_ship_status value not containing all provided values

filter[order_ship_status_contains]

string

Filter records with order_ship_status value containing any of the provided values

filter[order_ship_status_lte]

string

Filter records with order_ship_status value equal to or less than provided value

filter[order_ship_status_lt]

string

Filter records with order_ship_status value less than provided value

filter[order_ship_status_gte]

string

Filter records with order_ship_status value equal to or greater than provided value

filter[order_ship_status_gt]

string

Filter records with order_ship_status value greater than provided value

filter[order_tags_neq]

string

Filter records with order_tags value not equal to all provided values

filter[order_tags_eq]

string

Filter records with order_tags value equal to any of the provided values

filter[order_tags_ncontains]

string

Filter records with order_tags value not containing all provided values

filter[order_tags_contains]

string

Filter records with order_tags value containing any of the provided values

filter[order_tags_lte]

string

Filter records with order_tags value equal to or less than provided value

filter[order_tags_lt]

string

Filter records with order_tags value less than provided value

filter[order_tags_gte]

string

Filter records with order_tags value equal to or greater than provided value

filter[order_tags_gt]

string

Filter records with order_tags value greater than provided value

filter[original_freight_quote_neq]

string

Filter records with original_freight_quote value not equal to all provided values

filter[original_freight_quote_eq]

string

Filter records with original_freight_quote value equal to any of the provided values

filter[original_freight_quote_lte]

string

Filter records with original_freight_quote value equal to or less than provided value

filter[original_freight_quote_lt]

string

Filter records with original_freight_quote value less than provided value

filter[original_freight_quote_gte]

string

Filter records with original_freight_quote value equal to or greater than provided value

filter[original_freight_quote_gt]

string

Filter records with original_freight_quote value greater than provided value

filter[part_id_neq]

string

Filter records with part_id value not equal to all provided values

filter[part_id_eq]

string

Filter records with part_id value equal to any of the provided values

filter[part_id_lte]

string

Filter records with part_id value equal to or less than provided value

filter[part_id_lt]

string

Filter records with part_id value less than provided value

filter[part_id_gte]

string

Filter records with part_id value equal to or greater than provided value

filter[part_id_gt]

string

Filter records with part_id value greater than provided value

filter[part_name_neq]

string

Filter records with part_name value not equal to all provided values

filter[part_name_eq]

string

Filter records with part_name value equal to any of the provided values

filter[part_name_ncontains]

string

Filter records with part_name value not containing all provided values

filter[part_name_contains]

string

Filter records with part_name value containing any of the provided values

filter[part_name_lte]

string

Filter records with part_name value equal to or less than provided value

filter[part_name_lt]

string

Filter records with part_name value less than provided value

filter[part_name_gte]

string

Filter records with part_name value equal to or greater than provided value

filter[part_name_gt]

string

Filter records with part_name value greater than provided value

filter[part_number_neq]

string

Filter records with part_number value not equal to all provided values

filter[part_number_eq]

string

Filter records with part_number value equal to any of the provided values

filter[part_number_ncontains]

string

Filter records with part_number value not containing all provided values

filter[part_number_contains]

string

Filter records with part_number value containing any of the provided values

filter[part_number_lte]

string

Filter records with part_number value equal to or less than provided value

filter[part_number_lt]

string

Filter records with part_number value less than provided value

filter[part_number_gte]

string

Filter records with part_number value equal to or greater than provided value

filter[part_number_gt]

string

Filter records with part_number value greater than provided value

filter[part_status_neq]

string

Filter records with part_status value not equal to all provided values

filter[part_status_eq]

string

Filter records with part_status value equal to any of the provided values

filter[part_status_ncontains]

string

Filter records with part_status value not containing all provided values

filter[part_status_contains]

string

Filter records with part_status value containing any of the provided values

filter[part_status_lte]

string

Filter records with part_status value equal to or less than provided value

filter[part_status_lt]

string

Filter records with part_status value less than provided value

filter[part_status_gte]

string

Filter records with part_status value equal to or greater than provided value

filter[part_status_gt]

string

Filter records with part_status value greater than provided value

filter[part_tags_neq]

string

Filter records with part_tags value not equal to all provided values

filter[part_tags_eq]

string

Filter records with part_tags value equal to any of the provided values

filter[part_tags_ncontains]

string

Filter records with part_tags value not containing all provided values

filter[part_tags_contains]

string

Filter records with part_tags value containing any of the provided values

filter[part_tags_lte]

string

Filter records with part_tags value equal to or less than provided value

filter[part_tags_lt]

string

Filter records with part_tags value less than provided value

filter[part_tags_gte]

string

Filter records with part_tags value equal to or greater than provided value

filter[part_tags_gt]

string

Filter records with part_tags value greater than provided value

filter[payment_terms_neq]

string

Filter records with payment_terms value not equal to all provided values

filter[payment_terms_eq]

string

Filter records with payment_terms value equal to any of the provided values

filter[payment_terms_ncontains]

string

Filter records with payment_terms value not containing all provided values

filter[payment_terms_contains]

string

Filter records with payment_terms value containing any of the provided values

filter[payment_terms_lte]

string

Filter records with payment_terms value equal to or less than provided value

filter[payment_terms_lt]

string

Filter records with payment_terms value less than provided value

filter[payment_terms_gte]

string

Filter records with payment_terms value equal to or greater than provided value

filter[payment_terms_gt]

string

Filter records with payment_terms value greater than provided value

filter[po_issued_date_neq]

string

Filter records with po_issued_date value not equal to all provided values

filter[po_issued_date_eq]

string

Filter records with po_issued_date value equal to any of the provided values

filter[po_issued_date_lte]

string

Filter records with po_issued_date value equal to or less than provided value

filter[po_issued_date_lt]

string

Filter records with po_issued_date value less than provided value

filter[po_issued_date_gte]

string

Filter records with po_issued_date value equal to or greater than provided value

filter[po_issued_date_gt]

string

Filter records with po_issued_date value greater than provided value

filter[po_notes_neq]

string

Filter records with po_notes value not equal to all provided values

filter[po_notes_eq]

string

Filter records with po_notes value equal to any of the provided values

filter[po_notes_ncontains]

string

Filter records with po_notes value not containing all provided values

filter[po_notes_contains]

string

Filter records with po_notes value containing any of the provided values

filter[po_notes_lte]

string

Filter records with po_notes value equal to or less than provided value

filter[po_notes_lt]

string

Filter records with po_notes value less than provided value

filter[po_notes_gte]

string

Filter records with po_notes value equal to or greater than provided value

filter[po_notes_gt]

string

Filter records with po_notes value greater than provided value

filter[po_number_neq]

string

Filter records with po_number value not equal to all provided values

filter[po_number_eq]

string

Filter records with po_number value equal to any of the provided values

filter[po_number_ncontains]

string

Filter records with po_number value not containing all provided values

filter[po_number_contains]

string

Filter records with po_number value containing any of the provided values

filter[po_number_lte]

string

Filter records with po_number value equal to or less than provided value

filter[po_number_lt]

string

Filter records with po_number value less than provided value

filter[po_number_gte]

string

Filter records with po_number value equal to or greater than provided value

filter[po_number_gt]

string

Filter records with po_number value greater than provided value

filter[po_status_neq]

string

Filter records with po_status value not equal to all provided values

filter[po_status_eq]

string

Filter records with po_status value equal to any of the provided values

filter[po_status_ncontains]

string

Filter records with po_status value not containing all provided values

filter[po_status_contains]

string

Filter records with po_status value containing any of the provided values

filter[po_status_lte]

string

Filter records with po_status value equal to or less than provided value

filter[po_status_lt]

string

Filter records with po_status value less than provided value

filter[po_status_gte]

string

Filter records with po_status value equal to or greater than provided value

filter[po_status_gt]

string

Filter records with po_status value greater than provided value

filter[production_lead_time_neq]

string

Filter records with production_lead_time value not equal to all provided values

filter[production_lead_time_eq]

string

Filter records with production_lead_time value equal to any of the provided values

filter[production_lead_time_lte]

string

Filter records with production_lead_time value equal to or less than provided value

filter[production_lead_time_lt]

string

Filter records with production_lead_time value less than provided value

filter[production_lead_time_gte]

string

Filter records with production_lead_time value equal to or greater than provided value

filter[production_lead_time_gt]

string

Filter records with production_lead_time value greater than provided value

filter[purchase_order_lead_time_neq]

string

Filter records with purchase_order_lead_time value not equal to all provided values

filter[purchase_order_lead_time_eq]

string

Filter records with purchase_order_lead_time value equal to any of the provided values

filter[purchase_order_lead_time_lte]

string

Filter records with purchase_order_lead_time value equal to or less than provided value

filter[purchase_order_lead_time_lt]

string

Filter records with purchase_order_lead_time value less than provided value

filter[purchase_order_lead_time_gte]

string

Filter records with purchase_order_lead_time value equal to or greater than provided value

filter[purchase_order_lead_time_gt]

string

Filter records with purchase_order_lead_time value greater than provided value

filter[quantity_shipped_neq]

string

Filter records with quantity_shipped value not equal to all provided values

filter[quantity_shipped_eq]

string

Filter records with quantity_shipped value equal to any of the provided values

filter[quantity_shipped_lte]

string

Filter records with quantity_shipped value equal to or less than provided value

filter[quantity_shipped_lt]

string

Filter records with quantity_shipped value less than provided value

filter[quantity_shipped_gte]

string

Filter records with quantity_shipped value equal to or greater than provided value

filter[quantity_shipped_gt]

string

Filter records with quantity_shipped value greater than provided value

filter[quantity_neq]

string

Filter records with quantity value not equal to all provided values

filter[quantity_eq]

string

Filter records with quantity value equal to any of the provided values

filter[quantity_lte]

string

Filter records with quantity value equal to or less than provided value

filter[quantity_lt]

string

Filter records with quantity value less than provided value

filter[quantity_gte]

string

Filter records with quantity value equal to or greater than provided value

filter[quantity_gt]

string

Filter records with quantity value greater than provided value

filter[ship_to_city_neq]

string

Filter records with ship_to_city value not equal to all provided values

filter[ship_to_city_eq]

string

Filter records with ship_to_city value equal to any of the provided values

filter[ship_to_city_ncontains]

string

Filter records with ship_to_city value not containing all provided values

filter[ship_to_city_contains]

string

Filter records with ship_to_city value containing any of the provided values

filter[ship_to_city_lte]

string

Filter records with ship_to_city value equal to or less than provided value

filter[ship_to_city_lt]

string

Filter records with ship_to_city value less than provided value

filter[ship_to_city_gte]

string

Filter records with ship_to_city value equal to or greater than provided value

filter[ship_to_city_gt]

string

Filter records with ship_to_city value greater than provided value

filter[ship_to_contact_email_neq]

string

Filter records with ship_to_contact_email value not equal to all provided values

filter[ship_to_contact_email_eq]

string

Filter records with ship_to_contact_email value equal to any of the provided values

filter[ship_to_contact_email_ncontains]

string

Filter records with ship_to_contact_email value not containing all provided values

filter[ship_to_contact_email_contains]

string

Filter records with ship_to_contact_email value containing any of the provided values

filter[ship_to_contact_email_lte]

string

Filter records with ship_to_contact_email value equal to or less than provided value

filter[ship_to_contact_email_lt]

string

Filter records with ship_to_contact_email value less than provided value

filter[ship_to_contact_email_gte]

string

Filter records with ship_to_contact_email value equal to or greater than provided value

filter[ship_to_contact_email_gt]

string

Filter records with ship_to_contact_email value greater than provided value

filter[ship_to_contact_name_neq]

string

Filter records with ship_to_contact_name value not equal to all provided values

filter[ship_to_contact_name_eq]

string

Filter records with ship_to_contact_name value equal to any of the provided values

filter[ship_to_contact_name_ncontains]

string

Filter records with ship_to_contact_name value not containing all provided values

filter[ship_to_contact_name_contains]

string

Filter records with ship_to_contact_name value containing any of the provided values

filter[ship_to_contact_name_lte]

string

Filter records with ship_to_contact_name value equal to or less than provided value

filter[ship_to_contact_name_lt]

string

Filter records with ship_to_contact_name value less than provided value

filter[ship_to_contact_name_gte]

string

Filter records with ship_to_contact_name value equal to or greater than provided value

filter[ship_to_contact_name_gt]

string

Filter records with ship_to_contact_name value greater than provided value

filter[ship_to_contact_phone_neq]

string

Filter records with ship_to_contact_phone value not equal to all provided values

filter[ship_to_contact_phone_eq]

string

Filter records with ship_to_contact_phone value equal to any of the provided values

filter[ship_to_contact_phone_ncontains]

string

Filter records with ship_to_contact_phone value not containing all provided values

filter[ship_to_contact_phone_contains]

string

Filter records with ship_to_contact_phone value containing any of the provided values

filter[ship_to_contact_phone_lte]

string

Filter records with ship_to_contact_phone value equal to or less than provided value

filter[ship_to_contact_phone_lt]

string

Filter records with ship_to_contact_phone value less than provided value

filter[ship_to_contact_phone_gte]

string

Filter records with ship_to_contact_phone value equal to or greater than provided value

filter[ship_to_contact_phone_gt]

string

Filter records with ship_to_contact_phone value greater than provided value

filter[ship_to_country_neq]

string

Filter records with ship_to_country value not equal to all provided values

filter[ship_to_country_eq]

string

Filter records with ship_to_country value equal to any of the provided values

filter[ship_to_country_ncontains]

string

Filter records with ship_to_country value not containing all provided values

filter[ship_to_country_contains]

string

Filter records with ship_to_country value containing any of the provided values

filter[ship_to_country_lte]

string

Filter records with ship_to_country value equal to or less than provided value

filter[ship_to_country_lt]

string

Filter records with ship_to_country value less than provided value

filter[ship_to_country_gte]

string

Filter records with ship_to_country value equal to or greater than provided value

filter[ship_to_country_gt]

string

Filter records with ship_to_country value greater than provided value

filter[ship_to_location_name_neq]

string

Filter records with ship_to_location_name value not equal to all provided values

filter[ship_to_location_name_eq]

string

Filter records with ship_to_location_name value equal to any of the provided values

filter[ship_to_location_name_ncontains]

string

Filter records with ship_to_location_name value not containing all provided values

filter[ship_to_location_name_contains]

string

Filter records with ship_to_location_name value containing any of the provided values

filter[ship_to_location_name_lte]

string

Filter records with ship_to_location_name value equal to or less than provided value

filter[ship_to_location_name_lt]

string

Filter records with ship_to_location_name value less than provided value

filter[ship_to_location_name_gte]

string

Filter records with ship_to_location_name value equal to or greater than provided value

filter[ship_to_location_name_gt]

string

Filter records with ship_to_location_name value greater than provided value

filter[ship_to_postal_code_neq]

string

Filter records with ship_to_postal_code value not equal to all provided values

filter[ship_to_postal_code_eq]

string

Filter records with ship_to_postal_code value equal to any of the provided values

filter[ship_to_postal_code_ncontains]

string

Filter records with ship_to_postal_code value not containing all provided values

filter[ship_to_postal_code_contains]

string

Filter records with ship_to_postal_code value containing any of the provided values

filter[ship_to_postal_code_lte]

string

Filter records with ship_to_postal_code value equal to or less than provided value

filter[ship_to_postal_code_lt]

string

Filter records with ship_to_postal_code value less than provided value

filter[ship_to_postal_code_gte]

string

Filter records with ship_to_postal_code value equal to or greater than provided value

filter[ship_to_postal_code_gt]

string

Filter records with ship_to_postal_code value greater than provided value

filter[ship_to_state_neq]

string

Filter records with ship_to_state value not equal to all provided values

filter[ship_to_state_eq]

string

Filter records with ship_to_state value equal to any of the provided values

filter[ship_to_state_ncontains]

string

Filter records with ship_to_state value not containing all provided values

filter[ship_to_state_contains]

string

Filter records with ship_to_state value containing any of the provided values

filter[ship_to_state_lte]

string

Filter records with ship_to_state value equal to or less than provided value

filter[ship_to_state_lt]

string

Filter records with ship_to_state value less than provided value

filter[ship_to_state_gte]

string

Filter records with ship_to_state value equal to or greater than provided value

filter[ship_to_state_gt]

string

Filter records with ship_to_state value greater than provided value

filter[shipment_actual_delivery_date_neq]

string

Filter records with shipment_actual_delivery_date value not equal to all provided values

filter[shipment_actual_delivery_date_eq]

string

Filter records with shipment_actual_delivery_date value equal to any of the provided values

filter[shipment_actual_delivery_date_lte]

string

Filter records with shipment_actual_delivery_date value equal to or less than provided value

filter[shipment_actual_delivery_date_lt]

string

Filter records with shipment_actual_delivery_date value less than provided value

filter[shipment_actual_delivery_date_gte]

string

Filter records with shipment_actual_delivery_date value equal to or greater than provided value

filter[shipment_actual_delivery_date_gt]

string

Filter records with shipment_actual_delivery_date value greater than provided value

filter[shipment_actual_ship_date_neq]

string

Filter records with shipment_actual_ship_date value not equal to all provided values

filter[shipment_actual_ship_date_eq]

string

Filter records with shipment_actual_ship_date value equal to any of the provided values

filter[shipment_actual_ship_date_lte]

string

Filter records with shipment_actual_ship_date value equal to or less than provided value

filter[shipment_actual_ship_date_lt]

string

Filter records with shipment_actual_ship_date value less than provided value

filter[shipment_actual_ship_date_gte]

string

Filter records with shipment_actual_ship_date value equal to or greater than provided value

filter[shipment_actual_ship_date_gt]

string

Filter records with shipment_actual_ship_date value greater than provided value

filter[shipment_address_line1_neq]

string

Filter records with shipment_address_line1 value not equal to all provided values

filter[shipment_address_line1_eq]

string

Filter records with shipment_address_line1 value equal to any of the provided values

filter[shipment_address_line1_ncontains]

string

Filter records with shipment_address_line1 value not containing all provided values

filter[shipment_address_line1_contains]

string

Filter records with shipment_address_line1 value containing any of the provided values

filter[shipment_address_line1_lte]

string

Filter records with shipment_address_line1 value equal to or less than provided value

filter[shipment_address_line1_lt]

string

Filter records with shipment_address_line1 value less than provided value

filter[shipment_address_line1_gte]

string

Filter records with shipment_address_line1 value equal to or greater than provided value

filter[shipment_address_line1_gt]

string

Filter records with shipment_address_line1 value greater than provided value

filter[shipment_address_line2_neq]

string

Filter records with shipment_address_line2 value not equal to all provided values

filter[shipment_address_line2_eq]

string

Filter records with shipment_address_line2 value equal to any of the provided values

filter[shipment_address_line2_ncontains]

string

Filter records with shipment_address_line2 value not containing all provided values

filter[shipment_address_line2_contains]

string

Filter records with shipment_address_line2 value containing any of the provided values

filter[shipment_address_line2_lte]

string

Filter records with shipment_address_line2 value equal to or less than provided value

filter[shipment_address_line2_lt]

string

Filter records with shipment_address_line2 value less than provided value

filter[shipment_address_line2_gte]

string

Filter records with shipment_address_line2 value equal to or greater than provided value

filter[shipment_address_line2_gt]

string

Filter records with shipment_address_line2 value greater than provided value

filter[shipment_city_neq]

string

Filter records with shipment_city value not equal to all provided values

filter[shipment_city_eq]

string

Filter records with shipment_city value equal to any of the provided values

filter[shipment_city_ncontains]

string

Filter records with shipment_city value not containing all provided values

filter[shipment_city_contains]

string

Filter records with shipment_city value containing any of the provided values

filter[shipment_city_lte]

string

Filter records with shipment_city value equal to or less than provided value

filter[shipment_city_lt]

string

Filter records with shipment_city value less than provided value

filter[shipment_city_gte]

string

Filter records with shipment_city value equal to or greater than provided value

filter[shipment_city_gt]

string

Filter records with shipment_city value greater than provided value

filter[shipment_company_line1_neq]

string

Filter records with shipment_company_line1 value not equal to all provided values

filter[shipment_company_line1_eq]

string

Filter records with shipment_company_line1 value equal to any of the provided values

filter[shipment_company_line1_ncontains]

string

Filter records with shipment_company_line1 value not containing all provided values

filter[shipment_company_line1_contains]

string

Filter records with shipment_company_line1 value containing any of the provided values

filter[shipment_company_line1_lte]

string

Filter records with shipment_company_line1 value equal to or less than provided value

filter[shipment_company_line1_lt]

string

Filter records with shipment_company_line1 value less than provided value

filter[shipment_company_line1_gte]

string

Filter records with shipment_company_line1 value equal to or greater than provided value

filter[shipment_company_line1_gt]

string

Filter records with shipment_company_line1 value greater than provided value

filter[shipment_company_line2_neq]

string

Filter records with shipment_company_line2 value not equal to all provided values

filter[shipment_company_line2_eq]

string

Filter records with shipment_company_line2 value equal to any of the provided values

filter[shipment_company_line2_ncontains]

string

Filter records with shipment_company_line2 value not containing all provided values

filter[shipment_company_line2_contains]

string

Filter records with shipment_company_line2 value containing any of the provided values

filter[shipment_company_line2_lte]

string

Filter records with shipment_company_line2 value equal to or less than provided value

filter[shipment_company_line2_lt]

string

Filter records with shipment_company_line2 value less than provided value

filter[shipment_company_line2_gte]

string

Filter records with shipment_company_line2 value equal to or greater than provided value

filter[shipment_company_line2_gt]

string

Filter records with shipment_company_line2 value greater than provided value

filter[shipment_consolidation_count_neq]

string

Filter records with shipment_consolidation_count value not equal to all provided values

filter[shipment_consolidation_count_eq]

string

Filter records with shipment_consolidation_count value equal to any of the provided values

filter[shipment_consolidation_count_lte]

string

Filter records with shipment_consolidation_count value equal to or less than provided value

filter[shipment_consolidation_count_lt]

string

Filter records with shipment_consolidation_count value less than provided value

filter[shipment_consolidation_count_gte]

string

Filter records with shipment_consolidation_count value equal to or greater than provided value

filter[shipment_consolidation_count_gt]

string

Filter records with shipment_consolidation_count value greater than provided value

filter[shipment_consolidation_id_neq]

string

Filter records with shipment_consolidation_id value not equal to all provided values

filter[shipment_consolidation_id_eq]

string

Filter records with shipment_consolidation_id value equal to any of the provided values

filter[shipment_consolidation_id_lte]

string

Filter records with shipment_consolidation_id value equal to or less than provided value

filter[shipment_consolidation_id_lt]

string

Filter records with shipment_consolidation_id value less than provided value

filter[shipment_consolidation_id_gte]

string

Filter records with shipment_consolidation_id value equal to or greater than provided value

filter[shipment_consolidation_id_gt]

string

Filter records with shipment_consolidation_id value greater than provided value

filter[shipment_consolidation_order_id_neq]

string

Filter records with shipment_consolidation_order_id value not equal to all provided values

filter[shipment_consolidation_order_id_eq]

string

Filter records with shipment_consolidation_order_id value equal to any of the provided values

filter[shipment_consolidation_order_id_lte]

string

Filter records with shipment_consolidation_order_id value equal to or less than provided value

filter[shipment_consolidation_order_id_lt]

string

Filter records with shipment_consolidation_order_id value less than provided value

filter[shipment_consolidation_order_id_gte]

string

Filter records with shipment_consolidation_order_id value equal to or greater than provided value

filter[shipment_consolidation_order_id_gt]

string

Filter records with shipment_consolidation_order_id value greater than provided value

filter[shipment_consolidation_order_item_id_neq]

string

Filter records with shipment_consolidation_order_item_id value not equal to all provided values

filter[shipment_consolidation_order_item_id_eq]

string

Filter records with shipment_consolidation_order_item_id value equal to any of the provided values

filter[shipment_consolidation_order_item_id_lte]

string

Filter records with shipment_consolidation_order_item_id value equal to or less than provided value

filter[shipment_consolidation_order_item_id_lt]

string

Filter records with shipment_consolidation_order_item_id value less than provided value

filter[shipment_consolidation_order_item_id_gte]

string

Filter records with shipment_consolidation_order_item_id value equal to or greater than provided value

filter[shipment_consolidation_order_item_id_gt]

string

Filter records with shipment_consolidation_order_item_id value greater than provided value

filter[shipment_contact_name_neq]

string

Filter records with shipment_contact_name value not equal to all provided values

filter[shipment_contact_name_eq]

string

Filter records with shipment_contact_name value equal to any of the provided values

filter[shipment_contact_name_ncontains]

string

Filter records with shipment_contact_name value not containing all provided values

filter[shipment_contact_name_contains]

string

Filter records with shipment_contact_name value containing any of the provided values

filter[shipment_contact_name_lte]

string

Filter records with shipment_contact_name value equal to or less than provided value

filter[shipment_contact_name_lt]

string

Filter records with shipment_contact_name value less than provided value

filter[shipment_contact_name_gte]

string

Filter records with shipment_contact_name value equal to or greater than provided value

filter[shipment_contact_name_gt]

string

Filter records with shipment_contact_name value greater than provided value

filter[shipment_cost_neq]

string

Filter records with shipment_cost value not equal to all provided values

filter[shipment_cost_eq]

string

Filter records with shipment_cost value equal to any of the provided values

filter[shipment_cost_lte]

string

Filter records with shipment_cost value equal to or less than provided value

filter[shipment_cost_lt]

string

Filter records with shipment_cost value less than provided value

filter[shipment_cost_gte]

string

Filter records with shipment_cost value equal to or greater than provided value

filter[shipment_cost_gt]

string

Filter records with shipment_cost value greater than provided value

filter[shipment_country_neq]

string

Filter records with shipment_country value not equal to all provided values

filter[shipment_country_eq]

string

Filter records with shipment_country value equal to any of the provided values

filter[shipment_country_ncontains]

string

Filter records with shipment_country value not containing all provided values

filter[shipment_country_contains]

string

Filter records with shipment_country value containing any of the provided values

filter[shipment_country_lte]

string

Filter records with shipment_country value equal to or less than provided value

filter[shipment_country_lt]

string

Filter records with shipment_country value less than provided value

filter[shipment_country_gte]

string

Filter records with shipment_country value equal to or greater than provided value

filter[shipment_country_gt]

string

Filter records with shipment_country value greater than provided value

filter[shipment_email_neq]

string

Filter records with shipment_email value not equal to all provided values

filter[shipment_email_eq]

string

Filter records with shipment_email value equal to any of the provided values

filter[shipment_email_ncontains]

string

Filter records with shipment_email value not containing all provided values

filter[shipment_email_contains]

string

Filter records with shipment_email value containing any of the provided values

filter[shipment_email_lte]

string

Filter records with shipment_email value equal to or less than provided value

filter[shipment_email_lt]

string

Filter records with shipment_email value less than provided value

filter[shipment_email_gte]

string

Filter records with shipment_email value equal to or greater than provided value

filter[shipment_email_gt]

string

Filter records with shipment_email value greater than provided value

filter[shipment_estimated_delivery_date_neq]

string

Filter records with shipment_estimated_delivery_date value not equal to all provided values

filter[shipment_estimated_delivery_date_eq]

string

Filter records with shipment_estimated_delivery_date value equal to any of the provided values

filter[shipment_estimated_delivery_date_lte]

string

Filter records with shipment_estimated_delivery_date value equal to or less than provided value

filter[shipment_estimated_delivery_date_lt]

string

Filter records with shipment_estimated_delivery_date value less than provided value

filter[shipment_estimated_delivery_date_gte]

string

Filter records with shipment_estimated_delivery_date value equal to or greater than provided value

filter[shipment_estimated_delivery_date_gt]

string

Filter records with shipment_estimated_delivery_date value greater than provided value

filter[shipment_estimated_ship_date_neq]

string

Filter records with shipment_estimated_ship_date value not equal to all provided values

filter[shipment_estimated_ship_date_eq]

string

Filter records with shipment_estimated_ship_date value equal to any of the provided values

filter[shipment_estimated_ship_date_lte]

string

Filter records with shipment_estimated_ship_date value equal to or less than provided value

filter[shipment_estimated_ship_date_lt]

string

Filter records with shipment_estimated_ship_date value less than provided value

filter[shipment_estimated_ship_date_gte]

string

Filter records with shipment_estimated_ship_date value equal to or greater than provided value

filter[shipment_estimated_ship_date_gt]

string

Filter records with shipment_estimated_ship_date value greater than provided value

filter[shipment_location_name_neq]

string

Filter records with shipment_location_name value not equal to all provided values

filter[shipment_location_name_eq]

string

Filter records with shipment_location_name value equal to any of the provided values

filter[shipment_location_name_ncontains]

string

Filter records with shipment_location_name value not containing all provided values

filter[shipment_location_name_contains]

string

Filter records with shipment_location_name value containing any of the provided values

filter[shipment_location_name_lte]

string

Filter records with shipment_location_name value equal to or less than provided value

filter[shipment_location_name_lt]

string

Filter records with shipment_location_name value less than provided value

filter[shipment_location_name_gte]

string

Filter records with shipment_location_name value equal to or greater than provided value

filter[shipment_location_name_gt]

string

Filter records with shipment_location_name value greater than provided value

filter[shipment_notes_neq]

string

Filter records with shipment_notes value not equal to all provided values

filter[shipment_notes_eq]

string

Filter records with shipment_notes value equal to any of the provided values

filter[shipment_notes_ncontains]

string

Filter records with shipment_notes value not containing all provided values

filter[shipment_notes_contains]

string

Filter records with shipment_notes value containing any of the provided values

filter[shipment_notes_lte]

string

Filter records with shipment_notes value equal to or less than provided value

filter[shipment_notes_lt]

string

Filter records with shipment_notes value less than provided value

filter[shipment_notes_gte]

string

Filter records with shipment_notes value equal to or greater than provided value

filter[shipment_notes_gt]

string

Filter records with shipment_notes value greater than provided value

filter[shipment_number_neq]

string

Filter records with shipment_number value not equal to all provided values

filter[shipment_number_eq]

string

Filter records with shipment_number value equal to any of the provided values

filter[shipment_number_ncontains]

string

Filter records with shipment_number value not containing all provided values

filter[shipment_number_contains]

string

Filter records with shipment_number value containing any of the provided values

filter[shipment_number_lte]

string

Filter records with shipment_number value equal to or less than provided value

filter[shipment_number_lt]

string

Filter records with shipment_number value less than provided value

filter[shipment_number_gte]

string

Filter records with shipment_number value equal to or greater than provided value

filter[shipment_number_gt]

string

Filter records with shipment_number value greater than provided value

filter[shipment_phone_neq]

string

Filter records with shipment_phone value not equal to all provided values

filter[shipment_phone_eq]

string

Filter records with shipment_phone value equal to any of the provided values

filter[shipment_phone_ncontains]

string

Filter records with shipment_phone value not containing all provided values

filter[shipment_phone_contains]

string

Filter records with shipment_phone value containing any of the provided values

filter[shipment_phone_lte]

string

Filter records with shipment_phone value equal to or less than provided value

filter[shipment_phone_lt]

string

Filter records with shipment_phone value less than provided value

filter[shipment_phone_gte]

string

Filter records with shipment_phone value equal to or greater than provided value

filter[shipment_phone_gt]

string

Filter records with shipment_phone value greater than provided value

filter[shipment_postal_code_neq]

string

Filter records with shipment_postal_code value not equal to all provided values

filter[shipment_postal_code_eq]

string

Filter records with shipment_postal_code value equal to any of the provided values

filter[shipment_postal_code_ncontains]

string

Filter records with shipment_postal_code value not containing all provided values

filter[shipment_postal_code_contains]

string

Filter records with shipment_postal_code value containing any of the provided values

filter[shipment_postal_code_lte]

string

Filter records with shipment_postal_code value equal to or less than provided value

filter[shipment_postal_code_lt]

string

Filter records with shipment_postal_code value less than provided value

filter[shipment_postal_code_gte]

string

Filter records with shipment_postal_code value equal to or greater than provided value

filter[shipment_postal_code_gt]

string

Filter records with shipment_postal_code value greater than provided value

filter[shipment_state_neq]

string

Filter records with shipment_state value not equal to all provided values

filter[shipment_state_eq]

string

Filter records with shipment_state value equal to any of the provided values

filter[shipment_state_ncontains]

string

Filter records with shipment_state value not containing all provided values

filter[shipment_state_contains]

string

Filter records with shipment_state value containing any of the provided values

filter[shipment_state_lte]

string

Filter records with shipment_state value equal to or less than provided value

filter[shipment_state_lt]

string

Filter records with shipment_state value less than provided value

filter[shipment_state_gte]

string

Filter records with shipment_state value equal to or greater than provided value

filter[shipment_state_gt]

string

Filter records with shipment_state value greater than provided value

filter[shipping_method_neq]

string

Filter records with shipping_method value not equal to all provided values

filter[shipping_method_eq]

string

Filter records with shipping_method value equal to any of the provided values

filter[shipping_method_ncontains]

string

Filter records with shipping_method value not containing all provided values

filter[shipping_method_contains]

string

Filter records with shipping_method value containing any of the provided values

filter[shipping_method_lte]

string

Filter records with shipping_method value equal to or less than provided value

filter[shipping_method_lt]

string

Filter records with shipping_method value less than provided value

filter[shipping_method_gte]

string

Filter records with shipping_method value equal to or greater than provided value

filter[shipping_method_gt]

string

Filter records with shipping_method value greater than provided value

filter[ships_on_at_po_acceptance_neq]

string

Filter records with ships_on_at_po_acceptance value not equal to all provided values

filter[ships_on_at_po_acceptance_eq]

string

Filter records with ships_on_at_po_acceptance value equal to any of the provided values

filter[ships_on_at_po_acceptance_lte]

string

Filter records with ships_on_at_po_acceptance value equal to or less than provided value

filter[ships_on_at_po_acceptance_lt]

string

Filter records with ships_on_at_po_acceptance value less than provided value

filter[ships_on_at_po_acceptance_gte]

string

Filter records with ships_on_at_po_acceptance value equal to or greater than provided value

filter[ships_on_at_po_acceptance_gt]

string

Filter records with ships_on_at_po_acceptance value greater than provided value

filter[supplier_city_neq]

string

Filter records with supplier_city value not equal to all provided values

filter[supplier_city_eq]

string

Filter records with supplier_city value equal to any of the provided values

filter[supplier_city_ncontains]

string

Filter records with supplier_city value not containing all provided values

filter[supplier_city_contains]

string

Filter records with supplier_city value containing any of the provided values

filter[supplier_city_lte]

string

Filter records with supplier_city value equal to or less than provided value

filter[supplier_city_lt]

string

Filter records with supplier_city value less than provided value

filter[supplier_city_gte]

string

Filter records with supplier_city value equal to or greater than provided value

filter[supplier_city_gt]

string

Filter records with supplier_city value greater than provided value

filter[supplier_country_neq]

string

Filter records with supplier_country value not equal to all provided values

filter[supplier_country_eq]

string

Filter records with supplier_country value equal to any of the provided values

filter[supplier_country_ncontains]

string

Filter records with supplier_country value not containing all provided values

filter[supplier_country_contains]

string

Filter records with supplier_country value containing any of the provided values

filter[supplier_country_lte]

string

Filter records with supplier_country value equal to or less than provided value

filter[supplier_country_lt]

string

Filter records with supplier_country value less than provided value

filter[supplier_country_gte]

string

Filter records with supplier_country value equal to or greater than provided value

filter[supplier_country_gt]

string

Filter records with supplier_country value greater than provided value

filter[supplier_name_neq]

string

Filter records with supplier_name value not equal to all provided values

filter[supplier_name_eq]

string

Filter records with supplier_name value equal to any of the provided values

filter[supplier_name_ncontains]

string

Filter records with supplier_name value not containing all provided values

filter[supplier_name_contains]

string

Filter records with supplier_name value containing any of the provided values

filter[supplier_name_lte]

string

Filter records with supplier_name value equal to or less than provided value

filter[supplier_name_lt]

string

Filter records with supplier_name value less than provided value

filter[supplier_name_gte]

string

Filter records with supplier_name value equal to or greater than provided value

filter[supplier_name_gt]

string

Filter records with supplier_name value greater than provided value

filter[supplier_postal_code_neq]

string

Filter records with supplier_postal_code value not equal to all provided values

filter[supplier_postal_code_eq]

string

Filter records with supplier_postal_code value equal to any of the provided values

filter[supplier_postal_code_ncontains]

string

Filter records with supplier_postal_code value not containing all provided values

filter[supplier_postal_code_contains]

string

Filter records with supplier_postal_code value containing any of the provided values

filter[supplier_postal_code_lte]

string

Filter records with supplier_postal_code value equal to or less than provided value

filter[supplier_postal_code_lt]

string

Filter records with supplier_postal_code value less than provided value

filter[supplier_postal_code_gte]

string

Filter records with supplier_postal_code value equal to or greater than provided value

filter[supplier_postal_code_gt]

string

Filter records with supplier_postal_code value greater than provided value

filter[supplier_state_neq]

string

Filter records with supplier_state value not equal to all provided values

filter[supplier_state_eq]

string

Filter records with supplier_state value equal to any of the provided values

filter[supplier_state_ncontains]

string

Filter records with supplier_state value not containing all provided values

filter[supplier_state_contains]

string

Filter records with supplier_state value containing any of the provided values

filter[supplier_state_lte]

string

Filter records with supplier_state value equal to or less than provided value

filter[supplier_state_lt]

string

Filter records with supplier_state value less than provided value

filter[supplier_state_gte]

string

Filter records with supplier_state value equal to or greater than provided value

filter[supplier_state_gt]

string

Filter records with supplier_state value greater than provided value

filter[target_delivery_date_neq]

string

Filter records with target_delivery_date value not equal to all provided values

filter[target_delivery_date_eq]

string

Filter records with target_delivery_date value equal to any of the provided values

filter[target_delivery_date_lte]

string

Filter records with target_delivery_date value equal to or less than provided value

filter[target_delivery_date_lt]

string

Filter records with target_delivery_date value less than provided value

filter[target_delivery_date_gte]

string

Filter records with target_delivery_date value equal to or greater than provided value

filter[target_delivery_date_gt]

string

Filter records with target_delivery_date value greater than provided value

filter[target_ship_date_neq]

string

Filter records with target_ship_date value not equal to all provided values

filter[target_ship_date_eq]

string

Filter records with target_ship_date value equal to any of the provided values

filter[target_ship_date_lte]

string

Filter records with target_ship_date value equal to or less than provided value

filter[target_ship_date_lt]

string

Filter records with target_ship_date value less than provided value

filter[target_ship_date_gte]

string

Filter records with target_ship_date value equal to or greater than provided value

filter[target_ship_date_gt]

string

Filter records with target_ship_date value greater than provided value

filter[team_name_neq]

string

Filter records with team_name value not equal to all provided values

filter[team_name_eq]

string

Filter records with team_name value equal to any of the provided values

filter[team_name_ncontains]

string

Filter records with team_name value not containing all provided values

filter[team_name_contains]

string

Filter records with team_name value containing any of the provided values

filter[team_name_lte]

string

Filter records with team_name value equal to or less than provided value

filter[team_name_lt]

string

Filter records with team_name value less than provided value

filter[team_name_gte]

string

Filter records with team_name value equal to or greater than provided value

filter[team_name_gt]

string

Filter records with team_name value greater than provided value

filter[total_order_cost_neq]

string

Filter records with total_order_cost value not equal to all provided values

filter[total_order_cost_eq]

string

Filter records with total_order_cost value equal to any of the provided values

filter[total_order_cost_lte]

string

Filter records with total_order_cost value equal to or less than provided value

filter[total_order_cost_lt]

string

Filter records with total_order_cost value less than provided value

filter[total_order_cost_gte]

string

Filter records with total_order_cost value equal to or greater than provided value

filter[total_order_cost_gt]

string

Filter records with total_order_cost value greater than provided value

filter[total_other_item_cost_neq]

string

Filter records with total_other_item_cost value not equal to all provided values

filter[total_other_item_cost_eq]

string

Filter records with total_other_item_cost value equal to any of the provided values

filter[total_other_item_cost_lte]

string

Filter records with total_other_item_cost value equal to or less than provided value

filter[total_other_item_cost_lt]

string

Filter records with total_other_item_cost value less than provided value

filter[total_other_item_cost_gte]

string

Filter records with total_other_item_cost value equal to or greater than provided value

filter[total_other_item_cost_gt]

string

Filter records with total_other_item_cost value greater than provided value

filter[total_part_cost_neq]

string

Filter records with total_part_cost value not equal to all provided values

filter[total_part_cost_eq]

string

Filter records with total_part_cost value equal to any of the provided values

filter[total_part_cost_lte]

string

Filter records with total_part_cost value equal to or less than provided value

filter[total_part_cost_lt]

string

Filter records with total_part_cost value less than provided value

filter[total_part_cost_gte]

string

Filter records with total_part_cost value equal to or greater than provided value

filter[total_part_cost_gt]

string

Filter records with total_part_cost value greater than provided value

filter[total_part_quantity_neq]

string

Filter records with total_part_quantity value not equal to all provided values

filter[total_part_quantity_eq]

string

Filter records with total_part_quantity value equal to any of the provided values

filter[total_part_quantity_lte]

string

Filter records with total_part_quantity value equal to or less than provided value

filter[total_part_quantity_lt]

string

Filter records with total_part_quantity value less than provided value

filter[total_part_quantity_gte]

string

Filter records with total_part_quantity value equal to or greater than provided value

filter[total_part_quantity_gt]

string

Filter records with total_part_quantity value greater than provided value

filter[transit_lead_time_neq]

string

Filter records with transit_lead_time value not equal to all provided values

filter[transit_lead_time_eq]

string

Filter records with transit_lead_time value equal to any of the provided values

filter[transit_lead_time_lte]

string

Filter records with transit_lead_time value equal to or less than provided value

filter[transit_lead_time_lt]

string

Filter records with transit_lead_time value less than provided value

filter[transit_lead_time_gte]

string

Filter records with transit_lead_time value equal to or greater than provided value

filter[transit_lead_time_gt]

string

Filter records with transit_lead_time value greater than provided value

filter[unit_of_measure_neq]

string

Filter records with unit_of_measure value not equal to all provided values

filter[unit_of_measure_eq]

string

Filter records with unit_of_measure value equal to any of the provided values

filter[unit_of_measure_ncontains]

string

Filter records with unit_of_measure value not containing all provided values

filter[unit_of_measure_contains]

string

Filter records with unit_of_measure value containing any of the provided values

filter[unit_of_measure_lte]

string

Filter records with unit_of_measure value equal to or less than provided value

filter[unit_of_measure_lt]

string

Filter records with unit_of_measure value less than provided value

filter[unit_of_measure_gte]

string

Filter records with unit_of_measure value equal to or greater than provided value

filter[unit_of_measure_gt]

string

Filter records with unit_of_measure value greater than provided value

filter[unit_price_neq]

string

Filter records with unit_price value not equal to all provided values

filter[unit_price_eq]

string

Filter records with unit_price value equal to any of the provided values

filter[unit_price_lte]

string

Filter records with unit_price value equal to or less than provided value

filter[unit_price_lt]

string

Filter records with unit_price value less than provided value

filter[unit_price_gte]

string

Filter records with unit_price value equal to or greater than provided value

filter[unit_price_gt]

string

Filter records with unit_price value greater than provided value

filter[upc_neq]

string

Filter records with upc value not equal to all provided values

filter[upc_eq]

string

Filter records with upc value equal to any of the provided values

filter[upc_ncontains]

string

Filter records with upc value not containing all provided values

filter[upc_contains]

string

Filter records with upc value containing any of the provided values

filter[upc_lte]

string

Filter records with upc value equal to or less than provided value

filter[upc_lt]

string

Filter records with upc value less than provided value

filter[upc_gte]

string

Filter records with upc value equal to or greater than provided value

filter[upc_gt]

string

Filter records with upc value greater than provided value

filter[vessel_number_neq]

string

Filter records with vessel_number value not equal to all provided values

filter[vessel_number_eq]

string

Filter records with vessel_number value equal to any of the provided values

filter[vessel_number_ncontains]

string

Filter records with vessel_number value not containing all provided values

filter[vessel_number_contains]

string

Filter records with vessel_number value containing any of the provided values

filter[vessel_number_lte]

string

Filter records with vessel_number value equal to or less than provided value

filter[vessel_number_lt]

string

Filter records with vessel_number value less than provided value

filter[vessel_number_gte]

string

Filter records with vessel_number value equal to or greater than provided value

filter[vessel_number_gt]

string

Filter records with vessel_number value greater than provided value

filter[workflow_name_neq]

string

Filter records with workflow_name value not equal to all provided values

filter[workflow_name_eq]

string

Filter records with workflow_name value equal to any of the provided values

filter[workflow_name_ncontains]

string

Filter records with workflow_name value not containing all provided values

filter[workflow_name_contains]

string

Filter records with workflow_name value containing any of the provided values

filter[workflow_name_lte]

string

Filter records with workflow_name value equal to or less than provided value

filter[workflow_name_lt]

string

Filter records with workflow_name value less than provided value

filter[workflow_name_gte]

string

Filter records with workflow_name value equal to or greater than provided value

filter[workflow_name_gt]

string

Filter records with workflow_name value greater than provided value

filter[workflow_state_neq]

string

Filter records with workflow_state value not equal to all provided values

filter[workflow_state_eq]

string

Filter records with workflow_state value equal to any of the provided values

filter[workflow_state_ncontains]

string

Filter records with workflow_state value not containing all provided values

filter[workflow_state_contains]

string

Filter records with workflow_state value containing any of the provided values

filter[workflow_state_lte]

string

Filter records with workflow_state value equal to or less than provided value

filter[workflow_state_lt]

string

Filter records with workflow_state value less than provided value

filter[workflow_state_gte]

string

Filter records with workflow_state value equal to or greater than provided value

filter[workflow_state_gt]

string

Filter records with workflow_state value greater than provided value

filter[workflow_version_neq]

string

Filter records with workflow_version value not equal to all provided values

filter[workflow_version_eq]

string

Filter records with workflow_version value equal to any of the provided values

filter[workflow_version_lte]

string

Filter records with workflow_version value equal to or less than provided value

filter[workflow_version_lt]

string

Filter records with workflow_version value less than provided value

filter[workflow_version_gte]

string

Filter records with workflow_version value equal to or greater than provided value

filter[workflow_version_gt]

string

Filter records with workflow_version value greater than provided value

Response

200Get reporting records for order items