Looking at the details report for batches I realise we are not tracking the reversal trxn IDs. Also, it would probably simplify the code....
Christine - I got buy in for adding in auth_id and capture_id while we are adding these
Description
Description
Details
Details
Related Changes in Gerrit:
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Add new tracking columns to wmf_contribution_extra. | wikimedia/fundraising/crm | master | +66 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T419629 Epic: Reconciliation (Audit framework) | |||
| Open | None | T419645 Intacct Reconciliation Ready for Go live | |||
| Resolved | None | T420155 Field-a-polooza | |||
| Resolved | None | T419649 New WMFContributionExtra fields backend_processor_reversal_id & payment_orchestrator_reversal_id & auth_id & capture_id |
Event Timeline
Comment Actions
ALTER TABLE wmf_contribution_extra
ADD COLUMN backend_processor_reversal_id VARCHAR(255) NULL,
ADD COLUMN payment_orchestrator_reversal_id VARCHAR(255) NULL,
ADD COLUMN auth_id VARCHAR(255) NULL,
ADD COLUMN capture_id VARCHAR(255) NULL,
ADD INDEX index_backend_processor_reversal_id (backend_processor_reversal_id),
ADD INDEX index_payment_orchestrator_reversal_id (payment_orchestrator_reversal_id),
ADD INDEX index_auth_id (auth_id),
ADD INDEX index_capture_id (capture_id);ALTER TABLE log_wmf_contribution_extra
ADD COLUMN backend_processor_reversal_id VARCHAR(255) NULL,
ADD COLUMN payment_orchestrator_reversal_id VARCHAR(255) NULL,
ADD COLUMN auth_id VARCHAR(255) NULL,
ADD COLUMN capture_id VARCHAR(255) NULL;Comment Actions
Change #1253684 had a related patch set uploaded (by Eileen; author: Eileen):
[wikimedia/fundraising/crm@master] Add new tracking columns to wmf_contribution_extra.
Comment Actions
Change #1253684 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Add new tracking columns to wmf_contribution_extra.
Comment Actions
MariaDB [civicrm]> ALTER TABLE wmf_contribution_extra
-> ADD COLUMN backend_processor_reversal_id VARCHAR(255) NULL,
-> ADD COLUMN payment_orchestrator_reversal_id VARCHAR(255) NULL,
-> ADD COLUMN auth_id VARCHAR(255) NULL,
-> ADD COLUMN capture_id VARCHAR(255) NULL,
-> ADD INDEX index_backend_processor_reversal_id (backend_processor_reversal_id),
-> ADD INDEX index_payment_orchestrator_reversal_id (payment_orchestrator_reversal_id),
-> ADD INDEX index_auth_id (auth_id),
-> ADD INDEX index_capture_id (capture_id);
Query OK, 0 rows affected (1 hour 27 min 47.511 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [civicrm]>MariaDB [civicrm]> ALTER TABLE log_wmf_contribution_extra
-> ADD COLUMN backend_processor_reversal_id VARCHAR(255) NULL,
-> ADD COLUMN payment_orchestrator_reversal_id VARCHAR(255) NULL,
-> ADD COLUMN auth_id VARCHAR(255) NULL,
-> ADD COLUMN capture_id VARCHAR(255) NULL;
Query OK, 0 rows affected (32 min 56.572 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [civicrm]>