# Get All Work Orders

Get All Work Orders

Endpoint: POST /v1/api/pub/order/projects/query
Version: 1.0
Security: Authorization

## Request fields (*/*):

  - `facilities` (array)

  - `accounts` (array)

  - `items` (array)

  - `lots` (array)

  - `sublots` (array)

  - `channels` (array)

  - `orderNumber` (string)

  - `poNumber` (string)

  - `soNumber` (string)

  - `transNumber` (string)

  - `assocOrderTransNumber` (string)

  - `carriers` (array)

  - `statuses` (array)
    Enum: "PENDING", "INTRANSIT", "OPEN", "HOLD", "WAITING_PUTAWAY", "PUTTINGAWAY", "PUTAWAY", "WAITING_RESERVE", "RESERVED", "WAITING_PICK", "PICKING", "PICKED", "WAITING_ROUTED", "ROUTED", "WAITING_PACKED", "PACKING", "PACKED", "WAITING_LABELED", "LABELING", "LABELED", "WAITING_STAGED", "STAGING", "STAGED", "WAITING_LOADED", "LOADING", "LOADED", "COMPLETED", "EDISENT", "EDIRECV", "BILLING_PENDING", "INVOICE_PENDING", "INVOICE_APPROVALPENDING", "INVOICED", "CANCELED", "VOID"

  - `createdonFrom` (string)

  - `createdonTo` (string)

  - `completedonFrom` (string)

  - `completedonTo` (string)

