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 Order QC Status QC Status of the Sub Order NA 1. PASS
  1. FAIL | | 18 | Item Uploaded? | If item is uploaded or not | NA | 0 or 1 | | 19 | Channel Order Time | Ordered Timestamp by Channel | NA | 2023-01-01 12:34:56 | | 20 | System Order Time | OMS Order Creation Timestamp | NA | 2023-01-01 12:34:56 | | 21 | SLA Time | SLA Required By Timestamp | | 2023-01-03 12:34:56 | | 22 | Order Release Time | Start Processing Timestamp | | 2023-01-03 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 | Invoice Time | Channel Invoice’s timestamp | If it is a bulk order | 2023-01-01 12:34:56 | | 26 | Manifest Created Time | Timestamp of Manifest Created | If it is a bulk order | 2023-01-01 12:34:56 | | 27 | Manifest Closed Time | Timestamp of Manifest Closed | If it is a bulk order | 2023-01-01 12:34:56 | | 28 | Handover Time | Timestamp of shipment handover | If it is a bulk order | 2023-01-01 12:34:56 | | 29 | AWB Number | Air Way Bill Number | If it is a bulk order | asd123 | | 30 | Delivered Time | Shipment Delivered Timestamp | If it is a bulk order | 2023-01-01 12:34:56 | | 31 | SLA Breach | Whether order has breached SLA or not | If it is a bulk order | YES or NO | | 32 | Priority | Whether order is on priority or not | NA | 1. TRUE
  2. FALSE | | 33 | Split Order | Whether the order is a split order or not | No | 1. TRUE
  3. FALSE | | 34 | Party | Partner’s name (Customer / Supplier) | NA | abcd | | 35 | City | City | If not provided | PATNA | | 36 | State | State | If not provided | UP | | 37 | Pin Code | Pin Code | If not provided | 560031 | | 38 | Client SKU ID / EAN | Client SKU ID / EAN | NA | asd1234 | | 39 | Virtual SKU | Virtual SKU or Not | | TRUE or FALSE | | 40 | Category | Category | | Apparel | | 41 | Style | Style | | abcd | | 42 | Color | Color | | red | | 43 | Size | Size | | L | | 44 | Brand | Brand | | XYZ | | 45 | Internal Batch ID | Increff’s Batch ID for Perishable SKUs | | 123 | | 46 | Min Expiry | In case of a perishable products, this date shows the min of all the expiry dates. | | 2023-01-05 10:30:00 | | 47 | Order Qty | Ordered Quantity | | 4 | | 48 | Cancelled Qty | Cancelled Qty | | 1 | | 49 | Reserve Qty | Allocated Quantity for an order | | 2 | | 50 | Customer Cancelled Qty | Customer Cancelled Qty | | 1 | | 51 | Seller Cancelled Qty | Seller Cancelled Qty | | 0 | | 52 | Max Allocated Qty | Maximum Allocated Qty | | 2 | | 53 | Picked Qty | Total Quantity in Picked Status | | 1 | | 54 | Packed/ Dispatched Qty | Total quantity Fulfilled | | 1 | | 55 | Pack Pending Qty | Quantity pending to be packed | | 1 | | 56 | Open Box Qty | Quantity in Open Box | | 1 | | 57 | Closed Box Qty | Quantity in Closed Box | | 1 | | 58 | Invoiced Qty | Total Invoiced Quantity | | 2 | | 59 | Manifested Qty | Total Manifested Quantity | | 1 | | 60 | Shipped Qty | Dispatched Quantity | | 1 | | 61 | Unfulfillable Qty | Unfulfillable Quantity | | 1 | | 62 | Total Picklist Released Qty | Total Quantity for which Pick List is released | | 3 | | 63 | Pick List Created | Total Quantity in Pick List release status. | In case of Market Place Perspective | 2 | | 64 | Active in Picking Qty | Quantity that is currently in Picking status (Picklist status New and Allocated) | In case of Market Place Perspective | 0 | | 65 | Pick List Marked as Not Found | Quantity that is currently in Not Found Picklist status | In case of Market Place Perspective | 1 | | 66 | Pick List Not Released | Total Quantity for which Picklist for which picklist is not created. | In case of Market Place Perspective | 2 | | 67 | Pigeonhole Qty | Items in Pigeon hole | In case of Market Place Perspective | 1 | | 68 | Fulfilled Pc | Percentage fulfilment till now. | | 75 | | 69 | Order MRP Amount | Ordered Quantity * MRP | | 3999 | | 70 | Order Amount | Total Order Amount | | 2999 | | 71 | Shipping Charge | Shipping Charges | If not provided | 12.34 | | 72 | Gift Charge | Gift Charges | If not provided | 12.34 | | 73 | 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 1. Maximum date range : 31
  1. *sm | | 6 | Order Created To | Order created till the date | | | 7 | Required By From | Required from the date | 1. Maximum date range : 31
  2. *sm | | 8 | Required By To | Required till the date | | | 9 | Order Status | Status of order | NA | | 10 | Parent Order ID | Parent order ID of channel | *sm | | 11 | Channel Order ID | Order ID by channel | *sm | | 12 | System Order ID | Increff’s unique system order ID | *sm | | 13 | System Sub Order ID | Increff’s unique sub order ID | *sm | | 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 |

FAQs