Skip to end of banner
Go to start of banner

ERM-Agreements Costs - Cost Attributes

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »


Database schemaTableAttributesDerived tableEditorStatus
folio_agreementssubscription_agreement

sa_id
sa_name
sa_description

https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement.sqlAxel(tick)
folio_agreementssubscription_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.sqlAxel(tick)
folio_agreementsentitlementent_idhttps://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_subscription_agreement_entitlement.sqlAxel(tick)
folio_agreementsremote_license_linkrll_owner (sa_id)
rol_remote_id (lic_id)		https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sqlStefan(tick)
folio_organizationsorganizationsname (for invoice & purchase order)purchase_order_transactions
invoice_transactions		Axel(tick)
folio_licenseslicenselic_id
lic_name		https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/licenses_license_ext.sqlStefan(tick)
folio_agreementsorder_linepol_owner_fk → ent_id
pol_id → po_line_id (purchase_order_transactions)		Add with left join to erm_agreements_subscription_agreement_entitlementAxel(tick)

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.sqlAxel(tick)
folio_invoices
folio_finance

invoices
invoice_lines
transactions

...https://github.com/folio-org/folio-analytics/blob/main/sql_2g/derived_tables/invoice_transactions.sqlAxel(tick)
folio_agreementscustoms_properties ??? Needed?
https://github.com/folio-org/folio-analytics/blob/erm/sql/derived_tables/erm_agreements_custom_property.sqlAsk ERM Team(tick)
  • No labels