TCUPOMFISCAL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCUPOMFISCALFIN.CODCOLIGADA FKTCUPOMFISCALFIN_TCUPOMFISCALR
TCUPOMFISCALITM.CODCOLIGADA FKTCUPOMFISCALITM_TCUPOMFISCALR
TFMOV.CODCOLIGADA FKTFMOV_TCUPOMFISCALR
TREDUCAOZ.CODCOLIGADA FKTCUPOMFISCAL_TREDUCAOZR
TPONTOVENDA.CODCOLIGADA FKTCUPOMFISCAL_TPONTOVENDAR
IDCUPOM int 4 null
TCUPOMFISCALFIN.IDCUPOM FKTCUPOMFISCALFIN_TCUPOMFISCALR
TCUPOMFISCALITM.IDCUPOM FKTCUPOMFISCALITM_TCUPOMFISCALR
TFMOV.IDCUPOM FKTFMOV_TCUPOMFISCALR
PONTOVENDA varchar 10 null
TPONTOVENDA.PONTOVENDA FKTCUPOMFISCAL_TPONTOVENDAR
CRO int 4 null
NUMERO int 4 null
COO int 4 √ null
DATAEMISSAO datetime 16,3 √ null
HORARIO datetime 16,3 √ null
CODCOLCFO smallint 2 √ null
FCFO.CODCOLIGADA FKTCUPOMFISCAL_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKTCUPOMFISCAL_FCFOR
VALORLIQUIDO RMDVALOR2 17,2 √ null
DESCONTO RMDVALOR2 17,2 √ null
ACRESCIMO RMDVALOR2 17,2 √ null
VALORRECEBIDO RMDVALOR2 17,2 √ null
CAIXA int 4 √ null
IDREDUCAOZ int 4 √ null
TREDUCAOZ.IDREDUCAOZ FKTCUPOMFISCAL_TREDUCAOZR
CANCELADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
STATUS varchar 1 √ null
CNPJCPFADQUIRENTE varchar 20 √ null
NOMEADQUIRENTE varchar 40 √ null
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)
PKTCUPOMFISCAL Primary key Asc/Asc CODCOLIGADA + IDCUPOM
TXTCUPOMFISCAL Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + PONTOVENDA + CRO + NUMERO

Relationships

Close relationships within degrees of separation