TTRBMOV

1930 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TMOV.CODCOLIGADA FKTTRBMOV_TMOVR
DTRIBUTO.CODCOLIGADA FKTTRBMOV_DTRIBUTOBASER
IDMOV int 4 null
TMOV.IDMOV FKTTRBMOV_TMOVR
NSEQITMMOV int 4 null
CODTRB varchar 10 null
DTRIBUTO.CODTRB FKTTRBMOV_DTRIBUTOR
BASEDECALCULO RMDVALOR4 17,4 √ null
ALIQUOTA RMDVALOR4 17,4 √ null
VALOR RMDVALOR4 17,4 √ null
FATORREDUCAO RMDVALOR4 17,4 √ null
FATORSUBSTTRIB RMDVALOR4 17,4 √ null
BASEDECALCULOCALCULADA RMDVALOR4 17,4 √ null
EDITADO smallint 2 √ null
VLRISENTO RMDVALOR4 17,4 √ null
CODRETENCAO varchar 10 √ null
TIPORECOLHIMENTO varchar 1 √ null
CODTRBBASE varchar 10 √ null
DTRIBUTO.CODTRB FKTTRBMOV_DTRIBUTOBASER
PERCDIFERIMENTOPARCIALICMS RMDVALOR4 17,4 √ null
SITTRIBUTARIA varchar 5 √ null
MODALIDADEBC smallint 2 √ null
ALIQUOTAPORVALOR RMDVALOR4 17,4 √ null
CODUNDREFERENCIA varchar 5 √ null
BASECHEIA RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCONTRIBSOCIAL varchar 2 √ null
TIPORENDIMENTO varchar 3 √ ('000')
FORMATRIBUTACAO varchar 2 √ ('00')
MOTDESICMS int 4 √ null
NATOPERNFSE varchar 20 √ null
CODENQIPI varchar 3 √ null
BASEICMSDIFALIQ RMDVALOR4 17,4 √ null
VALORICMSDESONERADO RMDVALOR4 17,4 √ null
VALORRETSUSPJUDIC RMDVALOR4 17,4 √ null
VALORRETSUBCONTRATACAO RMDVALOR2 17,2 √ null
BASEICMSDESONERADO RMDVALOR4 17,4 √ null
IDNATRENDIMENTO int 4 √ null
DNATUREZARENDIMENTO.IDNATRENDIMENTO FKTTRBMOV_DNATUREZARENDIMENTOR

Indexes

Constraint Name Type Sort Column(s)
PKTTRBMOV Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDMOV + NSEQITMMOV + CODTRB

Relationships

Close relationships within degrees of separation