-- DROP SEQUENCE public.seq_log_vnd_orcamento; CREATE SEQUENCE public.seq_log_vnd_orcamento INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9999999999 CACHE 1; ALTER SEQUENCE public.seq_log_vnd_orcamento OWNER TO postgres; COMMENT ON SEQUENCE public.seq_log_vnd_orcamento IS 'Sequence do log de pedidos'; -- DROP TABLE public.log_vnd_orcamento; CREATE TABLE public.log_vnd_orcamento ( log_sequencia integer NOT NULL, log_terminal_ip character varying(15) NOT NULL, log_usuario integer NOT NULL, log_formulario character varying(100) NOT NULL, log_data date NOT NULL, log_hora time without time zone NOT NULL, log_observacao character varying(200) NOT NULL, log_tipo_operacao integer NOT NULL, ant_filial_orc integer NOT NULL, ant_orcamento integer NOT NULL, ant_data_emissao date NOT NULL, ant_hora_emissao time without time zone NOT NULL, ant_data_passou_cx date NOT NULL, ant_filial_usu integer NOT NULL, ant_usuario integer NOT NULL, ant_filial_cli integer NOT NULL, ant_cliente integer NOT NULL, ant_filial_ven integer NOT NULL, ant_vendedor integer NOT NULL, ant_filial_nota integer NOT NULL, ant_nota integer NOT NULL, ant_serie character varying(6) NOT NULL, ant_nr_seq_duplicata integer NOT NULL, ant_nr_troca integer NOT NULL, ant_nr_abertura integer NOT NULL, ant_nr_caixa integer NOT NULL, ant_nr_ordem_serv integer NOT NULL, ant_situacao character varying(1) NOT NULL, ant_tipo character varying(1) NOT NULL, ant_reimpresso character varying(1) NOT NULL, ant_gerou_nf_caixa character varying(1) NOT NULL, ant_venda_sn character varying(1) NOT NULL, ant_revenda_cons character varying(1) NOT NULL, ant_baixou_stq character varying(1) NOT NULL, ant_liberado character varying(1) NOT NULL, ant_email_sn character varying(1) NOT NULL, ant_filial_tra integer NOT NULL, ant_transportador integer NOT NULL, ant_nr_embal_caixa integer NOT NULL, ant_vlr_total_liquido numeric(18,6) NOT NULL, ant_vlr_total_bruto numeric(18,6) NOT NULL, ant_perc_desconto numeric(10,6) NOT NULL, ant_vlr_desconto numeric(18,6) NOT NULL, ant_vlr_servico numeric(18,6) NOT NULL, ant_vlr_frete numeric(18,6) NOT NULL, ant_perc_rentabilidade numeric(10,6) NOT NULL, ant_carga character varying(1) NOT NULL, ant_observacao character varying(100) NOT NULL, ant_nat_oper1 numeric(4,0) NOT NULL, ant_nat_oper2 numeric(4,0) NOT NULL, ant_tipo_nf character varying(1) NOT NULL, ant_ac_nome_dest character varying(30) NOT NULL, ant_endereco_entrega integer NOT NULL, ant_endereco_cobranca integer NOT NULL, ant_duplicata_doc integer NOT NULL, ant_aut_compra integer NOT NULL, ant_vlr_total_juros numeric(18,6) NOT NULL, ant_vlr_pago numeric(18,6) NOT NULL, ant_especie character varying(10) NOT NULL, ant_qtd_volumes numeric(18,6) NOT NULL, ant_data_previsao_entrega date NOT NULL, ant_vlr_seguro numeric(18,6) NOT NULL, ant_vlr_desp_aces numeric(18,6) NOT NULL, ant_peso_liquido numeric(18,6) NOT NULL, ant_peso_bruto numeric(18,6) NOT NULL, ant_frete_conta character varying(1) NOT NULL, ant_liberado_separacao character varying(1) NOT NULL, atu_filial_orc integer NOT NULL, atu_orcamento integer NOT NULL, atu_data_emissao date NOT NULL, atu_hora_emissao time without time zone NOT NULL, atu_data_passou_cx date NOT NULL, atu_filial_usu integer NOT NULL, atu_usuario integer NOT NULL, atu_filial_cli integer NOT NULL, atu_cliente integer NOT NULL, atu_filial_ven integer NOT NULL, atu_vendedor integer NOT NULL, atu_filial_nota integer NOT NULL, atu_nota integer NOT NULL, atu_serie character varying(6) NOT NULL, atu_nr_seq_duplicata integer NOT NULL, atu_nr_troca integer NOT NULL, atu_nr_abertura integer NOT NULL, atu_nr_caixa integer NOT NULL, atu_nr_ordem_serv integer NOT NULL, atu_situacao character varying(1) NOT NULL, atu_tipo character varying(1) NOT NULL, atu_reimpresso character varying(1) NOT NULL, atu_gerou_nf_caixa character varying(1) NOT NULL, atu_venda_sn character varying(1) NOT NULL, atu_revenda_cons character varying(1) NOT NULL, atu_baixou_stq character varying(1) NOT NULL, atu_liberado character varying(1) NOT NULL, atu_email_sn character varying(1) NOT NULL, atu_filial_tra integer NOT NULL, atu_transportador integer NOT NULL, atu_nr_embal_caixa integer NOT NULL, atu_vlr_total_liquido numeric(18,6) NOT NULL, atu_vlr_total_bruto numeric(18,6) NOT NULL, atu_perc_desconto numeric(10,6) NOT NULL, atu_vlr_desconto numeric(18,6) NOT NULL, atu_vlr_servico numeric(18,6) NOT NULL, atu_vlr_frete numeric(18,6) NOT NULL, atu_perc_rentabilidade numeric(10,6) NOT NULL, atu_carga character varying(1) NOT NULL, atu_observacao character varying(100) NOT NULL, atu_nat_oper1 numeric(4,0) NOT NULL, atu_nat_oper2 numeric(4,0) NOT NULL, atu_tipo_nf character varying(1) NOT NULL, atu_ac_nome_dest character varying(30) NOT NULL, atu_endereco_entrega integer NOT NULL, atu_endereco_cobranca integer NOT NULL, atu_duplicata_doc integer NOT NULL, atu_aut_compra integer NOT NULL, atu_vlr_total_juros numeric(18,6) NOT NULL, atu_vlr_pago numeric(18,6) NOT NULL, atu_especie character varying(10) NOT NULL, atu_qtd_volumes numeric(18,6) NOT NULL, atu_data_previsao_entrega date NOT NULL, atu_vlr_seguro numeric(18,6) NOT NULL, atu_vlr_desp_aces numeric(18,6) NOT NULL, atu_peso_liquido numeric(18,6) NOT NULL, atu_peso_bruto numeric(18,6) NOT NULL, atu_frete_conta character varying(1) NOT NULL, atu_liberado_separacao character varying(1) NOT NULL, CONSTRAINT pk_log_vnd_orcamento PRIMARY KEY (log_sequencia) ) WITH ( OIDS = FALSE ) TABLESPACE pg_default; ALTER TABLE public.log_vnd_orcamento OWNER to postgres; COMMENT ON TABLE public.log_vnd_orcamento IS 'Tabela de log de pedidos'; INSERT INTO log_tipo_operacao (codigo, descricao) VALUES (33, 'Alteracao de pedido / orcamento');