invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Odoo Data Model

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su API.
  • Los datos se agrupan por categorías, como por empresa o por administración.
  • Una Query puede leer varios datos de empresas a la vez.
  • Los datos se pueden leer y escribir.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Cifras

Figure Count
Tables 876
Columns 26,381

Póster del Modelo de Datos

Este modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de los nombres de las columnas.

PDF, 5 hojas A0

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Odoo Modelo de Datos, Hoja 1 de 5Odoo Modelo de Datospara su uso con Invantive UniversalSQLComunicado 22.1.135-BETA+3826 · 01-03-2023Account · company · Orden · Account · transaction · Account · carrier · Account · warehouse · Reporte · Work · resourceHoja 1 de 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_incotermsincotermsOrdenOdoo.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_filterfilterFiltroOdoo.product.pricelist: itgen_odoo_pricelist (Odoo.product.pricelist_item)pricelistOrdenOdoo.res.companyCOdoo.res.currencyROdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCrearOdoo.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)taskOrdenOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.report.paperformat: itgen_odoo_paperformatpaperformatAcciónOdoo.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_groupsgroupsGrupoOdoo.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 · menuOrden×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_automationautomationGrupoOdoo.delivery.carrier: itgen_odoo_carrier (Odoo.delivery.carrier_easypost)carrierAccount · carrierOdoo.res.companyCOdoo.gamification.challenge: itgen_odoo_challenge (Odoo.gamification.challenge_line)challengeUsuarioOdoo.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_suppliersupplierGrupoOdoo.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_milestonemilestoneCrearOdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCrearOdoo.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_groupsgroupsGrupoOdoo.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)pricelistOrdenOdoo.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)productionReporteOdoo.res.companyCOdoo.res.usersUOdoo.mrp.unbuild: itgen_odoo_unbuildunbuildAccount · bomOdoo.res.companyCOdoo.mrp.workorder: itgen_odoo_workorderworkorderRecruitmentOdoo.res.companyCOdoo.res.groups: itgen_odoo_groupsgroupsGrupoOdoo.stock.lot: itgen_odoo_lotlotOrdenOdoo.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_suppliersupplierGrupoOdoo.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)projectCrearOdoo.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_groupsgroupsGrupoOdoo.stock.lot: itgen_odoo_lotlotOrdenOdoo.res.companyCOdoo.uom.uom: itgen_odoo_uomuomAccount · uomReporte×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)pricelistOrdenOdoo.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.usersUOdooNotasEste modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de losnombres de las columnas.Diccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasAcción3Account · bank2Account · bom2Account · carrier1Account · chart2Account · company1Account · country3Account · folder2Account · guest3Account · lead3Account · mailing3Account · media3Account · menu2Account · picking2Account · registration3Account · sequence3Account · slide3Account · source2Account · transaction1Account · uom3Account · warehouse1Activo3Almacén3Analytic3Conciliar3Crear2Equipo3Filtro3Fiscal3Grupo2Nómina3Orden1Otro3Paquete3Record3Recruitment2Referral2Reporte1Salario3Sale3Solicitud3Ui3Usuario2Wizard3Work · employee3Work · leave2Work · recurrency3Work · resource1Tablas sin relaciones3, 4, 5LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes×n: n relations between the same tablesLetras: se refiere a una tabla que se utiliza en la mayoría de los temas: C = company, P = partner, U =users, R = currencyGenerado a partir de los metadatos de Invantive UniversalSQL 22.1.135-BETA+3826 el 01-03-2023. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/odoo
El póster en forma de texto: tablas por tema y sus relaciones

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

Usuario

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

Orden

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

Grupo

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

Crear

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

Reporte

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

Nómina

payroll_edit_payslip_line, payroll_edit_payslip_lines_wizard, payroll_report, payroll_structure, payroll_structure_type

Solicitud

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

Acción

actions_act_window, actions_report, actions_server, paperformat

Activo

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

Filtro

filters, filters, filter

Paquete

package_destination, package_level, package_type

Conciliar

reconcile_model, reconcile_model_line, reconcile_model_partner_mapping

Record

record, record, record

Salario

salary_attachment, salary_attachment_report, salary_rule

Sale

sale_report, sale_line_employee_map, sale_extra_field

Almacén

stock_tracking, stock_tracking_line, stock_quantity

Equipo

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

Otro

participant, trace

Cuenta (sin relaciones)

account

Acción (sin relaciones)

actions_act_url, actions_act_window_close, actions_act_window_view, actions_actions, actions_client, actions_todo

Dirección (sin relaciones)

address_mixin

Aged (sin relaciones)

aged_partner_balance_report_handler, aged_payable_report_handler, aged_receivable_report_handler

Alarm (sin relaciones)

alarm

Analytic (sin relaciones)

analytic_applicability

Respuesta (sin relaciones)

answer

Api (sin relaciones)

api

Aprobación (sin relaciones)

approval_request

Autocompletar (sin relaciones)

autocomplete_api

Autovacuum (sin relaciones)

autovacuum

Backorder (sin relaciones)

backorder_confirmation

Código de Barras (sin relaciones)

barcode_events_mixin

Base (sin relaciones)

base

Lote (sin relaciones)

batch_error_wizard, batch_error_wizard_line, batch_payment_rejection

Binario (sin relaciones)

binary

Lista negra (sin relaciones)

blacklist, blacklist

Bot (sin relaciones)

bot

Bus (sin relaciones)

bus

Efectivo (sin relaciones)

cash_flow_report_handler

Categoría (sin relaciones)

category, category, category, category

Cambio (sin relaciones)

change_lock_date, change_product_qty

Canal (sin relaciones)

channel

Cerrar (sin relaciones)

close_session_wizard

Collaborative (sin relaciones)

collaborative_mixin

Compose (sin relaciones)

compose_message

Configurator (sin relaciones)

configurator_feature

Confirmar (sin relaciones)

confirm

Consumption (sin relaciones)

consumption_warning, consumption_warning_line

Contrato (sin relaciones)

contract

Converter (sin relaciones)

converter_test, converter_test_sub

Panel de Control (sin relaciones)

dashboard

Demo (sin relaciones)

demo

Departure (sin relaciones)

departure_reason

Detalle (sin relaciones)

details_wizard

Duplicado (sin relaciones)

duplicate_template_pdf

Ec (sin relaciones)

ec_sales_report_handler

Edi (sin relaciones)

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

Habilitar (sin relaciones)

enable_profiling_wizard

Enrich (sin relaciones)

enrich_api

Exportar (sin relaciones)

export_wizard_format, exports

Campo (sin relaciones)

fields_converter

Fiscal (sin relaciones)

fiscal_position_account_template, fiscal_position_tax_template

Followup (sin relaciones)

followup_report

Full (sin relaciones)

full_reconcile

Puerta de Enlace (sin relaciones)

gateway_allowed

General (sin relaciones)

general_ledger_report_handler

Genérico (sin relaciones)

generic_tax_report_handler, generic_tax_report_handler_account_tax, generic_tax_report_handler_tax_account

Geo (sin relaciones)

geo_provider

Geocoder (sin relaciones)

geocoder

Get (sin relaciones)

get_refuse_reason

Gmail (sin relaciones)

gmail_mixin

Grid (sin relaciones)

grid_mixin

Grupo (sin relaciones)

group

Vacaciones (sin relaciones)

holidays_summary_employee

Hr (sin relaciones)

hr_holidays_report_holidayssummary, hr_payroll_contribution_register

Http (sin relaciones)

http

Iap (sin relaciones)

iap_lead_helpers, iap_lead_industry, iap_lead_role, iap_lead_seniority

Ice (sin relaciones)

ice_server

Imagen (sin relaciones)

image

Immediate (sin relaciones)

immediate_transfer

Importar (sin relaciones)

import

Sector (sin relaciones)

industry_fsm_worksheet_custom

Inventario (sin relaciones)

inventory_adjustment_name, inventory_conflict, inventory_warning

Invite (sin relaciones)

invite

Factura (sin relaciones)

invoice_extract_words

Iot (sin relaciones)

iot_box

Ir (sin relaciones)

ir_actions_account_report_download, ir_asset, ir_attachment, ir_ui_view

Karma (sin relaciones)

karma_rank

Keyboard (sin relaciones)

keyboard_layout

Etiqueta (sin relaciones)

label_layout, label_layout, label_type

Idioma (sin relaciones)

language_export, language_import, language_install

Plantilla (sin relaciones)

layout

Enlace (sin relaciones)

link_journal, link_listing, link_preview, link_to_record_wizard

Inicio de Sesión (sin relaciones)

logging

Buscar (sin relaciones)

