View idempiere9.adempiere.rv_pp_product_bomline
View Product 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
seqno numeric 10  √  null Method of ordering records; lowest number comes first
levelno numeric 10  √  null Level no
levels varchar 250  √  null Levels
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
createdby numeric 10  √  null User who created this records
updatedby numeric 10  √  null User who updated this records
updated timestamp 29,6  √  null Date this record was updated
created timestamp 29,6  √  null Date this record was created
ad_pinstance_id numeric 10  √  null Instance of the process
implosion bpchar 1  √  null Implosion of a Bill of Materials refers to finding all the BOM''s in which a component is used.
m_product_id numeric 10  √  null Product, Service, Item
isactive bpchar 1  √  null The record is active in the system
pp_product_bom_id numeric 10  √  null BOM & Formula
pp_product_bomline_id numeric 10  √  null BOM Line
description varchar 255  √  null Optional short description of the record
iscritical bpchar 1  √  null Indicate that a Manufacturing Order can not begin without have this component
componenttype bpchar 2  √  null Component Type for a Bill of Material or Formula
tm_product_id numeric 10  √  null Product
c_uom_id numeric 10  √  null Unit of Measure
issuemethod bpchar 1  √  null There are two methods for issue the components to Manufacturing Order
line numeric 10  √  null Unique line for this document
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
scrap numeric 0  √  null Indicate the Scrap % for calculate the Scrap Quantity
validfrom timestamp 29,6  √  null Valid from including this date (first day)
validto timestamp 29,6  √  null Valid to including this date (last day)
qtybom numeric 0  √  null Indicate the Quantity use in this BOM
qtybatch numeric 0  √  null Indicate the Quantity % use in this Formula
isqtypercentage bpchar 1  √  null Indicate that this component is based in % Quantity

Analyzed at 2021-12-25 14:43 +0100