invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Odoo-datamodel

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Met één Query kunnen meerdere bedrijven tegelijk worden opgehaald.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • Invantive Cloud-abonnementen: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Cijfers

Figure Count
Tables 876
Columns 26,381

Poster met datamodel

In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.

PDF, 5 A0-vellen

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Odoo datamodel, Pagina 1 van 5Odoo datamodelvoor gebruik met Invantive UniversalSQLRelease 22.1.135-BETA+3826 · 01-03-2023Account · company · Volgorde · Account · transaction · Account · carrier · Account · warehouse · Rapport · Work · resourcePagina 1 van 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_incotermsincotermsVolgordeOdoo.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)pricelistVolgordeOdoo.res.companyCOdoo.res.currencyROdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectAanmakenOdoo.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)taskVolgordeOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.report.paperformat: itgen_odoo_paperformatpaperformatActieOdoo.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_groupsgroupsGroeperenOdoo.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 · menuVolgorde×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_automationautomationGroeperenOdoo.delivery.carrier: itgen_odoo_carrier (Odoo.delivery.carrier_easypost)carrierAccount · carrierOdoo.res.companyCOdoo.gamification.challenge: itgen_odoo_challenge (Odoo.gamification.challenge_line)challengeGebruikerOdoo.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_suppliersupplierGroeperenOdoo.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_milestonemilestoneAanmakenOdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectAanmakenOdoo.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_groupsgroupsGroeperenOdoo.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)pricelistVolgordeOdoo.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_groupsgroupsGroeperenOdoo.stock.lot: itgen_odoo_lotlotVolgordeOdoo.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_suppliersupplierGroeperenOdoo.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)projectAanmakenOdoo.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_groupsgroupsGroeperenOdoo.stock.lot: itgen_odoo_lotlotVolgordeOdoo.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)pricelistVolgordeOdoo.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.usersUOdooNotitiesIn dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties wordenafgeleid uit de namen van de kolommen.DatadictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenAanmaken2Account · bank2Account · bom2Account · carrier1Account · chart2Account · company1Account · country3Account · folder2Account · guest3Account · lead3Account · mailing3Account · media3Account · menu2Account · picking2Account · registration3Account · sequence3Account · slide3Account · source2Account · transaction1Account · uom3Account · warehouse1Actie3Activum3Analytic3Filter3Fiscal3Gebruiker2Groeperen2Lonen3Overige3Package3Rapport1Record3Recruitment2Referral2Salaris3Sale3Team3Ui3Verzoek3Verzoenen3Volgorde1Voorraad3Wizard3Work · employee3Work · leave2Work · recurrency3Work · resource1Tabeller uden relationen3, 4, 5LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten×n: n relations between the same tablesBrieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: C = company, P =partner, U = users, R = currencyGegenereerd op basis van de metagegevens van Invantive UniversalSQL 22.1.135-BETA+3826 op 01-03-2023. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/odoo
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

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

Gebruiker

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

Volgorde

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

Groeperen

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

Aanmaken

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

Lonen

payroll_edit_payslip_line, payroll_edit_payslip_lines_wizard, payroll_report, payroll_structure, payroll_structure_type

Verzoek

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

Actie

actions_act_window, actions_report, actions_server, paperformat

Activum

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

Verzoenen

reconcile_model, reconcile_model_line, reconcile_model_partner_mapping

Record

record, record, record

Salaris

salary_attachment, salary_attachment_report, salary_rule

Sale

sale_report, sale_line_employee_map, sale_extra_field

Voorraad

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

Overige

participant, trace

Account (zonder relaties)

account

Actie (zonder relaties)

actions_act_url, actions_act_window_close, actions_act_window_view, actions_actions, actions_client, actions_todo

Adres (zonder relaties)

address_mixin

Aged (zonder relaties)

aged_partner_balance_report_handler, aged_payable_report_handler, aged_receivable_report_handler

Alarm (zonder relaties)

alarm

Analytic (zonder relaties)

analytic_applicability

Antwoord (zonder relaties)

answer

Api (zonder relaties)

api

Goedkeuring (zonder relaties)

approval_request

Automatisch Aanvullen (zonder relaties)

autocomplete_api

Autovacuum (zonder relaties)

autovacuum

Backorder (zonder relaties)

backorder_confirmation

Barcode (zonder relaties)

barcode_events_mixin

Basis (zonder relaties)

base

Batch (zonder relaties)

batch_error_wizard, batch_error_wizard_line, batch_payment_rejection

Binair (zonder relaties)

binary

Zwarte Lijst (zonder relaties)

blacklist, blacklist

Bot (zonder relaties)

bot

Bus (zonder relaties)

bus

Kas (zonder relaties)

cash_flow_report_handler

Categorie (zonder relaties)

category, category, category, category

Wijzigen (zonder relaties)

change_lock_date, change_product_qty

Kanaal (zonder relaties)

channel

Sluiten (zonder relaties)

close_session_wizard

Collaborative (zonder relaties)

collaborative_mixin

Compose (zonder relaties)

compose_message

Configurator (zonder relaties)

configurator_feature

Bevestig (zonder relaties)

confirm

Consumption (zonder relaties)

consumption_warning, consumption_warning_line

Contract (zonder relaties)

contract

Converter (zonder relaties)

converter_test, converter_test_sub

Dashboard (zonder relaties)

dashboard

Demo (zonder relaties)

demo

Departure (zonder relaties)

departure_reason

Detail (zonder relaties)

details_wizard

Dupliceer (zonder relaties)

duplicate_template_pdf

Ec (zonder relaties)

ec_sales_report_handler

Edi (zonder relaties)

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

Inschakelen (zonder relaties)

enable_profiling_wizard

Enrich (zonder relaties)

enrich_api

Exporteren (zonder relaties)

export_wizard_format, exports

Veld (zonder relaties)

fields_converter

Fiscal (zonder relaties)

fiscal_position_account_template, fiscal_position_tax_template

Followup (zonder relaties)

followup_report

Full (zonder relaties)

full_reconcile

Koppeling (zonder relaties)

gateway_allowed

Algemeen (zonder relaties)

general_ledger_report_handler

Algemeen (zonder relaties)

generic_tax_report_handler, generic_tax_report_handler_account_tax, generic_tax_report_handler_tax_account

Geo (zonder relaties)

geo_provider

Geocoder (zonder relaties)

geocoder

Get (zonder relaties)

get_refuse_reason

Gmail (zonder relaties)

gmail_mixin

Grid (zonder relaties)

grid_mixin

Groeperen (zonder relaties)

group

Feestdag (zonder relaties)

holidays_summary_employee

Hr (zonder relaties)

hr_holidays_report_holidayssummary, hr_payroll_contribution_register

Http (zonder relaties)

http

Iap (zonder relaties)

iap_lead_helpers, iap_lead_industry, iap_lead_role, iap_lead_seniority

Ice (zonder relaties)

ice_server

Afbeelding (zonder relaties)

image

Immediate (zonder relaties)

immediate_transfer

Importeer (zonder relaties)

import

Branche (zonder relaties)

industry_fsm_worksheet_custom

Inventaris (zonder relaties)

inventory_adjustment_name, inventory_conflict, inventory_warning

Invite (zonder relaties)

invite

Factuur (zonder relaties)

invoice_extract_words

Iot (zonder relaties)

iot_box

Ir (zonder relaties)

ir_actions_account_report_download, ir_asset, ir_attachment, ir_ui_view

Karma (zonder relaties)

karma_rank

Keyboard (zonder relaties)

keyboard_layout

Label (zonder relaties)

label_layout, label_layout, label_type

Taal (zonder relaties)

language_export, language_import, language_install

Lay-out (zonder relaties)

layout

Koppelen (zonder relaties)

link_journal, link_listing, link_preview, link_to_record_wizard

Logging (zonder relaties)

logging

Opzoeken (zonder relaties)

lookup_wizard, lookup_wizard_line

Lost (zonder relaties)

lost_reason

Make (zonder relaties)

make_payment

Mapping (zonder relaties)

mapping

Mass (zonder relaties)

mass_cancel_orders

Boodschap (zonder relaties)

message

Min (zonder relaties)

min_cron_mixin

Mixin (zonder relaties)

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

Model (zonder relaties)

model, model, model

Module (zonder relaties)

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

Mrp (zonder relaties)

mrp_account_enterprise_mrp_cost_structure, mrp_account_enterprise_product_template_cost_structure, mrp_report_bom_structure

Multicurrency (zonder relaties)

multicurrency_revaluation_report_handler

Orderpoint (zonder relaties)

orderpoint_snooze

Pack (zonder relaties)

pack_operation_lot

Moeder (zonder relaties)

parent_mixin

Wachtwoord (zonder relaties)

password_own, password_wizard

Lonen (zonder relaties)

payroll_edit_payslip_worked_days_line, payroll_index

Policy (zonder relaties)

policy

Precisie (zonder relaties)

precision

Profiel (zonder relaties)

profile

Gepubliceerd (zonder relaties)

published_mixin

Quality (zonder relaties)

quality_control_quality_worksheet, quality_control_quality_worksheet_internal

Aantal (zonder relaties)

quantity_history

Vraag (zonder relaties)

question

Wachtrij (zonder relaties)

queue_mixin

Qweb (zonder relaties)

qweb

Verzoenen (zonder relaties)

reconcile_model_line_template, reconcile_model_template

Reconciliation (zonder relaties)

reconciliation_widget

Recover (zonder relaties)

recover_order_wizard

Recruitment (zonder relaties)

recruitment_degree, recruitment_stage

Terugkerend (zonder relaties)

recurring_plan

Referral (zonder relaties)

referral_alert_mail_wizard, referral_friend, referral_level

Removal (zonder relaties)

removal

Render (zonder relaties)

render_mixin

Resequence (zonder relaties)

resequence_wizard

Herstel (zonder relaties)

reset_mixin

Hervatten (zonder relaties)

resume_line_type

Revisie (zonder relaties)

revision

Robot (zonder relaties)

robots

Route (zonder relaties)

route

Regel (zonder relaties)

rule, rule, rule, rules_report

Salaris (zonder relaties)

salary_rule_category

Voorbeeld (zonder relaties)

sample_receipt

Scheduler (zonder relaties)

scheduler_compute

Doorzoekbaar (zonder relaties)

searchable_mixin

Seo (zonder relaties)

seo_metadata

Server (zonder relaties)

server

Service (zonder relaties)

service

Delen (zonder relaties)

share

Shipping (zonder relaties)

shipping_product

Shortcode (zonder relaties)

shortcode

Teken (zonder relaties)

sign_green_savings_report

Site (zonder relaties)

site

Slot (zonder relaties)

slot

Spreadsheet (zonder relaties)

spreadsheet_template

Stadium (zonder relaties)

stage, stage, stage, stage, stage

Voorraad (zonder relaties)

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 (zonder relaties)

subscription_close_reason_wizard

Label (zonder relaties)

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

Sjabloon (zonder relaties)

template, template, template, template

Tijdelijk (zonder relaties)

temporal_recurrence

Thread (zonder relaties)

thread

Traceability (zonder relaties)

traceability_report

Transfer (zonder relaties)

transfer_model_line

Trial (zonder relaties)

trial_balance_report_handler, trial_balance_report_handler

Twitter (zonder relaties)

twitter_account

Unreconcile (zonder relaties)

unreconcile

Util (zonder relaties)

utils

Beeld (zonder relaties)

view_arch_wizard

Warn (zonder relaties)

warn_insufficient_qty, warn_insufficient_qty_repair

Websocket (zonder relaties)

websocket

Work (zonder relaties)

work_entry_regeneration_wizard, work_entry_type

X (zonder relaties)

x_project_task_worksheet_template_1, x_project_task_worksheet_template_2

Zip (zonder relaties)

zip_prefix

_unknown (zonder relaties)

_unknown

Relaties

Tabellen

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

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

Attributen

De kenmerken van dit platform staan op de pagina Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: