Example Table
| Reference | Status / Type | Payment type | Main amount | Order reference | |
|---|---|---|---|---|---|
| 1-2-3 | Pending / Auth |  | £159.00 | order123 | |
| 1-2-4 | Settled / Auth |  | £237.00 | order124 | |
| 1-2-5 | Settling / Auth |  | £262.00 | order125 | |
| 1-2-6 | Manual / Refund |  | £305.00 | order126 | |
| 1-2-7 | Settled / Refund | | £356.00 | order127 |