Skip to end of banner
Go to start of banner

ERM - OpenAccess derived table for charges 'openaccess_charges'

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 4 Next »

Description Detail

Overview

  • The purpose of this derived table is to show informations about the records in the table "folio_oa.charges" and their linked tables and reference data.

Github Issue

Folio AttributeFolio Data Element DescriptionFK (From table)PK (To table)Notes
Table name: folio_oa.charge



version



ch_id



ch_amount_fk



ch_exchange_rate_fk



ch_description



ch_discount



ch_discount_type_fk



ch_category_fk



ch_owner_fk



ch_invoice_reference



ch_invoice_line_item_reference



ch_discount_note



ch_tax



ch_charge_status_fk



ch_date_created



ch_last_updated



ch_payment_period



Table name: folio_oa.exchange_rate



id



version



from_currency



to_currency



coefficient



Table name: folio_oa.monetary_value



id



version



basecurrency



monval



Table name: folio_oa.refdata_value



rdv_id



rdv_version



rdv_value



rdv_owner



rdv_label



  • No labels