Navigate To
Description
Provides the Failed Outward Orders (and not yet cancelled), due to unavailability of listing in CIMS.
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | Client Name | Name of the Client | NA | Increff |
| 2 | Fulfilment Location Name | Name of the fulfilment location | NA | wms_hosur |
| 3 | Sales Channel | Channel through which order is placed |
| FLIPKARTV3 |
| 4 | Client ID | Increff’s unique ID for each client | NA | 97567231 |
| 5 | Channel Order ID | Order ID from Channel | NA | abcd123 |
| 6 | Parent Order ID | Parent Order ID from Channel | asd213 | |
| 7 | Order State | State of the order | NA | CANCELLED |
| 8 | Fail Reason | Reason for fail | If no reason is captured | SKU Listing not found |
| 9 | Order Item ID | Order Item Code from the channel | NA | abcd123 |
| 10 | Channel SKU ID | SKU ID as per Channel | NA | abcd123 |
| 11 | Global SKU ID | Increff’s unique SKU ID | 1234123412 | |
| 12 | Client SKU ID / EAN | SKU ID as per Client | NA | 1234123412 |
| 13 | Channel Order Time | Order Timestamp from Channel | NA | 2023-01-01 12:34:56 |
| 14 | CIMS Creation Time | Outward Order Creation Timestamp in CIMS | NA | 2023-01-01 12:34:56 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Client | Name of the Client | Mandatory |
| 2 | Order Created From | Order Created From the date | Maximum date range : 31 |
| 3 | Order Created To | Order Created To the date |
FAQs
Why is the order not reflecting in report (but showing it in the CIMS-UI) even if order is in Failed State?
The report will only show the orders which are still NOT Cancelled.
Fromcims_outward_order_pojoorder_statecolumn should be one of “FAIL” or “VALIDATED”order_statuscolumn != CANCELLED