Order Status Report Detail - OMS
- Prakash Nagulapati
Navigate To
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
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 |
|
| 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 |
|
| 33 | Split Order | Whether the order is a split order or not | No |
|
| 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 |
|
| 6 | Order Created To | Order created till the date | |
| 7 | Required By From | Required from the date |
|
| 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 |
*sm : At least one of the filters tagged with this is a MUST to submit a report request.
FAQs
Â
Â