m_discountschemabreak

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_discountschemabreak_id numeric 10 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
m_discountschema_id numeric 10 null
m_discountschema.m_discountschema_id mdiscounts_mdsbreak C
seqno numeric 10 null
breakvalue numeric 0 null
breakdiscount numeric 0 null
m_product_category_id numeric 10 √ null
m_product_category.m_product_category_id mprodcategory_mdiscountsbreak R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_mdiscountsbreak R
isbpartnerflatdiscount bpchar 1 'N'::bpchar
m_discountschemabreak_uu varchar 36 √ NULL::character varying
cof_producttype_id numeric 10 √ null
cof_producttype.cof_producttype_id cofproducttype_mdiscountschemabreak R
cof_productgroup_id numeric 10 √ null
cof_productgroup.cof_productgroup_id cofproductgroup_mdiscountschemabreak R
cof_productclass_id numeric 10 √ null
cof_productclass.cof_productclass_id cofproductclass_mdiscountschemabreak R
cof_grupofornecedor_id numeric 10 √ null
cof_grupofornecedor.cof_grupofornecedor_id cofgrupofornecedor_mdiscountschemabreak R
fixedprice numeric 0 √ 0

Indexes

Constraint Name Type Sort Column(s)
m_discountschemabreak_pkey Primary key Asc m_discountschemabreak_id
m_discountschemabreak_uu_idx Must be unique Asc m_discountschemabreak_uu

Check Constraints

Constraint Name Constraint
m_discountschemabreak_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation