Outward Unfulfillable Orders Detail - OMS
- Prakash Nagulapati
Navigate To
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
Description
Provides Unfulfillable SKUs with their last unfulfillable Order details, Last Sync details and inventory stuck in Recycle, Offline and GRN state. Helps with the analysis of Unfulfillable orders.
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | Date | OMS Order Creation Date | NA | 2023-01-01 12:34:56 |
| 2 | Sales Channel | Channel through which order is placed | Â | FLIPKARTV3 |
| 3 | Client Name | Name of the client | NA | Increff |
| 4 | Fulfilment Location Name | Name of fulfilment location | NA | wms_hosur |
| 5 | Channel Order ID | Order ID by channel | Â NA | aB12Pq34 |
| 6 | Parent Order Code | Parent Order ID from the Channel | Â | Â abcd123 |
| 7 | CIMS Order ID | Order ID from CIMS | Â | 212323 |
| 8 | Global SKU ID | Increff’s unique SKU ID |  | 1234123 |
| 9 | Client SKU ID / EAN | SKU ID as per Client | NA | 1234123412 |
| 10 | Inventory Exposure Formula | Â | Â | 1231 |
| 11 | Enabled | Is enabled or not | NA | YES or NO |
| 12 | Last Unfulfillable Order | Recent Unfulfillable Order ID | NA | 1242131 |
| 13 | No of Unfulfillable Orders | Count of unfulfillable orders | NA | 432 |
| 14 | No of Unfulfillable Order Items | Number of order items unfulfillable | NA | 124 |
| 15 | No of Items in GRN Status | Distinct number of items in GRN | NA | 241 |
| 16 | No of Items in Recycle Status | Distinct number of items in RECYCLE | NA | 22 |
| 17 | Order Resolution | Â | Â | CUSTOMER_CANCELLED |
| 18 | Unfulfillable due to Bulk Break Pending | If Order is unfulfillable due to Bulk Break pending | NA | YES or NO |
| 19 | Unfulfillable Quantity | Â | NA | 234 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Client | Name of the client | Mandatory |
| 2 | Fulfilment Locations | Name of the fulfilment locations | Mandatory |
| 3 | Sales Channel | Name of the Sales Channel | NA |
| 4 | Order Created From | Order created from the date |
|
| 5 | Order Created To | Order created till the date |
FAQs
Â