ERM-Agreements Costs - Cost Attributes

Database schema	Table	Attributes	Derived table	Editor
folio_agreements	subscription_agreement	sa_id sa_name sa_description	https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement.sql	Axel
folio_agreements	subscription_agreement_org org	sao_role sao_role→ refdata_value org_orgs_uuid org_name	https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/agreements_subscription_agreement_org_ext.sql	Axel
folio_agreements	entitlement	ent_id	https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement_entitlement.sql	Axel
folio_agreements	remote_license_link	rll_owner (sa_id) rol_remote_id (lic_id)	https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sql	Stefan
folio_organizations	organizations	name (for invoice & purchase order)	purchase_order_transactions invoice_transactions	Axel
folio_licenses	license	lic_id lic_name	https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sql	Stefan
folio_agreements	order_line	pol_owner_fk → ent_id pol_id → po_line_id (purchase_order_transactions)	Add with left join to erm_agreements_subscription_agreement_entitlement	Axel
folio_orders folio_finance	purchase_order po_lines transactions	...	https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/purchase_order_transactions.sql	Axel
folio_invoices folio_finance	invoices invoice_lines transactions	...	https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sql	Axel
folio_agreements	customs_properties		https://github.com/folio-org/folio-analytics/blob/main/sql_metadb/derived_tables/agreements_custom_property.sql	Stefan (Additions to the existing derived table)