CLCVARIAVEL

24 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CLCMOLDE.CODCOLIGADA FKLCMOLDE_CLCVARIAVEL_VALOR2R
CLCESTRUT.CODCOLIGADA FKLCVARIAVEL_CLCESTRUTR
IDLCESTRUT int 4 null
CLCMOLDE.IDLCESTRUT FKLCMOLDE_CLCVARIAVEL_DEBITOR
CLCESTRUT.IDLCESTRUT FKLCVARIAVEL_CLCESTRUTR
IDLCVARIAVEL int 4 null
CLCMOLDE.VARCCUSTO FKLCMOLDE_CLCVARIAVEL_GCCUSTOSR
CLCMOLDE.VARCOMPLEMENTO FKLCMOLDE_CLCVARIAVEL_COMPLR
CLCMOLDE.VARCREDITO FKLCMOLDE_CLCVARIAVEL_CREDITOR
CLCMOLDE.VARDEBITO FKLCMOLDE_CLCVARIAVEL_DEBITOR
CLCMOLDE.VARDEPTO FKLCMOLDE_CLCVARIAVEL_DPTOR
CLCMOLDE.VARDIARIO FKLCMOLDE_CLCVARIAVEL_DIARIOR
CLCMOLDE.VARDOCUMENTO FKLCMOLDE_CLCVARIAVEL_DOCUMENR
CLCMOLDE.VARFILIAL FKLCMOLDE_CLCVARIAVEL_FILIALR
CLCMOLDE.VARHISTP FKLCMOLDE_CLCVARIAVEL_CHISTPR
CLCMOLDE.VARPARTICIPANTE FKLCMOLDE_CLCVARIAVEL_PARTICR
CLCMOLDE.VARPARTIDA FKLCMOLDE_CLCVARIAVEL_PARTIDAR
CLCMOLDE.VARVALOR FKLCMOLDE_CLCVARIAVEL_VALORR
CLCMOLDE.VARVALOR2 FKLCMOLDE_CLCVARIAVEL_VALOR2R
CODLCVARIAVEL varchar 15 null
DESCRICAO varchar 40 √ null
TIPO smallint 2 √ null
TCODIGO.TIPO Implied ConstraintR
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)
PKCLCVARIAVEL Primary key Asc/Asc/Asc CODCOLIGADA + IDLCESTRUT + IDLCVARIAVEL

Relationships

Close relationships within degrees of separation