TCNT

25 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FLAN.CODCOLIGADA FKFLAN_TCNTR
OFCONTRATO.CODCOLIGADA FKOFCONTRATO_TCNTR
TCNTCOMPL.CODCOLIGADA FKTCNTCOMPL_TCNTR
TCNTHISTORICO.CODCOLIGADA FKTCNTHISTORICO_TCNTR
TITMCNT.CODCOLIGADA FKTITMCNT_TCNTR
TITMMOV.CODCOLIGADA FKTITMMOV_TCNTR
GCCUSTO.CODCOLIGADA FKTCNT_GCCUR
TRPR.CODCOLIGADA FKTCNT_TRPRR
TTB3.CODCOLIGADA FKTCNT_TTB3R
TTCN.CODCOLIGADA FKTCNT_TTCNR
TSTACNT.CODCOLIGADA FKTCNT_TSTACNTR
TTIP.CODCOLIGADA FKTCNT_TTIPR
FTB4.CODCOLIGADA FKTCNT_FTB4R
TTB1.CODCOLIGADA FKTCNT_TTB1R
FTB2.CODCOLIGADA FKTCNT_FTB2R
TVEN.CODCOLIGADA FKTCNT_TVEN2R
GDEPTO.CODCOLIGADA FKTCNT_GDEPR
TMCACNT.CODCOLIGADA FKTCNT_TMCACNTR
FTB3.CODCOLIGADA FKTCNT_FTB3R
TTB5.CODCOLIGADA FKTCNT_TTB5R
DCFOP.CODCOLIGADA FKTCNT_DCFOPR
TCPG.CODCOLIGADA FKTCNT_TCPGPRAZOR
TTB4.CODCOLIGADA FKTCNT_TTB4R
FTB1.CODCOLIGADA FKTCNT_FTB1R
TTB2.CODCOLIGADA FKTCNT_TTB2R
FTB5.CODCOLIGADA FKTCNT_FTB5R
IDCNT int 4 null
FLAN.IDCNT FKFLAN_TCNTR
OFCONTRATO.IDCNT FKOFCONTRATO_TCNTR
TCNTCOMPL.IDCNT FKTCNTCOMPL_TCNTR
TCNTHISTORICO.IDCNT FKTCNTHISTORICO_TCNTR
TITMCNT.IDCNT FKTITMCNT_TCNTR
TITMMOV.IDCNT FKTITMMOV_TCNTR
CODTCN varchar 5 √ null
TTCN.CODTCN FKTCNT_TTCNR
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKTCNT_GDEPR
CODIGOCONTRATO varchar 30 √ null
CODCFO varchar 25 √ null
FCFO.CODCFO FKTCNT_FCFOR
FCFOCONTATO.CODCFO FKTCNT_FCFOCONTATOCOBRANCAR
CODRPR varchar 15 √ null
TRPR.CODRPR FKTCNT_TRPRR
COMISSAOREPRES RMDVALOR2 17,2 √ null
DATACONTRATO datetime 16,3 √ null
DATAINICIO datetime 16,3 √ null
PFHSTGRADEREMUN.DATAINICIO Implied ConstraintR
DATAFIM datetime 16,3 √ null
CODSTACNT varchar 5 √ null
TSTACNT.CODSTACNT FKTCNT_TSTACNTR
DATACANCEL datetime 16,3 √ null
CODMCACNT varchar 5 √ null
TMCACNT.CODMCACNT FKTCNT_TMCACNTR
CODCPG varchar 5 √ null
TCPG.CODCPG FKTCNT_TCPGR
CODMOEVALORCONTRATO varchar 10 √ null
GMOEDA.SIMBOLO FKTCNT_GMOER
DIAFATURAMENTO smallint 2 √ null
DIASCARENPARAFAT smallint 2 √ null
DIASCARENCANCFAT smallint 2 √ null
IMPRIMEMOV smallint 2 √ null
VALORCONTRATO RMDVALOR4 17,4 √ null
CAMPOLIVRE varchar 100 √ null
OBSERVACAO varchar 60 √ null
CODCPGPRAZO varchar 5 √ null
TCPG.CODCPG FKTCNT_TCPGPRAZOR
CODVEN varchar 16 √ null
TVEN.CODVEN FKTCNT_TVENR
COMISSAOVEN RMDVALOR2 17,2 √ null
CODCOLCFO smallint 2 √ null
FCFOCONTATO.CODCOLIGADA FKTCNT_FCFOCONTATOENTREGAR
FCFO.CODCOLIGADA FKTCNT_FCFOR
NOME varchar 100 √ null
EPLANILHASEXP.NOME Implied ConstraintR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKTCNT_GCCUR
CODCOLIGADA2 DCODCOLIGADA 2 null
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKTCNT_GDEPR
CODVEN2 varchar 16 √ null
TVEN.CODVEN FKTCNT_TVEN2R
COMISSAOVEN2 RMDVALOR2 17,2 √ null
CAMPOLIVRE2 varchar 100 √ null
CAMPOLIVRE3 varchar 100 √ null
DATAAUX DDATE 16,3 √ null
CODTIP varchar 10 √ null
TTIP.CODTIP FKTCNT_TTIPR
CODCOLCONTAGER DCODCOLIGADANULL 2 √ null
CGERENCIA.CODCOLIGADA FKTCNT_CGERENCIAR
CODCONTAGER DCODCONTA 40 √ null
CGERENCIA.CODCONTA FKTCNT_CGERENCIAR
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKTCNT_FTB1R
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKTCNT_FTB2R
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKTCNT_FTB3R
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKTCNT_FTB4R
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKTCNT_FTB5R
CODCXA varchar 10 √ null
FCXA.CODCXA FKTCNT_FCXAR
CODCOLCXA DCODCOLIGADANULL 2 √ null
FCXA.CODCOLIGADA FKTCNT_FCXAR
NATUREZA smallint 2 √ null
QTDEFATURAMENTOS smallint 2 √ null
IDNAT int 4 √ null
DCFOP.IDNAT FKTCNT_DCFOPR
CONTATOFCFOENTREGA int 4 √ null
FCFOCONTATO.IDCONTATO FKTCNT_FCFOCONTATOENTREGAR
CONTATOFCFOCOBRANCA int 4 √ null
FCFOCONTATO.IDCONTATO FKTCNT_FCFOCONTATOCOBRANCAR
CODTB1FAT varchar 10 √ null
TTB1.CODTB1FAT FKTCNT_TTB1R
CODTB2FAT varchar 10 √ null
TTB2.CODTB2FAT FKTCNT_TTB2R
CODTB3FAT varchar 10 √ null
TTB3.CODTB3FAT FKTCNT_TTB3R
CODTB4FAT varchar 10 √ null
TTB4.CODTB4FAT FKTCNT_TTB4R
CODTB5FAT varchar 10 √ null
TTB5.CODTB5FAT FKTCNT_TTB5R
CODUSUARIO varchar 20 √ null
GUSUARIO.CODUSUARIO FKTCNT_GUSUARIOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
INTEGRADOBONUM DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODVEN3 varchar 16 √ null
CODVEN4 varchar 16 √ null
COMISSAOVEN3 RMDVALOR2 17,2 √ null
COMISSAOVEN4 RMDVALOR2 17,2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTCNT Primary key Asc/Asc CODCOLIGADA + IDCNT
TXCNTCFO Performance Asc CODCFO
TXCNTCOD Must be unique Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODIGOCONTRATO
TXCNTDTA Performance Asc DATACONTRATO
TXCNTFIL Performance Asc CODFILIAL
TXCNTID Performance Asc IDCNT
TXCNTRPR Performance Asc CODRPR
TXCNTTCN Performance Asc CODTCN

Relationships

Close relationships within degrees of separation