localfilial


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalfilial int8 19 null
atendimento_aud.idlocalfilial Implied Constraint R
campanhabrinde_aud.idlocalfilial Implied Constraint R
campbrinderestricao_aud.idlocalfilial Implied Constraint R
cfopfilial_aud.idlocalfilial Implied Constraint R
cfoptipopedido_aud.idlocalfilial Implied Constraint R
colecaovinculo_aud.idlocalfilial Implied Constraint R
comissao_aud.idlocalfilial Implied Constraint R
condicaopagamento_aud.idlocalfilial Implied Constraint R
controlecota_aud.idlocalfilial Implied Constraint R
controleflex_aud.idlocalfilial Implied Constraint R
desconto_aud.idlocalfilial Implied Constraint R
estoque_aud.idlocalfilial Implied Constraint R
evento_aud.idlocalfilial Implied Constraint R
filialtransportadora_aud.idlocalfilial Implied Constraint R
financeirotitulo_aud.idlocalfilial Implied Constraint R
frete_aud.idlocalfilial Implied Constraint R
freteadicional_aud.idlocalfilial Implied Constraint R
impostoprodutouf_aud.idlocalfilial Implied Constraint R
lancamentovinculo_aud.idlocalfilial Implied Constraint R
limitecredito_aud.idlocalfilial Implied Constraint R
linhafilial_aud.idlocalfilial Implied Constraint R
localcondicaopagamento_aud.idlocalfilial Implied Constraint R
localentrega_aud.idlocalfilial Implied Constraint R
localfilial_aud.idlocalfilial Implied Constraint R
localregiao_aud.idlocalfilial Implied Constraint R
localtabelacomissao_aud.idlocalfilial Implied Constraint R
localtabelapreco_aud.idlocalfilial Implied Constraint R
localtabprecoareavenda_aud.idlocalfilial Implied Constraint R
localtipocobranca_aud.idlocalfilial Implied Constraint R
localtipodesconto_aud.idlocalfilial Implied Constraint R
localtipoestoque_aud.idlocalfilial Implied Constraint R
localtipofrete_aud.idlocalfilial Implied Constraint R
localtipologia_aud.idlocalfilial Implied Constraint R
localtipopedido_aud.idlocalfilial Implied Constraint R
localtransportador_aud.idlocalfilial Implied Constraint R
localveiculo.idlocalfilial fk_ph0rea272t0lloyiufkk91mmv R
localveiculo_aud.idlocalfilial Implied Constraint R
metafilial_aud.idlocalfilial Implied Constraint R
ofertalocalfilial_aud.idlocalfilial Implied Constraint R
ofertavinculo_aud.idlocalfilial Implied Constraint R
operacaogrupoprodutouf_aud.idlocalfilial Implied Constraint R
operacaolinha_aud.idlocalfilial Implied Constraint R
operacaolocal_aud.idlocalfilial Implied Constraint R
operacaomix_aud.idlocalfilial Implied Constraint R
operacaoprodutouf_aud.idlocalfilial Implied Constraint R
operacaotabelapreco_aud.idlocalfilial Implied Constraint R
operacaotipopedido_aud.idlocalfilial Implied Constraint R
operacaousuario_aud.idlocalfilial Implied Constraint R
ordemproducao_aud.idlocalfilial Implied Constraint R
parametrofilial_aud.idlocalfilial Implied Constraint R
parceirotransportador_aud.idlocalfilial Implied Constraint R
planejamentoagrupitem_aud.idlocalfilial Implied Constraint R
planejamentoitem_aud.idlocalfilial Implied Constraint R
planejamentoitemdelete_aud.idlocalfilial Implied Constraint R
planejamentoitemmetrica_aud.idlocalfilial Implied Constraint R
pontogps_aud.idlocalfilial Implied Constraint R
prazoentrega_aud.idlocalfilial Implied Constraint R
prodlancalocalfilial_aud.idlocalfilial Implied Constraint R
produtoareavenda_aud.idlocalfilial Implied Constraint R
produtocondicaopagto.idlocalfilial fk_qaad6namvpsrckohnjyny05pj R
produtocondicaopagto_aud.idlocalfilial Implied Constraint R
produtoconfigvenda_aud.idlocalfilial Implied Constraint R
produtoembalagem_aud.idlocalfilial Implied Constraint R
produtofilial_aud.idlocalfilial Implied Constraint R
produtosaldoretirar_aud.idlocalfilial Implied Constraint R
produtotipocobranca.idlocalfilial fk_o2k040ycptss86hu46muvt7iy R
produtotipocobranca_aud.idlocalfilial Implied Constraint R
produtotipopedido_aud.idlocalfilial Implied Constraint R
projetoagrareasemente_aud.idlocalfilial Implied Constraint R
romaneioentrega_aud.idlocalfilial Implied Constraint R
rotalocal_aud.idlocalfilial Implied Constraint R
tabelaprecoproduto_aud.idlocalfilial Implied Constraint R
tipoaprovacaoconfig_aud.idlocalfilial Implied Constraint R
tipoclassificacaopedido_aud.idlocalfilial Implied Constraint R
usuariofilial_aud.idlocalfilial Implied Constraint R
viagem_aud.idlocalfilial Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_n3q4546gcx7h05u5jc3a4pfab R
idfilial int8 19 √ null
local.idlocal fk_5lokif4a3ykh2c5d9vyhec2to R
idsegmento int8 19 √ null
segmento.idsegmento fk_o0kviig80ugnkde4ky1nse78j R
sgltipofilial varchar 10 √ null
distanciafilial numeric 18,6 √ null
itinerariofilial varchar 4000 √ null
idnpadrao int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idusuario int8 19 √ null
usuario.idusuario fk_ngw9eyyebcvbjk1axgj43pskb R

Indexes

Constraint Name Type Sort Column(s)
pka11498d6 Primary key Asc idlocalfilial
idx3a1a6fa7 Performance Asc idlocal
idx4475ffc1 Performance Asc idsegmento
idx8bb16329 Performance Asc idfilial
idxc3078601 Performance Asc idusuario
idxwsversao_a11498d6 Performance Desc wsversao
uce2f6a746 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation