Update finance_transaction_purchase_order.sql

folio-org / folio-analytics

Community query repository for FOLIO analytics based on Metadb/LDP

Apache License 2.0

15 stars 30 forks source link

Update finance_transaction_purchase_order.sql #848

Closed sbeltaine closed 3 months ago

sbeltaine commented 4 months ago

This update is being submitted on behalf of Joanne Leary. It corrects the PO line acquisition method and PO order type data field extractions from the JSON data array in the finance_transaction_purchase_order derived table for Metadb. It also adds the acquisition method name to the table. The finance_transaction_purchase_order is already included in runlist.txt.

sbeltaine commented 4 months ago

This pull request closes Issue #847.

sbeltaine commented 3 months ago

Irina, Thanks for reviewing, and for catching that error. I have just updated "Should not change once create" to "Should not change once created" in this PR.