CLCMOLDE

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CLCMOLDERATEIO.CODCOLIGADA FKLCMOLDERATEIO_CLCMOLDER
CHISTP.CODCOLIGADA FKLCMOLDE_CHISTPR
GCCUSTO.CODCOLIGADA FKLCMOLDE_GCCUSTOR
GDEPTO.CODCOLIGADA FKLCMOLDE_GDEPTOR
CPDIARIOPTG.CODCOLIGADA FKLCMOLDE_CPDIARIOPTGR
CLCESTRUT.CODCOLIGADA FKLCMOLDE_CLCESTRUTR
CSPEDPARTICIPANTE.CODCOLIGADA FKLCMOLDE_PARTICIPANTER
CLCVARIAVEL.CODCOLIGADA FKLCMOLDE_CLCVARIAVEL_VALOR2R
GFILIAL.CODCOLIGADA FKLCMOLDE_GFILIALR
IDLCESTRUT int 4 null
CLCMOLDERATEIO.IDLCESTRUT FKLCMOLDERATEIO_CLCMOLDER
CLCVARIAVEL.IDLCESTRUT FKLCMOLDE_CLCVARIAVEL_DEBITOR
CLCESTRUT.IDLCESTRUT FKLCMOLDE_CLCESTRUTR
IDLCMOLDE int 4 null
CLCMOLDERATEIO.IDLCMOLDE FKLCMOLDERATEIO_CLCMOLDER
CODLCMOLDE varchar 15 null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKLCMOLDE_GDEPTOR
GFILIAL.CODFILIAL FKLCMOLDE_GFILIALR
VARFILIAL int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_FILIALR
DEBITO DCODCONTA 40 √ null
CCONTA.CODCONTA FKLCMOLDE_CCONTA_DEBITOR
CODCOLDEBITO DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKLCMOLDE_CCONTA_DEBITOR
VARDEBITO int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_DEBITOR
CREDITO DCODCONTA 40 √ null
CCONTA.CODCONTA FKLCMOLDE_CCONTA_CREDITOR
CODCOLCREDITO DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKLCMOLDE_CCONTA_CREDITOR
VARCREDITO int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_CREDITOR
PARTIDA DCODCONTA 40 √ null
CCONTA.CODCONTA FKLCMOLDE_CCONTA_PARTIDAR
CODCOLPARTIDA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKLCMOLDE_CCONTA_PARTIDAR
VARPARTIDA int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_PARTIDAR
VALOR RMDVALOR2 17,2 √ null
VARVALOR int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_VALORR
CODHISTP varchar 10 √ null
CHISTP.CODHISTP FKLCMOLDE_CHISTPR
VARHISTP int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_CHISTPR
COMPLEMENTO varchar 250 √ null
VARCOMPLEMENTO int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_COMPLR
VALOR2 RMDVALOR4 17,4 √ null
VARVALOR2 int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_VALOR2R
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKLCMOLDE_GCCUSTOR
VARCCUSTO int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_GCCUSTOSR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKLCMOLDE_GDEPTOR
VARDEPTO int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_DPTOR
DOCUMENTO varchar 20 √ null
VARDOCUMENTO int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_DOCUMENR
DATA2 datetime 16,3 √ null
VARDATA2 int 4 √ null
CODDIARIO varchar 5 √ null
CPDIARIOPTG.CODDIARIO FKLCMOLDE_CPDIARIOPTGR
VARDIARIO int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_DIARIOR
IDPARTICIPANTE int 4 √ null
CSPEDPARTICIPANTE.IDPARTICIPANTE FKLCMOLDE_PARTICIPANTER
VARPARTICIPANTE int 4 √ null
CLCVARIAVEL.IDLCVARIAVEL FKLCMOLDE_CLCVARIAVEL_PARTICR
EXPRESSAO varchar 100 √ null
EXPRESSAO2 varchar 100 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DIA2 smallint 2 √ null
MES2 smallint 2 √ null
ANO2 smallint 2 √ null
CONSDATA2ESTRUT smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKCLCMOLDE Primary key Asc/Asc/Asc CODCOLIGADA + IDLCESTRUT + IDLCMOLDE

Relationships

Close relationships within degrees of separation