Odoo Synconics

Explore the interactive ERD

Table & Field Reference

reconciled_invoice

Column	Type	Keys
`payment_id`	Unknown	PKFK
`reconciled_invoice_id`	Unknown	PKFK

payment

Column	Type	Keys
`id`	Unknown	PK
`destination_account_id`	Unknown	FK
`outstanding_account_id`	Unknown	FK
`access_token`	Unknown
`access_url`	Unknown
`access_warning`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`always_tax_exigible`	Unknown
`amount`	Unknown
`amount_available_for_refund`	Unknown
`amount_company_currency_signed`	Unknown
`amount_paid`	Unknown
`amount_residual`	Unknown
`amount_residual_signed`	Unknown
`amount_signed`	Unknown
`amount_tax`	Unknown
`amount_tax_electronic_invoice`	Unknown
`amount_tax_signed`	Unknown
`amount_untaxed`	Unknown
`amount_untaxed_signed`	Unknown
`asset_asset_type`	Unknown
`asset_depreciated_value`	Unknown
`asset_depreciation_beginning_date`	Unknown
`asset_id_display_name`	Unknown
`asset_ids`	Json
`asset_number_days`	Unknown
`asset_remaining_value`	Unknown
`asset_value_change`	Unknown
`attachment_ids`	Json
`authorized_transaction_ids`	Json
`auto_post`	Unknown
`auto_post_origin_id`	Unknown
`auto_post_until`	Unknown
`available_journal_ids`	Json
`available_partner_bank_ids`	Json
`available_payment_method_line_ids`	Json
`bank_partner_id`	Json
`c_sin_imp`	Unknown
`campaign_id`	Unknown
`commercial_partner_id`	Json
`company_currency_id`	Json
`company_id`	Json
`company_vat`	Unknown
`consecutive_number_receiver`	Unknown
`country_code`	Unknown
`create_date`	Unknown
`create_uid`	Json
`credit_fiscal`	Unknown
`csi_articulo`	Unknown
`csi_inciso`	Unknown
`csi_ley`	Unknown
`currency_id`	Json
`date`	Unknown
`date_issuance`	Unknown
`declaracion_company_state`	Json
`depreciation_value`	Unknown
`destination_journal_id`	Unknown
`direction_sign`	Unknown
`display_inactive_currency_warning`	Unknown
`display_name`	Unknown
`display_qr_code`	Unknown
`draft_asset_ids`	Unknown
`duplicated_ref_ids`	Json
`economic_activities_ids`	Json
`economic_activity_id`	Unknown
`economic_activity_id_invoice`	Unknown
`edi_blocking_level`	Unknown
`edi_document_ids`	Json
`edi_error_count`	Unknown
`edi_error_message`	Unknown
`edi_show_abandon_cancel_button`	Unknown
`edi_show_cancel_button`	Unknown
`edi_state`	Unknown
`edi_web_services_to_process`	Unknown
`electronic_invoice_return_message`	Unknown
`error_count`	Unknown
`estado_declaracion_hacienda`	Unknown
`fiscal_position_id`	Unknown
`fname_xml_comprobante`	Unknown
`fname_xml_respuesta_tributacion`	Unknown
`fname_xml_supplier_approval`	Unknown
`gasto_no_dedu`	Unknown
`has_message`	Unknown
`has_reconciled_entries`	Unknown
`hide_post_button`	Unknown
`highest_name`	Unknown
`ignore_total_difference`	Unknown
`inalterable_hash`	Unknown
`invoice_amount_text`	Unknown
`invoice_cash_rounding_id`	Unknown
`invoice_date`	Unknown
`invoice_date_due`	Unknown
`invoice_filter_type_domain`	Unknown
`invoice_has_outstanding`	Unknown
`invoice_id`	Unknown
`invoice_incoterm_id`	Unknown
`invoice_line_ids`	Json
`invoice_origin`	Unknown
`invoice_outstanding_credits_debits_widget`	Unknown
`invoice_partner_display_name`	Unknown
`invoice_payment_term_id`	Unknown
`invoice_payments_widget`	Unknown
`invoice_source_email`	Unknown
`invoice_user_id`	Unknown
`invoice_vendor_bill_id`	Unknown
`is_donation`	Unknown
`is_internal_transfer`	Unknown
`is_matched`	Unknown
`is_move_sent`	Unknown
`is_reconciled`	Unknown
`is_storno`	Unknown
`journal_id`	Json
`last_update`	Unknown
`line_ids`	Json
`linked_asset_type`	Unknown
`made_sequence_hole`	Unknown
`medium_id`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`move_id`	Json
`move_type`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`narration`	Unknown
`needed_terms_dirty`	Unknown
`not_loaded_invoice`	Unknown
`not_loaded_invoice_date`	Unknown
`number_asset_ids`	Unknown
`number_electronic`	Unknown
`paired_internal_transfer_payment_id`	Unknown
`partner_bank_id`	Unknown
`partner_credit_warning`	Unknown
`partner_id`	Json
`partner_shipping_id`	Unknown
`partner_type`	Unknown
`partner_vat`	Unknown
`payment_method_code`	Unknown
`payment_method_id`	Json
`payment_method_line_id`	Json
`payment_methods_id`	Unknown
`payment_reference`	Unknown
`payment_state`	Unknown
`payment_state_before_switch`	Unknown
`payment_term_details`	Unknown
`payment_token_id`	Unknown
`payment_transaction_id`	Unknown
`payment_type`	Unknown
`posted_before`	Unknown
`purchase_id`	Json
`purchase_vendor_bill_id`	Unknown
`qr_code`	Unknown
`qr_code_method`	Unknown
`qr_image`	Unknown
`quick_edit_mode`	Unknown
`quick_encoding_vals`	Unknown
`reconciled_bill_ids`	Json
`reconciled_invoices_count`	Unknown
`reconciled_invoices_type`	Unknown
`reconciled_statement_line_ids`	Json
`ref`	Unknown
`reference_code_id`	Unknown
`reference_document_id`	Unknown
`refunds_count`	Unknown
`require_partner_bank_account`	Unknown
`restrict_mode_hash_table`	Unknown
`reversal_move_id`	Json
`reversed_entry_id`	Unknown
`sale_order_count`	Unknown
`sequence`	Unknown
`sequence_prefix`	Unknown
`show_discount_details`	Unknown
`show_name_warning`	Unknown
`show_partner_bank_account`	Unknown
`show_payment_term_details`	Unknown
`show_reset_to_draft_button`	Unknown
`source_id`	Unknown
`source_payment_id`	Unknown
`state`	Unknown
`state_email`	Unknown
`state_invoice_partner`	Unknown
`state_send_invoice`	Unknown
`state_tributacion`	Unknown
`statement_line_id`	Unknown
`statement_line_ids`	Json
`stock_move_id`	Unknown
`stock_valuation_layer_ids`	Json
`string_to_hash`	Unknown
`subto`	Unknown
`suitable_journal_ids`	Json
`suitable_payment_token_ids`	Json
`suspense_statement_line_id`	Unknown
`tax_cash_basis_created_move_ids`	Json
`tax_cash_basis_origin_move_id`	Unknown
`tax_cash_basis_rec_id`	Unknown
`tax_closing_end_date`	Unknown
`tax_country_code`	Unknown
`tax_country_id`	Json
`tax_lock_date_message`	Unknown
`tax_report_control_error`	Unknown
`team_id`	Json
`timesheet_encode_uom_id`	Json
`timesheet_ids`	Json
`timesheet_total_duration`	Unknown
`tipo_documento`	Unknown
`tipo_gasto_no_dedu`	Unknown
`to_check`	Unknown
`transaction_ids`	Json
`transfer_model_id`	Unknown
`type_name`	Unknown
`usd_currency_id`	Json
`usd_currency_rate`	Unknown
`use_electronic_payment_method`	Unknown
`user_id`	Unknown
`venta_aut_sin_imp`	Unknown
`venta_exentas`	Unknown
`venta_no_sujeta`	Unknown
`visibilidad_declaracion`	Unknown
`website_id`	Unknown
`website_message_ids`	Json
`write_date`	LocalDateTime
`write_uid`	Json
`xml_comprobante`	Unknown
`xml_respuesta_tributacion`	Unknown
`xml_supplier_approval`	Unknown

sale_order_line

Column	Type	Keys
`id`	Unknown	PK
`analytic_distribution`	Unknown
`analytic_distribution_search`	Unknown
`analytic_line_ids`	Json
`analytic_precision`	Unknown
`company_id`	Json
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Unknown
`customer_lead`	Unknown
`discount`	Unknown
`discount_total`	Unknown
`display_name`	Unknown
`display_qty_widget`	Unknown
`display_type`	Unknown
`forecast_expected_date`	Unknown
`free_qty_today`	Unknown
`has_displayed_warning_upsell`	Unknown
`invoice_lines`	Json
`invoice_status`	Unknown
`is_configurable_product`	Unknown
`is_downpayment`	Unknown
`is_expense`	Unknown
`is_mto`	Unknown
`is_service`	Unknown
`last_update`	Unknown
`line_discount`	Unknown
`linked_line_id`	Unknown
`margin`	Unknown
`margin_percent`	Unknown
`move_ids`	Json
`name`	Unknown
`name_short`	Unknown
`option_line_ids`	Json
`order_id`	Json
`order_partner_id`	Json
`precio`	Unknown
`price_reduce`	Unknown
`price_reduce_tax_excl`	Unknown
`price_reduce_tax_inc`	Unknown
`price_subtotal`	Unknown
`price_tax`	Unknown
`price_total`	Unknown
`price_total_no_discount`	Unknown
`price_unit`	Unknown
`pricelist_item_id`	Unknown
`product_custom_attribute_value_ids`	Json
`product_id`	Json
`product_no_variant_attribute_value_ids`	Json
`product_packaging_id`	Unknown
`product_packaging_qty`	Unknown
`product_template_attribute_value_ids`	Unknown
`product_template_id`	Json
`product_type`	Unknown
`product_uom`	Json
`product_uom_category_id`	Json
`product_uom_qty`	Unknown
`product_uom_read_only`	Unknown
`product_updatable`	Unknown
`project_id`	Json
`purchase_line_count`	Unknown
`purchase_line_ids`	Unknown
`purchase_price`	Unknown
`qty_available_today`	Unknown
`qty_delivered`	Unknown
`qty_delivered_method`	Unknown
`qty_invoiced`	Unknown
`qty_to_deliver`	Unknown
`qty_to_invoice`	Unknown
`reached_milestones_ids`	Json
`remaining_hours`	Unknown
`remaining_hours_available`	Unknown
`route_id`	Unknown
`sale_order_option_ids`	Unknown
`salesman_id`	Json
`scheduled_date`	Unknown
`sequence`	Unknown
`shop_warning`	Unknown
`state`	Unknown
`task_id`	Json
`tax_id`	Json
`timesheet_ids`	Json
`untaxed_amount_invoiced`	Unknown
`untaxed_amount_to_invoice`	Unknown
`virtual_available_at_date`	Unknown
`warehouse_id`	Json
`write_date`	LocalDateTime
`write_uid`	Json

sale_order_invoice

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`sale_order_id`	Unknown	PKFK

sale_order_task

Column	Type	Keys
`sale_order_id`	Unknown	PKFK
`task_id`	Unknown	PKFK

sale_order_project

Column	Type	Keys
`project_id`	Unknown	PKFK
`sale_order_id`	Unknown	PKFK

sale_order

Column	Type	Keys
`id`	Unknown	PK
`access_token`	Unknown
`access_url`	Unknown
`access_warning`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`amount_undiscounted`	Unknown
`analytic_account_id`	Unknown
`authorized_transaction_ids`	Json
`campaign_id`	Unknown
`cart_quantity`	Unknown
`cart_recovery_email_sent`	Unknown
`client_order_ref`	Unknown
`commitment_date`	Unknown
`company_id`	Json
`country_code`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`currency_rate`	Unknown
`date_order`	Unknown
`delivery_count`	Unknown
`delivery_status`	Unknown
`display_name`	Unknown
`effective_date`	Unknown
`expected_date`	Unknown
`fiscal_position_id`	Unknown
`has_message`	Unknown
`incoterm`	Unknown
`incoterm_location`	Unknown
`invoice_status`	Unknown
`is_abandoned_cart`	Unknown
`is_expired`	Unknown
`is_product_milestone`	Unknown
`json_popover`	Unknown
`last_update`	Unknown
`margin`	Unknown
`margin_percent`	Unknown
`medium_id`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`my_activity_date_deadline`	Unknown
`name`	Unknown
`note`	Unknown
`only_services`	Unknown
`opportunity_id`	Json
`order_line`	Json
`origin`	Unknown
`partner_credit_warning`	Unknown
`partner_id`	Json
`partner_invoice_id`	Json
`partner_shipping_id`	Json
`payment_term_id`	Json
`picking_ids`	Json
`picking_policy`	Unknown
`pricelist_id`	Json
`procurement_group_id`	Unknown
`purchase_order_count`	Unknown
`reference`	Unknown
`require_payment`	Unknown
`require_signature`	Unknown
`sale_order_option_ids`	Json
`sale_order_template_id`	Unknown
`shop_warning`	Unknown
`show_json_popover`	Unknown
`show_update_fpos`	Unknown
`show_update_pricelist`	Unknown
`signature`	Unknown
`signed_by`	Unknown
`signed_on`	Unknown
`source_id`	Unknown
`state`	Unknown
`subto`	Unknown
`tag_ids`	Json
`tax_country_id`	Json
`team_id`	Json
`terms_type`	Unknown
`ticket_count`	Unknown
`timesheet_encode_uom_id`	Json
`timesheet_ids`	Json
`timesheet_total_duration`	Unknown
`transaction_ids`	Json
`type_name`	Unknown
`user_id`	Json
`validity_date`	Unknown
`visible_project`	Unknown
`warehouse_id`	Json
`website_id`	Unknown
`website_message_ids`	Json
`website_order_line`	Json
`write_date`	LocalDateTime
`write_uid`	Json

account_analytic_line

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Json
`amount`	Unknown
`ancestor_task_id`	Unknown
`can_edit`	Unknown
`category`	Unknown
`code`	Unknown
`company_id`	Json
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Unknown
`custom_helpdesk_ticket_id`	Json
`date`	Unknown
`department_id`	Json
`display_name`	Unknown
`display_sol`	Unknown
`display_task`	Unknown
`display_timer`	Unknown
`display_timer_pause`	Unknown
`display_timer_resume`	Unknown
`display_timer_start_primary`	Unknown
`display_timer_stop`	Unknown
`duration_unit_amount`	Unknown
`employee_id`	Json
`encoding_uom_id`	Json
`general_account_id`	Unknown
`has_helpdesk_team`	Unknown
`has_so_access`	Unknown
`helpdesk_ticket_id`	Unknown
`is_so_line_edited`	Unknown
`is_timer_running`	Unknown
`is_timesheet`	Unknown
`job_title`	Unknown
`journal_id`	Unknown
`last_update`	Unknown
`manager_id`	Json
`move_line_id`	Unknown
`name`	Unknown
`order_id`	Json
`partner_id`	Unknown
`plan_id`	Json
`product_id`	Unknown
`product_uom_category_id`	Json
`product_uom_id`	Json
`project_id`	Json
`ref`	Unknown
`so_line`	Unknown
`task_id`	Json
`timer_pause`	Unknown
`timer_start`	Unknown
`timesheet_invoice_id`	Unknown
`timesheet_invoice_type`	Unknown
`unit_amount`	Unknown
`unit_amount_validate`	Unknown
`user_can_validate`	Unknown
`user_id`	Json
`user_timer_id`	Json
`validated`	Unknown
`validated_status`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

crm_lead_property

Column	Type	Keys
`index`	Unknown	PK
`crm_lead_id`	Unknown	PKFK
`defaults`	Unknown
`name`	Unknown
`string`	Unknown
`type`	Unknown

crm_lead_order

