...
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 |
|
| 78 | External Item Code | External Item Code | NA | abcd123 |
| 89 | Client SKU ID / EAN | Client SKU ID | NA | abcd123 |
| 910 | UOM SKU | Boolean - If UOM SKU or not | NA | 0 or 1 |
| 1011 | Each Client SKU ID | SKU ID of each Item | If not a UOM SKU | abcd123 |
| 1112 | Each Qty | Each Qty in box | If not a UOM SKU | 34 |
| 1213 | Gate Entry ID | Gate entry ID | If not yet inwarded | 23455 |
| 1314 | Gate Entry Time | Gate entry time | If not yet inwarded | 2023-01-01 12:34:56 |
| 1415 | GRN Time | GRN Time | If not yet GRNed | 2023-01-01 12:34:56 |
| 1516 | Bin Change Time | Bin Change Time | If not added to any Bin after inward | 2023-01-01 12:34:56 |
| 1617 | Bin Change Description | Bin Change Description | If No Bin Change has been done after inward | 2023-01-01 12:34:56 |
| 1718 | Old Bin ID | Old Bin ID | If No Bin Change has been done after inward | 465787456 |
| 1819 | Putaway Time | Put away time | If Putaway hasn’t been done after inward | 2023-01-01 12:34:45 |
| 1920 | Putaway Description | Put away description | If Putaway hasn’t been done after inward | abcd123 |
| 2021 | Putaway Bin ID | Putaway Bin ID | If Item is not made LIVE yet | 86457654 |
| 2122 | Putaway Bin Location Name | Putaway Bin Location Name |
| abcd123 |
| 2223 | External Serial Code | External serial code | If not mapped in DB in inward ledger | abcd123 |
...