By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 14 Duplicates: 0 Warnings: 0
| DateOfActivity | CustomerReference | ReferenceLine | Description | ReceivableAmount |
|---|---|---|---|---|
| 2022-10-24 | CUST567 | 1 | Credit Purchase | 20000 |
| 2022-10-24 | CUST567 | 4 | Credit Purchase | 10000 |
| 2022-10-24 | CUST555 | 2 | Credit Purchase | 50000 |
| 2022-10-27 | CUST555 | 2 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 4 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 1 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 4 | Repayment | -3500 |
| 2022-10-27 | CUST567 | 4 | Repayment | -6500 |
| 2022-11-13 | CUST567 | 1 | Repayment | -10000 |
| 2022-11-13 | CUST567 | 1 | Repayment | -2000 |
| 2022-11-18 | CUST567 | 1 | Contract Sign | 0 |
| 2022-11-18 | CUST567 | 1 | Repayment | -3000 |
| 2022-10-27 | CUST123 | 4 | Repayment | -5000 |
| 2022-10-27 | CUST123 | 4 | Credit Purchase | 15000 |
| CustomerReference | ReferenceLine |
|---|---|
| CUST567 | 1 |
| CUST555 | 2 |
| CUST123 | 4 |
| DateOfActivity | CustomerReference | ReferenceLine | Description | ReceivableAmount |
|---|---|---|---|---|
| 2022-10-24 | CUST567 | 1 | Credit Purchase | 20000 |
| 2022-10-24 | CUST567 | 4 | Credit Purchase | 10000 |
| 2022-10-24 | CUST555 | 2 | Credit Purchase | 50000 |
| 2022-10-27 | CUST555 | 2 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 4 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 1 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 4 | Repayment | -3500 |
| 2022-10-27 | CUST567 | 4 | Repayment | -6500 |
| 2022-11-13 | CUST567 | 1 | Repayment | -10000 |
| 2022-11-13 | CUST567 | 1 | Repayment | -2000 |
| 2022-11-18 | CUST567 | 1 | Contract Sign | 0 |
| 2022-11-18 | CUST567 | 1 | Repayment | -3000 |
| 2022-10-27 | CUST123 | 4 | Repayment | -5000 |
| 2022-10-27 | CUST123 | 4 | Credit Purchase | 15000 |
| DateOfActivity | CustomerReference | ReferenceLine | Description | ReceivableAmount |
|---|---|---|---|---|
| 2022-10-24 | CUST567 | 1 | Credit Purchase | 20000 |
| 2022-10-24 | CUST555 | 2 | Credit Purchase | 50000 |
| 2022-10-27 | CUST555 | 2 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 1 | Contract Sign | 0 |
| 2022-11-13 | CUST567 | 1 | Repayment | -10000 |
| 2022-11-13 | CUST567 | 1 | Repayment | -2000 |
| 2022-11-18 | CUST567 | 1 | Contract Sign | 0 |
| 2022-11-18 | CUST567 | 1 | Repayment | -3000 |
| 2022-10-27 | CUST123 | 4 | Repayment | -5000 |
| 2022-10-27 | CUST123 | 4 | Credit Purchase | 15000 |
| DateOfActivity | CustomerReference | ReferenceLine | Description | ReceivableAmount |
|---|---|---|---|---|
| 2022-10-24 | CUST567 | 1 | Credit Purchase | 20000 |
| 2022-10-24 | CUST555 | 2 | Credit Purchase | 50000 |
| 2022-10-27 | CUST555 | 2 | Contract Sign | 0 |
| 2022-10-27 | CUST567 | 1 | Contract Sign | 0 |
| 2022-11-13 | CUST567 | 1 | Repayment | -10000 |
| 2022-11-13 | CUST567 | 1 | Repayment | -2000 |
| 2022-11-18 | CUST567 | 1 | Contract Sign | 0 |
| 2022-11-18 | CUST567 | 1 | Repayment | -3000 |
| 2022-10-27 | CUST123 | 4 | Repayment | -5000 |
| 2022-10-27 | CUST123 | 4 | Credit Purchase | 15000 |