Navigate To
Description
Provides Outward Open Orders data at Box ID-Invoice level with Transporter and Shipment Details.
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | System Order ID | Increff’s unique Order ID | NA | 1231212312 |
| 2 | System Sub Order ID | Increff’s Unique Sub Order ID | NA | 12 |
| 3 | Channel Order ID | Order ID by channel | NA | aB12Pq34 |
| 4 | Shipment ID | Internal Shipment ID | NA | 112231 |
| 5 | External Shipment ID |
|
| 123abab |
| 6 | Pre/Post Pack Staging Location |
|
| 1231241 |
| 7 | External Pick Order Group Code | External Pick Order Group Code | NA | abcd123 |
| 8 | External Gate Pass Code | External Gate Pass Code | NA | abcd123 |
| 9 | System Invoice ID | Increff’s Invoice ID | NA | 123123 |
| 10 | Channel Invoice No | Channel’s Invoice Number |
| AB12CD34EF56 |
| 11 | Channel Invoice Time | Invoice Created Timestamp | NA | 2023-01-01 10:10:00 |
| 12 | Box ID | ID of box | NA | 1713126987 |
| 13 | Box Status | Status of the box | NA | DISPATCHED |
| 14 | Total Quantity | Total Quantity | NA | 23 |
| 15 | Global SKU ID | Increff’s unique SKU ID | NA | 1231212312 |
| 16 | Client SKU ID / EAN | Client’s SKU ID | NA | abcd123 |
| 17 | UOM SKU | If SKU is UOM or NOT | NA | 0 or 1 |
| 18 | Each Client SKU ID / EAN | Client SKU ID of Eaches leves | If SKU is not part of UOM | 1231212312 |
| 19 | Each Qty | Eaches Quantity | NA | 51 |
| 20 | Internal Batch ID | Internal Batch ID | If not provided | 1231241 |
| 21 | External Batch ID | External Batch ID | NA | abcd123 |
| 22 | Manufacturing Date | Manufacturing Date | NA | 2023-01-01-12:34:56 |
| 23 | Expiry Date | Expiry Date | NA | 2023-01-01-12:34:56 |
| 24 | Outward AWB No | If not provided | abcd123 | |
| 25 | Transporter | Transporter | If not provided | abcd123 |
| 26 | Length | Length of Box | If not provided | 12.34 |
| 27 | Breadth | Breadth of Box | If not provided | 12.34 |
| 28 | Weight | Weight of Box | If not provided | 12.34 |
| 29 | Height | Height of Box | If not provided | 12.34 |
| 30 | Box Label Remarks | If not provided | abcd123 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Fulfilment Locations | Name of fulfilment locations | Mandatory |
| 2 | Client | Name of client | Mandatory |
| 3 | Shipment ID | Internal Shipment ID | NA |
| 4 | Generated Invoice ID | Increff’s generated Invoice ID OR System Invoice ID | NA |
| 5 | Box ID | Box ID | NA |
| 6 | Increff Order ID | Increff’s Order ID OR System Order ID | |
| 7 | Sub Order ID | System Sub Order ID | NA |
| 8 | Channel Order ID | Channel Order ID | NA |
| 9 | Pre/Post Pack Staging Location |
| Mandatory |
| 10 | Order Created From | Order created from the date | Date Range : 31 |
| 11 | Order Created To | Order created till the date | |
| 12 | SLA From | SLA from the date | Date Range : 31 |
| 13 | SLA To | SLA till the date | |
| 14 | Invoice From | Invoice created from the date | Date Range : 31 |
| 15 | Invoice To | Invoice created till the date | |
| 16 | External Gate Pass Code | External Gate Pass Code | NA |
| 17 | Pre/ Post Pack Staging Location ID | Pre/Post Pack Staging Location | NA |