comissaorelatorio


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcomissaorelatorio int8 19 null
comissaorelatorio_aud.idcomissaorelatorio Implied Constraint R
descricao varchar 80 √ null
numerodocumento varchar 20 √ null
enderecolocal varchar 80 √ null
nomeparceiro varchar 80 √ null
dataemissaodocumento date 13 √ null
valordocumento numeric 18,6 √ null
valorbasecalculo numeric 18,6 √ null
percentualcomissao numeric 18,6 √ null
valorcomissao numeric 18,6 √ null
datacomissao date 13 √ null
idnpago int2 5 √ null
idtipocomissao int8 19 √ null
tipocomissao.idtipocomissao fk_qi4g6jwjh6639c739hwimh2hk R
idusuario int8 19 √ null
usuario.idusuario fk_aw2yiplcr8t9r0l3gbv5ih05w R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
dataprevisaopagamento date 13 √ null
idpedido int8 19 √ null
pedido.idpedido fk_4i0cynr9udjdib7j453xjr9yc R

Indexes

Constraint Name Type Sort Column(s)
pk384165bf Primary key Asc idcomissaorelatorio
idx5c41819c Performance Asc idtipocomissao
idx81b398f4 Performance Asc idusuario
idx9eccadc2 Performance Asc idpedido
idxwsversao_384165bf Performance Desc wsversao
ucac8413fd Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation