By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SKU | TransactionType | WarehouseCode | TransactionDate | Qty |
---|---|---|---|---|
100 | IN | WH1 | 2021-04-30 | 100 |
100 | OUT | WH1 | 2021-05-02 | 20 |
100 | OUT | WH1 | 2021-05-04 | 50 |
100 | OUT | WH1 | 2021-05-05 | 25 |
100 | IN | WH1 | 2021-05-11 | 30 |
100 | OUT | WH1 | 2021-05-15 | 30 |
100 | IN | WH1 | 2021-05-16 | 30 |
101 | IN | WH1 | 2021-04-30 | 30 |
102 | IN | WH1 | 2021-05-15 | 25 |
102 | OUT | WH1 | 2021-05-17 | 2 |
102 | ADJ | WH1 | 2021-05-18 | 5 |
102 | ADJ | WH1 | 2021-05-18 | -1 |
100 | IN | WH2 | 2021-04-30 | 50 |
100 | OUT | WH2 | 2021-05-02 | 30 |
100 | OUT | WH2 | 2021-05-04 | 20 |
100 | IN | WH2 | 2021-05-10 | 30 |
101 | IN | WH2 | 2021-05-01 | 25 |
101 | OUT | WH2 | 2021-05-12 | 20 |
SKU | TransactionType | WarehouseCode | TransactionDate | Qty | qty_in_so_far | qty_out_final | qty_final | aging |
---|---|---|---|---|---|---|---|---|
100 | IN | WH1 | 2021-04-30 | 100 | 100 | 125 | 0 | 21 |
100 | IN | WH2 | 2021-04-30 | 50 | 50 | 50 | 0 | 21 |
101 | IN | WH1 | 2021-04-30 | 30 | 30 | 0 | 30 | 21 |
101 | IN | WH2 | 2021-05-01 | 25 | 25 | 20 | 5 | 20 |
100 | IN | WH2 | 2021-05-10 | 30 | 80 | 50 | 30 | 11 |
100 | IN | WH1 | 2021-05-11 | 30 | 130 | 125 | 5 | 10 |
102 | IN | WH1 | 2021-05-15 | 25 | 25 | 2 | 23 | 6 |
100 | IN | WH1 | 2021-05-16 | 30 | 160 | 125 | 30 | 5 |
SKU | TransactionType | WarehouseCode | TransactionDate | Qty | grp |
---|---|---|---|---|---|
100 | IN | WH1 | 2021-04-30 | 100 | 1 |
100 | IN | WH1 | 2021-05-11 | 30 | 2 |
100 | IN | WH1 | 2021-05-16 | 30 | 3 |
101 | IN | WH1 | 2021-04-30 | 30 | 1 |
102 | IN | WH1 | 2021-05-15 | 25 | 1 |
102 | ADJ | WH1 | 2021-05-18 | 5 | 1 |
102 | ADJ | WH1 | 2021-05-18 | -1 | 1 |
100 | IN | WH2 | 2021-04-30 | 50 | 1 |
100 | IN | WH2 | 2021-05-10 | 30 | 2 |
101 | IN | WH2 | 2021-05-01 | 25 | 1 |
SKU | WarehouseCode | grp | TransactionDate | Qty |
---|---|---|---|---|
100 | WH1 | 1 | 2021-04-30 | 100 |
100 | WH1 | 2 | 2021-05-11 | 30 |
100 | WH1 | 3 | 2021-05-16 | 30 |
101 | WH1 | 1 | 2021-04-30 | 30 |
102 | WH1 | 1 | 2021-05-15 | 29 |
100 | WH2 | 1 | 2021-04-30 | 50 |
100 | WH2 | 2 | 2021-05-10 | 30 |
101 | WH2 | 1 | 2021-05-01 | 25 |
SKU | WarehouseCode | TransactionType | TransactionDate | Qty |
---|---|---|---|---|
100 | WH1 | IN | 2021-04-30 | 100 |
100 | WH1 | OUT | 2021-05-02 | 20 |
100 | WH1 | OUT | 2021-05-04 | 50 |
100 | WH1 | OUT | 2021-05-05 | 25 |
100 | WH1 | IN | 2021-05-11 | 30 |
100 | WH1 | OUT | 2021-05-15 | 30 |
100 | WH1 | IN | 2021-05-16 | 30 |
101 | WH1 | IN | 2021-04-30 | 30 |
102 | WH1 | IN | 2021-05-15 | 29 |
102 | WH1 | OUT | 2021-05-17 | 2 |
100 | WH2 | IN | 2021-04-30 | 50 |
100 | WH2 | OUT | 2021-05-02 | 30 |
100 | WH2 | OUT | 2021-05-04 | 20 |
100 | WH2 | IN | 2021-05-10 | 30 |
101 | WH2 | IN | 2021-05-01 | 25 |
101 | WH2 | OUT | 2021-05-12 | 20 |
SKU | WarehouseCode | TransactionType | TransactionDate | qty_out_final | qty_in_so_far | Qty | qty_final | aging |
---|---|---|---|---|---|---|---|---|
100 | WH1 | IN | 2021-04-30 | 125 | 100 | 100 | 0 | 21 |
100 | WH2 | IN | 2021-04-30 | 50 | 50 | 50 | 0 | 21 |
101 | WH1 | IN | 2021-04-30 | 0 | 30 | 30 | 30 | 21 |
101 | WH2 | IN | 2021-05-01 | 20 | 25 | 25 | 5 | 20 |
100 | WH2 | IN | 2021-05-10 | 50 | 80 | 30 | 30 | 11 |
100 | WH1 | IN | 2021-05-11 | 125 | 130 | 30 | 5 | 10 |
102 | WH1 | IN | 2021-05-15 | 2 | 29 | 29 | 27 | 6 |
100 | WH1 | IN | 2021-05-16 | 125 | 160 | 30 | 35 | 5 |