invantive documentation
Invantive Support ForumsLog In / Sign Up

Odoo Data Model

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • One query can read several companies at once.
  • Data can be written as well as read.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Figures

Figure Count
Tables 876
Columns 26,381

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 5 A0 sheets

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Odoo data model, Sheet 1 of 5Odoo data modelfor use with Invantive UniversalSQLRelease 22.1.135-BETA+3826 · 01-03-2023Account · company · Order · Account · transaction · Account · carrier · Account · warehouse · Report · Work · resourceSheet 1 of 5 · documentation.invantive.euAccount · company×2×2×3×3×2×3×2×3×3×4×2×2×2×2×2×2×2×2×2Odoo.Odoo.website: itgen_odoo_website (Odoo.theme.website_menu, Odoo.theme.website_page)website+_menu +_pageOdoo.res.usersUOdoo.account.account: itgen_odoo_account (Odoo.account.account_tag, Odoo.account.account_template, Odoo.documents.account_folder_setting, Odoo.report.account_batch_payment_print_batch_payment, Odoo.report.account_report_hash_integrity, Odoo.report.account_report_invoice, Odoo.report.account_report_invoice_with_payments, Odoo.validate.account_move)account+_batch_payment_print_batch_payment +…Odoo.account.accrued_orders_wizard: itgen_odoo_accrued_orders_wizardaccrued_orders_wizardOdoo.account.automatic_entry_wizard: itgen_odoo_automatic_entry_wizardautomatic_entry_wizardOdoo.account.batch_payment: itgen_odoo_batch_paymentbatch_paymentOdoo.account.cash_rounding: itgen_odoo_cash_roundingcash_roundingOdoo.account.financial_year_op: itgen_odoo_financial_year_opfinancial_year_opOdoo.account.link_journal_line: itgen_odoo_link_journal_linelink_journal_lineOdoo.account.multicurrency_revaluation_wizard: itgen_odoo_multicurrency_revaluation_wizardmulticurrency_revaluation_wizardOdoo.account.online_account: itgen_odoo_online_accountonline_accountOdoo.account.online_link: itgen_odoo_online_linkonline_linkOdoo.account.partial_reconcile: itgen_odoo_partial_reconcilepartial_reconcileOdoo.account.root: itgen_odoo_rootrootOdoo.account.transfer_model: itgen_odoo_transfer_modeltransfer_modelOdoo.account_followup.followup_line: itgen_odoo_followup_linefollowup_lineOdoo.account_followup.manual_reminder: itgen_odoo_manual_remindermanual_reminderOdoo.amazon.account: itgen_odoo_accountaccountOdoo.res.usersUOdoo.amazon.marketplace: itgen_odoo_marketplacemarketplaceOdoo.amazon.offer: itgen_odoo_offerofferOdoo.appointment.answer: itgen_odoo_answer (Odoo.appointment.answer_input)answer+_inputOdoo.bank.rec_widget: itgen_odoo_rec_widgetrec_widgetOdoo.bank.rec_widget_line: itgen_odoo_rec_widget_linerec_widget_lineOdoo.barcode.nomenclature: itgen_odoo_nomenclaturenomenclatureOdoo.digest.digest: itgen_odoo_digestdigestOdoo.event.type: itgen_odoo_type (Odoo.event.type_mail, Odoo.event.type_ticket)type+_mail +_ticketOdoo.expense.sample_register: itgen_odoo_sample_registersample_registerOdoo.hr.contract: itgen_odoo_contract (Odoo.hr.contract_employee_report, Odoo.hr.contract_history, Odoo.hr.contract_sign_document_wizard, Odoo.hr.contract_type)contract+_employee_report +_history +_sign_docu…Odoo.hr.expense: itgen_odoo_expense (Odoo.hr.expense_approve_duplicate, Odoo.hr.expense_refuse_wizard, Odoo.hr.expense_sheet, Odoo.hr.expense_split, Odoo.hr.expense_split_wizard)expense+_approve_duplicate +_refuse_wizard +_sh…Odoo.res.usersUOdoo.hr.timesheet_attendance_report: itgen_odoo_timesheet_attendance_reporttimesheet_attendance_reportOdoo.res.usersUOdoo.hr.work_location: itgen_odoo_work_locationwork_locationOdoo.iot.box: itgen_odoo_boxboxOdoo.iot.device: itgen_odoo_devicedeviceOdoo.ir.default: itgen_odoo_defaultdefaultOdoo.res.usersUOdoo.ir.property: itgen_odoo_propertypropertyOdoo.knowledge.article: itgen_odoo_article (Odoo.knowledge.article_favorite, Odoo.knowledge.article_member)article+_favorite +_memberOdoo.res.usersUOdoo.knowledge.invite: itgen_odoo_inviteinviteOdoo.lunch.cashmove: itgen_odoo_cashmove (Odoo.lunch.cashmove_report)cashmove+_reportOdoo.res.usersUOdoo.lunch.location: itgen_odoo_locationlocationOdoo.mail.followers: itgen_odoo_followersfollowersOdoo.mail.tracking_value: itgen_odoo_tracking_valuetracking_valueOdoo.maintenance.equipment: itgen_odoo_equipment (Odoo.maintenance.equipment_category)equipment+_categoryOdoo.marketing.campaign: itgen_odoo_campaign (Odoo.marketing.campaign_test)campaign+_testOdoo.res.usersUOdoo.mrp.document: itgen_odoo_documentdocumentOdoo.onboarding.onboarding: itgen_odoo_onboarding (Odoo.appointment.onboarding_link, Odoo.onboarding.onboarding_step)onboarding+_link +_stepOdoo.onboarding.progress: itgen_odoo_progress (Odoo.onboarding.progress_step)progress+_stepOdoo.payment.link_wizard: itgen_odoo_link_wizardlink_wizardOdoo.planning.planning: itgen_odoo_planning (Odoo.slot.planning_select_send)planning+_select_sendOdoo.pos.bill: itgen_odoo_bill (Odoo.purchase.bill_union)bill+_unionOdoo.product.attribute: itgen_odoo_attribute (Odoo.product.attribute_custom_value, Odoo.product.attribute_value)attribute+_custom_value +_valueOdoo.product.packaging: itgen_odoo_packagingpackagingOdoo.product.public_category: itgen_odoo_public_categorypublic_categoryOdoo.product.ribbon: itgen_odoo_ribbonribbonOdoo.product.supplierinfo: itgen_odoo_supplierinfosupplierinfoOdoo.product.tag: itgen_odoo_tagtagOdoo.product.template: itgen_odoo_template (Odoo.product.template_attribute_exclusion, Odoo.product.template_attribute_line, Odoo.product.template_attribute_value)template+_attribute_exclusion +_attribute_line +_at…Odoo.rating.rating: itgen_odoo_ratingratingOdoo.res.company: itgen_odoo_company (Odoo.consolidation.company_period)company+_periodOdoo.res.config: itgen_odoo_config (Odoo.res.config_installer, Odoo.res.config_settings)config+_installer +_settingsOdoo.res.currency: itgen_odoo_currency (Odoo.res.currency_rate)currency+_rateOdoo.res.partner: itgen_odoo_partner (Odoo.account.partner_ledger_report_handler, Odoo.base.partner_merge_automatic_wizard, Odoo.base.partner_merge_line, Odoo.res.partner_autocomplete_sync, Odoo.res.partner_bank, Odoo.res.partner_category, Odoo.res.partner_industry, Odoo.res.partner_title)partner+_autocomplete_sync +_bank +_category +…Odoo.res.usersUOdoo.sale.advance_payment_inv: itgen_odoo_advance_payment_invadvance_payment_invOdoo.sale.subscription_change_customer_wizard: itgen_odoo_subscription_change_customer_wizardsubscription_change_customer_wizardOdoo.sign.log: itgen_odoo_loglogOdoo.res.usersUOdoo.slide.channel: itgen_odoo_channel (Odoo.slide.channel_invite, Odoo.slide.channel_partner, Odoo.slide.channel_tag, Odoo.slide.channel_tag_group)channel+_invite +_partner +_tag +_tag_groupOdoo.res.usersUOdoo.social.live_post: itgen_odoo_live_postlive_postOdoo.social.post: itgen_odoo_post (Odoo.social.post_template, Odoo.social.post_to_lead)post+_template +_to_leadOdoo.stock.putaway_rule: itgen_odoo_putaway_ruleputaway_ruleOdoo.stock.replenishment_info: itgen_odoo_replenishment_inforeplenishment_infoOdoo.stock.route: itgen_odoo_routerouteOdoo.stock.storage_category: itgen_odoo_storage_categorystorage_categoryOdoo.stock.storage_category_capacity: itgen_odoo_storage_category_capacitystorage_category_capacityOdoo.stock.valuation_layer_revaluation: itgen_odoo_valuation_layer_revaluationvaluation_layer_revaluationOdoo.timesheets.analysis_report: itgen_odoo_analysis_reportanalysis_reportOdoo.res.usersUOdoo.utm.campaign: itgen_odoo_campaigncampaignOdoo.res.usersUOdoo.vendor.delay_report: itgen_odoo_delay_reportdelay_reportOdoo.voip.phonecall: itgen_odoo_phonecall (Odoo.voip.phonecall_log_wizard, Odoo.voip.phonecall_report)phonecall+_log_wizard +_reportOdoo.res.usersUOdoo.website.multi_mixin: itgen_odoo_multi_mixinmulti_mixinOdoo.website.published_multi_mixin: itgen_odoo_published_multi_mixinpublished_multi_mixinOdoo.website.rewrite: itgen_odoo_rewriterewriteOdoo.website.snippet_filter: itgen_odoo_snippet_filtersnippet_filterOdoo.account.incoterms: itgen_odoo_incotermsincotermsOrderOdoo.consolidation.chart: itgen_odoo_chart (Odoo.account.chart_template)chartAccount · chartOdoo.res.currencyROdoo.consolidation.period: itgen_odoo_period (Odoo.consolidation.period_composition)periodAccount · chartOdoo.documents.folder: itgen_odoo_folder (Odoo.documents.folder_deletion_wizard)folderAccount · folderOdoo.res.companyCOdoo.hr.department: itgen_odoo_departmentdepartmentWork · employeeOdoo.res.companyCOdoo.hr.employee: itgen_odoo_employee (Odoo.hr.employee_base, Odoo.hr.employee_category, Odoo.hr.employee_delete_wizard, Odoo.hr.employee_public, Odoo.hr.employee_skill, Odoo.hr.employee_skill_log, Odoo.hr.employee_skill_report)employeeWork · employeeOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdoo.hr.job: itgen_odoo_jobjobRecruitmentOdoo.res.companyCOdoo.res.usersUOdoo.mail.alias: itgen_odoo_alias (Odoo.mail.alias_mixin)aliasRecruitmentOdoo.mailing.filter: itgen_odoo_filterfilterFilterOdoo.product.pricelist: itgen_odoo_pricelist (Odoo.product.pricelist_item)pricelistOrderOdoo.res.companyCOdoo.res.currencyROdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCreateOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.project.task: itgen_odoo_task (Odoo.project.task_burndown_chart_report, Odoo.project.task_confirm_schedule_line_wizard, Odoo.project.task_confirm_schedule_wizard, Odoo.project.task_convert_wizard, Odoo.project.task_create_timesheet, Odoo.project.task_recurrence, Odoo.project.task_stage_personal, Odoo.project.task_stop_timers_wizard, Odoo.project.task_stop_timers_wizard_line, Odoo.project.task_type, Odoo.project.task_type_delete_wizard)taskOrderOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.report.paperformat: itgen_odoo_paperformatpaperformatActionOdoo.res.bank: itgen_odoo_bank (Odoo.account.bank_reconciliation_report_handler, Odoo.account.bank_statement, Odoo.account.bank_statement_line)bankAccount · bankOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.res.country: itgen_odoo_country (Odoo.res.country_group, Odoo.res.country_state)countryAccount · countryOdoo.res.currencyROdoo.res.groups: itgen_odoo_groupsgroupsGroupOdoo.stock.warehouse: itgen_odoo_warehouse (Odoo.stock.warehouse_orderpoint)warehouseAccount · warehouseOdoo.res.companyCOdoo.res.partnerPOdoo.uom.uom: itgen_odoo_uomuomAccount · uomOdoo.utm.source: itgen_odoo_source (Odoo.utm.source_mixin)sourceAccount · sourceOdoo.website.menu: itgen_odoo_menumenuAccount · menuOdoo.website.page: itgen_odoo_pagepageAccount · menuOrder×3×2×2×4×2×2×2×2Odoo.account.incoterms: itgen_odoo_incotermsincotermsOdoo.account.tax: itgen_odoo_tax (Odoo.account.tax_group, Odoo.account.tax_repartition_line, Odoo.account.tax_repartition_line_template, Odoo.account.tax_template, Odoo.account.tax_unit)tax+_group +_repartition_line +_repartition_li…Odoo.res.companyCOdoo.calendar.attendee: itgen_odoo_attendeeattendeeOdoo.res.partnerPOdoo.calendar.recurrence: itgen_odoo_recurrencerecurrenceOdoo.gamification.goal: itgen_odoo_goal (Odoo.gamification.goal_definition, Odoo.gamification.goal_wizard)goal+_definition +_wizardOdoo.res.usersUOdoo.lunch.order: itgen_odoo_order (Odoo.rental.order_wizard, Odoo.rental.order_wizard_line)order+_wizard +_wizard_lineOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdoo.pos.order: itgen_odoo_order (Odoo.pos.order_line)order+_lineOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.product.pricelist: itgen_odoo_pricelist (Odoo.product.pricelist_item)pricelist+_itemOdoo.res.companyCOdoo.res.currencyROdoo.product.pricing: itgen_odoo_pricingpricingOdoo.res.companyCOdoo.res.currencyROdoo.project.task: itgen_odoo_task (Odoo.project.task_burndown_chart_report, Odoo.project.task_confirm_schedule_line_wizard, Odoo.project.task_confirm_schedule_wizard, Odoo.project.task_convert_wizard, Odoo.project.task_create_timesheet, Odoo.project.task_recurrence, Odoo.project.task_stage_personal, Odoo.project.task_stop_timers_wizard, Odoo.project.task_stop_timers_wizard_line, Odoo.project.task_type, Odoo.project.task_type_delete_wizard)task+_burndown_chart_report +_confirm_sche…Odoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.purchase.order: itgen_odoo_order (Odoo.purchase.order_line)order+_lineOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.repair.fee: itgen_odoo_feefeeOdoo.res.companyCOdoo.res.currencyROdoo.repair.line: itgen_odoo_linelineOdoo.res.companyCOdoo.res.currencyROdoo.repair.order: itgen_odoo_order (Odoo.repair.order_make_invoice)order+_make_invoiceOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.sale.order: itgen_odoo_order (Odoo.sale.order_alert, Odoo.sale.order_cancel, Odoo.sale.order_close_reason, Odoo.sale.order_line, Odoo.sale.order_log, Odoo.sale.order_option, Odoo.sale.order_stage, Odoo.sale.order_template, Odoo.sale.order_template_line, Odoo.sale.order_template_option)order+_alert +_cancel +_close_reason +_line +_l…Odoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.sale.rental_report: itgen_odoo_rental_reportrental_reportOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.sale.subscription_report: itgen_odoo_subscription_reportsubscription_reportOdoo.res.companyCOdoo.res.partnerPOdoo.res.usersUOdoo.stock.lot: itgen_odoo_lotlotOdoo.res.companyCOdoo.stock.quant: itgen_odoo_quant (Odoo.stock.quant_package)quant+_packageOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdoo.Odoo.website: itgen_odoo_website (Odoo.theme.website_menu, Odoo.theme.website_page)websiteAccount · companyOdoo.res.usersUOdoo.base.automation: itgen_odoo_automationautomationGroupOdoo.delivery.carrier: itgen_odoo_carrier (Odoo.delivery.carrier_easypost)carrierAccount · carrierOdoo.res.companyCOdoo.gamification.challenge: itgen_odoo_challenge (Odoo.gamification.challenge_line)challengeUserOdoo.hr.employee: itgen_odoo_employee (Odoo.hr.employee_base, Odoo.hr.employee_category, Odoo.hr.employee_delete_wizard, Odoo.hr.employee_public, Odoo.hr.employee_skill, Odoo.hr.employee_skill_log, Odoo.hr.employee_skill_report)employeeWork · employeeOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdoo.lunch.supplier: itgen_odoo_suppliersupplierGroupOdoo.res.companyCOdoo.res.partnerPOdoo.pos.session: itgen_odoo_session (Odoo.pos.session_check_product_wizard)sessionAccount · transactionOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdoo.project.milestone: itgen_odoo_milestonemilestoneCreateOdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCreateOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.res.country: itgen_odoo_country (Odoo.res.country_group, Odoo.res.country_state)countryAccount · countryOdoo.res.currencyROdoo.res.groups: itgen_odoo_groupsgroupsGroupOdoo.stock.picking: itgen_odoo_picking (Odoo.stock.picking_type)pickingAccount · pickingOdoo.res.companyCOdoo.res.partnerPOdoo.res.usersUOdoo.stock.warehouse: itgen_odoo_warehouse (Odoo.stock.warehouse_orderpoint)warehouseAccount · warehouseOdoo.res.companyCOdoo.res.partnerPOdoo.uom.uom: itgen_odoo_uomuomAccount · uomOdoo.utm.medium: itgen_odoo_mediummediumAccount · sourceOdoo.utm.source: itgen_odoo_source (Odoo.utm.source_mixin)sourceAccount · sourceAccount · transactionOdoo.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSOdoo.payment.provider: itgen_odoo_provider (Odoo.calendar.provider_config, Odoo.payment.provider_onboarding_wizard)provider+_config +_onboarding_wizardOdoo.res.companyCOdoo.payment.refund_wizard: itgen_odoo_refund_wizardrefund_wizardOdoo.res.currencyROdoo.payment.token: itgen_odoo_tokentokenOdoo.res.companyCOdoo.res.partnerPOdoo.payment.transaction: itgen_odoo_transactiontransactionOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.pos.payment: itgen_odoo_payment (Odoo.pos.payment_method)payment+_methodOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.pos.session: itgen_odoo_session (Odoo.pos.session_check_product_wizard)session+_check_product_wizardOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdoo.report.pos_order: itgen_odoo_pos_orderpos_orderOdoo.res.companyCOdoo.res.partnerPOdoo.res.usersUOdoo.sign.item: itgen_odoo_item (Odoo.ebay.item_condition, Odoo.sign.item_option, Odoo.sign.item_role, Odoo.sign.item_type)item+_condition +_option +_role +_typeOdoo.Odoo.website: itgen_odoo_website (Odoo.theme.website_menu, Odoo.theme.website_page)websiteAccount · companyOdoo.res.usersUOdoo.hr.employee: itgen_odoo_employee (Odoo.hr.employee_base, Odoo.hr.employee_category, Odoo.hr.employee_delete_wizard, Odoo.hr.employee_public, Odoo.hr.employee_skill, Odoo.hr.employee_skill_log, Odoo.hr.employee_skill_report)employeeWork · employeeOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdoo.product.pricelist: itgen_odoo_pricelist (Odoo.product.pricelist_item)pricelistOrderOdoo.res.companyCOdoo.res.currencyRAccount · carrier×2×2×2Odoo.choose.delivery_carrier: itgen_odoo_delivery_carrierdelivery_carrierOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.delivery.carrier: itgen_odoo_carrier (Odoo.delivery.carrier_easypost)carrier+_easypostOdoo.res.companyCOdoo.delivery.price_rule: itgen_odoo_price_ruleprice_ruleOdoo.sendcloud.shipping_wizard: itgen_odoo_shipping_wizardshipping_wizardOdoo.stock.move: itgen_odoo_move (Odoo.stock.move_line)move+_lineOdoo.res.companyCOdoo.res.partnerPOdoo.Odoo.website: itgen_odoo_website (Odoo.theme.website_menu, Odoo.theme.website_page)websiteAccount · companyOdoo.res.usersUOdoo.mrp.production: itgen_odoo_production (Odoo.change.production_qty, Odoo.mrp.production_backorder, Odoo.mrp.production_backorder_line, Odoo.mrp.production_split, Odoo.mrp.production_split_line, Odoo.mrp.production_split_multi)productionReportOdoo.res.companyCOdoo.res.usersUOdoo.mrp.unbuild: itgen_odoo_unbuildunbuildAccount · bomOdoo.res.companyCOdoo.mrp.workorder: itgen_odoo_workorderworkorderRecruitmentOdoo.res.companyCOdoo.res.groups: itgen_odoo_groupsgroupsGroupOdoo.stock.lot: itgen_odoo_lotlotOrderOdoo.res.companyCOdoo.stock.picking: itgen_odoo_picking (Odoo.stock.picking_type)pickingAccount · pickingOdoo.res.companyCOdoo.res.partnerPOdoo.res.usersUOdoo.stock.warehouse: itgen_odoo_warehouse (Odoo.stock.warehouse_orderpoint)warehouseAccount · warehouseOdoo.res.companyCOdoo.res.partnerPAccount · warehouseOdoo.lunch.product: itgen_odoo_product (Odoo.approval.product_line, Odoo.lunch.product_category, Odoo.report.product_report_pricelist, Odoo.report.product_report_producttemplatelabel, Odoo.report.product_report_producttemplatelabel_dymo)product+_category +_line +_report_pricelist +_repo…Odoo.res.companyCOdoo.res.currencyROdoo.product.product: itgen_odoo_productproductOdoo.res.companyCOdoo.res.currencyROdoo.product.replenish: itgen_odoo_replenishreplenishOdoo.res.companyCOdoo.sale.rental_schedule: itgen_odoo_rental_schedulerental_scheduleOdoo.res.companyCOdoo.res.partnerPOdoo.res.usersUOdoo.stock.location: itgen_odoo_locationlocationOdoo.res.companyCOdoo.stock.replenishment_option: itgen_odoo_replenishment_optionreplenishment_optionOdoo.stock.warehouse: itgen_odoo_warehouse (Odoo.stock.warehouse_orderpoint)warehouse+_orderpointOdoo.res.companyCOdoo.res.partnerPOdoo.Odoo.website: itgen_odoo_website (Odoo.theme.website_menu, Odoo.theme.website_page)websiteAccount · companyOdoo.res.usersUOdoo.lunch.supplier: itgen_odoo_suppliersupplierGroupOdoo.res.companyCOdoo.res.partnerPOdoo.mrp.bom: itgen_odoo_bom (Odoo.mrp.bom_byproduct, Odoo.mrp.bom_line)bomAccount · bomOdoo.res.companyCOdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCreateOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.res.country: itgen_odoo_country (Odoo.res.country_group, Odoo.res.country_state)countryAccount · countryOdoo.res.currencyROdoo.res.groups: itgen_odoo_groupsgroupsGroupOdoo.stock.lot: itgen_odoo_lotlotOrderOdoo.res.companyCOdoo.uom.uom: itgen_odoo_uomuomAccount · uomReport×2Odoo.account.report: itgen_odoo_report (Odoo.account.report_column, Odoo.account.report_custom_handler, Odoo.account.report_expression, Odoo.account.report_external_value, Odoo.account.report_footnote, Odoo.account.report_horizontal_group, Odoo.account.report_horizontal_group_rule, Odoo.account.report_line, Odoo.account.report_manager, Odoo.im_livechat.report_channel, Odoo.im_livechat.report_operator)report+_channel +_column +_custom_handler +…Odoo.res.companyCOdoo.res.partnerPOdoo.mrp.production: itgen_odoo_production (Odoo.change.production_qty, Odoo.mrp.production_backorder, Odoo.mrp.production_backorder_line, Odoo.mrp.production_split, Odoo.mrp.production_split_line, Odoo.mrp.production_split_multi)production+_backorder +_backorder_line +_qty +_spli…Odoo.res.companyCOdoo.res.usersUOdoo.mrp.report: itgen_odoo_reportreportOdoo.res.companyCOdoo.res.currencyROdoo.purchase.report: itgen_odoo_reportreportOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.sale.report: itgen_odoo_reportreportOdoo.res.companyCOdoo.res.partnerPOdoo.res.usersUOdoo.stock.assign_serial: itgen_odoo_assign_serialassign_serialOdoo.stock.report: itgen_odoo_reportreportOdoo.res.companyCOdoo.res.partnerPOdoo.Odoo.website: itgen_odoo_website (Odoo.theme.website_menu, Odoo.theme.website_page)websiteAccount · companyOdoo.res.usersUOdoo.mrp.bom: itgen_odoo_bom (Odoo.mrp.bom_byproduct, Odoo.mrp.bom_line)bomAccount · bomOdoo.res.companyCOdoo.product.pricelist: itgen_odoo_pricelist (Odoo.product.pricelist_item)pricelistOrderOdoo.res.companyCOdoo.res.currencyROdoo.res.country: itgen_odoo_country (Odoo.res.country_group, Odoo.res.country_state)countryAccount · countryOdoo.res.currencyROdoo.stock.picking: itgen_odoo_picking (Odoo.stock.picking_type)pickingAccount · pickingOdoo.res.companyCOdoo.res.partnerPOdoo.res.usersUOdoo.stock.warehouse: itgen_odoo_warehouse (Odoo.stock.warehouse_orderpoint)warehouseAccount · warehouseOdoo.res.companyCOdoo.res.partnerPOdoo.utm.medium: itgen_odoo_mediummediumAccount · sourceOdoo.utm.source: itgen_odoo_source (Odoo.utm.source_mixin)sourceAccount · sourceWork · resource×2Odoo.resource.calendar: itgen_odoo_calendar (Odoo.resource.calendar_attendance, Odoo.resource.calendar_leaves)calendar+_attendance +_leavesOdoo.res.companyCOdoo.resource.mixin: itgen_odoo_mixinmixinOdoo.res.companyCOdoo.resource.resource: itgen_odoo_resourceresourceOdoo.res.companyCOdoo.res.usersUOdoo.hr.employee: itgen_odoo_employee (Odoo.hr.employee_base, Odoo.hr.employee_category, Odoo.hr.employee_delete_wizard, Odoo.hr.employee_public, Odoo.hr.employee_skill, Odoo.hr.employee_skill_log, Odoo.hr.employee_skill_report)employeeWork · employeeOdoo.res.companyCOdoo.res.currencyROdoo.res.usersUOdooNotesThis data model declares no keys yet; the dotted relations are derived from column names.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsAccount · bank2Account · bom2Account · carrier1Account · chart2Account · company1Account · country3Account · folder2Account · guest3Account · lead3Account · mailing3Account · media3Account · menu2Account · picking2Account · registration3Account · sequence3Account · slide3Account · source2Account · transaction1Account · uom3Account · warehouse1Action3Analytic3Asset3Create2Filter3Fiscal3Group2Order1Other3Package3Payroll3Reconcile3Record3Recruitment2Referral2Report1Request3Salary3Sale3Stock3Team3Ui3User2Wizard3Work · employee3Work · leave2Work · recurrency3Work · resource1Tables without relations3, 4, 5LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n relations between the same tablesLetters: refers to a table used by most topics: C = company, P = partner, U = users, R = currencyGenerated from the metadata of Invantive UniversalSQL 22.1.135-BETA+3826 on 01-03-2023. Every table links toits page with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/odoo
The poster as text: tables per topic and their relations

Account · company

website, account, accrued_orders_wizard, automatic_entry_wizard, batch_payment, cash_rounding, financial_year_op, link_journal_line, multicurrency_revaluation_wizard, online_account, online_link, partial_reconcile, root, transfer_model, followup_line, manual_reminder, account, marketplace, offer, answer, rec_widget, rec_widget_line, nomenclature, digest, type, sample_register, contract, expense, timesheet_attendance_report, work_location, box, device, default, property, article, invite, cashmove, location, followers, tracking_value, equipment, campaign, document, onboarding, progress, link_wizard, planning, bill, attribute, packaging, public_category, ribbon, supplierinfo, tag, template, rating, company, config, currency, partner, advance_payment_inv, subscription_change_customer_wizard, log, channel, live_post, post, putaway_rule, replenishment_info, route, storage_category, storage_category_capacity, valuation_layer_revaluation, analysis_report, campaign, delay_report, phonecall, multi_mixin, published_multi_mixin, rewrite, snippet_filter

User

device, module_install_request, password_user, iap_lead_mining_request, merge_opportunity, badge, challenge, karma_tracking, resume_line, user_work_entry_employee, stage, log, users, contributor, invite, survey, user_input, user_input_line, timer, tour

Order

incoterms, tax, attendee, recurrence, goal, order, order, pricelist, pricing, task, order, fee, line, order, order, rental_report, subscription_report, lot, quant

