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 1. Maximum date range : 31
  1. Mandatory | | 3 | Order Created To | Order Created To the date | |

FAQs

  1. Why is the order not reflecting in report (but showing it in the CIMS-UI) even if order is in Failed State?
    1. The report will only show the orders which are still NOT Cancelled. From cims_outward_order_pojo
      1. order_state column should be one of “FAIL” or “VALIDATED”
      2. order_status column != CANCELLED