...
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 | |
| 1819 | Channel Order Time | Ordered Timestamp by Channel | NA | 2023-01-01 12:34:56 | |
| 1920 | System Order Time | OMS Order Creation Timestamp | NA | 2023-01-01 12:34:56 | |
| 2021 | SLA Time | SLA Required By Timestamp |
| 2023-01-03 12:34:56 | |
| 2122 | Order Release Time | Start Processing Timestamp |
| 2023-01-03 12:34:56 | |
| 2223 | Last Status Updated Time | OMS Order Status Last Updated Timestamp | NA | 2023-01-01 12:34:56 | |
| 2324 | Warehouse Order Creation Time | WMS Order Creation Timestamp | NA | 2023-01-01 12:34:56 | |
| 2425 | Invoice Time | Channel Invoice’s timestampNA | If it is a bulk order | 2023-01-01 12:34:56 | |
| 2526 | Manifest Created Time | Timestamp of Manifest CreatedNA | If it is a bulk order | 2023-01-01 12:34:56 | |
| 2627 | Manifest Closed Time | Timestamp of Manifest ClosedNA | If it is a bulk order | 2023-01-01 12:34:56 | |
| 2728 | Handover Time | Timestamp of shipment handover | If it is a bulk order | 2023-01-01 12:34:56 | |
| 2829 | AWB Number | Air Way Bill Number | If it is a bulk order | asd123 | |
| 2930 | Delivered Time | Shipment Delivered Timestamp | If it is a bulk order | 2023-01-01 12:34:56 | 30|
| 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 | |
| 3135 | City | City | If not provided | PATNA | |
| 3236 | State | State | If not provided | UP | |
| 3337 | Pin Code | Pin Code | If not provided | 560031 | |
| 3438 | Client SKU ID / EAN | Client SKU ID / EAN | NA | asd1234 | |
| 3539 | Virtual SKU | Virtual SKU or Not | TRUE or FALSE | ||
| 3640 | Category | Category | Apparel | ||
| 3741 | Style | Style | abcd | ||
| 3842 | Color | Color | red | ||
| 3943 | Size | Size | L | ||
| 4044 | Brand | Brand | XYZ | ||
| 4145 | Internal Batch ID | Increff’s Batch ID for Perishable SKUs | 123 | ||
| 4246 | Min Expiry | In case of a perishable products, this date shows the min of all the expiry dates. | 2023-01-05 10:30:00 | ||
| 4347 | Order Qty | Ordered Quantity | 4 | ||
| 4448 | Cancelled Qty | Cancelled Qty | 1 | ||
| 4549 | Reserve Qty | Allocated Quantity for an order | 2 | ||
| 4650 | Customer Cancelled Qty | Customer Cancelled Qty | 1 | ||
| 4751 | Seller Cancelled Qty | Seller Cancelled Qty | 0 | ||
| 4852 | Max Allocated Qty | Maximum Allocated Qty | 2 | ||
| 4953 | Picked Qty | Total Quantity in Picked Status | 1 | ||
| 5054 | Packed/ Dispatched Qty | Total quantity Fulfilled | 1 | ||
| 5155 | Pack Pending Qty | Quantity pending to be packed | 1 | ||
| 5256 | Open Box Qty | Quantity in Open Box | 1 | ||
| 5357 | Closed Box Qty | Quantity in Closed Box | 1 | ||
| 5458 | Invoiced Qty | Total Invoiced Quantity | 2 | ||
| 5559 | Manifested Qty | Total Manifested Quantity | 1 | ||
| 5660 | Shipped Qty | Dispatched Quantity | 1 | ||
| 5761 | Unfulfillable Qty | Unfulfillable Quantity | 1 | ||
| 5862 | Total Picklist Released Qty | Total Quantity for which Pick List is released | 3 | ||
| 5963 | Pick List Created | Total Quantity in Pick List release status. | In case of Market Place Perspective | 2 | |
| 6064 | Active in Picking Qty | Quantity that is currently in Picking status (Picklist status New and Allocated) | In case of Market Place Perspective | 0 | |
| 6165 | Pick List Marked as Not Found | Quantity that is currently in Not Found Picklist status | In case of Market Place Perspective | 1 | |
| 6266 | Pick List Not Released | Total Quantity for which Picklist for which picklist is not created. | In case of Market Place Perspective | 2 | |
| 6367 | Pigeonhole Qty | Items in Pigeon hole | In case of Market Place Perspective | 1 | |
| 6468 | Fulfilled Pc | Percentage fulfilment till now. | 75 | ||
| 6569 | Order MRP Amount | Ordered Quantity * MRP | 3999 | ||
| 6670 | Order Amount | Total Order Amount | 2999 | ||
| 6771 | Shipping Charge | Shipping Charges | If not provided | 12.34 | |
| 6872 | Gift Charge | Gift Charges | If not provided | 12.34 | |
| 6973 | Payment Type | Type of Payment | If not provided | abcd |
...
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 | NA*sm |
| 11 | Channel Order ID | Order ID by channel | NA*sm |
| 12 | System Order ID | Increff’s unique system order ID | NA*sm |
| 13 | System Sub Order ID | Increff’s unique sub order ID | NA*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.