Overview

In order to list the invoices for a given purchase order, we need to populate the order-invoice-relationship table. This should happen when creating/deleting invoice lines.

Approach

The orders-invoice-relationships API should be called when creating/removing invoice-lines.

Upon invoice-line creation

GET /orders-storage/order-invoice-relns?query=purchaseOrderId==<poId> and invoiceId==<invId>

POST /orders-storage/order-invoice-relns (if needed)
Gracefully handle failures due to record already existing

Upon invoice-line deletion

Acceptance Criteria

• The order-invoice-relationships table is updated upon invoice-line creation/deletion

• unit tests are updated

• api tests are updated