XCOMISSOESMODCALCULO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDMODCALCCOMISSAO int 4 null
XCOMISSOESMODCALCULOCOMPN.IDMODCALCCOMISSAO FKXCOMMODCALCOMPN_XCOMMODCALR
XCOMISSOESREGRA.IDMODCALCCOMISSAO FKXCOMISSOESREGRA_XCOMISSOESMR
DESCRICAO varchar 200 null
TIPOCOMISSAOEMPRESA smallint 2 null
NROPARCELAS smallint 2 √ null
PERCENTUALMAXVINCULADOREC RMDVALOR4 17,4 √ null
CODCOLFORMULAPERCMAXVINCREC DCODCOLIGADANULL 2 √ null
GFORMULA.CODCOLIGADA FKXCOMISMODCALC_GFORPERCR
APLCODFORMULAPERCMAXVINCREC varchar 1 √ null
GFORMULA.APLICACAO FKXCOMISMODCALC_GFORPERCR
CODFORMULAPERCMAXVINCREC varchar 8 √ null
GFORMULA.CODIGO FKXCOMISMODCALC_GFORPERCR
TIPOCOMISSAOCLIENTE smallint 2 null
CODCOLFORMULAVALID DCODCOLIGADANULL 2 √ null
GFORMULA.CODCOLIGADA FKXCOMISMODCALC_GFORVALR
APLICACAOFRMVALID varchar 1 √ null
GFORMULA.APLICACAO FKXCOMISMODCALC_GFORVALR
CODFORMULAVALID varchar 8 √ null
GFORMULA.CODIGO FKXCOMISMODCALC_GFORVALR
TIPOCONTRATO smallint 2 null
DEFINIRCOMPN smallint 2 ((0))
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)
PKXCOMISSOESMODCALCULO Primary key Asc IDMODCALCCOMISSAO

Relationships

Close relationships within degrees of separation