Navigate To

1 Description
2 Fields
3 Filters
4 FAQs

Description

Provides Outward Order details at Order level with all the relevant information.

Fields

	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 fulfilment location	NA	wms_hosur
3	Fulfilment Location ID	Increff’s unique ID of a fulfilment location	NA	1231212312
4	Sales Channel	Channel through which order is placed	NA	FLIPKARTV3
5	Channel Order No	Order ID by channel	NA	aB12Pq34
6	Channel Parent Order ID	Parent Order ID from the Channel		abcd123
7	System Order ID	Increff’s unique Order ID	NA	1231212312
8	System Sub Order ID	Increff’s Unique Sub Order ID	NA	12
9	Order Type	Type of order	NA	SALES
10	Gift	Is it gift or not	NA	TRUE or FALSE
11	Party	Partner’s name	NA	abcd
12	Partner ID	Partner’s ID	NA	124231
13	Reservation Pool	Reservation Pool Name		abcd123
14	Status	Status of Order	NA	PICKING
15	Order QC Status	QC Status of the Sub Order	NA	PASS FAIL
16	Final Resolution	Order Resolution		CUSTOMER_CANCELLED
17	On Hold	If order is on hold or not	NA	TRUE or FALSE
18	Priority	Is on priority or not	NA	TRUE or FALSE
19	Future Picklist Express Orders	If order is in CREATED, UNFULFILLABLE, FULFILLABLE and	If order is Express or Not	TRUE or FALSE
20	Channel Order Time	Order received Timestamp by Channel	NA	2023-01-01 12:34:56
21	Channel Order Status	Status of order w.r.t. channel	NA	CREATED
22	System Order Time	OMS Order Creation Timestamp	NA	2023-01-01 12:34:56
23	Last Status Updated Time	OMS Order Status Last Updated Timestamp	NA	2023-01-01 12:34:56
24	Warehouse Order Creation Time	WMS Order Creation Timestamp	NA	2023-01-01 12:34:56
25	SLA Time	SLA Required By Timestamp		2023-01-03 12:34:56
26	Order Release Time	Start Processing Timestamp		2023-01-03 12:34:56
27	Invoice Time	Channel Invoice’s timestamp	If it is a bulk order	2023-01-01 12:34:56
28	Manifest Created Time	Timestamp of Manifest Created	If it is a bulk order	2023-01-01 12:34:56
29	Manifest Closed Time	Timestamp of Manifest Closed	If it is a bulk order	2023-01-01 12:34:56
30	Handover Time	Timestamp of shipment handover	If it is a bulk order	2023-01-01 12:34:56
31	Delivered Time	Shipment Delivered Timestamp	If it is a bulk order	2023-01-01 12:34:56
32	Order And Manifest Time Difference in Hours	Time taken from orders created to manifest closed in hours		7
33	Manifested within 24 Hours	If manifest is closed in 24 hours from order creation or not	If manifest is not yet closed	YES or NO
34	SLA Breach	Whether order has breached SLA or not	NA	YES or NO
35	Order Qty	Ordered Quantity	NA	3
36	Cancelled Qty	Cancelled Qty		1
37	Reserve Qty	Allocated Quantity for an order		2
38	Processing Qty	Quantity currently being processed.	When Marketplace perspective is selected or order is still not moved to processing stage.	1
39	Picked Qty	Total Quantity in Picked Status	When Marketplace perspective is selected	1
40	Dispatched / Packed Qty	Total quantity Fulfilled	When no qty is fulfilled	0
41	Pending Qty	Quantity pending to be Fulfilled		1
42	Unfulfillable Qty	Unfulfillable Qty		0
43	Pick List Created Qty	Total Quantity for which Picklist is in created status.	In case of Market Place Perspective	1
44	Pick List Not Released Qty	Total Quantity for which Picklist for which picklist is not created.	In case of Market Place Perspective	1
45	Invoice Pending Quantity	Total Quantity for which Invoicing is pending.	In case of Market Place Perspective	1
46	Fulfilled %	Percentage fulfilment till now.		50%
47	Order Amount	Total Value of entire order.		3999
48	External Pick Order Group Code	A unique ID for Pick Order Group which consists of multiple orders Items that are grouped together to be picked at once.	Yes. If Pick order group is not applicable	abcd123
49	Pre/Post Pack Staging Location	Pre/Post Pack Staging Location ID		1231241
50	Remarks	Remarks if any	If not provided	String
51	Retry Count	No. of times an order, oms tries syncing with wms if sync is getting failed	NA	1

Filters

	Filters	Description	Limitation

	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	Reservation Pool	Reservation Pool	NA
5	Order Created From	Order created from the date	Maximum date range : 31
6	Order Created To	Order created till the date	Maximum date range : 31
7	Required By From	Required from the date	Maximum date range : 31
8	Required By To	Required till the date	Maximum date range : 31
9	Last Update From	Last update from the date	Maximum date range : 31
10	Last Update To	Last update till the date	Maximum date range : 31
11	Channel Order ID	Order ID by channel	NA
12	System Order ID	Increff’s unique system order ID	NA
13	Parent Order ID	Parent order ID of channel	NA
14	WMS Order From	WMS Order created from the date	Maximum date range : 31
15	WMS Order To	WMS Order created till the date	Maximum date range : 31
16	Order Status	Status of order	NA
17	Virtual / Combo Perspective	Marketplace or Warehouse perspective	Mandatory, Single Select
18	Business Type	B2C or B2B	NA
19	Pick Order Group Code	Pick Order Group Code	NA
20	Pick Order Group	Associated with Pick order group or not	Mandatory, Single Select
21	Pre Pack Staging Location	Is associated to Pre Pack Staging Location or not	NA
22	SLA Breached	Yes or No	NA
23	WMS Updated From	WMS updated from the date	Maximum date range : 31
24	WMS Updated To	WMS updated till the date	Maximum date range : 31
25	Post Pack Staging Location ID	Pre / Post Pack Staging Location ID	NA
26	Retry Count	All or only whose retry count >=3	Mandatory
27	Final Resolution	Order Resolution	NA

Omni Public

Order Status Report - OMS

Navigate To

Description

Fields

Filters

FAQs