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 | Final Resolution | Order Resolution | CUSTOMER_CANCELLED | |
| 16 | On Hold | If order is on hold or not | NA | TRUE or FALSE |
| 17 | Priority | Is on priority or not | NA | TRUE or FALSE |
| 18 | Future Picklist Express Orders | If order is in CREATED, UNFULFILLABLE, FULFILLABLE and | If order is Express or Not | TRUE or FALSE |
| 19 | Channel Order Time | Order received Timestamp by Channel | NA | 2023-01-01 12:34:56 |
| 20 | Channel Order Status | Status of order w.r.t. channel | NA | CREATED |
| 21 | System Order Time | OMS Order Creation Timestamp | NA | 2023-01-01 12:34:56 |
| 22 | Last Status Updated Time | OMS Order Status Last Updated Timestamp | NA | 2023-01-01 12:34:56 |
| 23 | Warehouse Order Creation Time | WMS Order Creation Timestamp | NA | 2023-01-01 12:34:56 |
| 24 | SLA Time | SLA Required By Timestamp |
| 2023-01-03 12:34:56 |
| 25 | Order Release Time | Start Processing Timestamp | 2023-01-03 12:34:56 | |
| 26 | Invoice Time | Channel Invoice’s timestamp | NA | 2023-01-01 12:34:56 |
| 27 | Manifest Created Time | Timestamp of Manifest Created | NA | 2023-01-01 12:34:56 |
| 28 | Manifest Closed Time | Timestamp of Manifest Closed | NA | 2023-01-01 12:34:56 |
| 29 | Handover Time | Timestamp of shipment handover |
| 2023-01-01 12:34:56 |
| 30 | Delivered Time | Shipment Delivered Timestamp |
| 2023-01-01 12:34:56 |
| 31 | Order And Manifest Time Difference in Hours | Time taken from orders created to manifest closed in hours | 7 | |
| 32 | 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 |
| 33 | SLA Breach | Whether order has breached SLA or not | NA | YES or NO |
| 34 | Order Qty | Ordered Quantity | NA | 3 |
| 35 | Cancelled Qty | Cancelled Qty | 1 | |
| 36 | Reserve Qty | Allocated Quantity for an order | 2 | |
| 37 | Processing Qty | Quantity currently being processed. | When Marketplace perspective is selected or order is still not moved to processing stage. | 1 |
| 38 | Picked Qty | Total Quantity in Picked Status | When Marketplace perspective is selected | 1 |
| 39 | Dispatched / Packed Qty | Total quantity Fulfilled | When no qty is fulfilled | 0 |
| 40 | Pending Qty | Quantity pending to be Fulfilled | 1 | |
| 41 | Unfulfillable Qty | Unfulfillable Qty | 0 | |
| 42 | Pick List Created Qty | Total Quantity for which Picklist is in created status. | In case of Market Place Perspective | 1 |
| 43 | Pick List Not Released Qty | Total Quantity for which Picklist for which picklist is not created. | In case of Market Place Perspective | 1 |
| 44 | Invoice Pending Quantity | Total Quantity for which Invoicing is pending. | In case of Market Place Perspective | 1 |
| 45 | Fulfilled % | Percentage fulfilment till now. | 50% | |
| 46 | Order Amount | Total Value of entire order. | 3999 | |
| 47 | 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 |
| 48 | Pre/Post Pack Staging Location | Pre/Post Pack Staging Location ID | 1231241 | |
| 49 | Remarks | Remarks if any | If not provided | String |
| 50 | 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 |