By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| acctid | payseq | totalamount | acctnum | expectprice | payorder | paidamount | CummulativeTotalAmount | CurrentCummulativeAllocation | PriorCummulativeTotalAmount | PriorCummulativeAllocation |
|---|---|---|---|---|---|---|---|---|---|---|
| aac1 | 99 | 1000.00 | 1111aa | 800.00 | 1 | 800.00 | 1000.00 | 800.00 | 0.00 | 0.00 |
| aac1 | 99 | 1000.00 | 1111bb | 800.00 | 2 | 200.00 | 1000.00 | 200.00 | 0.00 | 0.00 |
| aac1 | 99 | 1000.00 | 1111cc | 800.00 | 3 | 0.00 | 1000.00 | 0.00 | 0.00 | 0.00 |
| aac1 | 99 | 1000.00 | 1111dd | 1200.00 | 4 | 0.00 | 1000.00 | 0.00 | 0.00 | 0.00 |
| aac1 | 100 | 2000.00 | 1111aa | 800.00 | 1 | 0.00 | 3000.00 | 800.00 | 1000.00 | 800.00 |
| aac1 | 100 | 2000.00 | 1111bb | 800.00 | 2 | 600.00 | 3000.00 | 800.00 | 1000.00 | 200.00 |
| aac1 | 100 | 2000.00 | 1111cc | 800.00 | 3 | 800.00 | 3000.00 | 800.00 | 1000.00 | 0.00 |
| aac1 | 100 | 2000.00 | 1111dd | 1200.00 | 4 | 600.00 | 3000.00 | 600.00 | 1000.00 | 0.00 |
| acctid | payseq | totalamount | acctnum | expectprice | payorder | paidamount |
|---|---|---|---|---|---|---|
| aac1 | 99 | 1000.00 | 1111aa | 800.00 | 1 | 800.00 |
| aac1 | 99 | 1000.00 | 1111bb | 800.00 | 2 | 200.00 |
| aac1 | 99 | 1000.00 | 1111cc | 800.00 | 3 | 0.00 |
| aac1 | 99 | 1000.00 | 1111dd | 1200.00 | 4 | 0.00 |
| aac1 | 100 | 2000.00 | 1111aa | 800.00 | 1 | 800.00 |
| aac1 | 100 | 2000.00 | 1111bb | 800.00 | 2 | 800.00 |
| aac1 | 100 | 2000.00 | 1111cc | 800.00 | 3 | 400.00 |
| aac1 | 100 | 2000.00 | 1111dd | 1200.00 | 4 | 0.00 |