c_commissionline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_commissionline_id numeric 10 null
c_commissionamt.c_commissionline_id ccomline_ccomamt R
cof_rv_commission_composition_detail.c_commissionline_id Implied Constraint R
rv_commissionrundetail.c_commissionline_id Implied Constraint R
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
c_commission_id numeric 10 null
c_commission.c_commission_id ccommission_ccommissionline C
line numeric 10 null
description varchar 255 √ null
amtsubtract numeric 0 null
amtmultiplier numeric 0 null
qtysubtract numeric 0 null
qtymultiplier numeric 0 null
ispositiveonly bpchar 1 'Y'::bpchar
commissionorders bpchar 1 'N'::bpchar
org_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_ccommissionline R
m_product_category_id numeric 10 √ null
m_product_category.m_product_category_id mproductcat_ccommissionline R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_ccommissionline R
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id cbpgroup_commissionline R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_ccommissionline R
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregion_ccommissionline R
paymentrule varchar 1 √ null
c_commissionline_uu varchar 36 √ NULL::character varying
cof_grupofornecedor_id numeric 10 √ NULL::numeric
cof_grupofornecedor.cof_grupofornecedor_id cofgrupofornecedor_ccommission R
cof_producttype_id numeric 10 √ NULL::numeric
cof_producttype.cof_producttype_id cofproducttype_ccommissionline R
cof_productclass_id numeric 10 √ NULL::numeric
cof_productclass.cof_productclass_id cofproductclass_ccommissionlin R
cof_productgroup_id numeric 10 √ NULL::numeric
cof_productgroup.cof_productgroup_id cofproductgroup_ccommissionlin R
percentagesubtract numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
c_commissionline_pkey Primary key Asc c_commissionline_id
c_commissionline_commission Performance Asc c_commission_id
c_commissionline_uu_idx Must be unique Asc c_commissionline_uu

Check Constraints

Constraint Name Constraint
c_commissionline_ispositiveonly_check ((ispositiveonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_commissionorders_check ((commissionorders = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation