# Younium schema ERD

Table and field reference for the Fivetran Younium connector.

## Table & Field Reference

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| custom_fields | Unknown |  |
| name | Unknown |  |
| three_alpha_code | Unknown |  |
| two_alpha_code | Unknown |  |

### booking_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_id | Unknown | PK, FK |
| acv_amount | Unknown |  |
| acv_base_currency_amount | Unknown |  |
| acv_base_currency_code | Unknown |  |
| acv_currency_code | Unknown |  |
| acv_currency_conversion_date | Unknown |  |
| charge_description | Unknown |  |
| charge_external_crm_id | Unknown |  |
| charge_external_erp_id | Unknown |  |
| charge_id | Unknown |  |
| charge_name | Unknown |  |
| charge_number | Unknown |  |
| cmrr_amount | Unknown |  |
| cmrr_base_currency_amount | Unknown |  |
| cmrr_base_currency_code | Unknown |  |
| cmrr_currency_code | Unknown |  |
| cmrr_currency_conversion_date | Unknown |  |
| created | Unknown |  |
| emrr_amount | Unknown |  |
| emrr_base_currency_amount | Unknown |  |
| emrr_base_currency_code | Unknown |  |
| emrr_currency_code | Unknown |  |
| emrr_currency_conversion_date | Unknown |  |
| fmrr_amount | Unknown |  |
| fmrr_base_currency_amount | Unknown |  |
| fmrr_base_currency_code | Unknown |  |
| fmrr_currency_code | Unknown |  |
| fmrr_currency_conversion_date | Unknown |  |
| modified | Unknown |  |
| one_time_fees_amount | Unknown |  |
| one_time_fees_base_currency_amount | Unknown |  |
| one_time_fees_base_currency_code | Unknown |  |
| one_time_fees_currency_code | Unknown |  |
| one_time_fees_currency_conversion_date | Unknown |  |
| tcv_amount | Unknown |  |
| tcv_base_currency_amount | Unknown |  |
| tcv_base_currency_code | Unknown |  |
| tcv_currency_code | Unknown |  |
| tcv_currency_conversion_date | Unknown |  |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| account_category | Unknown |  |
| booking_type | Unknown |  |
| change_type | Unknown |  |
| classification_chart_color | Unknown |  |
| classification_description | Unknown |  |
| classification_is_system_classification | Unknown |  |
| classification_name | Unknown |  |
| classification_type | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| effective_date | Unknown |  |
| modified | Unknown |  |

### usage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| order_id | Unknown | FK |
| product_id | Unknown | FK |
| charge_description | Unknown |  |
| charge_external_crm_id | Unknown |  |
| charge_external_erp_id | Unknown |  |
| charge_id | Unknown |  |
| charge_name | Unknown |  |
| charge_number | Unknown |  |
| created | Unknown |  |
| description | Unknown |  |
| from_date | Unknown |  |
| import_date | Unknown |  |
| modified | Unknown |  |
| processed | Unknown |  |
| product_description | Unknown |  |
| quantity | Unknown |  |
| rated_price | Unknown |  |
| rated_price_currency_code | Unknown |  |
| source | Unknown |  |
| to_date | Unknown |  |
| unit | Unknown |  |
| custom_fields_** |  |  |

### subscription_product_charge_price_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| subscription_product_charge_id | Unknown | PK, FK |
| subscription_product_id | Unknown | PK, FK |
| description | Unknown |  |
| from_quantity | Unknown |  |
| line_discount_amount | Unknown |  |
| line_discount_percent | Unknown |  |
| list_price | Unknown |  |
| price | Unknown |  |
| price_base | Unknown |  |
| tier | Unknown |  |
| to_quantity | Unknown |  |

### subscription_product_charge_feature

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| subscription_product_charge_id | Unknown | PK, FK |
| subscription_product_id | Unknown | PK, FK |
| code | Unknown |  |
| description | Unknown |  |

### subscription_product_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| subscription_product_id | Unknown | PK, FK |
| charge_id | Unknown | FK |
| order_id | Unknown | FK |
| order_product_id | Unknown | FK |
| acv_amount | Unknown |  |
| acv_base_currency_amount | Unknown |  |
| acv_base_currency_code | Unknown |  |
| acv_currency_code | Unknown |  |
| acv_currency_conversion_date | Unknown |  |
| billing_period | Unknown |  |
| change_state | Unknown |  |
| charge_type | Unknown |  |
| charged_through_date | Unknown |  |
| cmrr_amount | Unknown |  |
| cmrr_base_currency_amount | Unknown |  |
| cmrr_base_currency_code | Unknown |  |
| cmrr_currency_code | Unknown |  |
| cmrr_currency_conversion_date | Unknown |  |
| created | Unknown |  |
| deferred_revenue_account | Unknown |  |
| display_price | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| emrr_amount | Unknown |  |
| emrr_base_currency_amount | Unknown |  |
| emrr_base_currency_code | Unknown |  |
| emrr_currency_code | Unknown |  |
| emrr_currency_conversion_date | Unknown |  |
| end_on | Unknown |  |
| estimated_quantity | Unknown |  |
| estimated_usage | Unknown |  |
| is_last_version | Unknown |  |
| modified | Unknown |  |
| number | Unknown |  |
| one_time_feesamount | Unknown |  |
| one_time_feesbase_currency_amount | Unknown |  |
| one_time_feesbase_currency_code | Unknown |  |
| one_time_feescurrency_code | Unknown |  |
| one_time_feescurrency_conversion_date | Unknown |  |
| quantity | Unknown |  |
| recognized_revenue_account | Unknown |  |
| recurring_monthly_amount | Unknown |  |
| recurring_monthly_amount_base | Unknown |  |
| revenue_recognition_rule | Unknown |  |
| start_on | Unknown |  |
| tcv_amount | Unknown |  |
| tcv_base_currency_amount | Unknown |  |
| tcv_base_currency_code | Unknown |  |
| tcv_currency_code | Unknown |  |
| tcv_currency_conversion_date | Unknown |  |
| version | Unknown |  |
| custom_fields_** |  |  |

### subscription_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| charge_plan_id | Unknown | FK |
| created | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| product_line_number | Unknown |  |
| product_number | Unknown |  |
| custom_fields_** |  |  |

### subscription_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| description | Unknown |  |
| milestone_date | Unknown |  |
| name | Unknown |  |
| order_id | Unknown |  |
| planned_date | Unknown |  |

### subscription_order_discount_product_charge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_order_discount_id | Unknown | PK, FK |
| subscription_order_discount_subscription_id | Unknown | PK, FK |
| charge_id | Unknown |  |
| order_discount_id | Unknown |  |

### subscription_order_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| discount_type | Unknown |  |
| end_date | Unknown |  |
| end_on | Unknown |  |
| order_id | Unknown |  |
| percents | Unknown |  |
| start_date | Unknown |  |
| start_on | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| account_external_crm_id | Unknown |  |
| account_external_erp_id | Unknown |  |
| account_name | Unknown |  |
| account_number | Unknown |  |
| buyer_reference | Unknown |  |
| cancellation_date | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| currency_code_to_use_when_invoice | Unknown |  |
| description | Unknown |  |
| effective_change_date | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| invoice_accountexternal_crm_id | Unknown |  |
| invoice_accountexternal_erp_id | Unknown |  |
| invoice_accountid | Unknown |  |
| invoice_accountname | Unknown |  |
| invoice_accountnumber | Unknown |  |
| invoice_addresscity | Unknown |  |
| invoice_addresscountry | Unknown |  |
| invoice_addresscounty | Unknown |  |
| invoice_addressdescription | Unknown |  |
| invoice_addressid | Unknown |  |
| invoice_addressstate | Unknown |  |
| invoice_addressstreet | Unknown |  |
| invoice_addressstreet_2 | Unknown |  |
| invoice_addresszip | Unknown |  |
| invoice_batch_groupcode | Unknown |  |
| invoice_batch_groupdescription | Unknown |  |
| invoice_batch_groupid | Unknown |  |
| invoice_separatly | Unknown |  |
| is_auto_renewed | Unknown |  |
| is_last_version | Unknown |  |
| last_renewal_date | Unknown |  |
| modified | Unknown |  |
| notice_period | Unknown |  |
| notice_period_date | Unknown |  |
| order_billing_period | Unknown |  |
| order_date | Unknown |  |
| order_number | Unknown |  |
| order_payment_method | Unknown |  |
| order_type | Unknown |  |
| our_reference | Unknown |  |
| payment_term | Unknown |  |
| remarks | Unknown |  |
| renewal_term | Unknown |  |
| set_order_billing_period | Unknown |  |
| status | Unknown |  |
| term | Unknown |  |
| term_type | Unknown |  |
| use_account_invoice_batch_group | Unknown |  |
| version | Unknown |  |
| your_order_number | Unknown |  |
| your_reference | Unknown |  |
| custom_fields_** |  |  |

### chart_of_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| description | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| name | Unknown |  |

### salesorder_product_charge_price_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| salesorder_id | Unknown | PK, FK |
| salesorder_product_charge_id | Unknown | PK, FK |
| salesorder_product_id | Unknown | PK, FK |
| description | Unknown |  |
| from_quantity | Unknown |  |
| line_discount_amount | Unknown |  |
| line_discount_percent | Unknown |  |
| list_price | Unknown |  |
| price | Unknown |  |
| tier | Unknown |  |
| to_quantity | Unknown |  |

