TNFE

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TMOV.CODCOLIGADA FKTNFE_TMOVR
IDMOV int 4 null
TMOV.IDMOV FKTNFE_TMOVR
CODIGOSERVICO varchar 40 √ null
VALORSERVICO RMDVALOR4 17,4 √ null
DEDUCAOSERVICO RMDVALOR4 17,4 √ null
ALIQUOTAISS RMDVALOR4 17,4 √ null
ISSRETIDO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NUMERONFE varchar 8 √ null
CODIGOVERIFICACAONFE varchar 8 √ null
DATAEMISSAO datetime 16,3 √ null
HORAEMISSAO datetime 16,3 √ null
DATACANCELAMENTO datetime 16,3 √ null
NUMEROGUIA varchar 12 √ null
DATAQUITACAOGUIA datetime 16,3 √ null
VALORISS RMDVALOR4 17,4 √ null
VALORCREDITOIPTU RMDVALOR4 17,4 √ null
DISCRIMINACAO MEMO 2147483647 √ null
BASEDECALCULO RMDVALOR4 17,4 √ null
EDITADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTNFE Primary key Asc/Asc CODCOLIGADA + IDMOV

Relationships

Close relationships within degrees of separation