| 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 |
|
|
|
|
|
|