DITMEVCTRB

48 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DAPURACAOITEM.CODCOLIGADA FKDAPURACAOITEM_DITMEVCTRBR
DITMEVCTRBCGER.CODCOLIGADA FKDITMEVCTRBCGER_DITMEVCTRBR
DITMEVCTRBHISTP.CODCOLIGADA FKDITMEVCTRBHISTP_DITMEVCTRBR
DPROCJUDEVCTRB.CODCOLIGADA FKDPROCJUDEVCTRB_DITMEVCTRBR
DEVCTRB.CODCOLIGADA FKDITMEVCTRB_DEVCTRBEXPR
GCCUSTO.CODCOLIGADA FKDITMEVCTRB_GCCUSTOR
GDEPTO.CODCOLIGADA FKDITMEVCTRB_GDEPTOR
ICENARIOCALCULO.CODCOLIGADA FKDITMEVCTRB_ICENARIOCALCCONTR
DCFOP.CODCOLIGADA FKDITMEVCTRB_DCFOPR
GFILIAL.CODCOLIGADA FKDITMEVCTRB_GFILIALR
DTRIBUTO.CODCOLIGADA FKDITMEVCTRB_DTRIBUTOR
IDEVCTRB int 4 null
DAPURACAOITEM.IDEVCTRB FKDAPURACAOITEM_DITMEVCTRBR
DITMEVCTRBCGER.IDEVCTRB FKDITMEVCTRBCGER_DITMEVCTRBR
DITMEVCTRBHISTP.IDEVCTRB FKDITMEVCTRBHISTP_DITMEVCTRBR
DPROCJUDEVCTRB.IDEVCTRB FKDPROCJUDEVCTRB_DITMEVCTRBR
DEVCTRB.IDEVCTRB FKDITMEVCTRB_DEVCTRBR
NUMITEM int 4 null
DAPURACAOITEM.NUMITEM FKDAPURACAOITEM_DITMEVCTRBR
DITMEVCTRBCGER.NUMITEM FKDITMEVCTRBCGER_DITMEVCTRBR
DITMEVCTRBHISTP.NUMITEM FKDITMEVCTRBHISTP_DITMEVCTRBR
DPROCJUDEVCTRB.NUMITEM FKDPROCJUDEVCTRB_DITMEVCTRBR
TIPO smallint 2 √ null
TCODIGO.TIPO Implied ConstraintR
CODCOLCONTA DCODCOLIGADA 2 √ null
CCONTA.CODCOLIGADA FKDITMEVCTRB_CCONTAR
CODCONTA DCODCONTA 40 √ null
CCONTA.CODCONTA FKDITMEVCTRB_CCONTAR
GRUPO smallint 2 null
DESCRICAO varchar 200 √ null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKDITMEVCTRB_GDEPTOR
GFILIAL.CODFILIAL FKDITMEVCTRB_GFILIALR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKDITMEVCTRB_GCCUSTOR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKDITMEVCTRB_GDEPTOR
OPERACAO varchar 1 √ (1)
PERCENTCALCULO RMDVALOR4 17,4 √ null
PERCENTUAL RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDTABDINAMECF int 4 √ null
DTABELADINAMICAECF.IDTABDINAMECF FKDITMEVCTRB_DTABELADINAMCAECFR
VLRAPLICAPERCENTUAL smallint 2 √ null
ORIGEMINFO smallint 2 √ null
EXPRESSAO MEMO 2147483647 √ null
IDNAT int 4 √ null
DCFOP.IDNAT FKDITMEVCTRB_DCFOPR
CAMPOVLRCONSIDERADO varchar 30 √ null
CODTRB varchar 10 √ null
DTRIBUTO.CODTRB FKDITMEVCTRB_DTRIBUTOR
TRBCAMPOVLR varchar 30 √ null
CODPARALELO varchar 10 √ null
CCONTA2.CODPARALELO FKDITMEVCTRB_CCONTA2R
CODCOLCONTALALUR DCODCOLIGADA 2 √ null
CCONTA2.CODCOLIGADA FKDITMEVCTRB_CCONTA2R
CODCONTALALUR DCODCONTA 40 √ null
CCONTA2.CODCONTA FKDITMEVCTRB_CCONTA2R
TIPOATIVIDADE int 4 √ null
PROUNI int 4 √ null
PERCREDUCAO RMDVALOR4 17,4 √ null
IDTABDINAMECFLEXP int 4 √ null
DTABELADINAMICAECF.IDTABDINAMECF FKDITMEVCTRB_DTABELADINAMICAECR
IDEVCTRBLEXP int 4 √ null
DEVCTRB.IDEVCTRB FKDITMEVCTRB_DEVCTRBEXPR
PROPATIVRURAL varchar 1 √ null
EFEITOLPARTEB smallint 2 √ null
GERARLANCLALURBAUTOM smallint 2 √ null
CODCOLCONTALEFEITOPTB DCODCOLIGADANULL 2 √ null
CCONTA2.CODCOLIGADA FKDITMEVCTRB_CCONTA2_EFEITOPTBR
CODPARALELOEFEITOPTB varchar 10 √ null
CCONTA2.CODPARALELO FKDITMEVCTRB_CCONTA2_EFEITOPTBR
CODCONTALEFEITOPTB DCODCONTA 40 √ null
CCONTA2.CODCONTA FKDITMEVCTRB_CCONTA2_EFEITOPTBR
IDCENARIOCALCULOFIS int 4 √ null
ICENARIOCALCULO.IDCENARIOCALCULO FKDITMEVCTRB_ICENARIOCALCFISR
IDCENARIOCALCULOCONT int 4 √ null
ICENARIOCALCULO.IDCENARIOCALCULO FKDITMEVCTRB_ICENARIOCALCCONTR

Indexes

Constraint Name Type Sort Column(s)
PKDITMEVCTRB Primary key Asc/Asc/Asc CODCOLIGADA + IDEVCTRB + NUMITEM

Relationships

Close relationships within degrees of separation