Odoo

Explore the interactive ERD

Table & Field Reference

stock_warehouse

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`buy_pull_id`	Json
`buy_to_resupply`	Unknown
`code`	Unknown
`company_id`	Json
`create_date`	Unknown
`create_uid`	Json
`delivery_route_id`	Json
`delivery_steps`	Unknown
`display_name`	Unknown
`fulfillment_center_ids`	Json
`in_type_id`	Json
`int_type_id`	Json
`is_fba_warehouse`	Unknown
`lot_stock_id`	Json
`manu_type_id`	Json
`manufacture_mto_pull_id`	Json
`manufacture_pull_id`	Json
`manufacture_steps`	Unknown
`manufacture_to_resupply`	Unknown
`mto_pull_id`	Json
`name`	Unknown
`out_type_id`	Json
`pack_type_id`	Json
`partner_id`	Json
`pbm_loc_id`	Json
`pbm_mto_pull_id`	Json
`pbm_route_id`	Json
`pbm_type_id`	Json
`pick_type_id`	Json
`qc_type_id`	Json
`reception_route_id`	Json
`reception_steps`	Unknown
`resupply_route_ids`	Json
`resupply_wh_ids`	Json
`route_ids`	Json
`sam_loc_id`	Json
`sam_rule_id`	Unknown
`sam_type_id`	Json
`seller_id`	Json
`sequence`	Unknown
`store_type_id`	Json
`tiktok_shop_id`	Unknown
`tiktok_warehouse_id`	Unknown
`unsellable_location_id`	Json
`view_location_id`	Json
`wh_input_stock_loc_id`	Json
`wh_output_stock_loc_id`	Json
`wh_pack_stock_loc_id`	Json
`wh_qc_stock_loc_id`	Json
`write_date`	Instant
`write_uid`	Json
`xdock_type_id`	Json

accounting

Column	Type	Keys
`id`	Unknown	PK
`account_status`	Json
`account_stock_expense_id`	Unknown
`account_stock_variation_id`	Unknown
`account_type`	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
`asset_model_ids`	Json
`audit_balance`	Unknown
`audit_balance_show_warning`	Unknown
`audit_credit`	Unknown
`audit_debit`	Unknown
`audit_previous_balance`	Unknown
`audit_previous_balance_show_warning`	Unknown
`audit_status`	Unknown
`audit_var_n_1`	Unknown
`audit_var_percentage`	Unknown
`budget_item_ids`	Json
`can_create_asset`	Unknown
`code`	Unknown
`code_mapping_ids`	Json
`code_store`	Unknown
`company_currency_id`	Json
`company_fiscal_country_code`	Unknown
`company_ids`	Json
`create_asset`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Unknown
`current_balance`	Unknown
`current_rate`	Unknown
`description`	Unknown
`display_mapping_tab`	Unknown
`display_name`	Unknown
`exclude_provision_currency_ids`	Json
`fiscal_category_id`	Unknown
`form_view_ref`	Unknown
`group_id`	Unknown
`has_message`	Unknown
`include_initial_balance`	Unknown
`internal_group`	Unknown
`last_message`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`multiple_assets_per_line`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`non_trade`	Unknown
`note`	Unknown
`opening_balance`	Unknown
`opening_credit`	Unknown
`opening_debit`	Unknown
`placeholder_code`	Unknown
`rate_ids`	Json
`rating_ids`	Json
`reconcile`	Unknown
`related_taxes_amount`	Unknown
`root_id`	Json
`tag_ids`	Json
`tax_ids`	Json
`used`	Unknown
`website_message_ids`	Json
`write_date`	Instant
`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_id`	Json
`field_info`	Unknown
`mail_message_id`	Json
`new_value_char`	Unknown
`new_value_datetime`	Unknown
`new_value_float`	Unknown
`new_value_integer`	Unknown
`new_value_text`	Unknown
`old_value_char`	Unknown
`old_value_datetime`	Unknown
`old_value_float`	Unknown
`old_value_integer`	Unknown
`old_value_text`	Unknown
`write_date`	Instant
`write_uid`	Json

