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' |
| 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 | id | Finance | transaction | jsonb->>'sourceInvoiceId' | |
, multiple selections available,