# Odoo schema ERD

Table and field reference for the Fivetran Odoo connector.

## Table & Field Reference

### reconciled_invoice

| Column | Type | Keys |
| --- | --- | --- |
| payment_id | Unknown | PK, FK |
| reconciled_invoice_id | Unknown | PK, FK |

### 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 | PK, FK |
| sale_order_id | Unknown | PK, FK |

### sale_order_task

| Column | Type | Keys |
| --- | --- | --- |
| sale_order_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### sale_order_project

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| sale_order_id | Unknown | PK, FK |

### 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 | PK, FK |
| defaults | Unknown |  |
| name | Unknown |  |
| string | Unknown |  |
| type | Unknown |  |

### crm_lead_order

| Column | Type | Keys |
| --- | --- | --- |
| crm_lead_id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |

### 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 | PK, FK |
| tracking_value_id | Unknown | PK, FK |

### 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 | PK, FK |
| invoice_id | Unknown | PK, FK |

### customer_task

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### customer_employee

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| employee_id | Unknown | PK, FK |

### 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 | PK, FK |
| task_id | Unknown | PK, FK |

### project_sale_line_employee

| Column | Type | Keys |
| --- | --- | --- |
| sale_line_employee_id | Unknown | PK |
| project_id | Unknown | PK, FK |
| 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 | PK, FK |
| payment_id | Unknown | PK, FK |

### 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 |  |

## Relationships

- reconciled_invoice(reconciled_invoice_id) → invoice(id)
- reconciled_invoice(payment_id) → payment(id)
- payment(outstanding_account_id) → accounting(id)
- payment(destination_account_id) → accounting(id)
- sale_order_invoice(invoice_id) → invoice(id)
- sale_order_invoice(sale_order_id) → sale_order(id)
- sale_order_task(task_id) → task(id)
- sale_order_task(sale_order_id) → sale_order(id)
- sale_order_project(project_id) → project(id)
- sale_order_project(sale_order_id) → sale_order(id)
- crm_lead_property(crm_lead_id) → crm_lead(id)
- crm_lead_order(order_id) → sale_order(id)
- crm_lead_order(crm_lead_id) → crm_lead(id)
- mail_message_tracking_value_id(tracking_value_id) → mail_tracking_value(id)
- mail_message_tracking_value_id(mail_message_id) → mail_message(id)
- customer_invoice(invoice_id) → invoice(id)
- customer_invoice(customer_id) → customer(id)
- customer_task(task_id) → task(id)
- customer_task(customer_id) → customer(id)
- customer_employee(employee_id) → employee(id)
- customer_employee(customer_id) → customer(id)
- project_task(task_id) → task(id)
- project_task(project_id) → project(id)
- project_sale_line_employee(employee_id) → employee(id)
- project_sale_line_employee(project_id) → project(id)
- invoice_payment(payment_id) → payment(id)
- invoice_payment(invoice_id) → invoice(id)
- sale_report(product_id) → product(id)
- sale_report(order_id) → sale_order(id)