...
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 |
| 3435 | City | City | If not provided | PATNA |
| 3536 | State | State | If not provided | UP |
| 3637 | Pin Code | Pin Code | If not provided | 560031 |
| 3738 | Client SKU ID / EAN | Client SKU ID / EAN | NA | asd1234 |
| 3839 | Virtual SKU | Virtual SKU or Not | TRUE or FALSE | |
| 3940 | Category | Category | Apparel | |
| 4041 | Style | Style | abcd | |
| 4142 | Color | Color | red | |
| 4243 | Size | Size | L | |
| 4344 | Brand | Brand | XYZ | |
| 4445 | Internal Batch ID | Increff’s Batch ID for Perishable SKUs | 123 | |
| 4546 | Min Expiry | In case of a perishable products, this date shows the min of all the expiry dates. | 2023-01-05 10:30:00 | |
| 4647 | Order Qty | Ordered Quantity | 4 | |
| 4748 | Cancelled Qty | Cancelled Qty | 1 | |
| 4849 | Reserve Qty | Allocated Quantity for an order | 2 | |
| 4950 | Customer Cancelled Qty | Customer Cancelled Qty | 1 | |
| 5051 | Seller Cancelled Qty | Seller Cancelled Qty | 0 | |
| 5152 | Max Allocated Qty | Maximum Allocated Qty | 2 | |
| 5253 | Picked Qty | Total Quantity in Picked Status | 1 | |
| 5354 | Packed/ Dispatched Qty | Total quantity Fulfilled | 1 | |
| 5455 | Pack Pending Qty | Quantity pending to be packed | 1 | |
| 5556 | Open Box Qty | Quantity in Open Box | 1 | |
| 5657 | Closed Box Qty | Quantity in Closed Box | 1 | |
| 5758 | Invoiced Qty | Total Invoiced Quantity | 2 | |
| 5859 | Manifested Qty | Total Manifested Quantity | 1 | |
| 5960 | Shipped Qty | Dispatched Quantity | 1 | |
| 6061 | Unfulfillable Qty | Unfulfillable Quantity | 1 | |
| 6162 | Total Picklist Released Qty | Total Quantity for which Pick List is released | 3 | |
| 6263 | Pick List Created | Total Quantity in Pick List release status. | In case of Market Place Perspective | 2 |
| 6364 | Active in Picking Qty | Quantity that is currently in Picking status (Picklist status New and Allocated) | In case of Market Place Perspective | 0 |
| 6465 | Pick List Marked as Not Found | Quantity that is currently in Not Found Picklist status | In case of Market Place Perspective | 1 |
| 6566 | Pick List Not Released | Total Quantity for which Picklist for which picklist is not created. | In case of Market Place Perspective | 2 |
| 6667 | Pigeonhole Qty | Items in Pigeon hole | In case of Market Place Perspective | 1 |
| 6768 | Fulfilled Pc | Percentage fulfilment till now. | 75 | |
| 6869 | Order MRP Amount | Ordered Quantity * MRP | 3999 | |
| 6970 | Order Amount | Total Order Amount | 2999 | |
| 7071 | Shipping Charge | Shipping Charges | If not provided | 12.34 |
| 7172 | Gift Charge | Gift Charges | If not provided | 12.34 |
| 7273 | Payment Type | Type of Payment | If not provided | abcd |
...