> 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/statistics-bo-api/sales-order-status-by-brand.md).
# Sales/Order Status By Brand
## Retrieve Order/Sales Status List by Brand
> \## Function Description\
> \* This function retrieves the order/sales status list by brand.\
> \---\
> \## Detailed Description\
> \* Called when the search button is clicked on the \[BO] Statistics > Sales Analysis > Sales Status by Brand page.\
> \* Called when the search button is clicked on the \[BO] Statistics > Order Analysis > Order Status by Brand page.\
> \* \*\*Aggregation Type Code, Search Period (Start Date, End Date)\*\* are required search conditions.\
> \* - Aggregation Type Code 01: Order, 02: Sales\
> \* \*\*Site No., Brand No.\*\* are optional search conditions.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827 : Initial creation
```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":{"BrandStatusRequest":{"type":"object","description":"Sales/Order Status by Brand DTO","properties":{"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"brandNo":{"type":"string","description":"Brand No."},"agrtGb":{"type":"string","description":"Aggregation Type","minLength":1}},"required":["agrtGb"]},"RealGridListResponseBrandStatusResponse":{"type":"object","properties":{"totalCount":{"type":"integer","format":"int32"},"payloads":{"type":"array","items":{"$ref":"#/components/schemas/BrandStatusResponse"}}}},"BrandStatusResponse":{"type":"object","description":"Order/Sales Status by Brand DTO","properties":{"siteNm":{"type":"string","description":"Site Name"},"agrtGb":{"type":"string","description":"Aggregation Type"},"brandNo":{"type":"string","description":"Brand No."},"brandNm":{"type":"string","description":"Brand Name"},"dcAmt2nd":{"type":"number","description":"Secondary Discount Amount"},"dcAmt3rd":{"type":"number","description":"Tertiary Discount Amount"},"ordAmt":{"type":"number","description":"Order Amount"},"cnclAmt":{"type":"number","description":"Cancellation Amount"},"netOrdAmt":{"type":"integer","format":"int64","description":"Net Order Amount"},"ordQty":{"type":"integer","format":"int32","description":"Order Quantity"},"cnclQty":{"type":"integer","format":"int32","description":"Cancellation Quantity"},"netOrdQty":{"type":"integer","format":"int32","description":"Net Order Quantity"}}},"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/statistics/brandStatus/getBrandStatusList":{"get":{"tags":["Sales/Order Status by Brand"],"summary":"Retrieve Order/Sales Status List by Brand","description":"## Function Description\n* This function retrieves the order/sales status list by brand.\n---\n## Detailed Description\n* Called when the search button is clicked on the [BO] Statistics > Sales Analysis > Sales Status by Brand page.\n* Called when the search button is clicked on the [BO] Statistics > Order Analysis > Order Status by Brand page.\n* **Aggregation Type Code, Search Period (Start Date, End Date)** are required search conditions.\n* - Aggregation Type Code 01: Order, 02: Sales\n* **Site No., Brand No.** are optional search conditions.\n---\n## Revision History\n* Release v2.00_240827 : Initial creation\n","operationId":"getBrandStatusList","parameters":[{"name":"request","in":"query","required":true,"schema":{"$ref":"#/components/schemas/BrandStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"siteNo","in":"query","description":"Site No.","schema":{"type":"String"}},{"name":"brandNo","in":"query","description":"Brand No.","schema":{"type":"String"}},{"name":"agrtGb","in":"query","description":"Aggregation Type","required":true,"schema":{"type":"String"}}],"responses":{"200":{"description":"Successfully retrieved sales/order status list by brand","content":{"*/*":{"schema":{"$ref":"#/components/schemas/RealGridListResponseBrandStatusResponse"}}}},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```
## Batch Excel Download of Order/Sales Status by Brand
> \## Function Description\
> \* Generates and downloads the order/sales status list by brand as an Excel file.\
> \---\
> \## Detailed Description\
> \* The displayed items are the same as the grid list.\
> \* Retrieves all data matching the search conditions without paging.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827 : Initial creation
```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":{"BrandStatusRequest":{"type":"object","description":"Sales/Order Status by Brand DTO","properties":{"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"brandNo":{"type":"string","description":"Brand No."},"agrtGb":{"type":"string","description":"Aggregation Type","minLength":1}},"required":["agrtGb"]},"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/statistics/brandStatus/downloadBrandStatusExcel":{"get":{"tags":["Sales/Order Status by Brand"],"summary":"Batch Excel Download of Order/Sales Status by Brand","description":"## Function Description\n* Generates and downloads the order/sales status list by brand as an Excel file.\n---\n## Detailed Description\n* The displayed items are the same as the grid list.\n* Retrieves all data matching the search conditions without paging.\n---\n## Revision History\n* Release v2.00_240827 : Initial creation\n","operationId":"downloadBrandStatusExcel","parameters":[{"name":"request","in":"query","required":true,"schema":{"$ref":"#/components/schemas/BrandStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"siteNo","in":"query","description":"Site No.","schema":{"type":"String"}},{"name":"brandNo","in":"query","description":"Brand No.","schema":{"type":"String"}},{"name":"agrtGb","in":"query","description":"Aggregation Type","required":true,"schema":{"type":"String"}}],"responses":{"200":{"description":"Excel Download Successful"},"900":{"description":"Excel Download Failed","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```