## Response 200 fields (application/json):

  - `id` (string)

  - `orderhdr_id` (string)

  - `order_number` (string)

  - `po_number` (string)

  - `assoc_orderhdr_id` (string)

  - `hdr` (object)

  - `hdr.createdby` (string)

  - `hdr.createdon` (string)

  - `hdr.modifiedon` (string)

  - `hdr.trans_number` (string)

  - `hdr.account_id` (string)

  - `hdr.internalstatus` (string)
    Enum: "PENDING", "INTRANSIT", "OPEN", "HOLD", "WAITING_PUTAWAY", "PUTTINGAWAY", "PUTAWAY", "WAITING_RESERVE", "RESERVED", "WAITING_PICK", "PICKING", "PICKED", "WAITING_ROUTED", "ROUTED", "WAITING_PACKED", "PACKING", "PACKED", "WAITING_LABELED", "LABELING", "LABELED", "WAITING_STAGED", "STAGING", "STAGED", "WAITING_LOADED", "LOADING", "LOADED", "COMPLETED", "EDISENT", "EDIRECV", "BILLING_PENDING", "INVOICE_PENDING", "INVOICE_APPROVALPENDING", "INVOICED", "CANCELED", "VOID"

  - `hdr.internaltype` (string)
    Enum: "PO", "RECEIPT", "RETURN", "TRANSFER", "PROJECT", "ORDER", "SHIPMENT"

  - `hdr.priority` (string)
    Enum: "LOW", "NORMAL", "HIGH"

  - `hdr.Facility Requested` (string)
    With Distributed Order Management, this value is optional.  Without Distibuted Order Management, this value is required

  - `hdr.requestedcompdt` (string)

  - `hdr.actualcompdt` (string)

  - `hdr.sourcetxt` (string)

  - `hdr.Channel` (string, required)
    The Channel associated with the order, including if this channel is Manual Data Entry

  - `hdr.country_flag` (string)

  - `hdr.account` (object)

  - `hdr.account.enabled` (boolean)

  - `hdr.account.ship_strategy` (string)
    Enum: "ALLOW_SHORT_SHIP", "SHIP_COMPLETE"

  - `hdr.account.ship_create_backorders` (boolean)

  - `hdr.account.ship_po_required` (boolean)

  - `hdr.account.ship_order_number_required` (boolean)

  - `hdr.account.ship_so_required` (boolean)

  - `hdr.account.ship_carrier_required` (boolean)

  - `hdr.account.ship_labels_required` (boolean)

  - `hdr.account.ship_email_packing_slip` (boolean)

  - `hdr.account.ship_email_bol` (boolean)

  - `hdr.account.ship_email_labels` (boolean)

  - `hdr.account.ship_udef0` (string)

  - `hdr.account.ship_udef1` (string)

  - `hdr.account.ship_udef2` (string)

  - `hdr.account.ship_udef3` (string)

  - `hdr.account.ship_udef4` (string)

  - `hdr.account.ship_udef5` (string)

  - `hdr.account.ship_udef6` (string)

  - `hdr.account.ship_udef7` (string)

  - `hdr.account.ship_udef8` (string)

  - `hdr.account.recv_po_required` (boolean)

  - `hdr.account.recv_order_number_required` (boolean)

  - `hdr.account.recv_carrier_required` (boolean)

  - `hdr.account.recv_container_required` (boolean)

  - `hdr.account.recv_email_receipt` (boolean)

  - `hdr.account.recv_udef0` (string)

  - `hdr.account.recv_udef1` (string)

  - `hdr.account.recv_udef2` (string)

  - `hdr.account.recv_udef3` (string)

  - `hdr.account.recv_udef4` (string)

  - `hdr.account.recv_udef5` (string)

  - `hdr.account.recv_udef6` (string)

  - `hdr.account.recv_udef7` (string)

  - `hdr.account.recv_udef8` (string)

  - `hdr.account.work_udef0` (string)

  - `hdr.account.work_udef1` (string)

  - `hdr.account.work_udef2` (string)

  - `hdr.account.work_udef3` (string)

  - `hdr.account.work_udef4` (string)

  - `hdr.account.work_udef5` (string)

  - `hdr.account.work_udef6` (string)

  - `hdr.account.work_udef7` (string)

  - `hdr.account.work_udef8` (string)

  - `hdr.account.account_base` (object)

  - `hdr.account.account_base.ncode` (integer)

  - `hdr.account.account_base.accountid` (string)

  - `hdr.account.account_base.nodelete` (boolean)

  - `hdr.account.account_base.type` (string)
    Enum: "ACCOUNT", "SHIPTO", "CARRIER", "SUPPLIER", "BILLTO", "CONTACT", "INVOICETO", "PURCHASEDBY"

  - `hdr.account.account_base.name` (string)

  - `hdr.account.account_base.description` (string)

  - `hdr.account.account_base.notes` (string)

  - `hdr.account.account_base.saddr1` (string)

  - `hdr.account.account_base.saddr2` (string)

  - `hdr.account.account_base.saddr3` (string)

  - `hdr.account.account_base.saddr4` (string)

  - `hdr.account.account_base.scity` (string)

  - `hdr.account.account_base.sstateprovince` (string)

  - `hdr.account.account_base.spostalcode` (string)

  - `hdr.account.account_base.scountry` (string)

  - `hdr.account.account_base.maddr1` (string)

  - `hdr.account.account_base.maddr2` (string)

  - `hdr.account.account_base.maddr3` (string)

  - `hdr.account.account_base.maddr4` (string)

  - `hdr.account.account_base.mcity` (string)

  - `hdr.account.account_base.mstateprovince` (string)

  - `hdr.account.account_base.mpostalcode` (string)

  - `hdr.account.account_base.mcountry` (string)

  - `hdr.account.account_base.contact_name` (string)

  - `hdr.account.account_base.contact_phone` (string)

  - `hdr.account.account_base.contact_email` (string)

  - `hdr.account.account_base.inv_contact_name` (string)

  - `hdr.account.account_base.inv_contact_phone` (string)

  - `hdr.account.account_base.inv_contact_email` (string)

  - `hdr.facility_requested` (object)

  - `hdr.facility_requested.code` (string)

  - `hdr.facility_requested.accounting_ref` (string)

  - `hdr.facility_requested.address1` (string)

  - `hdr.facility_requested.address2` (string)

  - `hdr.facility_requested.address3` (string)

  - `hdr.facility_requested.address4` (string)

  - `hdr.facility_requested.city` (string)

  - `hdr.facility_requested.state_province` (string)

  - `hdr.facility_requested.postal_code` (string)

  - `hdr.facility_requested.country` (string)

  - `hdr.channel` (object)

  - `hdr.channel.tmplt_id` (string)

  - `hdr.channel.tmplt` (object)

  - `hdr.channel.tmplt.print_packing_slip` (boolean)

  - `hdr.channel.tmplt.allow_facility_mods` (boolean)

  - `hdr.channel.tmplt.reserve_inv_qty` (number)

  - `hdr.channel.tmplt.sync_943` (boolean)

  - `hdr.channel.tmplt.confirm_944` (boolean)

  - `hdr.channel.tmplt.confirm_945` (boolean)

  - `hdr.channel.tmplt.sync_inventory` (boolean)

  - `hdr.channel.tmplt.sync_item_codes` (boolean)

  - `hdr.channel.channel_facility` (object)

  - `hdr.channel.channel_facility.channel_id` (string)

  - `hdr.channel.channel_facility.facility_id` (string)

  - `hdr.channel.channel_facility.transit_lane_id` (string)

  - `hdr.channel.channel_facility.facility_alias` (string)

  - `hdr.channel.channel_facility.facility_integration_alias` (string)

  - `hdr.channel.channel_facility.facility_api_alias` (string)

  - `hdr.channel.channel_facility.cutoff_time` (string)

  - `hdr.channel.channel_facility.sync_inventory_level_percent` (number)

  - `hdr.channel.channel_facility.rtn_add_name` (string)

  - `hdr.channel.channel_facility.rtn_add_addr1` (string)

  - `hdr.channel.channel_facility.rtn_add_addr2` (string)

  - `hdr.channel.channel_facility.rtn_add_addr3` (string)

  - `hdr.channel.channel_facility.rtn_add_addr4` (string)

  - `hdr.channel.channel_facility.rtn_add_city` (string)

  - `hdr.channel.channel_facility.rtn_add_state_province` (string)

  - `hdr.channel.channel_facility.rtn_add_postal_code` (string)

  - `hdr.channel.channel_facility.rtn_add_country` (string)

  - `hdr.channel.channel_facility.rtn_add_contact_name` (string)

  - `hdr.channel.channel_facility.rtn_add_contact_phone` (string)

  - `hdr.channel.channel_facility.rtn_add_contact_email` (string)

  - `hdr.channel.channel_facility.carriers` (array)

  - `hdr.channel.channel_facility.carriers.carrier_id` (string)

  - `hdr.channel.channel_facility.carriers.rm` (number)

  - `hdr.channel.channel_facility.carriers.carrier` (object)

  - `hdr.channel.channel_facility.carriers.carrier.alias` (string)

  - `hdr.channel.channel_facility.carriers.carrier.subtype` (string)
    Enum: "FedEx", "UPS", "USPS", "OnTrac", "DHL"

  - `hdr.channel.channel_facility.carriers.carrier.package_type` (string)

  - `hdr.channel.channel_facility.carriers.carrier.service_level` (string)

  - `hdr.channel.channel_facility.facility` (object)

  - `assoc_hdr` (object)

  - `lines` (array)

  - `lines.status` (string)
    Enum: "PENDING", "OPEN", "HOLD", "PROCESSING", "WAITING", "COMPLETED", "BILLING_PENDING", "INVOICE_PENDING", "INVOICE_APPROVALPENDING", "INVOICED", "CANCELED", "VOID"

  - `lines.porder_line_id` (string)

  - `lines.order_line_alloc_id` (string)

  - `lines.item_planned_id` (string)

  - `lines.item_id` (string)

  - `lines.lpn_id` (string)

  - `lines.facilitylocation_id` (string)

  - `lines.internalinvstatus` (string)
    Enum: "FOREIGNENTITY", "PICKEDUP", "INTRANSITRECEIVE", "INGATE", "UNLOADED", "QC", "ONHAND", "SAFETY", "ONHANDBYPASSPUTAWAY", "RESERVEDWITHORDER", "RESERVEDWITHOUTORDER", "SCRAP", "DAMAGED", "HOLD", "QUARANTINE", "INPROJECT", "ALLOCATED", "LOADED", "SHIPPED", "OUTGATE", "INTRANSITSHIP", "DELIVERED"

  - `lines.reservedfor_id` (string)

  - `lines.reservedfor_channel_id` (string)

  - `lines.invresv_mode` (string)
    Enum: "HOLDMANUAL", "HOLDHOLD", "RESVORDERAUTO", "RESVWAVEAUTO", "RESVCLUSTERAUTO", "RESVZONEAUTO"

  - `lines.invputaway_flow` (string)
    Enum: "LPNMANUALSELECT", "LPNAUTOSELECT", "CLUSTERMANUALSELECT", "CLUSTERAUTOSELECT"

  - `lines.sscc` (string)

  - `lines.lotcode` (string)

  - `lines.sublotcode` (string)

  - `lines.wtin` (number)

  - `lines.wtout` (number)

  - `lines.wt_mode` (string)
    Enum: "LBS", "KGS"

  - `lines.expirydate` (string)

  - `lines.snin` (string)

  - `lines.snout` (string)

  - `lines.tempin` (number)

  - `lines.tempout` (number)

  - `lines.temp_mode` (string)
    Enum: "F", "C"

  - `lines.qty_pcs_total_planned` (number)

  - `lines.qty_pcs_total_completed` (number)

  - `lines.qty_pcs` (number)

  - `lines.qty_cases` (number)

  - `lines.case_pack` (number)

  - `lines.qty_ip` (number)

  - `lines.ip_pack` (number)

  - `lines.cost` (number)

  - `lines.cost_denom_id` (string)

  - `lines.price` (number)

  - `lines.price_denom_id` (string)

  - `lines.udef0` (string)

  - `lines.udef1` (string)

  - `lines.udef2` (string)

  - `lines.udef3` (string)

  - `lines.udef4` (string)

  - `lines.udef5` (string)

  - `lines.udef6` (string)

  - `lines.udef7` (string)

  - `lines.udef8` (string)

  - `lines.udef9` (string)

  - `lines.udef10` (string)

  - `lines.udef11` (string)

  - `lines.udef12` (string)

  - `lines.udef13` (string)

  - `lines.udef14` (string)

  - `lines.asn0` (string)

  - `lines.asn1` (string)

  - `lines.asn2` (string)

  - `lines.asn3` (string)

  - `lines.asn4` (string)

  - `lines.asn5` (string)

  - `lines.asn6` (string)

  - `lines.asn7` (string)

  - `lines.asn8` (string)

  - `lines.asn9` (string)

  - `lines.asn10` (string)

  - `lines.asn11` (string)

  - `lines.asn12` (string)

  - `lines.asn13` (string)

  - `lines.asn14` (string)

  - `lines.completed` (boolean)

  - `lines.voided` (boolean)

  - `lines.orderLineAlloc` (object)

  - `lines.orderLineAlloc.alloc_supplier_id` (string)

  - `lines.orderLineAlloc.alloc_reservedfor_id` (string)

  - `lines.orderLineAlloc.alloc_reservedfor_channel_id` (string)

  - `lines.orderLineAlloc.alloc_ohdrrecv_id` (string)

  - `lines.item` (object)

  - `lines.item.itemcode` (string)

  - `lines.item.wt` (number)

  - `lines.item.l` (number)

  - `lines.item.w` (number)

  - `lines.item.h` (number)

  - `lines.item.dim_mode` (string)
    Enum: "INCHES", "FEET", "CM", "METER"

  - `lines.item.image_file_uri` (string)

  - `lines.item.safety_inv_qty` (number)

  - `lines.item.components` (array)

  - `lines.item.components.pitem_id` (string)

  - `lines.item.components.citem_id` (string)

  - `lines.item.components.uom_type` (string)
    Enum: "EACH", "IP", "CASE"

  - `lines.item.components.uom_packfactor` (number)

  - `lines.item.components.lotcode_v` (integer)

  - `lines.item.components.sublotcode_v` (integer)

  - `lines.item.components.udef0_v` (integer)

  - `lines.item.components.udef1_v` (integer)

  - `lines.item.components.udef2_v` (integer)

  - `lines.item.components.udef3_v` (integer)

  - `lines.item.components.udef4_v` (integer)

  - `lines.item.components.udef5_v` (integer)

  - `lines.item.components.udef6_v` (integer)

  - `lines.item.components.udef7_v` (integer)

  - `lines.item.components.udef8_v` (integer)

  - `lines.item.components.udef9_v` (integer)

  - `lines.item.components.udef10_v` (integer)

  - `lines.item.components.udef11_v` (integer)

  - `lines.item.components.udef12_v` (integer)

  - `lines.item.components.udef13_v` (integer)

  - `lines.item.components.udef14_v` (integer)

  - `lines.item.components.subItem` (object)

  - `lines.rmas` (array)

  - `lines.rmas.email` (string)

  - `lines.rmas.return_fee` (number)

  - `lines.rmas.return_fee_denom_id` (string)

  - `lines.rmas.drop_off_method` (string)

  - `lines.rmas.order_id` (string)

  - `lines.rmas.order_order_line_id` (string)

  - `lines.rmas.order_line_return_id` (string)

  - `lines.rmas.reason_code_id` (string)

  - `lines.rmas.msg` (string)

  - `lines.rmas.raddr1` (string)

  - `lines.rmas.raddr2` (string)

  - `lines.rmas.raddr3` (string)

  - `lines.rmas.raddr4` (string)

  - `lines.rmas.rcity` (string)

  - `lines.rmas.rstateprovince` (string)

  - `lines.rmas.rpostalcode` (string)

  - `lines.rmas.rcountry` (string)

  - `lines.rmas.rma_uri` (string)

  - `lines.rmas.qr_code_uri` (string)

  - `lines.invReceived` (array)

  - `lines.invReceived.inv_key_id` (string)

  - `lines.invReceived.cntrl` (string)

  - `lines.invReceived.recv_ts` (string)

  - `lines.invReceived.ship_ts` (string)

  - `lines.invReceived.qty_pcs_total` (number)

  - `lines.invReceived.ohdrrecv_id` (string)

  - `lines.invReceived.olinerecv_id` (string)

  - `lines.invReceived.ohdralloc_id` (string)

  - `lines.invReceived.olinealloc_id` (string)

  - `lines.invReceived.inv_key` (object)

  - `lines.invReceived.inv_key.ikeyhash` (string)

  - `lines.invReceived.inv_key.temp` (number)

  - `lines.invReceived.inv_key.lpn` (object)

  - `lines.invReceived.inv_key.lpn.deletedon` (string)

  - `lines.invReceived.inv_key.lpn.lpn_type_id` (string)

  - `lines.invReceived.inv_key.lpn.plpn_id` (string)

  - `lines.invReceived.inv_key.lpn.pallet` (boolean)

  - `lines.invReceived.inv_key.lpn.parcel_pkg_id` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg` (object)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.order_parcel_id` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.tracking_code` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.label_doc_id` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.label_type` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.err_msg` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.label_doc` (object)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.label_doc.object_type` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.label_doc.object_id` (string)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.label_doc.object_serial` (integer)

  - `lines.invReceived.inv_key.lpn.parcel_pkg.label_doc.uri` (string)

  - `lines.invReceived.inv_key.facilityLocation` (object)

  - `lines.invReceived.inv_key.facilityLocation.locale` (string)
    Enum: "pt_BR", "es_MX", "fr_FR", "en_US", "de_DE", "zh_CN"

  - `lines.invReceived.inv_key.facilityLocation.aisle_details_id` (string)

  - `lines.invReceived.inv_key.facilityLocation.strid` (string)

  - `lines.invReceived.inv_key.facilityLocation.strcd` (string)

  - `lines.invReceived.inv_key.facilityLocation.aislesz` (string)

  - `lines.invReceived.inv_key.facilityLocation.levelsz` (string)

  - `lines.invReceived.inv_key.facilityLocation.slotsz` (string)

  - `lines.invReceived.inv_key.facilityLocation.aisleint` (integer)

  - `lines.invReceived.inv_key.facilityLocation.levelint` (integer)

  - `lines.invReceived.inv_key.facilityLocation.slotint` (integer)

  - `lines.invReceived.inv_key.facilityLocation.belowloc` (string)

  - `lines.invReceived.inv_key.facilityLocation.aboveloc` (string)

  - `lines.invReceived.inv_key.facilityLocation.leftloc` (string)

  - `lines.invReceived.inv_key.facilityLocation.rightloc` (string)

  - `lines.invReceived.inv_key.facilityLocation.frontloc` (string)

  - `lines.invReceived.inv_key.facilityLocation.backloc` (string)

  - `lines.invReceived.inv_key.facilityLocation.coord_x` (number)

  - `lines.invReceived.inv_key.facilityLocation.coord_y` (number)

  - `lines.invReceived.inv_key.facilityLocation.coord_z` (number)

  - `lines.invReceived.inv_key.facilityLocation.subLocations` (array)

  - `lines.invReceived.inv_key.facilityLocation.aisleDetails` (object)

  - `lines.invReceived.inv_key.facilityLocation.aisleDetails.num_hpos` (integer)

  - `lines.invReceived.inv_key.facilityLocation.aisleDetails.num_vpos` (integer)

  - `lines.invReceived.inv_key.reservedFor` (object)

  - `lines.invAllocated` (array)