Navigate To:
Description
Provides Items inwarded against a PO with their GRN, Putaway and Bin Change timestamps.
Fields
Fields | Description | This Column Can be NULL | Sample Data | |
|---|---|---|---|---|
| 1 | System Order ID | System Order ID | NA | 324421 |
| 2 | Channel Order ID | Channel Order ID | NA | abcd123 |
| 3 | Parent Order ID | Parent Order ID | NA | abcd123 |
| 4 | Item ID | Item ID | NA | 434214324 |
| 5 | Item Status | Status of the Item | NA |
|
| 6 | Item QC Status | QC Status of the Item while inwarding |
| |
| 7 | Bin QC Status | QC Status of the Bin | If Item is Outward-ed |
|
| 8 | External Item Code | External Item Code | NA | abcd123 |
| 9 | Client SKU ID / EAN | Client SKU ID | NA | abcd123 |
| 10 | UOM SKU | Boolean - If UOM SKU or not | NA | 0 or 1 |
| 11 | Each Client SKU ID | SKU ID of each Item | If not a UOM SKU | abcd123 |
| 12 | Each Qty | Each Qty in box | If not a UOM SKU | 34 |
| 13 | Gate Entry ID | Gate entry ID | If not yet inwarded | 23455 |
| 14 | Gate Entry Time | Gate entry time | If not yet inwarded | 2023-01-01 12:34:56 |
| 15 | GRN Time | GRN Time | If not yet GRNed | 2023-01-01 12:34:56 |
| 16 | Bin Change Time | Bin Change Time | If not added to any Bin after inward | 2023-01-01 12:34:56 |
| 17 | Bin Change Description | Bin Change Description | If No Bin Change has been done after inward | 2023-01-01 12:34:56 |
| 18 | Old Bin ID | Old Bin ID | If No Bin Change has been done after inward | 465787456 |
| 19 | Putaway Time | Put away time | If Putaway hasn’t been done after inward | 2023-01-01 12:34:45 |
| 20 | Putaway Description | Put away description | If Putaway hasn’t been done after inward | abcd123 |
| 21 | Putaway Bin ID | Putaway Bin ID | If Item is not made LIVE yet | 86457654 |
| 22 | Putaway Bin Location Name | Putaway Bin Location Name |
| abcd123 |
| 23 | External Serial Code | External serial code | If not mapped in DB in inward ledger | abcd123 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Time Zone | To show data in the specified time zone | Mandatory |
| 2 | Channel Order ID | Channel Order ID | Mandatory (Multi Text) |