By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
19 rows affected
customerId | baseCurrencyId | totalOldDebt | totalRecoveredDebt | totalPaidDebt |
---|---|---|---|---|
2 | 1 | 2000 | 950 | 0 |
4 | 1 | 0 | 10 | 0 |
1 | 2 | 100 | 100 | 0 |
2 | 2 | 300 | 500 | 1000 |
customerId | paymentTypeId | baseCurrencyId | subTotalPrice | totalPrice | totalCost |
---|---|---|---|---|---|
1 | 1 | 1 | 5300 | 5300 | 5008 |
2 | 1 | 1 | 292.5 | 287.5 | 181 |
2 | 2 | 1 | 20638.5 | 20538.5 | 492 |
2 | 2 | 2 | 10 | 10 | 1000 |
3 | 1 | 1 | 174.5 | 174.5 | 160.5 |
3 | 2 | 1 | 1172 | 1172 | 6016 |
4 | 1 | 1 | 661 | 661 | 626 |
4 | 2 | 1 | 144 | 144 | 132.25 |
customerId | paymentTypeId | baseCurrencyId | totalPrice | totalCost |
---|---|---|---|---|
2 | 2 | 1 | 91610 | 0 |
3 | 2 | 1 | 115.5 | 0 |