XALGCONTRATOLOCCORRETORCOMISSA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLCONTLOC DCODCOLIGADA 2 null
XALGCONTRATOLOCCOMISSAOCOMPL.CODCOLCONTLOC FKXALGCONTLOCOMCOMPL_XALGCONTLR
XALGCONTRATOLOCCORRETOR.CODCOLCONTLOC FKXALGCONTLOCORC_XALGCONTLOCORR
CODCONTLOC int 4 null
XALGCONTRATOLOCCOMISSAOCOMPL.CODCONTLOC FKXALGCONTLOCOMCOMPL_XALGCONTLR
XALGCONTRATOLOCCORRETOR.CODCONTLOC FKXALGCONTLOCORC_XALGCONTLOCORR
CODCOLCFOCORRETOR DCODCOLIGADA 2 null
XALGCONTRATOLOCCOMISSAOCOMPL.CODCOLCFOCORRETOR FKXALGCONTLOCOMCOMPL_XALGCONTLR
XALGCONTRATOLOCCORRETOR.CODCOLCFOCORRETOR FKXALGCONTLOCORC_XALGCONTLOCORR
CODCFOCORRETOR varchar 25 null
XALGCONTRATOLOCCOMISSAOCOMPL.CODCFOCORRETOR FKXALGCONTLOCOMCOMPL_XALGCONTLR
XALGCONTRATOLOCCORRETOR.CODCFOCORRETOR FKXALGCONTLOCORC_XALGCONTLOCORR
CODCOLCOMISSAOCONTLOC int 4 null
XALGCONTRATOLOCCOMISSAOCOMPL.CODCOLCOMISSAOCONTLOC FKXALGCONTLOCOMCOMPL_XALGCONTLR
CODCOMISSAOCONTLOC int 4 null
XALGCONTRATOLOCCOMISSAOCOMPL.CODCOMISSAOCONTLOC FKXALGCONTLOCOMCOMPL_XALGCONTLR
SITUACAOCOMISSAO int 4 √ null
CODCOLFRM DCODCOLIGADANULL 2 √ null
GFORMULA.CODCOLIGADA FKXALGCONTLOCORC_GFORMULAR
APLICACAOFRM varchar 1 √ null
GFORMULA.APLICACAO FKXALGCONTLOCORC_GFORMULAR
CODFRM varchar 8 √ null
GFORMULA.CODIGO FKXALGCONTLOCORC_GFORMULAR
VR_TOT_COMISSAO RMDVALOR4 17,4 √ null
MEMO_CALC_COMISSAO varchar 4000 √ null
CODCOLMOV DCODCOLIGADANULL 2 √ null
TMOV.CODCOLIGADA FKXALGCONTLOCORC_TMOVR
IDMOV int 4 √ null
TMOV.IDMOV FKXALGCONTLOCORC_TMOVR
HISTMOV varchar 255 √ null
CODCOLTMV DCODCOLIGADANULL 2 √ null
CODTMV varchar 10 √ null
CODCOLPRD DCODCOLIGADANULL 2 √ null
IDPRD int 4 √ null
TPRODUTO.IDPRD FKXALGCONTLOCORC_TPRODUTOR
CODCOLFIL DCODCOLIGADANULL 2 √ null
GFILIAL.CODCOLIGADA FKXALGCONTLOCORC_GFILIALR
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKXALGCONTLOCORC_GFILIALR
CODCOLCCU DCODCOLIGADANULL 2 √ null
GCCUSTO.CODCOLIGADA FKXALGCONTLOCORC_GCCUSTOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKXALGCONTLOCORC_GCCUSTOR
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)
PKXALGCONTRATOLOCCORRETCOMISSA Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLCONTLOC + CODCONTLOC + CODCOLCFOCORRETOR + CODCFOCORRETOR + CODCOLCOMISSAOCONTLOC + CODCOMISSAOCONTLOC

Relationships

Close relationships within degrees of separation