TCUPOMFISCALFIN

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TCUPOMFISCALFINRELAC.CODCOLIGADA FKTCUPFISFINRE_TCUPOMFISCALFINR
TCPG.CODCOLIGADA FKTCUPOMFISCALFIN_TCPGR
TCUPOMFISCAL.CODCOLIGADA FKTCUPOMFISCALFIN_TCUPOMFISCALR
TFORMAPAGTO.CODCOLIGADA FKTCUPOMFISCALFIN_TFORMAPAGTOR
IDCUPOM int 4 null
TCUPOMFISCALFINRELAC.IDCUPOM FKTCUPFISFINRE_TCUPOMFISCALFINR
TCUPOMFISCAL.IDCUPOM FKTCUPOMFISCALFIN_TCUPOMFISCALR
NUMEROPARCELA int 4 null
TCUPOMFISCALFINRELAC.NUMEROPARCELA FKTCUPFISFINRE_TCUPOMFISCALFINR
DEBITOCREDITO varchar 1 √ null
CODCPG varchar 5 √ null
TCPG.CODCPG FKTCUPOMFISCALFIN_TCPGR
VALOR RMDVALOR2 17,2 √ null
DATAVENCIMENTO datetime 16,3 √ null
IDFORMAPAGTO int 4 √ null
TFORMAPAGTO.IDFORMAPAGTO FKTCUPOMFISCALFIN_TFORMAPAGTOR
BANCO varchar 4 √ null
AGENCIA varchar 20 √ null
CC varchar 20 √ null
CHEQUE varchar 20 √ null
CODCOLCXA smallint 2 √ null
FCXA.CODCOLIGADA FKTCUPOMFISCALFIN_FCXAR
CODCXA varchar 10 √ null
FCXA.CODCXA FKTCUPOMFISCALFIN_FCXAR
CAMPOLIVRE varchar 10 √ null
NOMEEMITENTE varchar 30 √ null
TELEMITENTE varchar 15 √ 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)
PKTCUPOMFISCALFIN Primary key Asc/Asc/Asc CODCOLIGADA + IDCUPOM + NUMEROPARCELA

Check Constraints

Constraint Name Constraint
CK__TCUPOMFISCALFIN__1665E4F0 ([DEBITOCREDITO] = 'D' or [DEBITOCREDITO] = 'C')

Relationships

Close relationships within degrees of separation