invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Modèle de données Odoo

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Une Query peut interroger plusieurs entreprises à la fois.
  • Les données peuvent être aussi bien écrites que lues.
  • Forfaits Invantive Cloud : Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Chiffres

Figure Count
Tables 876
Columns 26,381

Affiche sur le modèle de données

Ce modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des points sont dérivées des noms de colonnes.

PDF, 5 feuilles A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

Odoo Modèle de données, Page 1 sur 5Odoo Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 22.1.135-BETA+3826 · 01-03-2023Account · company · Commande · Account · transaction · Account · carrier · Account · warehouse · Rapport · Work · resourcePage 1 sur 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_incotermsincotermsCommandeOdoo.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_filterfilterFiltreOdoo.product.pricelist: itgen_odoo_pricelist (Odoo.product.pricelist_item)pricelistCommandeOdoo.res.companyCOdoo.res.currencyROdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCréerOdoo.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)taskCommandeOdoo.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_groupsgroupsGroupeOdoo.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 · menuCommande×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_automationautomationGroupeOdoo.delivery.carrier: itgen_odoo_carrier (Odoo.delivery.carrier_easypost)carrierAccount · carrierOdoo.res.companyCOdoo.gamification.challenge: itgen_odoo_challenge (Odoo.gamification.challenge_line)challengeUtilisateurOdoo.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_suppliersupplierGroupeOdoo.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_milestonemilestoneCréerOdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCréerOdoo.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_groupsgroupsGroupeOdoo.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)pricelistCommandeOdoo.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)productionRapportOdoo.res.companyCOdoo.res.usersUOdoo.mrp.unbuild: itgen_odoo_unbuildunbuildAccount · bomOdoo.res.companyCOdoo.mrp.workorder: itgen_odoo_workorderworkorderRecruitmentOdoo.res.companyCOdoo.res.groups: itgen_odoo_groupsgroupsGroupeOdoo.stock.lot: itgen_odoo_lotlotCommandeOdoo.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_suppliersupplierGroupeOdoo.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)projectCréerOdoo.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_groupsgroupsGroupeOdoo.stock.lot: itgen_odoo_lotlotCommandeOdoo.res.companyCOdoo.uom.uom: itgen_odoo_uomuomAccount · uomRapport×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)pricelistCommandeOdoo.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.usersUOdooNotesCe modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des pointssont dérivées des noms de colonnes.Dictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.SujetsAccount · bank2Account · bom2Account · carrier1Account · chart2Account · company1Account · country3Account · folder2Account · guest3Account · lead3Account · mailing3Account · media3Account · menu2Account · picking2Account · registration3Account · sequence3Account · slide3Account · source2Account · transaction1Account · uom3Account · warehouse1Actif3Action3Analytic3Autre3Commande1Créer2Demande3Équipe3Filtre3Fiscal3Groupe2Paie3Paquetage3Rapport1Réconcilier3Record3Recruitment2Referral2Salaire3Sale3Stock3Ui3Utilisateur2Wizard3Work · employee3Work · leave2Work · recurrency3Work · resource1Tables sans relations3, 4, 5LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes×n: n relations between the same tablesLettres : désigne une table utilisée dans la plupart des rubriques: C = company, P = partner, U = users, R =currencyGénéré à partir des métadonnées d'Invantive UniversalSQL 22.1.135-BETA+3826 le 01-03-2023. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/odoo
L'affiche sous forme de texte : tableaux par thème et leurs 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

Utilisateur

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

Commande

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

Groupe

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

Créer

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

Rapport

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

Paie

payroll_edit_payslip_line, payroll_edit_payslip_lines_wizard, payroll_report, payroll_structure, payroll_structure_type

Demande

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

Actif

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

Filtre

filters, filters, filter

Paquetage

package_destination, package_level, package_type

Réconcilier

reconcile_model, reconcile_model_line, reconcile_model_partner_mapping

Record

record, record, record

Salaire

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

Équipe

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

Autre

participant, trace

Compte (sans relations)

account

Action (sans relations)

actions_act_url, actions_act_window_close, actions_act_window_view, actions_actions, actions_client, actions_todo

Adresse (sans relations)

address_mixin

Aged (sans relations)

aged_partner_balance_report_handler, aged_payable_report_handler, aged_receivable_report_handler

Alarm (sans relations)

alarm

Analytic (sans relations)

analytic_applicability

Réponse (sans relations)

answer

Api (sans relations)

api

Validation (sans relations)

approval_request

Saisie automatique (sans relations)

autocomplete_api

Autovacuum (sans relations)

autovacuum

Backorder (sans relations)

backorder_confirmation

Code-barre (sans relations)

barcode_events_mixin

Base (sans relations)

base

Lot (sans relations)

batch_error_wizard, batch_error_wizard_line, batch_payment_rejection

Binaire (sans relations)

binary

Liste noire (sans relations)

blacklist, blacklist

Bot (sans relations)

bot

Bus (sans relations)

bus

Espèces (sans relations)

cash_flow_report_handler

Catégorie (sans relations)

category, category, category, category

Modifier (sans relations)

change_lock_date, change_product_qty

Canal (sans relations)

channel

Fermer (sans relations)

close_session_wizard

Collaborative (sans relations)

collaborative_mixin

Compose (sans relations)

compose_message

Configurator (sans relations)

configurator_feature

Confirmer (sans relations)

confirm

Consumption (sans relations)

consumption_warning, consumption_warning_line

Contrat (sans relations)

contract

Converter (sans relations)

converter_test, converter_test_sub

Tableau de bord (sans relations)

dashboard

Démo (sans relations)

demo

Departure (sans relations)

departure_reason

Détail (sans relations)

details_wizard

En double (sans relations)

duplicate_template_pdf

Ec (sans relations)

ec_sales_report_handler

Edi (sans 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

Activer (sans relations)

enable_profiling_wizard

Enrich (sans relations)

enrich_api

&Exporter (sans relations)

export_wizard_format, exports

Champ (sans relations)

fields_converter

Fiscal (sans relations)

fiscal_position_account_template, fiscal_position_tax_template

Followup (sans relations)

followup_report

Full (sans relations)

full_reconcile

Passerelle (sans relations)

gateway_allowed

Général (sans relations)

general_ledger_report_handler

Générique (sans relations)

generic_tax_report_handler, generic_tax_report_handler_account_tax, generic_tax_report_handler_tax_account

Geo (sans relations)

geo_provider

Geocoder (sans relations)

geocoder

Get (sans relations)

get_refuse_reason

Gmail (sans relations)

gmail_mixin

Grid (sans relations)

grid_mixin

Groupe (sans relations)

group

vacances (sans relations)

holidays_summary_employee

Hr (sans relations)

hr_holidays_report_holidayssummary, hr_payroll_contribution_register

Http (sans relations)

http

Iap (sans relations)

iap_lead_helpers, iap_lead_industry, iap_lead_role, iap_lead_seniority

Ice (sans relations)

ice_server

Image (sans relations)

image

Immediate (sans relations)

immediate_transfer

Importer (sans relations)

import

industrie (sans relations)

industry_fsm_worksheet_custom

L'inventaire (sans relations)

inventory_adjustment_name, inventory_conflict, inventory_warning

Invite (sans relations)

invite

Facture (sans relations)

invoice_extract_words

Iot (sans relations)

iot_box

Ir (sans relations)

ir_actions_account_report_download, ir_asset, ir_attachment, ir_ui_view

Karma (sans relations)

karma_rank

Keyboard (sans relations)

keyboard_layout

Étiquette (sans relations)

label_layout, label_layout, label_type

Langue (sans relations)

language_export, language_import, language_install

Mise en page (sans relations)

layout

Lien (sans relations)

link_journal, link_listing, link_preview, link_to_record_wizard

Journalisation (sans relations)

logging

Recherche (sans relations)

lookup_wizard, lookup_wizard_line

Lost (sans relations)

lost_reason

Make (sans relations)

make_payment

Mapping (sans relations)

mapping

Mass (sans relations)

mass_cancel_orders

Message (sans relations)

message

Min (sans relations)

min_cron_mixin

Mixin (sans relations)

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

Modèle (sans relations)

model, model, model

Module (sans relations)

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

Mrp (sans relations)

mrp_account_enterprise_mrp_cost_structure, mrp_account_enterprise_product_template_cost_structure, mrp_report_bom_structure

Multicurrency (sans relations)

multicurrency_revaluation_report_handler

Orderpoint (sans relations)

orderpoint_snooze

Pack (sans relations)

pack_operation_lot

Parent (sans relations)

parent_mixin

Mot de passe (sans relations)

password_own, password_wizard

Paie (sans relations)

payroll_edit_payslip_worked_days_line, payroll_index

Policy (sans relations)

policy

Précision (sans relations)

precision

Profil (sans relations)

profile

Publiés (sans relations)

published_mixin

Quality (sans relations)

quality_control_quality_worksheet, quality_control_quality_worksheet_internal

Quantité (sans relations)

quantity_history

Requête (sans relations)

question

File d'attente (sans relations)

queue_mixin

Qweb (sans relations)

qweb

Réconcilier (sans relations)

reconcile_model_line_template, reconcile_model_template

Reconciliation (sans relations)

reconciliation_widget

Recover (sans relations)

recover_order_wizard

Recruitment (sans relations)

recruitment_degree, recruitment_stage

Récurrent (sans relations)

recurring_plan

Referral (sans relations)

referral_alert_mail_wizard, referral_friend, referral_level

Removal (sans relations)

removal

Render (sans relations)

render_mixin

Resequence (sans relations)

resequence_wizard

Remettre (sans relations)

reset_mixin

Continuer (sans relations)

resume_line_type

Révision (sans relations)

revision

Robot (sans relations)

robots

Route (sans relations)

route

Règle (sans relations)

rule, rule, rule, rules_report

Salaire (sans relations)

salary_rule_category

Échantillon (sans relations)

sample_receipt

Scheduler (sans relations)

scheduler_compute

Recherchable (sans relations)

searchable_mixin

Seo (sans relations)

seo_metadata

Serveur (sans relations)

server

Service (sans relations)

service

Partager (sans relations)

share

Shipping (sans relations)

shipping_product

Shortcode (sans relations)

shortcode

Signer (sans relations)

sign_green_savings_report

Site (sans relations)

site

Slot (sans relations)

slot

Spreadsheet (sans relations)

spreadsheet_template

L'Étape (sans relations)

stage, stage, stage, stage, stage

Stock (sans 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

Abonnement (sans relations)

subscription_close_reason_wizard

Balise (sans relations)

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

Modèle (sans relations)

template, template, template, template

Temporel (sans relations)

temporal_recurrence

Fil de discussion (sans relations)

thread

Traceability (sans relations)

traceability_report

Transfer (sans relations)

transfer_model_line

Trial (sans relations)

trial_balance_report_handler, trial_balance_report_handler

Twitter (sans relations)

twitter_account

Unreconcile (sans relations)

unreconcile

Util (sans relations)

utils

Vue (sans relations)

view_arch_wizard

Warn (sans relations)

warn_insufficient_qty, warn_insufficient_qty_repair

Websocket (sans relations)

websocket

Work (sans relations)

work_entry_regeneration_wizard, work_entry_type

X (sans relations)

x_project_task_worksheet_template_1, x_project_task_worksheet_template_2

Zip (sans relations)

zip_prefix

_unknown (sans relations)

_unknown

Relations

Tableaux

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

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
  • étape: 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

Attributs

Les caractéristiques de cette plateforme sont présentées sur la page Attributes.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :