CREATE TABLE public.com_aux_pro055
(
    terminal_ip character varying(15) COLLATE pg_catalog."default" NOT NULL,
    filial integer NOT NULL,
    familia integer NOT NULL,
    produto integer NOT NULL,
    dt_entrega date NOT NULL,
    qtde_pedida numeric(18,6) NOT NULL,
    preco_mercado numeric(18,6) NOT NULL,
    valor_total_pedido numeric(18,6) NOT NULL,
    qtde_entrada numeric(18,6) NOT NULL,
    preco_unitario_entrada numeric(18,6) NOT NULL,
    valor_total_entrada numeric(18,6) NOT NULL,
    qtde_saida numeric(18,6) NOT NULL,
    qtde_consumo numeric(18,6) NOT NULL,
    observacao character varying(200) COLLATE pg_catalog."default" NOT NULL,
    dt_entrega_final date NOT NULL,
    dt_consumo_inicial date NOT NULL,
    dt_consumo_final date NOT NULL,
    CONSTRAINT pk_com_aux_pro055 PRIMARY KEY (terminal_ip, filial, familia, produto, dt_entrega)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.com_aux_pro055
    OWNER to postgres;

COMMENT ON TABLE public.com_aux_pro055
    IS 'Auxiliar resumo conferencia de compras';