XPIPROPOSTACOMISSAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
LANCADO_POR_USUARIO_ID int 4 √ null
PROPOSTA_ID int 4 √ null
XPIPROPOSTA.ID FKPROPOSTACOMISSAOPROPOSTA_ID_PROPOSTAR
USUARIO_ID int 4 √ null
DATAHORACADASTRO datetime 16,3 √ null
NOME varchar 255 √ null
PORCENTAGEM RMDVALOR4 17,4 √ null
VALOR RMDVALOR4 17,4 √ null
TIPO_COMISSAO smallint 2 √ ((1))
SITUACAOCOMISSAO_ID smallint 2 √ null
ID_GERENTE int 4 √ null
XPIUSUARIO.ID FKPROPOSTACOMISSAOID_GERENTE_USUARIOC
ID_DIRETOR int 4 √ null
COMISSAO_PAGA_PELO_CLIENTE int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXPIPROPOSTACOMISSAO Primary key Asc ID

Relationships

Close relationships within degrees of separation