SchemaSpy Analysis of idempiere9.adempiereProduct Price Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:54 +0100
Database Type: PostgreSQL - 9.6.24

XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Rows Comments
c_bpartner 6 5 74 17 Identifies a Business Partner
c_bpartner_product 2 18 1 Product Business Partner
m_discountschema 5 19 3 Schema to calculate the trade discount percentage
m_discountschemabreak 3 16 1 Trade Discount Break
m_discountschemaline 4 43 11 Line of the pricelist trade discount schema
m_pricelist 5 1 20 3 Unique identifier of a Price List
m_pricelist_version 3 3 16 5 Identifies a unique instance of a Price List
m_product 7 1 72 55 Product Service Item
m_product_category 4 1 19 14 Category of a Product
m_product_po 2 32 29 Product Purchasing
m_productprice 2 14 86 Product Price
m_productpricevendorbreak 3 16 0 Product Price Break
m_promotion 4 13 0 Promotion setup
m_promotiondistribution 2 2 16 0 Distribute order line items into multiple bucket for reward calculation
m_promotiongroup 2 11 0 Grouping of product for promotion setup
m_promotiongroupline 2 11 0 Line items of a promotion group
m_promotionline 1 2 13 0 Promotion line items
m_promotionprecondition 3 21 0 Pre condition for promotion
m_promotionreward 3 20 0 Setup reward for the promotion
           
19 Tables     464 225  
0 Views     0