Navigate To
Description
Provides Outward Order details at Order-SKU 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 | Channel Order ID | Order ID by channel | NA | aB12Pq34 |
| 4 | Channel Parent Order Code | Parent Order ID from the Channel |
| abcd123 |
| 5 | System Order ID | Increff’s unique Order ID | NA | 1231212312 |
| 6 | System Sub Order ID | Increff’s Unique Sub Order ID | NA | 12 |
| 7 | System Sub Order Item ID | Increff’s Unique Sub Order Item ID | NA | 4 |
| 8 | Order Type | Type of order | NA | SALES |
| 9 | Channel Order Status | Status of order w.r.t. channel | NA | CREATED |
| 10 | Pack Type | Type of packing - B2B or B2C | NA | B2B or B2C |
| 11 | Sales Channel | Channel through which order is placed | NA | FLIPKARTV3 |
| 12 | 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 |
|
| 13 | On Hold | If is on hold or not | NA | TRUE or FALSE |
| 14 | Gift | A gift or not | NA | TRUE or FALSE |
| 15 | Remarks | Remarks if any | If not provided | String |
| 16 | Order Resolution | Order Resolution |
| CUSTOMER_CANCELLED |
| 17 | Item Uploaded? | If item is uploaded or not | NA | 0 or 1 |
| 18 | Channel Order Time | Ordered Timestamp by Channel | NA | 2023-01-01 12:34:56 |
| 19 | System Order Time | OMS Order Creation Timestamp | NA | 2023-01-01 12:34:56 |
| 20 | SLA Time | SLA Required By Timestamp |
| 2023-01-03 12:34:56 |
| 21 | Order Release Time | Start Processing Timestamp |
| 2023-01-03 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 | Invoice Time | Channel Invoice’s timestamp | NA | 2023-01-01 12:34:56 |
| 25 | Manifest Created Time | Timestamp of Manifest Created | NA | 2023-01-01 12:34:56 |
| 26 | Manifest Closed Time | Timestamp of Manifest Closed | NA | 2023-01-01 12:34:56 |
| 27 | Handover Time | Timestamp of shipment handover |
| 2023-01-01 12:34:56 |
| 28 | AWB Number | Air Way Bill Number |
| asd123 |
| 29 | Delivered Time | Shipment Delivered Timestamp |
| 2023-01-01 12:34:56 |
| 30 | Party | Partner’s name (Customer / Supplier) | NA | abcd |
| 31 | City | City | If not provided | PATNA |
| 32 | State | State | If not provided | UP |
| 33 | Pin Code | Pin Code | If not provided | 560031 |
| 34 | Client SKU ID / EAN | Client SKU ID / EAN | NA | asd1234 |
| 35 | Virtual SKU | Virtual SKU or Not | TRUE or FALSE | |
| 36 | Category | Category | Apparel | |
| 37 | Style | Style | abcd | |
| 38 | Color | Color | red | |
| 39 | Size | Size | L | |
| 40 | Brand | Brand | XYZ | |
| 41 | Internal Batch ID | Increff’s Batch ID for Perishable SKUs | 123 | |
| 42 | Min Expiry | In case of a perishable products, this date shows the min of all the expiry dates. | 2023-01-05 10:30:00 | |
| 43 | Order Qty | Ordered Quantity | 4 | |
| 44 | Cancelled Qty | Cancelled Qty | 1 | |
| 45 | Reserve Qty | Allocated Quantity for an order | 2 | |
| 46 | Customer Cancelled Qty | Customer Cancelled Qty | 1 | |
| 47 | Seller Cancelled Qty | Seller Cancelled Qty | 0 | |
| 48 | Max Allocated Qty | Maximum Allocated Qty | 2 | |
| 49 | Picked Qty | Total Quantity in Picked Status | 1 | |
| 50 | Packed/ Dispatched Qty | Total quantity Fulfilled | 1 | |
| 51 | Pack Pending Qty | Quantity pending to be packed | 1 | |
| 52 | Open Box Qty | Quantity in Open Box | 1 | |
| 53 | Closed Box Qty | Quantity in Closed Box | 1 | |
| 54 | Invoiced Qty | Total Invoiced Quantity | 2 | |
| 55 | Manifested Qty | Total Manifested Quantity | 1 | |
| 56 | Shipped Qty | Dispatched Quantity | 1 | |
| 57 | Unfulfillable Qty | Unfulfillable Quantity | 1 | |
| 58 | Total Picklist Released Qty | Total Quantity for which Pick List is released | 3 | |
| 59 | Pick List Created | Total Quantity in Pick List release status. | In case of Market Place Perspective | 2 |
| 60 | Active in Picking Qty | Quantity that is currently in Picking status (Picklist status New and Allocated) | In case of Market Place Perspective | 0 |
| 61 | Pick List Marked as Not Found | Quantity that is currently in Not Found Picklist status | In case of Market Place Perspective | 1 |
| 62 | Pick List Not Released | Total Quantity for which Picklist for which picklist is not created. | In case of Market Place Perspective | 2 |
| 63 | Pigeonhole Qty | Items in Pigeon hole | In case of Market Place Perspective | 1 |
| 64 | Fulfilled Pc | Percentage fulfilment till now. | 75 | |
| 65 | Order MRP Amount | Ordered Quantity * MRP | 3999 | |
| 66 | Order Amount | Total Order Amount | 2999 | |
| 67 | Shipping Charge | Shipping Charges | If not provided | 12.34 |
| 68 | Gift Charge | Gift Charges | If not provided | 12.34 |
| 69 | Payment Type | Type of Payment | If not provided | abcd |
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 | Brand | Brand | |
| 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 | Order Status | Status of order | NA |
| 10 | Parent Order ID | Parent order ID of channel | NA |
| 11 | Channel Order ID | Order ID by channel | NA |
| 12 | System Order ID | Increff’s unique system order ID | NA |
| 13 | System Sub Order ID | Increff’s unique sub order ID | NA |
| 14 | Party | Partner (Customer / Supplier) | NA |
| 15 | Virtual / Combo Perspective | Marketplace or Warehouse perspective | Mandatory, Single Select |
| 16 | Client SKU ID | Client’s SKU ID / EAN | NA |
| 17 | Business | B2B, B2C | NA |