Column	Type	Keys
`crm_lead_id`	Unknown	PKFK
`order_id`	Unknown	PKFK

crm_lead

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`automated_probability`	Unknown
`calendar_event_count`	Unknown
`campaign_id`	Unknown
`city`	Unknown
`color`	Unknown
`company_currency`	Json
`company_id`	Json
`contact_name`	Unknown
`country_id`	Json
`create_date`	Unknown
`create_uid`	Json
`date_action_last`	Unknown
`date_closed`	Unknown
`date_conversion`	Unknown
`date_deadline`	Unknown
`date_last_stage_update`	Unknown
`date_open`	Unknown
`day_close`	Unknown
`day_open`	Unknown
`days_exceeding_closing`	Unknown
`days_to_convert`	Unknown
`description`	Unknown
`display_name`	Unknown
`duplicate_lead_count`	Unknown
`duplicate_lead_ids`	Json
`email_cc`	Unknown
`email_from`	Unknown
`email_normalized`	Unknown
`email_state`	Unknown
`expected_revenue`	Unknown
`function`	Unknown
`has_message`	Unknown
`is_automated_probability`	Unknown
`is_blacklisted`	Unknown
`is_partner_visible`	Unknown
`kanban_state`	Unknown
`lang_active_count`	Unknown
`lang_code`	Unknown
`lang_id`	Unknown
`last_update`	Unknown
`lost_reason_id`	Unknown
`medium_id`	Unknown
`message_attachment_count`	Unknown
`message_bounce`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_error_counter`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Json
`message_need_action`	Unknown
`message_need_action_counter`	Unknown
`message_partner_ids`	Json
`mobile`	Unknown
`mobile_blacklisted`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`partner_email_update`	Unknown
`partner_id`	Json
`partner_is_blacklisted`	Unknown
`partner_name`	Unknown
`partner_phone_update`	Unknown
`phone`	Unknown
`phone_blacklisted`	Unknown
`phone_mobile_search`	Unknown
`phone_sanitized`	Unknown
`phone_sanitized_blacklisted`	Unknown
`phone_state`	Unknown
`priority`	Unknown
`probability`	Unknown
`prorated_revenue`	Unknown
`quotation_count`	Unknown
`recurring_plan`	Unknown
`recurring_revenue`	Unknown
`recurring_revenue_monthly`	Unknown
`recurring_revenue_monthly_prorated`	Unknown
`referred`	Unknown
`reveal_id`	Unknown
`sale_amount_total`	Unknown
`sale_order_count`	Unknown
`source_id`	Unknown
`stage_id`	Json
`state_id`	Unknown
`street`	Unknown
`street_2`	Unknown
`tag_ids`	Json
`team_id`	Json
`title`	Unknown
`type`	Unknown
`user_company_ids`	Json
`user_id`	Json
`visitor_ids`	Json
`visitor_page_count`	Unknown
`website`	Unknown
`website_message_ids`	Json
`won_status`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

mail_tracking_value

Column	Type	Keys
`id`	Unknown	PK
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Unknown
`display_name`	Unknown
`field_desc`	Unknown
`field_groups`	Unknown
`field_type`	Unknown
`last_update`	Unknown
`mail_message_id`	Json
`new_value_char`	Unknown
`new_value_datetime`	Unknown
`new_value_float`	Unknown
`new_value_integer`	Unknown
`new_value_monetary`	Unknown
`new_value_text`	Unknown
`old_value_datetime`	Unknown
`old_value_float`	Unknown
`old_value_integer`	Unknown
`old_value_monetary`	Unknown
`old_value_text`	Unknown
`tracking_sequence`	Unknown
`write_date`	LocalDateTime

helpdesk_tag

Column	Type	Keys
`id`	Unknown	PK
`color`	Unknown
`create_date`	Unknown
`create_uid`	Json
`display_name`	Unknown
`last_update`	Unknown
`name`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

account_move_line

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Json
`account_internal_group`	Unknown
`account_root_id`	Json
`account_type`	Unknown
`amount_currency`	Unknown
`amount_residual`	Unknown
`amount_residual_currency`	Unknown
`analytic_distribution`	Unknown
`analytic_distribution_search`	Unknown
`analytic_precision`	Unknown
`asset_ids`	Json
`balance`	Unknown
`blocked`	Unknown
`cabys_code`	Unknown
`categ_name`	Unknown
`company_currency_id`	Json
`company_id`	Json
`compute_all_tax_dirty`	Unknown
`create_date`	Unknown
`create_uid`	Json
`credit`	Unknown
`cumulated_balance`	Unknown
`currency_id`	Json
`currency_rate`	Unknown
`date`	Unknown
`debit`	Unknown
`discount`	Unknown
`discount_amount_currency`	Unknown
`discount_balance`	Unknown
`discount_date`	Unknown
`discount_note`	Unknown
`discount_percentage`	Unknown
`discount_total`	Unknown
`display_name`	Unknown
`display_type`	Unknown
`economic_activity_id`	Unknown
`epd_dirty`	Unknown
`expected_pay_date`	Unknown
`followup_line_id`	Unknown
`full_reconcile_id`	Json
`group_tax_id`	Unknown
`invoice_date`	Unknown
`invoice_origin`	Unknown
`is_account_reconcile`	Unknown
`is_downpayment`	Unknown
`is_refund`	Unknown
`is_same_currency`	Unknown
`is_storno`	Unknown
`journal_id`	Json
`last_followup_date`	Unknown
`last_update`	Unknown
`line_discount`	Unknown
`matched_credit_ids`	Json
`matched_debit_ids`	Json
`move_attachment_ids`	Json
`move_id`	Json
`move_name`	Unknown
`move_type`	Unknown
`name`	Unknown
`next_action_date`	Unknown
`non_deductible_tax_value`	Unknown
`non_tax_deductible`	Unknown
`parent_state`	Unknown
`partner_id`	Json
`payment_id`	Unknown
`precio`	Unknown
`price_subtotal`	Unknown
`price_total`	Unknown
`price_total_no_discount`	Unknown
`price_unit`	Unknown
`product_id`	Json
`product_uom_category_id`	Unknown
`product_uom_id`	Unknown
`purchase_line_id`	Unknown
`purchase_order_id`	Unknown
`quantity`	Unknown
`reconcile_model_id`	Unknown
`reconciled`	Unknown
`ref`	Unknown
`sale_line_ids`	Json
`sequence`	Unknown
`statement_id`	Unknown
`stock_valuation_layer_ids`	Json
`tariff_head`	Unknown
`tax_audit`	Unknown
`tax_base_amount`	Unknown
`tax_group_id`	Json
`tax_ids`	Json
`tax_line_id`	Json
`tax_repartition_line_id`	Unknown
`tax_tag_ids`	Json
`tax_tag_invert`	Unknown
`third_party_id`	Unknown
`tipo_inversion`	Unknown
`total_tax`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

helpdesk_ticket

Column	Type	Keys
`id`	Unknown	PK
`access_token`	Unknown
`access_url`	Unknown
`access_warning`	Unknown
`active`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`analytic_account_id`	Json
`answered_customer_message_count`	Unknown
`assign_hours`	Unknown
`avg_response_hours`	Unknown
`campaign_id`	Unknown
`can_share_forum`	Unknown
`close_date`	Unknown
`close_hours`	Unknown
`closed_by_partner`	Unknown
`color`	Unknown
`commercial_partner_id`	Json
`company_id`	Json
`create_date`	Unknown
`create_uid`	Json
`custom_project_id`	Json
`custom_timesheet_ids`	Json
`date_last_stage_update`	Unknown
`description`	Unknown
`display_name`	Unknown
`display_timer`	Unknown
`display_timer_pause`	Unknown
`display_timer_resume`	Unknown
`display_timer_start_primary`	Unknown
`display_timer_start_secondary`	Unknown
`display_timer_stop`	Unknown
`display_timesheet_timer`	Unknown
`domain_user_ids`	Json
`email`	Unknown
`email_cc`	Unknown
`empresa_remitente`	Json
`encode_uom_in_days`	Unknown
`first_response_hours`	Unknown
`forum_post_count`	Unknown
`forum_post_ids`	Json
`has_message`	Unknown
`is_partner_email_update`	Unknown
`is_partner_phone_update`	Unknown
`is_timer_running`	Unknown
`kanban_state`	Unknown
`kanban_state_label`	Unknown
`last_update`	Unknown
`legend_blocked`	Unknown
`legend_done`	Unknown
`legend_normal`	Unknown
`medium_id`	Unknown
`mensajes_no_leidos`	Unknown
`message_attachment_count`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_error_counter`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`my_activity_date_deadline`	Unknown
`name`	Unknown
`oldest_unanswered_customer_message_date`	Unknown
`open_hours`	Unknown
`partner_email`	Unknown
`partner_id`	Json
`partner_name`	Unknown
`partner_open_ticket_count`	Unknown
`partner_ticket_count`	Unknown
`partner_ticket_ids`	Json
`priority`	Unknown
`project_id`	Json
`project_sale_order_id`	Unknown
`properties`	Json
`rating_avg`	Unknown
`rating_avg_text`	Unknown
`rating_count`	Unknown
`rating_last_feedback`	Unknown
`rating_last_image`	Unknown
`rating_last_text`	Unknown
`rating_last_value`	Unknown
`rating_percentage_satisfaction`	Unknown
`remaining_hours_available`	Unknown
`remaining_hours_so`	Unknown
`sale_line_id`	Unknown
`sale_order_id`	Unknown
`sla_deadline`	Unknown
`sla_deadline_hours`	Unknown
`sla_fail`	Unknown
`sla_reached`	Unknown
`sla_reached_late`	Unknown
`sla_success`	Unknown
`source_id`	Unknown
`stage_id`	Json
`tag_ids`	Json
`team_id`	Json
`team_privacy_visibility`	Unknown
`ticket_ref`	Unknown
`ticket_type_id`	Json
`timer_pause`	Unknown
`timer_start`	Unknown
`timesheet_ids`	Json
`total_hours_spent`	Unknown
`total_response_hours`	Unknown
`use_coupons`	Unknown
`use_credit_notes`	Unknown
`use_helpdesk_sale_timesheet`	Unknown
`use_helpdesk_timesheet`	Unknown
`use_product_repairs`	Unknown
`use_product_returns`	Unknown
`use_rating`	Unknown
`use_sla`	Unknown
`use_website_helpdesk_forum`	Unknown
`user_id`	Json
`user_timer_id`	Json
`website_message_ids`	Json
`write_date`	LocalDateTime
`write_uid`	Json

product

Column	Type	Keys
`id`	Unknown	PK
`accessory_product_ids`	Json
`account_tag_ids`	Json
`active`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`alternative_product_ids`	Json
`attribute_line_ids`	Json
`barcode`	Unknown
`base_unit_id`	Json
`base_unit_name`	Unknown
`base_unit_price`	Unknown
`cabys_code`	Unknown
`cabys_product_id`	Json
`cabys_tax`	Unknown
`can_image_1024_be_zoomed`	Unknown
`can_publish`	Unknown
`categ_id`	Json
`code_type_id`	Json
`color`	Unknown
`commercial_measurement`	Unknown
`company_id`	Unknown
`compare_list_price`	Unknown
`cost_currency_id`	Json
`cost_method`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`default_code`	Unknown
`description`	Unknown
`description_picking`	Unknown
`description_picking_in`	Unknown
`description_picking_out`	Unknown
`description_purchase`	Unknown
`description_sale`	Unknown
`detailed_type`	Unknown
`display_name`	Unknown
`documents_allowed_company_id`	Json
`economic_activity_id`	Json
`expense_policy`	Unknown
`has_available_route_ids`	Unknown
`has_configurable_attributes`	Unknown
`has_message`	Unknown
`image_1024`	Unknown
`image_128`	Unknown
`image_1920`	Unknown
`image_256`	Unknown
`image_512`	Unknown
`incoming_qty`	Unknown
`invoice_policy`	Unknown
`is_product_variant`	Unknown
`is_published`	Unknown
`is_seo_optimized`	Unknown
`last_update`	Unknown
`list_price`	Unknown
`location_id`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`my_activity_date_deadline`	Unknown
`name`	Unknown
`nbr_moves_in`	Unknown
`nbr_moves_out`	Unknown
`nbr_reordering_rules`	Unknown
`non_tax_deductible`	Unknown
`optional_product_ids`	Json
`outgoing_qty`	Unknown
`packaging_ids`	Json
`pricelist_item_count`	Unknown
`priority`	Unknown
`product_tag_ids`	Json
`product_template_image_ids`	Json
`product_tooltip`	Unknown
`product_variant_ids`	Json
`project_id`	Unknown
`project_template_id`	Unknown
`project_template_use_documents`	Unknown
`property_account_creditor_price_difference`	Unknown
`property_account_expense_id`	Unknown
`property_account_income_id`	Unknown
`property_stock_inventory`	Json
`property_stock_production`	Json
`public_categ_ids`	Json
`purchase_line_warn`	Unknown
`purchase_line_warn_msg`	Unknown
`purchase_method`	Unknown
`purchase_ok`	Unknown
`purchased_product_qty`	Unknown
`qty_available`	Unknown
`rating_avg`	Unknown
`rating_avg_text`	Unknown
`rating_ids`	Json
`rating_last_feedback`	Unknown
`rating_last_image`	Unknown
`rating_last_text`	Unknown
`rating_last_value`	Unknown
`rating_percentage_satisfaction`	Unknown
`reordering_max_qty`	Unknown
`reordering_min_qty`	Unknown
`responsible_id`	Json
`route_from_categ_ids`	Json
`route_ids`	Json
`sale_delay`	Unknown
`sale_line_warn`	Unknown
`sale_line_warn_msg`	Unknown
`sale_ok`	Unknown
`sales_count`	Unknown
`seller_ids`	Json
`seo_name`	Unknown
`sequence`	Unknown
`service_policy`	Unknown
`service_to_purchase`	Unknown
`service_tracking`	Unknown
`service_type`	Unknown
`service_upsell_threshold`	Unknown
`service_upsell_threshold_ratio`	Unknown
`show_forecasted_qty_status_button`	Unknown
`show_on_hand_qty_status_button`	Unknown
`sla_id`	Unknown
`standard_price`	Unknown
`supplier_taxes_id`	Json
`tariff_head`	Unknown
`tax_string`	Unknown
`taxes_id`	Json
`template_folder_id`	Unknown
`tracking`	Unknown
`type`	Unknown
`uom_id`	Json
`uom_name`	Unknown
`uom_po_id`	Json
`valid_product_template_attribute_line_ids`	Json
`valuation`	Unknown
`variant_seller_ids`	Json
`virtual_available`	Unknown
`visible_expense_policy`	Unknown
`visible_qty_configurator`	Unknown
`volume`	Unknown
`volume_uom_name`	Unknown
`warehouse_id`	Unknown
`website_description`	Unknown
`website_id`	Unknown
`website_message_ids`	Json
`website_meta_description`	Unknown
`website_meta_keywords`	Unknown
`website_meta_og_img`	Unknown
`website_meta_title`	Unknown
`website_published`	Unknown
`website_ribbon_id`	Unknown
`website_sequence`	Unknown
`website_size_x`	Unknown
`website_size_y`	Unknown
`website_url`	Unknown
`weight`	Unknown
`weight_uom_name`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

mail_message_tracking_value_id

Column	Type	Keys
`mail_message_id`	Unknown	PKFK
`tracking_value_id`	Unknown	PKFK

mail_message

Column	Type	Keys
`id`	Unknown	PK
`author_avatar`	Unknown
`author_guest_id`	Unknown
`author_id`	Json
`body`	Unknown
`canned_response_ids`	Json
`create_date`	Unknown
`create_uid`	Json
`date`	Unknown
`description`	Unknown
`display_name`	Unknown
`email_add_signature`	Unknown
`email_from`	Unknown
`email_layout_xmlid`	Unknown
`has_error`	Unknown
`has_sms_error`	Unknown
`is_current_user_or_guest_author`	Unknown
`is_internal`	Unknown
`last_update`	Unknown
`leido`	Unknown
`letter_ids`	Json
`mail_activity_type_id`	Unknown
`mail_ids`	Json
`mail_server_id`	Unknown
`message_id`	Unknown
`message_type`	Unknown
`model`	Unknown
`need_action`	Unknown
`notification_ids`	Json
`notified_partner_ids`	Json
`partner_ids`	Json
`preview`	Unknown
`rating_ids`	Json
`rating_value`	Unknown
`reaction_ids`	Json
`reply_to`	Unknown
`reply_to_force_new`	Unknown
`res_id`	Unknown
`snail_mail_error`	Unknown
`starred`	Unknown
`starred_partner_ids`	Json
`subject`	Unknown
`subtype_id`	Json
`write_date`	LocalDateTime
`write_uid`	Json

customer_invoice

Column	Type	Keys
`customer_id`	Unknown	PKFK
`invoice_id`	Unknown	PKFK

customer_task

Column	Type	Keys
`customer_id`	Unknown	PKFK
`task_id`	Unknown	PKFK

customer_employee

Column	Type	Keys
`customer_id`	Unknown	PKFK
`employee_id`	Unknown	PKFK

customer

Column	Type	Keys
`id`	Unknown	PK
`account_represented_company_ids`	Json
`active`	Unknown
`active_lang_count`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_id`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`allowed_cabys_ids`	Json
`avatar_1024`	Unknown
`avatar_128`	Unknown
`avatar_1920`	Unknown
`avatar_256`	Unknown
`avatar_512`	Unknown
`bank_account_count`	Unknown
`bank_ids`	Json
`barcode`	Unknown
`calendar_last_notif_ack`	Unknown
`can_publish`	Unknown
`category_id`	Json
`certifications_company_count`	Unknown
`certifications_count`	Unknown
`channel_ids`	Json
`child_ids`	Json
`city`	Unknown
`color`	Unknown
`comment`	Unknown
`commercial_company_name`	Unknown
`commercial_name`	Unknown
`commercial_partner_id`	Json
`company_id`	Unknown
`company_name`	Unknown
`company_registry`	Unknown
`company_type`	Unknown
`contact_address`	Unknown
`contact_address_complete`	Unknown
`contract_ids`	Json
`country_code`	Unknown
`country_id`	Json
`county_id`	Json
`create_date`	Unknown
`create_uid`	Json
`credit`	Unknown
`credit_fiscal`	Unknown
`credit_fiscal_compra`	Unknown
`credit_limit`	Unknown
`currency_id`	Json
`customer_rank`	Unknown
`date`	Unknown
`date_expiration`	Unknown
`date_issue`	Unknown
`date_notification`	Unknown
`debit`	Unknown
`debit_limit`	Unknown
`display_name`	Unknown
`district_id`	Json
`document_count`	Unknown
`duplicated_bank_account_partners_count`	Unknown
`economic_activities_ids`	Json
`email`	Unknown
`email_formatted`	Unknown
`email_normalized`	Unknown
`employee`	Unknown
`export`	Unknown
`followup_line_id`	Unknown
`followup_next_action_date`	Unknown
`followup_reminder_type`	Unknown
`followup_responsible_id`	Unknown
`followup_status`	Unknown
`function`	Unknown
`has_exoneration`	Unknown
`has_message`	Unknown
`has_unreconciled_entries`	Unknown
`iap_enrich_info`	Unknown
`iap_search_domain`	Unknown
`identification_id`	Json
`im_status`	Unknown
`image_1024`	Unknown
`image_128`	Unknown
`image_1920`	Unknown
`image_256`	Unknown
`image_512`	Unknown
`image_medium`	Unknown
`industry_id`	Unknown
`institution_name`	Unknown
`invoice_warn`	Unknown
`invoice_warn_msg`	Unknown
`is_blacklisted`	Unknown
`is_coa_installed`	Unknown
`is_company`	Unknown
`is_extra_fronterizo`	Unknown
`is_public`	Unknown
`is_published`	Unknown
`is_seo_optimized`	Unknown
`is_zona_franca`	Unknown
`journal_item_count`	Unknown
`lang`	Unknown
`last_time_entries_checked`	Unknown
`last_update`	Unknown
`last_website_so_id`	Unknown
`meeting_ids`	Json
`message_bounce`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`mobile`	Unknown
`mobile_blacklisted`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`neighborhood_id`	Unknown
`ocn_token`	Unknown
`on_time_rate`	Unknown
`online_partner_information`	Unknown
`opportunity_ids`	Json
`parent_id`	Unknown
`parent_name`	Unknown
`partner_latitude`	Unknown
`partner_longitude`	Unknown
`partner_share`	Unknown
`payment_methods_id`	Json
`payment_token_ids`	Json
`percentage_exoneration`	Unknown
`phone`	Unknown
`phone_blacklisted`	Unknown
`phone_mobile_search`	Unknown
`phone_sanitized`	Unknown
`phone_sanitized_blacklisted`	Unknown
`picking_warn`	Unknown
`picking_warn_msg`	Unknown
`property_account_payable_id`	Json
`property_account_position_id`	Unknown
`property_account_receivable_id`	Json
`property_payment_term_id`	Json
`property_product_pricelist`	Json
`property_purchase_currency_id`	Unknown
`property_stock_customer`	Json
`property_stock_supplier`	Json
`property_supplier_payment_term_id`	Json
`purchase_line_ids`	Json
`purchase_order_count`	Unknown
`purchase_warn`	Unknown
`purchase_warn_msg`	Unknown
`receipt_reminder_email`	Unknown
`ref`	Unknown
`ref_company_ids`	Json
`reminder_date_before_receipt`	Unknown
`sale_order_ids`	Json
`sale_warn`	Unknown
`sale_warn_msg`	Unknown
`same_company_registry_partner_id`	Unknown
`same_vat_partner_id`	Unknown
`self`	Json
`seo_name`	Unknown
`show_credit_limit`	Unknown
`signup_expiration`	Unknown
`signup_token`	Unknown
`signup_type`	Unknown
`signup_url`	Unknown
`signup_valid`	Unknown
`sla_ids`	Json
`slide_channel_completed_ids`	Json
`slide_channel_ids`	Json
`state_id`	Json
`street`	Unknown
`street_2`	Unknown
`supplier_invoice_count`	Unknown
`supplier_rank`	Unknown
`team_id`	Unknown
`ticket_count`	Unknown
`tipo_credit_fiscal`	Unknown
`title`	Unknown
`total_due`	Unknown
`total_invoiced`	Unknown
`total_overdue`	Unknown
`translated_display_name`	Unknown
`trust`	Unknown
`type`	Unknown
`type_exoneration`	Unknown
`tz`	Unknown
`tz_offset`	Unknown
`unpaid_invoice_ids`	Json
`unreconciled_aml_ids`	Json
`use_partner_credit_limit`	Unknown
`user_ids`	Json
`vat`	Unknown
`visitor_ids`	Json
`website`	Unknown
`website_description`	Unknown
`website_id`	Unknown
`website_message_ids`	Json
`website_meta_description`	Unknown
`website_meta_keywords`	Unknown
`website_meta_og_img`	Unknown
`website_meta_title`	Unknown
`website_published`	Unknown
`website_short_description`	Unknown
`website_url`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json
`zip`	Unknown

accounting

Column	Type	Keys
`id`	Unknown	PK
`account_type`	Unknown
`allowed_journal_ids`	Json
`asset_model`	Unknown
`asset_type`	Unknown
`can_create_asset`	Unknown
`code`	Unknown
`company_currency_id`	Json
`company_id`	Json
`create_asset`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`current_balance`	Unknown
`deprecated`	Unknown
`display_name`	Unknown
`exclude_provision_currency_ids`	Json
`form_view_ref`	Unknown
`group_id`	Json
`has_message`	Unknown
`include_initial_balance`	Unknown
`internal_group`	Unknown
`is_off_balance`	Unknown
`last_update`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`multiple_assets_per_line`	Unknown
`name`	Unknown
`non_trade`	Unknown
`note`	Unknown
`opening_balance`	Unknown
`opening_credit`	Unknown
`opening_debit`	Unknown
`reconcile`	Unknown
`related_taxes_amount`	Unknown
`root_id`	Json
`tag_ids`	Json
`tax_ids`	Json
`used`	Unknown
`website_message_ids`	Json
`write_date`	LocalDateTime
`write_uid`	Json

account_tax

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`amount`	Unknown
`amount_type`	Unknown
`analytic`	Unknown
`cash_basis_transition_account_id`	Unknown
`children_tax_ids`	Json
`company_id`	Json
`country_code`	Unknown
`country_id`	Json
`create_date`	Unknown
`create_uid`	Json
`description`	Unknown
`display_name`	Unknown
`has_exoneration`	Unknown
`hide_tax_exigibility`	Unknown
`include_base_amount`	Unknown
`invoice_repartition_line_ids`	Json
`is_base_affected`	Unknown
`iva_tax_code`	Unknown
`iva_tax_desc`	Unknown
`last_update`	Unknown
`name`	Unknown
`name_searchable`	Unknown
`non_tax_deductible`	Unknown
`percentage_exoneration`	Unknown
`price_include`	Unknown
`real_amount`	Unknown
`refund_repartition_line_ids`	Json
`sequence`	Unknown
`tax_code`	Unknown
`tax_exigibility`	Unknown
`tax_group_id`	Json
`tax_root`	Unknown
`tax_scope`	Unknown
`type_tax_use`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

account_asset

Column	Type	Keys
`id`	Unknown	PK
`account_asset_id`	Json
`account_depreciation_expense_id`	Json
`account_depreciation_id`	Json
`account_type`	Unknown
`acquisition_date`	Unknown
`active`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`already_depreciated_amount_import`	Unknown
`analytic_distribution`	Unknown
`analytic_distribution_search`	Unknown
`analytic_precision`	Unknown
`asset_lifetime_days`	Unknown
`asset_paused_days`	Unknown
`asset_type`	Unknown
`book_value`	Unknown
`children_ids`	Json
`company_id`	Json
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`depreciation_entries_count`	Unknown
`depreciation_move_ids`	Json
`display_account_asset_id`	Unknown
`display_name`	Unknown
`disposal_date`	Unknown
`gross_increase_count`	Unknown
`gross_increase_value`	Unknown
`has_message`	Unknown
`journal_id`	Json
`last_update`	Unknown
`message_attachment_count`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_error_counter`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Json
`message_need_action_counter`	Unknown
`message_needaction`	Unknown
`message_partner_ids`	Json
`method`	Unknown
`method_number`	Unknown
`method_period`	Unknown
`method_progress_factor`	Unknown
`model_id`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`non_deductible_tax_value`	Unknown
`original_move_line_ids`	Json
`original_value`	Unknown
`parent_id`	Unknown
`paused_prorata_date`	Unknown
`prorata_computation_type`	Unknown
`prorata_date`	Unknown
`related_purchase_value`	Unknown
`salvage_value`	Unknown
`state`	Unknown
`total_depreciable_value`	Unknown
`total_depreciation_entries_count`	Unknown
`value_residual`	Unknown
`website_message_ids`	Json
`write_date`	LocalDateTime
`write_uid`	Json

