Exact Online

Explore the interactive ERD

Table & Field Reference

gl_account_classification_mapping

Column	Type	Keys
`id`	Unknown	PK
`classification`	Unknown	FK
`division_id`	Unknown	FK
`classification_code`	Unknown
`classification_description`	Unknown
`gl_account`	Unknown
`gl_account_code`	Unknown
`gl_account_description`	Unknown
`gl_scheme_code`	Unknown
`gl_scheme_description`	Unknown
`gl_scheme_id`	Unknown
`metadata_`

subscription

Column	Type	Keys
`id`	Unknown	PK
`division`	Unknown	FK
`block_entry`	Unknown
`cancellation_date`	Unknown
`classification`	Unknown
`classification_code`	Unknown
`classification_description`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`currency`	Unknown
`customer_po_number`	Unknown
`description`	Unknown
`end_date`	Unknown
`invoice_day`	Unknown
`invoice_to`	Unknown
`invoice_to_contact_person`	Unknown
`invoice_to_contact_person_full_name`	Unknown
`invoice_to_name`	Unknown
`invoiced_to`	Unknown
`invoicing_start_date`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`note`	Unknown
`number`	Unknown
`ordered_by`	Unknown
`ordered_by_contact_person`	Unknown
`ordered_by_contact_person_full_name`	Unknown
`ordered_by_name`	Unknown
`payment_condition`	Unknown
`payment_condition_description`	Unknown
`printed`	Unknown
`project`	Unknown
`reason_cancelled`	Unknown
`reason_cancelled_code`	Unknown
`reason_cancelled_description`	Unknown
`start_date`	Unknown
`subscription_type`	Unknown
`subscription_type_code`	Unknown
`subscription_type_description`	Unknown
`timestamps`	Unknown
`metadata_`

sales_invoice_line

Column	Type	Keys
`id`	Unknown	PK
`amount_dc`	Unknown
`amount_fc`	Unknown
`cost_center`	Unknown
`cost_center_description`	Unknown
`cost_unit`	Unknown
`cost_unit_description`	Unknown
`custom_field`	Unknown
`customer_item_code`	Unknown
`delivery_date`	Unknown
`description`	Unknown
`discount`	Unknown
`division`	Unknown
`employee`	Unknown
`employee_full_name`	Unknown
`end_time`	Unknown
`extra_duty_amount_fc`	Unknown
`extra_duty_percentage`	Unknown
`gl_account`	Unknown
`gl_account_description`	Unknown
`invoice_id`	Unknown
`item`	Unknown
`item_code`	Unknown
`item_description`	Unknown
`line_number`	Unknown
`net_price`	Unknown
`notes`	Unknown
`pricelist`	Unknown
`pricelist_description`	Unknown
`project`	Unknown
`project_description`	Unknown
`project_wbs`	Unknown
`project_wbs_description`	Unknown
`quantity`	Unknown
`sales_order`	Unknown
`sales_order_line`	Unknown
`sales_order_line_number`	Unknown
`sales_order_number`	Unknown
`start_time`	Unknown
`subscription`	Unknown
`subscription_description`	Unknown
`system_division_id`	Unknown
`tax_schedule`	Unknown
`tax_schedule_code`	Unknown
`tax_schedule_description`	Unknown
`unit_code`	Unknown
`unit_description`	Unknown
`unit_price`	Unknown
`vat_amount_dc`	Unknown
`vat_amount_fc`	Unknown
`vat_code`	Unknown
`vat_code_description`	Unknown
`vat_percentage`	Unknown
`metadata_`

receivables_list

Column	Type	Keys
`hid`	Unknown	PK
`account_id`	Unknown	FK
`account_code`	Unknown
`account_name`	Unknown
`amount`	Unknown
`amount_in_transit`	Unknown
`currency_code`	Unknown
`description`	Unknown
`due_date`	Unknown
`entry_number`	Unknown
`id`	Unknown
`invoice_date`	Unknown
`invoice_number`	Unknown
`journal_code`	Unknown
`journal_description`	Unknown
`system_division_id`	Unknown
`your_ref`	Unknown

division

Column	Type	Keys
`id`	Unknown	PK
`accounting_division`	Unknown
`customer_code`	Unknown
`division_customer`	Unknown
`division_customer_code`	Unknown
`division_customer_name`	Unknown
`division_customer_siret_number`	Unknown
`division_customer_vat_number`	Unknown
`dossier_division`	Unknown
`email`	Unknown
`employee_id`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`gender`	Unknown
`initials`	Unknown
`is_client_user`	Unknown
`is_employee_self_service_user`	Unknown
`is_my_firm_lite_user`	Unknown
`is_my_firm_portal_user`	Unknown
`is_starter_user`	Unknown
`language_code`	Unknown
`languages`	Unknown
`last_name`	Unknown
`legislation`	Unknown
`middle_name`	Unknown
`mobile`	Unknown
`nationality`	Unknown
`phone`	Unknown
`phone_extension`	Unknown
`picture_url`	Unknown
`server_time`	Unknown
`server_utc_offset`	Unknown
`thumbnail_picture`	Unknown
`thumbnail_picture_format`	Unknown
`title`	Unknown
`user_id`	Unknown
`user_name`	Unknown
`metadata_`

revenue_list

Column	Type	Keys
`period`	Unknown	PK
`year`	Unknown	PK
`amount`	Unknown
`system_division_id`	Unknown
`metadata_`

bank

Column	Type	Keys
`id`	Unknown	PK
`bank_name`	Unknown
`bic_code`	Unknown
`country`	Unknown
`created`	Unknown
`description`	Unknown
`format`	Unknown
`home_page_address`	Unknown
`modified`	Unknown
`status`	Unknown
`system_division_id`	Unknown
`metadata_`

contact

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`division_id`	Unknown	FK
`account_is_customer`	Unknown
`account_is_supplier`	Unknown
`account_main_contact`	Unknown
`account_name`	Unknown
`address_line_2`	Unknown
`address_street`	Unknown
`address_street_number_suffix`	Unknown
`allow_mailing`	Unknown
`birth_date`	Unknown
`birth_name`	Unknown
`birth_name_prefix`	Unknown
`birth_place`	Unknown
`business_email`	Unknown
`business_fax`	Unknown
`business_mobile`	Unknown
`business_phone`	Unknown
`business_phone_extension`	Unknown
`city`	Unknown
`code`	Unknown
`country`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`custom_field`	Unknown
`email`	Unknown
`end_date`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`gender`	Unknown
`hid`	Unknown
`identification_date`	Unknown
`identification_document`	Unknown
`identification_user`	Unknown
`initials`	Unknown
`is_anonymised`	Unknown
`is_mailing_excluded`	Unknown
`is_main_contact`	Unknown
`job_title_description`	Unknown
`languages`	Unknown
`last_name`	Unknown
`lead_purpose`	Unknown
`lead_source`	Unknown
`marketing_notes`	Unknown
`middle_name`	Unknown
`mobile`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`nationality`	Unknown
`notes`	Unknown
`partner_name`	Unknown
`partner_name_prefix`	Unknown
`person`	Unknown
`phone`	Unknown
`phone_extension`	Unknown
`picture`	Unknown
`picture_name`	Unknown
`picture_thumbnail_url`	Unknown
`picture_url`	Unknown
`postcode`	Unknown
`start_date`	Unknown
`state`	Unknown
`timestamps`	Unknown
`title`	Unknown
`title_abbreviation`	Unknown
`title_description`	Unknown
`metadata_`

gl_classification

Column	Type	Keys
`id`	Unknown	PK
`division_id`	Unknown	FK
`abstract`	Unknown
`balance`	Unknown
`code`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`description`	Unknown
`is_tuple_sub_element`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`name`	Unknown
`nillable`	Unknown
`parent`	Unknown
`period_type`	Unknown
`substitution_group`	Unknown
`taxonomy_namespace`	Unknown
`taxonomy_namespace_description`	Unknown
`timestamps`	Unknown
`type`	Unknown
`metadata_`

system_division

Column	Type	Keys
`id`	Unknown	PKFK
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_line_3`	Unknown
`archive_date`	Unknown
`blocking_status`	Unknown
`business_type_code`	Unknown
`business_type_description`	Unknown
`chamber_of_commerce_establishment`	Unknown
`chamber_of_commerce_number`	Unknown
`city`	Unknown
`class_01`	Unknown
`class_02`	Unknown
`class_03`	Unknown
`class_04`	Unknown
`class_05`	Unknown
`company_size_code`	Unknown
`company_size_description`	Unknown
`country`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`currency`	Unknown
`current`	Unknown
`customer`	Unknown
`customer_code`	Unknown
`customer_name`	Unknown
`date_v_accountant_number`	Unknown
`date_v_client_number`	Unknown
`description`	Unknown
`division_hr_link_unlink_date`	Unknown
`division_move_date`	Unknown
`email`	Unknown
`fax`	Unknown
`hid`	Unknown
`is_dossier_division`	Unknown
`is_hr_division`	Unknown
`is_main_division`	Unknown
`is_practice_division`	Unknown
`legislation`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`ob_number`	Unknown
`phone`	Unknown
`postcode`	Unknown
`sbi_code`	Unknown
`sbi_description`	Unknown
`sector_code`	Unknown
`sector_description`	Unknown
`share_capital`	Unknown
`siret_number`	Unknown
`start_date`	Unknown
`state`	Unknown
`status`	Unknown
`subsector_code`	Unknown
`subsector_description`	Unknown
`tax_office_number`	Unknown
`tax_reference_number`	Unknown
`template_code`	Unknown
`vat_number`	Unknown
`website`	Unknown
`metadata_`

lead_purpose

Column	Type	Keys
`id`	Unknown	PK
`division_id`	Unknown	FK
`code`	Unknown
`description`	Unknown
`division_company_coc_number`	Unknown
`division_company_iban_number`	Unknown
`division_company_name`	Unknown
`division_company_rsin_number`	Unknown
`division_company_vat_number`	Unknown
`division_company_wage_tax_number`	Unknown
`division_label`	Unknown
`division_name`	Unknown
`division_owner_company_name`	Unknown
`division_owner_company_number`	Unknown
`division_short_name`	Unknown

gl_account

Column	Type	Keys
`id`	Unknown	PK
`division_id`	Unknown	FK
`allow_costs_in_sales`	Unknown
`assimilated_vatbox`	Unknown
`balance_side`	Unknown
`balance_type`	Unknown
`belcotax_type`	Unknown
`code`	Unknown
`compress`	Unknown
`cost_center`	Unknown
`cost_center_description`	Unknown
`costunit`	Unknown
`costunit_description`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_fullname`	Unknown
`custom_field`	Unknown
`deductibility_percentages_deferred_uri`	Unknown
`description`	Unknown
`description_term_id`	Unknown
`exclude_vat_listing`	Unknown
`expense_non_deductible_percentage`	Unknown
`is_blocked`	Unknown
`matching`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`private_gl_account`	Unknown
`private_percentage`	Unknown
`reporting_code`	Unknown
`revalue_currency`	Unknown
`search_code`	Unknown
`timestamps`	Unknown
`type`	Unknown
`type_description`	Unknown
`use_cost_center`	Unknown
`use_costunit`	Unknown
`vat_code`	Unknown
`vat_description`	Unknown
`vat_gl_account_type`	Unknown
`vat_non_deductible_gl_account`	Unknown
`vat_non_deductible_percentage`	Unknown
`vat_system`	Unknown
`year_end_cost_gl_account`	Unknown
`year_end_reflection_gl_account`	Unknown
`metadata_`

bank_account

Column	Type	Keys
`id`	Unknown	PK
`division_id`	Unknown	FK
`account`	Unknown
`account_name`	Unknown
`bank`	Unknown
`bank_account`	Unknown
`bank_account_holder_name`	Unknown
`bank_description`	Unknown
`bank_name`	Unknown
`bic_code`	Unknown
`blocked`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`description`	Unknown
`format`	Unknown
`iban`	Unknown
`main`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`payment_service_account`	Unknown
`type`	Unknown
`type_description`	Unknown
`metadata_`

reporting_balance

Column	Type	Keys
`id`	Unknown	PK
`division`	Unknown	FK
`amount`	Unknown
`amount_credit`	Unknown
`amount_debit`	Unknown
`balance_type`	Unknown
`cost_center_code`	Unknown
`cost_center_description`	Unknown
`cost_unit_code`	Unknown
`cost_unit_description`	Unknown
`count`	Unknown
`gl_account`	Unknown
`gl_account_code`	Unknown
`gl_account_description`	Unknown
`reporting_period`	Unknown
`reporting_year`	Unknown
`status`	Unknown
`type`	Unknown
`metadata_`

transaction_line

Column	Type	Keys
`id`	Unknown	PK
`account`	Unknown
`account_code`	Unknown
`account_name`	Unknown
`amount_dc`	Unknown
`amount_fc`	Unknown
`amount_vat_base_fc`	Unknown
`amount_vat_fc`	Unknown
`asset`	Unknown
`asset_code`	Unknown
`asset_description`	Unknown
`cost_center`	Unknown
`cost_center_description`	Unknown
`cost_unit`	Unknown
`cost_unit_description`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`currency`	Unknown
`custom_field`	Unknown
`date`	Unknown
`description`	Unknown
`division`	Unknown
`document`	Unknown
`document_number`	Unknown
`document_subject`	Unknown
`due_date`	Unknown
`entry_id`	Unknown
`entry_number`	Unknown
`exchange_rate`	Unknown
`external_link_description`	Unknown
`external_link_reference`	Unknown
`extra_duty_amount_fc`	Unknown
`extra_duty_percentage`	Unknown
`financial_period`	Unknown
`financial_year`	Unknown
`gl_account`	Unknown
`gl_account_code`	Unknown
`gl_account_description`	Unknown
`invoice_number`	Unknown
`item`	Unknown
`item_code`	Unknown
`item_description`	Unknown
`journal_code`	Unknown
`journal_description`	Unknown
`line_number`	Unknown
`line_type`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`notes`	Unknown
`offset_id`	Unknown
`order_number`	Unknown
`payment_discount_amount`	Unknown
`payment_reference`	Unknown
`project`	Unknown
`project_code`	Unknown
`project_description`	Unknown
`quantity`	Unknown
`serial_number`	Unknown
`shop_order`	Unknown
`status`	Unknown
`subscription`	Unknown
`subscription_description`	Unknown
`system_division_id`	Unknown
`tracking_number`	Unknown
`tracking_number_description`	Unknown
`type`	Unknown
`vat_code`	Unknown
`vat_code_description`	Unknown
`vat_percentage`	Unknown
`vat_type`	Unknown
`your_ref`	Unknown
`metadata_`

profit_loss_overview

Column	Type	Keys
`_fivetran_id`	String	PK
`costs_current_period`	Unknown
`costs_current_year`	Unknown
`costs_previous_year`	Unknown
`costs_previous_year_period`	Unknown
`currency_code`	Unknown
`current_period`	Unknown
`current_year`	Unknown
`metadata_type`	Unknown
`metadata_uri`	Unknown
`previous_year`	Unknown
`previous_year_period`	Unknown
`result_current_period`	Unknown
`result_current_year`	Unknown
`result_previous_year`	Unknown
`result_previous_year_period`	Unknown
`revenue_current_period`	Unknown
`revenue_current_year`	Unknown
`revenue_previous_year`	Unknown
`revenue_previous_year_period`	Unknown
`system_division_id`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`division_id`	Unknown	FK
`account`	Unknown
`account_city`	Unknown
`account_code`	Unknown
`account_is_supplier`	Unknown
`account_logo_thumbnail_url`	Unknown
`account_name`	Unknown
`account_status`	Unknown
`created`	Unknown
`created_utc`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`division_company_coc_number`	Unknown
`division_company_iban_number`	Unknown
`division_company_name`	Unknown
`division_company_rsin_number`	Unknown
`division_company_vat_number`	Unknown
`division_company_wage_tax_number`	Unknown
`division_label`	Unknown
`division_name`	Unknown
`division_owner_company_name`	Unknown
`division_owner_company_number`	Unknown
`division_short_name`	Unknown
`involved_user_role`	Unknown
`involved_user_role_description`	Unknown
`is_main_contact`	Unknown
`modified`	Unknown
`modified_utc`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`person_email`	Unknown
`person_phone`	Unknown
`person_phone_extension`	Unknown
`person_picture_thumbnail_url`	Unknown
`user_full_name`	Unknown
`users`	Unknown

subscription_line

Column	Type	Keys
`id`	Unknown	PK
`division`	Unknown	FK
`amount_dc`	Unknown
`amount_fc`	Unknown
`cost_center`	Unknown
`costunit`	Unknown
`custom_field`	Unknown
`description`	Unknown
`discount`	Unknown
`entry_id`	Unknown
`from_date`	Unknown
`item`	Unknown
`item_description`	Unknown
`line_number`	Unknown
`line_type`	Unknown
`line_type_description`	Unknown
`modified`	Unknown
`net_price`	Unknown
`note`	Unknown
`quantity`	Unknown
`subscription_number`	Unknown
`timestamps`	Unknown
`to_date`	Unknown
`unit_code`	Unknown
`unit_description`	Unknown
`unit_price`	Unknown
`vat_amount_fc`	Unknown
`vat_code`	Unknown
`vat_code_description`	Unknown
`metadata_`

account_classification

Column	Type	Keys
`id`	Unknown	PK
`division_id`	Unknown	FK
`account_classification_name`	Unknown
`account_classification_name_description`	Unknown
`code`	Unknown
`created`	Unknown
`created_utc`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`description`	Unknown
`division_company_coc_number`	Unknown
`division_company_iban_number`	Unknown
`division_company_name`	Unknown
`division_company_rsin_number`	Unknown
`division_company_vat_number`	Unknown
`division_company_wage_tax_number`	Unknown
`division_label`	Unknown
`division_name`	Unknown
`division_owner_company_name`	Unknown
`division_owner_company_number`	Unknown
`division_short_name`	Unknown
`modified`	Unknown
`modified_utc`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown

return

Column	Type	Keys
`document_id`	Unknown	PK
`amount`	Unknown
`created`	Unknown
`currency`	Unknown
`description`	Unknown
`document_view_url`	Unknown
`due_date`	Unknown
`frequency`	Unknown
`metadata_type`	Unknown
`metadata_uri`	Unknown
`payroll_declaration_type`	Unknown
`period`	Unknown
`period_description`	Unknown
`request`	Unknown
`status`	Unknown
`subject`	Unknown
`system_division_id`	Unknown
`type`	Unknown
`year`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`division_id`	Unknown	FK
`account_manager`	Unknown
`account_manager_full_name`	Unknown
`account_manager_hid`	Unknown
`accountant`	Unknown
`activity_sector`	Unknown
`activity_sub_sector`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_line_3`	Unknown
`address_source`	Unknown
`bankaccounts_deferred_uri`	Unknown
`blocked`	Unknown
`brin`	Unknown
`bsn`	Unknown
`business_type`	Unknown
`can_drop_ship`	Unknown
`chamber_of_commerce`	Unknown
`city`	Unknown
`classification`	Unknown
`classification_1`	Unknown
`classification_2`	Unknown
`classification_3`	Unknown
`classification_4`	Unknown
`classification_5`	Unknown
`classification_6`	Unknown
`classification_7`	Unknown
`classification_8`	Unknown
`classification_description`	Unknown
`code`	Unknown
`code_at_supplier`	Unknown
`company_size`	Unknown
`consolidation_scenario`	Unknown
`controlled_date`	Unknown
`cost_center`	Unknown
`cost_center_description`	Unknown
`cost_paid`	Unknown
`country`	Unknown
`country_name`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`credit_line_purchase`	Unknown
`credit_line_sales`	Unknown
`currency`	Unknown
`custom_field`	Unknown
`customer_since`	Unknown
`datev_creditor_code`	Unknown
`datev_debtor_code`	Unknown
`delivery_advice`	Unknown
`discount_purchase`	Unknown
`discount_sales`	Unknown
`document`	Unknown
`duns_number`	Unknown
`email`	Unknown
`enable_sales_payment_link`	Unknown
`end_date`	Unknown
`eori_number`	Unknown
`established_date`	Unknown
`fax`	Unknown
`gl_account_purchase`	Unknown
`gl_account_sales`	Unknown
`glap`	Unknown
`glar`	Unknown
`gln_number`	Unknown
`has_withholding_tax_sales`	Unknown
`ignore_datev_warning_message`	Unknown
`incoterm_address_purchase`	Unknown
`incoterm_address_sales`	Unknown
`incoterm_code_purchase`	Unknown
`incoterm_code_sales`	Unknown
`incoterm_version_purchase`	Unknown
`incoterm_version_sales`	Unknown
`intra_stat_area`	Unknown
`intra_stat_delivery_term`	Unknown
`intra_stat_system`	Unknown
`intra_stat_transaction_a`	Unknown
`intra_stat_transaction_b`	Unknown
`intra_stat_transport_method`	Unknown
`invoice_account`	Unknown
`invoice_account_code`	Unknown
`invoice_account_name`	Unknown
`invoice_attachment_type`	Unknown
`invoicing_method`	Unknown
`is_accountant`	Unknown
`is_agency`	Unknown
`is_anonymised`	Unknown
`is_bank`	Unknown
`is_competitor`	Unknown
`is_extra_duty`	Unknown
`is_mailing`	Unknown
`is_member`	Unknown
`is_pilot`	Unknown
`is_purchase`	Unknown
`is_reseller`	Unknown
`is_sales`	Unknown
`is_supplier`	Unknown
`language_description`	Unknown
`languages`	Unknown
`latitude`	Unknown
`lead_purpose`	Unknown
`lead_source`	Unknown
`logo`	Unknown
`logo_file_name`	Unknown
`logo_thumbnail_url`	Unknown
`logo_url`	Unknown
`longitude`	Unknown
`main_contact`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`name`	Unknown
`oin_number`	Unknown
`parent`	Unknown
`pay_as_you_earn`	Unknown
`payment_condition_purchase`	Unknown
`payment_condition_purchase_description`	Unknown
`payment_condition_sales`	Unknown
`payment_condition_sales_description`	Unknown
`phone`	Unknown
`phone_extension`	Unknown
`postcode`	Unknown
`price_list`	Unknown
`purchase_currency`	Unknown
`purchase_currency_description`	Unknown
`purchase_lead_days`	Unknown
`purchase_v_a_t_code`	Unknown
`purchase_v_a_t_code_description`	Unknown
`recepient_of_commissions`	Unknown
`remarks`	Unknown
`reseller`	Unknown
`reseller_code`	Unknown
`reseller_name`	Unknown
`rsin`	Unknown
`sales_currency`	Unknown
`sales_currency_description`	Unknown
`sales_tax_schedule`	Unknown
`sales_tax_schedule_code`	Unknown
`sales_tax_schedule_description`	Unknown
`sales_v_a_t_code`	Unknown
`sales_v_a_t_code_description`	Unknown
`search_code`	Unknown
`security_level`	Unknown
`separate_inv_per_project`	Unknown
`separate_inv_per_subscription`	Unknown
`shipping_lead_days`	Unknown
`shipping_method`	Unknown
`show_remark_for_sales`	Unknown
`source`	Unknown
`start_date`	Unknown
`state`	Unknown
`state_name`	Unknown
`status`	Unknown
`status_since`	Unknown
`timestamps`	Unknown
`trade_name`	Unknown
`type`	Unknown
`unique_taxpayer_reference`	Unknown
`vat_liability`	Unknown
`vat_number`	Unknown
`website`	Unknown
`metadata_`

sales_invoice

Column	Type	Keys
`id`	Unknown	PK
`amount_dc`	Unknown
`amount_discount`	Unknown
`amount_discount_excl_vat`	Unknown
`amount_fc`	Unknown
`amount_fc_excl_vat`	Unknown
`created`	Unknown
`creator`	Unknown
`creator_full_name`	Unknown
`currency`	Unknown
`deliver_to`	Unknown
`deliver_to_address`	Unknown
`deliver_to_contact_person`	Unknown
`deliver_to_contact_person_full_name`	Unknown
`deliver_to_name`	Unknown
`description`	Unknown
`discount`	Unknown
`discount_type`	Unknown
`division`	Unknown
`document`	Unknown
`document_number`	Unknown
`document_subject`	Unknown
`due_date`	Unknown
`extra_duty_amount_fc`	Unknown
`g_account_amount_fc`	Unknown
`incoterm_address`	Unknown
`incoterm_code`	Unknown
`incoterm_version`	Unknown
`invoice_date`	Unknown
`invoice_number`	Unknown
`invoice_to`	Unknown
`invoice_to_contact_person`	Unknown
`invoice_to_contact_person_full_name`	Unknown
`invoice_to_name`	Unknown
`is_extra_duty`	Unknown
`journal`	Unknown
`journal_description`	Unknown
`modified`	Unknown
`modifier`	Unknown
`modifier_full_name`	Unknown
`order_date`	Unknown
`order_number`	Unknown
`ordered_by`	Unknown
`ordered_by_contact_person`	Unknown
`ordered_by_contact_person_full_name`	Unknown
`ordered_by_name`	Unknown
`payment_condition`	Unknown
`payment_condition_description`	Unknown
`payment_reference`	Unknown
`remarks`	Unknown
`sales_channel`	Unknown
`sales_channel_code`	Unknown
`sales_channel_description`	Unknown
`sales_invoice_lines`	Unknown
`salesperson`	Unknown
`salesperson_full_name`	Unknown
`selection_code`	Unknown
`selection_code_code`	Unknown
`selection_code_description`	Unknown
`shipping_method`	Unknown
`shipping_method_code`	Unknown
`shipping_method_description`	Unknown
`starter_sales_invoice_status`	Unknown
`starter_sales_invoice_status_description`	Unknown
`status`	Unknown
`status_description`	Unknown
`system_division_id`	Unknown
`tax_schedule`	Unknown
`tax_schedule_code`	Unknown
`tax_schedule_description`	Unknown
`type`	Unknown
`type_description`	Unknown
`vat_amount_dc`	Unknown
`vat_amount_fc`	Unknown
`warehouse`	Unknown
`withholding_tax_amount_fc`	Unknown
`withholding_tax_base_amount`	Unknown
`withholding_tax_percentage`	Unknown
`your_ref`	Unknown
`metadata_`