Table idempiere9.adempiere.m_discountschemaline
Line of the pricelist trade discount schema

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
m_discountschemaline_id numeric 10 Line of the pricelist trade discount schema
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
m_discountschema_id numeric 10
m_discountschema.m_discountschema_id mdiscountschema_mdsline C
Schema to calculate the trade discount percentage
seqno numeric 10 Method of ordering records; lowest number comes first
m_product_category_id numeric 10  √  null
m_product_category.m_product_category_id mprodcategory_mdiscountsline R
Category of a Product
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_mdiscountsline R
Identifies a Business Partner
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_mdiscountsline N
Product, Service, Item
conversiondate timestamp 29,6 Date for selecting conversion rate
list_base bpchar 1 Price used as the basis for price list calculations
list_addamt numeric 0 0 List Price Surcharge Amount
list_discount numeric 0 Discount from list price as a percentage
list_rounding bpchar 1 Rounding rule for final list price
list_minamt numeric 0 0 Minimum margin for a product
list_maxamt numeric 0 0 Maximum margin for a product
list_fixed numeric 0  √  0 Fixes List Price (not calculated)
std_base bpchar 1 Base price for calculating new standard price
std_addamt numeric 0 0 Amount added to a price as a surcharge
std_discount numeric 0 Discount percentage to subtract from base price
std_rounding bpchar 1 Rounding rule for calculated price
std_minamt numeric 0 0 Minimum margin allowed for a product
std_maxamt numeric 0 0 Maximum margin allowed for a product
std_fixed numeric 0  √  0 Fixed Standard Price (not calculated)
limit_base bpchar 1 Base price for calculation of the new price
limit_addamt numeric 0 0 Amount added to the converted/copied price before multiplying
limit_discount numeric 0 Discount in percent to be subtracted from base, if negative it will be added to base price
limit_rounding bpchar 1 Rounding of the final result
limit_minamt numeric 0 0 Minimum difference to original limit price; ignored if zero
limit_maxamt numeric 0 0 Maximum difference to original limit price; ignored if zero
limit_fixed numeric 0  √  0 Fixed Limit Price (not calculated)
c_conversiontype_id numeric 10
c_conversiontype.c_conversiontype_id cconversiontype_mdiscschline R
Currency Conversion Rate Type
classification varchar 12  √  null Classification for grouping
group2 varchar 255  √  null Group2
group1 varchar 255  √  null Group1
m_discountschemaline_uu varchar 36  √  NULL::character varying M_DiscountSchemaLine_UU
description varchar 255  √  NULL::character varying Optional short description of the record
isignoreiscurrentvendor bpchar 1 'N'::bpchar take all PO prices into account
vendorcategory varchar 30  √  NULL::character varying Product Category of the Business Partner

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

Indexes:
Column(s) Type Sort Constraint Name
m_discountschemaline_id Primary key Asc m_discountschemaline_pkey
m_discountschemaline_uu Must be unique Asc m_discountschemaline_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.