TFILCONT

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TFILRAT.CODCOLIGADA FKTFILRAT_TFILCONTR
CHISTP.CODCOLIGADA FKTFILCONT_CHISTPR
GCCUSTO.CODCOLIGADA FKTFILCONT_GCCUSTOR
GDEPTO.CODCOLIGADA FKTFILCONT_GDEPTOR
GFILIAL.CODCOLIGADA FKTFILCONT_GFILIALR
IDFILCONT int 4 null
TFILRAT.IDFILCONT FKTFILRAT_TFILCONTR
TIPO smallint 2 null
TCODIGO.TIPO Implied ConstraintR
PERCENTUAL RMDVALOR4 17,4 √ null
CODFILIAL smallint 2 null
GDEPTO.CODFILIAL FKTFILCONT_GDEPTOR
GFILIAL.CODFILIAL FKTFILCONT_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKTFILCONT_GDEPTOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKTFILCONT_GCCUSTOR
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKTFILCONT_CHISTPR
COMPLHISTORICO varchar 250 √ null
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKTFILCONT_CCONTAR
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKTFILCONT_CCONTAR
CLASSCONTA varchar 10 √ null
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)
PKTFILCONT Primary key Asc/Asc IDFILCONT + CODCOLIGADA
TXFILCONT_CODCONTA Performance Asc/Asc/Asc/Asc/Asc CODCONTA + TIPO + CODFILIAL + CODCOLCONTA + CODCOLIGADA

Relationships

Close relationships within degrees of separation