> For the complete documentation index, see [llms.txt](https://tech.x2bee.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tech.x2bee.com/api/api-en/back-office-api-reference/order-bo-api/order-lookup.md).

# Order Lookup

## Order/Payment > Order Management > Order Lookup

>   \## Function Description\
>   \- Looks up the customer's order list matching the search conditions set in Order Lookup.\
>   \---\
>   \## Detailed Description\
>   The searchable conditions are as follows.\
>   \- Site, order date, vendor no./name, order status, product type, orderer/recipient\
>   \- Order No., product No., product name, order type, channel no./name\
>   \- Delivery type, order media, brand no./name, delivery processing type\
>   \---\
>   \## Revision History\
>   \* Release v2.00\_240711: Nulled delivery address and delivery request notes for ticket products only\
> &#x20; \* Release v2.00\_240711: Added E-coupon number column<br>

```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"OrderQueryRequest":{"type":"object","properties":{"entrNo":{"type":"string","description":"Vendor No."},"dateSelect":{"type":"string"},"statOrdAccpDtm":{"type":"string","format":"date"},"endOrdAccpDtm":{"type":"string","format":"date"},"loginId":{"type":"string"},"ordDtlStatCd":{"type":"string"},"ordNo":{"type":"string"},"ordNoList":{"type":"array","items":{"type":"string"}},"ordSrcCnd":{"type":"string"},"ordererInfo":{"type":"string"},"goodsTypCd":{"type":"string"},"goodsNoSrcCnd":{"type":"string"},"goodsNo":{"type":"string"},"goodsNoList":{"type":"array","items":{"type":"string"}},"statGoodsNo":{"type":"string"},"endGoodsNo":{"type":"string"},"goodsNm":{"type":"string"},"ordGbCd":{"type":"string"},"chlNo":{"type":"string"},"deliKindCd":{"type":"string"},"ordMediaCd":{"type":"string"},"brandNo":{"type":"string"},"deliProcTypCd":{"type":"string"},"frgnDirPurGoodsYn":{"type":"string"}}},"RealGridListResponseOrderQueryResponse":{"type":"object","properties":{"totalCount":{"type":"integer","format":"int32"},"payloads":{"type":"array","items":{"$ref":"#/components/schemas/OrderQueryResponse"}}}},"OrderQueryResponse":{"type":"object","properties":{"siteNo":{"type":"string"},"ordNo":{"type":"string"},"ordGbCdNm":{"type":"string"},"ordAccpDtm":{"type":"string","format":"date-time"},"ordMediaNm":{"type":"string"},"ordManNm":{"type":"string"},"ordDtlGbNm":{"type":"string"},"ordDtlStatNm":{"type":"string"},"ordQty":{"type":"integer","format":"int32"},"cnclQty":{"type":"integer","format":"int32"},"rtnQty":{"type":"integer","format":"int32"},"ordSaleTypNm":{"type":"string"},"goodsTypCd":{"type":"string"},"goodsTypNm":{"type":"string"},"goodsNo":{"type":"string"},"goodsNm":{"type":"string"},"itmNm":{"type":"string"},"ecpnNo":{"type":"string"},"brandNm":{"type":"string"},"norPrc":{"type":"number"},"salePrc":{"type":"number"},"mbrNo":{"type":"string"},"loginId":{"type":"string"},"mbrMgrNm":{"type":"string"},"mbrGradeNm":{"type":"string"},"mgrGbNm":{"type":"string"},"rcvmnNm":{"type":"string"},"zipAddr":{"type":"string"},"dtlAddr":{"type":"string"},"deliMsg":{"type":"string"},"deliProcTypNm":{"type":"string"},"deliMethodNm":{"type":"string"},"siteNm":{"type":"string"},"ordManCellSctNo":{"type":"string"},"ordManCellTxnoNo":{"type":"string"},"ordManCellEndNo":{"type":"string"},"rcvmnCellSctNo":{"type":"string"},"rcvmnCellTxnoNo":{"type":"string"},"rcvmnCellEndNo":{"type":"string"},"entrNm":{"type":"string"},"ordSeq":{"type":"string"},"ordProcSeq":{"type":"string"},"deliSeq":{"type":"string"},"deliDtlStatCd":{"type":"string"},"deliDtlStatCdNm":{"type":"string"},"shipQty":{"type":"integer","format":"int32"},"frgnDirPurGoodsYn":{"type":"string"}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/order/orderQuery/getOrderQueryList":{"get":{"tags":["Order Lookup"],"summary":"Order/Payment > Order Management > Order Lookup","description":"  ## Function Description\n  - Looks up the customer's order list matching the search conditions set in Order Lookup.\n  ---\n  ## Detailed Description\n  The searchable conditions are as follows.\n  - Site, order date, vendor no./name, order status, product type, orderer/recipient\n  - Order No., product No., product name, order type, channel no./name\n  - Delivery type, order media, brand no./name, delivery processing type\n  ---\n  ## Revision History\n  * Release v2.00_240711: Nulled delivery address and delivery request notes for ticket products only\n  * Release v2.00_240711: Added E-coupon number column\n","operationId":"getOrderQueryList","parameters":[{"name":"orderQueryRequest","in":"query","required":true,"schema":{"$ref":"#/components/schemas/OrderQueryRequest"}}],"responses":{"200":{"description":"Success","content":{"*/*":{"schema":{"$ref":"#/components/schemas/RealGridListResponseOrderQueryResponse"}}}},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```