Navigate To

Description

Provides the Failed Outward Orders (and not yet cancelled), due to unavailability of listing in CIMS.

	Fields	Description	This column can be null	Sample Data

	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	Description	Limitation

	Filters	Description	Limitation
1	Client	Name of the Client	Mandatory
2	Order Created From	Order Created From the date	Maximum date range : 31 Mandatory
3	Order Created To	Order Created To the date	Maximum date range : 31 Mandatory

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