TPRDCODFISCAL

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
IDPRD int 4 null
TPRODUTO.IDPRD FKTPRDCODFISCAL_TPRDR
CODETD varchar 2 null
GETD.CODETD FKTPRDCODFISCAL_GETDR
CODFISCAL varchar 15 √ null
ALIQINTICMS RMDVALOR4 17,4 √ null
PERCDIFERIMENTOPARCIALICMS RMDVALOR4 17,4 √ null
MODALIDADEBCICMS smallint 2 √ null
MODALIDADEBCICMSST smallint 2 √ null
PRECOSUGERIDO RMDVALOR4 17,4 √ null
TRIBUTADOICMSST smallint 2 √ null
DTINICIOICMSST DDATETIME 16,3 √ null
FATORSUBST RMDVALOR4 17,4 √ null
FATORREDUCAOICMS RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODTRIBUTACAO varchar 10 √ null
ALIQIBPTFEDERAL RMDVALOR4 17,4 ((0))
ALIQIBPTESTADUAL RMDVALOR4 17,4 ((0))
ALIQIBPTMUNICIPAL RMDVALOR4 17,4 ((0))
CHAVEIBPT varchar 20 √ null
CODIPM varchar 80 √ null
PERFECP RMDVALOR4 17,4 √ null
CSTPRD varchar 3 √ null
BENFISCALUF smallint 2 ((0))

Indexes

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

Relationships

Close relationships within degrees of separation