CREATE TABLE IF NOT EXISTS public.pag_aux_duplicata_pagar_desconto
(
    filial_dup_pag integer NOT NULL,
    terminal_ip character varying(50) COLLATE pg_catalog."default" NOT NULL,
    sequencia_dup integer NOT NULL,
    sequencia integer NOT NULL,
    vlr_desconto numeric(18,6) NOT NULL,
    observacao character varying NOT NULL,
    CONSTRAINT pk_pag_aux_duplicata_pagar_desconto PRIMARY KEY (filial_dup_pag, terminal_ip, sequencia_dup, sequencia),
    
	CONSTRAINT fk_pag_aux_duplicata_pagar_desconto_dup FOREIGN KEY (filial_dup_pag, terminal_ip, sequencia_dup)
        REFERENCES public.pag_aux_duplicata_pagar (filial_dup_pag, terminal_ip, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT	
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.pag_aux_duplicata_pagar_desconto
    OWNER to postgres;

COMMENT ON TABLE public.pag_aux_duplicata_pagar_desconto
    IS 'Auxiliar dos descontos da duplicata a pagar';


-- Table: public.pag_duplicata_pagar

-- DROP TABLE IF EXISTS public.pag_duplicata_pagar;

CREATE TABLE IF NOT EXISTS public.pag_duplicata_pagar_desconto
(
    filial_dup_pag integer NOT NULL,
    sequencia_dup integer NOT NULL,
    sequencia integer NOT NULL,
	vlr_desconto numeric(18,6) NOT NULL,
    observacao character varying NOT NULL,
	
    CONSTRAINT pk_pag_duplicata_pagar_desconto PRIMARY KEY (filial_dup_pag, sequencia_dup, sequencia),
    CONSTRAINT fk_pag_duplicata_pagar_desconto_duplicata FOREIGN KEY (filial_dup_pag, sequencia_dup)
        REFERENCES public.pag_duplicata_pagar (filial_dup_pag, sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.pag_duplicata_pagar_desconto
    OWNER to postgres;

COMMENT ON TABLE public.pag_duplicata_pagar_desconto
     IS 'Cadastro dos descontos da duplicata a pagar';




CREATE TABLE IF NOT EXISTS public.pag_recibo_baixa_duplicata_desconto
(
    recibo integer NOT NULL,
    filial_dup integer NOT NULL,
    sequencia_duplicata integer NOT NULL,
	sequencia_desconto integer NOT NULL,
	
    vlr_desconto numeric(18,6) NOT NULL,
    observacao character varying NOT NULL,

    CONSTRAINT pk_pag_recibo_baixa_duplicata_desconto PRIMARY KEY (recibo, filial_dup, sequencia_duplicata, sequencia_desconto),
    CONSTRAINT fk_pag_recibo_baixa_duplicata_desconto FOREIGN KEY (recibo)
        REFERENCES public.pag_recibo_baixa (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.pag_recibo_baixa_duplicata_desconto
    OWNER to postgres;

COMMENT ON TABLE public.pag_recibo_baixa_duplicata_desconto
    IS 'Tabela para o Recibo com os Descontos das duplicatas da baixa da duplicata a pagar';
	
	
	
	
INSERT INTO pag_duplicata_pagar_desconto(filial_dup_pag, sequencia_dup, sequencia, vlr_desconto, observacao)
SELECT filial_dup_pag,
	    sequencia,
		1,
		vlr_desconto,
		''
  FROM pag_duplicata_pagar
 WHERE vlr_desconto > 0
   AND (filial_dup_pag, sequencia) NOT IN(SELECT filial_dup_pag, sequencia_dup
   										     FROM pag_duplicata_pagar_desconto
											WHERE filial_dup_pag = pag_duplicata_pagar.filial_dup_pag
											  AND sequencia_dup = pag_duplicata_pagar.sequencia);