Younium

Explore the interactive ERD

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	PKFK
`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	PKFK
`subscription_product_charge_id`	Unknown	PKFK
`subscription_product_id`	Unknown	PKFK
`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	PKFK
`subscription_product_charge_id`	Unknown	PKFK
`subscription_product_id`	Unknown	PKFK
`code`	Unknown
`description`	Unknown

subscription_product_charge

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PKFK
`subscription_product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`subscription_order_discount_subscription_id`	Unknown	PKFK
`charge_id`	Unknown
`order_discount_id`	Unknown

subscription_order_discount

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PKFK
`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	PKFK
`salesorder_product_charge_id`	Unknown	PKFK
`salesorder_product_id`	Unknown	PKFK
`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	PKFK
`salesorder_product_charge_id`	Unknown	PKFK
`salesorder_product_id`	Unknown	PKFK
`code`	Unknown
`description`	Unknown

salesorder_product_charge

Column	Type	Keys
`id`	Unknown	PK
`salesorder_id`	Unknown	PKFK
`salesorder_product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`salesorder_order_discount_salesorder_id`	Unknown	PKFK
`charge_id`	Unknown
`order_discount_id`	Unknown

salesorder_order_discount

Column	Type	Keys
`id`	Unknown	PK
`salesorder_id`	Unknown	PKFK
`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	PKFK
`quote_product_charge_id`	Unknown	PKFK
`quote_product_id`	Unknown	PKFK
`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	PKFK
`quote_product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`journal_voucher_journal_id`	Unknown	PKFK
`account`	Unknown
`credit_amount`	Unknown
`custom_fields`	Json
`debit_amount`	Unknown
`description`	Unknown

journal_voucher

Column	Type	Keys
`index`	Unknown	PK
`journal_id`	Unknown	PKFK
`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	PKFK
`payment_settlement_payment_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`charge_plan_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`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	PKFK
`product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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_`