TCUPOMFISCALITM

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DITEM.CODCOLIGADA FKDITEM_TCUPOMFISCALITMR
DITEMHISTORICO.CODCOLIGADA FKDITEMHISTORICO_TCUPOMFISCALIR
TCUPOMFISCALITMRELAC.CODCOLIGADA FKTCFISITMRELA_TCUPOMFISCALITMR
TTRIBUTACAOECF.CODCOLIGADA FKTCUPOMFISCITM_TTRIBUTACAOECFR
DCFOP.CODCOLIGADA FKTCUPOMFISCALITM_DCFOPR
TCUPOMFISCAL.CODCOLIGADA FKTCUPOMFISCALITM_TCUPOMFISCALR
IDCUPOM int 4 null
DITEM.IDCUPOM FKDITEM_TCUPOMFISCALITMR
DITEMHISTORICO.IDCUPOM FKDITEMHISTORICO_TCUPOMFISCALIR
TCUPOMFISCALITMRELAC.IDCUPOM FKTCFISITMRELA_TCUPOMFISCALITMR
TCUPOMFISCAL.IDCUPOM FKTCUPOMFISCALITM_TCUPOMFISCALR
NUMEROITEM int 4 null
DITEM.NSEQITMMOV FKDITEM_TCUPOMFISCALITMR
DITEMHISTORICO.NSEQITMMOV FKDITEMHISTORICO_TCUPOMFISCALIR
TCUPOMFISCALITMRELAC.NUMEROITEM FKTCFISITMRELA_TCUPOMFISCALITMR
IDPRD int 4 null
TPRODUTO.IDPRD FKTCUPOMFISCALITM_TPRDR
QUANTIDADE RMDVALOR3 17,3 √ null
PRECOUNITARIO RMDVALOR3 17,3 √ null
VALORBRUTO RMDVALOR2 17,2 √ null
DESCONTO RMDVALOR2 17,2 √ null
ACRESCIMO RMDVALOR2 17,2 √ null
RATEIODESCONTO RMDVALOR2 17,2 √ null
RATEIOACRESCIMO RMDVALOR2 17,2 √ null
VALORLIQUIDO RMDVALOR2 17,2 √ null
CANCELAMENTO RMDVALOR2 17,2 √ null
TRIBUTACAOECF varchar 10 √ null
TTRIBUTACAOECF.TRIBUTACAOECF FKTCUPOMFISCITM_TTRIBUTACAOECFR
IDNAT int 4 √ null
DCFOP.IDNAT FKTCUPOMFISCALITM_DCFOPR
ALIQUOTA RMDVALOR2 17,2 √ null
CST varchar 3 √ null
CANCELADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODUND varchar 5 √ null
TUND.CODUND FKTCUPOMFISCALITM_TUNDR
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)
PKTCUPOMFISCALITM Primary key Asc/Asc/Asc CODCOLIGADA + IDCUPOM + NUMEROITEM

Relationships

Close relationships within degrees of separation