URGENT - Part 1 - Confirm which NRs have payment so staff can cancel duplicate NRs

Need to confirm which of the following NRs have completed payments:

TRUSUM BY MANNAM INVESTMENTS INC. NR 3625162 - PENDING_PAYMENT NR 0500044 - HOLD NR 3153274 - APPROVED NR 4841273 - APPROVED

BOSTON OUTLOOK CORP NR 5318778 - approved NR 1535127 - approved NR 0724074 - cancelled NR 6762616 - hold NR 6315208 - hold NR 7697100 - hold

FLOER MILLIKEN GROUP PRIVATE WEALTH MANAGEMENT NR 3566824 - approved NR 4745667 - approved

GRAYMARE CREATIONS NR 3747671 - approved NR 6358190 - hold NR 0415501 - hold NR 4636524 - hold NR 7193491 - hold NR 9710006 - PENDING_PAYMENT NR 5711807 - PENDING_PAYMENT

LUNISOLAR NR 8827635 - approved NR 4488004 - approved NR 2440301 - hold NR 6706777 - hold NR 2206760 - PENDING_PAYMENT

TRUSUM BY MANNAM INVESTMENTS INC. NR 3625162 - PENDING_PAYMENT NR 0500044 - HOLD NR 3153274 - APPROVED < -- PAID NR 4841273 - APPROVED

 business_identifier | invoice_status | pay_status | total | paid
---------------------+----------------+------------+-------+------
 NR 0500044          | CREATED        |            |  31.5 |    0
 NR 3153274          | PAID           | COMPLETED  |  31.5 | 31.5
 NR 3625162          | CREATED        |            |  31.5 |    0
 NR 4841273          | CREATED        |            |  31.5 |    0

BOSTON OUTLOOK CORP NR 5318778 - approved <- PAID NR 1535127 - approved NR 0724074 - cancelled NR 6762616 - hold NR 6315208 - hold NR 7697100 - hold <- PAID

 business_identifier | invoice_status | pay_status | total | paid
---------------------+----------------+------------+-------+-------
 NR 0724074          | CREATED        |            |  31.5 |     0
 NR 1535127          | CREATED        |            |  31.5 |     0
 NR 5318778          | PAID           | COMPLETED  |  31.5 |  31.5
 NR 5318778          | PAID           | COMPLETED  | 101.5 | 101.5
 NR 6315208          | CREATED        |            |  31.5 |     0
 NR 6762616          | CREATED        |            |  31.5 |     0
 NR 7697100          | PAID           | COMPLETED  |  31.5 |  31.5

FLOER MILLIKEN GROUP PRIVATE WEALTH MANAGEMENT NR 3566824 - approved NR 4745667 - approved

i.business_identifier in('NR 3566824','NR 4745667')
order by i.business_identifier asc;
 business_identifier | invoice_status | pay_status | total | paid
---------------------+----------------+------------+-------+------
(0 rows)

GRAYMARE CREATIONS NR 3747671 - approved <- PAID NR 6358190 - hold NR 0415501 - hold NR 4636524 - hold NR 7193491 - hold NR 9710006 - PENDING_PAYMENT NR 5711807 - PENDING_PAYMENT

 business_identifier | invoice_status | pay_status | total | paid
---------------------+----------------+------------+-------+-------
 NR 0415501          | CREATED        |            |  31.5 |     0
 NR 3747671          | PAID           | COMPLETED  | 101.5 | 101.5
 NR 3747671          | PAID           | COMPLETED  |  31.5 |  31.5
 NR 4636524          | CREATED        |            |  31.5 |     0
 NR 5711807          | CREATED        |            |  31.5 |     0
 NR 6358190          | CREATED        |            |  31.5 |     0
 NR 7193491          | CREATED        |            |  31.5 |     0
 NR 9710006          | CREATED        |            |  31.5 |     0

LUNISOLAR NR 8827635 - approved <- PAID NR 4488004 - approved NR 2440301 - hold NR 6706777 - hold <- PAID NR 2206760 - PENDING_PAYMENT

 business_identifier | invoice_status | pay_status | total | paid
---------------------+----------------+------------+-------+-------
 NR 6706777          | PAID           | COMPLETED  |  31.5 |  31.5
 NR 8827635          | PAID           | COMPLETED  | 131.5 | 131.5

bcgov / entity

URGENT - Part 1 - Confirm which NRs have payment so staff can cancel duplicate NRs #6657