### salesorder_product_charge_feature

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| salesorder_id | Unknown | PK, FK |
| salesorder_product_charge_id | Unknown | PK, FK |
| salesorder_product_id | Unknown | PK, FK |
| code | Unknown |  |
| description | Unknown |  |

### salesorder_product_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| salesorder_id | Unknown | PK, FK |
| salesorder_product_id | Unknown | PK, FK |
| accounts_receivable_account | Unknown |  |
| acv_amount | Unknown |  |
| acv_base_currency_amount | Unknown |  |
| acv_base_currency_code | Unknown |  |
| acv_currency_code | Unknown |  |
| acv_currency_conversion_date | Unknown |  |
| alignment_date | Unknown |  |
| billing_day | Unknown |  |
| billing_period | Unknown |  |
| billing_timing | Unknown |  |
| change_state | Unknown |  |
| charge_id | Unknown |  |
| charge_number | Unknown |  |
| charge_type | Unknown |  |
| charged_through_date | Unknown |  |
| cmrr_amount | Unknown |  |
| cmrr_base_currency_amount | Unknown |  |
| cmrr_base_currency_code | Unknown |  |
| cmrr_currency_code | Unknown |  |
| cmrr_currency_conversion_date | Unknown |  |
| create_invoice_lines_per_tier | Unknown |  |
| created | Unknown |  |
| deferred_revenue_account | Unknown |  |
| display_price | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| emrr_amount | Unknown |  |
| emrr_base_currency_amount | Unknown |  |
| emrr_base_currency_code | Unknown |  |
| emrr_currency_code | Unknown |  |
| emrr_currency_conversion_date | Unknown |  |
| end_on | Unknown |  |
| estimated_quantity | Unknown |  |
| estimated_usage | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| is_last_version | Unknown |  |
| last_price_adjustment_date | Unknown |  |
| last_renewal_date | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| one_time_feesamount | Unknown |  |
| one_time_feesbase_currency_amount | Unknown |  |
| one_time_feesbase_currency_code | Unknown |  |
| one_time_feescurrency_code | Unknown |  |
| one_time_feescurrency_conversion_date | Unknown |  |
| order_id | Unknown |  |
| order_product_id | Unknown |  |
| ordered_quantity | Unknown |  |
| period_alignment | Unknown |  |
| price_model | Unknown |  |
| price_period | Unknown |  |
| quantity | Unknown |  |
| recognized_revenue_account | Unknown |  |
| recurring_monthly_amount | Unknown |  |
| recurring_monthly_amount_base | Unknown |  |
| remaining_quantity | Unknown |  |
| remarks | Unknown |  |
| revenue_recognition_rule | Unknown |  |
| specific_billing_day | Unknown |  |
| start_on | Unknown |  |
| tax_included | Unknown |  |
| tax_template | Unknown |  |
| tcv_amount | Unknown |  |
| tcv_base_currency_amount | Unknown |  |
| tcv_base_currency_code | Unknown |  |
| tcv_currency_code | Unknown |  |
| tcv_currency_conversion_date | Unknown |  |
| unit_code | Unknown |  |
| usage_rating | Unknown |  |
| version | Unknown |  |

### salesorder_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| salesorder_id | Unknown | PK, FK |
| charge_plan_id | Unknown | FK |
| created | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| product_line_number | Unknown |  |
| product_number | Unknown |  |
| custom_fields_** |  |  |

### salesorder_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| salesorder_id | Unknown | PK, FK |
| description | Unknown |  |
| milestone_date | Unknown |  |
| name | Unknown |  |
| order_id | Unknown |  |
| planned_date | Unknown |  |

### salesorder_order_discount_product_charge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| salesorder_order_discount_id | Unknown | PK, FK |
| salesorder_order_discount_salesorder_id | Unknown | PK, FK |
| charge_id | Unknown |  |
| order_discount_id | Unknown |  |

### salesorder_order_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| salesorder_id | Unknown | PK, FK |
| discount_type | Unknown |  |
| end_date | Unknown |  |
| end_on | Unknown |  |
| order_id | Unknown |  |
| percents | Unknown |  |
| start_date | Unknown |  |
| start_on | Unknown |  |

