ALTER TABLE pag_duplicata_pagar_complemento
ADD COLUMN competencia integer NOT NULL DEFAULT 0,
ADD COLUMN vlr_outras_entidades numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN vlr_atualiza_monetaria numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN vlr_arrecadado numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN data_arrecadacao date NOT NULL DEFAULT CURRENT_DATE,
ADD COLUMN referencia numeric(20,0) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN perc_receita_bruta numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN divida_ativa numeric(13,0) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN referencia_anomes integer NOT NULL DEFAULT 0,
ADD COLUMN parcela_notificacao numeric(13,0) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN exercicio integer NOT NULL DEFAULT 0,
ADD COLUMN renavam integer NOT NULL DEFAULT 0,
ADD COLUMN uf_renavam character varying(2) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
ADD COLUMN placa character varying(7) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
ADD COLUMN opcao_pgto character varying(1) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
ADD COLUMN vlr_ipva numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN lacre_conectividade_social integer NOT NULL DEFAULT 0,
ADD COLUMN digito_lacre integer NOT NULL DEFAULT 0,
ADD COLUMN vlr_principal_darf numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN tipo_tributo integer NOT NULL DEFAULT 0,
ADD COLUMN codigo_pagamento_gps integer NOT NULL DEFAULT 0,
ADD COLUMN periodo_apuracao date NOT NULL DEFAULT CURRENT_DATE,
ADD COLUMN vlr_receita_bruta numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN vlr_desconto_ipva numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN renavam_12 numeric(12,0) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN identificador_fgts numeric(16,0) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN cod_municipio_renavam integer NOT NULL DEFAULT 0,
ADD COLUMN cod_receita integer NOT NULL DEFAULT 0,
ADD COLUMN vlr_multa_impostos numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN vlr_juros_impostos numeric(18,6) NOT NULL DEFAULT '0'::numeric,
ADD COLUMN finalidade_detalhe character varying(20) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
ADD COLUMN finalidade_ted character varying(5) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying;