transacaofiscal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtransacaofiscal int8 19 null
transacaofiscal_aud.idtransacaofiscal Implied Constraint R
descricao varchar 80 √ null
sgloperacao varchar 20 null
codigo varchar 10 √ null
idtiponotafiscal int8 19 √ null
tiponotafiscal.idtiponotafiscal fk_i0yuvwq3t6u02a02c6px2gfaf R
idtipopedido int8 19 √ null
tipopedido.idtipopedido fk_6a16342wjvfrnh7k7wcaml58i R
idcfop int8 19 √ null
cfop.idcfop fk_464ckyecjpmjq0vjaop2wksr6 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk515a9a36 Primary key Asc idtransacaofiscal
idx1ba81593 Performance Asc idtipopedido
idx6e48ade6 Performance Asc idcfop
idxa65afded Performance Asc idtiponotafiscal
idxwsversao_515a9a36 Performance Desc wsversao
uc5b473966 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation