By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| StartDate | EndDate | InventoryID | AvailableQty | OutgoingQty | DeltaQty | CummulativeAvailQty |
|---|---|---|---|---|---|---|
| 2023-01-09 | 2023-01-15 | 00069 | 2 | 1 | 1 | 0 |
| 2023-01-16 | 2023-01-22 | 00069 | 2 | 2 | 0 | 0 |
| 2023-01-23 | 2023-01-29 | 00069 | 0 | 3 | -3 | 0 |
| 2023-01-09 | 2023-01-15 | 00071 | 8 | 5 | 3 | 0 |
| 2023-01-16 | 2023-01-22 | 00071 | 3 | 2 | 1 | 0 |
| 2023-01-23 | 2023-01-29 | 00071 | 1 | 3 | -2 | 0 |