-- Table: public.flx_aux_cheque_emitido

CREATE TABLE IF NOT EXISTS public.flx_aux_cheque_emitido
(
    terminal_ip character varying(50) NOT NULL, 
    banco integer NOT NULL,
    agencia character varying(10) COLLATE pg_catalog."default" NOT NULL,
    conta character varying(12) COLLATE pg_catalog."default" NOT NULL,
    numero_cheque character varying(14) COLLATE pg_catalog."default" NOT NULL,
    valor numeric(18,6) NOT NULL,
    data_emissao date NOT NULL,
    data_vencimento date NOT NULL,
    referencia_filial integer NOT NULL,
    referencia_fornecedor integer NOT NULL,
    situacao character varying(1) COLLATE pg_catalog."default" NOT NULL,
    escolhido character varying(1) COLLATE pg_catalog."default" NOT NULL,
    data_compensacao date NOT NULL,
    centro_custo integer NOT NULL,
    cheque_cada_nota character varying(1) COLLATE pg_catalog."default" NOT NULL,
    portador character varying(100) COLLATE pg_catalog."default" NOT NULL,
    impresso character varying(1) COLLATE pg_catalog."default" NOT NULL,
    proximo_cec integer NOT NULL,
    ja_foi_baixado character varying(1) COLLATE pg_catalog."default" NOT NULL,
    carta_cobranca character varying(1) COLLATE pg_catalog."default" NOT NULL,
    cheque_pendente character varying(1) COLLATE pg_catalog."default" NOT NULL,
    data_pagamento date NOT NULL,
    CONSTRAINT pk_flx_aux_cheque_emitido PRIMARY KEY (terminal_ip,banco, agencia, conta, numero_cheque)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.flx_aux_cheque_emitido
    OWNER to postgres;

COMMENT ON TABLE public.flx_aux_cheque_emitido
    IS 'Cadastro Auxiliar de cheques emitidos';