...
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 | Fulfilment Location ID | Increff’s unique ID of a fulfilment location | NA | 1231212312 |
| 4 | Sales Channel | Channel through which order is placed | NA | FLIPKARTV3 |
| 5 | Channel Order No | Order ID by channel | NA | aB12Pq34 |
| 6 | Channel Parent Order ID | Parent Order ID from the Channel |
| abcd123 |
| 7 | System Order ID | Increff’s unique Order ID | NA | 1231212312 |
| 8 | System Sub Order ID | Increff’s Unique Sub Order ID | NA | 12 |
| 9 | Order Type | Type of order | NA | SALES |
| 10 | Gift | Is it gift or not | NA | TRUE or FALSE |
| 11 | Party | Partner’s name | NA | abcd |
| 12 | Partner ID | Partner’s ID | NA | 124231 |
| 13 | Reservation Pool | Reservation Pool Name | abcd123 | |
| 14 | Status | Status of Order | NA | PICKING |
| 15 | Order QC Status | QC Status of the Sub Order | NA |
|
| 16 | Final Resolution | Order Resolution | CUSTOMER_CANCELLED | |
| 1617 | On Hold | If order is on hold or not | NA | TRUE or FALSE |
| 1718 | Priority | Is on priority or not | NA | TRUE or FALSE |
| 1819 | Future Picklist Express Orders | If order is in CREATED, UNFULFILLABLE, FULFILLABLE and | If order is Express or Not | TRUE or FALSE |
| 1920 | Channel Order Time | Order received Timestamp by Channel | NA | 2023-01-01 12:34:56 |
| 2021 | Channel Order Status | Status of order w.r.t. channel | NA | CREATED |
| 2122 | System Order Time | OMS Order Creation Timestamp | NA | 2023-01-01 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 | SLA Time | SLA Required By Timestamp |
| 2023-01-03 12:34:56 |
| 2526 | Order Release Time | Start Processing Timestamp | 2023-01-03 12:34:56 | |
| 2627 | Invoice Time | Channel Invoice’s timestampNA | If it is a bulk order | 2023-01-01 12:34:56 |
| 2728 | Manifest Created Time | Timestamp of Manifest CreatedNA | If it is a bulk order | 2023-01-01 12:34:56 |
| 2829 | Manifest Closed Time | Timestamp of Manifest ClosedNA | If it is a bulk order | 2023-01-01 12:34:56 |
| 2930 | Handover Time | Timestamp of shipment handover | If it is a bulk order | 2023-01-01 12:34:56 |
| 3031 | Delivered Time | Shipment Delivered Timestamp | If it is a bulk order | 2023-01-01 12:34:56 |
| 3132 | Order And Manifest Time Difference in Hours | Time taken from orders created to manifest closed in hours | 7 | |
| 3233 | Manifested within 24 Hours | If manifest is closed in 24 hours from order creation or not | If manifest is not yet closed | YES or NO |
| 3334 | SLA Breach | Whether order has breached SLA or not | NA | YES or NO |
| 3435 | Order Qty | Ordered Quantity | NA | 3 |
| 3536 | Cancelled Qty | Cancelled Qty | 1 | |
| 3637 | Reserve Qty | Allocated Quantity for an order | 2 | |
| 3738 | Processing Qty | Quantity currently being processed. | When Marketplace perspective is selected or order is still not moved to processing stage. | 1 |
| 3839 | Picked Qty | Total Quantity in Picked Status | When Marketplace perspective is selected | 1 |
| 3940 | Dispatched / Packed Qty | Total quantity Fulfilled | When no qty is fulfilled | 0 |
| 4041 | Pending Qty | Quantity pending to be Fulfilled | 1 | |
| 4142 | Unfulfillable Qty | Unfulfillable Qty | 0 | |
| 4243 | Pick List Created Qty | Total Quantity for which Picklist is in created status. | In case of Market Place Perspective | 1 |
| 4344 | Pick List Not Released Qty | Total Quantity for which Picklist for which picklist is not created. | In case of Market Place Perspective | 1 |
| 4445 | Invoice Pending Quantity | Total Quantity for which Invoicing is pending. | In case of Market Place Perspective | 1 |
| 4546 | Fulfilled % | Percentage fulfilment till now. | 50% | |
| 4647 | Order Amount | Total Value of entire order. | 3999 | |
| 4748 | 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 | abcd123 |
| 4849 | Pre/Post Pack Staging Location | Pre/Post Pack Staging Location ID | 1231241 | |
| 4950 | Remarks | Remarks if any | If not provided | String |
| 5051 | Retry Count | No. of times an order, oms tries syncing with wms if sync is getting failed | NA | 1 |
...