Table idempiere9.adempiere.t_bom_indented
Indented BOM Report

 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
t_bom_indented_id numeric 10 Indented BOM Report
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::numeric Instance of the process
c_acctschema_id numeric 10  √  NULL::numeric Rules for accounting
cost numeric 0  √  null Cost information
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
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
isactive bpchar 1  √  NULL::bpchar The record is active in the system
levelno numeric 10  √  NULL::numeric Level no
levels varchar 250  √  NULL::character varying Levels
m_costelement_id numeric 10  √  NULL::numeric Product Cost Element
m_product_id numeric 10  √  NULL::numeric Product, Service, Item
qtybom numeric 0  √  null Indicate the Quantity use in this BOM
seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
qty numeric 0  √  null Quantity
costfuture numeric 0  √  null Cost information
sel_product_id numeric 10  √  NULL::numeric Selected Product
t_bom_indented_uu varchar 36  √  NULL::character varying T_BOM_Indented_UU

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

Indexes:
Column(s) Type Sort Constraint Name
t_bom_indented_id Primary key Asc t_bom_indented_key
t_bom_indented_uu Must be unique Asc t_bom_indented_uu_idx