ERM-Agreements Costs - Cross-module connections

metadb, tested with FOLIO juniper and lotus (The schema can be another in other FOLIO versions!)

From			To
Module	Table	Attribute	Module	Table	Attribute
Agreements	remote_license_link	role_remote_id	Licenses	license	lic_id
Agreements	org	org_orgs_uuid	Organizations	organizations	id
Agreements	?	?	eUsage	?	?
Agreements	order_line	pol_orders_fk	Orders	po_line	id
Orders	purchase_order	jsonb->>'billTo' jsonb->>'shipTo' jsonb->>'vendor'	Organizations	organizations	id
Orders	po_line	id	Invoices	invoice_lines	jsonb->>'poLineId'
Orders	po_line	jsonb->'fundDistribution'->> 'fundId'	Finance	fund	id
Orders	po_line	id	Finance	transaction	jsonb->>'sourcePoLineId'
Orders	purchase_order	id	Finance	transaction	jsonb->>'sourcePurchaseOrderId'
Invoices	invoices	jsonb->>'billTo' jsonb->>'vendorId'	Organizations	organizations	id
Invoices	invoice_lines	jsonb->'fundDistributions'->> 'fundId'	Finance	fund	id
Invoices	invoice_lines	id	Finance	transaction	jsonb->>'sourceInvoiceLineId'
Invoices	invoices	id	Finance	transaction	jsonb->>'sourceInvoiceId'

Reporting SIG