lookup_wizard, lookup_wizard_line

Lost (sin relaciones)

lost_reason

Make (sin relaciones)

make_payment

Mapping (sin relaciones)

mapping

Mass (sin relaciones)

mass_cancel_orders

Mensaje (sin relaciones)

message

Min (sin relaciones)

min_cron_mixin

Mixin (sin relaciones)

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

Modelo (sin relaciones)

model, model, model

Módulo (sin relaciones)

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

Mrp (sin relaciones)

mrp_account_enterprise_mrp_cost_structure, mrp_account_enterprise_product_template_cost_structure, mrp_report_bom_structure

Multicurrency (sin relaciones)

multicurrency_revaluation_report_handler

Orderpoint (sin relaciones)

orderpoint_snooze

Pack (sin relaciones)

pack_operation_lot

Elemento Primario (sin relaciones)

parent_mixin

Contraseña (sin relaciones)

password_own, password_wizard

Nómina (sin relaciones)

payroll_edit_payslip_worked_days_line, payroll_index

Policy (sin relaciones)

policy

Precisión (sin relaciones)

precision

Perfil (sin relaciones)

profile

Publicado (sin relaciones)

published_mixin

Quality (sin relaciones)

quality_control_quality_worksheet, quality_control_quality_worksheet_internal

Cantidad (sin relaciones)

quantity_history

Pregunta (sin relaciones)

question

Cola (sin relaciones)

queue_mixin

Qweb (sin relaciones)

qweb

Conciliar (sin relaciones)

reconcile_model_line_template, reconcile_model_template

Reconciliation (sin relaciones)

reconciliation_widget

Recover (sin relaciones)

recover_order_wizard

Recruitment (sin relaciones)

recruitment_degree, recruitment_stage

Recurrente (sin relaciones)

recurring_plan

Referral (sin relaciones)

referral_alert_mail_wizard, referral_friend, referral_level

Removal (sin relaciones)

removal

Render (sin relaciones)

render_mixin

Resequence (sin relaciones)

resequence_wizard

Restablecer (sin relaciones)

reset_mixin

Reanudar (sin relaciones)

resume_line_type

Revisión (sin relaciones)

revision

Robot (sin relaciones)

robots

Route (sin relaciones)

route

Regla (sin relaciones)

rule, rule, rule, rules_report

Salario (sin relaciones)

salary_rule_category

Muestra (sin relaciones)

sample_receipt

Scheduler (sin relaciones)

scheduler_compute

Se puede buscar (sin relaciones)

searchable_mixin

Seo (sin relaciones)

seo_metadata

Servidor (sin relaciones)

server

Servicio (sin relaciones)

service

Compartir (sin relaciones)

share

Shipping (sin relaciones)

shipping_product

Shortcode (sin relaciones)

shortcode

Firmar (sin relaciones)

sign_green_savings_report

Sitio (sin relaciones)

site

Slot (sin relaciones)

slot

Spreadsheet (sin relaciones)

spreadsheet_template

Etapa (sin relaciones)

stage, stage, stage, stage, stage

Almacén (sin relaciones)

stock_label_product_product_view, stock_report_product_product_replenishment, stock_report_product_template_replenishment, stock_report_reception, stock_report_stock_rule, stock_sms

Suscripción (sin relaciones)

subscription_close_reason_wizard

Etiqueta (sin relaciones)

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

Plantilla (sin relaciones)

template, template, template, template

Temporal (sin relaciones)

temporal_recurrence

Hilo (sin relaciones)

thread

Traceability (sin relaciones)

traceability_report

Transfer (sin relaciones)

transfer_model_line

Trial (sin relaciones)

trial_balance_report_handler, trial_balance_report_handler

Twitter (sin relaciones)

twitter_account

Unreconcile (sin relaciones)

unreconcile

Util (sin relaciones)

utils

Vista (sin relaciones)

view_arch_wizard

Warn (sin relaciones)

warn_insufficient_qty, warn_insufficient_qty_repair

Websocket (sin relaciones)

websocket

Work (sin relaciones)

work_entry_regeneration_wizard, work_entry_type

X (sin relaciones)

x_project_task_worksheet_template_1, x_project_task_worksheet_template_2

Zip (sin relaciones)

zip_prefix

_unknown (sin relaciones)

_unknown

Relaciones

Tablas

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

Atributos

Las características de esta plataforma se encuentran en la página Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: