HPROSPECT

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
HACAO.CODCOLIGADAPROSPECT FKHACAO_HPROSPECTR
HCLIENTEATENDIMENTO.COLIGADAPROSPECT FKHCLIENTEATEND_HPROSPECTR
HCLIENTECAMPANHA.COLIGADAPROSPECT FKHCLIENTECAMPANHA_HPROSPECTR
HPROSPECTATIVO.CODCOLIGADAPRO FKHPROSPECTATIVO_HPROSPECTR
HPROSPECTCOMPL.CODCOLIGADA FKHPROSPECTCOMPL_HPROSPECTR
HPROSPECTCONTATO.CODCOLIGADA FKHPROSPECTCONTATO_HPROSPECTR
XPROSPECT.CODCOLPROSPECT FKXPROSPECT_HPROSPECTR
HPRIMEIROCONTATO.CODCOLIGADA FKHPROSPECT_HPRIMEIROCONTATOR
GCOLIGADA.CODCOLIGADA FKHPROSPECT_GCOLIGR
HORIGEM.CODCOLIGADA FKHPROSPECT_HORIGEMR
CODPROSPECT int 4 null
HACAO.CODPROSPECT FKHACAO_HPROSPECTR
HCLIENTEATENDIMENTO.CODPROSPECT FKHCLIENTEATEND_HPROSPECTR
HCLIENTECAMPANHA.CODPROSPECT FKHCLIENTECAMPANHA_HPROSPECTR
HPROSPECTATIVO.CODPROSPECT FKHPROSPECTATIVO_HPROSPECTR
HPROSPECTCOMPL.CODPROSPECT FKHPROSPECTCOMPL_HPROSPECTR
HPROSPECTCONTATO.CODPROSPECT FKHPROSPECTCONTATO_HPROSPECTR
XPROSPECT.CODPROSPECT FKXPROSPECT_HPROSPECTR
NOMEFANTASIA varchar 60 √ null
NOME varchar 60 √ null
CGCCFO varchar 20 √ null
INSCRESTADUAL varchar 20 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CODETD varchar 2 √ null
GMUNICIPIO.CODETDMUNICIPIO FKHPROSPECT_GMUNICIPIOR
GETD.CODETD FKHPROSPECT_GETDR
CEP DCEP 9 √ null
TELEFONE varchar 15 √ null
FAX varchar 15 √ null
TELEX varchar 15 √ null
EMAIL varchar 60 √ null
ATIVO smallint 2 √ null
DATAULTALTERACAO datetime 16,3 √ null
DATACRIACAO datetime 16,3 √ null
DATAULTMOVIMENTO datetime 16,3 √ null
CODCOLIGADAATEND DCODCOLIGADANULL 2 √ null
CODATENDENTE int 4 √ null
DTINICATIVIDADES datetime 16,3 √ null
NUMFUNCIONARIOS int 4 √ null
PESSOAFISOUJUR varchar 1 √ null
SENHA varchar 8 √ null
CODORIGEM int 4 √ null
HORIGEM.CODORIGEM FKHPROSPECT_HORIGEMR
CODCOLIGINDICACAO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKHPROSPECT_FCFOR
CODCFOINDICACAO varchar 25 √ null
FCFO.CODCFO FKHPROSPECT_FCFOR
TIPOCLIENTE int 4 √ null
CODLOCAL int 4 √ null
HLOCALIDADE.CODLOCAL FKHPROSPECT_HLOCALIDADER
CODCOLIGADATCF DCODCOLIGADANULL 2 √ null
FTCF.CODCOLIGADA FKHPROSPECT_FTCFR
CODTCF varchar 25 √ null
FTCF.CODTCF FKHPROSPECT_FTCFR
CODPRCONTATO int 4 √ null
HPRIMEIROCONTATO.CODPRCONTATO FKHPROSPECT_HPRIMEIROCONTATOR
STATUS int 4 √ null
CODCOLIGADACONS smallint 2 √ null
HATENDENTE.CODCOLIGADA FKHPROSPECT_HATENDENTER
CODATENDENTECONS int 4 √ null
HATENDENTE.CODATENDENTE FKHPROSPECT_HATENDENTER
IDPAIS smallint 2 √ null
GPAIS.IDPAIS FKHPROSPECT_GPAISR
CODMUNICIPIO varchar 20 √ null
GMUNICIPIO.CODMUNICIPIO FKHPROSPECT_GMUNICIPIOR
CODUSUARIOONLINE varchar 20 √ null
GUSUARIO.CODUSUARIO FKHPROSPECT_GUSUARIOR
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)
PKHPROSPECT Primary key Asc/Asc CODCOLIGADA + CODPROSPECT

Relationships

Close relationships within degrees of separation