Table idempiere9.adempiere.pp_order_bomline
Manufacturing Order BOM Line

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
description varchar 255  √  null Optional short description of the record
feature varchar 30  √  null Indicated the Feature for Product Configure
m_product_id numeric 10
m_product.m_product_id mproduct_pporderbomline R
Product, Service, Item
backflushgroup varchar 30  √  null The Grouping Components to the Backflush
c_uom_id numeric 10
c_uom.c_uom_id cuom_pporderbomline R
Unit of Measure
componenttype bpchar 2  √  'CO'::bpchar Component Type for a Bill of Material or Formula
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
datedelivered timestamp 29,6  √  null Date when the product was delivered
forecast numeric 0  √  null Indicated the % of participation this component into a of the BOM Planning
help varchar 2000  √  null Comment or Hint
isactive bpchar 1 The record is active in the system
iscritical bpchar 1 Indicate that a Manufacturing Order can not begin without have this component
isqtypercentage bpchar 1  √  null Indicate that this component is based in % Quantity
issuemethod bpchar 1  √  null There are two methods for issue the components to Manufacturing Order
leadtimeoffset numeric 10  √  null Optional Lead Time offset before starting production
line numeric 10 Unique line for this document
m_attributesetinstance_id numeric 10  √  null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_ppordbl R
Product Attribute Set Instance
m_changenotice_id numeric 10  √  null
m_changenotice.m_changenotice_id mchangenotice_pporderbomline R
Bill of Materials (Engineering) Change Notice (Version)
m_locator_id numeric 10  √  null
m_locator.m_locator_id mlocator_pporderbomline R
Warehouse Locator
m_warehouse_id numeric 10
m_warehouse.m_warehouse_id mwarehouse_pporderbomline R
Storage Warehouse and Service Point
pp_order_bomline_id numeric 10
pp_cost_collector.pp_order_bomline_id pporderbomline_ppcostcollector R
pp_mrp.pp_order_bomline_id pporderbomline_ppmrp R
pp_order_bomline_trl.pp_order_bomline_id pporderbomline_pporderbomlinet R
Manufacturing Order BOM Line
pp_order_bom_id numeric 10
pp_order_bom.pp_order_bom_id pporderbom_pporderbomline R
Manufacturing Order BOM
pp_order_id numeric 10
pp_order.pp_order_id pporder_pporderbomline R
Manufacturing Order
qtybom numeric 0 Indicate the Quantity use in this BOM
qtybatch numeric 0 Indicate the Quantity % use in this Formula
qtydelivered numeric 0 Delivered Quantity
qtyentered numeric 0  √  (1)::numeric The Quantity Entered is based on the selected UoM
qtypost numeric 0 Qty Post
qtyreject numeric 0 Qty Reject
qtyrequiered numeric 0 Qty Requiered
qtyreserved numeric 0 Reserved Quantity
qtyscrap numeric 0 Scrap % Quantity for this componet
scrap numeric 0  √  null Indicate the Scrap % for calculate the Scrap Quantity
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
validfrom timestamp 29,6 Valid from including this date (first day)
ad_client_id numeric 10 Client/Tenant for this installation.
validto timestamp 29,6  √  null Valid to including this date (last day)
ad_org_id numeric 10 Organizational entity within client
assay numeric 0  √  null Indicated the Quantity Assay to use into Quality Order
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_pporderbomline R
User within the system - Internal or Business Partner Contact
costallocationperc numeric 0  √  (0)::numeric Cost allocation percent in case of a co-product.
pp_order_bomline_uu varchar 36  √  NULL::character varying PP_Order_BOMLine_UU

Table contained 4 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
pp_order_bomline_id Primary key Asc pp_order_bomline_key
pp_order_bomline_uu Must be unique Asc pp_order_bomline_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.