View idempiere11.adempiere.t_bomline_costs
Cost 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 Tenant for this installation.
c_acctschema_id numeric 10  √  null Rules for accounting
ad_org_id numeric 10  √  null Organizational entity within tenant
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
m_costelement_id numeric 10  √  null Product Cost Element
currentcostprice numeric 0  √  null The currently used cost price
currentcostpricell numeric 0  √  null Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
futurecostprice numeric 0  √  null Future Cost Price
futurecostpricell numeric 0  √  null Future Cost Price Lower Level
iscostfrozen bpchar 1  √  null Indicated that the Standard Cost is frozen
qtybom numeric 0  √  null Indicate the Quantity use in this BOM
cost numeric 0  √  null Cost information
coststandard numeric 0  √  null Standard Costs
m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
costingmethod bpchar 1  √  null Indicates how Costs will be calculated
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)
isqtypercentage bpchar 1  √  null Indicate that this component is based in % Quantity

Analyzed at 2024-01-03 13:44 +0100