cfop_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
descricao varchar 4000 null
descricaoclassifica varchar 4000 null
codigocomplemento varchar 20 null
codigoaliquotauf varchar 20 null
sglcondicionaicms varchar 10 null
observacao varchar 4000 null
idnativo int2 5 null
idnreceitafinanceira int2 5 null
idntributapis int2 5 null
idntributacofins int2 5 null
idnicms int2 5 null
idnnotafiscalretorno int2 5 null
codigoerp varchar 80 null
wsversao int8 19 null
idtipolancamento int8 19 null
tipolancamento.idtipolancamento Implied Constraint R
idtiponotafiscal int8 19 null
tiponotafiscal.idtiponotafiscal Implied Constraint R
idtipomaterialnotafiscal int8 19 null
tipomaterialnotafiscal.idtipomaterialnotafiscal Implied Constraint R
idtipopedido int8 19 null
tipopedido.idtipopedido Implied Constraint R
idcfop int8 19 null
cfop.idcfop Implied Constraint R
rev int8 19 null
revtype int8 19 null
codigo varchar 80 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk32455555 Primary key Asc id
idxwsversao_32455555 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.