| inventory_record_id | record_date | warehouse_id | warehouse_region | sku_id | product_category | supplier_id | supplier_region | opening_stock | receipts_units | issued_units | closing_stock | damaged_units | expired_units | safety_stock | reorder_point | reorder_quantity | lead_time_days | supplier_on_time_pct | unit_cost | inventory_value | storage_utilization_pct | picking_time_min | order_accuracy_pct | stockout_flag | overstock_flag | forecast_demand_units | actual_demand_units | inventory_turnover | cycle_count_variance | warehouse_temperature_c |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INV200000 | 2024-05-09 | WH04 | North | SKU7603 | Pharma | SUP368 | Central | 320 | 193 | 37 | 476 | 7 | 2 | 36 | 177 | 208 | 10 | 79.6 | 4756.69 | 257810.7 | 78.4 | 18.5 | 94.6 | 0 | 1 | 36.0 | 37 | 2.33 | -1 | 22.3 |
| INV200001 | 2023-01-01 | WH01 | Central | SKU8039 | Industrial | SUP973 | East | 473 | 205 | 44 | 634 | 3 | 2 | 59 | 168 | 62 | 25 | 91.4 | 2774.69 | 2619468.29 | 38.8 | 2.6 | 99.7 | 0 | 1 | 45.0 | 44 | 2.08 | 0 | 20.5 |
| INV200002 | 2023-01-24 | WH01 | West | SKU6227 | Electronics | SUP582 | West | 63 | 181 | 43 | 201 | 1 | 4 | 77 | 155 | 343 | 14 | 82.5 | 568.16 | 438052.65 | 44.0 | 12.4 | 93.5 | 0 | 0 | 39.0 | 43 | 6.39 | 6 | 25.3 |
| INV200003 | 2024-04-29 | WH02 | North | SKU1317 | Automotive | SUP246 | West | 227 | 247 | 44 | 430 | 5 | 1 | 10 | 87 | 56 | 27 | 82.8 | 4024.85 | 182286.82 | 74.2 | 28.4 | 98.7 | 0 | 1 | 40.0 | 44 | 3.06 | -1 | 27.6 |
| INV200004 | 2023-11-18 | WH03 | West | SKU3361 | Apparel | SUP491 | North | 27 | 230 | 37 | 220 | 0 | 2 | 50 | 50 | 146 | 17 | 79.7 | 3534.01 | 526243.0 | 50.8 | 11.2 | 97.5 | 0 | 0 | 39.0 | 37 | 5.02 | 8 | 22.0 |
| INV200005 | 2023-07-27 | WH05 | West | SKU5358 | Pharma | SUP522 | Central | 61 | 166 | 48 | 179 | 5 | 0 | 18 | 39 | 143 | 7 | 79.8 | 2174.33 | 712387.59 | 53.6 | 28.1 | 99.5 | 0 | 0 | 49.0 | 48 | 8.0 | -6 | 22.1 |
| INV200006 | 2023-07-16 | WH06 | North | SKU5053 | Pharma | SUP265 | Central | 417 | 224 | 49 | 592 | 4 | 1 | 83 | 75 | 112 | 6 | 96.0 | 4261.45 | 477526.35 | 65.9 | 20.4 | 93.3 | 0 | 1 | 47.0 | 49 | 2.48 | -1 | 19.6 |
| INV200007 | 2023-12-07 | WH01 | North | SKU2608 | Industrial | SUP879 | East | 221 | 193 | 38 | 376 | 4 | 3 | 78 | 145 | 93 | 10 | 77.6 | 4014.18 | 1738961.47 | 77.2 | 17.0 | 90.9 | 0 | 0 | 37.0 | 38 | 3.02 | 5 | 20.1 |
Showing first 8 rows of 11,483.