c_commissionline

-1 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_configuracaometa.c_commissionline_id ccommissionline_cofconfiguraca C
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
cof_isincluirmetalinha bpchar 1 'N'::bpchar
cof_isconsiderarprecomediolinha bpchar 1 'N'::bpchar
cof_tipodemetalinha bpchar 1 √ NULL::bpchar
cof_metalinha numeric 0 √ null
cof_doctypetarget varchar 2000 √ NULL::character varying
cof_linhacomissaoorg varchar 255 √ NULL::character varying
cof_linhacomissaocbpgroup varchar 255 √ NULL::character varying
cof_linhacomissaocbpartner varchar 255 √ NULL::character varying
cof_linhacomissaomproductcategory varchar 255 √ NULL::character varying
cof_linhacomissaomproduct varchar 255 √ NULL::character varying
cof_linhacomissaosalesregion varchar 255 √ NULL::character varying
cof_linhacomissaopaymentrule varchar 255 √ NULL::character varying
cof_isnegarorg bpchar 1 'N'::bpchar
cof_isnegargrupopn bpchar 1 'N'::bpchar
cof_isnegarpn bpchar 1 'N'::bpchar
cof_isnegargrupocontabilproduto bpchar 1 'N'::bpchar
cof_isnegarproduto bpchar 1 'N'::bpchar
cof_isnegartipoproduto bpchar 1 'N'::bpchar
cof_isnegarclasseproduto bpchar 1 'N'::bpchar
cof_isnegargrupoproduto bpchar 1 'N'::bpchar
cof_isnegargrupofornecedor bpchar 1 'N'::bpchar
cof_isnegarregiaovendas bpchar 1 'N'::bpchar
cof_isnegarregrapagamento bpchar 1 'N'::bpchar
cof_linhacomissaoproducttype varchar 255 √ NULL::character varying
cof_linhacomissaoproductclass varchar 255 √ NULL::character varying
cof_linhacomissaoproductgroup varchar 255 √ NULL::character varying
cof_linhacomissaogrupofornecedor varchar 255 √ NULL::character varying
cof_isnegarrepresentantevendas bpchar 1 'N'::bpchar
cof_linhacomissaorepresentantevendas varchar 2000 √ NULL::character varying

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_cof_isnegarclasseproduto_check ((cof_isnegarclasseproduto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isincluirmetalinha_check ((cof_isincluirmetalinha = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegarregiaovendas_check ((cof_isnegarregiaovendas = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegargrupopn_check ((cof_isnegargrupopn = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegarregrapagamento_check ((cof_isnegarregrapagamento = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_commissionorders_check ((commissionorders = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegargrupofornecedor_check ((cof_isnegargrupofornecedor = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegarpn_check ((cof_isnegarpn = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegarrepresentantevendas_check ((cof_isnegarrepresentantevendas = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegarproduto_check ((cof_isnegarproduto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_ispositiveonly_check ((ispositiveonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegarorg_check ((cof_isnegarorg = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegargrupocontabilproduto_check ((cof_isnegargrupocontabilproduto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegargrupoproduto_check ((cof_isnegargrupoproduto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isconsiderarprecomediolinha_check ((cof_isconsiderarprecomediolinha = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_commissionline_cof_isnegartipoproduto_check ((cof_isnegartipoproduto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation