Details
-
Story
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
None
-
ACQ Sprint 111
-
2
-
Thunderjet
Description
Overview
In order to make it easier to discover which invoices are related to an order, and to manage these relationships, we need to make a few changes to the order-invoice-relationships table.
- Add a unique constraint on (purchaseOrderId, invoiceId)
- Add alias/table alias to help with cross-index subqueries
Acceptance Criteria
- changes above are made
- data migration scripts ensure uniqueness, removing records as needed
- unit tests are updated
TestRail: Results
Attachments
Issue Links
- defines
-
UXPROD-2630 Thunderjet - R2 Enhancements/Bugfixes
-
- Closed
-
- relates to
-
MODINVOICE-148 Related invoices not displaying on PO
-
- Closed
-