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 Table | Folio Attribute | Description | Datatype | Sample Output | FK (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 |
|
|
|
|
|
|