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' | 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' | 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' | |