FFATCONT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FFATCONTRAT.CODCOLIGADA FKFFATCONTRAT_FFATCONTR
CHISTP.CODCOLIGADA FKFFATCONT_CHISTPR
GCCUSTO.CODCOLIGADA FKFFATCONT_GCCUSTOR
GDEPTO.CODCOLIGADA FKFFATCONT_GDEPTOR
CCONTA.CODCOLIGADA FKFFATCONT_CCONTAR
GFILIAL.CODCOLIGADA FKFFATCONT_GFILIALR
FFAT.CODCOLIGADA FKFFATCONT_FFATR
IDFAT int 4 null
FFAT.IDFAT FKFFATCONT_FFATR
IDFATCONT int 4 null
FFATCONTRAT.IDFATCONT FKFFATCONTRAT_FFATCONTR
CODCOLCONTA DCODCOLIGADA 2 null
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKFFATCONT_CCONTAR
DEBOUCRED smallint 2 null
VALOR RMDVALOR4 17,4 null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKFFATCONT_GDEPTOR
GFILIAL.CODFILIAL FKFFATCONT_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKFFATCONT_GDEPTOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKFFATCONT_GCCUSTOR
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKFFATCONT_CHISTPR
COMPLHISTORICO varchar 250 √ null
CODLOTE int 4 √ null
ATIVO smallint 2 √ 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)
PKFFATCONT Primary key Asc/Asc CODCOLIGADA + IDFATCONT

Relationships

Close relationships within degrees of separation