Navigate To

Description

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

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 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 1. PASS
  1. 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
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
7 Required By From Required from the date Maximum date range : 31
8 Required By To Required till the date
9 Last Update From Last update from the date Maximum date range : 31
10 Last Update To Last update till the date
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
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
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

FAQs