### salesorder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| invoice_account_id | Unknown | FK |
| account_receivable_account | Unknown |  |
| buyer_reference | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| delivery_addresscity | Unknown |  |
| delivery_addresscountry | Unknown |  |
| delivery_addresscounty | Unknown |  |
| delivery_addressdescription | Unknown |  |
| delivery_addressid | Unknown |  |
| delivery_addressname | Unknown |  |
| delivery_addressstate | Unknown |  |
| delivery_addressstreet | Unknown |  |
| delivery_addressstreet_2 | Unknown |  |
| delivery_addresszip | Unknown |  |
| description | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| invoice_accountid | Unknown |  |
| invoice_addresscity | Unknown |  |
| invoice_addresscountry | Unknown |  |
| invoice_addresscounty | Unknown |  |
| invoice_addressdescription | Unknown |  |
| invoice_addressid | Unknown |  |
| invoice_addressname | Unknown |  |
| invoice_addressstate | Unknown |  |
| invoice_addressstreet | Unknown |  |
| invoice_addressstreet_2 | Unknown |  |
| invoice_addresszip | Unknown |  |
| invoice_batch_group | Unknown |  |
| invoice_separatly | Unknown |  |
| invoicing_currency | Unknown |  |
| is_last_version | Unknown |  |
| modified | Unknown |  |
| number | Unknown |  |
| order_date | Unknown |  |
| order_type | Unknown |  |
| our_reference | Unknown |  |
| payment_term | Unknown |  |
| remark | Unknown |  |
| use_account_invoice_batch_group | Unknown |  |
| version | Unknown |  |
| your_order_number | Unknown |  |
| your_reference | Unknown |  |

### measurement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| order_id | Unknown | FK |
| product_id | Unknown | FK |
| charge_charge_number | Unknown |  |
| charge_description | Unknown |  |
| charge_external_crm_id | Unknown |  |
| charge_external_erp_id | Unknown |  |
| charge_id | Unknown |  |
| charge_name | Unknown |  |
| created | Unknown |  |
| from_date | Unknown |  |
| import_date | Unknown |  |
| modified | Unknown |  |
| quantity | Unknown |  |
| tags | Unknown |  |

### quote_product_charge_price_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| quote_product_charge_id | Unknown | PK, FK |
| quote_product_id | Unknown | PK, FK |
| description | Unknown |  |
| from_quantity | Unknown |  |
| line_discount_amount | Unknown |  |
| line_discount_percent | Unknown |  |
| list_price | Unknown |  |
| price | Unknown |  |
| price_base | Unknown |  |
| tier | Unknown |  |
| to_quantity | Unknown |  |

### quote_product_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| quote_product_id | Unknown | PK, FK |
| acv_amount | Unknown |  |
| acv_base_currency_amount | Unknown |  |
| acv_base_currency_code | Unknown |  |
| acv_currency_code | Unknown |  |
| acv_currency_conversion_date | Unknown |  |
| billing_period | Unknown |  |
| charge_number | Unknown |  |
| charge_type | Unknown |  |
| cmrr_amount | Unknown |  |
| cmrr_base_currency_amount | Unknown |  |
| cmrr_base_currency_code | Unknown |  |
| cmrr_currency_code | Unknown |  |
| cmrr_currency_conversion_date | Unknown |  |
| created | Unknown |  |
| display_price | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| end_on | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| ppu | Unknown |  |
| price_model | Unknown |  |
| price_period | Unknown |  |
| quantity | Unknown |  |
| remarks | Unknown |  |
| start_on | Unknown |  |
| tcv_amount | Unknown |  |
| tcv_base_currency_amount | Unknown |  |
| tcv_base_currency_code | Unknown |  |
| tcv_currency_code | Unknown |  |
| tcv_currency_conversion_date | Unknown |  |
| unit_code | Unknown |  |
| usage_rating | Unknown |  |
| custom_fields_** |  |  |

### quote_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| charge_plan_id | Unknown | FK |
| created | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| product_line_number | Unknown |  |
| custom_fields_** |  |  |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| invoice_customer_id | Unknown | FK |
| auto_renewal | Unknown |  |
| converted_to_orderexternal_crm_id | Unknown |  |
| converted_to_orderexternal_erp_id | Unknown |  |
| converted_to_orderid | Unknown |  |
| converted_to_ordernumber | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| delivery_addresscity | Unknown |  |
| delivery_addresscountry | Unknown |  |
| delivery_addresscounty | Unknown |  |
| delivery_addressdescription | Unknown |  |
| delivery_addressid | Unknown |  |
| delivery_addressname | Unknown |  |
| delivery_addressstate | Unknown |  |
| delivery_addressstreet | Unknown |  |
| delivery_addressstreet_2 | Unknown |  |
| delivery_addresszip | Unknown |  |
| description | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| initial_term | Unknown |  |
| invoice_customerid | Unknown |  |
| modified | Unknown |  |
| notice_period | Unknown |  |
| number | Unknown |  |
| order_type | Unknown |  |
| our_reference | Unknown |  |
| quote_date | Unknown |  |
| remarks | Unknown |  |
| renewal_term | Unknown |  |
| status | Unknown |  |
| term_type | Unknown |  |
| valid_to_date | Unknown |  |
| version | Unknown |  |
| your_reference | Unknown |  |
| custom_fields_** |  |  |

### journal_voucher_transaction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| journal_voucher_index | Unknown | PK, FK |
| journal_voucher_journal_id | Unknown | PK, FK |
| account | Unknown |  |
| credit_amount | Unknown |  |
| custom_fields | Json |  |
| debit_amount | Unknown |  |
| description | Unknown |  |

### journal_voucher

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| journal_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| payment_id | Unknown | FK |
| created | Unknown |  |
| effective_date | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| modified | Unknown |  |
| order_charge_id | Unknown |  |
| order_charge_number | Unknown |  |
| payment_settlement_id | Unknown |  |
| revenue_schedule_item_id | Unknown |  |
| source | Unknown |  |
| transaction_number | Unknown |  |

### journal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounting_periodcalendar_month | Unknown |  |
| accounting_periodcalendar_year | Unknown |  |
| accounting_periodclosed_date | Unknown |  |
| accounting_perioddescription | Unknown |  |
| accounting_periodend_date | Unknown |  |
| accounting_periodfiscal_period | Unknown |  |
| accounting_periodfiscal_quarter | Unknown |  |
| accounting_periodfiscal_year | Unknown |  |
| accounting_periodstart_date | Unknown |  |
| accounting_periodstatus | Unknown |  |
| created | Unknown |  |
| description | Unknown |  |
| external_erp_id | Unknown |  |
| modified | Unknown |  |
| number | Unknown |  |
| posted | Unknown |  |
| posted_date | Unknown |  |
| transferred_to_erp | Unknown |  |
| type | Unknown |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| description | Unknown |  |

### payment_settlement_write_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_settlement_index | Unknown | PK, FK |
| payment_settlement_payment_id | Unknown | PK, FK |
| amount_amount | Unknown |  |
| amount_base_currency_amount | Unknown |  |
| amount_base_currency_code | Unknown |  |
| amount_currency_code | Unknown |  |
| amount_currency_conversion_date | Unknown |  |
| description | Unknown |  |
| financial_account_id | Unknown |  |
| financial_accountcode | Unknown |  |
| financial_accountdescription | Unknown |  |
| financial_accountexternal_crm_id | Unknown |  |
| financial_accountexternal_erp_id | Unknown |  |
| financial_accountid | Unknown |  |
| financial_accountname | Unknown |  |

### payment_settlement

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payment_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| amount_amount | Unknown |  |
| amount_base_currency_amount | Unknown |  |
| amount_base_currency_code | Unknown |  |
| amount_currency_code | Unknown |  |
| amount_currency_conversion_date | Unknown |  |

### payment_write_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_id | Unknown | PK, FK |
| amount_amount | Unknown |  |
| amount_base_currency_amount | Unknown |  |
| amount_currency_code | Unknown |  |
| amount_currency_conversion_date | Unknown |  |
| financial_accountcode | Unknown |  |
| financial_accountdescription | Unknown |  |
| financial_accountexternal_crm_id | Unknown |  |
| financial_accountexternal_erp_id | Unknown |  |
| financial_accountid | Unknown |  |
| financial_accountname | Unknown |  |
| posting_text | Unknown |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount_amount | Unknown |  |
| amount_base_currency_amount | Unknown |  |
| amount_base_currency_code | Unknown |  |
| amount_currency_code | Unknown |  |
| amount_currency_conversion_date | Unknown |  |
| bank_fee_accountcode | Unknown |  |
| bank_fee_accountdescription | Unknown |  |
| bank_fee_accountexternal_crm_id | Unknown |  |
| bank_fee_accountexternal_erp_id | Unknown |  |
| bank_fee_accountid | Unknown |  |
| bank_fee_accountname | Unknown |  |
| bank_fee_amountamount | Unknown |  |
| bank_fee_amountbase_currency_amount | Unknown |  |
| bank_fee_amountbase_currency_code | Unknown |  |
| bank_fee_amountcurrency_code | Unknown |  |
| bank_fee_amountcurrency_conversion_date | Unknown |  |
| description | Unknown |  |
| exchange_rate | Unknown |  |
| external_bank_id | Unknown |  |
| payer_information | Unknown |  |
| payer_name | Unknown |  |
| payment_accountcode | Unknown |  |
| payment_accountdescription | Unknown |  |
| payment_accountexternal_crm_id | Unknown |  |
| payment_accountexternal_erp_id | Unknown |  |
| payment_accountid | Unknown |  |
| payment_accountname | Unknown |  |
| payment_batch_id | Unknown |  |
| payment_batch_number | Unknown |  |
| payment_date | Unknown |  |
| payment_method_id | Unknown |  |
| payment_method_name | Unknown |  |
| reference | Unknown |  |

### product_charge_plan_price_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| charge_plan_detail_id | Unknown | PK, FK |
| charge_plan_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| currency | Unknown |  |
| description | Unknown |  |
| from_quantity | Unknown |  |
| price | Unknown |  |
| price_base | Unknown |  |
| tier | Unknown |  |
| to_quantity | Unknown |  |

### product_charge_plan_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| charge_plan_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| billing_day | Unknown |  |
| billing_period | Unknown |  |
| billing_timing | Unknown |  |
| charge_number | Unknown |  |
| charge_type | Unknown |  |
| create_invoice_lines_per_tier | Unknown |  |
| created | Unknown |  |
| default_quantity | Unknown |  |
| deferred_revenue_account | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| model | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| period_alignment | Unknown |  |
| price_period | Unknown |  |
| recognized_revenue_account | Unknown |  |
| specific_billing_day | Unknown |  |
| tax_included | Unknown |  |
| tax_template | Unknown |  |
| unit_code | Unknown |  |
| usage_rating | Unknown |  |
| custom_fields_** |  |  |

### product_charge_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| created | Unknown |  |
| effective_end_date | Unknown |  |
| effective_start_date | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| custom_fields_** |  |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activation_date | Unknown |  |
| category | Unknown |  |
| created | Unknown |  |
| end_of_life_date | Unknown |  |
| end_of_new_sales_date | Unknown |  |
| end_of_renewal_date | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| is_framework_product | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |
| custom_fields_** |  |  |

### payment_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| days | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| term_type | Unknown |  |

### exchange_rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| effective_from_date | Unknown |  |
| effective_to_date | Unknown |  |
| from_currency | Unknown |  |
| rate | Unknown |  |
| to_currency | Unknown |  |

### invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| order_id | Unknown | FK |
| order_product_id | Unknown | FK |
| charge_description | Unknown |  |
| charge_number | Unknown |  |
| charge_plan_id | Unknown |  |
| created | Unknown |  |
| deferred_revenuecode | Unknown |  |
| deferred_revenuedescription | Unknown |  |
| deferred_revenueexternal_crm_id | Unknown |  |
| deferred_revenueexternal_erp_id | Unknown |  |
| deferred_revenueid | Unknown |  |
| deferred_revenuename | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| modified | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| order_charge_id | Unknown |  |
| price | Unknown |  |
| product_name | Unknown |  |
| product_number | Unknown |  |
| quantity | Unknown |  |
| recognized_revenuecode | Unknown |  |
| recognized_revenuedescription | Unknown |  |
| recognized_revenueexternal_crm_id | Unknown |  |
| recognized_revenueexternal_erp_id | Unknown |  |
| recognized_revenueid | Unknown |  |
| recognized_revenuename | Unknown |  |
| service_period_end_date | Unknown |  |
| service_period_start_date | Unknown |  |
| subtotal | Unknown |  |
| subtotal_pre_discount | Unknown |  |
| tax | Unknown |  |
| tax_category_name | Unknown |  |
| tax_pre_discount | Unknown |  |
| tax_rate | Unknown |  |
| total | Unknown |  |
| total_pre_discount | Unknown |  |
| unit_of_measuredisplay_name | Unknown |  |
| unit_of_measureid | Unknown |  |
| unit_of_measurename | Unknown |  |
| unit_of_measureunit_code | Unknown |  |
| custom_fields_** |  |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| payment_term_id | Unknown | FK |
| accounts_receivablecode | Unknown |  |
| accounts_receivabledescription | Unknown |  |
| accounts_receivableexternal_crm_id | Unknown |  |
| accounts_receivableexternal_erp_id | Unknown |  |
| accounts_receivableid | Unknown |  |
| accounts_receivablename | Unknown |  |
| balanced_amount | Unknown |  |
| buyer_reference | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| days_past_due | Unknown |  |
| delivery_addresscity | Unknown |  |
| delivery_addresscountry | Unknown |  |
| delivery_addresscounty | Unknown |  |
| delivery_addressdescription | Unknown |  |
| delivery_addressid | Unknown |  |
| delivery_addressname | Unknown |  |
| delivery_addressstate | Unknown |  |
| delivery_addressstreet | Unknown |  |
| delivery_addressstreet_2 | Unknown |  |
| delivery_addresszip | Unknown |  |
| disable_automatic_invoice_reminder | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| invoice_addresscity | Unknown |  |
| invoice_addresscountry | Unknown |  |
| invoice_addresscounty | Unknown |  |
| invoice_addressdescription | Unknown |  |
| invoice_addressid | Unknown |  |
| invoice_addressname | Unknown |  |
| invoice_addressstate | Unknown |  |
| invoice_addressstreet | Unknown |  |
| invoice_addressstreet_2 | Unknown |  |
| invoice_addresszip | Unknown |  |
| invoice_batch_id | Unknown |  |
| invoice_delivery_method | Unknown |  |
| invoice_template_id | Unknown |  |
| invoice_type | Unknown |  |
| modified | Unknown |  |
| notes | Unknown |  |
| nr_of_reminders | Unknown |  |
| number | Unknown |  |
| ocr_number | Unknown |  |
| online_payment_link | Unknown |  |
| our_reference | Unknown |  |
| payment_termid | Unknown |  |
| send_method | Unknown |  |
| settled_amount | Unknown |  |
| settled_notes | Unknown |  |
| status | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| tax_included | Unknown |  |
| total_amount | Unknown |  |
| total_rounding_amount | Unknown |  |
| your_order_number | Unknown |  |
| your_reference | Unknown |  |
| custom_fields_** |  |  |

### tax_template_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_id | Unknown | FK |
| tax_template_id | Unknown | FK |
| country_active | Unknown |  |
| country_custom_fields | Json |  |
| country_name | Unknown |  |
| country_three_alpha_code | Unknown |  |
| country_two_alpha_code | Unknown |  |
| tax_1 | Unknown |  |
| tax_2 | Unknown |  |
| tax_3 | Unknown |  |
| tax_categorydescription | Unknown |  |
| tax_categoryid | Unknown |  |
| tax_categoryis_active | Unknown |  |
| tax_categoryis_eu_tax | Unknown |  |
| tax_categoryname | Unknown |  |
| use_tax_jar | Unknown |  |

### tax_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| description | Unknown |  |
| effective_from | Unknown |  |
| effective_to | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| tax_accountcode | Unknown |  |
| tax_accountdescription | Unknown |  |
| tax_accountexternal_crm_id | Unknown |  |
| tax_accountexternal_erp_id | Unknown |  |
| tax_accountid | Unknown |  |
| tax_accountname | Unknown |  |

### account_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| county | Unknown |  |
| description | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| street_2 | Unknown |  |
| zip | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| accounts_receivable | Unknown |  |
| acv_amount | Unknown |  |
| acv_base_currency_amount | Unknown |  |
| acv_base_currency_code | Unknown |  |
| acv_currency_code | Unknown |  |
| acv_currency_conversion_date | Unknown |  |
| cmrr_amount | Unknown |  |
| cmrr_base_currency_amount | Unknown |  |
| cmrr_base_currency_code | Unknown |  |
| cmrr_currency_code | Unknown |  |
| cmrr_currency_conversion_date | Unknown |  |
| created | Unknown |  |
| currency_code | Unknown |  |
| default_payment_term | Unknown |  |
| domain | Unknown |  |
| electronic_invoice_address | Unknown |  |
| electronic_invoice_address_scheme | Unknown |  |
| emrr_amount | Unknown |  |
| emrr_base_currency_amount | Unknown |  |
| emrr_base_currency_code | Unknown |  |
| emrr_currency_code | Unknown |  |
| emrr_currency_conversion_date | Unknown |  |
| external_crm_id | Unknown |  |
| external_erp_id | Unknown |  |
| image_url | Unknown |  |
| inactive | Unknown |  |
| invoice_batch_group_id | Unknown |  |
| invoice_delivery_method | Unknown |  |
| invoice_email_address | Unknown |  |
| invoice_email_cc_addresses | Unknown |  |
| invoice_setting_group_id | Unknown |  |
| invoice_template_id | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| one_time_feesamount | Unknown |  |
| one_time_feesbase_currency_amount | Unknown |  |
| one_time_feesbase_currency_code | Unknown |  |
| one_time_feescurrency_code | Unknown |  |
| one_time_feescurrency_conversion_date | Unknown |  |
| online_payment_detailscreated | Unknown |  |
| online_payment_detailsmodified | Unknown |  |
| online_payment_detailsstripe_customer_id | Unknown |  |
| online_payment_detailsstripe_payment_method_id | Unknown |  |
| organization_number | Unknown |  |
| our_reference | Unknown |  |
| parent_account_id | Unknown |  |
| reminder_email_address | Unknown |  |
| tax_registration_number | Unknown |  |
| tax_template | Unknown |  |
| tcv_amount | Unknown |  |
| tcv_base_currency_amount | Unknown |  |
| tcv_base_currency_code | Unknown |  |
| tcv_currency_code | Unknown |  |
| tcv_currency_conversion_date | Unknown |  |
| your_reference | Unknown |  |
| custom_fields_** |  |  |

## Relationships

