| Database schema | Table | Attributes | Derived table | Editor |
|---|---|---|---|---|
| folio_agreements | subscription_agreement | sa_id sa_name sa_description Plus possible vendor location: subscripton_agreement: sa_vendor_reference → agreements:org subscripton_agreement_org - sao_org_fk → agreements:org - sao_role → rdv_value Knowledgebase!!!!! package: pkg_vendor_id → agreements:org | ???.erm_agreements_subscription_agreement | Axel |
| folio_agreements | entitlement | ent_id | ??.erm_agreements_subscription_agreement_entitlement | Axel |
| folio_agreements | remote_license_link | rll_owner (sa_id) rol_remote_id (lic_id) | Stefan | |
| folio_organizations | organizations | name (for invoice & purchase order) | purchase_order_transactions invoice_transactions | Axel |
| folio_licenses | license | lic_id lic_name | Stefan | |
| folio_agreements | order_line | pol_owner_fk → ent_id pol_id → po_line_id (purchase_order_transactions) | left join to (integrate) erm_agreements_subscription_agreement_entitlement | Axel |
folio_orders | purchase_order_transactions | |||
| folio_invoices folio_finance | invoice_transactions | |||
| folio_agreements | customs_properties ??? Needed? | Ask ERM Team |
General
Content
Integrations