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 5 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 TableFolio AttributeDescriptionDatatypeSample OutputFK (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