Shipped Order Items Detail Report - WMS
- Prakash Nagulapati
Navigate To
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
Description
Provides Order, Item level details for a shipped Outward orders.
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 | Parent Order ID | 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 | Order Type | Type of the Order | NA |
|
| 8 | Pack Type | Type of packing - B2B or B2C | NA |
|
| 9 | System Order Time | Time when Order was created in the Increff System | Â NA | 2023-01-01 12:34:56 |
| 10 | Dispatch Time | Order dispatch timestamp | Â | 2023-01-01 12:34:56 |
| 11 | Outward Box ID | Increff’s unique Box ID which is outwarded |  | 3245454353 |
| 12 | System Invoice ID | Increff’s Invoice ID | NA | 123123 |
| 13 | Item ID | Increff’s unique Item ID | NA | 1241231413 |
| 14 | External Item Code | Â | NA | 2023-01-01 12:34:56 |
| 15 | Channel SKU ID | Â | Â | Â |
| 16 | Selling Price | Â | NA | 1242.23 |
| 17 | Sales Channel | Channel through which order is placed | Â | FLIPKARTV3 |
| 18 | Client SKU ID / EAN | Client SKU ID | Â | 1233512423 |
| 19 | UOM SKU | If SKU is UOM or NOT | NA | 0 or 1 |
| 20 | Each Client SKU ID / EAN | Client SKU ID of Eaches leves | If SKU is not part of UOM | 1231212312 |
| 21 | Each Qty | Eaches Quantity | NA | 51 |
| 22 | Global SKU ID | Increff’s unique SKU ID | NA | 5234524241 |
| 23 | Customer Name | Customer / Partner Name | NA | name |
| 24 | Image URL | URL of image | If not provided | |
| 25 | Actor | Â | Â | name |
| 26 | Table ID | Table ID | Â | abcd123 |
| 27 | Packing Table Timestamp | Packing Table Timestamp | NA | 2023-01-01 12:34:56 |
| 28 | Packed / Shipment Closed Time | Packed / Shipment Closed Time | NA | 2023-01-01 12:34:56 |
| 29 | External Serial Code Required | Does the SKU requires External Serial Code or not | NA |
|
| 30 | External Serial Code Mapping Timestamp | Timestamp of last mapping the external serial code | If the external serial code is not mapped before the corresponding outward | 2023-01-01 12:34:56 |
| 31 | AWB Number | AWB Number of Shipment | Â | abcd123 |
| 32 | Length | Length of Box | If not provided | 12.34 |
| 33 | Breadth | Breadth of Box | If not provided | 12.34 |
| 34 | Height | Height of Box | If not provided | 12.34 |
| 35 | Weight | Weight of Box | If not provided | 12.34 |
| 36 | Volume Weight | Volume Weight | If not provided | 12.34 |
| 37 | External Serial Code | External Serial Code | If not provided | abcd123 |
| 38 | Box SKU ID | Box SKU ID | If not provided | abcd123 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Fulfilment Locations | Name of fulfilment locations | Mandatory |
| 2 | Client | Name of client | Mandatory |
| 3 | System Order ID | Increff’s unique system order ID | NA |
| 4 | System Sub Order ID | Increff’s unique sub order ID | NA |
| 5 | Channel Order ID | Order ID by channel | NA |
| 6 | Item ID | Increff’s unique Item ID | NA |
| 7 | External Item Code | Â | NA |
| 8 | Order From | Ordered from the date | Date Range : 7 |
| 9 | Order To | Ordered till the date |
FAQs
Â
Â