Account · folder

edi_document, export_wizard, document, facet, folder, share, tag, workflow_action, workflow_rule, attachment, cover, notification, template, resend, sms, letter

Recruitment

type, applicant, job, recruitment_report, recruitment_sign_document_wizard, recruitment_source, recruitment_stage_report, skill, alias, eco, workcenter, workorder, alert, check, point, reason

Group

group, automation, group, tip, cron, model, alert, supplier, topping, group, groups, rule, approval_entry, approval_rule

Account · source

move, payment, script, vehicle, sla, ticket, tracker, trace, activity, medium, mixin, source

Account · lead

lead, lead2opportunity_partner, lead2opportunity_partner_mass, quotation_partner, activity, note, lang, track, visitor

Account · transaction

NATIVEPLATFORMSCALARREQUESTS, provider, refund_wizard, token, transaction, payment, session, pos_order, item

Create

create_fsm_task, merge_wizard, collaborator, create_invoice, create_sale_order, create_sale_order_line, milestone, project, update

Account · picking

delivery_package, backorder_confirmation_line, immediate_transfer_line, picking, return_picking, scrap, warn_insufficient_qty_scrap, cancel_operation

Account · warehouse

product, product, replenish, rental_schedule, location, replenishment_option, warehouse

Referral

referral_alert, referral_link_to_share, referral_onboarding, referral_points, referral_report, referral_reward, referral_send_mail

Report

report, production, report, report, report, assign_serial, report

Account · country

invoice_report, rule, payslip, contact, list, country

Account · menu

event, event, question, menu, page, ir_model_menu_create

Work · employee

appraisal, department, departure_wizard, employee, work_entry_report, appraisal

Work · leave

approver, attendance, holidays_cancel_leave, leave, work_entry, icon

Account · carrier

delivery_carrier, carrier, price_rule, shipping_wizard, move

Account · chart

account, chart, journal, period, rate

Analytic

analytic_account, analytic_distribution_model, analytic_line, analytic_plan, plan

Fiscal

fiscal_position, fiscal_position_account, fiscal_position_tax, fiscal_position_template, fiscal_year

Payroll

payroll_edit_payslip_line, payroll_edit_payslip_lines_wizard, payroll_report, payroll_structure, payroll_structure_type

Request

request, request, role, send, request

Account · bom

bom, routing_workcenter, unbuild, warn_insufficient_qty_unbuild

Account · guest

presence, channel, guest, message

Account · mailing

invoice_send, mail, mailing, composer

Action

actions_act_window, actions_report, actions_server, paperformat

Asset

asset, modify, asset, assets

Account · bank

journal, setup_bank_manual_config, bank

Account · media

account, media, stream

Account · registration

