CAGMOLDE

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CAGRATEIO.CODCOLIGADA FKCAGRATEIO_CAGMOLDER
CHISTP.CODCOLIGADA FKCAGMOLDE_CHISTPR
GCCUSTO.CODCOLIGADA FKCAGMOLDE_GCCUSTOR
GDEPTO.CODCOLIGADA FKCAGMOLDE_GDEPTOR
CPDIARIOPTG.CODCOLIGADA FKCAGMOLDE_CPDIARIOPTGR
CAGESTRUT.CODCOLIGADA FKCAGMOLDE_CAGESTRUTR
GFILIAL.CODCOLIGADA FKCAGMOLDE_GFILIALR
CODESTRUT varchar 10 null
CAGRATEIO.CODESTRUT FKCAGRATEIO_CAGMOLDER
CAGESTRUT.CODESTRUT FKCAGMOLDE_CAGESTRUTR
CODMOLDE int 4 null
CAGRATEIO.CODMOLDE FKCAGRATEIO_CAGMOLDER
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKCAGMOLDE_GDEPTOR
GFILIAL.CODFILIAL FKCAGMOLDE_GFILIALR
DIA smallint 2 √ null
MES smallint 2 √ null
ANO smallint 2 √ null
DEBITO DCODCONTA 40 √ null
CCONTA.CODCONTA FKCAGMOLDE_CCONTADEBITOR
CREDITO DCODCONTA 40 √ null
CCONTA.CODCONTA FKCAGMOLDE_CCONTACREDITOR
PARTIDA DCODCONTA 40 √ null
CCONTA.CODCONTA FKCAGMOLDE_CCONTAPARTIDAR
CODCOLDEBITO DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKCAGMOLDE_CCONTADEBITOR
CODCOLCREDITO DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKCAGMOLDE_CCONTACREDITOR
CODCOLPARTIDA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKCAGMOLDE_CCONTAPARTIDAR
VALOR RMDVALOR2 17,2 √ null
DIA2 smallint 2 √ null
MES2 smallint 2 √ null
ANO2 smallint 2 √ null
VALOR2 RMDVALOR4 17,4 √ null
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKCAGMOLDE_CHISTPR
COMPLEMENTO varchar 250 √ null
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKCAGMOLDE_GCCUSTOR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKCAGMOLDE_GDEPTOR
DOCUMENTO varchar 20 √ null
CODDIARIO varchar 5 √ null
CPDIARIOPTG.CODDIARIO FKCAGMOLDE_CPDIARIOPTGR
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)
PKCAGMOLDE Primary key Asc/Asc/Asc CODCOLIGADA + CODESTRUT + CODMOLDE

Relationships

Close relationships within degrees of separation