invantive documentation
Invantive Support ForumsLog In / Sign Up

bom: Odoo itgen_odoo_bom

read only per partition

  • Catalog: Odoo
  • Schema: mrp
  • Label: itgen_odoo_bom

Bill of Material

Can only retrieve data.

Summary

Defines bills of material for a product or a product template

Table Columns

The columns of the table bom are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
active boolean Production Ready
allow_operation_dependencies boolean Operation Dependencies Create operation level dependencies that will influence both planning and the status of work orders upon MO confirmation. If this feature is ticked, and nothing is specified, Odoo will assume that all operations can be started simultaneously.
analytic_account_id varchar2 Analytic account in which cost and revenue entries will take place for financial management of the manufacturing order.
analytic_account_id_label varchar2 Analytic account in which cost and revenue entries will take place for financial management of the manufacturing order.
bom_line_ids varchar2
byproduct_ids varchar2
code varchar2 Reference
company_id varchar2
company_id_label varchar2
consumption varchar2 Flexible Consumption Defines if you can consume more or less components than the quantity defined on the BoM: * Allowed: allowed for all manufacturing users. * Allowed with warning: allowed for all manufacturing users with summary of consumption differences when closing the manufacturing order. Note that in the case of component Manual Consumption, where consumption is registered manually exclusively, consumption warnings will still be issued when appropriate also. * Blocked: only a manager can close a manufacturing order when the BoM consumption is not respected.
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Display Name
eco_count int32 # ECOs
eco_ids varchar2
eco_inprogress_count int32 # ECOs in progress
has_message boolean Has Message
id int32 ID
image_128 varbinary Image 128
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
operation_ids varchar2
picking_type_id varchar2 When a procurement has a ‘produce’ route with a operation type set, it will try to create a Manufacturing Order for that product using a BoM of the same operation type. That allows to define stock rules which trigger different manufacturing orders with different BoMs.
picking_type_id_label varchar2 When a procurement has a ‘produce’ route with a operation type set, it will try to create a Manufacturing Order for that product using a BoM of the same operation type. That allows to define stock rules which trigger different manufacturing orders with different BoMs.
possible_product_template_attribute_value_ids varchar2
previous_bom_id varchar2
previous_bom_id_label varchar2
product_id varchar2 If a product variant is defined the BOM is available only for this product.
product_id_label varchar2 If a product variant is defined the BOM is available only for this product.
product_qty numeric Quantity This should be the smallest quantity that this product can be produced in. If the BOM contains operations, make sure the work center capacity is accurate.
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_uom_category_id varchar2 Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios.
product_uom_category_id_label varchar2 Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios.
product_uom_id varchar2 Unit of Measure (Unit of Measure) is the unit of measurement for the inventory control
product_uom_id_label varchar2 Unit of Measure (Unit of Measure) is the unit of measurement for the inventory control
ready_to_produce varchar2 Manufacturing Readiness
sequence int32 Sequence
type varchar2 BoM Type
version int32 Version
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: