m_discountschemaline

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_discountschemaline_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 mdiscountschema_mdsline C
seqno numeric 10 null
m_product_category_id numeric 10 √ null
m_product_category.m_product_category_id mprodcategory_mdiscountsline R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_mdiscountsline R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_mdiscountsline N
conversiondate timestamp 29,6 null
list_base bpchar 1 null
list_addamt numeric 0 0
list_discount numeric 0 null
list_rounding bpchar 1 null
list_minamt numeric 0 0
list_maxamt numeric 0 0
list_fixed numeric 0 √ 0
std_base bpchar 1 null
std_addamt numeric 0 0
std_discount numeric 0 null
std_rounding bpchar 1 null
std_minamt numeric 0 0
std_maxamt numeric 0 0
std_fixed numeric 0 √ 0
limit_base bpchar 1 null
limit_addamt numeric 0 0
limit_discount numeric 0 null
limit_rounding bpchar 1 null
limit_minamt numeric 0 0
limit_maxamt numeric 0 0
limit_fixed numeric 0 √ 0
c_conversiontype_id numeric 10 null
c_conversiontype.c_conversiontype_id cconversiontype_mdiscschline R
classification varchar 12 √ null
group2 varchar 255 √ null
group1 varchar 255 √ null
m_discountschemaline_uu varchar 36 √ NULL::character varying
cof_producttype_id numeric 10 √ NULL::numeric
cof_producttype.cof_producttype_id cofproducttype_mdiscountschema R
cof_productclass_id numeric 10 √ null
cof_productclass.cof_productclass_id cofproductclass_mdiscountschem R
cof_productgroup_id numeric 10 √ NULL::numeric
cof_productgroup.cof_productgroup_id cofproductgroup_mdiscountschem R
cof_grupofornecedor_id numeric 10 √ NULL::numeric
cof_grupofornecedor.cof_grupofornecedor_id cofgrupofornecedor_mdiscountsc R
description varchar 255 √ NULL::character varying
isignoreiscurrentvendor bpchar 1 'N'::bpchar
vendorcategory varchar 30 √ NULL::character varying

Indexes

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

Check Constraints

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

Relationships

Close relationships within degrees of separation