Visma

Explore the interactive ERD

Table & Field Reference

financial_period

Column	Type	Keys
`period`	String	PK
`active`	Unknown
`closed_in_cash_management`	Unknown
`closed_in_customer_ledger`	Unknown
`closed_in_fixed_assets`	Unknown
`closed_in_general_ledger`	Unknown
`closed_in_inventory_management`	Unknown
`closed_in_supplier_ledger`	Unknown
`description`	String
`end_date`	Unknown
`start_date`	Unknown
`year`	Unknown

inventory_issue_line_allocation

Column	Type	Keys
`index`	Unknown	PK
`inventory_issue_id`	String	PKFK
`inventory_issue_line_index`	Unknown	PKFK
`expiration_date`	Unknown
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`quantity`	Unknown
`uom`	String

inventory_issue_line_attachment

Column	Type	Keys
`id`	String	PK
`inventory_issue_id`	String	PKFK
`inventory_issue_line_index`	Unknown	PKFK
`name`	String
`revision`	Unknown

inventory_issue_line

Column	Type	Keys
`index`	Unknown	PK
`inventory_issue_id`	String	PKFK
`branch_number`	String	FK
`warehouse_id`	String	FK
`description`	String
`expiration_date`	Unknown
`ext_cost`	Unknown
`ext_price`	Unknown
`inventory_item_description`	String
`inventory_item_number`	String
`line_number`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`project_description`	String
`project_id`	String
`project_task_description`	String
`project_task_id`	String
`purchase_order_receipt_number`	String
`quantity`	Unknown
`reason_code_description`	String
`reason_code_id`	String
`transaction_type`	String
`unit_cost`	Unknown
`unit_price`	Unknown
`uom`	String

inventory_issue_attachment

Column	Type	Keys
`id`	String	PK
`inventory_issue_id`	String	PKFK
`name`	String
`revision`	Unknown

inventory_issue

Column	Type	Keys
`id`	String	PK
`branch_number`	String	FK
`batch_number`	String
`control_amount`	Unknown
`control_quantity`	Unknown
`date`	Unknown
`description`	String
`external_reference`	String
`hold`	Unknown
`last_modified_date_time`	Unknown
`post_period`	String
`status`	String
`timestamps`	String
`total_amount`	Unknown
`total_quantity`	Unknown

branch

Column	Type	Keys
`id`	Unknown	PK
`number`	String	PK
`currency_id`	String	FK
`organization_id`	Unknown	FK
`bank_settings_address_1`	String
`bank_settings_address_2`	String
`bank_settings_address_3`	String
`bank_settings_bba_n_2`	String
`bank_settings_bba_n_3`	String
`bank_settings_bban`	String
`bank_settings_bic`	String
`bank_settings_country`	String
`bank_settings_creditor_id`	String
`bank_settings_iban`	String
`bank_settings_name`	String
`corporate_id`	String
`default_country_id`	String
`default_country_name`	String
`delivery_address_address_line_1`	String
`delivery_address_address_line_2`	String
`delivery_address_address_line_3`	String
`delivery_address_city`	String
`delivery_address_country_id`	String
`delivery_address_country_name`	String
`delivery_address_county_id`	String
`delivery_address_county_name`	String
`delivery_address_id`	Unknown
`delivery_address_postal_code`	String
`delivery_contact_attention`	String
`delivery_contact_email`	String
`delivery_contact_fax`	String
`delivery_contact_id`	Unknown
`delivery_contact_name`	String
`delivery_contact_phone_1`	String
`delivery_contact_phone_2`	String
`delivery_contact_web`	String
`industry_code_description`	String
`industry_code_id`	String
`is_active`	Unknown
`is_main_branch`	Unknown
`last_modified_date_time`	Unknown
`ledger_description`	String
`ledger_id`	String
`main_address_city`	String
`main_address_country_id`	String
`main_address_country_name`	String
`main_address_county_id`	String
`main_address_county_name`	String
`main_address_id`	Unknown
`main_address_line_1`	String
`main_address_line_2`	String
`main_address_line_3`	String
`main_address_postal_code`	String
`main_contact_attention`	String
`main_contact_email`	String
`main_contact_fax`	String
`main_contact_id`	Unknown
`main_contact_name`	String
`main_contact_phone_1`	String
`main_contact_phone_2`	String
`main_contact_web`	String
`name`	String
`vat_registration_id`	String
`vat_zone_description`	String
`vat_zone_id`	String

supplier_location_payment_method_detail

Column	Type	Keys
`id`	String	PK
`supplier_location_baccount_internal_id`	Unknown	PKFK
`supplier_location_location_id`	String	PKFK
`banking_detail_type`	String
`description`	String
`value`	String

supplier_location

Column	Type	Keys
`location_id`	String	PK
`baccount_internal_id`	Unknown	PKFK
`active`	Unknown
`address_city`	String
`address_country_id`	String
`address_country_name`	String
`address_county_id`	String
`address_county_name`	String
`address_id`	Unknown
`address_line_1`	String
`address_line_2`	String
`address_line_3`	String
`address_postal_code`	String
`contact_attention`	String
`contact_email`	String
`contact_fax`	String
`contact_id`	Unknown
`contact_name`	String
`contact_phone_1`	String
`contact_phone_2`	String
`contact_web`	String
`corporate_id`	String
`edi_code`	String
`gln`	String
`last_modified_date_time`	Unknown
`time_stamp`	String
`vat_registration_id`	String
`vat_zone_default_tax_category_description`	String
`vat_zone_default_tax_category_number`	String
`vat_zone_default_vat_category`	String
`vat_zone_description`	String
`vat_zone_id`	String

inventory_adjustment_line_attachment

Column	Type	Keys
`id`	String	PK
`inventory_adjustment_id`	String	PKFK
`inventory_adjustment_line_index`	Unknown	PKFK
`name`	String
`revision`	Unknown

inventory_adjustment_line

Column	Type	Keys
`index`	Unknown	PK
`inventory_adjustment_id`	String	PKFK
`branch_number`	String	FK
`location_id`	String	FK
`warehouse_id`	String	FK
`description`	String
`ext_cost`	Unknown
`inventory_item_description`	String
`inventory_item_number`	String
`line_number`	Unknown
`location_country_id`	String
`location_name`	String
`purchase_order_receipt_number`	String
`quantity`	Unknown
`reason_code_description`	String
`reason_code_id`	String
`receipt_number`	String
`unit_cost`	Unknown
`uom`	String

inventory_adjustment_attachment

Column	Type	Keys
`id`	String	PK
`inventory_adjustment_id`	String	PKFK
`name`	String
`revision`	Unknown

inventory_adjustment

Column	Type	Keys
`id`	String	PK
`branch_number`	String	FK
`batch_number`	String
`control_cost`	Unknown
`control_quantity`	Unknown
`date`	Unknown
`description`	String
`external_reference`	String
`hold`	Unknown
`last_modified_date_time`	Unknown
`post_period`	String
`status`	String
`timestamps`	String
`total_cost`	Unknown
`total_quantity`	Unknown

inventory_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`inventory_id`	String	FK
`location_id`	String	FK
`warehouse_id`	String	FK
`available`	Unknown
`available_for_shipment`	Unknown
`base_unit`	String
`drop_ship_for_so`	Unknown
`drop_ship_for_so_prepared`	Unknown
`drop_ship_for_so_receipt`	Unknown
`estimated_total_cost`	Unknown
`estimated_unit_cost`	Unknown
`expired`	Unknown
`in_assembly_demand`	Unknown
`in_assembly_supply`	Unknown
`in_issues`	Unknown
`in_receipts`	Unknown
`in_transit`	Unknown
`location_name`	String
`not_available`	Unknown
`on_hand`	Unknown
`po_receipt`	Unknown
`purchase_for_so`	Unknown
`purchase_for_so_prepared`	Unknown
`purchase_for_so_receipt`	Unknown
`purchase_order`	Unknown
`purchase_prepared`	Unknown
`so_allocated`	Unknown
`so_back_ordered`	Unknown
`so_booked`	Unknown
`so_shipped`	Unknown
`so_to_drop_ship`	Unknown
`so_to_purchase`	Unknown

supplier_attribute

Column	Type	Keys
`id`	String	PKFK
`supplier_id`	Unknown	PKFK
`description`	String
`value`	String

supplier_payment_method_detail

Column	Type	Keys
`id`	String	PKFK
`supplier_id`	Unknown	PKFK
`banking_detail_type`	String
`description`	String
`value`	String

supplier

Column	Type	Keys
`id`	Unknown	PK
`number`	String	PK
`cash_account`	String	FK
`currency_id`	String	FK
`gl_accounts_expense_sub_account_id`	String	FK
`gl_accounts_supplier_sub_account_id`	String	FK
`payment_method_id`	String	FK
`account_reference`	String
`account_used_for_payment`	String
`charge_bearer`	String
`corporate_id`	String
`credit_terms_description`	String
`credit_terms_id`	String
`document_language`	String
`gl_accounts_expense_account_description`	String
`gl_accounts_expense_account_import_description`	String
`gl_accounts_expense_account_import_number`	String
`gl_accounts_expense_account_import_type`	String
`gl_accounts_expense_account_non_tax_description`	String
`gl_accounts_expense_account_non_tax_number`	String
`gl_accounts_expense_account_non_tax_type`	String
`gl_accounts_expense_account_number`	String
`gl_accounts_expense_account_type`	String
`gl_accounts_expense_eu_account_description`	String
`gl_accounts_expense_eu_account_number`	String
`gl_accounts_expense_eu_account_type`	String
`gl_accounts_supplier_account_description`	String
`gl_accounts_supplier_account_number`	String
`gl_accounts_supplier_account_type`	String
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`main_address_city`	String
`main_address_country_id`	String
`main_address_country_name`	String
`main_address_county_id`	String
`main_address_county_name`	String
`main_address_id`	Unknown
`main_address_line_1`	String
`main_address_line_2`	String
`main_address_line_3`	String
`main_address_postal_code`	String
`main_contact_attention`	String
`main_contact_email`	String
`main_contact_fax`	String
`main_contact_id`	Unknown
`main_contact_name`	String
`main_contact_phone_1`	String
`main_contact_phone_2`	String
`main_contact_web`	String
`name`	String
`note`	String
`number_of_employee`	Unknown
`parent_record_name`	String
`parent_record_number`	String
`pay_separately`	Unknown
`payment_by`	String
`payment_lead_time`	Unknown
`payment_ref_display_mask`	String
`remit_address_city`	String
`remit_address_county_id`	String
`remit_address_county_name`	String
`remit_address_id`	Unknown
`remit_address_line_1`	String
`remit_address_line_2`	String
`remit_address_line_3`	String
`remit_address_postal_code`	String
`remit_contact_attention`	String
`remit_contact_email`	String
`remit_contact_fax`	String
`remit_contact_id`	Unknown
`remit_contact_name`	String
`remit_contact_phone_1`	String
`remit_contact_phone_2`	String
`remit_contact_web`	String
`remit_sddress_country_id`	String
`remit_sddress_country_name`	String
`retainage_apply`	Unknown
`retainage_cash_account_id`	String
`retainage_pct`	Unknown
`status`	String
`supplier_address_city`	String
`supplier_address_country_id`	String
`supplier_address_country_name`	String
`supplier_address_county_id`	String
`supplier_address_county_name`	String
`supplier_address_id`	Unknown
`supplier_address_line_1`	String
`supplier_address_line_2`	String
`supplier_address_line_3`	String
`supplier_address_postal_code`	String
`supplier_class_description`	String
`supplier_class_id`	String
`supplier_contact_attention`	String
`supplier_contact_email`	String
`supplier_contact_fax`	String
`supplier_contact_id`	Unknown
`supplier_contact_name`	String
`supplier_contact_phone_1`	String
`supplier_contact_phone_2`	String
`supplier_contact_web`	String
`vat_registration_id`	String
`vat_zone_default_tax_categorydescription`	String
`vat_zone_default_tax_categorynumber`	String
`vat_zone_default_vat_category`	String
`vat_zone_description`	String
`vat_zone_id`	String

