-- Table: public.rcb_aux_dup_rcb_filiais

 DROP TABLE public.rcb_aux_dup_rcb_filiais;

CREATE TABLE public.rcb_aux_dup_rcb_filiais
(
    terminal_ip character varying(50) NOT NULL,
    filial_dup integer NOT NULL,
    sequencia integer NOT NULL,
    filial_cli integer NOT NULL,
    cliente integer NOT NULL,
    data_emissao date NOT NULL,
    data_vencimento date NOT NULL,
    vlr_nota numeric(18,6) NOT NULL,
    vlr_duplicata numeric(18,6) NOT NULL,
    vlr_juros numeric(18,6) NOT NULL,
    vlr_desconto numeric(18,6) NOT NULL,
    vlr_ja_pago numeric(18,6) NOT NULL,
    vlr_restante numeric(18,6) NOT NULL,
    vlr_multa numeric(18,6) NOT NULL,
    vlr_outros_acrescimos numeric(18,6) NOT NULL,
    vlr_pis numeric(18,6) NOT NULL,
    vlr_cofins numeric(18,6) NOT NULL,
    vlr_irrf numeric(18,6) NOT NULL,
    vlr_csll numeric(18,6) NOT NULL,
    vlr_iss numeric(18,6) NOT NULL,
    vlr_liquido numeric(18,6) NOT NULL,
    tipo_pgto integer NOT NULL,
    tipo_duplicata integer NOT NULL,
    imp_boleto character varying(1) NOT NULL,
    boleto_ja_imp character varying(1) NOT NULL,
    nr_tit_banco character varying(25) NOT NULL,
    fatura_ja_imp character varying(1) NOT NULL,
    banco integer NOT NULL,
    banco_recebido integer NOT NULL,
    observacao character varying(2000) NOT NULL,
    centro_custo integer NOT NULL,
    situacao character varying(1)  NOT NULL,
    paga_cartorio character varying(1) NOT NULL,
    linha_digitavel character varying(60) NOT NULL,
    nosso_numero character varying(20) NOT NULL,
    vlr_multa_empresa numeric(18,6) NOT NULL,
    endereco_entrega integer NOT NULL,
    endereco_cobranca integer NOT NULL,
    duplicata_doc integer NOT NULL,
    parcela integer NOT NULL,
    origem integer NOT NULL,
    cod_moeda integer NOT NULL,
    vlr_duplicata_moeda numeric(18,6) NOT NULL,
    vlr_inss numeric(18,6) NOT NULL,
    agencia character varying(10) NOT NULL,
    conta character varying(15) NOT NULL,
    cliente_razao_social character varying(100) NOT NULL,
    cliente_nome_fantasia character varying(100) NOT NULL,
    cliente_tipo_cliente integer NOT NULL,
    cliente_situacao character varying(1) NOT NULL,
    tipo_documento character varying(10) NOT NULL,
    imprime_boleto character varying(1) NOT NULL,
    data_pagamento date NOT NULL,
	
    CONSTRAINT pk_rcb_aux_dup_rcb_filiais PRIMARY KEY (terminal_ip, filial_dup, sequencia))

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.rcb_aux_dup_rcb_filiais
    OWNER to postgres;

COMMENT ON TABLE public.rcb_aux_dup_rcb_filiais
    IS 'Auxiliar Contas Receber - Filiais';