Table idempiere9.adempiere.t_bomline
Temporal 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
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
ad_pinstance_id numeric 10  √  null Instance of the process
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
isactive bpchar 1  √  null The record is active in the system
levelno numeric 10  √  null Level no
levels varchar 250  √  null Levels
m_product_id numeric 10  √  null Product, Service, Item
pp_product_bomline_id numeric 10  √  null BOM Line
pp_product_bom_id numeric 10  √  null BOM & Formula
seqno numeric 10  √  null Method of ordering records; lowest number comes first
t_bomline_id numeric 10 Temporal BOM Line
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
sel_product_id numeric 10 Selected Product
implosion bpchar 1  √  'N'::bpchar Implosion of a Bill of Materials refers to finding all the BOM''s in which a component is used.
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.
qtybom numeric 0  √  null Indicate the Quantity use in this BOM
cost varchar 22  √  null Cost information
c_acctschema_id numeric 10  √  null Rules for accounting
costingmethod bpchar 1  √  NULL::bpchar Indicates how Costs will be calculated
m_costtype_id numeric 10  √  NULL::numeric Type of Cost (e.g. Current, Plan, Future)
futurecostprice numeric 0  √  null Future Cost Price
futurecostpricell numeric 0  √  null Future Cost Price Lower Level
iscostfrozen bpchar 1  √  NULL::bpchar Indicated that the Standard Cost is frozen
coststandard numeric 0  √  null Standard Costs
t_bomline_uu varchar 36  √  NULL::character varying T_BOMLine_UU

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

Indexes:
Column(s) Type Sort Constraint Name
t_bomline_id Primary key Asc t_bomline_key
t_bomline_uu Must be unique Asc t_bomline_uu_idx