ILOCALCONT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ILOCALRAT.CODCOLIGADA FKILOCALRAT_ILOCALCONTR
CHISTP.CODCOLIGADA FKILOCALCONT_CHISTPR
GCCUSTO.CODCOLIGADA FKILOCALCONT_GCCUSTOR
GDEPTO.CODCOLIGADA FKILOCALCONT_GDEPTOR
ILOCAL.CODCOLIGADA FKILOCALCONT_ILOCALR
GFILIAL.CODCOLIGADA FKILOCALCONT_GFILIALR
CODLOCAL varchar 40 null
ILOCALRAT.CODLOCAL FKILOCALRAT_ILOCALCONTR
ILOCAL.CODLOCAL FKILOCALCONT_ILOCALR
IDLOCALCONT int 4 null
ILOCALRAT.IDLOCALCONT FKILOCALRAT_ILOCALCONTR
TIPO smallint 2 null
TCODIGO.TIPO Implied ConstraintR
PERCENTUAL RMDVALOR4 17,4 √ null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKILOCALCONT_GDEPTOR
GFILIAL.CODFILIAL FKILOCALCONT_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKILOCALCONT_GDEPTOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKILOCALCONT_GCCUSTOR
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKILOCALCONT_CHISTPR
COMPLHISTORICO varchar 250 √ null
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKILOCALCONT_CCONTAR
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKILOCALCONT_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)
PKILOCALCONT Primary key Asc/Asc/Asc CODCOLIGADA + CODLOCAL + IDLOCALCONT

Relationships

Close relationships within degrees of separation