TPRDFISCAL

499 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
IDPRD int 4 null
TPRODUTO.IDPRD FKTPRDFISCAL_TPRDR
CAPACVOLUMETRICA RMDVALOR4 17,4 √ null
CODPRDRECFEDERAL varchar 15 √ null
SITUACAOMERCADORIA varchar 2 √ null
CODIGOSRF varchar 10 √ null
CLASSEENQUADRAMENTOIPI varchar 5 √ null
CODIGOANP varchar 10 √ null
CODIGOCODIF varchar 21 √ null
CODIGOSELOIPI varchar 20 √ null
TIPOMEDICAMENTO smallint 2 √ null
SITTRIBUTARIAPIS varchar 2 √ null
SITTRIBUTARIACOFINS varchar 2 √ null
TIPOTRIBUTACAO smallint 2 √ null
CNAEPRD varchar 20 √ null
CODIGOIRRF varchar 10 √ null
DEDUCAOIRRF RMDVALOR4 17,4 √ null
ISSDEVIDOMUNICIPIOCLIENTE smallint 2 √ null
PERCENTBASEINSS RMDVALOR4 17,4 √ null
PERCBASEINSSEMPREGADO RMDVALOR4 17,4 √ null
INCENTIVOFISCALMS varchar 1 √ null
CODAPURACAO varchar 2 √ null
INDESPECIAL varchar 2 √ null
CODAPURACAOE varchar 2 √ null
CODIGOSERVICOFEDERAL varchar 5 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
NATREC varchar 3 √ null
NATBCCRED varchar 2 √ null
ALIQTOTTRIB numeric 23,4 √ null
CODATIVECONOMIC varchar 8 √ null
MARGEMLUCROFISC RMDVALOR4 17,4 √ null
FATORREDUCAOICMS RMDVALOR4 17,4 √ null
INVENTARIOFISCAL int 4 √ null
CLASSEFISCALECF int 4 √ null
CODIGOCEST varchar 15 √ null
CODENQIPI varchar 3 √ null
CODCOLCONTA DCODCOLIGADA 2 √ null
CCONTA.CODCOLIGADA FKTPRDFISCAL_CCONTAR
CODCONTA DCODCONTA 40 √ null
CCONTA.CODCONTA FKTPRDFISCAL_CCONTAR
CLASSIFSERVICO int 4 √ null
DESCRICAOANP varchar 200 √ null
PRDREGSANITARIAS int 4 √ null
IDATIVECONOMICA int 4 √ null
DATIVIDADEECONOMICA.IDATIVECONOMICA FKTPRDFISCAL_DATIVIDADEECONOMIR
CODFISCALSCANC varchar 10 √ null
IDNATRENDIMENTO int 4 √ null
DNATUREZARENDIMENTO.IDNATRENDIMENTO FKTPRDFISCAL_DNATUREZARENDIMENR

Indexes

Constraint Name Type Sort Column(s)
PKTPRDFISCAL Primary key Asc/Asc CODCOLIGADA + IDPRD

Relationships

Close relationships within degrees of separation