...
Fields | Description | This Column Can be NULL | Sample Data | ||
|---|---|---|---|---|---|
| 1 | Client Name | Client to which the order belongs | NA | Increff | |
| 2 | Fulfillment Location Name | Warehouse to which the order belongs | NA | wms_hsr | |
| 3 | System Order ID | System Order ID | NA | 324421 | |
| 24 | Channel Order ID | Channel Order ID | NA | abcd123 | |
| 35 | Parent Order ID | Parent Order ID | NA | abcd123 | 4|
| 6 | Order Type | Type of Inward Order | NA |
| |
| 7 | Vendor Name | Partner Name | NA | abc333 | |
| 8 | Item ID | Item ID | NA | 434214324 | |
| 59 | Item Status | Status of the Item | NA |
| |
| 610 | Item QC Status | QC Status of the Item while inwarding |
| ||
| 711 | Bin QC Status | QC Status of the Bin | If Item is Outward-ed |
| |
| 812 | External Item Code | External Item Code | NA | abcd123 | |
| 913 | Client SKU ID / EAN | Client SKU ID | NA | abcd123 | |
| 1014 | UOM SKU | Boolean - If UOM SKU or not | NA | 0 or 1 | |
| 1115 | Each Client SKU ID | SKU ID of each Item | If not a UOM SKU | abcd123 | |
| 1216 | Each Qty | Each Qty in box | If not a UOM SKU | 34 | |
| 1317 | Gate Entry ID | Gate entry ID | If not yet inwarded | 23455 | |
| 1418 | Gate Entry Time | Gate entry time | If not yet inwarded | 2023-01-01 12:34:56 | |
| 1519 | GRN Time | GRN Time | If not yet GRNed | 2023-01-01 12:34:56 | |
| 1620 | Bin Change Time | Bin Change Time | If not added to any Bin after inward | 2023-01-01 12:34:56 | |
| 1721 | Bin Change Description | Bin Change Description | If No Bin Change has been done after inward | 2023-01-01 12:34:56 | |
| 1822 | Old Bin ID | Old Bin ID | If No Bin Change has been done after inward | 465787456 | |
| 1923 | Putaway Time | Put away time | If Putaway hasn’t been done after inward | 2023-01-01 12:34:45 | |
| 2024 | Putaway Description | Put away description | If Putaway hasn’t been done after inward | abcd123 | |
| 2125 | Putaway Bin ID | Putaway Bin ID | If Item is not made LIVE yet | 86457654 | |
| 2226 | Putaway Bin Location Name | Putaway Bin Location Name |
| abcd123 | |
| 2327 | External Serial Code | External serial code | If not mapped in DB in inward ledger | abcd123 |
...