DTRIBUTO

51 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCAMPOSDIPJ.CODCOLIGADA FKDCAMPOSDIPJ_DTRIBUTOR
DCOMPPREJUIZOFISCAL.CODCOLIGADA FKDCOMPPREJUIZOFISCAL_DTRIBUTOR
DCOMPTRBFED.CODCOLIGADA FKDCOMPTRBFED_DTRIBUTOR
DCONTALALURB.CODCOLIGADA FKDCONTALALURB_DTRIBUTOR
DFILTROTRB.CODCOLIGADA FKDFILTROTRB_DTRIBUTOR
DFILTROTRIBUTO.CODCOLIGADA FKDFILTROTRIBUTO_DTRIBUTOR
DITMEVCTRB.CODCOLIGADA FKDITMEVCTRB_DTRIBUTOR
DITMEVCTRBNAT.CODCOLIGADA FKDITMEVCTRBNAT_DTRIBUTOR
DLANCDIPAM.CODCOLIGADA FKDLANCDIPAM_DTRIBUTOR
DLANCLALURB.CODCOLIGADA FKDLANCLALURB_DTRIBUTOR
DLDC.CODCOLIGADA FKDLDC_DTRIBUTOR
DPERIODO.CODCOLIGADA FKEPERIODO_DTRIBUTOR
DPRDPAUTA.CODCOLIGADA FKDPRDPAUTA_DTRIBUTOR
DPREJUIZOFISCAL.CODCOLIGADA FKDPREJUIZOFISCAL_DTRIBUTOR
DRELATORIO.CODCOLIGADA FKDRELATORIO_DTRIBUTOR
DSLDCREDTRIBUTO.CODCOLIGADA FKDSLDCREDTRIBUTO_DTRIBUTOR
DSLDCREDTRIBUTORET.CODCOLIGADA FKDSLDCREDTRIBUTORET_DTRIBUTOR
DTRBCFOPCALCULO.CODCOLIGADA FKDTRBCFOPCALCULO_DTRIBUTOR
DTRBCONT.CODCOLIGADA FKDTRBCONT_DTRIBUTOR
DTRBITEM.CODCOLIGADA FKDTRBITEM_DTRIBUTOR
DTRBITEMHISTORICO.CODCOLIGADA FKDTRBITEMHISTORICO_DTRIBUTOR
DTRBLAF.CODCOLIGADA FKDTRBLAF_DTRIBUTOR
DTRBLAFHISTORICO.CODCOLIGADA FKDTRBLAFHISTORICO_DTRIBUTOR
DTRBMUNICIPIOPRD.CODCOLIGADA FKDTRBMUNICIPIOPRD_DTRIBUTOR
DTRBNATUREZA.CODCOLIGADA FKDTRBNATUREZA_DTRIBUTOR
DTRBREGRAICMS.CODCOLIGADA FKDTRBREGRAICMS_DTRIBUTOR
DTRBREGRAIPI.CODCOLIGADA FKDTRBREGRAIPI_DTRIBUTOR
DTRIBDISCUTIDOSPROCJUDICIAL.CODCOLIGADA FKDTRIBDISCPROC_DTRIBUTOR
FLANBAIXATRB.CODCOLIGADA FKFLANBAIXATRB_DTRIBUTOR
FRETENCAOACUMULADA.CODCOLIGADA FKFRETENCAOACUMULADA_DTRIBUTOR
FTRBCFO.CODCOLIGADA FKFTRBCFO_DTRIBUTOR
FTRBLAN.CODCOLIGADA FKFTRBLAN_DTRIBUTOR
FTRBPARAM.CODCOLIGADA FKFTRBPARAM_DTRIBUTOR
TITMEVC.CODCOLIGADA FKTITMEVC_DTRIBUTOR
TITMTMV.CODCOLIGADA FKTITMTMV_DTRIBUTOR
TREDUCAOZTRB.CODCOLIGADA FKTREDUCAOZTRB_DTRIBUTOR
TTIPFIL.CODCOLIGADA FKTTIPFIL_DTRIBUTOR
TTMV.CODCOLIGADA FKTTMV_DTRIBUTORATEIOR
TTMVTRBPARCELA.CODCOLIGADA FKTTMVTRBPARCELA_DTRIBUTOR
TTRBMOV.CODCOLIGADA FKTTRBMOV_DTRIBUTOBASER
TTRBMOVLOGFAT.CODCOLIGADA FKTTRBMOVLOGFAT_DTRIBUTOR
TTRBPRD.CODCOLIGADA FKTTRBPRD_DTRIBUTOR
TTRBTMV.CODCOLIGADA FKTTRBTMV_DTRIBUTOBASER
TTRIBUTACAOECF.CODCOLIGADA FKTTRIBUTACAOECF_DTRIBUTOR
GCOLIGADA.CODCOLIGADA FKDTRIBUTO_GCOLIGADAR
DEXPRESSAO.CODCOLIGADA FKDTRIBUTO_DEXPRESSAOR
GFORMULA.CODCOLIGADA FKDTRIBUTO_GFORMULAR
CODTRB varchar 10 null
DCAMPOSDIPJ.CODTRBORIGEM FKDCAMPOSDIPJ_DTRIBUTOR
DCOMPPREJUIZOFISCAL.CODTRB FKDCOMPPREJUIZOFISCAL_DTRIBUTOR
DCOMPTRBFED.CODTRB FKDCOMPTRBFED_DTRIBUTOR
DCONTALALURB.CODTRB FKDCONTALALURB_DTRIBUTOR
DFILTROTRB.CODTRIBUTO FKDFILTROTRB_DTRIBUTOR
DFILTROTRIBUTO.CODTRB FKDFILTROTRIBUTO_DTRIBUTOR
DITMEVCTRB.CODTRB FKDITMEVCTRB_DTRIBUTOR
DITMEVCTRBNAT.CODTRB FKDITMEVCTRBNAT_DTRIBUTOR
DLANCDIPAM.CODTRB FKDLANCDIPAM_DTRIBUTOR
DLANCLALURB.CODTRB FKDLANCLALURB_DTRIBUTOR
DLDC.CODTRB FKDLDC_DTRIBUTOR
DPERIODO.CODTRB FKEPERIODO_DTRIBUTOR
DPRDPAUTA.CODTRB FKDPRDPAUTA_DTRIBUTOR
DPREJUIZOFISCAL.CODTRB FKDPREJUIZOFISCAL_DTRIBUTOR
DRELATORIO.CODTRB FKDRELATORIO_DTRIBUTOR
DSLDCREDTRIBUTO.CODTRB FKDSLDCREDTRIBUTO_DTRIBUTOR
DSLDCREDTRIBUTORET.CODTRB FKDSLDCREDTRIBUTORET_DTRIBUTOR
DTRBCFOPCALCULO.CODTRB FKDTRBCFOPCALCULO_DTRIBUTOR
DTRBCONT.CODTRB FKDTRBCONT_DTRIBUTOR
DTRBITEM.CODTRB FKDTRBITEM_DTRIBUTOR
DTRBITEMHISTORICO.CODTRB FKDTRBITEMHISTORICO_DTRIBUTOR
DTRBLAF.CODTRB FKDTRBLAF_DTRIBUTOR
DTRBLAFHISTORICO.CODTRB FKDTRBLAFHISTORICO_DTRIBUTOR
DTRBMUNICIPIOPRD.CODTRB FKDTRBMUNICIPIOPRD_DTRIBUTOR
DTRBNATUREZA.CODTRB FKDTRBNATUREZA_DTRIBUTOR
DTRBREGRAICMS.CODTRB FKDTRBREGRAICMS_DTRIBUTOR
DTRBREGRAIPI.CODTRB FKDTRBREGRAIPI_DTRIBUTOR
DTRIBDISCUTIDOSPROCJUDICIAL.CODTRB FKDTRIBDISCPROC_DTRIBUTOR
FLANBAIXATRB.CODTRB FKFLANBAIXATRB_DTRIBUTOR
FRETENCAOACUMULADA.CODTRB FKFRETENCAOACUMULADA_DTRIBUTOR
FTRBCFO.CODTRB FKFTRBCFO_DTRIBUTOR
FTRBLAN.CODTRB FKFTRBLAN_DTRIBUTOR
FTRBPARAM.CODTRB FKFTRBPARAM_DTRIBUTOR
TITMEVC.CODTRB FKTITMEVC_DTRIBUTOR
TITMTMV.TRBORDENACAO FKTITMTMV_DTRIBUTOR
TREDUCAOZTRB.CODTRB FKTREDUCAOZTRB_DTRIBUTOR
TTIPFIL.CODTRB FKTTIPFIL_DTRIBUTOR
TTMV.CODTRBRATEIOLAN FKTTMV_DTRIBUTORATEIOR
TTMVTRBPARCELA.CODTRB FKTTMVTRBPARCELA_DTRIBUTOR
TTRBMOV.CODTRB FKTTRBMOV_DTRIBUTOR
TTRBMOV.CODTRBBASE FKTTRBMOV_DTRIBUTOBASER
TTRBMOVLOGFAT.CODTRB FKTTRBMOVLOGFAT_DTRIBUTOR
TTRBPRD.CODTRB FKTTRBPRD_DTRIBUTOR
TTRBTMV.CODTRB FKTTRBTMV_DTRIBUTOR
TTRBTMV.CODTRBBASE FKTTRBTMV_DTRIBUTOBASER
TTRIBUTACAOECF.CODTRB FKTTRIBUTACAOECF_DTRIBUTOR
DESCRICAO varchar 50 √ null
ACHARALIQUOTA varchar 1 √ null
INCIDENCIA varchar 1 √ null
TIPOTRIBFISC varchar 2 √ null
TIPO varchar 1 √ null
ABRANGENCIA varchar 1 √ null
FATOR RMDVALOR4 17,4 √ null
INICIOVIGENCIA datetime 16,3 √ null
FIMVIGENCIA datetime 16,3 √ null
APURACAO varchar 1 √ null
SIMBOLO varchar 10 √ null
GMOEDA.SIMBOLO FKDTRIBUTO_GMOEDAR
BASECALCULO varchar 1 √ null
ALIQUOTA RMDVALOR4 17,4 √ null
CONTABIL varchar 2 √ null
CODRECEITA varchar 6 √ null
NUMEROTRB smallint 2 √ null
CODEXPR int 4 √ null
DEXPRESSAO.CODEXPR FKDTRIBUTO_DEXPRESSAOR
IMPOSTORETIDO int 4 √ null
ALIQIRADICIONAL RMDVALOR4 17,4 √ null
VALORISENCAO RMDVALOR4 17,4 √ null
PERCPRESUNCAOMATERIAIS RMDVALOR4 17,4 √ null
PERCPRESUNCAOSERVICOS RMDVALOR4 17,4 √ null
VALORMINIMOGUIA RMDVALOR2 17,2 √ (0)
CODFRM varchar 8 √ null
GFORMULA.CODIGO FKDTRIBUTO_GFORMULAR
APLICACAOFRM varchar 1 √ null
GFORMULA.APLICACAO FKDTRIBUTO_GFORMULAR
PERCCOMPPREJUIZO RMDVALOR4 17,4 √ null
PERCCOMPENSACAO RMDVALOR4 17,4 √ null
CODANTECIPACAOTRIBUTARIA varchar 2 √ null
PERCADICAODOACOES RMDVALOR4 17,4 √ null
TIPODOCDEFAULT varchar 10 √ null
GRUPORECEITA3 RMDVALOR4 17,4 √ null
GRUPORECEITA4 RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODTBORCAMENTO varchar 40 √ null
TTBORCAMENTO.CODTBORCAMENTO FKDTRIBUTO_TTBORCAMENTOR
CODCOLTBORCAMENTO DCODCOLIGADANULL 2 √ null
TTBORCAMENTO.CODCOLIGADA FKDTRIBUTO_TTBORCAMENTOR

Indexes

Constraint Name Type Sort Column(s)
PKDTRIBUTO Primary key Asc/Asc CODCOLIGADA + CODTRB

Relationships

Close relationships within degrees of separation