CREATE TABLE IF NOT EXISTS public.pag_aux_duplicata_pagar_imposto_adicional
(
    filial_dup_pag integer NOT NULL,
    terminal_ip character varying(50) NOT NULL,
    sequencia integer NOT NULL,
	duplicata bigint NOT NULL,
    serie_duplicata character varying(6) NOT NULL,
    nr_nota integer NOT NULL,
    serie_nota character varying(6) NOT NULL,
    filial_for integer NOT NULL,
    fornecedor integer NOT NULL,
    parcela integer NOT NULL,
    data_emissao date NOT NULL,
    data_vencimento date NOT NULL,
    situacao character varying(1) NOT NULL,
    vlr_duplicata numeric(18,6) NOT NULL,
    vlr_juros numeric(18,6) NOT NULL,
    vlr_desconto numeric(18,6) NOT NULL,
    vlr_devolucao numeric(18,6) NOT NULL,
    vlr_irrf numeric(18,6) NOT NULL,
    vlr_inss numeric(18,6) NOT NULL,
    vlr_liquido numeric(18,6) NOT NULL,
    vlr_pago numeric(18,6) NOT NULL,
    vlr_restante numeric(18,6) NOT NULL,
    tipo_pgto integer NOT NULL,
    centro_custo integer NOT NULL,
    observacao character varying(500) NOT NULL,
    tipo_duplicata integer NOT NULL,
    banco_portador integer NOT NULL,
    baixar_dup_sn character varying(1) NOT NULL,
    boleto_ja_entregue character varying(1) NOT NULL,
    cod_moeda integer NOT NULL,
    vlr_duplicata_moeda numeric(18,6) NOT NULL,
    vlr_pis numeric(18,6) NOT NULL,
    vlr_cofins numeric(18,6) NOT NULL,
    vlr_csll numeric(18,6) NOT NULL,
    vlr_iss numeric(18,6) NOT NULL,
    emite_cheque character varying(1) NOT NULL,
    emitido_cheque character varying(1) NOT NULL,
    agencia character varying(15) NOT NULL,
    conta character varying(15) NOT NULL,
    nosso_numero character varying(15) NOT NULL,
    codigo_barras character varying(50) NOT NULL,
    operacao_duplicata integer NOT NULL,
    vlr_multa numeric(18,6) NOT NULL,
	
    novo_fornecedor integer NOT NULL,

	
    CONSTRAINT pk_pag_aux_duplicata_pagar_imposto_adicional PRIMARY KEY (filial_dup_pag, terminal_ip, sequencia),
    CONSTRAINT fk_pag_aux_duplicata_pagar_imposto_adicional_fornec FOREIGN KEY (filial_for, fornecedor)
        REFERENCES public.for_fornecedor (filial, codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT,
	CONSTRAINT fk_pag_aux_duplicata_pagar_imposto_adicional_novo_fornec FOREIGN KEY (filial_for, novo_fornecedor)
        REFERENCES public.for_fornecedor (filial, codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT,
		
    CONSTRAINT fk_pag_aux_duplicata_pagar_imposto_adicional_oper FOREIGN KEY (operacao_duplicata)
        REFERENCES public.pag_tipo_operacao (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.pag_aux_duplicata_pagar_imposto_adicional
    OWNER to postgres;

COMMENT ON TABLE public.pag_aux_duplicata_pagar_imposto_adicional
    IS 'Cadastro de duplicatas a pagar Imposto Adicional';