DREGRAICMS

690 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCFOP.CODCOLIGADA FKDCFOP_DREGRAICMSR
DTRBREGRAICMS.CODCOLIGADA FKDTRBREGRAICMS_DREGRAICMSR
GFORMULA.CODCOLIGADA FKDREGRAICMS_GFORMULAR
IDREGRAICMS int 4 null
DCFOP.IDREGRAICMS FKDCFOP_DREGRAICMSR
DTRBREGRAICMS.IDREGRAICMS FKDTRBREGRAICMS_DREGRAICMSR
CODIGO varchar 10 null
DESCRICAO varchar 255 √ null
TIPO varchar 2 null
GLOBAL smallint 2 √ null
CODFILIAL int 4 √ null
BASEICMSCOMIPI varchar 1 √ null
ALIQSUBST RMDVALOR4 17,4 √ null
ALIQICMS RMDVALOR4 17,4 √ null
FATORICMS RMDVALOR4 17,4 √ null
FATORSUBST RMDVALOR4 17,4 √ null
LANCAIPIEMOUTROSOUISENTOS varchar 1 √ null
VALORESCONDICIONAIS int 4 √ null
FATORREDST RMDVALOR4 17,4 √ null
COLOCARREDUCAOEM varchar 1 √ null
SITTRIBUTARIA varchar 5 √ null
ICMSDOBRO smallint 2 √ null
ICMSDENTRO smallint 2 √ null
ICMSINDEXADO smallint 2 √ null
ICMSMETADE smallint 2 √ null
TIPOICMSNCONTABIL smallint 2 √ null
ICMSSTANTECIPADO smallint 2 √ null
AFETABASEICMS int 4 √ null
ALIQUOTAFIXADIFERENCIAL smallint 2 √ null
REDNAFETACAMPOS smallint 2 √ null
AFETABASEICMSST int 4 √ null
LANCAREDPRODISENTOOUOUTROS smallint 2 √ null
TIPOOPERACAOTRIBUTARIA smallint 2 √ null
OPERACAOCOMPLEMENTAR smallint 2 √ null
SOMAICMSSTVLRCONTABIL smallint 2 √ null
RETENCAOICMSST smallint 2 √ null
CONTROLAFECHAMENTO int 4 √ null
SOMAICMSDENTROVLRCONT smallint 2 √ ((0))
UTILIZAMVAAJUSTADA smallint 2 √ ((0))
LANCADESPCONDICIONALEM int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CSOSN varchar 5 √ null
ICMSDESONERADO smallint 2 √ null
MOTDESICMS int 4 √ null
ICMSSTREDUCPROP smallint 2 √ null
PERICMSESTDESTINO RMDVALOR4 17,4 √ null
PERICMSFCP RMDVALOR4 17,4 √ null
UTIBCDIFALICMSDENTRO int 4 √ ((0))
UTIBCSTICMSDENTRO int 4 √ ((0))
DIFALUTIICMSPROPRIO int 4 √ ((0))
OPERACAOFCP smallint 2 ((0))
OPERACAOFCPST smallint 2 ((0))
APLICACAOFRM varchar 1 √ null
GFORMULA.APLICACAO FKDREGRAICMS_GFORMULAR
CODIGOFRM varchar 8 √ null
GFORMULA.CODIGO FKDREGRAICMS_GFORMULAR
ICMSDESONAOAFETAVALOROP smallint 2 √ null
ALIQREDICMSPROP RMDVALOR4 17,4 √ null
DIFALUTILIZAALIQINTERESTADUAL smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKDREGRAICMS Primary key Asc/Asc CODCOLIGADA + IDREGRAICMS
DXREGRAICMS Must be unique Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODIGO

Relationships

Close relationships within degrees of separation