- booking_line(booking_id) → booking(id)
- booking(order_id) → subscription(id)
- usage(product_id) → product(id)
- usage(order_id) → salesorder(id)
- usage(account_id) → account(id)
- subscription_product_charge_price_detail(subscription_product_charge_id) → subscription_product_charge(id)
- subscription_product_charge_price_detail(subscription_product_id) → subscription_product_charge(subscription_product_id)
- subscription_product_charge_price_detail(subscription_id) → subscription_product_charge(subscription_id)
- subscription_product_charge_feature(subscription_product_charge_id) → subscription_product_charge(id)
- subscription_product_charge_feature(subscription_product_id) → subscription_product_charge(subscription_product_id)
- subscription_product_charge_feature(subscription_id) → subscription_product_charge(subscription_id)
- subscription_product_charge(order_id) → subscription(id)
- subscription_product_charge(order_product_id) → subscription_product(id)
- subscription_product_charge(charge_id) → product_charge_plan_detail(id)
- subscription_product_charge(subscription_id) → subscription_product(subscription_id)
- subscription_product_charge(subscription_product_id) → subscription_product(id)
- subscription_product(charge_plan_id) → product_charge_plan(id)
- subscription_product(subscription_id) → subscription(id)
- subscription_milestone(subscription_id) → subscription(id)
- subscription_order_discount_product_charge(subscription_order_discount_id) → subscription_order_discount(id)
- subscription_order_discount_product_charge(subscription_order_discount_subscription_id) → subscription_order_discount(subscription_id)
- subscription_order_discount(subscription_id) → subscription(id)
- subscription(account_id) → account(id)
- salesorder_product_charge_price_detail(salesorder_product_charge_id) → salesorder_product_charge(id)
- salesorder_product_charge_price_detail(salesorder_product_id) → salesorder_product_charge(salesorder_product_id)
- salesorder_product_charge_price_detail(salesorder_id) → salesorder_product_charge(salesorder_id)
- salesorder_product_charge_feature(salesorder_product_charge_id) → salesorder_product_charge(id)
- salesorder_product_charge_feature(salesorder_product_id) → salesorder_product_charge(salesorder_product_id)
- salesorder_product_charge_feature(salesorder_id) → salesorder_product_charge(salesorder_id)
- salesorder_product_charge(salesorder_product_id) → salesorder_product(id)
- salesorder_product_charge(salesorder_id) → salesorder_product(salesorder_id)
- salesorder_product(charge_plan_id) → product_charge_plan(id)
- salesorder_product(salesorder_id) → salesorder(id)
- salesorder_milestone(salesorder_id) → salesorder(id)
- salesorder_order_discount_product_charge(salesorder_order_discount_id) → salesorder_order_discount(id)
- salesorder_order_discount_product_charge(salesorder_order_discount_salesorder_id) → salesorder_order_discount(salesorder_id)
- salesorder_order_discount(salesorder_id) → salesorder(id)
- salesorder(account_id) → account(id)
- salesorder(invoice_account_id) → account(id)
- measurement(account_id) → account(id)
- measurement(order_id) → salesorder(id)
- measurement(product_id) → subscription_product(id)
- quote_product_charge_price_detail(quote_product_charge_id) → quote_product_charge(id)
- quote_product_charge_price_detail(quote_id) → quote_product_charge(quote_id)
- quote_product_charge_price_detail(quote_product_id) → quote_product_charge(quote_product_id)
- quote_product_charge(quote_id) → quote_product(quote_id)
- quote_product_charge(quote_product_id) → quote_product(id)
- quote_product(charge_plan_id) → product_charge_plan(id)
- quote_product(quote_id) → quote(id)
- quote(customer_id) → account(id)
- quote(invoice_customer_id) → account(id)
- journal_voucher_transaction(journal_voucher_journal_id) → journal_voucher(journal_id)
- journal_voucher_transaction(journal_voucher_index) → journal_voucher(index)
- journal_voucher(payment_id) → payment(id)
- journal_voucher(invoice_id) → invoice(id)
- journal_voucher(journal_id) → journal(id)
- payment_settlement_write_off(payment_settlement_payment_id) → payment_settlement(payment_id)
- payment_settlement_write_off(payment_settlement_index) → payment_settlement(index)
- payment_settlement(invoice_id) → invoice(id)
- payment_settlement(payment_id) → payment(id)
- payment_write_off(payment_id) → payment(id)
- product_charge_plan_price_detail(charge_plan_detail_id) → product_charge_plan_detail(id)
- product_charge_plan_price_detail(product_id) → product_charge_plan_detail(product_id)
- product_charge_plan_price_detail(charge_plan_id) → product_charge_plan_detail(charge_plan_id)
- product_charge_plan_detail(product_id) → product_charge_plan(product_id)
- product_charge_plan_detail(charge_plan_id) → product_charge_plan(id)
- product_charge_plan(product_id) → product(id)
- invoice_line(order_id) → salesorder(id)
- invoice_line(order_product_id) → salesorder_product(id)
- invoice_line(account_id) → account(id)
- invoice_line(invoice_id) → invoice(id)
- invoice(account_id) → account(id)
- invoice(payment_term_id) → payment_term(id)
- tax_template_detail(tax_template_id) → tax_template(id)
- tax_template_detail(country_id) → country(id)
- account_address(account_id) → account(id)