TFNOVOCF

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TFERROR.CODCOLIGADA FKTFERROR_TFNOVOCFR
TFMOV.CODCOLIGADA FKTFMOV_TFNOVOCFR
CGCCFO varchar 20 null
TFERROR.CGCCFO FKTFERROR_TFNOVOCFR
TFMOV.CGCNOVOCFO FKTFMOV_TFNOVOCFR
NOMEFANTASIA varchar 60 √ null
NOME varchar 60 √ null
PESSOAFISOUJUR varchar 1 √ null
INSCRESTADUAL varchar 20 √ null
PAGREC smallint 2 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CIDADE DCIDADE 32 √ null
CODETD varchar 2 √ null
GETD.CODETD Implied ConstraintR
CEP DCEP 9 √ null
TELEFONE varchar 15 √ null
FAX varchar 15 √ null
EMAIL varchar 60 √ null
CONTATO varchar 40 √ null
DTHRATUALIZACAO datetime 16,3 √ null
STATUSCFO varchar 1 √ null
CODMUNICIPIO varchar 20 √ null
DATAGERACAO datetime 16,3 √ null
CODCOLCFO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKTFNOVOCF_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKTFNOVOCF_FCFOR
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)
PKTFNOVOCF Primary key Asc/Asc CODCOLIGADA + CGCCFO

Relationships

Close relationships within degrees of separation