diff options
Diffstat (limited to 'python/report_ops/custodians.py')
| -rw-r--r-- | python/report_ops/custodians.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/report_ops/custodians.py b/python/report_ops/custodians.py index 5702b278..a819e332 100644 --- a/python/report_ops/custodians.py +++ b/python/report_ops/custodians.py @@ -11,7 +11,7 @@ from typing import ClassVar from dataclasses import dataclass _sql = ( - "INSERT INTO bond_csv_upload (allocationid, cusip, principal, interest) SELECT id, identifier, principal_payment, " + "INSERT INTO bond_csv_upload (allocationid, identifier, principal, interest) SELECT id, identifier, principal_payment, " "accrued_payment FROM bond_trades WHERE trade_date=%s AND account=%s AND tradeid IS NOT NULL ON CONFLICT DO NOTHING RETURNING allocationid;" ) |