bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 57 forks source link

Datawarehouse - Details View - Clean up and small improvements #21001

Closed seeker25 closed 1 week ago

seeker25 commented 1 week ago

Take all of the development work that has been done by payment methods, join it together - get it deployed to Gen can use it

Create separate Materialized views with fixes: reconciliation_details_bcol - Done reconciliation_details_rs - Done reconciliation_details_disbursement - Done reconciliation_details_ar - WIP reconciliation_details_ejv - Done

Done: Tweaks and asks too: Fix payload for invoice_details -> "Serial/Vin": "0F021644" <-- Invoice Id so we can figure out the details Rename colume invoice_number -> identifier include Business_identifier invoice_details -> details Add in external_effective_date is_refund? corp_type -> description