T_MOVIMENTACAO_CONTA_TMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NR_MOVIMENTACAO DOUBLE PRECISION 15 null
CD_CONTA DOUBLE PRECISION 15 null
T_CONTAS.CD_CONTA Implied Constraint R
DT_MOVIMENTACAO TIMESTAMP 24 null
DS_HISTORICO VARCHAR 200 √ null
VL_MOVIMENTACAO DOUBLE PRECISION 15 null
ID_CONTABIL CHAR 1 √ null
ID_OPERACAO CHAR 1 √ null
ID_CONFERIDO CHAR 1 √ null
NR_CONTA_CREDIARIO DOUBLE PRECISION 15 √ null
T_CREDIARIO.NR_CONTA_CREDIARIO Implied Constraint R
NM_USUARIO VARCHAR 50 √ null
T_USUARIO.NM_USUARIO Implied Constraint R
NR_CUPOM DOUBLE PRECISION 15 √ null
NR_DOCUMENTO DOUBLE PRECISION 15 √ null
DT_LANCAMENTO TIMESTAMP 24 √ null
NR_CHEQUE DOUBLE PRECISION 15 √ null
NR_BANCO DOUBLE PRECISION 15 √ null
NR_AGENCIA DOUBLE PRECISION 15 √ null
NR_CONTA VARCHAR 10 √ null
NR_PARCELA DOUBLE PRECISION 15 √ null
CD_EMPRESA DOUBLE PRECISION 15 √ null
T_EMPRESA.CD_EMPRESA Implied Constraint R
ID_PROCESSADO CHAR 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_MOV_CON_TMP Primary key Asc NR_MOVIMENTACAO

Relationships

Close relationships within degrees of separation