DTRBCONT

58 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DTRBRAT.CODCOLIGADA FKDTRBRAT_DTRBCONTR
CHISTP.CODCOLIGADA FKDTRBCONT_CHISTPR
GCCUSTO.CODCOLIGADA FKDTRBCONT_GCCUSTOR
GDEPTO.CODCOLIGADA FKDTRBCONT_GDEPTOR
GCOLIGADA.CODCOLIGADA FKDTRBCONT_GCOLIGADAR
GFILIAL.CODCOLIGADA FKDTRBCONT_GFILIALR
DTRIBUTO.CODCOLIGADA FKDTRBCONT_DTRIBUTOR
IDTRBCONT int 4 null
DTRBRAT.IDTRBCONT FKDTRBRAT_DTRBCONTR
TIPO smallint 2 null
TCODIGO.TIPO Implied ConstraintR
CODTRB varchar 10 null
DTRIBUTO.CODTRB FKDTRBCONT_DTRIBUTOR
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKDTRBCONT_CCONTAR
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKDTRBCONT_CCONTAR
PERCENTUAL RMDVALOR4 17,4 √ null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKDTRBCONT_GDEPTOR
GFILIAL.CODFILIAL FKDTRBCONT_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKDTRBCONT_GDEPTOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKDTRBCONT_GCCUSTOR
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKDTRBCONT_CHISTPR
COMPLHISTORICO varchar 250 √ null
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)
PKDTRBCONT Primary key Asc/Asc IDTRBCONT + CODCOLIGADA
DXTRBCONT_CCONTA Performance Asc/Asc/Asc/Asc/Asc CODCONTA + TIPO + CODTRB + CODCOLCONTA + CODCOLIGADA

Relationships

Close relationships within degrees of separation