DEVCTRB

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCCUSTOEVCTRB.CODCOLIGADA FKDCCUSTOEVCTRB_DEVCTRBR
DEVCTRB.CODCOLIGADA FKDEVCTRB_DEVCTRBR
DEVCTRBLANC.CODCOLIGADA FKDEVCTRBLANC_DEVCTRBR
DITMEVCTRB.CODCOLIGADA FKDITMEVCTRB_DEVCTRBEXPR
DITMEVCTRBNAT.CODCOLIGADA FKDITMEVCTRBNAT_DEVCTRBR
DPERIODO.CODCOLIGADA FKDPERIODO_DEVCTRBR
DVIGENCIAEVCTRB.CODCOLIGADA FKDVIGENCIAEVCTRB_DEVCTRBR
CDSCONTFATOCONTABIL.CODCOLIGADA FKDEVCTRB_CDSCONTFATOCONTABIL2R
DEVCTRB.CODCOLIGADA FKDEVCTRB_DEVCTRBR
CDSCONTCOLUNA.CODCOLIGADA FKDEVCTRB_CDSCONTCOLUN2R
CDSCONTESTRUTURA.CODCOLIGADA FKDEVCTRB_CDSCONTESTRUTURAR
GFILIAL.CODCOLIGADA FKDEVCTRB_GFILIALR
IDEVCTRB int 4 null
DCCUSTOEVCTRB.IDEVCTRB FKDCCUSTOEVCTRB_DEVCTRBR
DEVCTRB.IDEVCTRBARURAL FKDEVCTRB_DEVCTRBR
DEVCTRBLANC.IDEVCTRB FKDEVCTRBLANC_DEVCTRBR
DITMEVCTRB.IDEVCTRB FKDITMEVCTRB_DEVCTRBR
DITMEVCTRB.IDEVCTRBLEXP FKDITMEVCTRB_DEVCTRBEXPR
DITMEVCTRBNAT.IDEVCTRB FKDITMEVCTRBNAT_DEVCTRBR
DPERIODO.IDEVCTRB FKDPERIODO_DEVCTRBR
DVIGENCIAEVCTRB.IDEVCTRB FKDVIGENCIAEVCTRB_DEVCTRBR
CODEVCTRB int 4 null
DESCRICAO varchar 200 √ null
PORFILIAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ACUMULATIVO smallint 2 √ (0)
FORMATRIBUTACAO smallint 2 null
CODTRB varchar 10 null
PORCCUSTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ADREMOUPAUTA smallint 2 √ null
REGIMERTT smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODFILIALSCP varchar 30 √ null
LEVANTAMENTOVBALRED DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IDTABDINAMECF int 4 √ null
DTABELADINAMICAECF.IDTABDINAMECF FKDEVCTRB_DTABELADINAMICAECFR
IDESTRUTDEMCONT int 4 √ null
CDSCONTESTRUTURA.IDESTRUT FKDEVCTRB_CDSCONTESTRUTURAR
CODFILIALRESULTCONT smallint 2 √ null
GFILIAL.CODFILIAL FKDEVCTRB_GFILIALR
FATRESULTCONT int 4 √ null
CDSCONTFATOCONTABIL.IDFATOCONTABIL FKDEVCTRB_CDSCONTFATOCONTABILR
COLVALORRESULTCONT int 4 √ null
CDSCONTCOLUNA.IDDSCONTCOLUNA FKDEVCTRB_CDSCONTCOLUNAR
FATOPERACIONAL int 4 √ null
CDSCONTFATOCONTABIL.IDFATOCONTABIL FKDEVCTRB_CDSCONTFATOCONTABL2R
COLVLROPERACIONAL int 4 √ null
COLVLRNAOOPERACIONAL int 4 √ null
CDSCONTCOLUNA.IDDSCONTCOLUNA FKDEVCTRB_CDSCONTCOLUN2R
FATNAOOPERACIONAL int 4 √ null
CDSCONTFATOCONTABIL.IDFATOCONTABIL FKDEVCTRB_CDSCONTFATOCONTABIL2R
LUCROEXPLORACAO int 4 √ null
ATIVIDADERURAL int 4 √ null
IDEVCTRBARURAL int 4 √ null
DEVCTRB.IDEVCTRB FKDEVCTRB_DEVCTRBR
FATCONTATIVGERAL int 4 √ null
COLORIVLRATIVGERAL int 4 √ null
FATCONTATIVRURAL int 4 √ null
COLORIVLRATIVRURAL int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKDEVCTRB Primary key Asc/Asc CODCOLIGADA + IDEVCTRB
DXDEVCTRB Must be unique Asc/Asc CODCOLIGADA + CODEVCTRB

Relationships

Close relationships within degrees of separation