kit_specification_stock_component_line

Column	Type	Keys
`line_nbr`	Unknown	PK
`kit_specification_id`	String	PKFK
`allow_component_qty_variance`	Unknown
`allow_component_substitution`	Unknown
`component_id`	String
`component_qty`	Unknown
`description`	String
`disassembly_coeff`	Unknown
`max_component_qty`	Unknown
`min_component_qty`	Unknown
`uom`	String

kit_specification_non_stock_component_line

Column	Type	Keys
`line_nbr`	Unknown	PK
`kit_specification_id`	String	PKFK
`allow_component_qty_variance`	Unknown
`component_id`	String
`component_qty`	Unknown
`description`	String
`max_component_qty`	Unknown
`min_component_qty`	Unknown
`uom`	String

kit_specification

Column	Type	Keys
`id`	String	PK
`allow_component_addition`	Unknown
`created_date_time`	Unknown
`description`	String
`is_active`	Unknown
`is_non_stock`	Unknown
`last_modified_date_time`	Unknown
`revision`	String
`timestamps`	String

warehouse_location_attribute_detail

Column	Type	Keys
`id`	String	PK
`warehouse_location_attribute_id`	String	PKFK
`warehouse_location_attribute_warehouse_id`	String	PKFK
`warehouse_location_attribute_warehouse_location_id`	String	PKFK
`description`	String

warehouse_location_attribute

Column	Type	Keys
`id`	String	PKFK
`warehouse_id`	String	PKFK
`warehouse_location_id`	String	PKFK
`default_value`	String
`description`	String
`required`	Unknown
`sort_order`	Unknown
`type`	String

warehouse_location

Column	Type	Keys
`location_id`	String	PK
`warehouse_id`	String	PKFK
`active`	Unknown
`assembly_valid`	Unknown
`description`	String
`incl_qty_avail`	Unknown
`is_costed`	Unknown
`primary_item_class_description`	String
`primary_item_class_id`	String
`primary_item_class_type`	String
`primary_item_description`	String
`primary_item_number`	String
`primary_item_valid`	String
`project_description`	String
`project_id`	String
`project_task_description`	String
`project_task_id`	String
`receipts_valid`	Unknown
`sales_valid`	Unknown
`transfers_valid`	Unknown

warehouse

Column	Type	Keys
`id`	String	PK
`branch_number`	String	FK
`active`	Unknown
`address_city`	String
`address_country_id`	String
`address_country_name`	String
`address_county_id`	String
`address_county_name`	String
`address_id`	Unknown
`address_line_1`	String
`address_line_2`	String
`address_type`	String
`address_validated`	Unknown
`avg_default_cost`	String
`contact_attention`	String
`contact_company_name`	String
`contact_email`	String
`contact_fax`	String
`contact_id`	Unknown
`contact_phone_1`	String
`contact_phone_2`	String
`contact_web`	String
`description`	String
`drop_ship_location_description`	String
`drop_ship_location_id`	String
`fifo_default_cost`	String
`location_entry`	String
`lock_site_pi_count_entry`	Unknown
`receipt_location_description`	String
`receipt_location_id`	String
`replenishment_class_description`	String
`replenishment_class_id`	String
`return_location_description`	String
`return_location_id`	String
`ship_location_description`	String
`ship_location_id`	String
`timestamps`	String

sales_order_type

Column	Type	Keys
`order_type`	String	PK
`active`	Unknown
`behavior`	String
`customer_document_type`	String
`default_operation`	String
`description`	String

purchase_order_discount_detail

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	String	PKFK
`discount`	Unknown
`discount_amt`	Unknown
`discount_code`	String
`discountable_amt`	Unknown
`discountable_qty`	Unknown
`free_item`	Unknown
`free_item_qty`	Unknown
`line_nbr`	Unknown
`manual_discount`	Unknown
`sequance_id`	String
`skip_discount`	Unknown
`type`	String

purchase_order_tax_detail

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	String	PKFK
`id`	String
`record_id`	Unknown
`taxable_amount`	Unknown
`vat_amount`	Unknown
`vat_id_description`	String
`vat_id_number`	String
`vat_rate`	Unknown

purchase_order_line_sub_segment

Column	Type	Keys
`id`	Unknown	PK
`purchase_order_id`	String	PKFK
`purchase_order_line_index`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

purchase_order_line

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	String	PKFK
`account_number`	Unknown	FK
`branch_number`	String	FK
`inventory_number`	String	FK
`sub_account_id`	Unknown	FK
`warehouse_id`	String	FK
`alternate_id`	String
`amount`	Unknown
`canceled`	Unknown
`complete_on`	Unknown
`completed`	Unknown
`description`	String
`discount_amount`	Unknown
`discount_code_description`	String
`discount_code_number`	String
`discount_percent`	Unknown
`ext_cost`	Unknown
`line_nbr`	Unknown
`manual_discount`	Unknown
`max_receipt`	Unknown
`min_receipt`	Unknown
`note`	String
`order_number`	String
`order_qty`	Unknown
`order_type`	String
`project_description`	String
`project_id`	String
`project_task_description`	String
`project_task_id`	String
`promised`	Unknown
`qty_on_receipt`	Unknown
`receipt_action`	String
`received_amt`	Unknown
`requested`	Unknown
`tax_category_description`	String
`tax_category_number`	String
`type`	String
`unit_cost`	Unknown
`unit_cost_in_base_currency`	Unknown
`uom`	String

purchase_order_receipt

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	String	PKFK
`currency`	String
`number`	String
`status`	String
`supplier_name`	String
`total_amt`	Unknown
`total_qty`	Unknown
`type`	String

purchase_order

Column	Type	Keys
`id`	String	PK
`branch_number`	String	FK
`currency_id`	String	FK
`sales_order_type`	String	FK
`supplier_internal_id`	Unknown	FK
`warehouse_id`	String	FK
`control_total`	Unknown
`control_total_in_base_currency`	Unknown
`date`	Unknown
`default_tax_category_description`	String
`default_tax_category_number`	String
`description`	String
`dont_email`	Unknown
`dont_print`	Unknown
`emailed`	Unknown
`exchange_rate`	Unknown
`fob_point`	String
`hold`	Unknown
`last_modified_date_time`	Unknown
`line_total`	Unknown
`line_total_in_base_currency`	Unknown
`location_id`	Unknown
`location_name`	String
`note`	String
`open_balance`	Unknown
`open_quantity`	Unknown
`order_total_in_base_currency`	Unknown
`order_type`	String
`owner_id`	String
`owner_name`	String
`payment_ref_nbr`	String
`printed`	Unknown
`promised_on`	Unknown
`remit_address_city`	String
`remit_address_country_id`	String
`remit_address_country_name`	String
`remit_address_county_id`	String
`remit_address_county_name`	String
`remit_address_id`	Unknown
`remit_address_line_1`	String
`remit_address_line_2`	String
`remit_address_line_3`	String
`remit_address_override_address`	Unknown
`remit_address_postal_code`	String
`remit_contact_attention`	String
`remit_contact_email`	String
`remit_contact_fax`	String
`remit_contact_id`	Unknown
`remit_contact_name`	String
`remit_contact_override_contact`	Unknown
`remit_contact_phone_1`	String
`remit_contact_phone_2`	String
`remit_contact_web`	String
`requisition_ref_nbr`	String
`sales_order_nbr`	String
`ship_term`	String
`ship_to_internal_id`	Unknown
`ship_to_name`	String
`ship_to_number`	String
`ship_via`	String
`shipping_address_city`	String
`shipping_address_country_id`	String
`shipping_address_country_name`	String
`shipping_address_county_id`	String
`shipping_address_county_name`	String
`shipping_address_id`	Unknown
`shipping_address_line_1`	String
`shipping_address_line_2`	String
`shipping_address_line_3`	String
`shipping_address_override_address`	Unknown
`shipping_address_postal_code`	String
`shipping_contact_attention`	String
`shipping_contact_email`	String
`shipping_contact_fax`	String
`shipping_contact_id`	Unknown
`shipping_contact_name`	String
`shipping_contact_override_contact`	Unknown
`shipping_contact_phone_1`	String
`shipping_contact_phone_2`	String
`shipping_contact_web`	String
`shipping_destination_type`	String
`shipping_location_id`	Unknown
`shipping_location_name`	String
`status`	String
`supplier_ref`	String
`supplier_vat_zone_default_vat_category`	String
`supplier_vat_zone_description`	String
`supplier_vat_zone_id`	String
`tax_total`	Unknown
`tax_total_in_base_currency`	Unknown
`terms_description`	String
`terms_id`	String
`vat_exempt_total`	Unknown
`vat_exempt_total_in_base_currency`	Unknown
`work_group_id`	Unknown

customer_invoice_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_invoice_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_invoice_attachment

Column	Type	Keys
`id`	String	PK
`customer_invoice_id`	String	PKFK
`name`	String
`revision`	Unknown

customer_invoice_tax_detail

Column	Type	Keys
`id`	String	PK
`customer_invoice_id`	String	PKFK
`record_id`	Unknown
`taxable_amount`	Unknown
`vat_amount`	Unknown
`vat_description`	String
`vat_number`	String
`vat_rate`	Unknown

customer_invoice_line_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_invoice_id`	String	PKFK
`customer_invoice_line_index`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

customer_invoice_line_attachment

Column	Type	Keys
`id`	String	PK
`customer_invoice_id`	String	PKFK
`customer_invoice_line_index`	Unknown	PKFK
`name`	String
`revision`	Unknown

customer_invoice_line

Column	Type	Keys
`index`	Unknown	PK
`customer_invoice_id`	String	PKFK
`account_number`	String	FK
`branch_number`	String	FK
`sub_account_id`	Unknown	FK
`amount`	Unknown
`amount_in_currency`	Unknown
`cost`	Unknown
`deductable_amount`	Unknown
`deferral_code`	String
`deferral_schedule`	Unknown
`description`	String
`discount_amount`	Unknown
`discount_amount_in_currency`	Unknown
`discount_code`	String
`discount_percent`	Unknown
`end_date`	Unknown
`external_link`	String
`inventory_number`	String
`is_rot_rut_deductible`	Unknown
`item_type`	String
`line_number`	Unknown
`line_type`	String
`manual_amount`	Unknown
`manual_amount_in_currency`	Unknown
`manual_discount`	Unknown
`note`	String
`project_task_description`	String
`project_task_id`	String
`quantity`	Unknown
`s_0_order_nbr`	String
`seller_description`	String
`seller_id`	String
`so_order_type`	String
`so_shipment_nbr`	String
`start_date`	Unknown
`term_end_date`	Unknown
`term_start_date`	Unknown
`type_of_workdescription`	String
`type_of_workrut_rot_type`	String
`type_of_workxml_tag`	String
`unit_price`	Unknown
`unit_price_in_currency`	Unknown
`uom`	String
`vat_code_description`	String
`vat_code_id`	String

customer_invoice_application

Column	Type	Keys
`index`	Unknown	PK
`customer_invoice_id`	String	PKFK
`amount_paid`	Unknown
`application_date`	Unknown
`application_period`	String
`balance`	Unknown
`cash_discount_taken`	Unknown
`customer_cd`	String
`doc_type`	String
`hold`	Unknown
`invoice_text`	String
`payment_ref`	String
`pending_ppd`	Unknown
`ppd_cr_memo_ref_nbr`	String
`ref_nbr`	String
`released`	Unknown
`status`	String
`unit_price_in_currency`	Unknown
`voided`	Unknown

customer_invoice

Column	Type	Keys
`id`	String	PK
`account_number`	String	FK
`branch_number`	Unknown	FK
`cash_account`	String	FK
`closed_financial_period`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`financial_period`	String	FK
`payment_method_id`	String	FK
`sub_account_id`	Unknown	FK
`accounting_cost_ref`	String
`amount`	Unknown
`amount_in_currency`	Unknown
`balance`	Unknown
`balance_in_currency`	Unknown
`branch_name`	String
`cash_discount`	Unknown
`cash_discount_in_currency`	Unknown
`cash_discount_rate`	Unknown
`child_record_name`	String
`child_record_number`	String
`contact_id`	Unknown
`contact_name`	String
`contract_doc_ref`	String
`created_date_time`	Unknown
`credit_terms_description`	String
`credit_terms_id`	String
`customer_project`	String
`customer_reference`	String
`customer_vat_zone_description`	String
`customer_vat_zone_id`	String
`detail_total`	Unknown
`detail_total_in_currency`	Unknown
`direct_debit_mandate_description`	String
`direct_debit_mandate_mandate_id`	String
`direct_debit_mandate_uid`	String
`document_date`	Unknown
`document_due_date`	Unknown
`document_type`	String
`dont_email`	Unknown
`dont_print`	Unknown
`dunning_letter_date`	Unknown
`dunning_letter_level`	Unknown
`end_date`	Unknown
`exchange_rate`	Unknown
`external_reference`	String
`hold`	Unknown
`invoice_address_city`	String
`invoice_address_country_id`	String
`invoice_address_country_name`	String
`invoice_address_county_id`	String
`invoice_address_county_name`	String
`invoice_address_id`	Unknown
`invoice_address_line_1`	String
`invoice_address_line_2`	String
`invoice_address_line_3`	String
`invoice_address_override_address`	Unknown
`invoice_address_postal_code`	String
`invoice_contact_attention`	String
`invoice_contact_business_name`	String
`invoice_contact_email`	String
`invoice_contact_id`	Unknown
`invoice_contact_override_contact`	Unknown
`invoice_contact_phone_1`	String
`invoice_contact_web`	String
`invoice_text`	String
`is_rot_rut_deductible`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`note`	String
`orig_invoice_date`	Unknown
`originator_doc_ref`	String
`payment_reference`	String
`post_period`	String
`project_description`	String
`project_id`	String
`revoked`	Unknown
`rounding_diff`	Unknown
`sales_person_description`	String
`sales_person_id`	String
`send_to_auto_invoice`	Unknown
`start_date`	Unknown
`status`	String
`vat_exempt_total`	Unknown
`vat_exempt_total_in_currency`	Unknown
`vat_taotal`	Unknown
`vat_taxable_total`	Unknown
`vat_taxable_total_in_currency`	Unknown
`vat_total_in_currency`	Unknown

inventory_receipt_attachment

Column	Type	Keys
`id`	String	PK
`inventory_receipt_id`	String	PKFK
`name`	String
`revision`	Unknown

inventory_receipt_line_attachment

Column	Type	Keys
`id`	String	PK
`index`	Unknown	PKFK
`inventory_receipt_id`	String	PKFK
`name`	String
`revision`	Unknown

inventory_receipt_line_allocation

Column	Type	Keys
`index`	Unknown	PK
`inventory_receipt_id`	String	PKFK
`inventory_receipt_line_index`	Unknown	PKFK
`expiration_date`	Unknown
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`quantity`	Unknown
`uom`	String

inventory_receipt_line

Column	Type	Keys
`index`	Unknown	PK
`inventory_receipt_id`	String	PKFK
`branch_number`	String	FK
`warehouse_id`	String	FK
`description`	String
`ext_cost`	Unknown
`inventory_item_description`	String
`inventory_item_number`	String
`line_number`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`project_description`	String
`project_id`	String
`project_task_description`	String
`project_task_id`	String
`purchase_order_receipt_number`	String
`quantity`	Unknown
`reason_code_description`	String
`reason_code_id`	String
`unit_cost`	Unknown
`uom`	String

inventory_receipt

Column	Type	Keys
`id`	String	PK
`branch_number`	String	FK
`batch_number`	String
`control_cost`	Unknown
`control_quantity`	Unknown
`date`	Unknown
`description`	String
`external_reference`	String
`hold`	Unknown
`last_modified_date_time`	Unknown
`post_period`	String
`status`	String
`timestamps`	String
`total_cost`	Unknown
`total_quantity`	Unknown
`transfer_number`	String

general_ledger_transaction

Column	Type	Keys
`_fivetran_id`	String	PK
`account_number`	String	FK
`branch_number`	String	FK
`currency_id`	String	FK
`ledger_id`	String	FK
`account_external_code_1`	String
`account_external_code_2`	String
`account_gl_consol_account_cd`	String
`batch_number`	String
`beg_balance`	Unknown
`credit_amount`	Unknown
`curr_beg_balance`	Unknown
`curr_credit_amount`	Unknown
`curr_debit_amount`	Unknown
`curr_ending_balance`	Unknown
`debit_amount`	Unknown
`description`	String
`ending_balance`	Unknown
`last_modified_date_time`	Unknown
`ledger_description`	String
`line_number`	Unknown
`period`	String
`ref_number`	String
`sub_account`	String
`tran_date`	Unknown

currency_rate

Column	Type	Keys
`id`	Unknown	PK
`from_currency_id`	String	FK
`to_currency_id`	String	FK
`effective_date`	Unknown
`mult_div`	String
`rate`	Unknown
`rate_reciprocal`	Unknown
`rate_type`	String

kit_assembly_allocation

Column	Type	Keys
`index`	Unknown	PK
`kit_assembly_id`	String	PKFK
`expiration_date`	Unknown
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`quantity`	Unknown
`uom`	String

kit_assembly_non_stock_component_line

Column	Type	Keys
`id`	String	PK
`kit_assembly_id`	String	PKFK
`allow_component_qty_variance`	Unknown
`component_qty`	Unknown
`description`	String
`line_nbr`	Unknown
`max_component_qty`	Unknown
`min_component_qty`	Unknown
`quantity`	Unknown
`reason_code`	String
`unit_cost`	Unknown
`uom`	String

kit_assembly_stock_component_line_allocation

Column	Type	Keys
`index`	Unknown	PK
`kit_assembly_id`	String	PKFK
`kit_assembly_stock_component_line_id`	String	PKFK
`expiration_date`	Unknown
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`quantity`	Unknown
`uom`	String

kit_assembly_stock_component_line

Column	Type	Keys
`id`	String	PK
`kit_assembly_id`	String	PKFK
`allow_component_qty_variance`	Unknown
`allow_component_substitution`	Unknown
`component_qty`	Unknown
`description`	String
`disassembly_coeff`	Unknown
`line_nbr`	Unknown
`location`	String
`max_component_qty`	Unknown
`min_component_qty`	Unknown
`quantity`	Unknown
`reason_code`	String
`unit_cost`	Unknown
`uo_m`	String

kit_assembly

Column	Type	Keys
`id`	String	PK
`warehouse`	String	FK
`created_date_time`	Unknown
`date`	Unknown
`description`	String
`hold`	Unknown
`item_id`	String
`last_modified_date_time`	Unknown
`location`	String
`post_period`	String
`quantity`	Unknown
`reason_code`	String
`revision`	String
`sales_order_link`	String
`status`	String
`timestamps`	String
`type`	String
`uo_m`	String

currency

Column	Type	Keys
`id`	String	PK
`decimal_precision`	Unknown
`description`	String
`is_base_currency`	Unknown
`is_used_for_accounting`	Unknown
`symbol`	String

attribute_detail

Column	Type	Keys
`id`	String	PK
`attribute_id`	String	PKFK
`description`	String
`disabled`	Unknown
`sort_order`	Unknown

attribute

Column	Type	Keys
`id`	String	PK
`control_type`	String
`created_date_time`	Unknown
`description`	String
`entry_mask`	String
`internal`	Unknown
`last_modified_date_time`	Unknown
`reg_exp`	String

journal_transaction_attachment

Column	Type	Keys
`id`	String	PK
`financial_period_id`	String	PKFK
`journal_transaction_id`	String	PKFK
`name`	String
`revision`	Unknown

journal_transaction_line_attachment

Column	Type	Keys
`id`	String	PK
`financial_period_id`	String	PKFK
`journal_transaction_id`	String	PKFK
`journal_transaction_line_number`	Unknown	PKFK
`name`	String
`revision`	Unknown

journal_transaction_line_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`financial_period_id`	String	PKFK
`journal_transaction_id`	String	PKFK
`journal_transaction_line_number`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

journal_transaction_line

Column	Type	Keys
`line_number`	Unknown	PK
`financial_period_id`	String	PKFK
`journal_transaction_id`	String	PKFK
`account_number`	String	FK
`inventory_number`	String	FK
`sub_account_id`	Unknown	FK
`branch`	String
`credit_amount`	Unknown
`credit_amount_in_currency`	Unknown
`customer_supplier`	String
`debit_amount`	Unknown
`debit_amount_in_currency`	Unknown
`description`	String
`module`	String
`note`	String
`project_description`	String
`project_id`	String
`project_task_description`	String
`project_task_id`	String
`quantity`	Unknown
`reference_number`	String
`transaction_description`	String
`transaction_type`	String
`uom`	String
`vat_code_description`	String
`vat_code_id`	String
`vat_description`	String
`vat_id`	String

journal_transaction

Column	Type	Keys
`id`	String	PK
`financial_period_id`	String	PKFK
`currency_id`	String	FK
`ledger_id`	String	FK
`auto_reversing`	Unknown
`branch`	String
`control_total`	Unknown
`control_total_in_currency`	Unknown
`create_vat_transaction`	Unknown
`description`	String
`exchange_rate`	Unknown
`hold`	Unknown
`last_modified_date_time`	Unknown
`ledger_description`	String
`module`	String
`original_batch_number`	String
`post_period`	String
`reversing_entry`	Unknown
`skip_vat_amount_validation`	Unknown
`status`	String
`transaction_code`	String
`transaction_code_description`	String
`transaction_date`	Unknown

ledger

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`balance_type`	String
`branch_accounting`	Unknown
`consol_branch_name`	String
`consol_branch_number`	String
`consolidation_source`	Unknown
`description`	String
`internal_id`	Unknown
`last_modified_date_time`	Unknown
`post_inter_company`	Unknown

organization_branch

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	String	PKFK
`name`	String
`number`	String

organization

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`ledger_id`	String	FK
`bank_settings_address_1`	String
`bank_settings_address_2`	String
`bank_settings_address_3`	String
`bank_settings_bba_n_2`	String
`bank_settings_bba_n_3`	String
`bank_settings_bban`	String
`bank_settings_bic`	String
`bank_settings_country`	String
`bank_settings_creditor_id`	String
`bank_settings_iban`	String
`bank_settings_name`	String
`base_currency`	String
`corporate_id`	String
`default_country_id`	String
`default_country_name`	String
`delivery_address_city`	String
`delivery_address_country_id`	String
`delivery_address_country_name`	String
`delivery_address_county_id`	String
`delivery_address_county_name`	String
`delivery_address_id`	Unknown
`delivery_address_line_1`	String
`delivery_address_line_2`	String
`delivery_address_line_3`	String
`delivery_address_postal_code`	String
`delivery_contact_attention`	String
`delivery_contact_email`	String
`delivery_contact_fax`	String
`delivery_contact_id`	Unknown
`delivery_contact_name`	String
`delivery_contact_phone_1`	String
`delivery_contact_phone_2`	String
`delivery_contact_web`	String
`file_tax_by_branches`	Unknown
`industry_code_description`	String
`industry_code_id`	String
`last_modified_date_time`	String
`main_address_city`	String
`main_address_country_id`	String
`main_address_country_name`	String
`main_address_county_id`	String
`main_address_county_name`	String
`main_address_id`	Unknown
`main_address_line_1`	String
`main_address_line_2`	String
`main_address_line_3`	String
`main_address_postal_code`	String
`main_contact_attention`	String
`main_contact_email`	String
`main_contact_fax`	String
`main_contact_id`	Unknown
`main_contact_name`	String
`main_contact_phone_1`	String
`main_contact_phone_2`	String
`main_contact_web`	String
`name`	String
`time_stamp`	Unknown
`type`	String
`vat_registration_id`	String
`vat_zone_default_tax_category_description`	String
`vat_zone_default_tax_category_number`	String
`vat_zone_default_vat_category`	String
`vat_zone_description`	String
`vat_zone_id`	String

sales_order_line_allocation

Column	Type	Keys
`inventory_id`	String	PK
`split_line_number`	Unknown	PK
`sales_order_id`	String	PKFK
`sales_order_line_id`	Unknown	PKFK
`allocated`	Unknown
`completed`	Unknown
`expiration_date`	Unknown
`lot_serial_number`	String
`purchase_order_number`	String
`purchase_receipt_number`	String
`quantity`	Unknown
`received_quantity`	Unknown
`ship_date`	Unknown
`shipment_number`	String
`shipped_quantity`	Unknown
`unit_of_measure`	String

sales_order_line_attachment

Column	Type	Keys
`id`	String	PK
`sales_order_id`	String	PKFK
`sales_order_line_id`	Unknown	PKFK
`name`	String
`revision`	Unknown

sales_order_line

Column	Type	Keys
`id`	Unknown	PK
`sales_order_id`	String	PKFK
`inventory_id`	String	FK
`supplier_id`	String	FK
`warehouse_id`	String	FK
`amount_not_invoiced`	Unknown
`auto_create_issue`	Unknown
`base_order_quantity`	Unknown
`billed_quantity`	Unknown
`commissionable`	Unknown
`completed`	Unknown
`description`	String
`discount_amount`	Unknown
`discount_code`	String
`discount_percent`	Unknown
`discount_sequence_id`	String
`discounted_unit_price`	Unknown
`excise_duty`	Unknown
`extended_price`	Unknown
`external_link`	String
`free_item`	Unknown
`has_manual_discount`	Unknown
`has_manual_price`	Unknown
`inventory_alternate_id`	String
`inventory_base_unit`	String
`inventory_description`	String
`invoice_line_number`	Unknown
`invoice_number`	String
`invoice_type`	String
`is_rot_rut_deductible`	Unknown
`kit_assembly_reference_number`	String
`line_total_before_discount`	Unknown
`line_type`	String
`note`	String
`open_line`	Unknown
`open_quantity`	Unknown
`operation`	String
`order_date`	Unknown
`overship_threshold`	Unknown
`project_task_id`	String
`purchase_order_number`	Json
`purchase_order_source`	String
`quantity`	Unknown
`quantity_on_shipment`	Unknown
`reason_code`	String
`replacement_unit_cost`	Unknown
`request_date`	Unknown
`rot_rut_deductible_amount`	Unknown
`rot_rut_item_type_description`	String
`rot_rut_item_type_id`	String
`rot_rut_work_type`	String
`sales_account_id`	String
`sales_person_description`	String
`sales_person_id`	String
`ship_date`	Unknown
`shipping_rule`	String
`sort_order`	Unknown
`supplier_price`	Unknown
`tax_category_id`	String
`undership_threshold`	Unknown
`unit_cost`	Unknown
`unit_of_measure`	String
`unit_price`	Unknown
`warehouse_location_description`	String
`warehouse_location_id`	String
`custom_field_`
`subaccount_`

sales_order_commission

Column	Type	Keys
`sales_person_id`	String	PK
`sales_order_id`	String	PKFK
`amount`	Unknown
`commissionable_amount`	Unknown
`percentage`	Unknown

sales_order_tax

Column	Type	Keys
`id`	String	PK
`sales_order_id`	String	PKFK
`amount`	Unknown
`exempt_tax`	Unknown
`include_in_taxable`	Unknown
`is_pending_tax`	Unknown
`is_reverse_tax`	Unknown
`is_statistical_tax`	Unknown
`rate`	Unknown
`taxable_amount`	Unknown
`type`	String

sales_order_shipment

Column	Type	Keys
`id`	String	PKFK
`sales_order_id`	String	PKFK
`date`	Unknown
`inventory_correction_document_type`	String
`inventory_correction_reference_id`	String
`inventory_document_type`	String
`inventory_reference_id`	String
`invoice_id`	String
`invoice_type`	String
`quantity`	Unknown
`shipment_number`	String
`status`	String
`volume`	Unknown
`weight`	Unknown

sales_order_discount

Column	Type	Keys
`id`	String	PK
`sales_order_id`	String	PKFK
`discount_amount`	Unknown
`discount_percent`	Unknown
`discount_sequence_id`	String
`discountable_amount`	Unknown
`discountable_quantity`	Unknown
`free_item_description`	String
`free_item_id`	String
`free_item_quantity`	Unknown
`is_manual`	Unknown
`manual_order_index`	Unknown
`skip_discount`	Unknown
`type`	String

sales_order_payment

Column	Type	Keys
`index`	Unknown	PK
`sales_order_id`	String	PKFK
`currency_id`	String	FK
`amount_applied_to_order`	Unknown
`balance`	Unknown
`billed_amount`	Unknown
`cash_account`	String
`document_type`	String
`payment_method`	String
`reference`	String
`reference_number`	String
`status`	String
`total_amount`	Unknown

sales_order_rot_rut_distribution

Column	Type	Keys
`line_id`	Unknown	PK
`sales_order_id`	String	PKFK
`amount`	Unknown
`extra`	Unknown
`personal_id`	String

sales_order_attachment

Column	Type	Keys
`id`	String	PK
`sales_order_id`	String	PKFK
`name`	String
`revision`	Unknown

sales_order

Column	Type	Keys
`id`	String	PK
`branch_id`	String	FK
`currency`	String	FK
`customer_id`	String	FK
`payment_settings_cash_account_id`	String	FK
`payment_settings_payment_method_id`	String	FK
`shipping_preferred_warehouse_id`	String	FK
`shipping_ship_via_id`	String	FK
`billing_address_city`	String
`billing_address_country_id`	String
`billing_address_country_name`	String
`billing_address_county_id`	String
`billing_address_county_name`	String
`billing_address_id`	Unknown
`billing_address_line_1`	String
`billing_address_line_2`	String
`billing_address_line_3`	String
`billing_address_overrides_default`	Unknown
`billing_address_postal_code`	String
`billing_contact_attention`	String
`billing_contact_email`	String
`billing_contact_fax`	String
`billing_contact_id`	Unknown
`billing_contact_name`	String
`billing_contact_overrides_default`	Unknown
`billing_contact_phone_1`	String
`billing_contact_phone_2`	String
`cancel_by`	Unknown
`cost_total`	Unknown
`cost_total_in_base_currency`	Unknown
`created_by`	String
`customer_order`	String
`customer_ref_no`	String
`date`	Unknown
`description`	String
`discount_total`	Unknown
`discount_total_in_base_currency`	Unknown
`emailed`	Unknown
`excise_duty_total`	Unknown
`excise_duty_total_in_base_currency`	Unknown
`financial_information_cash_discount_date`	Unknown
`financial_information_due_date`	Unknown
`financial_information_invoice_date`	Unknown
`financial_information_invoice_id`	String
`financial_information_invoice_separately`	Unknown
`financial_information_post_period`	String
`financial_information_term_description`	String
`financial_information_term_id`	String
`freight_amount`	Unknown
`freight_amount_in_base_currency`	Unknown
`freight_cost`	Unknown
`freight_cost_in_base_currency`	Unknown
`freight_premium_amount`	Unknown
`freight_premium_amount_in_base_currency`	Unknown
`freight_tax_category_id`	String
`freight_total`	Unknown
`freight_total_in_base_currency`	Unknown
`freight_volume`	Unknown
`freight_weight`	Unknown
`is_rot_rut_deductible`	Unknown
`last_modified`	Unknown
`location`	String
`note`	String
`order_total`	Unknown
`order_total_in_base_currency`	Unknown
`origin_link_additional_prop_1_href`	String
`origin_link_additional_prop_2_href`	String
`origin_link_additional_prop_3_href`	String
`origin_order_id`	String
`origin_order_type`	String
`original_order_id`	String
`original_order_type`	String
`owner_id`	String
`owner_internal_id`	String
`parent_customer_id`	String
`parent_customer_internal_id`	Unknown
`parent_customer_name`	String
`payment_settings_payment_method_description`	String
`payment_settings_payment_reference`	String
`payment_total`	Unknown
`payment_total_in_base_currency`	Unknown
`print_description_on_invoice`	Unknown
`print_note_on_external_document`	Unknown
`print_note_on_internal_document`	Unknown
`project_description`	String
`project_id`	String
`project_internal_id`	Unknown
`request_on`	Unknown
`rot_rut_apartment`	String
`rot_rut_distributed_automatically`	Unknown
`rot_rut_estate`	String
`rot_rut_material_cost_amount`	Unknown
`rot_rut_organization_number`	String
`rot_rut_other_cost_amount`	Unknown
`rot_rut_total_deductable_amount`	Unknown
`rot_rut_type`	String
`rot_rut_work_price_amount`	Unknown
`sales_person_description`	String
`sales_person_id`	String
`shipping_address_city`	String
`shipping_address_country_id`	String
`shipping_address_country_name`	String
`shipping_address_county_id`	String
`shipping_address_county_name`	String
`shipping_address_id`	Unknown
`shipping_address_line_1`	String
`shipping_address_line_2`	String
`shipping_address_line_3`	String
`shipping_address_override_default`	Unknown
`shipping_address_postal_code`	String
`shipping_contact_attention`	String
`shipping_contact_email`	String
`shipping_contact_fax`	String
`shipping_contact_id`	Unknown
`shipping_contact_name`	String
`shipping_contact_overrides_default`	Unknown
`shipping_contact_phone_1`	String
`shipping_contact_phone_2`	String
`shipping_fob_point_description`	String
`shipping_fob_point_id`	String
`shipping_insurance`	Unknown
`shipping_intrastat_transaction_type_description`	String
`shipping_intrastat_transaction_type_id`	Unknown
`shipping_preferred_warehouse_description`	String
`shipping_priority`	Unknown
`shipping_residential_delivery`	Unknown
`shipping_rule`	String
`shipping_saturday_delivery`	Unknown
`shipping_scheduled_date`	Unknown
`shipping_ship_separately`	Unknown
`shipping_ship_via_description`	String
`shipping_term_description`	String
`shipping_term_id`	String
`shipping_zone_description`	String
`shipping_zone_id`	String
`status`	String
`status_details_cancelled`	Unknown
`status_details_description`	String
`status_details_hold`	Unknown
`tax_exempt_total`	Unknown
`tax_exempt_total_in_base_currency`	Unknown
`tax_total`	Unknown
`tax_total_in_base_currency`	Unknown
`taxable_total`	Unknown
`taxable_total_in_base_currency`	Unknown
`type`	String
`unbilled_amount`	Unknown
`unbilled_amount_in_base_currency`	Unknown
`unshipped_amount`	Unknown
`unshipped_amount_in_base_currency`	Unknown
`use_replacement_cost_for_margin_and_profit`	Unknown
`version`	String
`custom_field_`

supplier_invoice_tax_detail_line

Column	Type	Keys
`id`	String	PK
`supplier_invoice_fivetran_id`	Unknown	PKFK
`record_id`	Unknown
`taxable_amount`	Unknown
`vat_amount`	Unknown
`vat_id_description`	String
`vat_id_number`	String
`vat_rate`	Unknown

supplier_invoice_line_attachment

Column	Type	Keys
`id`	String	PK
`supplier_invoice_fivetran_id`	Unknown	PKFK
`supplier_invoice_line_index`	Unknown	PKFK
`name`	String
`revision`	Unknown

supplier_invoice_line_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`supplier_invoice_fivetran_id`	Unknown	PKFK
`supplier_invoice_line_index`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

supplier_invoice_line

Column	Type	Keys
`index`	Unknown	PK
`supplier_invoice_fivetran_id`	Unknown	PKFK
`account_number`	String	FK
`branch_number`	String	FK
`inventory_number`	String	FK
`sub_account_id`	Unknown	FK
`account_external_code_1`	String
`account_external_code_2`	String
`account_type`	String
`cost`	Unknown
`cost_in_currency`	Unknown
`cury_retainage_amt`	Unknown
`deferral_code`	String
`deferral_schedule`	Unknown
`deferral_schedule_nbr`	String
`discount_amount`	Unknown
`discount_amount_in_currency`	Unknown
`discount_percent`	Unknown
`discount_unit_cost`	Unknown
`discount_unit_cost_in_currency`	Unknown
`external_inventory_id`	String
`line_number`	Unknown
`manual_discount`	Unknown
`project_description`	String
`project_id`	String
`project_task_description`	String
`project_task_id`	String
`quantity`	Unknown
`retainage_pct`	Unknown
`split_hierarchy`	String
`stock_item`	Unknown
`term_end_date`	Unknown
`term_start_date`	Unknown
`transaction_description`	String
`unit_cost`	Unknown
`unit_cost_in_currency`	Unknown
`uom`	String
`vat_code_description`	String
`vat_code_id`	String

supplier_invoice_attachment

Column	Type	Keys
`id`	String	PK
`supplier_invoice_fivetran_id`	Unknown	PKFK
`name`	String
`revision`	Unknown

supplier_invoice

Column	Type	Keys
`_fivetran_id`	String	PK
`branch_number`	String	FK
`cash_account`	String	FK
`closed_financial_period`	String	FK
`currency_id`	String	FK
`financial_period`	String	FK
`payment_method_id`	String	FK
`supplier_number`	String	FK
`amount`	Unknown
`approval_detail_attachment_id`	String
`approval_detail_comment`	String
`approval_status`	String
`balance`	Unknown
`balance_in_currency`	Unknown
`buyer_reference`	String
`cash_discount`	Unknown
`cash_discount_date`	Unknown
`cash_discount_in_currency`	Unknown
`created_date_time`	Unknown
`credit_terms_description`	String
`credit_terms_id`	String
`cury_retainage_total`	Unknown
`cury_retainage_unreleased_amt`	Unknown
`date`	Unknown
`description`	String
`detail_total`	Unknown
`detail_total_in_currency`	Unknown
`document_type`	String
`document_version_number`	Unknown
`due_date`	Unknown
`exchange_rate`	Unknown
`hold`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`note`	String
`orig_invoice_date`	Unknown
`pay_date`	Unknown
`pay_selected`	Unknown
`payment_message`	String
`payment_ref_no`	String
`post_period`	String
`reference_number`	String
`retainage_apply`	Unknown
`rounding_diff`	Unknown
`rounding_diff_in_currency`	Unknown
`status`	String
`supplier_reference`	String
`supplier_tax_zone_default_tax_category_description`	String
`supplier_tax_zone_default_tax_category_number`	String
`supplier_tax_zone_default_vat_category`	String
`supplier_tax_zone_description`	String
`supplier_tax_zone_id`	String
`tax_calculation_mode`	String
`time_stamp`	String
`vat_amount`	Unknown
`vat_exempt_total`	Unknown
`vat_exempt_total_in_currency`	Unknown
`vat_taxable_total`	Unknown
`vat_taxable_total_in_currency`	Unknown
`vat_total`	Unknown
`vat_total_in_currency`	Unknown
`withholding_tax`	Unknown
`withholding_tax_in_currency`	Unknown

customer_debit_note_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_debit_note_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_debit_note_attachment

Column	Type	Keys
`id`	String	PK
`customer_debit_note_id`	String	PKFK
`name`	String
`revision`	Unknown

customer_debit_note_tax_detail

Column	Type	Keys
`id`	String	PK
`customer_debit_note_id`	String	PKFK
`record_id`	Unknown
`taxable_amount`	Unknown
`vat_amount`	Unknown
`vat_description`	String
`vat_number`	String
`vat_rate`	Unknown

customer_debit_note_line_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_debit_note_id`	String	PKFK
`customer_debit_note_line_index`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

customer_debit_note_line_attachment

Column	Type	Keys
`id`	String	PK
`customer_debit_note_id`	String	PKFK
`customer_debit_note_line_index`	Unknown	PKFK
`name`	String
`revision`	Unknown

customer_debit_note_line

Column	Type	Keys
`index`	Unknown	PK
`customer_debit_note_id`	String	PKFK
`account_number`	String	FK
`branch_number`	String	FK
`sub_account_id`	Unknown	FK
`account_external_code_1`	String
`account_external_code_2`	String
`amount`	Unknown
`amount_in_currency`	Unknown
`cost`	Unknown
`deductable_amount`	Unknown
`deferral_code`	String
`deferral_schedule`	Unknown
`description`	String
`discount_amount`	Unknown
`discount_amount_in_currency`	Unknown
`discount_code`	String
`discount_percent`	Unknown
`external_link`	String
`inventory_number`	String
`is_rot_rut_deductible`	Unknown
`item_type`	String
`line_number`	Unknown
`manual_amount`	Unknown
`manual_amount_in_currency`	Unknown
`manual_discount`	Unknown
`note`	String
`project_task_description`	String
`project_task_id`	String
`quantity`	Unknown
`s_0_order_nbr`	String
`seller_description`	String
`seller_id`	String
`so_order_type`	String
`so_shipment_nbr`	String
`term_end_date`	Unknown
`term_start_date`	Unknown
`type_of_workdescription`	String
`type_of_workrut_rot_type`	String
`type_of_workxml_tag`	String
`unit_price`	Unknown
`unit_price_in_currency`	Unknown
`uom`	String
`vat_code_description`	String
`vat_code_id`	String

