invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Odoo Data Model

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

Piattaforma

  • Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
  • Tipo: un'applicazione accessibile tramite la propria API.
  • I dati sono suddivisi, ad esempio per azienda o per amministrazione.
  • Una query può leggere i dati di più aziende contemporaneamente.
  • I dati possono essere sia letti che scritti.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Figure

Figure Count
Tables 876
Columns 26,381

Poster sul modello di dati

Questo modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivano dai nomi delle colonne.

PDF, 5 fogli in formato A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Odoo Modello di dati, Foglio 1 di 5Odoo Modello di datida utilizzare con Invantive UniversalSQLComunicato 22.1.135-BETA+3826 · 01-03-2023Account · company · Ordinamento · Account · transaction · Account · carrier · Account · warehouse · Rapporto · Work · resourceFoglio 1 di 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_incotermsincotermsOrdinamentoOdoo.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_filterfilterFiltraOdoo.product.pricelist: itgen_odoo_pricelist (Odoo.product.pricelist_item)pricelistOrdinamentoOdoo.res.companyCOdoo.res.currencyROdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCreareOdoo.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)taskOrdinamentoOdoo.res.companyCOdoo.res.partnerPOdoo.res.currencyROdoo.res.usersUOdoo.report.paperformat: itgen_odoo_paperformatpaperformatAzioneOdoo.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_groupsgroupsGruppoOdoo.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 · menuOrdinamento×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_automationautomationGruppoOdoo.delivery.carrier: itgen_odoo_carrier (Odoo.delivery.carrier_easypost)carrierAccount · carrierOdoo.res.companyCOdoo.gamification.challenge: itgen_odoo_challenge (Odoo.gamification.challenge_line)challengeUtenteOdoo.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_suppliersupplierGruppoOdoo.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_milestonemilestoneCreareOdoo.project.project: itgen_odoo_project (Odoo.project.project_stage, Odoo.report.project_task_user, Odoo.report.project_task_user_fsm)projectCreareOdoo.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_groupsgroupsGruppoOdoo.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)pricelistOrdinamentoOdoo.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)productionRapportoOdoo.res.companyCOdoo.res.usersUOdoo.mrp.unbuild: itgen_odoo_unbuildunbuildAccount · bomOdoo.res.companyCOdoo.mrp.workorder: itgen_odoo_workorderworkorderRecruitmentOdoo.res.companyCOdoo.res.groups: itgen_odoo_groupsgroupsGruppoOdoo.stock.lot: itgen_odoo_lotlotOrdinamentoOdoo.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_suppliersupplierGruppoOdoo.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)projectCreareOdoo.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_groupsgroupsGruppoOdoo.stock.lot: itgen_odoo_lotlotOrdinamentoOdoo.res.companyCOdoo.uom.uom: itgen_odoo_uomuomAccount · uomRapporto×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)pricelistOrdinamentoOdoo.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.usersUOdooNoteQuesto modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivanodai nomi delle colonne.Dizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiAccount · bank2Account · bom2Account · carrier1Account · chart2Account · company1Account · country3Account · folder2Account · guest3Account · lead3Account · mailing3Account · media3Account · menu2Account · picking2Account · registration3Account · sequence3Account · slide3Account · source2Account · transaction1Account · uom3Account · warehouse1Altro3Analytic3Attivo3Azione3Creare2Disponibilità3Filtra3Fiscal3Gruppo2Libro paga3Ordinamento1Pacchetto3Rapporto1Record3Recruitment2Referral2Richiesta3Riconcilia3Sale3Stipendio3Team3Ui3Utente2Wizard3Work · employee3Work · leave2Work · recurrency3Work · resource1Tabella senza relazioni3, 4, 5LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti×n: n relations between the same tablesLettere: si riferisce a una tabella utilizzata nella maggior parte degli argomenti: C = company, P =partner, U = users, R = currencyGenerato dai metadati di Invantive UniversalSQL 22.1.135-BETA+3826 il 01-03-2023. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/odoo
Il poster come testo: tabelle per argomento e le loro relazioni

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

Utente

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

Ordinamento

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

Gruppo

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

Creare

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

Rapporto

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

Libro paga

payroll_edit_payslip_line, payroll_edit_payslip_lines_wizard, payroll_report, payroll_structure, payroll_structure_type

Richiesta

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

Azione

actions_act_window, actions_report, actions_server, paperformat

Attivo

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

Filtra

filters, filters, filter

Pacchetto

package_destination, package_level, package_type

Riconcilia

reconcile_model, reconcile_model_line, reconcile_model_partner_mapping

Record

record, record, record

Stipendio

salary_attachment, salary_attachment_report, salary_rule

Sale

sale_report, sale_line_employee_map, sale_extra_field

Disponibilità

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

Altro

participant, trace

Conto (senza relazioni)

account

Azione (senza relazioni)

actions_act_url, actions_act_window_close, actions_act_window_view, actions_actions, actions_client, actions_todo

Indirizzo (senza relazioni)

address_mixin

Aged (senza relazioni)

aged_partner_balance_report_handler, aged_payable_report_handler, aged_receivable_report_handler

Alarm (senza relazioni)

alarm

Analytic (senza relazioni)

analytic_applicability

Risposta (senza relazioni)

answer

Api (senza relazioni)

api

Approvazione (senza relazioni)

approval_request

Auto Compimento (senza relazioni)

autocomplete_api

Autovacuum (senza relazioni)

autovacuum

Backorder (senza relazioni)

backorder_confirmation

Codice a barre (senza relazioni)

barcode_events_mixin

Base (senza relazioni)

base

Lotto (senza relazioni)

batch_error_wizard, batch_error_wizard_line, batch_payment_rejection

Binario (senza relazioni)

binary

Lista nera (senza relazioni)

blacklist, blacklist

Bot (senza relazioni)

bot

Bus (senza relazioni)

bus

Contanti (senza relazioni)

cash_flow_report_handler

Categoria (senza relazioni)

category, category, category, category

Cambiare (senza relazioni)

change_lock_date, change_product_qty

Canale (senza relazioni)

channel

Chiudere (senza relazioni)

close_session_wizard

Collaborative (senza relazioni)

collaborative_mixin

Compose (senza relazioni)

compose_message

Configurator (senza relazioni)

configurator_feature

Confermare (senza relazioni)

confirm

Consumption (senza relazioni)

consumption_warning, consumption_warning_line

Contratto (senza relazioni)

contract

Converter (senza relazioni)

converter_test, converter_test_sub

Pannello di controllo (senza relazioni)

dashboard

Demo (senza relazioni)

demo

Departure (senza relazioni)

departure_reason

Dettaglio (senza relazioni)

details_wizard

Duplicato (senza relazioni)

duplicate_template_pdf

Ec (senza relazioni)

ec_sales_report_handler

Edi (senza relazioni)

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

Abilitare (senza relazioni)

enable_profiling_wizard

Enrich (senza relazioni)

enrich_api

Esportazione (senza relazioni)

export_wizard_format, exports

Campo (senza relazioni)

fields_converter

Fiscal (senza relazioni)

fiscal_position_account_template, fiscal_position_tax_template

Followup (senza relazioni)

followup_report

Full (senza relazioni)

full_reconcile

Gateway (senza relazioni)

gateway_allowed

Generale (senza relazioni)

general_ledger_report_handler

Generico (senza relazioni)

generic_tax_report_handler, generic_tax_report_handler_account_tax, generic_tax_report_handler_tax_account

Geo (senza relazioni)

geo_provider

Geocoder (senza relazioni)

geocoder

Get (senza relazioni)

get_refuse_reason

Gmail (senza relazioni)

gmail_mixin

Grid (senza relazioni)

grid_mixin

Gruppo (senza relazioni)

group

Vacanze (senza relazioni)

holidays_summary_employee

Hr (senza relazioni)

hr_holidays_report_holidayssummary, hr_payroll_contribution_register

Http (senza relazioni)

http

Iap (senza relazioni)

iap_lead_helpers, iap_lead_industry, iap_lead_role, iap_lead_seniority

Ice (senza relazioni)

ice_server

Immagine (senza relazioni)

image

Immediate (senza relazioni)

immediate_transfer

Importa (senza relazioni)

import

Settore (senza relazioni)

industry_fsm_worksheet_custom

Inventario (senza relazioni)

inventory_adjustment_name, inventory_conflict, inventory_warning

Invite (senza relazioni)

invite

Fattura (senza relazioni)

invoice_extract_words

Iot (senza relazioni)

iot_box

Ir (senza relazioni)

ir_actions_account_report_download, ir_asset, ir_attachment, ir_ui_view

Karma (senza relazioni)

karma_rank

Keyboard (senza relazioni)

keyboard_layout

Etichetta (senza relazioni)

label_layout, label_layout, label_type

Lingua (senza relazioni)

language_export, language_import, language_install

Disposizione in senso orizzontale (senza relazioni)

layout

Collegamento (senza relazioni)

link_journal, link_listing, link_preview, link_to_record_wizard

Registrazione (senza relazioni)

logging

Lookup consentito (senza relazioni)

lookup_wizard, lookup_wizard_line

Lost (senza relazioni)

lost_reason

Make (senza relazioni)

make_payment

Mapping (senza relazioni)

mapping

Mass (senza relazioni)

mass_cancel_orders

Messaggio (senza relazioni)

message

Min (senza relazioni)

min_cron_mixin

Mixin (senza relazioni)

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

Modello (senza relazioni)

model, model, model

Modulo (senza relazioni)

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

Mrp (senza relazioni)

mrp_account_enterprise_mrp_cost_structure, mrp_account_enterprise_product_template_cost_structure, mrp_report_bom_structure

Multicurrency (senza relazioni)

multicurrency_revaluation_report_handler

Orderpoint (senza relazioni)

orderpoint_snooze

Pack (senza relazioni)

pack_operation_lot

Genitore (senza relazioni)

parent_mixin

Parola d'ordine (senza relazioni)

password_own, password_wizard

Libro paga (senza relazioni)

payroll_edit_payslip_worked_days_line, payroll_index

Policy (senza relazioni)

policy

Di precisione (senza relazioni)

precision

Profilo (senza relazioni)

profile

Pubblicato (senza relazioni)

published_mixin

Quality (senza relazioni)

quality_control_quality_worksheet, quality_control_quality_worksheet_internal

Quantità (senza relazioni)

quantity_history

Query (senza relazioni)

question

Coda (senza relazioni)

queue_mixin

Qweb (senza relazioni)

qweb

Riconcilia (senza relazioni)

reconcile_model_line_template, reconcile_model_template

Reconciliation (senza relazioni)

reconciliation_widget

Recover (senza relazioni)

recover_order_wizard

Recruitment (senza relazioni)

recruitment_degree, recruitment_stage

Ricorrente (senza relazioni)

recurring_plan

Referral (senza relazioni)

referral_alert_mail_wizard, referral_friend, referral_level

Removal (senza relazioni)

removal

Render (senza relazioni)

render_mixin

Resequence (senza relazioni)

resequence_wizard

Ripristina (senza relazioni)

reset_mixin

Riassumere (senza relazioni)

resume_line_type

Revisione (senza relazioni)

revision

Robot (senza relazioni)

robots

Route (senza relazioni)

route

Regola (senza relazioni)

rule, rule, rule, rules_report

Stipendio (senza relazioni)

salary_rule_category

Campione (senza relazioni)

sample_receipt

Scheduler (senza relazioni)

scheduler_compute

Ricercabile (senza relazioni)

searchable_mixin

Seo (senza relazioni)

seo_metadata

Server (senza relazioni)

server

Servizio (senza relazioni)

service

Condividere (senza relazioni)

share

Shipping (senza relazioni)

shipping_product

Shortcode (senza relazioni)

shortcode

Cartello (senza relazioni)

sign_green_savings_report

Sito (senza relazioni)

site

Slot (senza relazioni)

slot

Spreadsheet (senza relazioni)

spreadsheet_template

Tappa (senza relazioni)

stage, stage, stage, stage, stage

Disponibilità (senza relazioni)

stock_label_product_product_view, stock_report_product_product_replenishment, stock_report_product_template_replenishment, stock_report_reception, stock_report_stock_rule, stock_sms

Abbonamento (senza relazioni)

subscription_close_reason_wizard

Tag (senza relazioni)

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

Modello (senza relazioni)

template, template, template, template

Temporale (senza relazioni)

temporal_recurrence

Discussione (senza relazioni)

thread

Traceability (senza relazioni)

traceability_report

Transfer (senza relazioni)

transfer_model_line

Trial (senza relazioni)

trial_balance_report_handler, trial_balance_report_handler

Twitter (senza relazioni)

twitter_account

Unreconcile (senza relazioni)

unreconcile

Util (senza relazioni)

utils

Vista (senza relazioni)

view_arch_wizard

Warn (senza relazioni)

warn_insufficient_qty, warn_insufficient_qty_repair

Websocket (senza relazioni)

websocket

Work (senza relazioni)

work_entry_regeneration_wizard, work_entry_type

X (senza relazioni)

x_project_task_worksheet_template_1, x_project_task_worksheet_template_2

Zip (senza relazioni)

zip_prefix

_unknown (senza relazioni)

_unknown

Relazioni

Tabelle

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

Attributi

Le caratteristiche di questa piattaforma sono riportate nella pagina Attributes.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: