有没有可能用插件实现,让最终用户查询产品的原料来源?
小微企业
-
请问有report从成品回溯各个生产环节的半成品,直到最初原材料的吗? -
请问有report从成品回溯各个生产环节的半成品,直到最初原材料的吗?BoM之间的依赖关系,就是通过parent BoM确定的吗?有没有app把这个父子BoM的hierarchy生成树图啊(最终产品是根)?
-
请问有report从成品回溯各个生产环节的半成品,直到最初原材料的吗?或者说材料,半成品和成品之间的依赖关系在哪里定义?MRP里吗?
-
请问数据库里哪些table是inventory相关的?才发现需要安装Warehouse模块,新增的表有:
decimal_precision
decimal_precision_test
pricelist_partnerinfo
procurement_group
procurement_order
procurement_order_compute_all
procurement_orderpoint_compute
procurement_rule
product_attribute
product_attribute_line
product_attribute_line_product_attribute_value_rel
product_attribute_price
product_attribute_value
product_attribute_value_product_product_rel
product_category
product_packaging
product_price_history
product_price_list
product_price_type
product_pricelist
product_pricelist_item
product_pricelist_type
product_pricelist_version
product_product
product_putaway
product_removal
product_supplierinfo
product_template
product_ul
product_uom
product_uom_categ
report_stock_lines_date
stock_change_product_qty
stock_config_settings
stock_fixed_putaway_strat
stock_incoterms
stock_inventory
stock_inventory_line
stock_location
stock_location_path
stock_location_route
stock_location_route_categ
stock_location_route_move
stock_location_route_procurement
stock_move
stock_move_operation_link
stock_move_scrap
stock_pack_operation
stock_picking
stock_picking_type
stock_production_lot
stock_quant
stock_quant_move_rel
stock_quant_package
stock_return_picking
stock_return_picking_line
stock_route_product
stock_route_warehouse
stock_transfer_details
stock_transfer_details_items
stock_warehouse
stock_warehouse_orderpoint
stock_wh_resupply_table -
请问数据库里哪些table是inventory相关的?列表如下,比较明显的有crm_ 和wkf_,不知是ir_那些吗?
base_action_rule
base_action_rule_ir_act_server_rel
base_action_rule_lead_test
base_action_rule_res_partner_rel
base_config_settings
base_import_import
base_import_tests_models_char
base_import_tests_models_char_noreadonly
base_import_tests_models_char_readonly
base_import_tests_models_char_required
base_import_tests_models_char_states
base_import_tests_models_char_stillreadonly
base_import_tests_models_m2o
base_import_tests_models_m2o_related
base_import_tests_models_m2o_required
base_import_tests_models_m2o_required_related
base_import_tests_models_o2m
base_import_tests_models_o2m_child
base_import_tests_models_preview
base_language_export
base_language_import
base_language_install
base_module_configuration
base_module_update
base_module_upgrade
base_partner_merge_automatic_wizard
base_partner_merge_automatic_wizard_res_partner_rel
base_partner_merge_line
base_setup_terminology
base_update_translations
board_create
bus_bus
calendar_alarm
calendar_alarm_calendar_event_rel
calendar_attendee
calendar_contacts
calendar_event
calendar_event_res_partner_rel
calendar_event_type
change_password_user
change_password_wizard
crm_case_categ
crm_case_section
crm_case_stage
crm_lead
crm_lead2opportunity_partner
crm_lead2opportunity_partner_mass
crm_lead2opportunity_partner_mass_res_users_rel
crm_lead_category_rel
crm_lead_crm_lead2opportunity_partner_mass_rel
crm_lead_crm_lead2opportunity_partner_rel
crm_lead_report
crm_merge_opportunity
crm_opportunity_report
crm_partner_binding
crm_payment_mode
crm_phonecall
crm_phonecall2phonecall
crm_segmentation
crm_segmentation_line
crm_tracking_campaign
crm_tracking_medium
crm_tracking_source
email_template
email_template_attachment_rel
email_template_preview
email_template_preview_res_partner_rel
fetchmail_config_settings
fetchmail_server
im_chat_message
im_chat_presence
im_chat_session
im_chat_session_res_users_rel
ir_actions
ir_act_client
ir_act_report_xml
ir_act_server
ir_act_url
ir_act_window
ir_act_window_group_rel
ir_act_window_view
ir_actions_todo
ir_attachment
ir_config_parameter
ir_config_parameter_groups_rel
ir_cron
ir_default
ir_exports
ir_exports_line
ir_fields_converter
ir_filters
ir_logging
ir_mail_server
ir_model
ir_model_access
ir_model_constraint
ir_model_data
ir_model_fields
ir_model_fields_group_rel
ir_model_relation
ir_module_category
ir_module_module
ir_module_module_dependency
ir_property
ir_rule
ir_sequence
ir_sequence_type
ir_server_object_lines
ir_translation
ir_ui_menu
ir_ui_menu_group_rel
ir_ui_view
ir_ui_view_custom
ir_ui_view_group_rel
ir_values
mail_alias
mail_compose_message
mail_compose_message_ir_attachments_rel
mail_compose_message_res_partner_rel
mail_followers
mail_followers_mail_message_subtype_rel
mail_group
mail_group_res_group_rel
mail_mail
mail_mail_res_partner_rel
mail_message
mail_message_res_partner_rel
mail_message_subtype
mail_notification
mail_vote
mail_wizard_invite
mail_wizard_invite_res_partner_rel
meeting_category_rel
merge_opportunity_rel
message_attachment_rel
multi_company_default
osv_memory_autovacuum
portal_wizard
portal_wizard_user
rel_modules_langexport
rel_server_actions
report
report_paperformat
res_bank
res_company
res_company_users_rel
res_config
res_config_installer
res_config_settings
res_country
res_country_group
res_country_res_country_group_rel
res_country_state
res_currency
res_currency_rate
res_font
res_groups
res_groups_action_rel
res_groups_implied_rel
res_groups_report_rel
res_groups_users_rel
res_lang
res_partner
res_partner_bank
res_partner_bank_type
res_partner_bank_type_field
res_partner_category
res_partner_res_partner_category_rel
res_partner_title
res_request_link
res_users
resource_calendar
resource_calendar_attendance
resource_calendar_leaves
resource_resource
rule_group_rel
sale_config_settings
sale_member_rel
section_stage_rel
share_wizard
share_wizard_res_group_rel
share_wizard_res_user_rel
share_wizard_result_line
wizard_ir_model_menu_create
wkf
wkf_activity
wkf_instance
wkf_transition
wkf_triggers
wkf_witm_trans
wkf_workitem -
请问怎样生成数据库的EER diagram比较方便?或者哪里有现成的?装了之后导出了schema,将近200个table,有的一看了
-
请问怎样生成数据库的EER diagram比较方便?或者哪里有现成的?刚开始学习,想看看model的大略设计
SO上提到用ERPpeek或者postgresql_autodoc,但我还没装odoo,而且估计网上也不会有demo是提供数据库管理员密码的
多谢