customer_debit_note_application

Column	Type	Keys
`index`	Unknown	PK
`customer_debit_note_id`	String	PKFK
`amount_paid`	Unknown
`application_date`	Unknown
`application_period`	String
`balance`	Unknown
`cash_discount_taken`	Unknown
`customer_cd`	String
`doc_type`	String
`hold`	Unknown
`invoice_text`	String
`payment_ref`	String
`pending_ppd`	Unknown
`ppd_cr_memo_ref_nbr`	String
`ref_nbr`	String
`released`	Unknown
`status`	String
`unit_price_in_currency`	Unknown
`voided`	Unknown

customer_debit_note

Column	Type	Keys
`id`	String	PK
`account_number`	String	FK
`branch_number`	String	FK
`cash_account`	String	FK
`closed_financial_period`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`financial_period`	String	FK
`payment_method_id`	String	FK
`sub_account_id`	Unknown	FK
`account_external_code_1`	String
`account_external_code_2`	String
`amount`	Unknown
`amount_in_currency`	Unknown
`balance`	Unknown
`balance_in_currency`	Unknown
`cash_discount`	Unknown
`cash_discount_in_currency`	Unknown
`cash_discount_rate`	Unknown
`child_record_name`	String
`child_record_number`	String
`contact_id`	Unknown
`contact_name`	String
`created_date_time`	Unknown
`credit_terms_description`	String
`credit_terms_id`	String
`customer_project`	String
`customer_reference`	String
`customer_vat_zone_description`	String
`customer_vat_zone_id`	String
`detail_total`	Unknown
`detail_total_in_currency`	Unknown
`document_date`	Unknown
`document_due_date`	Unknown
`document_type`	String
`dont_email`	Unknown
`dont_print`	Unknown
`dunning_letter_date`	Unknown
`dunning_letter_level`	Unknown
`exchange_rate`	Unknown
`external_reference`	String
`hold`	Unknown
`invoice_address_city`	String
`invoice_address_country_id`	String
`invoice_address_country_name`	String
`invoice_address_county_id`	String
`invoice_address_county_name`	String
`invoice_address_id`	Unknown
`invoice_address_line_1`	String
`invoice_address_line_2`	String
`invoice_address_line_3`	String
`invoice_address_override_address`	Unknown
`invoice_address_postal_code`	String
`invoice_contact_attention`	String
`invoice_contact_business_name`	Unknown
`invoice_contact_email`	String
`invoice_contact_id`	Unknown
`invoice_contact_override_contact`	Unknown
`invoice_contact_phone_1`	String
`invoice_contact_web`	String
`invoice_text`	Unknown
`is_rot_rut_deductible`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`note`	String
`orig_invoice_date`	Unknown
`payment_reference`	String
`post_period`	String
`project_description`	String
`project_id`	String
`revoked`	Unknown
`rounding_diff`	Unknown
`sales_person_description`	String
`sales_person_id`	String
`send_to_auto_invoice`	Unknown
`status`	String
`vat_exempt_total`	Unknown
`vat_exempt_total_in_currency`	Unknown
`vat_taotal`	Unknown
`vat_taxable_total`	Unknown
`vat_taxable_total_in_currency`	Unknown
`vat_total_in_currency`	Unknown

purchase_receipt_line_allocation

Column	Type	Keys
`index`	Unknown	PK
`purchase_receipt_id`	String	PKFK
`purchase_receipt_line_index`	Unknown	PKFK
`description`	String
`expiration_date`	Unknown
`item_id`	String
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`quantity`	Unknown
`uom`	String

purchase_receipt_line

Column	Type	Keys
`index`	Unknown	PK
`purchase_receipt_id`	String	PKFK
`account_number`	String	FK
`actual_account_number`	String	FK
`branch_number`	String	FK
`inventory_number`	String	FK
`warehouse_id`	String	FK
`account_description`	String
`actual_account_description`	String
`actual_account_type`	String
`actual_sub_description`	String
`actual_sub_id`	String
`amount`	Unknown
`complete_po_line`	Unknown
`discount_amount`	Unknown
`discount_code_description`	String
`discount_code_number`	String
`discount_percent`	Unknown
`expiration_date`	Unknown
`ext_cost`	Unknown
`inventory_description`	String
`location_country_id`	Unknown
`location_id`	String
`location_location`	Unknown
`location_name`	String
`lot_serial_number`	String
`manual_discount`	Unknown
`nbr`	Unknown
`open_qty`	Unknown
`order_qty`	Unknown
`po_order_line_nbr`	Unknown
`po_order_nbr`	String
`po_order_type`	String
`project_description`	String
`project_id`	String
`project_task_description`	Unknown
`project_task_id`	String
`project_task_location`	Unknown
`receipt_qty`	Unknown
`sub_description`	String
`sub_id`	String
`tax_category_description`	String
`tax_category_number`	String
`transaction_description`	String
`transfer_order_line_nbr`	Unknown
`transfer_order_nbr`	String
`transfer_order_type`	String
`type`	String
`unit_cost`	Unknown
`uom`	String

purchase_receipt_landed_cost

Column	Type	Keys
`index`	Unknown	PK
`purchase_receipt_id`	String	PKFK
`internal_id`	Unknown	FK
`amount`	Unknown
`ap_bill_date`	Unknown
`ap_doc_type`	String
`ap_ref_nbr`	String
`currency`	String
`description`	String
`in_doc_type`	String
`in_ref_nbr`	String
`inventory_description`	String
`inventory_number`	String
`landed_cost_code`	String
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`postpone_purchase_invoice_creation`	Unknown
`purchase_invoice_nbr`	String
`tax_category_description`	String
`tax_category_number`	String
`terms_description`	String
`terms_id`	String

purchase_receipt

Column	Type	Keys
`id`	String	PK
`branch_number`	String	FK
`internal_id`	Unknown	FK
`warehouse_id`	String	FK
`control_qty`	Unknown
`control_total`	Unknown
`create_bill`	Unknown
`currency`	String
`date`	Unknown
`exchange_rate`	Unknown
`hold`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`post_period`	String
`receipt_type`	String
`status`	String
`supplier_ref`	String
`total_amt`	Unknown
`total_qty`	Unknown
`vat_exempt_total`	Unknown
`vat_taxable_total`	Unknown

