CPARAMSECF

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CAPURACAOVIRTUAL.CODCOLIGADA FKCPARAMSECF_CAPURACAOVIRTUAL2R
DPARAMSECFFILIAL.CODCOLIGADA FKCPARAMSECF_DPARAMSECFFILIALR
CPARALELO.CODCOLIGADA FKCPARAMSECF_CPARALELO2R
CDSCONTESTRUTURA.CODCOLIGADA FKCPARAMSECF_CDSCONTESTRUTURA2R
CTGCESTRUT.CODCOLIGADA FKCPARAMSECF_CTGCESTRUTR
GFILIAL.CODCOLIGADA FKCPARAMSECF_GFILIALR
IDCPARAMSECF int 4 null
CODFILIAL smallint 2 √ null
DPARAMSECFFILIAL.CODFILIAL FKCPARAMSECF_DPARAMSECFFILIALR
GFILIAL.CODFILIAL FKCPARAMSECF_GFILIALR
IDPARAMSECF int 4 √ null
DPARAMSECFFILIAL.IDPARAMSECF FKCPARAMSECF_DPARAMSECFFILIALR
CODPLANOREF varchar 10 √ null
CPARALELO.CODPARALELO FKCPARAMSECF_CPARALELOR
DATAINICIAL DDATE 16,3 √ null
DATAFINAL DDATE 16,3 √ null
ENVIAHISTCONTA BOOLEAN 1 √ null
ENVIAHISTCCUSTO BOOLEAN 1 √ null
APURASALDOPELATRANSGRP BOOLEAN 1 √ null
CODESTRUTTRANSGRP varchar 10 √ null
CTGCESTRUT.CODESTRUT FKCPARAMSECF_CTGCESTRUTR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDAPRVIRTUAL_LPA int 4 √ null
CAPURACAOVIRTUAL.IDAPRVIRTUAL FKCPARAMSECF_CAPURACAOVIRTUALR
IDAPRVIRTUAL_LR int 4 √ null
CAPURACAOVIRTUAL.IDAPRVIRTUAL FKCPARAMSECF_CAPURACAOVIRTUAL2R
OPLUCROPATRIMESTRAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
OPLUCROREALTRIMESTRALMESAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ORIGEMRESULTCONTABIL smallint 2 √ null
CODCOLCONTAPREJ DCODCOLIGADANULL 2 √ null
CODCONTAPREJ DCODCONTA 40 √ null
CODCOLCONTALUCRO DCODCOLIGADANULL 2 √ null
CODCONTALUCRO DCODCONTA 40 √ null
METODOAVLEST12 varchar 100 √ null
METODOAVLEST1 smallint 2 √ null
METODOAVLEST2 smallint 2 √ null
METODOAVLEST3 smallint 2 √ null
METODOAVLEST4 smallint 2 √ null
ESTRUTINFOCOMPCUTO varchar 10 √ null
CPARALELO.CODPARALELO FKCPARAMSECF_CPARALELO2R
ESTRUTREGY671 int 4 √ null
CDSCONTESTRUTURA.IDESTRUT FKCPARAMSECF_CDSCONTESTRUTURAR
ESTRUTREGY672 int 4 √ null
CDSCONTESTRUTURA.IDESTRUT FKCPARAMSECF_CDSCONTESTRUTURA1R
ESTRUTREGX390 int 4 √ null
CDSCONTESTRUTURA.IDESTRUT FKCPARAMSECF_CDSCONTESTRUTURA2R
GERARREGY665 BOOLEAN 1 √ null
DTADOCAOINI_Y665 DDATETIME 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKCPARAMSECF Primary key Asc/Asc CODCOLIGADA + IDCPARAMSECF

Relationships

Close relationships within degrees of separation