financeirotitmovimento_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
sgltipomovimento varchar 10 null
datamovimento date 13 null
valor numeric 19,2 null
codigoerp varchar 80 null
wsversao int8 19 null
idfinanceirotitulo int8 19 null
financeirotitulo.idfinanceirotitulo Implied Constraint R
idfinanceirotitmovimento int8 19 null
financeirotitmovimento.idfinanceirotitmovimento Implied Constraint R
rev int8 19 null
revtype int8 19 null
datacreditomovimento date 13 null
datapagamento date 13 null
datavencimento date 13 null
portador varchar 255 null
valorantecipado numeric 19,2 null
valordesconto numeric 19,2 null
valorliquido numeric 19,2 null
valormulta numeric 19,2 null
valorjuros numeric 19,2 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkce1fb01a Primary key Asc id
idxwsversao_ce1fb01a Performance Desc wsversao

Graphviz Needed!

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.