customer_payment_line

Column	Type	Keys
`index`	Unknown	PK
`customer_payment_id`	String	PKFK
`currency_id`	String	FK
`amount_paid`	Unknown
`balance`	Unknown
`balance_write_off`	Unknown
`cash_discount_balance`	Unknown
`cash_discount_date`	Unknown
`cash_discount_taken`	Unknown
`cross_rate`	Unknown
`customer_order`	String
`date`	Unknown
`description`	String
`document_type`	String
`due_date`	Unknown
`post_period`	String
`ref_nbr`	String
`write_off_reason_code_description`	String
`write_off_reason_code_id`	String

customer_payment_order_to_apply

Column	Type	Keys
`index`	Unknown	PK
`customer_payment_id`	String	PKFK
`currency_id`	String	FK
`applied_to_order`	Unknown
`balance`	Unknown
`cash_discount_date`	Unknown
`date`	Unknown
`description`	String
`due_date`	Unknown
`invoice_date`	Unknown
`invoice_nbr`	String
`order_no`	String
`order_total`	Unknown
`order_type`	String
`status`	String
`transferred_to_invoice`	Unknown

customer_payment

Column	Type	Keys
`id`	String	PK
`cash_account`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`payment_method_id`	String	FK
`application_date`	Unknown
`application_period`	String
`applied_to_document`	Unknown
`applied_to_order`	Unknown
`available_balance`	Unknown
`available_balance_in_currency`	Unknown
`branch`	String
`deducted_charges`	Unknown
`finance_charges`	Unknown
`hold`	Unknown
`invoice_text`	String
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`payment_amount`	Unknown
`payment_amount_in_currency`	Unknown
`payment_date`	Unknown
`payment_ref`	String
`status`	String
`type`	String
`write_off_amount`	Unknown

general_ledger_balance

Column	Type	Keys
`_fivetran_id`	String	PK
`account_number`	String	FK
`branch_number`	String	FK
`currency_id`	String	FK
`financial_period`	String	FK
`ledger_id`	String	FK
`sub_account_id`	String	FK
`account_external_code_1`	String
`account_external_code_1_info_description`	String
`account_external_code_1_info_number`	String
`account_external_code_2`	String
`account_external_code_2_info_description`	String
`account_external_code_2_info_number`	String
`account_gl_consol_account_cd`	String
`account_type`	String
`balance_type`	String
`beginning_balance`	Unknown
`beginning_balance_in_currency`	Unknown
`last_modified_date_time`	Unknown
`period_to_date_credit`	Unknown
`period_to_date_credit_in_currency`	Unknown
`period_to_date_debit`	Unknown
`period_to_date_debit_in_currency`	Unknown
`sub_account_cd`	String
`year_closed`	Unknown
`year_to_date_balance`	Unknown
`year_to_date_balance_in_currency`	Unknown

supplier_payment_line

Column	Type	Keys
`index`	Unknown	PK
`supplier_payment_id`	String	PKFK
`amount_paid`	Unknown
`application_period`	String
`balance`	Unknown
`batch_number`	String
`branch`	String
`cash_discount_balance`	Unknown
`cash_discount_date`	Unknown
`cash_discount_taken`	Unknown
`currency`	String
`date`	Unknown
`description`	String
`doc_type`	String
`due_date`	Unknown
`invoice_ref_nbr`	String
`post_period`	String
`supplier_ref`	String
`withholding_tax`	Unknown

supplier_payment

Column	Type	Keys
`id`	String	PK
`cash_account`	String	FK
`currency_id`	String	FK
`internal_id`	Unknown	FK
`payment_method`	String	FK
`application_date`	Unknown
`application_period`	String
`applied_amount`	Unknown
`branch`	String
`description`	String
`document_type`	String
`finance_charges`	Unknown
`hold`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`payment_amount`	Unknown
`payment_ref`	String
`released`	Unknown
`status`	String
`type`	String
`unapplied_balance`	Unknown

payment_method_detail

Column	Type	Keys
`id`	String	PK
`payment_method_id`	String	PKFK
`banking_detail_type`	String
`description`	String

payment_method

Column	Type	Keys
`id`	String	PK
`active`	Unknown
`description`	String
`means_of_payment`	String
`use_in_ap`	Unknown

shipment_detail_line_allocation

Column	Type	Keys
`index`	Unknown	PK
`shipment_detail_line_index`	Unknown	PKFK
`shipment_id`	String	PKFK
`description`	String
`expiration_date`	Unknown
`item_id`	String
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`quantity`	Unknown
`uom`	String

shipment_detail_line

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	String	PKFK
`warehouse_id`	String	FK
`alternate_id`	String
`description`	String
`expiration_date`	Unknown
`external_link`	String
`free_item`	Unknown
`inventory_number`	String
`line_number`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_nbr`	String
`note`	String
`open_qty`	Unknown
`order_line_nbr`	Unknown
`order_nbr`	String
`order_type`	String
`ordered_qty`	Unknown
`reason_code`	String
`shipped_qty`	Unknown
`uom`	String

shipment_package_line

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	String	PKFK
`box_id`	String
`cash_amount`	Unknown
`confirmed`	Unknown
`custom_ref_nbr_1`	String
`custom_ref_nbr_2`	String
`declared_value`	Unknown
`description`	String
`line_number`	Unknown
`tracking_number`	String
`type`	String
`uom`	String
`volume`	Unknown
`volume_uom`	String
`weight`	Unknown

shipment_order_line

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	String	PKFK
`inventory_doc_type`	String
`inventory_ref_nbr`	String
`invoice_nbr`	String
`invoice_type`	String
`note`	String
`order_nbr`	String
`order_type`	String
`shipped_qty`	Unknown
`shipped_volume`	Unknown
`shipped_weight`	Unknown

shipment

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`customer_id`	String	FK
`from_warehouse_id`	String	FK
`to_warehouse_id`	String	FK
`container`	Unknown
`control_quantity`	Unknown
`date`	Unknown
`delivery_address_city`	String
`delivery_address_country`	Unknown
`delivery_address_country_id`	String
`delivery_address_country_name`	String
`delivery_address_county_id`	String
`delivery_address_county_name`	String
`delivery_address_id`	Unknown
`delivery_address_line_1`	String
`delivery_address_line_2`	String
`delivery_address_line_3`	String
`delivery_address_override_address`	Unknown
`delivery_address_postal_code`	String
`delivery_contact_attention`	String
`delivery_contact_email`	String
`delivery_contact_fax`	String
`delivery_contact_id`	Unknown
`delivery_contact_name`	String
`delivery_contact_override_contact`	Unknown
`delivery_contact_phone_1`	String
`delivery_contact_phone_2`	String
`delivery_contact_web`	String
`fob_point_description`	String
`fob_point_id`	String
`freight_amt`	Unknown
`freight_cost`	Unknown
`hold`	Unknown
`insurance`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`mode_of_transport_description`	String
`mode_of_transport_id`	Unknown
`note`	String
`operation`	String
`owner_id`	String
`owner_name`	String
`packages`	Unknown
`packages_volume`	Unknown
`packages_weight`	Unknown
`residential_delivery`	Unknown
`saturday_delivery`	Unknown
`ship_via_description`	String
`ship_via_id`	String
`shipped_quantity`	Unknown
`shipped_volume`	Unknown
`shipped_weight`	Unknown
`shipping_terms_description`	String
`shipping_terms_id`	String
`shipping_zone_description`	String
`shipping_zone_id`	String
`status`	String
`transaction_type_description`	String
`transaction_type_id`	Unknown
`type`	String
`use_customer_account`	Unknown

cash_account_entry_type

Column	Type	Keys
`id`	String	PK
`number`	String	PKFK
`business_account_description`	String
`business_account_external_code_1`	String
`business_account_external_code_2`	String
`business_account_number`	String
`business_account_type`	String
`default_offset_account_branch_name`	String
`default_offset_account_branch_number`	String
`default_offset_account_description`	String
`default_offset_account_external_code_1`	String
`default_offset_account_external_code_2`	String
`default_offset_account_number`	String
`default_offset_account_type`	String
`default_offset_sub_account_description`	String
`default_offset_sub_account_id`	String
`description`	String
`disable_receipt`	String
`last_modified_date_time`	Unknown
`module`	String
`offset_account_branch_name`	String
`offset_account_branch_number`	String
`offset_account_override_description`	String
`offset_account_override_external_code_1`	String
`offset_account_override_external_code_2`	String
`offset_account_override_number`	String
`offset_account_override_type`	String
`offset_sub_account_override_description`	String
`offset_sub_account_override_id`	String
`reclasification_account_description`	String
`reclasification_account_external_code_1`	String
`reclasification_account_external_code_2`	String
`reclasification_account_number`	String
`reclasification_account_override_description`	String
`reclasification_account_override_external_code_1`	String
`reclasification_account_override_external_code_2`	String
`reclasification_account_override_number`	String
`reclasification_account_override_type`	String
`reclasification_account_type`	String
`tax_calculation_mode`	String
`use_for_payments_reclasification`	Unknown
`vat_zone_default_tax_category_description`	String
`vat_zone_default_tax_category_number`	String
`vat_zone_default_vat_category`	String
`vat_zone_description`	String
`vat_zone_id`	String

cash_account

Column	Type	Keys
`number`	String	PK
`currency_id`	String	FK
`description`	String
`last_modified_date_time`	Unknown

customer_credit_note_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_credit_note_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_credit_note_attachment

Column	Type	Keys
`id`	String	PK
`customer_credit_note_id`	String	PKFK
`name`	String
`revision`	Unknown

customer_credit_note_tax_detail

Column	Type	Keys
`id`	String	PK
`customer_credit_note_id`	String	PKFK
`record_id`	Unknown
`taxable_amount`	Unknown
`vat_amount`	Unknown
`vat_description`	String
`vat_number`	String
`vat_rate`	Unknown

customer_credit_note_line_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_credit_note_id`	String	PKFK
`customer_credit_note_line_index`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

customer_credit_note_line_attachment

Column	Type	Keys
`id`	String	PK
`customer_credit_note_id`	String	PKFK
`customer_credit_note_line_index`	Unknown	PKFK
`name`	String
`revision`	Unknown

customer_credit_note_line

Column	Type	Keys
`index`	Unknown	PK
`customer_credit_note_id`	String	PKFK
`account_number`	String	FK
`branch_number`	String	FK
`sub_account_id`	Unknown	FK
`account_external_code_1`	String
`account_external_code_2`	String
`amount`	Unknown
`amount_in_currency`	Unknown
`cost`	Unknown
`deductable_amount`	Unknown
`deferral_code`	String
`deferral_schedule`	Unknown
`description`	String
`discount_amount`	Unknown
`discount_amount_in_currency`	Unknown
`discount_code`	String
`discount_percent`	Unknown
`external_link`	String
`inventory_number`	String
`is_rot_rut_deductible`	Unknown
`item_type`	String
`line_number`	Unknown
`manual_amount`	Unknown
`manual_amount_in_currency`	Unknown
`manual_discount`	Unknown
`note`	String
`project_task_description`	String
`project_task_id`	String
`quantity`	Unknown
`s_0_order_nbr`	String
`seller_description`	String
`seller_id`	String
`so_order_type`	String
`so_shipment_nbr`	String
`term_end_date`	Unknown
`term_start_date`	Unknown
`type_of_workdescription`	String
`type_of_workrut_rot_type`	Unknown
`type_of_workxml_tag`	String
`unit_price`	Unknown
`unit_price_in_currency`	Unknown
`uom`	String
`vat_code_description`	String
`vat_code_id`	String

customer_credit_note_application

Column	Type	Keys
`index`	Unknown	PK
`customer_credit_note_id`	String	PKFK
`amount_paid`	Unknown
`application_date`	Unknown
`application_period`	String
`balance`	Unknown
`cash_discount_taken`	Unknown
`customer_cd`	String
`doc_type`	String
`hold`	Unknown
`invoice_text`	String
`payment_ref`	String
`pending_ppd`	Unknown
`ppd_cr_memo_ref_nbr`	String
`ref_nbr`	String
`released`	Unknown
`status`	String
`unit_price_in_currency`	Unknown
`voided`	Unknown

customer_credit_note

Column	Type	Keys
`id`	String	PK
`account_number`	String	FK
`branch_number`	String	FK
`cash_account`	String	FK
`closed_financial_period`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`financial_period`	String	FK
`payment_method_id`	String	FK
`sub_account_id`	Unknown	FK
`account_external_code_1`	String
`account_external_code_2`	String
`amount`	Unknown
`amount_in_currency`	Unknown
`balance`	Unknown
`balance_in_currency`	Unknown
`cash_discount`	Unknown
`cash_discount_in_currency`	Unknown
`cash_discount_rate`	Unknown
`child_record_name`	String
`child_record_number`	String
`contact_id`	Unknown
`contact_name`	String
`created_date_time`	Unknown
`credit_terms_description`	String
`credit_terms_id`	String
`customer_project`	String
`customer_reference`	String
`customer_vat_zone_description`	String
`customer_vat_zone_id`	String
`detail_total`	Unknown
`detail_total_in_currency`	Unknown
`document_date`	Unknown
`document_due_date`	Unknown
`document_type`	String
`dont_email`	Unknown
`dont_print`	Unknown
`dunning_letter_date`	Unknown
`dunning_letter_level`	Unknown
`exchange_rate`	Unknown
`external_reference`	String
`hold`	Unknown
`invoice_address_city`	String
`invoice_address_country_id`	String
`invoice_address_country_name`	String
`invoice_address_county_id`	String
`invoice_address_county_name`	String
`invoice_address_id`	Unknown
`invoice_address_line_1`	String
`invoice_address_line_2`	String
`invoice_address_line_3`	String
`invoice_address_override_address`	Unknown
`invoice_address_postal_code`	String
`invoice_contact_attention`	String
`invoice_contact_business_name`	Unknown
`invoice_contact_email`	String
`invoice_contact_id`	Unknown
`invoice_contact_override_contact`	Unknown
`invoice_contact_phone_1`	String
`invoice_contact_web`	String
`invoice_text`	String
`is_rot_rut_deductible`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`note`	String
`orig_invoice_date`	Unknown
`payment_reference`	String
`post_period`	String
`project_description`	String
`project_id`	String
`revoked`	Unknown
`rounding_diff`	Unknown
`sales_person_description`	String
`sales_person_id`	String
`send_to_auto_invoice`	Unknown
`status`	String
`vat_exempt_total`	Unknown
`vat_exempt_total_in_currency`	Unknown
`vat_taotal`	Unknown
`vat_taxable_total`	Unknown
`vat_taxable_total_in_currency`	Unknown
`vat_total_in_currency`	Unknown

sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`sub_account_id`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

sub_account

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`description`	String
`last_modified_date_time`	Unknown
`number`	String

inventory_attachment

Column	Type	Keys
`id`	String	PK
`inventory_id`	String	PKFK
`name`	String
`revision`	Unknown

inventory_supplier_detail

Column	Type	Keys
`inventory_id`	String	PKFK
`supplier_id`	String	PKFK
`currency_id`	String	FK
`active`	Unknown
`eoq`	Unknown
`is_default`	Unknown
`item_id`	String
`last_supplier_price`	Unknown
`lead_time`	Unknown
`location`	String
`lot_size`	Unknown
`max_order_qty`	Unknown
`min_order_freq`	Unknown
`min_order_qty`	Unknown
`override`	Unknown
`purchase_unit`	String
`shipment_lead_time`	Unknown
`warehouse`	String

inventory_sale_category

Column	Type	Keys
`id`	Unknown	PK
`inventory_id`	String	PKFK
`description`	String

inventory_unit_attribute_detail

Column	Type	Keys
`id`	String	PK
`inventory_id`	String	PKFK
`inventory_unit_attribute_id`	String	PKFK
`inventory_unit_index`	Unknown	PKFK
`description`	String

inventory_unit_attribute

Column	Type	Keys
`id`	String	PK
`inventory_id`	String	PKFK
`inventory_unit_index`	Unknown	PKFK
`default_value`	String
`description`	String
`required`	Unknown
`sort_order`	Unknown
`type`	String

inventory_unit

Column	Type	Keys
`index`	Unknown	PK
`inventory_id`	String	PKFK
`from_unit`	String
`item_class_description`	String
`item_class_id`	String
`item_class_type`	String
`price_adjustment_multiplier`	Unknown
`record_id`	Unknown
`sample_to_unit`	String
`to_unit`	String
`type`	Unknown
`unit_mult_div`	String
`unit_rate`	Unknown

inventory_warehouse_detail

Column	Type	Keys
`index`	Unknown	PK
`inventory_id`	String	PKFK
`warehouse`	String	FK
`available`	Unknown
`available_for_shipment`	Unknown
`is_default`	Unknown
`last_modified_date_time`	Unknown
`quantity_on_hand`	Unknown

inventory_attribute

Column	Type	Keys
`id`	String	PK
`inventory_id`	String	PKFK
`description`	String
`value`	String

inventory_item_class_attribute_detail

Column	Type	Keys
`id`	String	PK
`inventory_id`	String	PKFK
`inventory_item_class_attribute_id`	String	PKFK
`description`	String

inventory_item_class_attribute

Column	Type	Keys
`id`	String	PKFK
`inventory_id`	String	PKFK
`default_value`	String
`description`	String
`required`	Unknown
`sort_order`	Unknown
`type`	String

inventory_cross_reference

Column	Type	Keys
`index`	Unknown	PK
`inventory_id`	String	PKFK
`alternate_id`	String
`alternate_type`	String
`b_account_internal_id`	Unknown
`b_account_name`	String
`b_account_number`	String
`description`	String
`timestamps`	String
`uom`	String

inventory

Column	Type	Keys
`id`	String	PK
`account_information_cogs_sub_account_id`	String	FK
`account_information_expense_sub_account_id`	String	FK
`account_information_sales_sub_account_id`	String	FK
`default_warehouse_id`	String	FK
`account_information_cogs_account_description`	String
`account_information_cogs_account_number`	String
`account_information_cogs_account_type`	String
`account_information_expense_account_description`	String
`account_information_expense_account_number`	String
`account_information_expense_account_type`	String
`account_information_expense_accrual_account_description`	String
`account_information_expense_accrual_account_number`	String
`account_information_expense_accrual_account_type`	String
`account_information_expense_eu_account_description`	String
`account_information_expense_eu_account_number`	String
`account_information_expense_eu_account_type`	String
`account_information_expense_import_account_description`	String
`account_information_expense_import_account_number`	String
`account_information_expense_import_account_type`	String
`account_information_expense_non_taxable_account_description`	String
`account_information_expense_non_taxable_account_number`	String
`account_information_expense_non_taxable_account_type`	String
`account_information_inventory_account_description`	String
`account_information_inventory_account_number`	String
`account_information_inventory_account_type`	String
`account_information_sales_account_description`	String
`account_information_sales_account_number`	String
`account_information_sales_account_type`	String
`account_information_sales_eu_account_description`	String
`account_information_sales_eu_account_number`	String
`account_information_sales_eu_account_type`	String
`account_information_sales_export_account_description`	String
`account_information_sales_export_account_number`	String
`account_information_sales_export_account_type`	String
`account_information_sales_non_taxable_account_description`	String
`account_information_sales_non_taxable_account_number`	String
`account_information_sales_non_taxable_account_type`	String
`base_unit`	String
`body`	String
`cost_price_statistics_average_cost`	Unknown
`cost_price_statistics_last_cost`	Unknown
`cost_price_statistics_max_cost`	Unknown
`cost_price_statistics_min_cost`	Unknown
`current_cost`	Unknown
`default_issue_from_description`	String
`default_issue_from_id`	String
`default_price`	Unknown
`default_receipt_to_description`	String
`default_receipt_to_id`	String
`description`	String
`effective_date`	Unknown
`intrastat_cn_8`	String
`intrastat_country_of_origin`	String
`intrastat_supplementary_measure_unit`	String
`item_class_description`	String
`item_class_id`	String
`item_class_type`	String
`kit_item`	Unknown
`last_cost`	Unknown
`last_modified_date_time`	Unknown
`lot_serial_class_description`	String
`lot_serial_class_id`	String
`note`	String
`packaging_base_item_volume`	Unknown
`packaging_base_item_weight`	Unknown
`packaging_volume_uom`	String
`packaging_weight_uom`	String
`pending_cost`	Unknown
`pending_cost_date`	Unknown
`posting_class_description`	String
`posting_class_id`	String
`price_class_description`	String
`price_class_id`	String
`price_manager_id`	String
`price_manager_name`	String
`price_workgroup_id`	Unknown
`purchase_unit`	String
`recommended_price`	Unknown
`sales_unit`	String
`status`	String
`stock_item`	Unknown
`timestamps`	String
`type`	String
`uid`	Unknown
`vat_code_description`	String
`vat_code_id`	String

cash_sale_application

Column	Type	Keys
`index`	Unknown	PK
`cash_sale_id`	String	PKFK
`amount_paid`	Unknown
`application_date`	Unknown
`application_period`	String
`balance`	Unknown
`cash_discount_taken`	Unknown
`customer_cd`	String
`doc_type`	String
`hold`	Unknown
`invoice_text`	String
`payment_ref`	String
`pending_ppd`	Unknown
`ppd_cr_memo_ref_nbr`	String
`ref_nbr`	String
`released`	Unknown
`status`	String
`voided`	Unknown

cash_sale_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`cash_sale_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

cash_sale_line_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`cash_sale_id`	String	PKFK
`cash_sale_line_index`	Unknown	PKFK
`description`	String
`value`	String
`value_description`	String

cash_sale_line

Column	Type	Keys
`index`	Unknown	PK
`cash_sale_id`	String	PKFK
`account_number`	String	FK
`branch_number`	String	FK
`inventory_number`	String	FK
`sub_account_id`	Unknown	FK
`amount`	Unknown
`amount_in_currency`	Unknown
`cost`	Unknown
`deferral_code`	String
`deferral_schedule`	Unknown
`description`	String
`discount_amount`	Unknown
`discount_amount_in_currency`	Unknown
`discount_code`	String
`discount_percent`	Unknown
`external_link`	String
`line_number`	Unknown
`manual_amount`	Unknown
`manual_amount_in_currency`	Unknown
`manual_discount`	Unknown
`note`	String
`quantity`	Unknown
`salesperson`	String
`seller_description`	String
`seller_id`	String
`unit_price`	Unknown
`unit_price_in_currency`	Unknown
`uom`	String
`vat_code_description`	String
`vat_code_id`	String

cash_sale

Column	Type	Keys
`id`	String	PK
`account_number`	String	FK
`branch_number`	String	FK
`cash_account`	String	FK
`closed_financial_period`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`financial_period`	String	FK
`payment_method_id`	String	FK
`sub_account_id`	Unknown	FK
`amount`	Unknown
`amount_in_currency`	Unknown
`balance`	Unknown
`balance_in_currency`	Unknown
`cash_discount`	Unknown
`cash_discount_in_currency`	Unknown
`created_date_time`	Unknown
`credit_terms_description`	String
`credit_terms_id`	String
`customer_project`	String
`customer_ref_number`	String
`detail_total`	Unknown
`detail_total_in_currency`	Unknown
`document_date`	Unknown
`document_type`	String
`dont_email`	Unknown
`dont_print`	Unknown
`hold`	Unknown
`invoice_address_city`	String
`invoice_address_country_id`	String
`invoice_address_country_name`	String
`invoice_address_county_id`	String
`invoice_address_county_name`	String
`invoice_address_id`	Unknown
`invoice_address_line_1`	String
`invoice_address_line_2`	String
`invoice_address_line_3`	String
`invoice_address_override_address`	Unknown
`invoice_address_postal_code`	String
`invoice_contact_attention`	String
`invoice_contact_business_name`	String
`invoice_contact_email`	String
`invoice_contact_id`	Unknown
`invoice_contact_override_contact`	Unknown
`invoice_contact_phone_1`	String
`invoice_text`	String
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`note`	String
`orig_invoice_date`	Unknown
`payment_reference`	String
`post_period`	String
`project_description`	String
`project_id`	String
`revoked`	Unknown
`sales_person_description`	String
`sales_person_id`	String
`status`	String
`vat_exempt_total`	Unknown
`vat_exempt_total_in_currency`	Unknown
`vat_taxable_total`	Unknown
`vat_taxable_total_in_currency`	Unknown
`vat_total`	Unknown
`vat_total_in_currency`	Unknown

customer_payment_method_detail

Column	Type	Keys
`id`	String	PK
`customer_id`	String	PKFK
`payment_method_id`	String	PKFK
`description`	String
`value`	String

customer_payment_method

Column	Type	Keys
`customer_id`	String	PKFK
`payment_method_id`	String	PKFK
`cash_account_id`	String	FK
`active`	Unknown
`card_or_account_no`	String

inventory_transfer_attachment

Column	Type	Keys
`id`	String	PK
`inventory_transfer_id`	String	PKFK
`name`	String
`revision`	Unknown

inventory_transfer_line_allocation

Column	Type	Keys
`index`	Unknown	PK
`inventory_transfer_id`	String	PKFK
`transfer_line_index`	Unknown	PKFK
`line_nbr`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`quantity`	Unknown

inventory_transfer_line_attachment

Column	Type	Keys
`id`	String	PK
`inventory_transfer_id`	String	PKFK
`transfer_line_index`	Unknown	PKFK
`name`	String
`revision`	Unknown

inventory_transfer_line

Column	Type	Keys
`index`	Unknown	PK
`inventory_transfer_id`	String	PKFK
`branch_number`	String	FK
`description`	String
`expiration_date`	Unknown
`inventory_item_description`	String
`inventory_item_number`	String
`location_country_id`	String
`location_id`	String
`location_name`	String
`lot_serial_number`	String
`number`	Unknown
`quantity`	Unknown
`reason_code_description`	String
`reason_code_id`	String
`to_location_country_id`	String
`to_location_id`	String
`to_location_name`	String
`uom`	String

inventory_transfer

Column	Type	Keys
`id`	String	PK
`branch_number`	String	FK
`to_warehouse_id`	String	FK
`warehouse_id`	String	FK
`batch_number`	String
`control_quantity`	Unknown
`date`	Unknown
`description`	String
`external_reference`	String
`hold`	Unknown
`last_modified_date_time`	Unknown
`post_period`	String
`status`	String
`total_quantity`	Unknown

carrier

Column	Type	Keys
`id`	String	PK
`description`	String
`last_modified_date_time`	Unknown

location

Column	Type	Keys
`id`	String	PK
`internal_id`	String	PK
`active`	Unknown
`address_city`	String
`address_id`	Unknown
`address_line_1`	String
`address_line_2`	String
`address_line_3`	String
`address_postal_code`	String
`baccount_name`	String
`baccount_number`	String
`contact_attention`	String
`contact_email`	String
`contact_fax`	String
`contact_id`	Unknown
`contact_name`	String
`contact_phone_1`	String
`contact_phone_2`	String
`contact_web`	String
`corporate_id`	String
`country_id`	String
`country_name`	String
`county_id`	String
`county_name`	String
`default_tax_category_description`	String
`default_tax_category_number`	String
`edi_code`	String
`gln`	String
`last_modified_date_time`	Unknown
`name`	String
`peppol_scheme_endpoint`	String
`peppol_scheme_party_identification`	String
`peppol_scheme_party_legal`	String
`vat_registration_id`	String
`vat_zone_default_vat_category`	String
`vat_zone_description`	String
`vat_zone_id`	String

account

Column	Type	Keys
`account_number`	String	PK
`id`	Unknown	PK
`currency_id`	String	FK
`active`	Unknown
`allow_manual_entry`	Unknown
`analisys_code_info_description`	String
`analisys_code_info_number`	String
`cash_account`	Unknown
`class`	String
`control_account_module`	String
`description`	String
`external_code_1_info_description`	String
`external_code_1_info_number`	String
`external_code_2_info_description`	String
`external_code_2_info_number`	String
`group_cd`	String
`last_modified_date_time`	Unknown
`post_option`	String
`public_code_1`	String
`tax_category`	String
`type`	String
`use_default_sub`	Unknown

customer_attribute

Column	Type	Keys
`customer_id`	String	PKFK
`id`	String	PKFK
`description`	String
`value`	String

customer_direct_debit_line

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	String	PKFK
`bic`	String
`branch`	String
`date_of_signature`	Unknown
`expiration_date`	Unknown
`iban`	String
`is_default`	Unknown
`last_collection_date`	Unknown
`mandate_description`	String
`mandate_id`	String
`max_amount`	Unknown
`one_time`	Unknown

customer_ledger_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_sales_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_discount_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_freight_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_pre_payment_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

customer_cash_discount_sub_account_segment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	String	PKFK
`description`	String
`value`	String
`value_description`	String

payment_method_customer

Column	Type	Keys
`customer_id`	String	PKFK
`id`	String	PKFK
`is_default`	Unknown

customer

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`default_payment_method_id`	String	FK
`accept_auto_invoices`	Unknown
`account_reference`	String
`consolidate_invoices`	Unknown
`corporate_id`	String
`created_date_time`	Unknown
`credit_days_past_due`	Unknown
`credit_limit`	Unknown
`credit_terms_description`	String
`credit_terms_id`	String
`credit_verification`	String
`customer_class_description`	String
`customer_class_id`	String
`default_tax_category_description`	String
`default_tax_category_number`	String
`delivery_address_city`	String
`delivery_address_country_id`	String
`delivery_address_country_name`	String
`delivery_address_county_id`	String
`delivery_address_county_name`	String
`delivery_address_id`	Unknown
`delivery_address_line_1`	String
`delivery_address_line_2`	String
`delivery_address_line_3`	String
`delivery_address_postal_code`	String
`delivery_contact_attention`	String
`delivery_contact_email`	String
`delivery_contact_fax`	String
`delivery_contact_id`	Unknown
`delivery_contact_name`	String
`delivery_contact_phone_1`	String
`delivery_contact_phone_2`	String
`delivery_contact_web`	String
`e_invoice_contract_f_invoice_contract_id`	String
`e_invoice_contract_f_invoice_intermediator_id`	String
`gl_accounts_cash_discount_account_description`	String
`gl_accounts_cash_discount_account_number`	String
`gl_accounts_cash_discount_account_type`	String
`gl_accounts_cash_discount_sub_account_active`	Unknown
`gl_accounts_cash_discount_sub_account_description`	String
`gl_accounts_cash_discount_sub_account_id`	Unknown
`gl_accounts_cash_discount_sub_account_last_modified_date_time`	Unknown
`gl_accounts_cash_discount_sub_account_number`	String
`gl_accounts_customer_ledger_account_description`	String
`gl_accounts_customer_ledger_account_number`	String
`gl_accounts_customer_ledger_account_type`	String
`gl_accounts_customer_ledger_sub_account_active`	Unknown
`gl_accounts_customer_ledger_sub_account_description`	String
`gl_accounts_customer_ledger_sub_account_id`	Unknown
`gl_accounts_customer_ledger_sub_account_last_modified_date_time`	Unknown
`gl_accounts_customer_ledger_sub_account_number`	String
`gl_accounts_discount_account_description`	String
`gl_accounts_discount_account_number`	String
`gl_accounts_discount_account_type`	String
`gl_accounts_discount_sub_account_active`	Unknown
`gl_accounts_discount_sub_account_description`	String
`gl_accounts_discount_sub_account_id`	Unknown
`gl_accounts_discount_sub_account_last_modified_date_time`	Unknown
`gl_accounts_discount_sub_account_number`	String
`gl_accounts_freight_account_description`	String
`gl_accounts_freight_account_number`	String
`gl_accounts_freight_account_type`	String
`gl_accounts_freight_sub_account_active`	Unknown
`gl_accounts_freight_sub_account_description`	String
`gl_accounts_freight_sub_account_id`	Unknown
`gl_accounts_freight_sub_account_last_modified_date_time`	Unknown
`gl_accounts_freight_sub_account_number`	String
`gl_accounts_prepayment_account_description`	String
`gl_accounts_prepayment_account_number`	String
`gl_accounts_prepayment_account_type`	String
`gl_accounts_prepayment_sub_account_active`	Unknown
`gl_accounts_prepayment_sub_account_description`	String
`gl_accounts_prepayment_sub_account_id`	Unknown
`gl_accounts_prepayment_sub_account_last_modified_date_time`	Unknown
`gl_accounts_prepayment_sub_account_number`	String
`gl_accounts_sales_account_description`	String
`gl_accounts_sales_account_number`	String
`gl_accounts_sales_account_type`	String
`gl_accounts_sales_eu_account_description`	String
`gl_accounts_sales_eu_account_number`	String
`gl_accounts_sales_eu_account_type`	String
`gl_accounts_sales_export_account_description`	String
`gl_accounts_sales_export_account_number`	String
`gl_accounts_sales_export_account_type`	String
`gl_accounts_sales_non_taxable_account_description`	String
`gl_accounts_sales_non_taxable_account_number`	String
`gl_accounts_sales_non_taxable_account_type`	String
`gl_accounts_sales_sub_account_active`	Unknown
`gl_accounts_sales_sub_account_description`	String
`gl_accounts_sales_sub_account_id`	Unknown
`gl_accounts_sales_sub_account_last_modified_date_time`	Unknown
`gl_accounts_sales_sub_account_number`	String
`gln`	String
`internal_id`	Unknown
`invoice_address_city`	String
`invoice_address_country_id`	String
`invoice_address_country_name`	String
`invoice_address_county_id`	String
`invoice_address_county_name`	String
`invoice_address_id`	Unknown
`invoice_address_line_1`	String
`invoice_address_line_2`	String
`invoice_address_line_3`	String
`invoice_address_postal_code`	String
`invoice_contact_attention`	String
`invoice_contact_email`	String
`invoice_contact_fax`	String
`invoice_contact_id`	Unknown
`invoice_contact_name`	String
`invoice_contact_phone_1`	String
`invoice_contact_phone_2`	String
`invoice_contact_web`	String
`invoice_to_default_location`	Unknown
`last_modified_date_time`	Unknown
`location_country_id`	String
`location_id`	String
`location_name`	String
`main_address_city`	String
`main_address_country_id`	String
`main_address_country_name`	String
`main_address_county_id`	String
`main_address_county_name`	String
`main_address_id`	Unknown
`main_address_line_1`	String
`main_address_line_2`	String
`main_address_line_3`	String
`main_address_postal_code`	String
`main_contact_attention`	String
`main_contact_email`	String
`main_contact_fax`	String
`main_contact_id`	Unknown
`main_contact_name`	String
`main_contact_phone_1`	String
`main_contact_phone_2`	String
`main_contact_web`	String
`name`	String
`parent_record_name`	String
`parent_record_number`	String
`price_class_description`	String
`price_class_id`	String
`print_invoices`	Unknown
`print_multi_currency_statements`	Unknown
`print_statements`	Unknown
`send_invoices_by_email`	Unknown
`send_statements_by_email`	Unknown
`statement_type`	String
`status`	String
`vat_registration_id`	String
`vat_zone_default_vat_category`	String
`vat_zone_description`	String
`vat_zone_id`	String