mail, registration, editor

Account · sequence

category, sequence, config

Account · slide

embed, question, slide

Account · uom

return_picking_line, valuation_layer, uom

Filter

filters, filters, filter

Package

package_destination, package_level, package_type

Reconcile

reconcile_model, reconcile_model_line, reconcile_model_partner_mapping

Record

record, record, record

Salary

salary_attachment, salary_attachment_report, salary_rule

Sale

sale_report, sale_line_employee_map, sale_extra_field

Stock

stock_tracking, stock_tracking_line, stock_quantity

Team

team, team, team

Ui

ui_menu, ui_view, ui_view_custom

Wizard

wizard, wizard, wizard

Work · recurrency

analysis_report, recurrency, slot

Work · resource

calendar, mixin, resource

Other

participant, trace

Account (without relations)

account

Action (without relations)

actions_act_url, actions_act_window_close, actions_act_window_view, actions_actions, actions_client, actions_todo

Address (without relations)

address_mixin

Aged (without relations)

aged_partner_balance_report_handler, aged_payable_report_handler, aged_receivable_report_handler

Alarm (without relations)

alarm

Analytic (without relations)

analytic_applicability

Answer (without relations)

answer

Api (without relations)

api

Approval (without relations)

approval_request

Autocomplete (without relations)

autocomplete_api

Autovacuum (without relations)

autovacuum

Backorder (without relations)

backorder_confirmation

Barcode (without relations)

barcode_events_mixin

Base (without relations)

base

Batch (without relations)

batch_error_wizard, batch_error_wizard_line, batch_payment_rejection

Binary (without relations)

binary

Blacklist (without relations)

blacklist, blacklist

Bot (without relations)

bot

Bus (without relations)

bus

Cash (without relations)

cash_flow_report_handler

Category (without relations)

category, category, category, category

Change (without relations)

change_lock_date, change_product_qty

Channel (without relations)

channel

Close (without relations)

close_session_wizard

Collaborative (without relations)

collaborative_mixin

Compose (without relations)

compose_message

Configurator (without relations)

configurator_feature

Confirm (without relations)

confirm

Consumption (without relations)

consumption_warning, consumption_warning_line

Contract (without relations)

contract

Converter (without relations)

converter_test, converter_test_sub

Dashboard (without relations)

dashboard

Demo (without relations)

demo

Departure (without relations)

departure_reason

Detail (without relations)

details_wizard

Duplicate (without relations)

duplicate_template_pdf

Ec (without relations)

ec_sales_report_handler

Edi (without relations)

edi_common, edi_format, edi_xml_cii, edi_xml_ubl_20, edi_xml_ubl_21, edi_xml_ubl_a_nz, edi_xml_ubl_bis3, edi_xml_ubl_de, edi_xml_ubl_efff, edi_xml_ubl_nl

Enable (without relations)

enable_profiling_wizard

Enrich (without relations)

enrich_api

Export (without relations)

export_wizard_format, exports

Field (without relations)

fields_converter

Fiscal (without relations)

fiscal_position_account_template, fiscal_position_tax_template

Followup (without relations)

followup_report

Full (without relations)

full_reconcile

Gateway (without relations)

gateway_allowed

General (without relations)

general_ledger_report_handler

Generic (without relations)

generic_tax_report_handler, generic_tax_report_handler_account_tax, generic_tax_report_handler_tax_account

Geo (without relations)

geo_provider

Geocoder (without relations)

geocoder

Get (without relations)

get_refuse_reason

Gmail (without relations)

gmail_mixin

Grid (without relations)

grid_mixin

Group (without relations)

group

Holiday (without relations)

holidays_summary_employee

Hr (without relations)

hr_holidays_report_holidayssummary, hr_payroll_contribution_register

Http (without relations)

http

Iap (without relations)

iap_lead_helpers, iap_lead_industry, iap_lead_role, iap_lead_seniority

Ice (without relations)

ice_server

Image (without relations)

image

Immediate (without relations)

immediate_transfer

Import (without relations)

import

Industry (without relations)

industry_fsm_worksheet_custom

Inventory (without relations)

inventory_adjustment_name, inventory_conflict, inventory_warning

Invite (without relations)

invite

Invoice (without relations)

invoice_extract_words

Iot (without relations)

iot_box

Ir (without relations)

ir_actions_account_report_download, ir_asset, ir_attachment, ir_ui_view

Karma (without relations)

karma_rank

Keyboard (without relations)

keyboard_layout

Label (without relations)

label_layout, label_layout, label_type

Language (without relations)

language_export, language_import, language_install

Layout (without relations)

layout

Link (without relations)

link_journal, link_listing, link_preview, link_to_record_wizard

Logging (without relations)

logging

Lookup (without relations)

lookup_wizard, lookup_wizard_line

Lost (without relations)

lost_reason

Make (without relations)

make_payment

Mapping (without relations)

mapping

Mass (without relations)

mass_cancel_orders

Message (without relations)

message

Min (without relations)

min_cron_mixin

Mixin (without relations)

mixin, mixin, mixin, mixin, mixin, mixin, mixin, mixin, mixin, mixin

Model (without relations)

model, model, model

Module (without relations)

module_category, module_install_review, module_module, module_module_dependency, module_module_exclusion, module_uninstall, module_update, module_upgrade

Mrp (without relations)

mrp_account_enterprise_mrp_cost_structure, mrp_account_enterprise_product_template_cost_structure, mrp_report_bom_structure

Multicurrency (without relations)

multicurrency_revaluation_report_handler

Orderpoint (without relations)

orderpoint_snooze

Pack (without relations)

pack_operation_lot

Parent (without relations)

parent_mixin

Password (without relations)

password_own, password_wizard

Payroll (without relations)

payroll_edit_payslip_worked_days_line, payroll_index

Policy (without relations)

policy

Precision (without relations)

precision

Profile (without relations)

profile

Published (without relations)

published_mixin

Quality (without relations)

quality_control_quality_worksheet, quality_control_quality_worksheet_internal

Quantity (without relations)

quantity_history

Question (without relations)

question

Queue (without relations)

queue_mixin

Qweb (without relations)

qweb

Reconcile (without relations)

reconcile_model_line_template, reconcile_model_template

Reconciliation (without relations)

reconciliation_widget

Recover (without relations)

recover_order_wizard

Recruitment (without relations)

recruitment_degree, recruitment_stage

Recurring (without relations)

recurring_plan

Referral (without relations)

referral_alert_mail_wizard, referral_friend, referral_level

Removal (without relations)

removal

Render (without relations)

render_mixin

Resequence (without relations)

resequence_wizard

Reset (without relations)

reset_mixin

Resume (without relations)

resume_line_type

Revision (without relations)

revision

Robot (without relations)

robots

Route (without relations)

route

Rule (without relations)

rule, rule, rule, rules_report

Salary (without relations)

salary_rule_category

Sample (without relations)

sample_receipt

Scheduler (without relations)

scheduler_compute

Searchable (without relations)

searchable_mixin

Seo (without relations)

seo_metadata

Server (without relations)

server

Service (without relations)

service

Share (without relations)

share

Shipping (without relations)

shipping_product

Shortcode (without relations)

shortcode

Sign (without relations)

sign_green_savings_report

Site (without relations)

site

Slot (without relations)

slot

Spreadsheet (without relations)

spreadsheet_template

Stage (without relations)

stage, stage, stage, stage, stage

Stock (without relations)

stock_label_product_product_view, stock_report_product_product_replenishment, stock_report_product_template_replenishment, stock_report_reception, stock_report_stock_rule, stock_sms

Subscription (without relations)

subscription_close_reason_wizard

Tag (without relations)

tag, tag, tag, tag, tag, tag, tag, tags, tags

Template (without relations)

template, template, template, template

Temporal (without relations)

temporal_recurrence

Thread (without relations)

thread

Traceability (without relations)

traceability_report

Transfer (without relations)

transfer_model_line

Trial (without relations)

trial_balance_report_handler, trial_balance_report_handler

Twitter (without relations)

twitter_account

Unreconcile (without relations)

unreconcile

Util (without relations)

utils

View (without relations)

view_arch_wizard

Warn (without relations)

warn_insufficient_qty, warn_insufficient_qty_repair

Websocket (without relations)

websocket

Work (without relations)

work_entry_regeneration_wizard, work_entry_type

X (without relations)

x_project_task_worksheet_template_1, x_project_task_worksheet_template_2

Zip (without relations)

zip_prefix

_unknown (without relations)

_unknown

Relations

Tables

Odoo.Native

Odoo.Odoo

Odoo.account

Odoo.account_followup

Odoo.account_reports

Odoo.add

Odoo.amazon

Odoo.analytic

  • mixin: itgen_odoo_mixin

Odoo.applicant

Odoo.appointment

Odoo.approval

Odoo.asset

Odoo.auth_totp

Odoo.avatar

  • mixin: itgen_odoo_mixin

Odoo.bank

Odoo.barcode

Odoo.barcodes

Odoo.base

Odoo.base_import

Odoo.bus

Odoo.calendar

Odoo.change

Odoo.chatbot

Odoo.choose

Odoo.confirm

Odoo.consolidation

Odoo.crm

Odoo.data_cleaning

Odoo.data_merge

Odoo.data_recycle

Odoo.decimal

Odoo.delivery

Odoo.digest

  • digest: itgen_odoo_digest
  • tip: itgen_odoo_tip

Odoo.documents

Odoo.easypost

Odoo.ebay

Odoo.event

Odoo.expense

Odoo.extract

  • mixin: itgen_odoo_mixin

Odoo.fetchmail

Odoo.fleet

Odoo.format

Odoo.fsm

Odoo.gamification

Odoo.google

Odoo.helpdesk

Odoo.hr

Odoo.hr_timesheet

Odoo.iap

Odoo.im_livechat

Odoo.image

  • mixin: itgen_odoo_mixin

Odoo.iot

Odoo.ir

Odoo.knowledge

Odoo.lot

Odoo.lunch

Odoo.mail

Odoo.mailing

Odoo.maintenance

Odoo.marketing

Odoo.mrp

Odoo.note

  • note: itgen_odoo_note
  • stage: itgen_odoo_stage
  • tag: itgen_odoo_tag

Odoo.onboarding

Odoo.payment

Odoo.phone

Odoo.picking

Odoo.planning

Odoo.portal

Odoo.pos

Odoo.privacy

Odoo.procurement

  • group: itgen_odoo_group

Odoo.product

Odoo.project

Odoo.publisher_warranty

Odoo.purchase

Odoo.quality

Odoo.rating

Odoo.registration

Odoo.rental

Odoo.repair

Odoo.report

Odoo.request

Odoo.res

Odoo.reset

Odoo.resource

Odoo.sale

Odoo.save

Odoo.sendcloud

Odoo.sequence

  • mixin: itgen_odoo_mixin

Odoo.sign

Odoo.slide

Odoo.slot

Odoo.sms

Odoo.snailmail

Odoo.social

Odoo.spreadsheet

Odoo.stock

Odoo.stock_barcode

Odoo.studio

Odoo.survey

Odoo.template

Odoo.theme

Odoo.timer

Odoo.timesheet

Odoo.timesheets

Odoo.uom

Odoo.utm

Odoo.validate

Odoo.vendor

Odoo.voip

Odoo.web_editor

Odoo.web_tour

  • tour: itgen_odoo_tour

Odoo.website

Odoo.wizard

Odoo.worksheet

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: