T_COBRANCA_RASTREIO


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID_TRANSACAO DOUBLE PRECISION 15 null
CD_EMPRESA DOUBLE PRECISION 15 null
T_EMPRESA.CD_EMPRESA Implied Constraint R
NR_ORCAMENTO DOUBLE PRECISION 15 √ null
T_ORCAMENTO.NR_ORCAMENTO Implied Constraint R
NR_CUPOM DOUBLE PRECISION 15 √ null
DT_LANCAMENTO TIMESTAMP 24 null
CD_CLIENTE DOUBLE PRECISION 15 √ null
ID_SITUACAO CHAR 1 null
ID_PAGAMENTO CHAR 1 √ null
DT_PAGAMENTO TIMESTAMP 24 √ null
DT_CANCELAMENTO TIMESTAMP 24 √ null
DT_PROMETIDA TIMESTAMP 24 √ null
DS_CANCELAMENTO VARCHAR 600 √ null
CD_COBRANCA DOUBLE PRECISION 15 √ null
T_COBRANCA_ONLINE.CD_COBRANCA FK_COB_RAST R

Indexes

Constraint Name Type Sort Column(s)
PK_COB_RAS Primary key Asc ID_TRANSACAO
FK_COB_RAST Performance Asc CD_COBRANCA

Relationships

Close relationships within degrees of separation