CREATE TABLE IF NOT EXISTS public.flx_aux_relatorio_faturamento
(
	terminal_ip character varying(50) NOT NULL,
	sequencia integer NOT NULL,
    tipo character varying(50) NOT NULL,
	centro_custo integer NOT NULL,
	descricao character varying(50) NOT NULL,
	filial integer NOT NULL,
	orcamento integer NOT NULL,
	cliente integer NOT NULL,
	fornecedor integer NOT NULL,
	filial_duplicata integer NOT NULL,
	duplicata_rcb integer NOT NULL,
	parcela_duplicata_rcb integer NOT NULL,
	fil_dup_pagar integer NOT NULL,
	duplicata_pagar bigint NOT NULL,
	data_pagamento date NOT NULL,
	data_credito date NOT NULL,
	vlr_tot_liquido numeric(18, 6) NOT NULL,
    CONSTRAINT pk_flx_aux_relatorio_faturamento PRIMARY KEY (terminal_ip, sequencia)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.flx_aux_relatorio_faturamento
    OWNER to postgres;

COMMENT ON TABLE public.flx_aux_relatorio_faturamento
    IS 'Tabela auxiliar relatorio faturamento';