task

Column	Type	Keys
`id`	Unknown	PK
`access_token`	Unknown
`access_url`	Unknown
`access_warning`	Unknown
`active`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`allocated_hours`	Unknown
`allocation_type`	Unknown
`allow_billable`	Unknown
`allow_milestones`	Unknown
`allow_recurring_tasks`	Unknown
`allow_subtasks`	Unknown
`allow_task_dependencies`	Unknown
`allow_timesheets`	Unknown
`analytic_account_active`	Unknown
`analytic_account_id`	Json
`ancestor_id`	Unknown
`attachment_ids`	Json
`child_ids`	Json
`child_text`	Unknown
`color`	Unknown
`commercial_partner_id`	Json
`company_id`	Json
`create_date`	Unknown
`create_uid`	Json
`date_assign`	Unknown
`date_deadline`	Unknown
`date_end`	Unknown
`date_last_stage_update`	Unknown
`depend_on_ids`	Json
`dependent_ids`	Json
`description`	Unknown
`display_name`	Unknown
`display_parent_task_button`	Unknown
`display_sale_order_button`	Unknown
`display_timer_pause`	Unknown
`display_timer_resume`	Unknown
`display_timer_start_primary`	Unknown
`display_timer_start_secondary`	Unknown
`display_timer_stop`	Unknown
`display_timesheet_timer`	Unknown
`display_warning_dependency_in_gantt`	Unknown
`displayed_image_id`	Unknown
`document_ids`	Json
`documents_folder_id`	Json
`duration`	Unknown
`effective_hours`	Unknown
`email_cc`	Unknown
`email_from`	Unknown
`encode_uom_in_days`	Unknown
`fri`	Unknown
`has_late_and_unreached_milestone`	Unknown
`has_message`	Unknown
`has_multi_sol`	Unknown
`is_analytic_account_id_changed`	Unknown
`is_blocked`	Unknown
`is_closed`	Unknown
`is_private`	Unknown
`is_project_map_empty`	Unknown
`is_timer_running`	Unknown
`kanban_state`	Unknown
`kanban_state_label`	Unknown
`last_update`	Unknown
`legend_blocked`	Unknown
`legend_done`	Unknown
`legend_normal`	Unknown
`manager_id`	Json
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`milestone_id`	Unknown
`mon`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`overlap_warning`	Unknown
`overtime`	Unknown
`parent_id`	Unknown
`partner_city`	Unknown
`partner_email`	Unknown
`partner_id`	Json
`partner_is_company`	Unknown
`partner_mobile`	Unknown
`partner_phone`	Unknown
`partner_street`	Unknown
`partner_zip`	Unknown
`personal_stage_id`	Json
`personal_stage_type_id`	Json
`personal_stage_type_ids`	Json
`planned_date_begin`	Unknown
`planned_date_end`	Unknown
`planned_hours`	Unknown
`planning_overlap`	Unknown
`portal_effective_hours`	Unknown
`portal_progress`	Unknown
`portal_remaining_hours`	Unknown
`portal_subtask_effective_hours`	Unknown
`portal_user_names`	Unknown
`pricing_type`	Unknown
`priority`	Unknown
`progress`	Unknown
`project_analytic_account_id`	Json
`project_color`	Unknown
`project_privacy_visibility`	Unknown
`project_sale_order_id`	Unknown
`project_use_documents`	Unknown
`rating_active`	Unknown
`rating_avg`	Unknown
`rating_avg_text`	Unknown
`rating_ids`	Json
`rating_last_feedback`	Unknown
`rating_last_image`	Unknown
`rating_last_text`	Unknown
`rating_last_value`	Unknown
`rating_percentage_satisfaction`	Unknown
`recurrence_id`	Json
`recurrence_message`	Unknown
`recurrence_update`	Unknown
`recurring_task`	Json
`remaining_hours`	Unknown
`remaining_hours_available`	Unknown
`remaining_hours_percentage`	Unknown
`remaining_hours_so`	Unknown
`repeat_day`	Unknown
`repeat_interval`	Unknown
`repeat_month`	Unknown
`repeat_on_month`	Unknown
`repeat_on_year`	Unknown
`repeat_show_day`	Unknown
`repeat_show_dow`	Unknown
`repeat_show_month`	Unknown
`repeat_show_week`	Unknown
`repeat_type`	Unknown
`repeat_unit`	Unknown
`repeat_until`	Unknown
`repeat_week`	Unknown
`repeat_weekday`	Unknown
`sale_line_id`	Json
`sale_order_id`	Json
`sat`	Unknown
`sequence`	Unknown
`shared_document_ids`	Json
`so_analytic_account_id`	Unknown
`stage_id`	Json
`subtask_count`	Unknown
`subtask_effective_hours`	Unknown
`subtask_planned_hours`	Unknown
`sun`	Unknown
`tag_ids`	Json
`task_properties`	Json
`task_to_invoice`	Unknown
`thu`	Unknown
`timer_pause`	Unknown
`timer_start`	Unknown
`timesheet_ids`	Json
`timesheet_product_id`	Json
`tue`	Unknown
`user_ids`	Json
`user_names`	Unknown
`user_timer_id`	Json
`website_message_ids`	Json
`wed`	Unknown
`working_days_close`	Unknown
`working_days_open`	Unknown
`working_hours_close`	Unknown
`working_hours_open`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