employee

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`active_employee`	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_id`	Json
`allowed_country_state_ids`	Json
`avatar_1024`	Unknown
`avatar_128`	Unknown
`avatar_1920`	Unknown
`avatar_256`	Unknown
`avatar_512`	Unknown
`bank_account_ids`	Json
`barcode`	Unknown
`birthday`	Unknown
`birthday_public_display`	Unknown
`birthday_public_display_string`	Unknown
`category_ids`	Json
`certificate`	Unknown
`certification_ids`	Json
`child_ids`	Json
`children`	Unknown
`coach_id`	Unknown
`color`	Unknown
`company_country_code`	Unknown
`company_country_id`	Json
`company_id`	Json
`contract_date_end`	Unknown
`contract_date_start`	Unknown
`contract_template_id`	Unknown
`contract_type_id`	Unknown
`contract_wage`	Unknown
`country_code`	Unknown
`country_id`	Unknown
`country_of_birth`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`current_date_version`	Unknown
`current_employee_skill_ids`	Json
`current_version_id`	Json
`date_end`	Unknown
`date_start`	Unknown
`date_version`	Unknown
`department_color`	Unknown
`department_id`	Json
`departure_date`	Unknown
`departure_description`	Unknown
`departure_reason_id`	Unknown
`display_certification_page`	Unknown
`display_name`	Unknown
`distance_home_work`	Unknown
`distance_home_work_unit`	Unknown
`driving_license`	Unknown
`email`	Unknown
`emergency_contact`	Unknown
`emergency_phone`	Unknown
`employee_id`	Json
`employee_properties`	Json
`employee_skill_ids`	Json
`employee_type`	Unknown
`exceptional_location_id`	Unknown
`friday_location_id`	Unknown
`has_message`	Unknown
`has_multiple_bank_accounts`	Unknown
`has_work_permit`	Unknown
`hourly_cost`	Unknown
`hr_icon_display`	Unknown
`hr_presence_state`	Unknown
`hr_responsible_id`	Json
`id_card`	Unknown
`identification_id`	Unknown
`im_status`	Unknown
`image_1024`	Unknown
`image_128`	Unknown
`image_1920`	Unknown
`image_256`	Unknown
`image_512`	Unknown
`is_current`	Unknown
`is_custom_job_title`	Unknown
`is_flexible`	Unknown
`is_fully_flexible`	Unknown
`is_future`	Unknown
`is_in_contract`	Unknown
`is_past`	Unknown
`is_subordinate`	Unknown
`is_trusted_bank_account`	Unknown
`is_user_active`	Unknown
`job_id`	Unknown
`job_title`	Unknown
`km_home_work`	Unknown
`lang`	Unknown
`last_activity`	Unknown
`last_activity_time`	Unknown
`last_modified_date`	Unknown
`last_modified_uid`	Json
`legal_name`	Unknown
`marital`	Unknown
`member_of_department`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`mobile_phone`	Unknown
`monday_location_id`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`newly_hired`	Unknown
`parent_id`	Unknown
`passport_expiration_date`	Unknown
`passport_id`	Unknown
`permit_no`	Unknown
`phone`	Unknown
`pin`	Unknown
`place_of_birth`	Unknown
`primary_bank_account_id`	Unknown
`private_car_plate`	Unknown
`private_city`	Unknown
`private_country_id`	Unknown
`private_email`	Unknown
`private_phone`	Unknown
`private_state_id`	Unknown
`private_street`	Unknown
`private_street_2`	Unknown
`private_zip`	Unknown
`rating_ids`	Json
`related_partners_count`	Unknown
`resource_calendar_id`	Json
`resource_id`	Json
`resume_line_ids`	Json
`salary_distribution`	Unknown
`saturday_location_id`	Unknown
`sex`	Unknown
`share`	Unknown
`show_hr_icon_display`	Unknown
`skill_ids`	Json
`spouse_birthdate`	Unknown
`spouse_complete_name`	Unknown
`ssnid`	Unknown
`structure_type_id`	Json
`study_field`	Unknown
`study_school`	Unknown
`subordinate_ids`	Json
`sunday_location_id`	Unknown
`thursday_location_id`	Unknown
`today_location_name`	Unknown
`trial_date_end`	Unknown
`tuesday_location_id`	Unknown
`tz`	Unknown
`user_id`	Json
`user_partner_id`	Json
`version_id`	Json
`version_ids`	Json
`version_revision`	Unknown
`visa_expire`	Unknown
`visa_no`	Unknown
`wage`	Unknown
`website_message_ids`	Json
`wednesday_location_id`	Unknown
`work_contact_id`	Json
`work_email`	Unknown
`work_location_id`	Unknown
`work_location_name`	Unknown
`work_location_type`	Unknown
`work_permit_expiration_date`	Unknown
`work_permit_name`	Unknown
`work_permit_scheduled_activity`	Unknown
`work_phone`	Unknown
`write_date`	Instant
`write_uid`	Json

stock_quant

Column	Type	Keys
`id`	Unknown	PK
`accounting_date`	Unknown
`amazon_instance_id`	Unknown
`available_quantity`	Unknown
`company_id`	Json
`cost_method`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`cyclic_inventory_frequency`	Unknown
`display_name`	Unknown
`dummy_id`	Unknown
`fba_live_stock_report_id`	Unknown
`image_1920`	Unknown
`in_date`	Unknown
`inventory_date`	Unknown
`inventory_diff_quantity`	Unknown
`inventory_quantity`	Unknown
`inventory_quantity_auto_apply`	Unknown
`inventory_quantity_set`	Unknown
`is_favorite`	Unknown
`is_outdated`	Unknown
`last_count_date`	Unknown
`location_id`	Json
`lot_id`	Unknown
`lot_properties`	Json
`on_hand`	Unknown
`owner_id`	Unknown
`package_id`	Unknown
`product_categ_id`	Json
`product_id`	Json
`product_reference_code`	Unknown
`product_tmpl_id`	Json
`product_uom_id`	Json
`quantity`	Unknown
`reserved_quantity`	Unknown
`sn_duplicated`	Unknown
`storage_category_id`	Unknown
`tracking`	Unknown
`user_id`	Unknown
`value`	Unknown
`warehouse_id`	Json
`write_date`	Instant
`write_uid`	Json

account_analytic_line

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	FK
`product_id`	Unknown	FK
`account_id`	Unknown
`amount`	Unknown
`analytic_coverage`	Unknown
`analytic_distribution`	Json
`analytic_precision`	Unknown
`analytic_profitability`	Unknown
`auto_account_id`	Unknown
`category`	Unknown
`code`	Unknown
`company_id`	Json
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`date`	Unknown
`display_name`	Unknown
`fiscal_year_search`	Unknown
`general_account_id`	Json
`journal_id`	Json
`move_line_id`	Json
`name`	Unknown
`partner_id`	Json
`product_category`	Unknown
`product_uom_id`	Unknown
`ref`	Unknown
`so_line`	Unknown
`unit_amount`	Unknown
`user_id`	Json
`write_date`	Instant
`write_uid`	Json
`x_plan_2_id`	Unknown
`x_plan_3_id`	Unknown
`x_plan_4_id`	Json
`x_plan_5_id`	Json
`x_plan_6_id`	Unknown
`x_plan_7_id`	Unknown
`x_plan_8_id`	Unknown

stock_picking

Column	Type	Keys
`id`	Unknown	PK
`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
`allowed_carrier_ids`	Json
`amazon_purchase_date`	Unknown
`amazon_removal_transfer_id`	Unknown
`amazon_shipment_date`	Unknown
`amazon_shipment_id`	Unknown
`are_cases_required`	Unknown
`backorder_id`	Unknown
`backorder_ids`	Json
`buyer_cancellation_reason`	Unknown
`buyer_requested_cancellation`	Unknown
`carrier_id`	Json
`carrier_name_in_file`	Unknown
`carrier_price`	Unknown
`carrier_tracking_ref`	Unknown
`carrier_tracking_url`	Unknown
`company_id`	Json
`country_code`	Unknown
`cr_handover_method`	Unknown
`create_date`	Unknown
`create_uid`	Json
`date_deadline`	Unknown
`date_done`	Unknown
`days_to_arrive`	Unknown
`delay_alert_date`	Unknown
`delay_pass`	Unknown
`delivery_type`	Unknown
`destination_country_code`	Unknown
`display_name`	Unknown
`estimated_arrival_date`	Unknown
`feed_submission_id`	Unknown
`fulfill_center`	Unknown
`has_deadline_issue`	Unknown
`has_kits`	Unknown
`has_message`	Unknown
`has_scrap_move`	Unknown
`has_tracking`	Unknown
`inbound_ship_data_created`	Unknown
`inbound_ship_updated`	Unknown
`integration_level`	Unknown
`is_cancelled_in_shopify`	Unknown
`is_date_editable`	Unknown
`is_fba_wh_picking`	Unknown
`is_locked`	Unknown
`is_manually_action_shopify_fulfillment`	Unknown
`is_return_picking`	Unknown
`is_shopify_delivery_order`	Unknown
`is_shopify_return_picking`	Unknown
`is_signed`	Unknown
`json_popover`	Unknown
`location_dest_id`	Json
`location_id`	Json
`lot_id`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`move_ids`	Json
`move_line_ids`	Json
`move_type`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`new_odoo_awd_shipment_id`	Unknown
`new_odoo_shipment_id`	Unknown
`new_ship_plan_id`	Unknown
`new_total_received_qty`	Unknown
`new_total_shipped_qty`	Unknown
`note`	Unknown
`odoo_shipment_id`	Unknown
`old_shipment_pick_done_by`	Unknown
`origin`	Unknown
`owner_id`	Unknown
`package_history_ids`	Json
`packages_count`	Unknown
`partner_country_id`	Json
`partner_id`	Json
`picking_properties`	Json
`picking_type_code`	Unknown
`picking_type_entire_packs`	Unknown
`picking_type_id`	Json
`picking_warning_text`	Unknown
`printed`	Unknown
`priority`	Unknown
`product_id`	Json
`production_group_id`	Unknown
`production_ids`	Json
`products_availability`	Unknown
`products_availability_state`	Unknown
`purchase_id`	Unknown
`rating_ids`	Json
`reference_ids`	Json
`removal_order_id`	Unknown
`removal_order_report_id`	Unknown
`removal_picking_id`	Unknown
`removal_transfer_report_id`	Unknown
`return_id`	Unknown
`return_ids`	Json
`return_label_ids`	Json
`sale_id`	Unknown
`scheduled_date`	Unknown
`search_date_category`	Unknown
`seller_id`	Unknown
`ship_label_preference`	Unknown
`ship_plan_id`	Unknown
`shipment_pick_done_by`	Unknown
`shipment_status`	Unknown
`shipping_volume`	Unknown
`shipping_weight`	Unknown
`shopify_fulfillment_id`	Unknown
`shopify_instance_id`	Json
`shopify_return_id`	Unknown
`show_allocation`	Unknown
`show_check_availability`	Unknown
`show_lots_text`	Unknown
`show_next_pickings`	Unknown
`show_operations`	Unknown
`signature`	Unknown
`state`	Unknown
`stock_adjustment_report_id`	Unknown
`total_received_qty`	Unknown
`total_shipped_qty`	Unknown
`updated_in_amazon`	Unknown
`updated_in_shopify`	Unknown
`use_create_lots`	Unknown
`use_existing_lots`	Unknown
`user_id`	Unknown
`warehouse_address_id`	Json
`website_id`	Unknown
`website_message_ids`	Json
`weight`	Unknown
`weight_bulk`	Unknown
`weight_uom_name`	Unknown
`write_date`	Instant
`write_uid`	Json

sale_order_line

Column	Type	Keys
`id`	Unknown	PK
`allowed_uom_ids`	Json
`amazon_order_item_id`	Unknown
`amazon_order_qty`	Unknown
`amazon_product_id`	Unknown
`amazon_shipment_item_id`	Unknown
`amount_invoiced`	Unknown
`amount_to_invoice`	Unknown
`amount_to_invoice_at_date`	Unknown
`amz_gift_wrapper_charge`	Unknown
`amz_gift_wrapper_tax`	Unknown
`amz_instance_id`	Unknown
`amz_order_line_ref`	Unknown
`amz_order_line_tax`	Unknown
`amz_promotion_discount`	Unknown
`amz_return_reason`	Unknown
`amz_shipping_charge_ept`	Unknown
`amz_shipping_charge_tax`	Unknown
`amz_shipping_discount_ept`	Unknown
`analytic_distribution`	Unknown
`analytic_line_ids`	Json
`analytic_precision`	Unknown
`available_product_document_ids`	Json
`calendar_booking_ids`	Json
`calendar_event_id`	Unknown
`categ_id`	Json
`collapse_composition`	Unknown
`collapse_price`	Unknown
`combo_item_id`	Unknown
`company_id`	Json
`company_price_include`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`customer_lead`	Unknown
`deferred_revenue`	Unknown
`discount`	Unknown
`display_name`	Unknown
`display_qty_widget`	Unknown
`display_type`	Unknown
`distribution_analytic_account_ids`	Json
`event_id`	Unknown
`event_slot_id`	Unknown
`event_ticket_id`	Unknown
`extra_tax_data`	Unknown
`forecast_expected_date`	Unknown
`free_qty_today`	Unknown
`invoice_lines`	Json
`invoice_status`	Unknown
`invoice_to_be_issued`	Unknown
`is_configurable_product`	Unknown
`is_delivery`	Unknown
`is_downpayment`	Unknown
`is_expense`	Unknown
`is_gift_card_line`	Unknown
`is_mto`	Unknown
`is_multi_slot`	Unknown
`is_optional`	Unknown
`is_product_archived`	Unknown
`is_storable`	Unknown
`line_tax_amount`	Unknown
`line_tax_amount_percent`	Unknown
`linked_line_id`	Unknown
`linked_line_ids`	Json
`linked_virtual_id`	Unknown
`move_ids`	Json
`name`	Unknown
`name_short`	Unknown
`order_id`	Json
`order_partner_id`	Json
`parent_id`	Unknown
`price_reduce_taxexcl`	Unknown
`price_reduce_taxinc`	Unknown
`price_subtotal`	Unknown
`price_tax`	Unknown
`price_total`	Unknown
`price_unit`	Unknown
`pricelist_item_id`	Json
`product_custom_attribute_value_ids`	Json
`product_document_ids`	Json
`product_id`	Json
`product_invoice_policy`	Unknown
`product_no_variant_attribute_value_ids`	Json
`product_qty`	Unknown
`product_template_attribute_value_ids`	Json
`product_template_id`	Json
`product_type`	Unknown
`product_uom_id`	Json
`product_uom_qty`	Unknown
`product_uom_readonly`	Unknown
`product_updatable`	Unknown
`purchase_line_ids`	Json
`qty_available_today`	Unknown
`qty_delivered`	Unknown
`qty_delivered_at_date`	Unknown
`qty_delivered_method`	Unknown
`qty_invoiced`	Unknown
`qty_invoiced_at_date`	Unknown
`qty_invoiced_posted`	Unknown
`qty_to_deliver`	Unknown
`qty_to_invoice`	Unknown
`recompute_delivery_price`	Unknown
`registration_ids`	Json
`route_ids`	Json
`sale_line_warn_msg`	Unknown
`salesman_id`	Unknown
`scheduled_date`	Unknown
`selected_combo_items`	Unknown
`sequence`	Unknown
`service_tracking`	Unknown
`shop_warning`	Unknown
`shopify_fulfillment_line_id`	Unknown
`shopify_fulfillment_order_id`	Unknown
`shopify_fulfillment_order_status`	Unknown
`shopify_line_id`	Unknown
`shopify_related_line_id`	Unknown
`state`	Unknown
`tax_calculation_rounding_method`	Unknown
`tax_country_id`	Json
`tax_ids`	Json
`technical_price_unit`	Unknown
`translated_product_name`	Unknown
`untaxed_amount_invoiced`	Unknown
`untaxed_amount_to_invoice`	Unknown
`virtual_available_at_date`	Unknown
`virtual_id`	Unknown
`warehouse_id`	Json
`warehouse_id_ept`	Unknown
`write_date`	Instant
`write_uid`	Json

payment_invoice

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

payment

Column	Type	Keys
`id`	Unknown	PK
`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`	Unknown
`amount_available_for_refund`	Unknown
`amount_company_currency_signed`	Unknown
`amount_signed`	Unknown
`attachment_ids`	Json
`available_journal_ids`	Json
`available_partner_bank_ids`	Json
`available_payment_method_line_ids`	Json
`company_currency_id`	Json
`company_id`	Json
`country_code`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`date`	Unknown
`destination_account_id`	Json
`display_name`	Unknown
`duplicate_payment_ids`	Json
`has_message`	Unknown
`is_donation`	Unknown
`is_matched`	Unknown
`is_reconciled`	Unknown
`is_sent`	Unknown
`journal_id`	Json
`memo`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`move_id`	Json
`my_activity_date_deadline`	Unknown
`name`	Unknown
`need_cancel_request`	Unknown
`outstanding_account_id`	Json
`paired_internal_transfer_payment_id`	Unknown
`partner_bank_id`	Unknown
`partner_id`	Json
`partner_type`	Unknown
`payment_method_code`	Unknown
`payment_method_id`	Json
`payment_method_line_id`	Json
`payment_receipt_title`	Unknown
`payment_reference`	Unknown
`payment_token_id`	Unknown
`payment_transaction_id`	Unknown
`payment_type`	Unknown
`qr_code`	Unknown
`rating_ids`	Json
`reconciled_bill_ids`	Json
`reconciled_invoice_ids`	Json
`reconciled_invoices_type`	Unknown
`reconciled_statement_line_ids`	Json
`refunds_count`	Unknown
`require_partner_bank_account`	Unknown
`show_partner_bank_account`	Unknown
`source_payment_id`	Unknown
`state`	Unknown
`suitable_payment_token_ids`	Json
`use_electronic_payment_method`	Unknown
`website_message_ids`	Json
`write_date`	Instant
`write_uid`	Json

account_move_line_payment

Column	Type	Keys
`account_move_line_id`	Unknown	PKFK
`payment_id`	Unknown	PKFK

account_move_line

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`account_code`	Unknown
`account_id`	Json
`account_internal_group`	Unknown
`account_name`	Unknown
`account_root_id`	Json
`account_type`	Unknown
`allowed_uom_ids`	Json
`amount_currency`	Unknown
`amount_residual`	Unknown
`amount_residual_currency`	Unknown
`analytic_coverage`	Unknown
`analytic_distribution`	Unknown
`analytic_line_ids`	Json
`analytic_precision`	Unknown
`asset_ids`	Json
`balance`	Unknown
`cogs_origin_id`	Unknown
`collapse_composition`	Unknown
`collapse_prices`	Unknown
`commercial_partner_country`	Json
`company_currency_id`	Json
`company_id`	Json
`count_reconciled_lines`	Unknown
`count_reconciled_lines_excluding_exchange_diff`	Unknown
`create_date`	Unknown
`create_uid`	Json
`credit`	Unknown
`cumulated_balance`	Unknown
`currency_id`	Json
`currency_rate`	Unknown
`date`	Unknown
`date_maturity`	Unknown
`debit`	Unknown
`deductible_amount`	Unknown
`deferred_end_date`	Unknown
`deferred_start_date`	Unknown
`discount`	Unknown
`discount_allocation_dirty`	Unknown
`discount_amount_currency`	Unknown
`discount_balance`	Unknown
`discount_date`	Unknown
`display_name`	Unknown
`display_type`	Unknown
`distribution_analytic_account_ids`	Json
`epd_dirty`	Unknown
`exchange_move_ids`	Json
`exclude_bank_line`	Unknown
`extra_tax_data`	Unknown
`first_reconciled_lines_excluding_exchange_diff_id`	Json
`first_reconciled_lines_id`	Json
`followup_line_id`	Unknown
`full_amount_switch_html`	Unknown
`full_reconcile_id`	Json
`group_tax_id`	Unknown
`has_abnormal_deferred_date`	Unknown
`has_deferred_move`	Unknown
`has_invalid_analytic`	Unknown
`invoice_date`	Unknown
`invoice_origin`	Unknown
`is_account_reconcile`	Unknown
`is_downpayment`	Unknown
`is_imported`	Unknown
`is_landed_costs_line`	Unknown
`is_refund`	Unknown
`is_same_currency`	Unknown
`is_storno`	Unknown
`journal_group_id`	Unknown
`journal_id`	Json
`line_tax_amount_percent`	Unknown
`matched_credit_ids`	Json
`matched_debit_ids`	Json
`matching_number`	Unknown
`move_attachment_ids`	Json
`move_id`	Json
`move_name`	Unknown
`move_type`	Unknown
`name`	Unknown
`no_followup`	Unknown
`non_deductible_tax_value`	Unknown
`parent_id`	Unknown
`parent_state`	Unknown
`partner_id`	Json
`payment_date`	Unknown
`price_subtotal`	Unknown
`price_total`	Unknown
`price_unit`	Unknown
`product_category_id`	Unknown
`product_type`	Unknown
`product_uom_id`	Unknown
`purchase_line_id`	Unknown
`purchase_line_warn_msg`	Unknown
`purchase_order_id`	Unknown
`quantity`	Unknown
`reconcile_model_id`	Unknown
`reconciled`	Unknown
`reconciled_lines_excluding_exchange_diff_ids`	Json
`reconciled_lines_ids`	Json
`ref`	Unknown
`sale_line_ids`	Json
`sale_line_warn_msg`	Unknown
`search_account_id`	Unknown
`sequence`	Unknown
`statement_id`	Unknown
`statement_line_id`	Unknown
`tax_base_amount`	Unknown
`tax_calculation_rounding_method`	Unknown
`tax_group_id`	Unknown
`tax_ids`	Json
`tax_line_id`	Unknown
`tax_repartition_line_id`	Unknown
`tax_tag_ids`	Json
`translated_product_name`	Unknown
`write_date`	Instant
`write_uid`	Json

stock_location

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`barcode`	Unknown
`barcode_img`	Unknown
`child_ids`	Json
`child_internal_location_ids`	Json
`company_id`	Json
`complete_name`	Unknown
`create_date`	Unknown
`create_uid`	Json
`cyclic_inventory_frequency`	Unknown
`display_name`	Unknown
`forecast_weight`	Unknown
`incoming_move_line_ids`	Json
`is_empty`	Unknown
`is_valued_external`	Unknown
`is_valued_internal`	Unknown
`last_inventory_date`	Unknown
`location_id`	Json
`name`	Unknown
`net_weight`	Unknown
`next_inventory_date`	Unknown
`outgoing_move_line_ids`	Json
`parent_path`	Unknown
`putaway_rule_ids`	Json
`quant_ids`	Json
`removal_strategy_id`	Unknown
`replenish_location`	Unknown
`storage_category_id`	Unknown
`usage`	Unknown
`valuation_account_id`	Unknown
`warehouse_id`	Json
`warehouse_view_ids`	Json
`write_date`	Instant
`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
`allow_out_of_stock_order`	Unknown
`alternative_product_ids`	Json
`attribute_line_ids`	Json
`available_threshold`	Unknown
`barcode`	Unknown
`base_unit_count`	Unknown
`base_unit_id`	Unknown
`base_unit_name`	Unknown
`base_unit_price`	Unknown
`bom_count`	Unknown
`bom_ids`	Json
`bom_line_ids`	Json
`brand_id`	Unknown
`brand_name`	Unknown
`brand_status`	Unknown
`can_image_1024_be_zoomed`	Unknown
`can_publish`	Unknown
`categ_id`	Json
`category_id`	Unknown
`color`	Unknown
`combo_ids`	Json
`company_id`	Unknown
`compare_list_price`	Unknown
`cost_currency_id`	Json
`cost_method`	Unknown
`country_of_origin`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`default_code`	Unknown
`description`	Unknown
`description_ecommerce`	Unknown
`description_picking`	Unknown
`description_pickingin`	Unknown
`description_pickingout`	Unknown
`description_purchase`	Unknown
`description_sale`	Unknown
`display_name`	Unknown
`ept_image_ids`	Json
`expense_policy`	Unknown
`fiscal_country_code`	Unknown
`has_available_route_id`	Unknown
`has_configurable_attribute`	Unknown
`has_message`	Unknown
`hs_code`	Unknown
`image_1024`	Unknown
`image_128`	Unknown
`image_1920`	Unknown
`image_256`	Unknown
`image_512`	Unknown
`import_attribute_value`	Unknown
`incoming_qty`	Unknown
`invoice_policy`	Unknown
`is_dynamically_created`	Unknown
`is_favorite`	Unknown
`is_kit`	Unknown
`is_product_variant`	Unknown
`is_published`	Unknown
`is_seo_optimized`	Unknown
`is_storable`	Unknown
`landed_cost_ok`	Unknown
`list_price`	Unknown
`location_id`	Unknown
`lot_sequence_id`	Json
`lot_valuated`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`mrp_product_qty`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`nbr_moves_in`	Unknown
`nbr_moves_out`	Unknown
`nbr_reordering_rule`	Unknown
`next_serial`	Unknown
`optional_product_ids`	Json
`out_of_stock_message`	Unknown
`outgoing_qty`	Unknown
`pricelist_rule_ids`	Json
`product_document_ids`	Json
`product_properties`	Json
`product_tag_ids`	Json
`product_template_image_ids`	Json
`product_tooltip`	Unknown
`product_variant_id`	Json
`product_variant_ids`	Json
`property_account_expense_id`	Unknown
`property_account_income_id`	Unknown
`property_price_difference_account_id`	Unknown
`property_stock_inventory`	Json
`property_stock_production`	Json
`public_categ_ids`	Json
`publish_date`	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_msg`	Unknown
`sale_ok`	Unknown
`sales_count`	Unknown
`seller_ids`	Json
`seo_name`	Unknown
`sequence`	Unknown
`serial_prefix_format`	Unknown
`service_to_purchase`	Unknown
`service_tracking`	Unknown
`service_type`	Unknown
`shopify_template_count`	Unknown
`show_availability`	Unknown
`show_forecasted_qty_status_button`	Unknown
`show_on_hand_qty_status_button`	Unknown
`show_qty_update_button`	Unknown
`split_method_landed_cost`	Unknown
`standard_price`	Unknown
`supplier_taxes_id`	Json
`tax_string`	Unknown
`taxes_id`	Json
`tiktok_product_id`	Unknown
`tiktok_shop_id`	Unknown
`tiktok_sku_id`	Unknown
`tracking`	Unknown
`type`	Unknown
`uom_id`	Json
`uom_ids`	Json
`uom_name`	Unknown
`used_in_bom_count`	Unknown
`valid_product_template_attribute_line_ids`	Json
`valuation`	Unknown
`variant_seller_ids`	Json
`variants_default_code`	Unknown
`virtual_available`	Unknown
`visible_expense_policy`	Unknown
`volume`	Unknown
`volume_uom_name`	Unknown
`warehouse_id`	Unknown
`website_absolute_url`	Unknown
`website_description`	Unknown
`website_id`	Unknown
`website_message_ids`	Json
`website_meta_description`	Unknown
`website_meta_keyword`	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`	Instant
`write_uid`	Json
`x_studio_boolean_field_7_j_1_1_j_9_etus_7_k`	Unknown
`x_studio_char_field_6_n_9_1_j_9_f_20_v_2_b`	Unknown
`x_studio_char_field_95_o_1_j_9_f_3_v_8_j_0`	Unknown
`x_studio_many_2_many_field_1_h_1_1_j_9_f_3_mn_1_u`	Json
`x_studio_x_avg_landed_cost_per_unit`	Unknown

sale_report

Column	Type	Keys
`id`	Unknown	PK
`amz_fulfillment_by`	Unknown
`amz_instance_id`	Unknown
`amz_seller_id`	Unknown
`campaign_id`	Unknown
`categ_id`	Json
`commercial_partner_id`	Json
`company_id`	Json
`country_id`	Json
`currency_id`	Json
`date`	Instant
`discount`	Unknown
`discount_amount`	Unknown
`display_name`	Unknown
`industry_id`	Unknown
`invoice_status`	Unknown
`is_abandoned_cart`	Unknown
`line_invoice_status`	Unknown
`medium_id`	Unknown
`name`	Unknown
`nbr`	Unknown
`order_reference`	Unknown
`partner_id`	Json
`partner_zip`	Unknown
`price_subtotal`	Unknown
`price_total`	Unknown
`price_unit`	Unknown
`pricelist_id`	Json
`product_id`	Json
`product_tmpl_id`	Json
`product_uom_id`	Json
`product_uom_qty`	Unknown
`public_categ_ids`	Json
`qty_delivered`	Unknown
`qty_invoiced`	Unknown
`qty_to_deliver`	Unknown
`qty_to_invoice`	Unknown
`shopify_instance_id`	Json
`source_id`	Json
`state`	Unknown
`state_id`	Json
`team_id`	Json
`untaxed_amount_invoiced`	Unknown
`untaxed_amount_to_invoice`	Unknown
`user_id`	Unknown
`volume`	Unknown
`warehouse_id`	Json
`website_id`	Unknown
`weight`	Unknown

stock_move

Column	Type	Keys
`id`	Unknown	PK
`account_move_id`	Unknown
`additional`	Unknown
`adjusted_date`	Unknown
`allowed_operation_ids`	Json
`allowed_uom_ids`	Json
`amazon_instance_id`	Unknown
`amazon_order_item_id`	Unknown
`amazon_order_reference`	Unknown
`amazon_shipment_id`	Unknown
`amazon_shipment_item_id`	Unknown
`amz_return_report_id`	Unknown
`amz_shipment_report_id`	Unknown
`amz_stock_adjustment_report_id`	Unknown
`analytic_account_line_ids`	Json
`availability`	Unknown
`bom_line_id`	Unknown
`byproduct_id`	Unknown
`carrier_id`	Unknown
`check_id`	Json
`code_description`	Unknown
`code_id`	Unknown
`company_currency_id`	Json
`company_id`	Json
`consume_unbuild_id`	Unknown
`cost_share`	Unknown
`create_date`	Unknown
`create_uid`	Json
`created_production_id`	Unknown
`created_purchase_line_ids`	Json
`date`	Unknown
`date_deadline`	Unknown
`delay_alert_date`	Unknown
`description_picking`	Unknown
`description_picking_manual`	Unknown
`detailed_disposition`	Unknown
`display_assign_serial`	Unknown
`display_import_lot`	Unknown
`display_name`	Unknown
`fba_returned_date`	Unknown
`forecast_availability`	Unknown
`forecast_expected_date`	Unknown
`fulfillment_center_id`	Unknown
`has_lines_without_result_package`	Unknown
`has_tracking`	Unknown
`inventory_name`	Unknown
`is_date_editable`	Unknown
`is_dropship`	Unknown
`is_in`	Unknown
`is_initial_demand_editable`	Unknown
`is_inventory`	Unknown
`is_locked`	Unknown
`is_out`	Unknown
`is_quantity_done_editable`	Unknown
`is_storable`	Unknown
`is_unidentified_counterpart`	Unknown
`is_valued`	Unknown
`location_dest_id`	Json
`location_dest_usage`	Unknown
`location_final_id`	Json
`location_id`	Json
`location_usage`	Unknown
`lot_ids`	Json
`manual_consumption`	Unknown
`move_dest_ids`	Json
`move_line_ids`	Json
`move_line_ids_picked`	Json
`move_orig_ids`	Json
`never_product_template_attribute_value_ids`	Json
`next_serial`	Unknown
`note`	Unknown
`operation_id`	Unknown
`order_finished_lot_ids`	Json
`orderpoint_id`	Unknown
`origin`	Unknown
`origin_returned_move_id`	Unknown
`package_ids`	Json
`packaging_uom_id`	Json
`packaging_uom_qty`	Unknown
`partner_id`	Json
`picked`	Unknown
`picking_code`	Unknown
`picking_id`	Json
`picking_type_id`	Json
`picking_type_prefill_shop_floor_lots`	Unknown
`price_unit`	Unknown
`priority`	Unknown
`procure_method`	Unknown
`procurement_values`	Unknown
`product_barcode`	Unknown
`product_category_id`	Json
`product_id`	Json
`product_qty`	Unknown
`product_qty_available`	Unknown
`product_tmpl_id`	Json
`product_uom`	Json
`product_uom_qty`	Unknown
`product_virtual_available`	Unknown
`production_group_id`	Unknown
`production_id`	Unknown
`propagate_cancel`	Unknown
`purchase_line_id`	Unknown
`quantity`	Unknown
`raw_material_production_id`	Unknown
`reference`	Unknown
`reference_ids`	Json
`remaining_qty`	Unknown
`remaining_value`	Unknown
`reservation_date`	Unknown
`restrict_partner_id`	Unknown
`return_created`	Unknown
`return_reason_id`	Unknown
`returned_move_ids`	Json
`route_ids`	Json
`rule_id`	Json
`sale_line_id`	Json
`scrap_id`	Unknown
`seller_id`	Unknown
`sequence`	Unknown
`shopify_fulfillment_line_id`	Unknown
`shopify_fulfillment_order_id`	Unknown
`shopify_fulfillment_order_status`	Unknown
`shopify_return_reason`	Unknown
`should_consume_qty`	Unknown
`show_details_visible`	Unknown
`show_lots_m_2_o`	Unknown
`show_lots_text`	Unknown
`show_operations`	Unknown
`show_quant`	Unknown
`standard_price`	Unknown
`state`	Unknown
`status_ept`	Unknown
`to_refund`	Unknown
`tracking_number`	Unknown
`tracking_reference`	Unknown
`transaction_item_id`	Unknown
`unbuild_id`	Unknown
`unit_factor`	Unknown
`updated_in_amazon`	Unknown
`value`	Unknown
`value_computed_justification`	Unknown
`value_justification`	Unknown
`value_manual`	Unknown
`warehouse_id`	Json
`weight`	Unknown
`workorder_id`	Unknown
`worksheet_document`	Unknown
`write_date`	Instant
`write_uid`	Json

sale_order_tax_totals_subtotal_tax_group

Column	Type	Keys
`id`	Unknown	PK
`sale_order_id`	Unknown	PKFK
`sale_order_tax_totals_subtotal_index`	Unknown	PKFK
`base_amount`	Unknown
`base_amount_currency`	Unknown
`display_base_amount`	Unknown
`display_base_amount_currency`	Unknown
`group_label`	Unknown
`group_name`	Unknown
`involved_tax_ids`	Json
`tax_amount`	Unknown
`tax_amount_currency`	Unknown

sale_order_tax_totals_subtotal

Column	Type	Keys
`index`	Unknown	PK
`sale_order_id`	Unknown	PKFK
`base_amount`	Unknown
`base_amount_currency`	Unknown
`name`	Unknown
`tax_amount`	Unknown
`tax_amount_currency`	Unknown

sale_order_invoice

Column	Type	Keys
`invoice_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_delivery`	Unknown
`amount_invoiced`	Unknown
`amount_paid`	Unknown
`amount_tax`	Unknown
`amount_to_invoice`	Unknown
`amount_total`	Unknown
`amount_undiscounted`	Unknown
`amount_untaxed`	Unknown
`amz_delivery_end_time`	Unknown
`amz_delivery_start_time`	Unknown
`amz_displayable_date_time`	Unknown
`amz_fba_original_order_id`	Unknown
`amz_fba_replaced_order_id`	Unknown
`amz_fba_replaced_order_reason`	Unknown
`amz_fulfillment_action`	Unknown
`amz_fulfillment_by`	Unknown
`amz_fulfillment_instance_id`	Unknown
`amz_fulfillment_policy`	Unknown
`amz_fulfullment_order_status`	Unknown
`amz_instance_country_code`	Unknown
`amz_instance_id`	Unknown
`amz_is_outbound_order`	Unknown
`amz_order_reference`	Unknown
`amz_reimburse_invoice_ids`	Json
`amz_sales_order_report_id`	Unknown
`amz_seller_id`	Unknown
`amz_shipment_report_id`	Unknown
`amz_shipment_service_level_category`	Unknown
`attendee_count`	Unknown
`authorized_transaction_ids`	Json
`auto_workflow_process_id`	Json
`available_quotation_document_ids`	Json
`bill_city`	Unknown
`bill_country_id`	Unknown
`bill_postal_code`	Unknown
`bill_state_id`	Unknown
`buyer_cancellation_reason`	Unknown
`buyer_requested_cancellation`	Unknown
`calendar_event_count`	Unknown
`campaign_id`	Unknown
`canceled_in_shopify`	Unknown
`carrier_id`	Json
`cart_quantity`	Unknown
`cart_recovery_email_sent`	Unknown
`checkout_id`	Unknown
`client_order_ref`	Unknown
`closed_at_ept`	Unknown
`commitment_date`	Unknown
`company_id`	Json
`company_price_include`	Unknown
`country_code`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`currency_rate`	Unknown
`customizable_pdf_form_fields`	Unknown
`date_order`	Unknown
`delivery_count`	Unknown
`delivery_message`	Unknown
`delivery_set`	Unknown
`delivery_status`	Unknown
`display_name`	Unknown
`duplicated_order_ids`	Json
`earliest_delivery_date`	Unknown
`earliest_ship_date`	Unknown
`effective_date`	Unknown
`expected_date`	Unknown
`exported_in_amazon`	Unknown
`fiscal_position_id`	Json
`has_active_pricelist`	Unknown
`has_archived_product`	Unknown
`has_authorized_transaction_ids`	Unknown
`has_message`	Unknown
`incoterm`	Unknown
`incoterm_location`	Unknown
`invoice_status`	Unknown
`is_abandoned_cart`	Unknown
`is_all_service`	Unknown
`is_amazon_canceled`	Unknown
`is_business_order`	Unknown
`is_buy_with_prime_order`	Unknown
`is_expired`	Unknown
`is_fba_pending_order`	Unknown
`is_manual_order`	Unknown
`is_pdf_quote_builder_available`	Unknown
`is_pos_order`	Unknown
`is_prime_order`	Unknown
`is_risky_order`	Unknown
`is_service_tracking_updated`	Unknown
`is_shopify_multi_payment`	Unknown
`journal_id`	Unknown
`json_popover`	Unknown
`late_availability`	Unknown
`locked`	Unknown
`medium_id`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`mismatch_delivered_invoice_qty`	Unknown
`moves_count`	Unknown
`mrp_production_ids`	Json
`my_activity_date_deadline`	Unknown
`name`	Unknown
`note`	Unknown
`notify_by_email`	Unknown
`only_services`	Unknown
`opportunity_id`	Unknown
`order_has_fba_warehouse`	Unknown
`order_line`	Json
`origin`	Unknown
`partner_credit_warning`	Unknown
`partner_id`	Json
`partner_invoice_id`	Json
`partner_shipping_id`	Json
`payment_term_id`	Json
`pending_email_template_id`	Unknown
`picking_ids`	Json
`picking_policy`	Unknown
`pickup_location_data`	Unknown
`preferred_payment_method_line_id`	Unknown
`prepayment_percent`	Unknown
`pricelist_id`	Json
`purchase_order_count`	Unknown
`quotation_document_ids`	Json
`rating_ids`	Json
`recompute_delivery_price`	Unknown
`reference`	Unknown
`reimburse_invoice_count`	Unknown
`require_payment`	Unknown
`require_signature`	Unknown
`risk_ids`	Json
`sale_order_template_id`	Unknown
`sale_warning_text`	Unknown
`ship_city`	Unknown
`ship_country_id`	Unknown
`ship_postal_code`	Unknown
`ship_state_id`	Unknown
`shipping_weight`	Unknown
`shop_warning`	Unknown
`shopify_channel_id`	Unknown
`shopify_instance_id`	Json
`shopify_location_id`	Json
`shopify_market_id`	Unknown
`shopify_order_id`	Unknown
`shopify_order_number`	Unknown
`shopify_order_status`	Unknown
`shopify_payment_gateway_id`	Json
`shopify_payment_ids`	Json
`shopify_return_payload_json`	Unknown
`show_json_popover`	Unknown
`show_update_fpos`	Unknown
`show_update_pricelist`	Unknown
`signature`	Unknown
`signed_by`	Unknown
`signed_on`	Unknown
`source_id`	Json
`source_link`	Unknown
`spreadsheet_id`	Unknown
`spreadsheet_ids`	Json
`spreadsheet_template_id`	Unknown
`state`	Unknown
`stock_reference_ids`	Json
`tag_ids`	Json
`tax_calculation_rounding_method`	Unknown
`tax_country_id`	Json
`tax_totals_base_amount`	Unknown
`tax_totals_base_amount_currency`	Unknown
`tax_totals_company_currency_id`	Unknown
`tax_totals_company_currency_pd`	Unknown
`tax_totals_currency_id`	Unknown
`tax_totals_currency_pd`	Unknown
`tax_totals_has_tax_groups`	Unknown
`tax_totals_same_tax_base`	Unknown
`tax_totals_tax_amount`	Unknown
`tax_totals_tax_amount_currency`	Unknown
`tax_totals_total_amount`	Unknown
`tax_totals_total_amount_currency`	Unknown
`team_id`	Json
`terms_type`	Unknown
`tiktok_order_cancel_reason`	Unknown
`tiktok_order_id`	Unknown
`tiktok_order_status`	Unknown
`tiktok_return_status`	Unknown
`tiktok_shop_id`	Unknown
`tiktok_shop_package_id`	Unknown
`transaction_ids`	Json
`type_name`	Unknown
`updated_in_amazon`	Unknown
`updated_in_shopify`	Unknown
`user_id`	Unknown
`validity_date`	Unknown
`warehouse_id`	Json
`website_id`	Unknown
`website_message_ids`	Json
`website_order_line`	Json
`write_date`	Instant
`write_uid`	Json
`x_studio_channel`	Unknown
`x_studio_channel_1`	Unknown
`x_studio_channel_order_id`	Unknown
`x_studio_many_2_many_field_5_pi_1_j_96_oa_43_e`	Json
`x_studio_many_2_many_field_71_r_1_j_96_o_394_i`	Json
`x_studio_many_2_many_field_7_eu_1_j_96_no_0_vl`	Json
`x_studio_tax_removed`	Unknown
`x_studio_tiktok_tax_removed`	Unknown

invoice_tax_totals_subtotal

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`base_amount`	Unknown
`base_amount_currency`	Unknown
`name`	Unknown
`tax_amount`	Unknown
`tax_amount_currency`	Unknown
`tax_groups`	Json

invoice_payments_widget_content

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`account_payment_id`	Unknown
`amount`	Unknown
`amount_company_currency`	Unknown
`amount_foreign_currency`	Unknown
`company_name`	Unknown
`currency_id`	Unknown
`date`	Unknown
`is_exchange`	Unknown
`is_refund`	Unknown
`journal_name`	Unknown
`move_id`	Unknown
`name`	Unknown
`partial_id`	Unknown
`payment_method_name`	Unknown
`ref`	Unknown

invoice_payment

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

invoice_stock_move

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`stock_move_id`	Unknown	PKFK

invoice

Column	Type	Keys
`id`	Unknown	PK
`abnormal_amount_warning`	Unknown
`abnormal_date_warning`	Unknown
`access_token`	Unknown
`access_url`	Unknown
`access_warning`	Unknown
`account_fiscal_country_group_codes`	Json
`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
`adjusting_entries_count`	Unknown
`adjusting_entries_move_ids`	Json
`adjusting_entry_origin_label`	Unknown
`adjusting_entry_origin_move_ids`	Json
`alerts`	Unknown
`always_tax_exigible`	Unknown
`amazon_instance_id`	Unknown
`amount_paid`	Unknown
`amount_residual`	Unknown
`amount_residual_signed`	Unknown
`amount_tax`	Unknown
`amount_tax_signed`	Unknown
`amount_total`	Unknown
`amount_total_in_currency_signed`	Unknown
`amount_total_signed`	Unknown
`amount_total_words`	Unknown
`amount_untaxed`	Unknown
`amount_untaxed_in_currency_signed`	Unknown
`amount_untaxed_signed`	Unknown
`amz_fulfillment_by`	Unknown
`amz_sale_order_id`	Unknown
`asset_depreciated_value`	Unknown
`asset_depreciation_beginning_date`	Unknown
`asset_id`	Unknown
`asset_id_display_name`	Unknown
`asset_ids`	Json
`asset_move_type`	Unknown
`asset_number_days`	Unknown
`asset_remaining_value`	Unknown
`asset_value_change`	Unknown
`attachment_ids`	Json
`audit_trail_message_ids`	Json
`authorized_transaction_ids`	Json
`auto_post`	Unknown
`auto_post_origin_id`	Unknown
`auto_post_until`	Unknown
`bank_partner_id`	Json
`bill_city`	Unknown
`bill_country_id`	Unknown
`bill_postal_code`	Unknown
`bill_state_id`	Unknown
`calendar_booking_ids`	Json
`campaign_id`	Unknown
`checked`	Unknown
`closing_return_id`	Unknown
`commercial_partner_id`	Json
`company_currency_id`	Json
`company_id`	Json
`company_price_include`	Unknown
`count_asset`	Unknown
`country_code`	Unknown
`create_date`	Unknown
`create_uid`	Json
`currency_id`	Json
`date`	Unknown
`deferred_entry_type`	Unknown
`deferred_move_ids`	Json
`deferred_original_move_ids`	Json
`delivery_date`	Unknown
`depreciation_value`	Unknown
`direction_sign`	Unknown
`display_inactive_currency_warning`	Unknown
`display_link_qr_code`	Unknown
`display_name`	Unknown
`display_qr_code`	Unknown
`display_send_button`	Unknown
`draft_asset_exists`	Unknown
`duplicated_ref_ids`	Json
`exchange_diff_partial_ids`	Json
`expected_currency_rate`	Unknown
`extract_attachment_id`	Unknown
`extract_can_show_banners`	Unknown
`extract_can_show_send_button`	Unknown
`extract_detected_layout`	Unknown
`extract_document_uuid`	Unknown
`extract_error_message`	Unknown
`extract_partner_name`	Unknown
`extract_prefill_data`	Unknown
`extract_state`	Unknown
`extract_state_processed`	Unknown
`extract_status`	Unknown
`extracted_dates`	Unknown
`extracted_numbers`	Unknown
`extracted_words`	Unknown
`feed_id`	Unknown
`fiscal_position_id`	Json
`generating_loan_line_id`	Unknown
`has_message`	Unknown
`has_reconciled_entries`	Unknown
`hide_post_button`	Unknown
`highest_name`	Unknown
`highlight_send_button`	Unknown
`impacting_cash_basis`	Unknown
`inalterable_hash`	Unknown
`incoterm_location`	Unknown
`invoice_cash_rounding_id`	Unknown
`invoice_currency_rate`	Unknown
`invoice_date`	Unknown
`invoice_date_due`	Unknown
`invoice_filter_type_domain`	Unknown
`invoice_has_outstanding`	Unknown
`invoice_incoterm_id`	Unknown
`invoice_incoterm_placeholder`	Unknown
`invoice_line_ids`	Json
`invoice_origin`	Unknown
`invoice_outstanding_credits_debits_widget`	Unknown
`invoice_partner_display_name`	Unknown
`invoice_payment_term_id`	Json
`invoice_payments_widget_outstanding`	Unknown
`invoice_payments_widget_title`	Unknown
`invoice_pdf_report_file`	Unknown
`invoice_pdf_report_id`	Unknown
`invoice_sent`	Unknown
`invoice_source_email`	Unknown
`invoice_url`	Unknown
`invoice_user_id`	Unknown
`invoice_vendor_bill_id`	Unknown
`is_being_sent`	Unknown
`is_draft_duplicated_ref_id`	Unknown
`is_exact_move_duplicate`	Unknown
`is_in_extractable_state`	Unknown
`is_loan_payment_move`	Unknown
`is_manually_modified`	Unknown
`is_move_sent`	Unknown
`is_purchase_matched`	Unknown
`is_refund_in_shopify`	Unknown
`is_sale_installed`	Unknown
`is_shopify_multi_payment`	Unknown
`is_storno`	Unknown
`is_undefined_amazon_returns`	Unknown
`journal_group_id`	Unknown
`journal_id`	Json
`journal_line_ids`	Json
`landed_costs_ids`	Json
`landed_costs_visible`	Unknown
`line_ids`	Json
`loan_id`	Unknown
`made_sequence_gap`	Unknown
`matched_payment_ids`	Json
`medium_id`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`move_sent_values`	Unknown
`move_type`	Unknown
`my_activity_date_deadline`	Unknown
`name`	Unknown
`name_placeholder`	Unknown
`narration`	Unknown
`need_cancel_request`	Unknown
`needed_terms_dirty`	Unknown
`next_payment_date`	Unknown
`no_followup`	Unknown
`origin_payment_id`	Json
`partner_bank_id`	Unknown
`partner_credit_warning`	Unknown
`partner_id`	Json
`partner_shipping_id`	Json
`payment_count`	Unknown
`payment_reference`	Unknown
`payment_state`	Unknown
`payment_state_before_switch`	Unknown
`posted_before`	Unknown
`preferred_payment_method_line_id`	Unknown
`purchase_id`	Unknown
`purchase_order_count`	Unknown
`purchase_order_name`	Unknown
`purchase_vendor_bill_id`	Unknown
`purchase_warning_text`	Unknown
`qr_code_method`	Unknown
`quick_edit_mode`	Unknown
`quick_edit_total_amount`	Unknown
`rating_ids`	Json
`reconciled_payment_ids`	Json
`ref`	Unknown
`reimbursement_id`	Unknown
`restrict_mode_hash_table`	Unknown
`reversal_move_ids`	Json
`reversed_entry_id`	Unknown
`sale_warning_text`	Unknown
`secure_sequence_number`	Unknown
`secured`	Unknown
`seller_id`	Unknown
`sending_data`	Unknown
`sequence_number`	Unknown
`sequence_prefix`	Unknown
`ship_city`	Unknown
`ship_country_id`	Unknown
`ship_postal_code`	Unknown
`ship_state_id`	Unknown
`shopify_instance_id`	Json
`shopify_refund_id`	Unknown
`show_delivery_date`	Unknown
`show_discount_details`	Unknown
`show_journal`	Unknown
`show_name_warning`	Unknown
`show_payment_term_details`	Unknown
`show_reset_to_draft_button`	Unknown
`show_signature_area`	Unknown
`show_taxable_supply_date`	Unknown
`show_update_fpos`	Unknown
`signature`	Unknown
`signing_user`	Unknown
`so_reimburse_invoice_id`	Unknown
`source_id`	Json
`state`	Unknown
`statement_id`	Unknown
`statement_line_id`	Unknown
`statement_line_ids`	Json
`status_in_payment`	Unknown
`suitable_journal_ids`	Json
`tax_calculation_rounding_method`	Unknown
`tax_cash_basis_created_move_ids`	Json
`tax_cash_basis_origin_move_id`	Unknown
`tax_cash_basis_rec_id`	Unknown
`tax_country_code`	Unknown
`tax_country_id`	Json
`tax_lock_date_message`	Unknown
`tax_totals_base_amount`	Unknown
`tax_totals_base_amount_currency`	Unknown
`tax_totals_company_currency_id`	Unknown
`tax_totals_company_currency_pd`	Unknown
`tax_totals_currency_id`	Unknown
`tax_totals_currency_pd`	Unknown
`tax_totals_display_in_company_currency`	Unknown
`tax_totals_has_tax_groups`	Unknown
`tax_totals_same_tax_base`	Unknown
`tax_totals_tax_amount`	Unknown
`tax_totals_tax_amount_currency`	Unknown
`tax_totals_total_amount`	Unknown
`tax_totals_total_amount_currency`	Unknown
`taxable_supply_date`	Unknown
`taxable_supply_date_placeholder`	Unknown
`taxes_legal_notes`	Unknown
`team_id`	Json
`transaction_ids`	Json
`type_name`	Unknown
`ubl_cii_xml_file`	Unknown
`ubl_cii_xml_filename`	Unknown
`ubl_cii_xml_id`	Unknown
`user_id`	Unknown
`vcs_invoice_number`	Unknown
`website_id`	Unknown
`website_message_ids`	Json
`wip_production_ids`	Json
`write_date`	Instant
`write_uid`	Json
`x_studio_attention`	Unknown
`x_studio_char_field_6_id_1_jfvm_2_jot`	Unknown
`x_studio_char_field_8_aq_1_jfvmt_6_i_7`	Unknown
`x_studio_for_ach_delivery`	Unknown
`x_studio_for_wire_transfers`	Unknown
`x_studio_html_field_3_r_9_1_jfvidacu`	Unknown
`x_studio_note`	Unknown
`x_studio_one_2_many_field_mo_1_jfvghosp`	Json
`x_studio_project`	Unknown

mail_message

Column	Type	Keys
`id`	Unknown	PK
`account_audit_log_account_id`	Unknown
`account_audit_log_company_id`	Unknown
`account_audit_log_move_id`	Unknown
`account_audit_log_partner_id`	Unknown
`account_audit_log_preview`	Unknown
`account_audit_log_restricted`	Unknown
`account_audit_log_tax_id`	Unknown
`attachment_ids`	Json
`author_avatar`	Unknown
`author_guest_id`	Unknown
`author_id`	Json
`body`	Unknown
`call_history_ids`	Json
`channel_id`	Unknown
`child_ids`	Json
`create_date`	Unknown
`create_uid`	Json
`date`	Unknown
`display_name`	Unknown
`email_add_signature`	Unknown
`email_from`	Unknown
`email_layout_xmlid`	Unknown
`has_error`	Unknown
`has_sms_error`	Unknown
`incoming_email_cc`	Unknown
`incoming_email_to`	Unknown
`is_current_user_or_guest_author`	Unknown
`is_internal`	Unknown
`letter_ids`	Json
`linked_message_ids`	Json
`mail_activity_type_id`	Unknown
`mail_ids`	Json
`mail_server_id`	Unknown
`message_id`	Unknown
`message_link_preview_ids`	Json
`message_type`	Unknown
`model`	Unknown
`needaction`	Unknown
`notification_ids`	Json
`notified_partner_ids`	Json
`outgoing_email_to`	Unknown
`parent_id`	Unknown
`partner_ids`	Json
`pinned_at`	Unknown
`preview`	Unknown
`rating_id`	Unknown
`rating_ids`	Json
`rating_value`	Unknown
`reaction_ids`	Json
`record_alias_domain_id`	Unknown
`record_company_id`	Unknown
`record_name`	Unknown
`reply_to`	Unknown
`reply_to_force_new`	Unknown
`res_id`	Unknown
`snailmail_error`	Unknown
`starred`	Unknown
`starred_partner_ids`	Json
`subject`	Unknown
`subtype_id`	Json
`tracking_value_ids`	Json
`write_date`	Instant
`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
`company_price_include`	Unknown
`country_code`	Unknown
`country_id`	Json
`create_date`	Unknown
`create_uid`	Json
`description`	Unknown
`display_alternative_taxes_field`	Unknown
`display_name`	Unknown
`fiscal_position_ids`	Json
`formula`	Unknown
`formula_decoded_info`	Unknown
`has_message`	Unknown
`has_negative_factor`	Unknown
`hide_tax_exigibility`	Unknown
`include_base_amount`	Unknown
`invoice_label`	Unknown
`invoice_legal_notes`	Unknown
`invoice_repartition_line_ids`	Json
`is_amazon_tax_ept`	Unknown
`is_base_affected`	Unknown
`is_domestic`	Unknown
`is_used`	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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`name`	Unknown
`original_tax_ids`	Json
`price_include`	Unknown
`price_include_override`	Unknown
`rating_ids`	Json
`refund_repartition_line_ids`	Json
`repartition_line_ids`	Json
`repartition_lines_str`	Unknown
`replacing_tax_ids`	Json
`sequence`	Unknown
`tax_exigibility`	Unknown
`tax_group_id`	Json
`tax_label`	Unknown
`tax_scope`	Unknown
`type_tax_use`	Unknown
`ubl_cii_requires_exemption_reason`	Unknown
`ubl_cii_tax_category_code`	Unknown
`ubl_cii_tax_exemption_reason_code`	Unknown
`website_message_ids`	Json
`write_date`	Instant
`write_uid`	Json

customer_invoice

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

customer_sale_order

Column	Type	Keys
`customer_id`	Unknown	PKFK
`sale_order_id`	Unknown	PKFK

customer

Column	Type	Keys
`id`	Unknown	PK
`account_move_count`	Unknown
`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_ids`	Json
`activity_state`	Unknown
`activity_summary`	Unknown
`activity_type_icon`	Unknown
`activity_type_id`	Unknown
`activity_user_id`	Unknown
`agent_ids`	Json
`allow_search_fiscal_based_on_origin_warehouse`	Unknown
`application_statistics`	Json
`autopost_bill`	Unknown
`available_invoice_template_pdf_report_ids`	Json
`available_peppol_eas`	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
`buyer_id`	Unknown
`calendar_last_notif_ack`	Unknown
`can_publish`	Unknown
`category_id`	Json
`channel_ids`	Json
`channel_member_ids`	Json
`child_ids`	Json
`city`	Unknown
`color`	Unknown
`comment`	Unknown
`commercial_company_name`	Unknown
`commercial_partner_id`	Json
`company_id`	Json
`company_name`	Unknown
`company_registry`	Unknown
`company_registry_label`	Unknown
`company_registry_placeholder`	Unknown
`company_type`	Unknown
`complete_name`	Unknown
`contact_address`	Unknown
`contact_address_complete`	Unknown
`contact_address_inline`	Unknown
`contract_ids`	Json
`country_code`	Unknown
`country_id`	Json
`create_date`	Unknown
`create_uid`	Json
`credit`	Unknown
`credit_limit`	Unknown
`credit_to_invoice`	Unknown
`currency_id`	Json
`customer_rank`	Unknown
`days_sales_outstanding`	Unknown
`debit`	Unknown
`display_invoice_edi_format`	Unknown
`display_invoice_template_pdf_report_id`	Unknown
`display_name`	Unknown
`duplicate_bank_partner_ids`	Json
`email`	Unknown
`email_formatted`	Unknown
`email_normalized`	Unknown
`employee`	Unknown
`employee_ids`	Json
`event_count`	Unknown
`fiscal_country_code`	Unknown
`fiscal_country_group_codes`	Json
`followup_line_id`	Unknown
`followup_next_action_date`	Unknown
`followup_reminder_type`	Unknown
`followup_responsible_id`	Unknown
`followup_status`	Unknown
`function`	Unknown
`group_on`	Unknown
`group_rfq`	Unknown
`has_message`	Unknown
`has_moves`	Unknown
`ignore_abnormal_invoice_amount`	Unknown
`ignore_abnormal_invoice_date`	Unknown
`im_status`	Unknown
`image_1024`	Unknown
`image_128`	Unknown
`image_1920`	Unknown
`image_256`	Unknown
`image_512`	Unknown
`image_medium`	Unknown
`industry_id`	Unknown
`invoice_edi_format`	Unknown
`invoice_edi_format_store`	Unknown
`invoice_sending_method`	Unknown
`invoice_template_pdf_report_id`	Unknown
`is_amz_customer`	Unknown
`is_blacklisted`	Unknown
`is_company`	Unknown
`is_created_by_ocr`	Unknown
`is_in_call`	Unknown
`is_peppol_edi_format`	Unknown
`is_pickup_location`	Unknown
`is_public`	Unknown
`is_published`	Unknown
`is_seo_optimized`	Unknown
`is_shopify_customer`	Unknown
`is_ubl_format`	Unknown
`lang`	Unknown
`main_user_id`	Unknown
`meeting_ids`	Json
`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_needaction`	Unknown
`message_needaction_counter`	Unknown
`message_partner_ids`	Json
`my_activity_date_deadline`	Unknown
`name`	Unknown
`ocn_token`	Unknown
`offline_since`	Unknown
`on_time_rate`	Unknown
`online_partner_information`	Unknown
`opportunity_ids`	Json
`parent_id`	Json
`parent_name`	Unknown
`partner_company_registry_placeholder`	Unknown
`partner_latitude`	Unknown
`partner_longitude`	Unknown
`partner_share`	Unknown
`partner_vat_placeholder`	Unknown
`payment_token_ids`	Json
`peppol_eas`	Unknown
`peppol_endpoint`	Unknown
`phone`	Unknown
`phone_blacklisted`	Unknown
`phone_mobile_search`	Unknown
`phone_sanitized`	Unknown
`phone_sanitized_blacklisted`	Unknown
`picking_warn_msg`	Unknown
`properties`	Json
`properties_base_definition_id`	Json
`property_account_payable_id`	Json
`property_account_position_id`	Unknown
`property_account_receivable_id`	Json
`property_delivery_carrier_id`	Unknown
`property_inbound_payment_method_line_id`	Unknown
`property_outbound_payment_method_line_id`	Unknown
`property_payment_term_id`	Unknown
`property_product_pricelist`	Json
`property_purchase_currency_id`	Unknown
`property_stock_customer`	Json
`property_stock_supplier`	Json
`property_supplier_payment_term_id`	Unknown
`purchase_line_ids`	Json
`purchase_order_count`	Unknown
`purchase_warn_msg`	Unknown
`rating_ids`	Json
`receipt_reminder_email`	Unknown
`ref`	Unknown
`ref_company_ids`	Json
`reminder_date_before_receipt`	Unknown
`rtc_session_ids`	Json
`sale_warn_msg`	Unknown
`same_company_registry_partner_id`	Unknown
`same_vat_partner_id`	Unknown
`self`	Unknown
`seo_name`	Unknown
`shopify_segment_ids`	Json
`show_credit_limit`	Unknown
`signup_type`	Unknown
`specific_property_product_pricelist`	Unknown
`state_id`	Json
`static_map_url`	Unknown
`static_map_url_is_valid`	Unknown
`street`	Unknown
`street_2`	Unknown
`suggest_based_on`	Unknown
`suggest_day`	Unknown
`suggest_percent`	Unknown
`supplier_invoice_count`	Unknown
`supplier_rank`	Unknown
`total_all_due`	Unknown
`total_all_overdue`	Unknown
`total_due`	Unknown
`total_invoiced`	Unknown
`total_overdue`	Unknown
`total_overdue_followup`	Unknown
`trust`	Unknown
`type`	Unknown
`type_address_label`	Unknown
`tz`	Unknown
`tz_offset`	Unknown
`unpaid_invoice_ids`	Json
`unreconciled_aml_ids`	Json
`upcoming_appointment_ids`	Json
`use_partner_credit_limit`	Unknown
`user_id`	Unknown
`user_ids`	Json
`vat`	Unknown
`vat_label`	Unknown
`visitor_ids`	Json
`website`	Unknown
`website_absolute_url`	Unknown
`website_description`	Unknown
`website_id`	Unknown
`website_message_ids`	Json
`website_meta_description`	Unknown
`website_meta_keyword`	Unknown
`website_meta_og_img`	Unknown
`website_meta_title`	Unknown
`website_published`	Unknown
`website_short_description`	Unknown
`website_url`	Unknown
`wishlist_ids`	Json
`write_date`	Instant
`write_uid`	Json
`zip`	Unknown