project_task

Column	Type	Keys
`project_id`	Unknown	PKFK
`task_id`	Unknown	PKFK

project_sale_line_employee

Column	Type	Keys
`sale_line_employee_id`	Unknown	PK
`project_id`	Unknown	PKFK
`employee_id`	Unknown	FK

project

Column	Type	Keys
`id`	Unknown	PK
`access_instruction_message`	Unknown
`access_token`	Unknown
`access_url`	Unknown
`access_warning`	Unknown
`active`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`alias_bounced_content`	Unknown
`alias_contact`	Unknown
`alias_defaults`	Unknown
`alias_domain`	Unknown
`alias_enabled`	Unknown
`alias_force_thread_id`	Unknown
`alias_id`	Json
`alias_model_id`	Json
`alias_name`	Unknown
`alias_parent_model_id`	Json
`alias_parent_thread_id`	Unknown
`alias_user_id`	Json
`alias_value`	Unknown
`allocated_hours`	Unknown
`allow_billable`	Unknown
`allow_milestones`	Unknown
`allow_rating`	Unknown
`allow_recurring_tasks`	Unknown
`allow_subtasks`	Unknown
`allow_task_dependencies`	Unknown
`allow_timesheets`	Unknown
`analytic_account_balance`	Unknown
`analytic_account_id`	Json
`assets_count`	Unknown
`billable_percentage`	Unknown
`collaborator_ids`	Json
`color`	Unknown
`commercial_partner_id`	Unknown
`company_id`	Json
`contracts_count`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`date`	Unknown
`date_start`	Unknown
`description`	Unknown
`display_create_order`	Unknown
`display_name`	Unknown
`doc_count`	Unknown
`documents_folder_id`	Json
`documents_tag_ids`	Json
`encode_uom_in_days`	Unknown
`favorite_user_ids`	Json
`has_any_so_to_invoice`	Unknown
`has_any_so_with_nothing_to_invoice`	Unknown
`has_helpdesk_team`	Unknown
`has_message`	Unknown
`helpdesk_team`	Json
`invoice_count`	Unknown
`is_favorite`	Unknown
`is_internal_project`	Unknown
`is_milestone_exceeded`	Unknown
`is_project_overtime`	Unknown
`label_tasks`	Unknown
`last_update`	Unknown
`last_update_color`	Unknown
`last_update_id`	Unknown
`last_update_status`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Json
`message_need_action`	Unknown
`message_partner_ids`	Json
`milestone_ids`	Json
`my_activity_date_deadline`	Unknown
`name`	Unknown
`partner_email`	Unknown
`partner_id`	Unknown
`partner_phone`	Unknown
`pricing_type`	Unknown
`privacy_visibility`	Unknown
`privacy_visibility_warning`	Unknown
`purchase_orders_count`	Unknown
`rating_active`	Unknown
`rating_avg`	Unknown
`rating_avg_percentage`	Unknown
`rating_ids`	Json
`rating_percentage_satisfaction`	Unknown
`rating_request_deadline`	Unknown
`rating_status`	Unknown
`rating_status_period`	Unknown
`remaining_hours`	Unknown
`resource_calendar_id`	Json
`sale_line_id`	Json
`sale_order_id`	Json
`sequence`	Unknown
`shared_document_ids`	Json
`tag_ids`	Json
`task_count_with_subtasks`	Unknown
`task_properties_definition`	Json
`ticket_ids`	Json
`timesheet_encode_uom_id`	Json
`timesheet_ids`	Json
`timesheet_product_id`	Json
`total_timesheet_time`	Unknown
`type_ids`	Json
`update_ids`	Json
`use_documents`	Unknown
`user_id`	Json
`vendor_bill_count`	Unknown
`warning_employee_rate`	Unknown
`website_message_ids`	Json
`write_date`	LocalDateTime
`write_uid`	Json

employee

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`additional_note`	Unknown
`address_home_id`	Unknown
`address_id`	Json
`avatar_1024`	Unknown
`avatar_128`	Unknown
`avatar_1920`	Unknown
`avatar_256`	Unknown
`avatar_512`	Unknown
`badge_ids`	Json
`bank_account_id`	Unknown
`barcode`	Unknown
`birthday`	Unknown
`calendar_mismatch`	Unknown
`category_ids`	Json
`certificate`	Unknown
`child_all_count`	Unknown
`child_ids`	Json
`children`	Unknown
`coach_id`	Json
`color`	Unknown
`company_country_code`	Unknown
`company_country_id`	Json
`company_id`	Json
`contract_ids`	Json
`contract_warning`	Unknown
`country_id`	Unknown
`country_of_birth`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`department_id`	Json
`departure_date`	Unknown
`departure_description`	Unknown
`departure_reason_id`	Unknown
`direct_badge_ids`	Json
`display_name`	Unknown
`document_share_id`	Json
`driving_license`	Unknown
`emergency_contact`	Unknown
`emergency_phone`	Unknown
`employee_type`	Unknown
`first_contract_date`	Unknown
`gender`	Unknown
`goal_ids`	Json
`has_badges`	Unknown
`has_message`	Unknown
`has_work_permit`	Unknown
`hourly_cost`	Unknown
`hr_icon_display`	Unknown
`hr_presence_state`	Unknown
`id_card`	Unknown
`identification_id`	Unknown
`image_1024`	Unknown
`image_128`	Unknown
`image_1920`	Unknown
`image_256`	Unknown
`image_512`	Unknown
`internet_invoice`	Unknown
`is_address_home_a_company`	Unknown
`job_id`	Unknown
`job_title`	Unknown
`km_home_work`	Unknown
`lang`	Unknown
`last_activity`	Unknown
`last_activity_time`	Unknown
`last_update`	Unknown
`last_validated_timesheet_date`	Unknown
`marital`	Unknown
`member_of_department`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`mobile_invoice`	Unknown
`mobile_phone`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`notes`	Unknown
`parent_id`	Unknown
`passport_id`	Unknown
`permit_no`	Unknown
`phone`	Unknown
`pin`	Unknown
`place_of_birth`	Unknown
`private_email`	Unknown
`related_contact_ids`	Json
`related_contacts_count`	Unknown
`resource_calendar_id`	Json
`resource_id`	Json
`salary_attachment_ids`	Json
`show_hr_icon_display`	Unknown
`sim_card`	Unknown
`sin_id`	Unknown
`slip_ids`	Json
`spouse_birthdate`	Unknown
`spouse_complete_name`	Unknown
`ssn_id`	Unknown
`study_field`	Unknown
`study_school`	Unknown
`subordinate_ids`	Json
`timesheet_manager_id`	Json
`tz`	Unknown
`user_id`	Json
`user_partner_id`	Json
`vehicle`	Unknown
`visa_expire`	Unknown
`visa_no`	Unknown
`website_message_ids`	Json
`work_contact_id`	Json
`work_email`	Unknown
`work_location_id`	Unknown
`work_permit_expiration_date`	Unknown
`work_permit_name`	Unknown
`work_permit_scheduled_activity`	Unknown
`work_phone`	Unknown
`write_date`	LocalDateTime
`write_uid`	Json

invoice_payment

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`payment_id`	Unknown	PKFK

invoice

Column	Type	Keys
`id`	Unknown	PK
`access_token`	Unknown
`access_url`	Unknown
`access_warning`	Unknown
`activity_calendar_event_id`	Unknown
`activity_date_deadline`	Unknown
`activity_exception_decoration`	Unknown
`activity_exception_icon`	Unknown
`activity_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`always_tax_exigible`	Unknown
`amount_paid`	Unknown
`amount_residual`	Unknown
`amount_residual_signed`	Unknown
`amount_tax`	Unknown
`amount_tax_electronic_invoice`	Unknown
`amount_tax_signed`	Unknown
`amount_untaxed`	Unknown
`amount_untaxed_signed`	Unknown
`asset_asset_type`	Unknown
`asset_depreciated_value`	Unknown
`asset_depreciation_beginning_date`	Unknown
`asset_id_display_name`	Unknown
`asset_ids`	Json
`asset_number_days`	Unknown
`asset_remaining_value`	Unknown
`asset_value_change`	Unknown
`attachment_ids`	Json
`authorized_transaction_ids`	Json
`auto_post`	Unknown
`auto_post_origin_id`	Unknown
`auto_post_until`	Unknown
`bank_partner_id`	Json
`c_sin_imp`	Unknown
`campaign_id`	Unknown
`commercial_partner_id`	Unknown
`company_currency_id`	Json
`company_id`	Json
`company_vat`	Unknown
`consecutive_number_receiver`	Unknown
`country_code`	Unknown
`create_date`	Unknown
`create_uid`	Json
`credit_fiscal`	Unknown
`csi_articulo`	Unknown
`csi_inciso`	Unknown
`csi_ley`	Unknown
`currency_id`	Json
`date`	Unknown
`date_issuance`	Unknown
`declaracion_company_state`	Json
`depreciation_value`	Unknown
`direction_sign`	Unknown
`display_inactive_currency_warning`	Unknown
`display_name`	Unknown
`display_qr_code`	Unknown
`draft_asset_ids`	Unknown
`duplicated_ref_ids`	Json
`economic_activities_ids`	Json
`economic_activity_id`	Unknown
`economic_activity_id_invoice`	Unknown
`edi_blocking_level`	Unknown
`edi_document_ids`	Json
`edi_error_count`	Unknown
`edi_error_message`	Unknown
`edi_show_abandon_cancel_button`	Unknown
`edi_show_cancel_button`	Unknown
`edi_state`	Unknown
`edi_web_services_to_process`	Unknown
`electronic_invoice_return_message`	Unknown
`error_count`	Unknown
`estado_declaracion_hacienda`	Unknown
`fiscal_position_id`	Unknown
`fname_xml_comprobante`	Unknown
`fname_xml_respuesta_tributacion`	Unknown
`fname_xml_supplier_approval`	Unknown
`gasto_no_dedu`	Unknown
`has_message`	Unknown
`has_reconciled_entries`	Unknown
`hide_post_button`	Unknown
`highest_name`	Unknown
`inalterable_hash`	Unknown
`invoice_amount_text`	Unknown
`invoice_cash_rounding_id`	Unknown
`invoice_date`	Unknown
`invoice_date_due`	Unknown
`invoice_filter_type_domain`	Unknown
`invoice_has_outstanding`	Unknown
`invoice_id`	Unknown
`invoice_incoterm_id`	Unknown
`invoice_line_ids`	Json
`invoice_origin`	Unknown
`invoice_outstanding_credits_debits_widget`	Unknown
`invoice_partner_display_name`	Unknown
`invoice_payment_term_id`	Unknown
`invoice_payments_widget`	Unknown
`invoice_source_email`	Unknown
`invoice_user_id`	Unknown
`invoice_vendor_bill_id`	Unknown
`is_move_sent`	Unknown
`is_storno`	Unknown
`journal_id`	Json
`last_update`	Unknown
`line_ids`	Json
`linked_asset_type`	Unknown
`made_sequence_hole`	Unknown
`medium_id`	Unknown
`message_follower_ids`	Json
`message_has_error`	Unknown
`message_has_sms_error`	Unknown
`message_ids`	Json
`message_is_follower`	Unknown
`message_main_attachment_id`	Unknown
`message_need_action`	Unknown
`message_partner_ids`	Json
`move_type`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`narration`	Unknown
`needed_terms_dirty`	Unknown
`not_loaded_invoice`	Unknown
`not_loaded_invoice_date`	Unknown
`number_asset_ids`	Unknown
`number_electronic`	Unknown
`partner_bank_id`	Unknown
`partner_credit_warning`	Unknown
`partner_id`	Unknown
`partner_shipping_id`	Unknown
`partner_vat`	Unknown
`payment_methods_id`	Unknown
`payment_reference`	Unknown
`payment_state`	Unknown
`payment_state_before_switch`	Unknown
`posted_before`	Unknown
`purchase_id`	Json
`purchase_order_count`	Unknown
`purchase_vendor_bill_id`	Unknown
`qr_code_method`	Unknown
`qr_image`	Unknown
`quick_edit_mode`	Unknown
`ref`	Unknown
`reference_code_id`	Unknown
`reference_document_id`	Unknown
`restrict_mode_hash_table`	Unknown
`reversal_move_id`	Json
`reversed_entry_id`	Unknown
`sale_order_count`	Unknown
`sequence`	Unknown
`sequence_number`	Unknown
`sequence_prefix`	Unknown
`show_discount_details`	Unknown
`show_name_warning`	Unknown
`show_payment_term_details`	Unknown
`show_reset_to_draft_button`	Unknown
`source_id`	Unknown
`state`	Unknown
`state_email`	Unknown
`state_invoice_partner`	Unknown
`state_send_invoice`	Unknown
`state_tributacion`	Unknown
`statement_line_id`	Unknown
`statement_line_ids`	Json
`stock_move_id`	Unknown
`stock_valuation_layer_ids`	Json
`string_to_hash`	Unknown
`subto`	Unknown
`suitable_journal_ids`	Json
`suspense_statement_line_id`	Unknown
`tax_cash_basis_created_move_ids`	Json
`tax_cash_basis_origin_move_id`	Unknown
`tax_cash_basis_rec_id`	Unknown
`tax_closing_end_date`	Unknown
`tax_country_code`	Unknown
`tax_country_id`	Json
`tax_lock_date_message`	Unknown
`tax_report_control_error`	Unknown
`team_id`	Json
`timesheet_encode_uom_id`	Json
`timesheet_ids`	Json
`timesheet_total_duration`	Unknown
`tipo_documento`	Unknown
`tipo_gasto_no_dedu`	Unknown
`to_check`	Unknown
`transaction_ids`	Json
`transfer_model_id`	Unknown
`type_name`	Unknown
`usd_currency_id`	Json
`usd_currency_rate`	Unknown
`user_id`	Unknown
`venta_aut_sin_imp`	Unknown
`venta_exentas`	Unknown
`venta_no_sujeta`	Unknown
`visibilidad_declaracion`	Unknown
`website_id`	Unknown
`website_message_ids`	Json
`write_date`	LocalDateTime
`write_uid`	Json
`xml_comprobante`	Unknown
`xml_respuesta_tributacion`	Unknown
`xml_supplier_approval`	Unknown

sale_report

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`product_id`	Unknown	FK
`analytic_account_id`	Unknown
`avg_days_to_confirm`	Unknown
`campaign_id`	Unknown
`categ_id`	Json
`commercial_partner_id`	Json
`company_id`	Json
`country_id`	Json
`date`	LocalDateTime
`discount`	Unknown
`discount_amount`	Unknown
`display_name`	Unknown
`industry_id`	Unknown
`invoice_status`	Unknown
`is_abandoned_cart`	Unknown
`last_update`	Unknown
`margin`	Unknown
`medium_id`	Unknown
`name`	Unknown
`nbr`	Unknown
`partner_id`	Json
`price_subtotal`	Unknown
`price_total`	Unknown
`pricelist_id`	Json
`product_tmpl_id`	Json
`product_uom`	Unknown
`product_uom_qty`	Unknown
`qty_delivered`	Unknown
`qty_invoiced`	Unknown
`qty_to_deliver`	Unknown
`qty_to_invoice`	Unknown
`source_id`	Unknown
`state`	Unknown
`team_id`	Json
`untaxed_amount_invoiced`	Unknown
`untaxed_amount_to_invoice`	Unknown
`user_id`	Json
`volume`	Unknown
`website_id`	Unknown
`weight`	Unknown