update conf set confrelease = '13200'; ------------------------------------------------------------------------------------------------ alter table cte add ctetiposerv integer; ------------------------------------------------------------------------------------------------ -- DROP FUNCTION public.f_calc_clilimdisp(int4, int4); CREATE OR REPLACE FUNCTION public.f_calc_clilimdisp(integer, integer) RETURNS numeric LANGUAGE plpgsql AS $function$declare /* select * from f_calc_clilimdisp(1,1199) Descricao: Funcao criada para calcular limite disponível do cliente 01/02/08 - KAYTON: Criacao da funcao f_calc_clilimdisp 18/11/16 - KAYTON: Tratamento da regra cartão. Não consumir limite de crédito quando venda cartão. 22/02/17 - KAYTON: coalesce(tctipo,'') 29/03/17 - KAYTON: Ajustando critérios para PV, CPRPG, DOC considerando tipo DINHEIRO, CREDITO E DEBITO, bem como retirando da condição o parâmetro empresa 17/08/17 - DAVID: Correção do Limite para pvsit <> 'DIGITANDO' 13/05/20 - DAVID: adicionar regra para não considerar titulos com docavalistaparcod preenchidos. 31/05/24 - David: Tratar para utilizar apenas contas a receber */ disp numeric(14,4);lim numeric(14,4); totalpv numeric(14,4); totaldoc numeric(14,4); totalcpr numeric(14,4); i_empresa integer; i_cliente integer; begin i_empresa=$1; i_cliente=$2; disp := 00; lim := 00; totalpv := 00; totalcpr := 00; totaldoc := 00; select coalesce(clilim,0) into lim from cli where cliparcod=i_cliente; if lim is null then lim := 00; end if; --select coalesce(sum(pvvltotalate),0) into totalpv from pv join opnf on pvopnfcod=opnfcod where opnftopnfcod='VE' and pvsta in ('AA','MP','MT','FN') and pvcliparcod=i_cliente and pvempparcod=i_empresa; select coalesce(sum(pvvltotalate),0) into totalpv from pv join opnf on pvopnfcod=opnfcod join tc on tccod=pvtccod where opnftopnfcod in ('VE','VI','VV') and pvsta not in ('EX','FT','AP') and pvsit = 'APROVADO' and coalesce(tctipo,'') not in ('DINHEIRO','CARTAO_DEBITO','CARTAO_CREDITO') and pvcliparcod=i_cliente; if totalpv is null then totalpv := 00; end if; --select coalesce(sum(cprpgv),0) into totalcpr from cprpg join cpr on cprpgcprcod=cprcod join cli on cprparcod=cliparcod where cprpgsta in ('A') and cprparcod=i_cliente and cprtipo in ('CRC','CRO'); select coalesce(sum(cprpgv),0) into totalcpr from cprpg join cpr on cprpgcprcod=cprcod and cprpgcprempparcod=cprempparcod join cli on cprparcod=cliparcod join tc on tccod=cprpgtccod where cprpgsta in ('A') and cprtipo in ('CRC','CRO') and coalesce(tctipo,'') not in ('DINHEIRO','CARTAO_DEBITO','CARTAO_CREDITO') and cprparcod=i_cliente; if totalcpr is null then totalcpr := 00; end if; --select coalesce(sum(docv),0) into totaldoc from doc left join tc on doctccod=tccod where coalesce(tctipo,'') not in ('CARTAO_DEBITO','CARTAO_CREDITO') and docsta not in ('BA','RN','EX') and docdevparcod=i_cliente; select coalesce(sum(docv),0) into totaldoc from doc left join tc on doctccod=tccod where coalesce(tctipo,'') not in ('DINHEIRO','CARTAO_DEBITO','CARTAO_CREDITO') and coalesce(docavalistaparcod,0) = 0 and docsta not in ('BA','RN','EX') and doctipo in ('CRC','CRO') and docdevparcod=i_cliente; if totaldoc is null then totaldoc := 00; end if; disp := lim - coalesce(totalpv,0) - coalesce(totalcpr,0) - coalesce(totaldoc,0); return disp; end;$function$ ; -- Permissions ALTER FUNCTION public.f_calc_clilimdisp(int4, int4) OWNER TO postgres; GRANT ALL ON FUNCTION public.f_calc_clilimdisp(int4, int4) TO public; GRANT ALL ON FUNCTION public.f_calc_clilimdisp(int4, int4) TO postgres; ------------------------------------------------------------------------------------------------ alter table boleto alter column bolclientsecret type bpchar; ------------------------------------------------------------------------------------------------ -- DROP FUNCTION public.f_processar_cupom(int4, int4, int4); CREATE OR REPLACE FUNCTION public.f_processar_cupom(integer, integer, integer) RETURNS TABLE(frfatpvcod integer, frfatnfcod integer, frfatnfnum integer, frfatnfserie text, frfatmens text) LANGUAGE plpgsql AS $function$ DECLARE -- select * from f_processar_cupom(845,1,2) --select * from cprpg where cprpgcod = 894 -- select f_realizar_faturamento_pdv(100,1,pvcod) from pv where pvsta='AA' limit 200 offset 0 --select * from pdv.cupom --select * from pvi where pvipvcod=5021 --update pv set pvcliparcod=1,pvplpgcod=1,pvtccod=1 where pvcod=5021 -- select * from pv where pvcod=5021 /* -- FUNCAO FATURAMENTO PDV THUNDER 21/02/14 - KAYTON: Criação da função f_faturar 25/04/14 - KAYTON: Gravar nfiseq 01/03/16 - KAYTON: Utilizar campo pvcupnum no lugar de pvcupomecf 17/04/16 - KAYTON: Adaptação pra processamento de varios pedidos simultaneos 15/09/17 - DAVID: Adaptação para NFCe. 18/09/17 - DAVID: Adicionar Efetivação. 06/10/17 - KAYTON: Adicionar campos 14/10/17 - DAVID: Correção de CPRPGCOD de parcpagcod para parccod 16/10/17 - DAVID: Correção de CPRPG join pdvcod 10/11/17 - DAVID: Correção do nfpvcod para null 10/01/18 - DAVID: Correção do CX, estava setado como 1 04/09/18 - DAVID: tratar rca digitado na tela, case ele não esteja correto usar o operador 28/05/19 - David: não preencher o campo nfe_arquivo_xml 28/05/19 - David: importar o cupsefazsituacao 24/06/19 - David: importar o cupsefazinfprotdigval 22/08/19 - David: tratar situação 'NAO ENVIADO' para 'NAO_ENVIADO' 04/10/19 - David: usar cupsefazhorario caso o cupom esteja enviado no lugar da data de emissão 04/12/19 - David: Corrigir CST de Pis/Cofins 13/07/22 - David: Adicionar variavel do PDV no no TC e PLPG 26/09/22 - David: Correção do arqremessa 16/03/24 - David: corrigir cxmvtipo de R para C 13/05/24 - David: tratar para que a cob vale seja processada como CRV */ p_cupom ALIAS FOR $1;--integer p_loja ALIAS FOR $2;--integer p_pdv ALIAS FOR $3;--integer rec_cupom RECORD; rec_item RECORD; rec_plpg RECORD; rec_seqnf RECORD; rec_mens RECORD; rec_pag RECORD; rec_insert_estmv RECORD; rec_pv_insert_estmv RECORD; rec_pv_usacontrolelote RECORD; v_erro INTEGER; num_parc integer; v_nfcod INTEGER; v_res INTEGER; v_cprcod INTEGER; v_doccod INTEGER; v_cxmvcod INTEGER; v_agora TIMESTAMP; v_cupom INTEGER; v_pdv TEXT; p_dtemissao TIMESTAMP; p_horariosaida TIMESTAMP; v_pedido INTEGER; v_visento NUMERIC(14,4); v_vbasecalc NUMERIC(14,4); v_vicms NUMERIC(14,4); v_voutros NUMERIC(14,4); v_vipi NUMERIC(14,4); v_vbasecalcST NUMERIC(14,4); v_vlicmsST NUMERIC(14,4); v_confobsnf TEXT; v_obsnf TEXT; v_nfidet RECORD; v_docTipo text; BEGIN --******* -- OBTER DATA HORA HOJE --******* select now() into v_agora; p_dtemissao:=v_agora; p_horariosaida:=v_agora; --******* -- OBTER DADOS NF/NFI --******* FOR rec_cupom IN select cupoperadcod,--nfcadusuparcod cupinihorario,--nfcadhorario cuplojacod,--nfempparcod, case when cupclicod is null or cupclicod=0 then (select pdvclipadrao from pdv.pdv where pdvcod=cuppdvcod) else cupclicod end as clicod, -- 4695 é o consumidor final cuppdvcod, cupnum, cupserie, 'FT',--nfsta cast(cupfimhorario as date) as dtemi,--nfdtemi cast(coalesce(cupsefazhorario,cupfimhorario) as date) as dtsai,--nfdtsai cast(cupfimhorario as time) as hrsai,--nfhrsai cupfimhorario, cupopnfcod as nfopnfcod, opnf_conta_id, opnf_cc_id, (select opnfesp from opnf where opnfcod=cupopnfcod) as opnfesp,--nfopnfesp character(4) case when (select opnfsta from opnf where opnfcod=cupopnfcod) in ('GC','C') then 'P' else 'T' end as p_form,--nf_p_form character(1) DEFAULT 'N'::bpchar, cast('65' as varchar) as modelo,--nfmodelo cuppago,--nfvl update - Recebe 0 provisoriamente ate gravar nfi cuppago as cuppagopro,--nfvlpro update - Recebe 0 provisoriamente ate gravar nfi cast('C' as varchar) as tipofrete,--nftipofrete cast('' as varchar) as obs, cupcod,--nfpvcod (select pagplpgcod from pdv.pag where pagcupcod=cupcod and paglojacod=cuplojacod and pagpdvcod=cuppdvcod limit 1) as plpgcod, (select pagcobcod from pdv.pag where pagcupcod=cupcod and paglojacod=cuplojacod and pagpdvcod=cuppdvcod limit 1) as tccod, case when cupvendcod is not null and cupvendcod in (select rcaparcod from rca) then cupvendcod else cupoperadcod end as rcacod, (select rcasupparcod from rca where rcaparcod=cupoperadcod) as supcod,--nfsupparcod cupoperadcod,--nfrcaauxparcod opnfcpr, opnfsta, cupprochorario, cupsefazchave, case when cupsefazsituacao = 'NAO ENVIADO' then 'NAO_ENVIADO' else cupsefazsituacao end as cupsefazsituacao, cupsefazhorario, cupsefazusuparcod, cupsefazprotocolo, cupsefazmens, cupsefazxml, pdvcxcod, cupsefazinfprotdigval from pdv.cupom join pdv.pdv on cuppdvcod = pdvcod join opnf on cupopnfcod = opnfcod where cupprocretag is null and cupcod=p_cupom and cuplojacod=p_loja and cuppdvcod=p_pdv LOOP -- select * from f_realizar_faturamento_pdv() --******* -- VALIDAR DADOS ANTES DO FATURAMENTO --******* /* v_erro := 0; FOR rec_mens IN select pedido,advertencia from f_validar_faturamento_pdv(rec_pv.pvcod) LOOP RETURN QUERY SELECT rec_mens.pedido, coalesce((select nfcod from nf where nfpvcod=rec_pv.pvcod),0)::integer as nfcod, 0::integer as nfnum, ''::text as nfserie, rec_mens.advertencia; v_erro := 1; END LOOP; IF v_erro > 0 THEN RETURN; END IF; */ --******* --INSERIR CAB NF --******* --OBTER OBS NF /* select trim(confobsnf) into v_confobsnf from conf where confempparcod=rec_pv.pvempparcod; EXECUTE coalesce(v_confobsnf,'select null') INTO v_obsnf USING rec_pv.pvcod; */ --OBTER PROX CODIGO/SEQ DE NF - CAMPO CHAVE select nextval('nf_nfcod_seq') into v_nfcod; --INSERT NF insert into nf ( nfcadusuparcod, --integer, nfcadhorario, --timestamp without time zone, nfaltusuparcod, --integer, nfalthorario, --timestamp without time zone, nfcod, --serialNOT NULL, nfempparcod, --integer NOT NULL, nfparcod, --integer NOT NULL, nfnum, --integer NOT NULL, nfserie, --character varying(4) NOT NULL, nfsta, --character(2), nfdtemi, --date NOT NULL, nfdtsai, --date NOT NULL, nfhrsai, --time without time zone DEFAULT now(), nfopnfcod, --integer NOT NULL, nfespecie, --character(4), nftipoemissao, --character(1) DEFAULT 'P'::bpchar, nfmodelo, --character varying(10), nfvl, --numeric(14,4) DEFAULT 0, nfvlpro, --numeric(14,4) DEFAULT 0, nfbcicms, --numeric(14,4) DEFAULT 0, nfvlicms, --numeric(14,4) DEFAULT 0, nfbcicmsst, --numeric(14,4) DEFAULT 0, nfvlicmsst, --numeric(14,4) DEFAULT 0, nfvlfrete, --numeric(14,4) DEFAULT 0, nfvlseguro, --numeric(14,4) DEFAULT 0, nfvldesc, --numeric(14,4) DEFAULT 0, nfvloutrasdesp, --numeric(14,4) DEFAULT 0, nfvlipi, --numeric(14,4) DEFAULT 0, nfvlisento, --numeric(14,4) DEFAULT 0, nfvloutros, --numeric(14,4) DEFAULT 0, nftipofrete, --character(1), nfpesobruto, --numeric(14,4) DEFAULT 0, nfpesoliq, --numeric(14,4) DEFAULT 0, nfvol, --numeric(14,4) DEFAULT 0, nfnumvol, --numeric(14,4), nfobs, --text, nfpvcod, --integer, nfplpgcod, --integer, nftccod, --integer, nfrcaparcod, --integer, nfsupparcod, --integer, nfrcaauxparcod, --integer, nfcarcod, --integer, nfcarcodorig, --integer, nfordcar, --integer, nftranspcod, --integer, nfveicod, --integer, nfmotparcod, --integer, nfconhecfretecod, --integer, nfpccod, --integer, nfdevolnum, --integer, nfdevolserie, --character varying(4), nfmotivdevolnfcod, --integer, nf_num_cupom, --integer, nfdevolnfcod, --integer, nfvlcreddevol, --numeric(14,4), nfefetusuparcod, --integer, nfefetdt, --timestamp without time zone, nfdesagusuparcod, --integer, nfdesaghorario, --timestamp without time zone, nfespecievolume, --character varying(20) DEFAULT 'VOLUMES'::character varying, nfnumeracaovolume, --character varying(20) DEFAULT 'N/A'::character varying, nfctecod, --integer, nfarquivoxml, --character varying(100) nfsefazchave, --character varying(50), nfsefazsituacao, --character varying(20), nfsefazhorario, --timestamp without time zone, nfsefazusuparcod, --integer, --nfsefazobs, --text, nfsefazprotocolo, --text, nfsefazmens, --text, nfpdvcod --integer ) values ( rec_cupom.cupoperadcod,--nfcadusuparcod, --integer, rec_cupom.cupfimhorario,--nfcadhorario, --timestamp without time zone, null,--nfaltusuparcod, --integer, null,--nfalthorario, --timestamp without time zone, v_nfcod,--nfcod, serial --NOT NULL, rec_cupom.cuplojacod,--nfempparcod, --integer NOT NULL, rec_cupom.clicod,--nfparcod, --integer NOT NULL, rec_cupom.cupnum,--nfnum, --integer NOT NULL, rec_cupom.cupserie,--nfserie, --character varying(4) NOT NULL, 'FT',--nfsta, --character(2), cast(rec_cupom.cupfimhorario as date),--nfdtemi, --date NOT NULL, cast(rec_cupom.cupfimhorario as date),--nfdtsai cast(rec_cupom.cupfimhorario as time),--nfhrsai rec_cupom.nfopnfcod,--nfopnfcod, --integer NOT NULL, rec_cupom.opnfesp,--nfespecie, --character(4), rec_cupom.p_form,--nftipoemissao, --character(1) DEFAULT 'P'::bpchar, rec_cupom.modelo,--nfmodelo, --character varying(10), rec_cupom.cuppago,--nfvl, --numeric(14,4) DEFAULT 0, rec_cupom.cuppagopro,--nfvlpro, --numeric(14,4) DEFAULT 0, 0,--nfbcicms, --numeric(14,4) DEFAULT 0, 0,--nfvlicms, --numeric(14,4) DEFAULT 0, 0,--nfbcicmsst, --numeric(14,4) DEFAULT 0, 0,--nfvlicmsst, --numeric(14,4) DEFAULT 0, 0,--nfvlfrete, --numeric(14,4) DEFAULT 0, 0,--nfvlseguro, --numeric(14,4) DEFAULT 0, 0,--nfvldesc, --numeric(14,4) DEFAULT 0, 0,--nfvloutrasdesp, --numeric(14,4) DEFAULT 0, 0,--nfvlipi, --numeric(14,4) DEFAULT 0, 0,--nfvlisento, --numeric(14,4) DEFAULT 0, 0,--nfvloutros, --numeric(14,4) DEFAULT 0, 0,--nftipofrete, --character(1), 0,--nfpesobruto, --numeric(14,4) DEFAULT 0, 0,--nfpesoliq, --numeric(14,4) DEFAULT 0, 0,--nfvol, --numeric(14,4) DEFAULT 0, 0,--nfnumvol, --numeric(14,4), cast('' as varchar),--nfobs, --text, null,--rec_cupom.cupcod,--nfpvcod, --integer, rec_cupom.plpgcod,--nfplpgcod, --integer, rec_cupom.tccod,--nftccod, --integer, rec_cupom.rcacod,--nfrcaparcod, --integer, rec_cupom.supcod,--nfsupparcod, --integer, rec_cupom.rcacod,--nfrcaauxparcod, --integer, null,--nfcarcod, --integer, null,--nfcarcodorig, --integer, null,--nfordcar, --integer, null,--nftranspcod, --integer, null,--nfveicod, --integer, null,--nfmotparcod, --integer, null,--nfconhecfretecod, --integer, null,--nfpccod, --integer, null,--nfdevolnum, --integer, null,--nfdevolserie, --character varying(4), null,--nfmotivdevolnfcod, --integer, rec_cupom.cupnum,--nf_num_cupom, --integer, null,--nfdevolnfcod, --integer, null,--nfvlcreddevol, --numeric(14,4), rec_cupom.cupoperadcod,--nfefetusuparcod, --integer, now(),--nfefetdt, --timestamp without time zone, null,--nfdesagusuparcod, --integer, null,--nfdesaghorario, --timestamp without time zone, null,--nfespecievolume, --character varying(20) DEFAULT 'VOLUMES'::character varying, null,--nfnumeracaovolume, --character varying(20) DEFAULT 'N/A'::character varying, null,--nfctecod, --integer, null,--corrigir nfarquivoxml --character varying(100) rec_cupom.cupsefazchave,--nfsefazchave character varying(50), rec_cupom.cupsefazsituacao,--nfsefazsituacao character varying(20), rec_cupom.cupprochorario,--nfsefazhorario timestamp without time zone, rec_cupom.cupsefazusuparcod,--nfsefazusuparcod integer, --nfsefazobs text, rec_cupom.cupsefazprotocolo,--nfsefazprotocolo text, rec_cupom.cupsefazmens,--nfsefazmens text, rec_cupom.cuppdvcod--nfpdvcod integer, ); --INSERIR REGISTRO EM NFE insert into nfe ( nfecadusuparcod, nfecadhorario, nfealtusuparcod, nfealthorario, nfenfempparcod, nfenfparcod, nfenfnum, nfenfserie, nfenfcod, nfechave, nfesituacao, --nfe_arquivo_xml, nfe_texto_xml, nfe_infprot_nprot, nfe_infprot_dhrecbto, nfe_infprot_msg, nfe_infprot_digval ) values ( rec_cupom.cupoperadcod, --nfecadusuparcod integer, rec_cupom.cupinihorario, --nfecadhorario timestamp without time zone, null,--nfealtusuparcod integer, null,--nfealthorario timestamp without time zone, rec_cupom.cuplojacod,--nfenfempparcod integer NOT NULL, rec_cupom.clicod,--nfenfparcod integer NOT NULL, cast(rec_cupom.cupnum as integer),--nfenfnum integer NOT NULL, update - Recebe v_nfcod/seq provisoriamente ate gravar nfi, cpr e cprpg rec_cupom.cupserie,--nfenfserie character varying(4) NOT NULL, update - Recebe 0 provisoriamente ate gravar nfi, cpr e cprpg v_nfcod, --nfenfcod integer NOT NULL, rec_cupom.cupsefazchave,--nfechave character varying(254), rec_cupom.cupsefazsituacao, --cast(rec_cupom.cupsefazxml as bytea),--nfe_arquivo_xml bytea, rec_cupom.cupsefazxml,--nfe_texto_xml text, rec_cupom.cupsefazprotocolo,--nfe_infprot_nprot character varying(254), rec_cupom.cupprochorario,--nfe_infprot_dhrecbto character varying(254), rec_cupom.cupsefazmens,--nfe_infprot_msg character varying(254), rec_cupom.cupsefazinfprotdigval ); /*********** ITENS DO PEDIDO */ FOR rec_item IN select itemcod, itemlojacod, itempdvcod, itemopnfcod, itemcupcod, itemcadhorario, itemseq, itemcodbar, itemprocod, itemproembcod, itemtipoemb, itemprodes, itemprodesreduzida, itemproemb, itemproun, itempromult, itemqt, itemvltab, itemvlven, itemvltotal, itemncm, itemtribcfopcod, itemtribcsosncod, itemtribpercredbcicms, itemtribbcicms, itemtribaliqicms, itemtribvlicms, itemtribvloutros, itemtribcst, itemcanchorario, itemcancfiscalcod, itemdescfiscalcod, itemdeschorario, itemqt*estcustocompra as custocompra, itemqt*estcustoreal as custoreal, uvecod, uvedes, uveun, uvemult, itemqt*itempromult as pqtde, round(itemvltab/itempromult,2) as pvltabunit, round(itemvlven/itempromult,2) as pvlunit, itemtribcstpiscofinscod, itemtribaliqpis, itemtribaliqcofins, itemtribvlpis, itemtribvlcofins from pdv.item left join uve on itemprocod=uveprocod and uvetipo='P' left join est on itemprocod=estprocod and itemlojacod=estempparcod where itemcupcod=p_cupom and itemlojacod=p_loja and itempdvcod=p_pdv order by itemcupcod,itemseq LOOP /* --******* --INSERIR ITEM - NFI --******* --ICMS NORMAL v_visento:=0; v_vbasecalc:=0; v_vicms:=0; v_voutros:=0; v_vipi:=0; IF rec_pvi.isento = 'S' THEN v_visento := rec_pvi.pvivltotal; ELSE --Obter base de calculo IF rec_pvi.pauta > 0 THEN v_vbasecalc := rec_pvi.pviqtdeatecar*rec_pvi.pauta; ELSE IF rec_pvi.percrbcicms > 0 THEN v_vbasecalc := round(rec_pvi.pvivltotal*rec_pvi.percrbcicms/100,4); ELSE v_vbasecalc := rec_pvi.pvivltotal; END IF; END IF; v_vicms := round(v_vbasecalc*coalesce(rec_pvi.aliqicms,0)/100,4); v_voutros := rec_pvi.pvivltotal-v_vbasecalc; END IF; --SUBSTITUICAO v_vbasecalcST := 0; v_vlicmsST := 0; IF rec_pvi.opnfsta in ('GC','C') THEN v_vipi := round(rec_pvi.pvivltotal*coalesce(rec_pvi.percipi,0)/100,4); IF rec_pvi.aliqicmsret > 0 THEN IF rec_pvi.pautaret > 0 THEN v_vbasecalcST := rec_pvi.pviqtdeatecar*rec_pvi.pautaret; ELSE IF rec_pvi.percrbcicmsret > 0 THEN --v_vbasecalcST := round((rec_pvi.pvivltotal+v_vipi+frete)*rec_pvi.percrbcicmsret/100,4); v_vbasecalcST := round((rec_pvi.pvivltotal+v_vipi)*rec_pvi.percrbcicmsret/100,4); ELSE --v_vbasecalcST := rec_pvi.pvivltotal+v_vipi+frete; v_vbasecalcST := rec_pvi.pvivltotal+v_vipi; END IF; END IF; v_vbasecalcST := round(v_vbasecalcST*(1+(coalesce(rec_pvi.aliqiva,0)/100)),4); v_vlicmsST := round((v_vbasecalcST*rec_pvi.aliqicmsret/100)-coalesce(v_vicms,0),4); END IF; END IF; */ insert into nfi ( nficadusuparcod, nficadhorario, nfialtusuparcod, nfialthorario, nfinfempparcod, nfinfparcod, nfinfnum, nfinfserie, nfinfcod, nfiprocod, nfiuvecod, nfiuvedes, nfiuveun, nfiuvemult, nfiqtde, nfivltabunit, nfivlunit, nfivl, nficfopcod, nficstcod, nficsosncod, nfialiqcredsn, nfivlcredicmssn, nfibcicms, nfipercredbcicms, nfialiqicms, nfivlicms, nfibcicmsst, nfipercredbcicmsst, nfialiqicmsst, nfivlicmsst, nficstipicod, nfialiqipi, nfivlipi, nficstpiscofinscod, nfialiqpis, nfivlpautapis, nfivlpis, nfialiqcofins, nfivlpautacofins, nfivlcofins, nfivlfrete, nfivlseguro, nfivldesc, nfivloutrasdesp, nfivlisento, nfivloutros, nfivldesprat, nfivldespnrat, nficustocompra, nficustoreal, nfivlvensug, nfiforparcod, nfiseq, nfipuvecod, nfipuvedes, nfipuveun, nfipuvemult, nfipqtde, nfipvltabunit, nfipvlunit ) values ( rec_cupom.cupoperadcod,--nficadusuparcod rec_cupom.cupinihorario,--nficadhorario, null,--nfialtusuparcod, null,--nfialthorario, rec_item.itemlojacod,--nfinfempparcod, rec_cupom.clicod,--nfinfparcod, rec_cupom.cupnum,--nfinfnum, Receber v_nfcod/seq provisoriamente ate gravar nfi, cpr e cprpg rec_cupom.cupserie,--nfinfserie, Receber v_nfcod/seq provisoriamente ate gravar nfi, cpr e cprpg v_nfcod,--nfinfcod, rec_item.itemprocod,--nfiprocod, rec_item.itemproembcod,--nfiuvecod, rec_item.itemproemb,--nfiuvedes, rec_item.itemproun,--nfiuveun, rec_item.itempromult,--nfiuvemult, rec_item.itemqt,--nfiqtde, rec_item.itemvltab,--nfivltabunit, rec_item.itemvlven,--nfivlunit rec_item.itemvltotal,--nfivl, rec_item.itemtribcfopcod,--nficfopcod, rec_item.itemtribcst,--nficstcod, rec_item.itemtribcsosncod,--nficsosncod, null,--nfialiqcredsn, null,--nfivlcredicmssn, rec_item.itemtribbcicms,--nfibcicms, rec_item.itemtribpercredbcicms,--nfipercredbcicms, rec_item.itemtribaliqicms,--nfialiqicms, rec_item.itemtribvlicms,--nfivlicms, null,--nfibcicmsst, null,--nfipercredbcicmsst, null,--nfialiqicmsst, null,--nfivlicmsst, null,--nficstipicod, null,--nfialiqipi, null,--nfivlipi, rec_item.itemtribcstpiscofinscod,--nficstpiscofinscod, rec_item.itemtribaliqpis,--nfialiqpis, null,--nfivlpautapis, rec_item.itemtribvlpis,--nfivlpis, rec_item.itemtribaliqcofins,--nfialiqcofins, null,--nfivlpautacofins, rec_item.itemtribvlcofins,--nfivlcofins, null,--nfivlfrete, null,--nfivlseguro, null,--nfivldesc, null,--nfivloutrasdesp, null,--nfivlisento, rec_item.itemtribvloutros,--nfivloutros, null,--nfivldesprat, null,--nfivldespnrat, rec_item.custocompra,--nficustocompra, rec_item.custoreal,--nficustoreal, null,--nfivlvensug, null,--nfiforparcod rec_item.itemseq,--nfiseq rec_item.uvecod,--nfipuvecod integer, rec_item.uvedes,--nfipuvedes character varying(60), rec_item.uveun,--nfipuveun character varying(10), rec_item.uvemult,--nfipuvemult numeric(14,4), rec_item.pqtde,--nfipqtde numeric(14,4) DEFAULT 0, rec_item.pvltabunit, rec_item.pvlunit ); -- select * from f_realizar_faturamento_pdv() --******* --ESTOQUE --******* select f_insert_estmv( rec_item.itemlojacod, rec_item.itemprocod, rec_item.itemproembcod, rec_item.itemproemb, rec_item.itemproun, rec_item.itempromult, 'S', rec_cupom.opnfsta, rec_item.itemqt, 'FUNC FATURAMENTO', 'FATURAMENTO PEDIDO PDV', v_nfcod, rec_cupom.cupoperadcod ) into rec_insert_estmv; END LOOP;--FOR rec_pvi IN --******* --UPDATE NF PARA DISPONIBILIZAR VL TOTAL PARA GERAR CPR --******* update nf set nfvl=i.nfvl,--nfvl numeric(14,4) DEFAULT 0, nfvlpro=i.nfvlpro,--nfvlpro numeric(14,4) DEFAULT 0, nfbcicms=i.nfbcicms,--nfbcicms numeric(14,4) DEFAULT 0, nfvlicms=i.nfvlicms,--nfvlicms numeric(14,4) DEFAULT 0, nfbcicmsst=i.nfbcicmsst,--nfbcicmsst numeric(14,4) DEFAULT 0, nfvlicmsst=i.nfvlicmsst,--nfvlicmsst numeric(14,4) DEFAULT 0, nfvlfrete=i.nfvlfrete,--nfvlfrete numeric(14,4) DEFAULT 0, nfvlseguro=i.nfvlseguro,--nfvlseguro numeric(14,4) DEFAULT 0, nfvldesc=i.nfvldesc,--nfvldesc numeric(14,4) DEFAULT 0, nfvloutrasdesp=i.nfvloutrasdesp,--nfvloutrasdesp numeric(14,4) DEFAULT 0, nfvlipi=i.nfvlipi,--nfvlipi numeric(14,4) DEFAULT 0, nfvlisento=i.nfvlisento,--nfvlisento numeric(14,4) DEFAULT 0, nfvloutros=i.nfvloutros--nfvloutros numeric(14,4) DEFAULT 0, --nfpesobruto=i.nfpesobruto,--nfpesobruto numeric(14,4) DEFAULT 0, --nfpesoliq=i.nfpesoliq,--nfpesoliq numeric(14,4) DEFAULT 0, --nfvol=i.nfvol,--nfvol numeric(14,4) DEFAULT 0, --nfnumvol=i.nfnumvol--nfnumvol numeric(14,4), from ( select nfinfcod, count(nfiprocod) as qtitens, sum(coalesce(nfivl,0))+ sum(coalesce(nfivlipi,0))+ sum(coalesce(nfivlfrete,0))+ sum(coalesce(nfivlseguro,0))+ sum(coalesce(nfivloutrasdesp,0))+ sum(coalesce(nfivlicmsst,0))- sum(coalesce(nfivldesc,0)) as nfvl, sum(coalesce(nfibcicms,0)) as nfbcicms, sum(coalesce(nfivlicms,0)) as nfvlicms, sum(coalesce(nfibcicmsst,0)) as nfbcicmsst, sum(coalesce(nfivlicmsst,0)) as nfvlicmsst, sum(coalesce(nfivl,0)) as nfvlpro, sum(coalesce(nfivlfrete,0)) as nfvlfrete, sum(coalesce(nfivlseguro,0)) as nfvlseguro, sum(coalesce(nfivloutrasdesp,0)) as nfvloutrasdesp, sum(coalesce(nfivlipi,0)) as nfvlipi, sum(coalesce(nfivlisento,0)) as nfvlisento, sum(coalesce(nfivloutros,0)) as nfvloutros, sum(coalesce(nfivldesc,0)) as nfvldesc from nfi where nfinfcod=v_nfcod group by nfinfcod ) as i where nfcod=nfinfcod; --Se opnf gera conta IF rec_cupom.opnfcpr='S' THEN --******* --OBTER PROX CODIGO/SEQ DE CPR - CAMPO CHAVE --******* select nextval('seq_cpr'||rec_cupom.cuplojacod::text) into v_cprcod; if (select tctipo from tc where tccod = pagcobcod) = 'VALE' then v_docTipo := 'CRV'; else v_docTipo := 'CRC'; end if; --INSERIR CAB insert into cpr ( cprempparcod,-- integer NOT NULL, cprcod,-- integer NOT NULL, cprtipo,-- character(3), cprccpcgcccod,-- integer, cprccpcgpcgcod,-- integer, cprmodg,-- character(2), cprparcod,-- integer, cprdocnum,-- integer, cprdocserie,-- character varying(10), cprprev,-- character(1), cprdemi,-- timestamp with time zone, cprdlan,-- timestamp with time zone, cprvt,-- numeric(14,4) DEFAULT 0, cprvtpg,-- numeric(14,4) DEFAULT 0, cprfunparcod,-- integer, cprpcgcod,-- integer, cprnat,-- character(1), cprrcaparcod,-- integer, cprdevparcod,-- integer, cprobs,-- character varying(250), cpr_cart_codigo,-- integer, cpr_d_competencia,-- date, cpr_ccc_id,-- integer, cpr_conta_id,-- integer, cpr_cc_id,-- integer, cpr_notafiscal,-- character varying(20), cprnfcod-- integer, ) select cuplojacod,--cprempparcod integer NOT NULL, v_cprcod,--cprcod integer NOT NULL, v_docTipo,--'CRC',--cprtipo character(3), null,--cprccpcgcccod integer, null,--cprccpcgpcgcod integer, 'FT',--cprmodg character(2), rec_cupom.clicod,--cprparcod integer, rec_cupom.cupnum,--update cprdocnum integer, rec_cupom.cupserie,--update cprdocserie character varying(10), 'N',--cprprev character(1), rec_cupom.dtemi,--cprdemi timestamp with time zone, v_agora,--cprdlan timestamp with time zone, cuptotal,--cprvt numeric(14,4) DEFAULT 0, 0,--cprvtpg numeric(14,4) DEFAULT 0, rec_cupom.cupoperadcod,--cprfunparcod integer, null,--cprpcgcod integer, null,--cprnat character(1), rec_cupom.rcacod,--cprrcaparcod integer, rec_cupom.clicod,--cprdevparcod integer, 'Referente a saida de Mercadoria',--cprobs character varying(250), 1,--cpr_cart_codigo integer, DATE(rec_cupom.cupfimhorario),--cpr_d_competencia date, null,--cpr_ccc_id integer, rec_cupom.opnf_conta_id,--cpr_conta_id integer, rec_cupom.opnf_cc_id,--cpr_cc_id integer, rec_cupom.cupnum, --update cpr_notafiscal character varying(20), v_nfcod --cprnfcod integer; from pdv.cupom where cupcod=p_cupom and cuplojacod=p_loja and cuppdvcod=p_pdv; --INSERIR CPRPG insert into cprpg( cprpgcprempparcod, cprpgcprcod, cprpgcod, cprpgdvenc, cprpgv, cprpgmultav, cprpgmultaperc, cprpgmoradiav, cprpgmoradiaperc, cprpgdescv, cprpgdescperc, cprpgtccod, cprpgobs, cprpgdbai, cprpgsta, cprpgcodo, cprpgefetcod, cprpgvbai, cprpgdpag, cprpgfunparcod, cprpgbancod, cprpgag, cprpgnumdoc, cprpgcc, cprpgdsit, cprpgsit, cprpgcxcod, cprpgtdvchcod, cprpgobssit, cprpgreapdvch, cprpgnn, cprpgdevv, cprpgdvenco, cprpgtccodo, cprpgstsequifax, cprpg_d_lanc, cprpg_d_competencia, cprpg_arq_remessa, cprpgobsbol, cprpgcedparcod, cprpgcedbolagced, cprpgcedbolccced, cprpgcedboldvag, cprpgcedboldvcc, cprpgparc )( select parclojacod,--cprpgcprempparcod, v_cprcod,--cprpgcprcod, parccod,--cprpgcod, parcdtvenc,--cprpgdvenc, pagpago,--cprpgv, null,--cprpgmultav, null,--cprpgmultaperc, null,--cprpgmoradiav, null,--cprpgmoradiaperc, null,--cprpgdescv, null,--cprpgdescperc, pagcobcod,--cprpgtccod, null,--cprpgobs, null,--cprpgdbai, 'E',--cprpgsta, null,--cprpgcodo, rec_cupom.cupoperadcod, --cprpgefetcod, 0,--cprpgvbai, null,--cprpgdpag, rec_cupom.cupoperadcod,--cprpgfunparcod, parccheqbanco,--cprpgbancod, parccheqag,--cprpgag, parccheqnum,--cprpgnumdoc, parccheqcc,--cprpgcc, null,--cprpgdsit, null,--cprpgsit, rec_cupom.pdvcxcod,--cprpgcxcod, null,--cprpgtdvchcod, null,--cprpgobssit, null,--cprpgreapdvch, null,--cprpgnn, null,--cprpgdevv, parcdtvenc,--cprpgdvenco, null,--cprpgtccodo, null,--cprpgstsequifax, v_agora,--cprpg_d_lanc, rec_cupom.dtemi,--cprpg_d_competencia, null,--cprpg_arq_remessa, null,--cprpgobsbol, null,--cprpgcedparcod, null,--cprpgcedbolagced, null,--cprpgcedbolccced, null,--cprpgcedboldvag, null,--cprpgcedboldvcc, parcseq--cprpgparc from pdv.pag join pdv.parc on parcpagcod = pagcod and parcpdvcod = pagpdvcod where pagcupcod = p_cupom and paglojacod=p_loja and pagpdvcod=p_pdv ); /* --verifica diferenca e joga na ultima parcela UPDATE cprpg a SET cprpgv = round(cprpgv,2)+p.dif FROM ( select cprempparcod, cprcod, cprvt-sum(round(coalesce(cprpgv,0),2)) as dif from cpr left join cprpg on cprcod=cprpgcprcod and cprpgcprempparcod=cprempparcod where cprcod=v_cprcod group by cprempparcod,cprcod,cprvt ) AS p WHERE cprpgcprcod=cprcod and cprpgcprempparcod=cprempparcod and cprpgcod=rec_pv.num_parc; */ END IF;--IF rec_pv.opnfcpr='S' THEN FOR rec_pag IN SELECT cupcod as nfcod, cupnum as nfnum, rec_cupom.clicod as nfparcod, null as nfcarcod, cuplojacod as cprempparcod, v_cprcod as cprcod, rec_cupom.dtemi as cprdemi, parccod as cprpgcod, parcdtvenc as cprpgdvenc, pagpago as cprpgv, pagcobcod as cprpgtccod, 'E' as cprpgsta, cupoperadcod, pagcadhorario, pagvalor, pagcobcod, pagcobdes, tctdoc, tcbaidoc, tclancx, pagplpgcondicao, parcvalor, parcdtvenc, parccheqbanco, parccheqag, parccheqcc, parccheqnum, parccheqemitente, case when tcbaidoc='S' then 'BA' else 'LA' end as docsta, case when tcbaidoc='S' then parcdtvenc else null end as docdpag, case when tcbaidoc='S' then parcdtvenc else null end as docdbai, (select opnf_conta_id from opnf where opnfcod=cupopnfcod) as opnf_conta_id, (select opnf_cc_id from opnf where opnfcod=cupopnfcod) as opnf_cc_id, pdvcxcod,--pdvcxcod, bancod from pdv.cupom join pdv.pdv on cuppdvcod = pdvcod join pdv.pag on pagcupcod = cupcod and pagpdvcod = cuppdvcod join pdv.parc on parcpagcod = pagcod and parcpdvcod = cuppdvcod join tc on pagcobcod = tccod join opnf on cupopnfcod = opnfcod left join ban on parccheqbanco=bancod where pagcanchorario is null and cupcod=p_cupom and cuplojacod=p_loja and cuppdvcod=p_pdv order by pagseq,parcseq LOOP --******* -- DOC --******* select nextval('seq_doc') into v_doccod; insert into doc( docempparcod, --integer NOT NULL, doccod, -- integer NOT NULL, doctipo, -- character(3), docsta, -- character(2), docdsta, -- timestamp without time zone, docfunparcod, -- integer, docdlan, -- timestamp without time zone, docdvenc, -- date, docv, -- numeric(14,4) NOT NULL DEFAULT 0, doctccod, -- integer, docnum, -- character varying(18), docbancod, -- integer DEFAULT 0, docag, -- character varying(10), doccc, -- character varying(10), docdesc, -- numeric(14,4) DEFAULT 0, docjuros, -- numeric(14,4) DEFAULT 0, docdpag, -- timestamp without time zone, docdbai, -- timestamp without time zone, docdevparcod, -- integer, doctdvchcod, -- integer, docobs, -- text, docdvenco, -- date, docrcaparcod, -- integer, docsit, -- character(1), docdsit, -- timestamp without time zone, docnn, -- character(20), docdescb, -- numeric(14,4) DEFAULT 0, docjurosb, -- numeric(14,4) DEFAULT 0, doc_d_competencia, -- date, doc_cart_codigo, -- integer, doc_conta_id, -- integer NOT NULL, doc_cc_id, -- integer NOT NULL, docimpresso, -- character(1), docnominal, -- character varying(254), doc_notafiscal, -- character varying(20), doc_valor_protesto, -- numeric(14,4), doc_orgao_protesto, -- character varying(254), doc_arq_remessa, -- character varying(80), docobsbol, -- character varying(254), doc_sispag_tipo_pag, -- character varying(2), doc_sispag_forma_pag, -- character varying(2), doc_sispag_ban_fav, -- integer, doc_sispag_ag_fav, -- character varying(10), doc_sispag_cc_fav, -- character varying(10), doc_sispag_dac_fav, -- character varying(1), doc_sispag_dvcb, -- character(1), doc_sispag_fator_venc, -- integer, doc_sispag_campo_livre, -- character varying(25), doc_pagdoc_id, -- integer, doc_bol_ocorrencia, -- character(2), doccxmvcod, -- integer, doc_numcontrato, -- character varying(254), doclanccredcli, -- numeric(14,4) DEFAULT 0, docbaicredcli, -- numeric(14,4) DEFAULT 0, doccedparcod, -- integer DEFAULT 0, doccedbolagced, -- character varying(10), doccedbolccced, -- character varying(10), doccedboldvag, -- integer, doccedboldvcc, -- integer, docbordcod, -- integer DEFAULT 0, doc_vale, -- character varying(254), docdemi, -- timestamp without time zone, doc_agrup, -- integer DEFAULT nextval('seq_agrupdoc'::regclass), doc_cx_ef, -- integer, doc_bol_carteira_aux, -- character varying(10), doc_bol_carteira, -- character varying(10), docefetcxcod, -- integer, docefetusuparcod, -- integer, docefetdt, -- timestamp without time zone, docdonocxcod, -- integer, docdonousuparcod, -- integer, docdonodt, -- timestamp without time zone, doccarcod, -- integer, docparc ) values ( rec_pag.cprempparcod, --docempparcod, --integer NOT NULL, v_doccod, --doccod, -- integer NOT NULL, v_docTipo,--'CRC', --doctipo, -- character(3), rec_pag.docsta, --docsta, -- character(2), rec_pag.pagcadhorario, --docdsta, -- timestamp without time zone, rec_pag.cupoperadcod, --docfunparcod, -- integer, rec_pag.pagcadhorario, --docdlan, -- timestamp without time zone, rec_pag.parcdtvenc, --docdvenc, -- date, rec_pag.parcvalor, --docv, -- numeric(14,4) NOT NULL DEFAULT 0, rec_pag.pagcobcod, --doctccod, -- integer, rec_pag.parccheqnum , --docnum, -- character varying(18), rec_pag.parccheqbanco, --docbancod, -- integer DEFAULT 0, rec_pag.parccheqag, --docag, -- character varying(10), rec_pag.parccheqcc, --doccc, -- character varying(10), null, --docdesc, -- numeric(14,4) DEFAULT 0, null, --docjuros, -- numeric(14,4) DEFAULT 0, rec_pag.docdpag, --docdpag, -- timestamp without time zone, rec_pag.docdbai, --docdbai, -- timestamp without time zone, rec_pag.nfparcod, --docdevparcod, -- integer, null, --doctdvchcod, -- integer, null, --docobs, -- text, rec_pag.parcdtvenc, --docdvenco, -- date, rec_pag.cupoperadcod, --docrcaparcod, -- integer, null, --docsit, -- character(1), null, --docdsit, -- timestamp without time zone, null, --docnn, -- character(20), null, --docdescb, -- numeric(14,4) DEFAULT 0, null, --docjurosb, -- numeric(14,4) DEFAULT 0, rec_pag.pagcadhorario, --doc_d_competencia, -- date, 1, --doc_cart_codigo, -- integer, rec_pag.opnf_conta_id, --doc_conta_id, -- integer NOT NULL, rec_pag.opnf_cc_id, --doc_cc_id, -- integer NOT NULL, null, --docimpresso, -- character(1), null, --docnominal, -- character varying(254), rec_pag.nfnum, --doc_notafiscal, -- character varying(20), null, --doc_valor_protesto, -- numeric(14,4), null, --doc_orgao_protesto, -- character varying(254), null, --doc_arq_remessa, -- character varying(80), null, --docobsbol, -- character varying(254), null, --doc_sispag_tipo_pag, -- character varying(2), null, --doc_sispag_forma_pag, -- character varying(2), null, --doc_sispag_ban_fav, -- integer, null, --doc_sispag_ag_fav, -- character varying(10), null, --doc_sispag_cc_fav, -- character varying(10), null, --doc_sispag_dac_fav, -- character varying(1), null, --doc_sispag_dvcb, -- character(1), null, --doc_sispag_fator_venc, -- integer, null, --doc_sispag_campo_livre, -- character varying(25), null, --doc_pagdoc_id, -- integer, null, --doc_bol_ocorrencia, -- character(2), null, --doccxmvcod, -- integer,--ATUALIZADO NA ROTINA QUE LANCA NO CAIXA null, --doc_numcontrato, -- character varying(254), null, --doclanccredcli, -- numeric(14,4) DEFAULT 0, null, --docbaicredcli, -- numeric(14,4) DEFAULT 0, null, --doccedparcod, -- integer DEFAULT 0, null, --doccedbolagced, -- character varying(10), null, --doccedbolccced, -- character varying(10), null, --doccedboldvag, -- integer, null, --doccedboldvcc, -- integer, null, --docbordcod, -- integer DEFAULT 0, null, --doc_vale, -- character varying(254), rec_pag.pagcadhorario, --docdemi, -- timestamp without time zone, null, --doc_agrup, -- integer DEFAULT nextval('seq_agrupdoc'::regclass), null, --doc_cx_ef, -- integer, null, --doc_bol_carteira_aux, -- character varying(10), null, --doc_bol_carteira, -- character varying(10), null, --docefetcxcod, -- integer, null, --docefetusuparcod, -- integer, null, --docefetdt, -- timestamp without time zone, rec_pag.pdvcxcod, --docdonocxcod, -- integer, rec_pag.cupoperadcod, --docdonousuparcod, -- integer, rec_pag.pagcadhorario, --docdonodt, -- timestamp without time zone, null, --doccarcod -- integer, '1' --docparc character varying(250), ); --******* -- DOCS --******* insert into docs ( docsdocempparcod, --integer NOT NULL, docsdoccod, --integer NOT NULL, docsdocsta, --character(2) NOT NULL, docsd, --timestamp without time zone NOT NULL, docsfunparcod --integer ) values ( rec_pag.cprempparcod, --docsdocempparcod integer NOT NULL, v_doccod, --docsdoccod integer NOT NULL, rec_pag.docsta, --docsdocsta character(2) NOT NULL, rec_pag.pagcadhorario, --docsd timestamp without time zone NOT NULL, rec_pag.cupoperadcod --docsfunparcod integer ); IF (rec_pag.tcbaidoc='S' AND rec_pag.tclancx='S') THEN ------------------------------------------------------------ -- CXMV ------------------------------------------------------------ select nextval('seq_cxmv') into v_cxmvcod; insert into cxmv ( cxmvempparcod, -- integer NOT NULL, cxmvcod, -- integer NOT NULL, cxmvtcxmvcod, -- integer, cxmvnumdoc, -- character varying(18), cxmvsta, -- character(1), cxmvtipo, -- character(1), cxmvcxcod, -- integer NOT NULL, cxmvdlanc, -- timestamp with time zone, cxmvv, -- numeric DEFAULT 0, cxmvfunparcod, -- integer, cxmvpcgcod, -- integer, cxmvobs, -- text, cxmvdsis, -- timestamp with time zone, cxmvtmecod, -- integer, cxmvdoccod, -- integer, cxmv_ccc_id, -- integer, cxmv_aceite, -- character(1), cxmv_conta_id, -- integer, cxmv_cc_id, -- integer, cxmv_d_conc, -- date NOT NULL, cxmv_cheq_id_transf, -- integer, cxmvtccod, -- integer, cxmv_legado, -- character varying(1), cxmvcarcod, -- integer, cxmvcheckdt, -- timestamp without time zone, cxmvcheckusuparcod -- integer, ) values ( rec_pag.cprempparcod, --cxmvempparcod, -- integer NOT NULL, v_cxmvcod, --cxmvcod, -- integer NOT NULL, rec_pag.cprpgtccod, --cxmvtcxmvcod, -- integer, //BAIXA DE CONTAS A RECEBER rec_pag.parccheqnum,--cxmvnumdoc, -- character varying(18), 'B', --cxmvsta, -- character(1), 'C', --cxmvtipo, -- character(1), rec_pag.pdvcxcod, --cxmvcxcod, -- integer NOT NULL, rec_pag.pagcadhorario, --cxmvdlanc, -- timestamp with time zone, rec_pag.parcvalor, --cxmvv, -- numeric DEFAULT 0, rec_pag.cupoperadcod, --cxmvfunparcod, -- integer, null, --cxmvpcgcod, -- integer, null, --cxmvobs, -- text, rec_pag.pagcadhorario, --cxmvdsis, -- timestamp with time zone, null, --cxmvtmecod, -- integer, v_doccod, --cxmvdoccod, -- integer, null, --cxmv_ccc_id, -- integer, null, --cxmv_aceite, -- character(1), rec_pag.opnf_conta_id, --cxmv_conta_id, -- integer, rec_pag.opnf_cc_id, --cxmv_cc_id, -- integer, rec_pag.pagcadhorario, --cxmv_d_conc, -- date NOT NULL, null, --cxmv_cheq_id_transf, -- integer, rec_pag.pagcobcod, --cxmvtccod, -- integer, null, --cxmv_legado, -- character varying(1), null, --cxmvcarcod, -- integer, null, --cxmvcheckdt, -- timestamp without time zone, null --cxmvcheckusuparcod -- integer, ); ------------------------------------------------------------ -- CXMVS ------------------------------------------------------------ insert into cxmvs ( cxmvscxmvempparcod, -- integer NOT NULL, cxmvscxmvcod, -- integer NOT NULL, cxmvscxmvsta, -- character(2) NOT NULL, cxmvsdhi, -- timestamp with time zone NOT NULL, cxmvsdhf, -- timestamp with time zone, cxmvsobs, -- text, cxmvsparcod -- integer NOT NULL, ) values ( rec_pag.cprempparcod, --cxmvscxmvempparcod integer NOT NULL, v_cxmvcod, --cxmvscxmvcod integer NOT NULL, 'B', --cxmvscxmvsta character(2) NOT NULL, rec_pag.pagcadhorario, --cxmvsdhi timestamp with time zone NOT NULL, rec_pag.pagcadhorario, --cxmvsdhf timestamp with time zone, 'BAIXA AUTOMATICA - SUBIR VENDA PDV', --cxmvsobs text, rec_pag.cupoperadcod --cxmvsparcod integer NOT NULL, ); -- Atualizar movimento no DOC correspondente update doc set doccxmvcod=v_cxmvcod where doccod=v_doccod; END IF;--IF tclancx='S' THEN -- Associacao CDE insert into cde ( cdecprpgcprempparcod, -- integer NOT NULL, cdecprpgcprcod, -- integer NOT NULL, cdecprpgcod, -- integer NOT NULL, cdedoccod -- integer NOT NULL, ) values ( rec_pag.cprempparcod, --cdecprpgcprempparcod integer NOT NULL, rec_pag.cprcod, --cdecprpgcprcod integer NOT NULL, rec_pag.cprpgcod, --cdecprpgcod integer NOT NULL, v_doccod --cdedoccod integer NOT NULL, ); -- Marcar NF como efetivada update nf set nfefetusuparcod=rec_pag.cupoperadcod,nfefetdt=rec_pag.pagcadhorario where nfcod=rec_pag.nfcod; END LOOP; --******* -- GERAR PROXIMO NUM NF --******* select empresa,layout,numero,serie into rec_seqnf from f_seqnf(rec_cupom.cuplojacod,rec_cupom.nfopnfcod); --******* -- ATUALIZAR PROXIMO NUM NF E DEMAIS DADOS --******* /* --Utilizar pvcupnum para nfnum e pvpdv para nfserie update nf set nfnum=rec_pv.pvcupnum,nfserie=rec_seqnf.serie where nfcod=v_nfcod; update nfe set nfenfnum=rec_pv.pvcupnum,nfenfserie=rec_seqnf.serie where nfenfcod=v_nfcod; --update nfecf set nfecfnfnum=rec_pv.pvcupnum,nfecfnfserie=rec_pv.pvpdv where nfecfnfcod=v_nfcod; update nfi set nfinfnum=rec_pv.pvcupnum,nfinfserie=rec_seqnf.serie where nfinfcod=v_nfcod; update cpr set cprdocnum=rec_pv.pvcupnum,cprdocserie=rec_seqnf.serie,cpr_notafiscal=rec_pv.pvcupnum::text where cprcod=v_cprcod; update pv set pvsta='FT' where pvcod=rec_pv.pvcod and pvempparcod=rec_pv.pvempparcod; update car set carsta = 'FT',cartf='F' where carcod = rec_pv.pvcarcod and carempparcod = rec_pv.pvempparcod; */ --******* -- NFIDET --******* select f_atualizar_nfidet(v_nfcod) into v_nfidet; --******* -- LIBERACAO DA QTDE RESERVADA --******* --select f_tratar_reserva(rec_pv.pvempparcod) into v_res; -- select * from f_realizar_faturamento_pdv() update pdv.cupom set cupprocretag=now() where cupcod=p_cupom and cuplojacod=p_loja and cuppdvcod=p_pdv; RETURN QUERY SELECT rec_cupom.cupcod, v_nfcod::integer as frfatnfcod, rec_cupom.cupnum::integer as frfatnfnum, rec_seqnf.serie::text as frfatnfserie, 'CUPOM PROCESSADO'::text; END LOOP;--FOR rec_cupom IN RETURN; END; $function$ ; -- Permissions ALTER FUNCTION public.f_processar_cupom(int4, int4, int4) OWNER TO postgres; GRANT ALL ON FUNCTION public.f_processar_cupom(int4, int4, int4) TO public; GRANT ALL ON FUNCTION public.f_processar_cupom(int4, int4, int4) TO postgres; ------------------------------------------------------------------------------------------------ ALTER TABLE public.confconta ADD confconta_tc_falta int4 NULL; ALTER TABLE public.confconta ADD confconta_tc_sobra int4 NULL; ------------------------------------------------------------------------------------------------ -- DROP FUNCTION public.f_calc_debcred(int4, int4, date, date, numeric); CREATE OR REPLACE FUNCTION public.f_calc_debcred(integer, integer, date, date, numeric) RETURNS TABLE(dc_rca_cod integer, dc_limite numeric, dc_saldo numeric, dc_vltab numeric, dc_vl numeric, dc_vldebcred numeric, dc_percdebcred numeric, dc_pv_vltab numeric, dc_pv_vl numeric, dc_pv_vldebcred numeric, dc_pv_percdebcred numeric, dc_fat_vltab numeric, dc_fat_vl numeric, dc_fat_vldebcred numeric, dc_fat_percdebcred numeric, dc_devol_vltab numeric, dc_devol_vl numeric, dc_devol_vldebcred numeric, dc_devol_percdebcred numeric, dc_bonif_vltab numeric, dc_bonif_vl numeric, dc_bonif_vldebcred numeric, dc_bonif_percdebcred numeric, dc_troca_vltab numeric, dc_troca_vl numeric, dc_troca_vldebcred numeric, dc_troca_percdebcred numeric, dc_vlextra numeric, dc_bonus_pv_vl numeric, dc_bonus_nf_vl numeric) LANGUAGE plpgsql AS $function$ DECLARE /* select * from f_calc_debcred(1, null,'2024-05-14','now()',null) where dc_rca_cod = 6369 Descrição: Função criada para calcular deb cred do vendedor 05/11/13 - KAYTON: Criação da função f_calc_debcred 13/05/14 - KAYTON: Implementação parametro periodo 28/06/14 - KAYTON: Corrigir bug nos pedidos não faturados - Adicionar opnf tipo VI - Se rca_d_debcred é null então DATE(now()) 27/05/15 - KAYTON: Adicionar campos de Devolução ao cálculo 08/06/16 - KAYTON: Uso dos campos pvibasedebcred e nfibasedebcred no lugar de pvibasedebcred e nfibasedebcred respectivamente. 24/08/17 - David: correção da quantidade na base de devolução 30/08/17 - David: correção do saldo, para considerar pv negativo 03/01/19 - Kayton: atribuir valor inicial para p_data1 e p_data2 10/01/21 - David: considerar bonificação e troca no saldo do deb/cred 17/11/22 - David: adicionar BV e TR nos dados dos pedidos; correção do valor de bonificação / troca; correção do saldo final; 19/11/22 - David: inserir pedidos AP no calculo de deb/cred; 15/05/23 - David: correção do sinal no creb/cred de devolução 10/05/24 - David: tratar rca_debcred_perc_bonus para adicionar um % especial de acordo com os pedidos/notas sem desconto 15/05/24 - David: Correção do Bonus 17/05/24 - David: Não calcular o bonus para produtos em promoção e desc por qtde 31/05/24 - David: tratar bonus para que seja somado caso de aumento mesmo se tiver promoção ou descqtde 03/06/24 - David: Correção do bonus para não usar em caso de promoção e descqtde sem aumentar o valor da venda */ p_empresa ALIAS FOR $1; p_vendedor ALIAS FOR $2; p_data1 ALIAS FOR $3; p_data2 ALIAS FOR $4; p_limite ALIAS FOR $5; /* */ rec_dc RECORD; BEGIN p_data1 := CASE WHEN p_data1 IS NOT NULL THEN p_data1 ELSE COALESCE(( SELECT rca_d_debcred FROM rca WHERE rcaparcod = p_vendedor), DATE(now())) END; p_data2 := CASE WHEN p_data2 IS NOT NULL THEN p_data2 ELSE DATE(now()) END; FOR rec_dc IN SELECT rcaparcod AS dc_rca_cod, COALESCE(p_limite, rcadclimite, 0) AS dc_limite, --SALDO --coalesce(p_limite,rcadclimite,0)+(coalesce(pv_vl,0)-coalesce(pv_basedebcred,0))+(coalesce(fat_vl,0)-coalesce(fat_basedebcred,0))-(coalesce(fat_basedebcred_dc,0)-coalesce(fat_vl_dc,0))+coalesce(vlextra,0) as dc_saldo, CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN COALESCE(p_limite, rcadclimite, 0)+ (COALESCE(pv_vl, 0)-COALESCE(pv_basedebcred, 0))+ (COALESCE(fat_vl, 0)-COALESCE(fat_basedebcred, 0))- (COALESCE(fat_vl_dc, 0)-COALESCE(fat_basedebcred_dc, 0))- (COALESCE(fat_vl_bo, 0))- (COALESCE(fat_vl_tr, 0))+ COALESCE(vlextra, 0)+ COALESCE(bonus_pv_cred_vl, 0)+ COALESCE(bonus_nf_cred_vl, 0) ELSE COALESCE(p_limite, rcadclimite, 0)+ (COALESCE(pv_vl, 0)-COALESCE(pv_basedebcred, 0))+ (COALESCE(fat_vl, 0)-COALESCE(fat_basedebcred, 0))- (COALESCE(fat_vl_dc, 0)-COALESCE(fat_basedebcred_dc, 0))+ COALESCE(vlextra, 0)+ COALESCE(bonus_pv_cred_vl, 0)+ COALESCE(bonus_nf_cred_vl, 0) END AS dc_saldo, --TOTAL CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0)-COALESCE(fat_basedebcred_bo, 0)-COALESCE(fat_basedebcred_tr, 0) ELSE COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0) END AS dc_basedebcred, CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN COALESCE(pv_vl, 0)+ COALESCE(fat_vl, 0)-COALESCE(fat_vl_bo, 0)-COALESCE(fat_vl_tr, 0) ELSE COALESCE(pv_vl, 0)+ COALESCE(fat_vl, 0) END AS dc_vl, CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN (COALESCE(pv_vl, 0)+ COALESCE(fat_vl, 0)-COALESCE(fat_vl_bo, 0)-COALESCE(fat_vl_tr, 0))-(COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0)-COALESCE(fat_basedebcred_bo, 0)-COALESCE(fat_basedebcred_tr, 0)) ELSE (COALESCE(pv_vl, 0)+ COALESCE(fat_vl, 0))-(COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0)) END AS dc_vldebcred, CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN CASE WHEN (COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0)-COALESCE(fat_basedebcred_bo, 0)-COALESCE(fat_basedebcred_tr, 0))>0 THEN round(((COALESCE(pv_vl, 0)+ COALESCE(fat_vl, 0)-COALESCE(fat_vl_bo, 0)-COALESCE(fat_vl_tr, 0))-(COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0)-COALESCE(fat_basedebcred_bo, 0)-COALESCE(fat_basedebcred_tr, 0)))/(COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0)-COALESCE(fat_basedebcred_bo, 0)-COALESCE(fat_basedebcred_tr, 0))* 100, 2) ELSE 0.00 END ELSE CASE WHEN (COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0))>0 THEN round(((COALESCE(pv_vl, 0)+ COALESCE(fat_vl, 0))-(COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0)))/(COALESCE(pv_basedebcred, 0)+ COALESCE(fat_basedebcred, 0))* 100, 2) ELSE 0.00 END END AS dc_percdebcred, --PV CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN COALESCE(pv_basedebcred, 0)+ COALESCE(pv_basedebcred_bo, 0)+ COALESCE(pv_basedebcred_tr, 0) ELSE COALESCE(pv_basedebcred, 0) END AS dc_pv_basedebcred, CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN COALESCE(pv_vl, 0)+ COALESCE(pv_vl_bo, 0)+ COALESCE(pv_vl_tr, 0) ELSE COALESCE(pv_vl, 0) END AS dc_pv_vl, CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN (COALESCE(pv_vl, 0)-COALESCE(pv_basedebcred, 0)) ELSE (COALESCE(pv_vl, 0)-COALESCE(pv_basedebcred, 0)-COALESCE(pv_vl_bo, 0)-COALESCE(pv_vl_tr, 0)) END AS dc_pv_vldebcred, CASE WHEN COALESCE(rca_usa_bonif_troca_dc, 'S')= 'S' THEN CASE WHEN COALESCE(pv_basedebcred, 0)>0 THEN round((COALESCE(pv_vl, 0)-COALESCE(pv_basedebcred, 0))/ COALESCE(pv_basedebcred, 0)* 100, 2) ELSE 0.00 END ELSE CASE WHEN COALESCE(pv_basedebcred, 0)>0 THEN round((COALESCE(pv_vl, 0)-COALESCE(pv_basedebcred, 0)-COALESCE(pv_vl_bo, 0)-COALESCE(pv_vl_tr, 0))/ COALESCE(pv_basedebcred, 0)* 100, 2) ELSE 0.00 END END AS dc_pv_percdebcred, --FAT COALESCE(fat_basedebcred, 0) AS dc_fat_basedebcred, -- errado COALESCE(fat_vl, 0) AS dc_fat_vl, (COALESCE(fat_vl, 0)-COALESCE(fat_basedebcred, 0)) AS dc_fat_vldebcred, CASE WHEN COALESCE(fat_basedebcred, 0)>0 THEN round((COALESCE(fat_vl, 0)-COALESCE(fat_basedebcred, 0))/ COALESCE(fat_basedebcred, 0)* 100, 2) ELSE 0.00 END AS dc_fat_percdebcred, --DEVOL COALESCE(fat_basedebcred_dc, 0) AS dc_devol_basedebcred, COALESCE(fat_vl_dc, 0) AS dc_devol_vl, (COALESCE(fat_vl_dc, 0)-COALESCE(fat_basedebcred_dc, 0)) AS dc_devol_vldebcred, --(coalesce(fat_basedebcred_dc,0)-coalesce(fat_vl_dc,0)) as dc_devol_vldebcred, --case when coalesce(fat_basedebcred_dc,0)>0 then round((coalesce(fat_vl_dc,0)-coalesce(fat_basedebcred_dc,0))/coalesce(fat_basedebcred_dc,0)*100,2) else 0.00 end as dc_devol_percdebcred, CASE WHEN COALESCE(fat_basedebcred_dc, 0)>0 THEN round((COALESCE(fat_basedebcred_dc, 0)-COALESCE(fat_vl_dc, 0))/ COALESCE(fat_basedebcred_dc, 0)* 100, 2) ELSE 0.00 END AS dc_devol_percdebcred, --BONIF COALESCE(fat_basedebcred_bo, 0) AS dc_bonif_basedebcred, COALESCE(fat_vl_bo, 0) AS dc_bonif_vl, (COALESCE(fat_vl_bo, 0)) AS dc_bonif_vldebcred, CASE WHEN COALESCE(fat_basedebcred_bo, 0)>0 THEN round((COALESCE(fat_vl_bo, 0)-COALESCE(fat_basedebcred_bo, 0))/ COALESCE(fat_basedebcred_bo, 0)* 100, 2) ELSE 0.00 END AS dc_bonif_percdebcred, --TROCA COALESCE(fat_basedebcred_tr, 0) AS dc_troca_basedebcred, COALESCE(fat_vl_tr, 0) AS dc_troca_vl, (COALESCE(fat_vl_tr, 0)) AS dc_troca_vldebcred, CASE WHEN COALESCE(fat_basedebcred_tr, 0)>0 THEN round((COALESCE(fat_vl_tr, 0)-COALESCE(fat_basedebcred_tr, 0))/ COALESCE(fat_basedebcred_tr, 0)* 100, 2) ELSE 0.00 END AS dc_troca_percdebcred, --EXTRA COALESCE(vlextra, 0) AS dc_extra_vl, --Bonus COALESCE(bonus_pv_cred_vl, 0) AS dc_bonus_pv_vl, COALESCE(bonus_nf_cred_vl, 0) AS dc_bonus_nf_vl FROM rca --Pedido LEFT JOIN ( SELECT pv_rca_cod, round(sum(pv_basedebcred), 2) AS pv_basedebcred, round(sum(pv_vl), 2) AS pv_vl FROM sd.vw_pv WHERE DATE(pv_dtlan) BETWEEN p_data1 AND p_data2 AND pv_opnf_tipo IN ('VE', 'VI', 'VV') AND pv_sta NOT IN ('EX', 'FT') AND CASE WHEN p_vendedor IS NOT NULL THEN pv_rca_cod = p_vendedor ELSE 1 = 1 END GROUP BY pv_rca_cod ) AS dcpv ON rcaparcod = dcpv.pv_rca_cod --Pedido bonificação/troca LEFT JOIN ( SELECT pv_rca_cod, round(sum(pv_basedebcred_bo), 2) AS pv_basedebcred_bo, round(sum(pv_vl_bo), 2) AS pv_vl_bo, round(sum(pv_basedebcred_tr), 2) AS pv_basedebcred_tr, round(sum(pv_vl_tr), 2) AS pv_vl_tr FROM sd.vw_pv WHERE DATE(pv_dtlan) BETWEEN p_data1 AND p_data2 AND pv_opnf_tipo IN ('BV', 'TR') AND pv_sta NOT IN ('EX', 'FT') AND CASE WHEN p_vendedor IS NOT NULL THEN pv_rca_cod = p_vendedor ELSE 1 = 1 END GROUP BY pv_rca_cod ) AS dcpvbotr ON rcaparcod = dcpvbotr.pv_rca_cod --Faturado LEFT JOIN ( SELECT fat_rca_cod, round(sum(fat_basedebcred), 2) AS fat_basedebcred, round(sum(fat_vl), 2) AS fat_vl, round(sum(fat_basedebcred_dc), 2) AS fat_basedebcred_dc, round(sum(fat_vl_dc), 2) AS fat_vl_dc FROM sd.vw_fat WHERE fat_nf_sta NOT IN ('EX') AND fat_opnf_tipo IN ('VE', 'VI', 'VV', 'DC') AND DATE(fat_nf_dtemi) BETWEEN p_data1 AND p_data2 AND CASE WHEN p_vendedor IS NOT NULL THEN fat_rca_cod = p_vendedor ELSE 1 = 1 END GROUP BY fat_rca_cod ) AS dcfat ON rcaparcod = dcfat.fat_rca_cod --Bonificação / troca LEFT JOIN ( SELECT fat_rca_cod AS boniftr_rca_cod, round(sum(fat_basedebcred_bo), 2) AS fat_basedebcred_bo, round(sum(fat_vl_bo), 2) AS fat_vl_bo, round(sum(fat_basedebcred_tr), 2) AS fat_basedebcred_tr, round(sum(fat_vl_tr), 2) AS fat_vl_tr FROM sd.vw_fat WHERE fat_nf_sta NOT IN ('EX') AND fat_opnf_tipo IN ('BV', 'TR') AND DATE(fat_nf_dtemi) BETWEEN p_data1 AND p_data2 AND CASE WHEN p_vendedor IS NOT NULL THEN fat_rca_cod = p_vendedor ELSE 1 = 1 END GROUP BY fat_rca_cod ) AS dcfatbotc ON rcaparcod = dcfatbotc.boniftr_rca_cod --Extra LEFT JOIN ( SELECT rcamvrcaparcod, sum(CASE WHEN rcamvnatureza = 'D' THEN -rcamvvalor ELSE rcamvvalor END) AS vlextra FROM rcamv JOIN rca ON rcamvrcaparcod = rcaparcod WHERE rcamvsta = 'A' AND DATE(rcamvdtlanc) BETWEEN p_data1 AND p_data2 AND CASE WHEN p_vendedor IS NOT NULL THEN rcamvrcaparcod = p_vendedor ELSE 1 = 1 END GROUP BY rcamvrcaparcod ) AS dcextra ON rcaparcod = dcextra.rcamvrcaparcod --Bonus PV LEFT JOIN ( SELECT bonus_pv_rca_cod, sum(bonus_pv_cred_vl) AS bonus_pv_cred_vl FROM ( SELECT pv_rca_cod AS bonus_pv_rca_cod, round(sum(pv_basedebcred), 2) AS bonus_pv_basedebcred, round(sum(pv_vl), 2) AS bonus_pv_vl, COALESCE(pvidescqtdecod, 0) AS pvidescqtdecod, COALESCE(pvipromcod, 0) AS pvipromcod, CASE WHEN ((COALESCE(pvidescqtdecod, 0) <> 0 OR COALESCE(pvipromcod, 0) <> 0) AND (round(sum(pv_vl),2) - round(sum(pv_basedebcred),2) = 0)) THEN 0 WHEN (round(sum(pv_vl), 2) - round(sum(pv_basedebcred), 2) >= 0) THEN round(sum((pv_vl * rca_debcred_perc_bonus)/ 100), 2) ELSE 0 END AS bonus_pv_cred_vl FROM sd.vw_pv JOIN rca ON pv_rca_cod = rcaparcod LEFT JOIN pv ON pv_cod = pvcod LEFT JOIN pvi ON pvcod = pvipvcod AND pv_pro_cod = pviprocod AND pv_uve_cod = pviuvecod WHERE DATE(pv_dtlan) BETWEEN p_data1 AND p_data2 AND pv_opnf_tipo IN ('VE', 'VI', 'VV') AND pv_sta NOT IN ('EX', 'FT') AND CASE WHEN p_vendedor IS NOT NULL THEN pv_rca_cod = p_vendedor ELSE 1 = 1 END --and (pvipromcod is null or pvipromcod = 0) --and (pvidescqtdecod is null or pvidescqtdecod = 0) GROUP BY pv_rca_cod, pv_cod, pvidescqtdecod, pvipromcod)a GROUP BY bonus_pv_rca_cod ) AS dcbonuspv ON rcaparcod = dcbonuspv.bonus_pv_rca_cod --Bonus NF LEFT JOIN ( SELECT bonus_fat_rca_cod, sum(bonus_nf_cred_vl) AS bonus_nf_cred_vl FROM ( SELECT fat_rca_cod AS bonus_fat_rca_cod, round(sum(fat_basedebcred), 2) AS bonus_fat_basedebcred, round(sum(fat_vl), 2) AS bonus_fat_vl, COALESCE(pvidescqtdecod, 0) AS pvidescqtdecod, COALESCE(pvipromcod, 0) AS pvipromcod, CASE WHEN ((COALESCE(pvidescqtdecod,0) <> 0 OR COALESCE(pvipromcod,0) <> 0) AND (round(sum(fat_vl),2) - round(sum(fat_basedebcred),2) = 0)) THEN 0 WHEN (round(sum(fat_vl),2) - round(sum(fat_basedebcred),2) >= 0) THEN round(sum((fat_vl * rca_debcred_perc_bonus)/ 100),2) ELSE 0 END AS bonus_nf_cred_vl FROM sd.vw_fat JOIN nf ON fat_nf_cod = nfcod LEFT JOIN pv ON nfpvcod = pvcod LEFT JOIN pvi ON pvcod = pvipvcod AND fat_pro_cod = pviprocod AND fat_uve_cod = pviuvecod JOIN rca ON fat_rca_cod = rcaparcod WHERE fat_nf_sta NOT IN ('EX') AND fat_opnf_tipo IN ('VE', 'VI', 'VV', 'DC') AND DATE(fat_nf_dtemi) BETWEEN p_data1 AND p_data2 AND CASE WHEN p_vendedor IS NOT NULL THEN fat_rca_cod = p_vendedor ELSE 1 = 1 END --and (pvipromcod is null or pvipromcod = 0) --and (pvidescqtdecod is null or pvidescqtdecod = 0) GROUP BY fat_rca_cod, fat_nf_cod, pvidescqtdecod, pvipromcod)a GROUP BY bonus_fat_rca_cod ) AS dcbonusnf ON rcaparcod = dcbonusnf.bonus_fat_rca_cod WHERE rcausadebcred = 'S' AND CASE WHEN p_vendedor IS NOT NULL THEN rcaparcod = p_vendedor ELSE 1 = 1 END ORDER BY rcaparcod LOOP RETURN QUERY SELECT rec_dc.dc_rca_cod , rec_dc.dc_limite , rec_dc.dc_saldo , rec_dc.dc_basedebcred , rec_dc.dc_vl , rec_dc.dc_vldebcred , rec_dc.dc_percdebcred , rec_dc.dc_pv_basedebcred , rec_dc.dc_pv_vl , rec_dc.dc_pv_vldebcred , rec_dc.dc_pv_percdebcred , rec_dc.dc_fat_basedebcred , rec_dc.dc_fat_vl , rec_dc.dc_fat_vldebcred , rec_dc.dc_fat_percdebcred , rec_dc.dc_devol_basedebcred , rec_dc.dc_devol_vl , rec_dc.dc_devol_vldebcred , rec_dc.dc_devol_percdebcred , rec_dc.dc_bonif_basedebcred , rec_dc.dc_bonif_vl , rec_dc.dc_bonif_vldebcred , rec_dc.dc_bonif_percdebcred , rec_dc.dc_troca_basedebcred , rec_dc.dc_troca_vl , rec_dc.dc_troca_vldebcred , rec_dc.dc_troca_percdebcred , rec_dc.dc_extra_vl , rec_dc.dc_bonus_pv_vl , rec_dc.dc_bonus_nf_vl RETURN; END LOOP; RETURN; END; $function$ ; -- Permissions ALTER FUNCTION public.f_calc_debcred(int4, int4, date, date, numeric) OWNER TO postgres; GRANT ALL ON FUNCTION public.f_calc_debcred(int4, int4, date, date, numeric) TO public; GRANT ALL ON FUNCTION public.f_calc_debcred(int4, int4, date, date, numeric) TO postgres; ------------------------------------------------------------------------------------------------ -- sd.vw_pv source CREATE OR REPLACE VIEW sd.vw_pv AS SELECT pv.pvcod AS pv_cod, pv.pvsta AS pv_sta, pv.pvopnfcod AS pv_opnf_cod, opnf.opnfdes AS pv_opnf_des, CASE WHEN opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN 'BV'::bpchar ELSE opnf.opnftopnfcod END::character(2) AS pv_opnftipo_cod, CASE WHEN opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN 'BV'::bpchar ELSE opnf.opnftopnfcod END::character(2) AS pv_opnf_tipo, topnf.topnfdes AS pv_opnftipo_des, pv.pvcadhorario::date AS pv_dtlan, pv.pvcadhorario::time without time zone AS pv_hlan, pv.pvempparcod AS pv_emp_cod, emp.pardes AS pv_emp_des, emp.parfan AS pv_emp_fan, pv.pvcliparcod AS pv_par_cod, cli.pardes AS pv_par_des, cli.parfan AS pv_par_fan, CASE WHEN conf.conffantasiarazao = 'F'::bpchar THEN cli.parfan ELSE cli.pardes END AS pv_par_despadrao, pv.pvplpgcod AS pv_plpg_cod, plpg.plpgdes AS pv_plpg_des, pv.pvtccod AS pv_tc_cod, tc.tcdes AS pv_tc_des, pv.pvrcaparcod AS pv_rca_cod, rca.pardes AS pv_rca_des, rca.parfan AS pv_rca_fan, cr.crcod AS pv_cr_cod, cr.crdes AS pv_cr_des, pro.procod AS pv_pro_cod, pro.prodes AS pv_pro_des, uve.uvecod AS pv_uve_cod, uve.uvedes AS pv_uve_des, uve.uveun AS pv_uve_un, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN pvi.pviqtdeate ELSE NULL::numeric END AS pv_qt, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(pvi.pvivltab, 4) ELSE NULL::numeric END AS pv_vltabunit, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(pvi.pvibasedebcred, 4) ELSE 0::numeric END AS pv_basedebcredunit, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(pvi.pvivlven, 4) ELSE NULL::numeric END AS pvi_vlunit, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(pvi.pvivltab, 2) * pvi.pviqtdeatecar ELSE NULL::numeric END AS pv_vltab, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(pvi.pvibasedebcred, 2) * pvi.pviqtdeatecar ELSE 0::numeric END AS pv_basedebcred, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(pvi.pvivlven * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vl, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(pvi.pvicustoreal * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_custo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(0::numeric, 4) ELSE NULL::numeric END AS pv_cmv, CASE WHEN pv.pvsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(uve.uvepesoliq * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_pesoliq, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN pvi.pviqtdeate ELSE NULL::numeric END AS pv_qt_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(pvi.pvivltab, 4) ELSE NULL::numeric END AS pv_vltabunit_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(pvi.pvibasedebcred, 4) ELSE NULL::numeric END AS pv_basedebcredunit_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(pvi.pvivlven, 4) ELSE NULL::numeric END AS pvi_vlunit_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(pvi.pvivltab * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vltab_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(pvi.pvibasedebcred * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_basedebcred_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(pvi.pvivlven * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vl_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(pvi.pvicustoreal * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_custo_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(0::numeric, 4) ELSE NULL::numeric END AS pv_cmv_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(uve.uvepesoliq * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_pesoliq_bo, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN pvi.pviqtdeate ELSE NULL::numeric END AS pv_qt_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(pvi.pvivltab, 4) ELSE NULL::numeric END AS pv_vltabunit_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(pvi.pvibasedebcred, 4) ELSE NULL::numeric END AS pv_basedebcredunit_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(pvi.pvivlven, 4) ELSE NULL::numeric END AS pvi_vlunit_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(pvi.pvivltab * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vltab_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(pvi.pvibasedebcred * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_basedebcred_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(pvi.pvivlven * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vl_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(pvi.pvicustoreal * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_custo_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(0::numeric, 4) ELSE NULL::numeric END AS pv_cmv_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(uve.uvepesoliq * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_pesoliq_tr, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN pvi.pviqtdeate ELSE NULL::numeric END AS pv_qt_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(pvi.pvivltab, 4) ELSE NULL::numeric END AS pv_vltabunit_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(pvi.pvivlven, 4) ELSE NULL::numeric END AS pvi_vlunit_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(pvi.pvivltab * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vltab_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(pvi.pvibasedebcred * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_basedebcred_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(pvi.pvivlven * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vl_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(pvi.pvicustoreal * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_custo_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(0::numeric, 4) ELSE NULL::numeric END AS pv_cmv_dc, CASE WHEN pv.pvsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(uve.uvepesoliq * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_pesoliq_dc, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN pvi.pviqtdeate ELSE NULL::numeric END AS pv_qt_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(pvi.pvivltab, 4) ELSE NULL::numeric END AS pv_vltabunit_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(pvi.pvivlven, 4) ELSE NULL::numeric END AS pvi_vlunit_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(pvi.pvivltab * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vltab_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(pvi.pvibasedebcred * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_basedebcred_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(pvi.pvivlven * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_vl_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(pvi.pvicustoreal * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_custo_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(0::numeric, 4) ELSE NULL::numeric END AS pv_cmv_ex, CASE WHEN pv.pvsta = 'EX'::bpchar AND opnf.opnftopnfcod = 'EX'::bpchar THEN round(uve.uvepesoliq * pvi.pviqtdeatecar, 4) ELSE NULL::numeric END AS pv_pesoliq_ex, pv.pvsupparcod AS pv_sup_cod, sup.pardes AS pv_sup_des, sup.parfan AS pv_sup_fan, pv.pvcadusuparcod AS pv_usu_cod, fun.pardes AS pv_usu_des, fun.parfan AS pv_usu_fan, ( SELECT fpe.fpeforparcod FROM fpe WHERE fpe.fpeempparcod = pv.pvempparcod AND fpe.fpeprocod = pvi.pviprocod AND fpe.fpetipo = 'P'::bpchar ORDER BY fpe.fpeforparcod DESC LIMIT 1) AS pv_forn_cod, ( SELECT par.pardes FROM fpe JOIN par ON fpe.fpeforparcod = par.parcod WHERE fpe.fpeempparcod = pv.pvempparcod AND fpe.fpeprocod = pvi.pviprocod AND fpe.fpetipo = 'P'::bpchar ORDER BY fpe.fpeforparcod DESC LIMIT 1) AS pv_forn_des, ( SELECT par.parfan FROM fpe JOIN par ON fpe.fpeforparcod = par.parcod WHERE fpe.fpeempparcod = pv.pvempparcod AND fpe.fpeprocod = pvi.pviprocod AND fpe.fpetipo = 'P'::bpchar ORDER BY fpe.fpeforparcod DESC LIMIT 1) AS pv_forn_fan, depp.deppcod AS pv_depp_cod, depp.deppdes AS pv_depp_des, secp.secpcod AS pv_secp_cod, secp.secpdes AS pv_secp_des, cat.catcod AS pv_cat_cod, cat.catdes AS pv_cat_des, scat.scatcod AS pv_scat_cod, scat.scatdes AS pv_scat_des, marcas.marcascod AS pv_marcas_cod, marcas.marcasdes AS pv_marcas_des, fam.famcod AS pv_fam_cod, fam.famdes AS pv_fam_des, app.appcod AS pv_app_cod, app.appdes AS pv_app_des, cliente_grupo.cg_codigo AS pv_grupocli_cod, cliente_grupo.cg_descricao AS pv_grupocli_des, loc.loccod AS pv_loc_cod, loc.locdes AS pv_loc_des, ra.racod AS pv_ra_cod, ra.rades AS pv_ra_des, area_venda.av_codigo AS pv_av_cod, area_venda.av_descricao AS pv_av_des, pv.pvcarcod AS pv_carreg_cod, 0 AS pv_vei_cod, ''::text AS pv_vei_des, 0 AS pv_mot_cod, ''::text AS pv_mot_des, ''::text AS pv_mot_fan, c.clipromparcod AS pv_prom_cod, 0 AS pv_rca_comisscod, 0 AS pv_rca_perccom, 0 AS pv_sup_comisscod, 0 AS pv_sup_perccom, 0 AS pv_mot_comisscod, 0 AS pv_mot_perccom, 0 AS pv_prom_comisscod, 0 AS pv_prom_perccom, 'A'::text AS pv_prazo, 0 AS pv_prazomed, round(pvi.pviqtde * pvi.pvivlven, 4) - round(pvi.pviqtdeate * pvi.pvivlven, 4) AS pv_vlfalta, round(pvi.pviqtdeate * pvi.pvivlven, 4) - round(pvi.pviqtdeatecar * pvi.pvivlven, 4) AS pv_vlcorte, round(pvi.pviqtde, 4) - round(pvi.pviqtdeate, 4) AS pv_qtfalta, round(pvi.pviqtdeate, 4) - round(pvi.pviqtdeatecar, 4) AS pv_qtcorte, pv.pvpdvnum AS pv_pdv_num, pv.pvcupnum AS pv_pdv_cupnum, mun.munufsigla AS pv_par_uf, pvi.pvimetrocubico, pvi.pvipromcod AS pv_promocao_cod FROM pv JOIN pvi ON pvi.pvipvcod = pv.pvcod AND pvi.pvipvempparcod = pv.pvempparcod JOIN opnf ON pv.pvopnfcod = opnf.opnfcod AND opnf.opnfsta <> 'C'::bpchar AND (pv.pvsta = ANY (ARRAY['AA'::bpchar, 'MP'::bpchar, 'MT'::bpchar, 'FT'::bpchar])) JOIN topnf ON opnf.opnftopnfcod = topnf.topnfcod JOIN par emp ON pv.pvempparcod = emp.parcod JOIN par cli ON pv.pvcliparcod = cli.parcod JOIN plpg ON pv.pvplpgcod = plpg.plpgcod JOIN tc ON pv.pvtccod = tc.tccod JOIN cli c ON pv.pvcliparcod = c.cliparcod JOIN par fun ON pv.pvcadusuparcod = fun.parcod JOIN pro ON pvi.pviprocod = pro.procod JOIN uve ON pvi.pviuvecod = uve.uvecod AND pvi.pviprocod = uve.uveprocod JOIN est ON pro.procod = est.estprocod AND est.estempparcod = pv.pvempparcod JOIN app ON est.estappcod = app.appcod LEFT JOIN scat ON pro.proscatcod = scat.scatcod LEFT JOIN cat ON pro.procatcod = cat.catcod LEFT JOIN secp ON pro.prosecpcod = secp.secpcod LEFT JOIN depp ON pro.prodeppcod = depp.deppcod LEFT JOIN marcas ON pro.promarcascod = marcas.marcascod LEFT JOIN fam ON pro.profamcod = fam.famcod LEFT JOIN par rca ON pv.pvrcaparcod = rca.parcod LEFT JOIN rca r ON rca.parcod = r.rcaparcod LEFT JOIN cr ON r.rcacrcod = cr.crcod LEFT JOIN par sup ON pv.pvsupparcod = sup.parcod LEFT JOIN cliente_grupo ON c.cli_cg_codigo = cliente_grupo.cg_codigo LEFT JOIN loc ON c.cliloccod = loc.loccod LEFT JOIN area_venda ON c.cli_av_codigo = area_venda.av_codigo LEFT JOIN ra ON c.cliracod = ra.racod LEFT JOIN mun ON c.climuncodent = mun.muncod LEFT JOIN conf ON pv.pvempparcod = conf.confempparcod; -- Permissions ALTER TABLE sd.vw_pv OWNER TO postgres; GRANT ALL ON TABLE sd.vw_pv TO postgres; GRANT SELECT ON TABLE sd.vw_pv TO consulta; ------------------------------------------------------------------------------------------------ -- sd.vw_fat source CREATE OR REPLACE VIEW sd.vw_fat AS SELECT nf.nfcod AS fat_nf_cod, nf.nfnum AS fat_nf_num, nf.nfserie AS fat_nf_serie, nf.nfsta AS fat_nf_sta, nf.nfopnfcod AS fat_opnf_cod, opnf.opnfdes AS fat_opnf_des, CASE WHEN opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN 'BV'::bpchar ELSE opnf.opnftopnfcod END::character(2) AS fat_opnftipo_cod, CASE WHEN opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN 'BV'::bpchar ELSE opnf.opnftopnfcod END::character(2) AS fat_opnf_tipo, topnf.topnfdes AS fat_opnftipo_des, nf.nfdtemi AS fat_nf_dtemi, nf.nfdtsai AS fat_nf_dtsai, nf.nfcadhorario::date AS fat_nf_dtlan, nf.nfcadhorario::time without time zone AS fat_nf_hlan, nf.nfempparcod AS fat_emp_cod, emp.pardes AS fat_emp_des, emp.parfan AS fat_emp_fan, nf.nfparcod AS fat_par_cod, par.pardes AS fat_par_des, par.parfan AS fat_par_fan, CASE WHEN conf.conffantasiarazao = 'F'::bpchar THEN par.parfan ELSE par.pardes END AS fat_par_despadrao, nf.nfplpgcod AS fat_plpg_cod, plpg.plpgdes AS fat_plpg_des, nf.nftccod AS fat_tc_cod, tc.tcdes AS fat_tc_des, nf.nfrcaparcod AS fat_rca_cod, rca.pardes AS fat_rca_des, rca.parfan AS fat_rca_fan, cr.crcod AS fat_cr_cod, cr.crdes AS fat_cr_des, pro.procod AS fat_pro_cod, pro.prodes AS fat_pro_des, uve.uvecod AS fat_uve_cod, uve.uvedes AS fat_uve_des, uve.uveun AS fat_uve_un, nfi.nfipuvecod AS fat_puve_cod, nfi.nfipuvedes AS fat_puve_des, nfi.nfipuveun AS fat_puve_un, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfipqtde ELSE NULL::numeric END AS fat_pqt, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfipvltabunit, 4) ELSE NULL::numeric END AS fat_pvltabunit, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfipvlunit, 4) ELSE NULL::numeric END AS fat_pvlunit, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfiqtde * uve.uvepesoliq, 4) ELSE NULL::numeric END AS fat_pesoliq, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfiqtde ELSE NULL::numeric END AS fat_qt, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfiqtde * nfi.nfiuvemult ELSE NULL::numeric END AS fat_qtmult, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivltabunit, 4) ELSE NULL::numeric END AS fat_vltabunit, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfibasedebcred, 4) ELSE NULL::numeric END AS fat_basedebcredunit, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivlunit, 4) ELSE NULL::numeric END AS fat_vlunit, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivltabunit, 2) * nfi.nfiqtde ELSE NULL::numeric END AS fat_vltab, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfibasedebcred, 2) * nfi.nfiqtde ELSE NULL::numeric END AS fat_basedebcred, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivl, 4) ELSE NULL::numeric END AS fat_vl, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nficustocompra, 4) ELSE NULL::numeric END AS fat_custo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nficustoreal, 4) ELSE NULL::numeric END AS fat_custoreal, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetrcaperccom / 100.0 ELSE NULL::numeric END AS fat_vlcom, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetpercfrete / 100.0 ELSE NULL::numeric END AS fat_vlfrete, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetperccomercial / 100.0 ELSE NULL::numeric END AS fat_vlcomerc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_vloutrasdesp, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_cmvvldespvenda, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlicms ELSE NULL::numeric END AS fat_vlicms, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlicmsefet ELSE NULL::numeric END AS fat_vlicms_efet, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlpis ELSE NULL::numeric END AS fat_vlpis, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlcofins ELSE NULL::numeric END AS fat_vlcofins, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlipi ELSE NULL::numeric END AS fat_vlipi, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) ELSE NULL::numeric END AS fat_cmvvlimposto, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(round(nfi.nficustoreal, 4), 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0, 0::numeric) + COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) ELSE NULL::numeric END AS fat_cmv, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetpercdespfixa / 100.0 ELSE NULL::numeric END AS fat_prevvldespfixa, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN (nfi.nfivl - CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(round(nfi.nficustoreal, 4), 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0, 0::numeric) + COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercdespfixa / 100.0, 0::numeric) ELSE NULL::numeric END) * nfidet.nfidetpercirpj / 100.0 ELSE NULL::numeric END AS fat_prevvlirpj, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN (nfi.nfivl - CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(round(nfi.nficustoreal, 4), 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0, 0::numeric) + COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercdespfixa / 100.0, 0::numeric) ELSE NULL::numeric END) * nfidet.nfidetperccsll / 100.0 ELSE NULL::numeric END AS fat_prevvlcsll, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlicmsst ELSE NULL::numeric END AS fat_vlicmsst, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetrcacomisscod ELSE NULL::integer END AS fat_rca_comisscod, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetrcaperccom ELSE NULL::numeric END AS fat_rca_perccom, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetsupcomisscod ELSE NULL::integer END AS fat_sup_comisscod, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetsupperccom ELSE NULL::numeric END AS fat_sup_perccom, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetmotcomisscod ELSE NULL::integer END AS fat_mot_comisscod, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetmotperccom ELSE NULL::numeric END AS fat_mot_perccom, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetpromcomisscod ELSE NULL::integer END AS fat_prom_comisscod, CASE WHEN nf.nfsta <> 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetpromperccom ELSE NULL::numeric END AS fat_prom_perccom, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN nfi.nfipqtde ELSE NULL::numeric END AS fat_pqt_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(nfi.nfipvltabunit, 4) ELSE NULL::numeric END AS fat_pvltabunit_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar THEN round(nfi.nfipvlunit, 4) ELSE NULL::numeric END AS fat_pvlunit_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nfiqtde * uve.uvepesoliq, 4) ELSE NULL::numeric END AS fat_pesoliq_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfiqtde ELSE NULL::numeric END AS fat_qt_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfiqtde * nfi.nfiuvemult ELSE NULL::numeric END AS fat_qtmult_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nfivltabunit, 4) ELSE NULL::numeric END AS fat_vltabunit_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nfibasedebcred, 4) ELSE NULL::numeric END AS fat_basedebcredunit_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nfivlunit, 4) ELSE NULL::numeric END AS fat_vlunit_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nfivltabunit * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_vltab_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nfibasedebcred * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_basedebcred_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nfivl, 4) ELSE NULL::numeric END AS fat_vl_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nficustocompra, 4) ELSE NULL::numeric END AS fat_custo_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN round(nfi.nficustoreal, 4) ELSE NULL::numeric END AS fat_custoreal_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivl * nfidet.nfidetrcaperccom / 100.0 ELSE NULL::numeric END AS fat_vlcom_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivl * nfidet.nfidetpercfrete / 100.0 ELSE NULL::numeric END AS fat_vlfrete_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivl * nfidet.nfidetperccomercial / 100.0 ELSE NULL::numeric END AS fat_vlcomerc_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_vloutrasdesp_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_cmvvldespvenda_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivlicms ELSE NULL::numeric END AS fat_vlicms_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivlicmsefet ELSE NULL::numeric END AS fat_vlicms_efet_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivlpis ELSE NULL::numeric END AS fat_vlpis_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivlcofins ELSE NULL::numeric END AS fat_vlcofins_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivlipi ELSE NULL::numeric END AS fat_vlipi_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmvvlimposto_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN COALESCE(round(nfi.nficustoreal, 4), 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0, 0::numeric) + COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmv_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivl * nfidet.nfidetpercdespfixa / 100.0 ELSE NULL::numeric END AS fat_prevvldespfixa_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivl * nfidet.nfidetpercirpj / 100.0 ELSE NULL::numeric END AS fat_prevvlirpj_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivl * nfidet.nfidetperccsll / 100.0 ELSE NULL::numeric END AS fat_prevvlcsll_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfi.nfivlicmsst ELSE NULL::numeric END AS fat_vlicmsst_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetrcacomisscod ELSE NULL::integer END AS fat_rca_comisscod_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetrcaperccom ELSE NULL::numeric END AS fat_rca_perccom_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetsupcomisscod ELSE NULL::integer END AS fat_sup_comisscod_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetsupperccom ELSE NULL::numeric END AS fat_sup_perccom_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetmotcomisscod ELSE NULL::integer END AS fat_mot_comisscod_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetmotperccom ELSE NULL::numeric END AS fat_mot_perccom_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetpromcomisscod ELSE NULL::integer END AS fat_prom_comisscod_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'BO'::bpchar AND opnf.opnfnat = 'S'::bpchar THEN nfidet.nfidetpromperccom ELSE NULL::numeric END AS fat_prom_perccom_bo, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfipqtde ELSE NULL::numeric END AS fat_pqt_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfipvltabunit, 4) ELSE NULL::numeric END AS fat_pvltabunit_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfipvlunit, 4) ELSE NULL::numeric END AS fat_pvlunit_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfiqtde * uve.uvepesoliq, 4) ELSE NULL::numeric END AS fat_pesoliq_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfiqtde ELSE NULL::numeric END AS fat_qt_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfiqtde * nfi.nfiuvemult ELSE NULL::numeric END AS fat_qtmult_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfivltabunit, 4) ELSE NULL::numeric END AS fat_vltabunit_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfibasedebcred, 4) ELSE NULL::numeric END AS fat_basedebcredunit_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfivlunit, 4) ELSE NULL::numeric END AS fat_vlunit_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfivltabunit * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_vltab_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfibasedebcred * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_basedebcred_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nfivl, 4) ELSE NULL::numeric END AS fat_vl_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nficustocompra, 4) ELSE NULL::numeric END AS fat_custo_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN round(nfi.nficustoreal, 4) ELSE NULL::numeric END AS fat_custoreal_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivl * nfidet.nfidetrcaperccom / 100.0 ELSE NULL::numeric END AS fat_vlcom_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivl * nfidet.nfidetpercfrete / 100.0 ELSE NULL::numeric END AS fat_vlfrete_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivl * nfidet.nfidetperccomercial / 100.0 ELSE NULL::numeric END AS fat_vlcomerc_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_vloutrasdesp_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_cmvvldespvenda_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivlicms ELSE NULL::numeric END AS fat_vlicms_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivlicmsefet ELSE NULL::numeric END AS fat_vlicms_efet_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivlpis ELSE NULL::numeric END AS fat_vlpis_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivlcofins ELSE NULL::numeric END AS fat_vlcofins_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivlipi ELSE NULL::numeric END AS fat_vlipi_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmvvlimposto_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN COALESCE(round(nfi.nficustoreal, 4), 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0, 0::numeric) + COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmv_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivl * nfidet.nfidetpercdespfixa / 100.0 ELSE NULL::numeric END AS fat_prevvldespfixa_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivl * nfidet.nfidetpercirpj / 100.0 ELSE NULL::numeric END AS fat_prevvlirpj_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivl * nfidet.nfidetperccsll / 100.0 ELSE NULL::numeric END AS fat_prevvlcsll_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfi.nfivlicmsst ELSE NULL::numeric END AS fat_vlicmsst_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetrcacomisscod ELSE NULL::integer END AS fat_rca_comisscod_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetrcaperccom ELSE NULL::numeric END AS fat_rca_perccom_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetsupcomisscod ELSE NULL::integer END AS fat_sup_comisscod_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetsupperccom ELSE NULL::numeric END AS fat_sup_perccom_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetmotcomisscod ELSE NULL::integer END AS fat_mot_comisscod_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetmotperccom ELSE NULL::numeric END AS fat_mot_perccom_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetpromcomisscod ELSE NULL::integer END AS fat_prom_comisscod_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'TR'::bpchar THEN nfidet.nfidetpromperccom ELSE NULL::numeric END AS fat_prom_perccom_tr, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfipqtde ELSE NULL::numeric END AS fat_pqt_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfipvltabunit, 4) ELSE NULL::numeric END AS fat_pvltabunit_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfipvlunit, 4) ELSE NULL::numeric END AS fat_pvlunit_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfiqtde * uve.uvepesoliq, 4) ELSE NULL::numeric END AS fat_pesoliq_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfiqtde ELSE NULL::numeric END AS fat_qt_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfiqtde * nfi.nfiuvemult ELSE NULL::numeric END AS fat_qtmult_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfivltabunit, 4) ELSE NULL::numeric END AS fat_vltabunit_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfibasedebcred, 4) ELSE NULL::numeric END AS fat_basedebcredunit_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfivlunit, 4) ELSE NULL::numeric END AS fat_vlunit_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfivltabunit * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_vltab_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfibasedebcred * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_basedebcred_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nfivl, 4) ELSE NULL::numeric END AS fat_vl_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nficustocompra, 4) ELSE NULL::numeric END AS fat_custo_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN round(nfi.nficustoreal, 4) ELSE NULL::numeric END AS fat_custoreal_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivl * nfidet.nfidetrcaperccom / 100.0 ELSE NULL::numeric END AS fat_vlcom_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivl * nfidet.nfidetpercfrete / 100.0 ELSE NULL::numeric END AS fat_vlfrete_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivl * nfidet.nfidetperccomercial / 100.0 ELSE NULL::numeric END AS fat_vlcomerc_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_vloutrasdesp_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_cmvvldespvenda_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivlicms ELSE NULL::numeric END AS fat_vlicms_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivlicmsefet ELSE NULL::numeric END AS fat_vlicms_efet_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivlpis ELSE NULL::numeric END AS fat_vlpis_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivlcofins ELSE NULL::numeric END AS fat_vlcofins_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivlipi ELSE NULL::numeric END AS fat_vlipi_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmvvlimposto_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN COALESCE(round(nfi.nficustoreal, 4), 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0, 0::numeric) + COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmv_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivl * nfidet.nfidetpercdespfixa / 100.0 ELSE NULL::numeric END AS fat_prevvldespfixa_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivl * nfidet.nfidetpercirpj / 100.0 ELSE NULL::numeric END AS fat_prevvlirpj_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivl * nfidet.nfidetperccsll / 100.0 ELSE NULL::numeric END AS fat_prevvlcsll_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfi.nfivlicmsst ELSE NULL::numeric END AS fat_vlicmsst_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetrcacomisscod ELSE NULL::integer END AS fat_rca_comisscod_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetrcaperccom ELSE NULL::numeric END AS fat_rca_perccom_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetsupcomisscod ELSE NULL::integer END AS fat_sup_comisscod_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetsupperccom ELSE NULL::numeric END AS fat_sup_perccom_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetmotcomisscod ELSE NULL::integer END AS fat_mot_comisscod_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetmotperccom ELSE NULL::numeric END AS fat_mot_perccom_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetpromcomisscod ELSE NULL::integer END AS fat_prom_comisscod_dc, CASE WHEN nf.nfsta <> 'EX'::bpchar AND opnf.opnftopnfcod = 'DC'::bpchar THEN nfidet.nfidetpromperccom ELSE NULL::numeric END AS fat_prom_perccom_dc, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfipqtde ELSE NULL::numeric END AS fat_pqt_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfipvltabunit, 4) ELSE NULL::numeric END AS fat_pvltabunit_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfipvlunit, 4) ELSE NULL::numeric END AS fat_pvlunit_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfiqtde * uve.uvepesoliq, 4) ELSE NULL::numeric END AS fat_pesoliq_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfiqtde ELSE NULL::numeric END AS fat_qt_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfiqtde * nfi.nfiuvemult ELSE NULL::numeric END AS fat_qtmult_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivltabunit, 4) ELSE NULL::numeric END AS fat_vltabunit_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfibasedebcred, 4) ELSE NULL::numeric END AS fat_basedebcredunit_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivlunit, 4) ELSE NULL::numeric END AS fat_vlunit_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivltabunit * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_vltab_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfibasedebcred * nfi.nfiqtde, 4) ELSE NULL::numeric END AS fat_basedebcred_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nfivl, 4) ELSE NULL::numeric END AS fat_vl_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nficustocompra, 4) ELSE NULL::numeric END AS fat_custo_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN round(nfi.nficustoreal, 4) ELSE NULL::numeric END AS fat_custoreal_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetrcaperccom / 100.0 ELSE NULL::numeric END AS fat_vlcom_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetpercfrete / 100.0 ELSE NULL::numeric END AS fat_vlfrete_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetperccomercial / 100.0 ELSE NULL::numeric END AS fat_vlcomerc_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_vloutrasdesp_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0 ELSE NULL::numeric END AS fat_cmvvldespvenda_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlicms ELSE NULL::numeric END AS fat_vlicms_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlicmsefet ELSE NULL::numeric END AS fat_vlicms_efet_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlpis ELSE NULL::numeric END AS fat_vlpis_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlcofins ELSE NULL::numeric END AS fat_vlcofins_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlipi ELSE NULL::numeric END AS fat_vlipi_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmvvlimposto_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN COALESCE(round(nfi.nficustoreal, 4), 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetrcaperccom / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetperccomercial / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercfrete / 100.0, 0::numeric) + COALESCE(nfi.nfivl * nfidet.nfidetpercoutrasdesp / 100.0, 0::numeric) + COALESCE(nfi.nfivlicmsefet, nfi.nfivlicms) + COALESCE(nfi.nfivlpis, 0::numeric) + COALESCE(nfi.nfivlcofins, 0::numeric) + COALESCE(nfi.nfivlipi, 0::numeric) ELSE NULL::numeric END AS fat_cmv_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetpercdespfixa / 100.0 ELSE NULL::numeric END AS fat_prevvldespfixa_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetpercirpj / 100.0 ELSE NULL::numeric END AS fat_prevvlirpj_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivl * nfidet.nfidetperccsll / 100.0 ELSE NULL::numeric END AS fat_prevvlcsll_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfi.nfivlicmsst ELSE NULL::numeric END AS fat_vlicmsst_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetrcacomisscod ELSE NULL::integer END AS fat_rca_comisscod_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetrcaperccom ELSE NULL::numeric END AS fat_rca_perccom_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetsupcomisscod ELSE NULL::integer END AS fat_sup_comisscod_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetsupperccom ELSE NULL::numeric END AS fat_sup_perccom_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetmotcomisscod ELSE NULL::integer END AS fat_mot_comisscod_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetmotperccom ELSE NULL::numeric END AS fat_mot_perccom_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetpromcomisscod ELSE NULL::integer END AS fat_prom_comisscod_ex, CASE WHEN nf.nfsta = 'EX'::bpchar AND (opnf.opnftopnfcod = ANY (ARRAY['VE'::bpchar, 'VI'::bpchar, 'VV'::bpchar])) THEN nfidet.nfidetpromperccom ELSE NULL::numeric END AS fat_prom_perccom_ex, nf.nfsupparcod AS fat_sup_cod, sup.pardes AS fat_sup_des, sup.parfan AS fat_sup_fan, nf.nfcadusuparcod AS fat_usu_cod, fun.pardes AS fat_usu_des, fun.parfan AS fat_usu_fan, ( SELECT fpe.fpeforparcod FROM fpe WHERE fpe.fpeempparcod = nf.nfempparcod AND fpe.fpeprocod = nfi.nfiprocod AND fpe.fpetipo = 'P'::bpchar ORDER BY fpe.fpeforparcod DESC LIMIT 1) AS fat_forn_cod, ( SELECT par_1.pardes FROM fpe JOIN par par_1 ON fpe.fpeforparcod = par_1.parcod WHERE fpe.fpeempparcod = nf.nfempparcod AND fpe.fpeprocod = nfi.nfiprocod AND fpe.fpetipo = 'P'::bpchar ORDER BY fpe.fpeforparcod DESC LIMIT 1) AS fat_forn_des, ( SELECT par_1.parfan FROM fpe JOIN par par_1 ON fpe.fpeforparcod = par_1.parcod WHERE fpe.fpeempparcod = nf.nfempparcod AND fpe.fpeprocod = nfi.nfiprocod AND fpe.fpetipo = 'P'::bpchar ORDER BY fpe.fpeforparcod DESC LIMIT 1) AS fat_forn_fan, depp.deppcod AS fat_depp_cod, depp.deppdes AS fat_depp_des, secp.secpcod AS fat_secp_cod, secp.secpdes AS fat_secp_des, cat.catcod AS fat_cat_cod, cat.catdes AS fat_cat_des, scat.scatcod AS fat_scat_cod, scat.scatdes AS fat_scat_des, marcas.marcascod AS fat_marcas_cod, marcas.marcasdes AS fat_marcas_des, fam.famcod AS fat_fam_cod, fam.famdes AS fat_fam_des, app.appcod AS fat_app_cod, app.appdes AS fat_app_des, cliente_grupo.cg_codigo AS fat_grupocli_cod, cliente_grupo.cg_descricao AS fat_grupocli_des, loc.loccod AS fat_loc_cod, loc.locdes AS fat_loc_des, ra.racod AS fat_ra_cod, ra.rades AS fat_ra_des, area_venda.av_codigo AS fat_av_cod, area_venda.av_descricao AS fat_av_des, nf.nfcarcod AS fat_carreg_cod, nf.nfveicod AS fat_vei_cod, vei.veides AS fat_vei_des, nf.nfmotparcod AS fat_mot_cod, mot.pardes AS fat_mot_des, mot.parfan AS fat_mot_fan, cli.clipromparcod AS fat_prom_cod, prom.pardes AS fat_prom_des, prom.parfan AS fat_prom_fan, CASE WHEN plpg.plpgpzmedio > 0 THEN 'P'::text ELSE 'A'::text END AS fat_prazo, plpg.plpgpzmedio AS fat_prazomed, COALESCE(round(nfi.nfiqtdefalta * nfi.nfivlunit, 4), 0::numeric) AS fat_vlfalta, COALESCE(round(nfi.nfiqtdecorte * nfi.nfivlunit, 4), 0::numeric) AS fat_vlcorte, COALESCE(round(nfi.nfiqtdefalta, 4), 0::numeric) AS fat_qtfalta, COALESCE(round(nfi.nfiqtdecorte, 4), 0::numeric) AS fat_qtcorte, lpad(COALESCE(pv.pvpdvnum, nf.nfpdvcod::character(4)::character varying)::text, 3, '0'::text) AS fat_pdv_num, pv.pvcupnum AS fat_pdv_cupnum, mun.munufsigla AS fat_par_uf, clicart.clicartcod AS fat_clicart_cod, clicart.clicartdes AS fat_clicart_des, nfi.nficfopcod AS fat_cfop_cod, nfi.nfialiqicms AS fat_aliqicms, nfi.nfialiqpis AS fat_aliqpis, nfi.nfialiqcofins AS fat_aliqcofins, pv.pvcliendcod AS fat_cliend_cod, nfi.nfimetrocubico, nfi.nfialiqipi AS fat_aliqipi, nf.nfrefpvcod AS fat_ref_pv_cod, ( SELECT nf_1.nfnum FROM nf nf_1 WHERE nf_1.nfpvcod = nf_1.nfrefpvcod) AS fat_ref_nfnum, tdvnf.tdvnf_penalidade AS fat_penalidade_dc FROM nf JOIN nfi ON nf.nfcod = nfi.nfinfcod JOIN opnf ON nf.nfopnfcod = opnf.opnfcod AND opnf.opnfsta <> 'C'::bpchar JOIN topnf ON opnf.opnftopnfcod = topnf.topnfcod JOIN par emp ON nf.nfempparcod = emp.parcod JOIN par par ON nf.nfparcod = par.parcod LEFT JOIN plpg ON nf.nfplpgcod = plpg.plpgcod LEFT JOIN tc ON nf.nftccod = tc.tccod JOIN cli ON nf.nfparcod = cli.cliparcod JOIN par fun ON nf.nfcadusuparcod = fun.parcod JOIN pro ON nfi.nfiprocod = pro.procod JOIN uve ON nfi.nfiuvecod = uve.uvecod AND nfi.nfiprocod = uve.uveprocod JOIN est ON pro.procod = est.estprocod AND est.estempparcod = nf.nfempparcod JOIN app ON est.estappcod = app.appcod LEFT JOIN scat ON pro.proscatcod = scat.scatcod LEFT JOIN cat ON pro.procatcod = cat.catcod LEFT JOIN secp ON pro.prosecpcod = secp.secpcod LEFT JOIN depp ON pro.prodeppcod = depp.deppcod LEFT JOIN marcas ON pro.promarcascod = marcas.marcascod LEFT JOIN fam ON pro.profamcod = fam.famcod LEFT JOIN par rca ON nf.nfrcaparcod = rca.parcod LEFT JOIN rca r ON rca.parcod = r.rcaparcod LEFT JOIN cr ON r.rcacrcod = cr.crcod LEFT JOIN par sup ON nf.nfsupparcod = sup.parcod LEFT JOIN par mot ON nf.nfmotparcod = mot.parcod LEFT JOIN vei ON nf.nfveicod = vei.veicod LEFT JOIN cliente_grupo ON cli.cli_cg_codigo = cliente_grupo.cg_codigo LEFT JOIN area_venda ON cli.cli_av_codigo = area_venda.av_codigo LEFT JOIN ra ON cli.cliracod = ra.racod LEFT JOIN par prom ON cli.clipromparcod = prom.parcod LEFT JOIN nfidet ON nfidet.nfidetnfcod = nfi.nfinfcod AND nfidet.nfidetprocod = nfi.nfiprocod AND nfi.nfiseq = nfidet.nfidetseq LEFT JOIN pv ON nf.nfpvcod = pv.pvcod LEFT JOIN cliend ON pv.pvcliendcod = cliend.cliendcod LEFT JOIN loc ON COALESCE(cliend.cliendloccod, cli.cliloccod) = loc.loccod LEFT JOIN mun ON COALESCE(cliend.cliendmuncod, cli.climuncodent) = mun.muncod LEFT JOIN conf ON nf.nfempparcod = conf.confempparcod LEFT JOIN clicart ON cli.cliclicartcod = clicart.clicartcod LEFT JOIN tdvnf ON nf.nfmotivdevolnfcod = tdvnf.tdvnf_id WHERE opnf.opnfnat = 'S'::bpchar OR opnf.opnftopnfcod = 'DC'::bpchar; -- Permissions ALTER TABLE sd.vw_fat OWNER TO postgres; GRANT ALL ON TABLE sd.vw_fat TO postgres; GRANT SELECT ON TABLE sd.vw_fat TO consulta; ------------------------------------------------------------------------------------------------ -- public.proemp definition -- Drop table -- DROP TABLE public.proemp; CREATE TABLE public.proemp ( proempcadusuparcod int4 NULL, proempcadhorario timestamp NULL, proempaltusuparcod int4 NULL, proempalthorario timestamp NULL, proempacao text NULL, proempprocod int4 NOT NULL, proempempparcod int4 NOT NULL, proempdisp bpchar(1) NOT NULL, CONSTRAINT pk_proemp PRIMARY KEY (proempprocod, proempempparcod, proempdisp) ); -- Permissions ALTER TABLE public.proemp OWNER TO postgres; GRANT ALL ON TABLE public.proemp TO postgres; GRANT SELECT ON TABLE public.proemp TO consulta; ------------------------------------------------------------------------------------------------ DELETE FROM menu; INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(1, 'Parâmetros', 1, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(2, 'Configuração Geral', 1, '108', 'formconf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(3, 'Controle de Acesso', 1, '106', 'formusu', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(4, 'Alterar Senha', 1, '107', 'frmalterarsenha', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(5, 'Empresa', 1, '101', 'formemp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(6, 'Departamento', 1, '102', 'formdepe', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(7, 'Seção', 1, '103', 'formsece', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(8, 'Função', 1, '104', 'formfunc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(9, 'Funcionário', 1, '105', 'formfun', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(10, 'Município', 1, '109', 'formmun', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(11, 'País', 1, '', 'formpais', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(12, 'Motivos de Devolução de Nota Fiscal', 1, '113', 'formtdvnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(13, 'Motivos de Exclusão', 1, '114', 'formtmex', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(14, 'Tipos de Baixa', 1, '116', 'formtb', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(15, 'Tipos de Bônus', 1, '117', 'formtbon', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(16, 'Configurações de Boletos', 1, '118', 'frmboleto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(17, 'Impressoras ECF', 1, '120', 'formmaqecf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(18, 'Unidades de Medida', 1, '122', 'formunidade', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(19, 'Layout de Notas Fiscais', 1, '127', 'formel', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(20, 'Layouts de Impressão', 1, '', 'formgerlay', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(21, 'Configuração de Contas', 1, '', 'formconfconta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(22, 'Histórico de Alterações', 1, '', 'formlog', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(23, 'Calendário', 1, '', 'formferiados', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(24, 'Tributação', 24, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(25, 'Regime de Tributação', 24, '123', 'formregtrib', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(26, 'CFOP', 24, '123', 'formcfop', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(27, 'Tipos de OPNF', 24, '125', 'formtopnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(28, 'OPNF', 24, '112', 'formopnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(29, 'Grupo de Tributação', 24, '111', 'formgt', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(30, 'Cadastro de NCM', 24, '', 'formncm', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(31, 'Tributação por NCM', 24, '128', 'formtrib', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(32, 'Tributação por Produto', 24, '129', 'formtribpro', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(33, 'Tributação de Benefício', 24, '', 'formtribbenef', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(34, 'Tributação de Transferência', 24, '', 'formtribtransf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(35, 'Cadastro de Benefício Fiscal - Cliente', 24, '', 'formbenef', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(36, 'Cadastro de Benefício Fiscal - Produto', 24, '', 'formbenf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(37, 'Cadastro de CEST', 24, '', 'formcest', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(38, 'Tributação de Entrada', 24, '', 'formtribentr', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(39, 'Gestão de Produtos', 39, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(40, 'Aplicação do Produto', 39, '301', 'formapp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(41, 'Departamento', 39, '201', 'formdepp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(42, 'Seção', 39, '202', 'formsecp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(43, 'Categoria', 39, '203', 'formcat', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(44, 'SubCategoria', 39, '204', 'formscat', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(45, 'Marca', 39, '206', 'formmarca', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(46, 'Família de Produtos', 39, '312', 'formfam', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(47, 'Produto', 39, '306', 'formpro', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(48, 'Produto Serviço', 39, '', 'formproserv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(49, 'Produto Simplificado', 39, '', 'formproduto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(50, 'Agrupamento de Produto', 39, '302', 'formagrup', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(51, 'Administração de Produtos', 39, '311', 'formadmpro', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(52, 'Relação de Produtos', 39, '', 'formrelcadastroproduto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(53, 'Cesta Básica', 53, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(54, 'Montagem Cesta Básica', 53, '303', 'formcesta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(55, 'Proposta Cesta Básica', 53, '', 'formcestaprop', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(56, 'Aprovação Proposta Cesta Básica', 53, '', 'formcestapropaprov', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(57, 'Ordem de Produção Cesta Básica', 53, '', 'formcestaop', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(58, 'Entrada de Produção Cesta Básica', 53, '', 'formcestaep', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(59, 'Alterar Item de Produção Cesta Básica', 53, '', 'formcestaopalt', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(60, 'Pedido de Venda Cesta Básica', 53, '', 'formpvcb', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(61, 'Relatório - Ordem Produção Consolidado', 53, '', 'formrelordprodcbconsolidado', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(62, 'Gestão de Compras', 62, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(63, 'Tipo de Fornecedor', 62, '126', 'formtipoforn', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(64, 'Representante do Fornecedor', 62, '304', 'formrep', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(65, 'Fornecedor', 62, '305', 'formforn', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(66, 'Pedido de Compra', 62, '307', 'formpedcompra', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(67, 'Consulta de Pedidos de Compra', 62, '312', 'formconsultapc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(68, 'Manutenção de Notas de Entrada', 62, '309', 'formmannf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(69, 'Ajuste de Custo', 62, '', 'formajustecusto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(70, 'Recalcular Custo', 62, '', 'formatualcusto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(71, 'Relatório - Sugestão de Compra', 62, '', 'formrelsugestaocompra', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(72, 'Relatório - Giro do Estoque', 62, '', 'formrelgiroestoque', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(73, 'Distribuição', 62, '', 'formdistr', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(74, 'Cadastro de Zonas', 62, '', 'formzona', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(75, 'Manutenção de Zonas - Frete', 62, '', 'formmanzona', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(76, 'Recebimento de Mercadoria', 76, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(77, 'Autorização de Recebimento', 76, '401', 'formautrec', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(78, 'Entrada de Mercadoria', 76, '402', 'formnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(79, 'Sugestão de Preço', 76, '403', 'formsugestao_preco', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(80, 'Atualização de Entrada', 76, '404', 'formatuentr', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(81, 'Desagregação', 76, '0', 'formdesagregacao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(82, 'Devolução para Fornecedor', 76, '405', 'formnfdev', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(83, 'Devolução sem documento do Cliente', 76, '407', 'formdevnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(84, 'Manutenção de Lote', 76, '408', 'formlote', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(85, 'Entrada de Lote', 76, '', 'formentrlote', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(86, 'Conhecimento de Frete - Entrada', 76, '409', 'frmcfrete_ent', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(87, 'Devolução para Fornecedor por Carregamento', 76, '411', 'formdevforncar', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(88, 'Entrada de Importação', 76, '', 'formnfimport', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(89, 'Proposta de Importação', 76, '', 'formpropimportacao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(90, 'Entrada Cega', 76, '', 'formentrcega', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(91, 'Mapa de Conferência Cega Consolidado', 76, '', 'mapacegoconsolidado', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(92, 'Relatório - Compras Acumuladas', 76, '', 'formrelcompacum', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(93, 'Precificação', 93, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(94, 'Livro de Preço', 93, '502', 'formlp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(95, 'Precificação', 93, '503', 'formpreco', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(96, 'Precificação por Tabela de Preço', 93, '', 'formprecificacaolivro', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(97, 'Impressão de Tabela de Preço', 93, '', 'formrellivropreco', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(98, 'Logística', 98, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(99, 'Rota', 98, '601', 'formrota', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(100, 'Praça', 98, '602', 'formpraca', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(101, 'Localidade', 98, '603', 'formloc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(102, 'Motorista', 98, '604', 'formmot', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(103, 'Veículo', 98, '605', 'formvei', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(104, 'Área de Venda', 98, '', 'formarea_venda', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(105, 'Conferente', 98, '', 'formconferente', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(106, 'Categoria de Frota', 98, '', 'formcategfrota', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(107, 'Transporte de Pedido', 98, '', 'formtransppedido', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(108, 'Venda de Mercadoria', 108, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(109, 'Motivos de Não Venda', 108, '121', 'formotnv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(110, 'Tipos de Cobrança', 108, '2401', 'formtc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(111, 'Planos de Pagamento', 108, '701', 'formpp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(112, 'Ramos de Atividades', 108, '702', 'formra', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(113, 'Grupo de Cliente', 108, '703', 'formcliente_grupo', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(114, 'Supervisor', 108, '705', 'formsup', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(115, 'RCA', 108, '706', 'formrca', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(116, 'Promotores', 108, '707', 'formprom', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(117, 'Clientes', 108, '708', 'formcli', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(118, 'Administração de Clientes', 108, '709', 'formadmcarteira', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(119, 'Ficha de atendimento', 108, '709', 'formfa', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(120, 'Manutenção de Notas de Saída', 108, '710', 'formmannfsai', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(121, 'Pedido de Venda', 108, '1003', 'formpvtl', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(122, 'Pedido - Telemarketing Passivo', 108, '1004', 'formpvtlpassivo', 'N', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(123, 'Pedido Balcão', 108, '1005', 'formpvbalcao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(124, 'Consulta de Pedidos', 108, '1008', 'formconpv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(125, 'Aprovação de Pedidos', 108, '1001', 'formpvaprov', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(126, 'Carteira de Pedidos', 108, '1002', 'frmcartped', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(127, 'Desconto Gerencial Pedido de Venda', 108, '1003', 'formdescpv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(128, 'Nota de Serviço', 108, '', 'formpvserv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(129, 'NFSe 4.0', 108, '', 'nfse40', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(130, 'NFSeX', 108, '', 'nfsex', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(131, 'Carta de Correção de Serviço', 108, '', 'formnfcceserv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(132, 'Pedido - Administrador', 108, '1008', 'formpvadmin', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(133, 'Consulta Preço', 108, '', 'formconsultaprecoproduto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(134, 'Lista de Preço', 108, '', 'formlistaprecoproduto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(135, 'Entrega de Venda Futura', 108, '', 'formvendfut', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(136, 'Relatório - Vendas Acumuladas', 108, '', 'formrelvenacum', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(137, 'Relatório - Clientes Sem Vendas', 108, '', 'formrelclientesemvenda', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(138, 'Relatório - Relação de Vendas', 108, '', 'formrelrelacaovenda', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(139, 'Relatório - Nota Fiscal de Serviço', 108, '', 'formrelnfserv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(140, 'Relatório - Relação de Clientes', 108, '', 'formrellistacliente', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(141, 'Relatório - Produtos sem Venda', 108, '', 'formrelprodutosemvenda', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(142, 'Relatório - Relação de Cortes', 108, '', 'formrelcorteproduto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(143, 'Relatório - Relação de Vendedor', 108, '', 'formrelacaorca', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(144, 'Relatório - Evolução do Preço de Venda', 108, '', 'formrelevolprvenda', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(145, 'Relatório - Mapa de Vendas Matriz', 108, '', 'formrelmapavenda', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(146, 'Relatório - Mapa de Vendas Filial', 108, '', 'formrelmapavendafilial', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(147, 'Relatório - Relação de Vendas por Endereço', 108, '', 'formrellistavendaendereco', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(148, 'Relatório - Entrega Futura', 108, '', 'formrelentrfut', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(149, 'Relatório - Apuração de Desconto', 108, '', 'formreldesc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(150, 'Comissão', 150, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(151, 'Categoria de Comissão Produto', 150, '801', 'formce', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(152, 'Categoria de Comissão RCA', 150, '802', 'formcr', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(153, 'Comissão por Produto', 150, '803', 'formcrce', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(154, 'Comissão por Cobrança', 150, '804', 'formcrtc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(155, 'Recalcular Comissão', 150, '805', 'formrecalccom', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(156, 'Região de Comissão', 150, '', 'formcomissregiao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(157, 'Comissão por Viagem', 150, '', 'formcomissviagem', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(158, 'Comercial', 158, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(159, 'Meta por RCA', 158, '', 'formmetaemprca', 'S', 'S'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(160, 'Meta RCA por Distribuição', 158, '901', 'formmetarcadistri', 'S', 'S'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(161, 'Meta RCA por Categoria', 158, '902', 'formmetarcacat', 'S', 'S'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(162, 'Administração de Metas / Campanhas', 158, '', 'formmetaatac', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(163, 'Campanha', 158, '904', 'formcamp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(164, 'Manutenção de Vendas do RCA', 158, '906', 'frmvendasrca', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(165, 'Promoção', 158, '', 'formpromocao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(166, 'Desconto por Quantidade', 158, '', 'formdescqtde', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(167, 'Autorização Especial de Pedido ', 158, '', 'FormAutorizDescEspecial', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(168, 'Lançamento Deb/Cred RCA', 158, '911', 'formrcamv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(169, 'Restrição de Produto - iPedi', 158, '', 'formrcapro', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(170, 'Restrição de Venda', 158, '', 'formrestrvenda', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(171, 'ECF - Emissor de Cupom Fiscal', 171, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(172, 'Utilitário ECF', 171, '1010', 'formecfutil', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(173, 'Pedido - Atacadão', 171, '1006', 'formpvvarejo', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(174, 'Listagem/Cotação de Preços', 171, '1009', 'formllp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(175, 'Consulta de Pedidos Carregamento', 171, '1009', 'formconsultapvcar', 'A', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(176, 'Carregamento', 176, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(177, 'Montar Carregamento por Rota', 176, '1101', 'formcar', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(178, 'Montar Carregamento por Pedido', 176, '1102', 'formcarpv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(179, 'Montar Carregamento de Nota Fiscal', 176, '1104', 'formcarnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(180, 'Separação por Pedido', 176, '1106', 'formmapped', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(181, 'Impressão Mapa de Separação de Nota Fiscal', 176, '1105', 'formimprmapanf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(182, 'ReImpressão Mapa de Separação', 176, '', 'formreimprmapa', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(183, 'ReImpressão de Mapa de Pedido', 176, '1107', 'formremapped', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(184, 'CTe - Conhecimento de Transporte Eletrônico', 176, '1110', 'formcte', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(185, 'CT-e -4.0', 176, '1110', 'cte', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(186, 'MDF-e', 176, '', 'mdfe', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(187, 'Retirar Nota Fiscal de Carregamento', 176, '1111', 'formretnfcar', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(188, 'Retirar Pedido de Carregamento Mapeado', 176, '1103', 'formretpedcar', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(189, 'Administração de Carregamento', 176, '', 'formadmcarreg', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(190, 'Relatório - Mapa de Separação Consolidado', 176, '', 'formrelmapasepconsolidado', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(191, 'Relatório - Posição de Carregamento', 176, '', 'formrelposicaocarreg', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(192, 'Relatório - Listagem de CTe de Saída', 176, '', 'formrelctesaida', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(193, 'Faturamento', 193, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(194, 'Lançar Divergência', 193, '1201', 'formdivpv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(195, 'Registrar Lote', 193, '1202', 'frmctrllote', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(196, 'Faturar Pedido', 193, '1203', 'formfatped', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(197, 'Faturar Carregamento', 193, '1204', 'formfat', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(198, 'Impressão de Nota Fiscal', 193, '1205', 'formimprnfrav', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(199, 'ReImpressão de Nota Fiscal', 193, '1206', 'formreimprnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(200, 'Imprimir Boleto (Pré-impresso)', 193, '1207', 'formimprbol', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(201, 'Imprimir Duplicata', 193, '1208', 'formimprdp', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(202, 'Imprimir Nota Promissória', 193, '1209', 'formimprpromissoria', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(203, 'Impressão Romaneio', 193, '1210', 'formimprrom', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(204, 'Imprimir Rascunho', 193, '1211', 'formimprrascnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(205, 'Cancelamento de Nota Fiscal', 193, '1212', 'formcancnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(206, 'Estorno de Cancelamento de Nota Fiscal', 193, '1213', 'formestcancnf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(207, 'NFe Nota Fiscal Eletrônica', 193, '1214', 'nfe', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(208, 'NF-e 4.0', 193, '', 'nfe40', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(209, 'NFC-e 4.0', 193, '', 'nfce40', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(210, 'Emissor de Documentos Eletrônicos', 193, '', 'doce', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(211, 'Carta de Correção', 193, '', 'formnfcce', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(212, 'Manutenção de Volumes - Nota Fiscal', 193, '1214', 'formmanvol', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(213, 'Manutenção de Volumes - Pedido', 193, '', 'formmanvolumepedido', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(214, 'Caixa Varejo', 193, '1215', 'frmcxvarejo', 'N', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(215, 'Transferência entre Filias', 193, '', 'formtransestoque', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(216, 'Lançamento de Conferência Cega', 193, '1008', 'formlancconfcega', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(217, 'Conferencia Cega', 193, '2211', 'formconfcega', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(218, 'Consulta de Notas Fiscais', 193, '2202', 'frmconsultanf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(219, 'Emissão de Outras Nfes', 193, '', 'formoutrasnfes', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(220, 'Cobrança Magnética', 220, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(221, 'Boleto Laser (Impressão,Remessa e Retorno)', 220, '1301', 'boletolaser', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(222, 'Brasil', 220, '', 'brasil', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(223, 'Sicredi', 220, '', 'sicredi', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(224, 'Banrisul', 220, '', 'banrisul', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(225, 'Bradesco', 220, '', 'bradesco', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(226, 'Sicoob', 220, '', 'sicoob', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(227, 'Safra', 220, '', 'Safra', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(228, 'Caixa', 220, '', 'Caixa', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(229, 'Itau', 220, '', 'itau', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(230, 'Santander', 220, '', 'santander', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(231, 'BRB', 220, '', 'brb', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(232, 'Expedição', 232, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(233, 'Portaria', 232, '1401', 'formportaria', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(234, 'Ocorrência de Portaria', 232, '', 'formportariaocorr', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(235, 'Serviço de Portaria', 232, '', 'formservicodeportaria', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(236, 'Plano de Contas', 236, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(237, 'Centro de Custos', 236, '1501', 'frmcentro_custo', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(238, 'Grupo de Contas', 236, '1502', 'formgrupo_conta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(239, 'Contas Gerenciais', 236, '1503', 'formconta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(240, 'Contas a Pagar', 240, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(241, 'Contas a Pagar', 240, '', 'contpag', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(242, 'Lançamento Contas a Pagar', 240, '1601', 'formcprpag', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(243, 'Renegociação Contas a Pagar', 240, '1602', 'formrendocpag', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(244, 'Baixa Contas a Pagar', 240, '1603', 'formbaipag', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(245, 'Estorno de Baixa Contas a Pagar', 240, '1606', 'formbaiestpag', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(246, 'Pagamento com Cheque', 240, '1604', 'frmpagcheque', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(247, 'Cancelamento de Pagamento com Cheque', 240, '1607', 'frmcancheque', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(248, 'Pagamento com Documentos de Terceiros', 240, '1605', 'formpagdoc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(249, 'Carta de Prorrogação', 240, '1809', 'formecartapr', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(250, 'Entrada Nota Fiscal de Serviço', 240, '', 'Formnfentradaaguaenergiagas', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(251, 'Folha de Pagamento', 240, '', 'formfolhapagamento', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(252, 'Folha de Pagamento Completa', 240, '', 'formfolhapagcompleta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(253, 'Pagamento Eletrônico - iPag', 240, '', 'ipag', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(254, 'Aprovação de Contas a Pagar', 240, '', 'formcpagaprov', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(255, 'Relatório - Contas a Pagar Resumo', 240, '', 'formrelcpagresumo', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(256, 'Relatório - Contas a Pagar Quitadas', 240, '', 'formrelcpagquitado', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(257, 'Relatório - Contas a Pagar em Aberto', 240, '', 'formrelcpagaberto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(258, 'Relatório - Contas a Pagar por Centro de Custo', 240, '', 'formrelcpagcentrocusto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(259, 'Relatório - Contas a Pagar por Grupo de Contas', 240, '', 'formrelcpaggrupoconta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(260, 'Relatório - Comissão de Motorista por Viagem', 240, '', 'formrelcomissaoviag', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(261, 'Relatório - Comissão de RCA por Liquidez', 240, '', 'relcomissaoliquidez', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(262, 'Relatório - Comissão de RCA', 240, '', 'formrelcomissao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(263, 'Contas a Receber', 263, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(264, 'Tipos de Devolução de Cheques', 263, '115', 'formtdvch', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(265, 'Contas a Receber', 263, '', 'contrec', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(266, 'Lançamento Contas a Receber', 263, '1701', 'formcprrec', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(267, 'Renegociação Contas a Receber', 263, '1703', 'formrendocrec', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(268, 'Baixa Contas a Receber', 263, '1704', 'formbairec', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(269, 'Estorno de Baixa Contas a Receber', 263, '1709', 'formbaiestrec', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(270, 'Efetivação de Carregamento (Caixa Motorista)', 263, '1702', 'formef', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(271, 'Devolução de Cheques', 263, '1705', 'formdevdoc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(272, 'Representação de Cheques', 263, '1706', 'formreapdoc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(273, 'Depósito/Custódia/Desconto de Cheques', 263, '1707', 'formdepcustdescdoc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(274, 'Protesto de Títulos', 263, '1710', 'formprotesta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(275, 'Estorno de Protesto', 263, '1711', 'formestprotesto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(276, 'Antecipação de Títulos', 263, '1712', 'formanttit', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(277, 'Estorno de Antecipação', 263, '1717', 'formestant', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(278, 'Impressão de Boletos Avulsos', 263, '1708', 'formimpbolm', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(279, 'Caixa Balcão', 263, '', 'formcaixabalcao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(280, 'Caixa Balcão (TEF)', 263, '', 'formcaixabalcaotef', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(281, 'Borderô de Cobrança', 263, '', 'formbordero', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(282, 'Conciliação de Títulos', 263, '', 'formconccartao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(283, 'Lançamento Vales', 263, '2301', 'formvale', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(284, 'Baixa Vales', 263, '2302', 'formbaivale', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(285, 'Transferência de Carteira de Títulos', 263, '', 'formtransfcart', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(286, 'Lançamento de Adiantamento', 263, '', 'lancvale', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(287, 'Relatório - Contas a Receber Resumo', 263, '', 'formrelcrecebresumo', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(288, 'Relatório - Contas a Receber em Aberto', 263, '', 'formrelcrecebaberto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(289, 'Relatório - Contas a Receber Quitadas', 263, '', 'formrelcrecebquitado', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(290, 'Relatório - Títulos em Aberto para Cobrança', 263, '', 'formrelcrecebabertocob', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(291, 'Relatório - Lista de Títulos Protestados', 263, '', 'formrellistatituloprotestado', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(292, 'Negociação de Contas a Receber', 263, '', 'NegociacaoDoc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(293, 'Relatório - Histórico de Ocorrencia de Titulos', 263, '', 'formrelhisttitulos', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(294, 'Movimentação de Caixa', 293, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(295, 'Bancos', 293, '110', 'formban', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(296, 'Tipos de Movimentação de Caixa', 293, '1808', 'formtcxmv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(297, 'Caixas/Bancos', 293, '1801', 'formcx', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(298, 'Lançamento Caixa', 293, '1802', 'formlanccx', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(299, 'Transferência entre Caixas', 293, '1803', 'formtransf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(300, 'Estono de Lançamento', 293, '1804', 'formestornocaixa', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(301, 'Fechamento de Caixa', 293, '1806', 'formfechcx', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(302, 'Estorno de Fechamento', 293, '1805', 'formestfechcx', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(303, 'Extrato de Movimentação de Caixa', 293, '1807', 'frmextrmovcx', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(304, 'Fluxo de Caixa', 293, '', 'formfluxocaixa', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(305, 'Fluxo de Caixa - NOVO', 293, '', 'fluxocaixa', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(306, 'Acerto de Caixa', 293, '', 'formacertocx', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(307, 'Conciliação Bancaria', 293, '', 'conciliacaobancaria', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(308, 'Relatório - Demonstrativo de Contas', 293, '', 'formreldemonstrativoconta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(309, 'Relatório - Demonstrativo de Fluxo de Caixa - DFC', 293, '', 'formreldemfluxocaixa', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(310, 'Contabilidade', 309, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(311, 'Escrita Fiscal - Apuração de Vendas para CPF', 309, '1901', 'frmlfapvencpf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(312, 'Escrita Fiscal - Apuração de ICMS', 309, '1902', 'formlfapicms', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(313, 'Escrita Fiscal - Apuração de ICMS Analítico', 309, '', 'formrelapuracaoicmsanalitico', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(314, 'Escrita Fiscal - Apuração de Pis/Cofins', 309, '1903', 'formlfpiscofins', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(315, 'Escrita Fiscal - Apuração IPI', 309, '', 'formrelapuracaoipi', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(316, 'Escrita Fiscal - Crédito Outorgado', 309, '1904', 'formlfcredout', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(317, 'Escrita Fiscal - Registro de Entradas', 309, '1905', 'formlfregent', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(318, 'Escrita Fiscal - Registro de Inventário', 309, '1906', 'formlfreginv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(319, 'Escrita Fiscal - Registro de Saídas', 309, '1907', 'formrelfiscalicmsregsaida', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(320, 'Escrita Fiscal - Registro de Saídas por CNPJ/CPF', 309, '1908', 'formlfregsaicpf', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(321, 'Escrita Fiscal - Registro de Entradas/Saídas por CFOP', 309, '1909', 'formlflistacfop', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(322, 'Escrita Fiscal - Registro de Saídas por Item da Portaria e por CFOP', 309, '1910', 'formlfregitem', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(323, 'Escrita Fiscal - Ressarcimento de ICMS', 309, '1911', 'formlfregressarc', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(324, 'Escrita Fiscal - Entrada/Saída por Produto', 309, '', 'formrelentrsaiproduto', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(325, 'Confronto Fiscal', 309, '1912', 'frmconfrontofiscal', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(326, 'Sintegra', 309, '1913', 'formsintegra', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(327, 'Livro Eletrônico', 309, '1914', 'formlivro_eletronico', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(328, 'Arquivos ROI', 309, '1915', 'formroi', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(329, 'Ambiente Dexion', 309, '1916', 'formdexion', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(330, 'Exportação Dexion', 309, '', 'ExportarDexion', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(331, 'SPED Fiscal', 309, '', 'formsped', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(332, 'SPED Contribuições (PIS/Cofins)', 309, '', 'formspedpiscofins', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(333, 'Relatório - Apuração PIS/COFINS', 309, '', 'formlfappiscofins', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(334, 'Complemento de ICMS (Entrada/Saída)', 309, '', 'formcomplicms', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(335, 'Inventário', 334, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(336, 'Controle da Contagem de Estoque', 334, '2001', 'frmctrlcontagemest', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(337, 'Contagem de Estoque', 334, '2002', 'frmcontagemest', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(338, 'Relatório de Estoque Retroativo', 334, '2003', 'formrelestretroativo', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(339, 'Contagem - HoneyWell', 334, '', 'formhoneywell', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(340, 'Ajuste de Estoque', 334, '', 'formajusteest', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(341, 'Manutenção de Estoque Pendente', 334, '', 'formmanestpend', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(342, 'Relatório - Posição de Estoque', 334, '', 'formrelposicaoestoque', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(343, 'Relatório - Relação de Estoque', 334, '', 'frmrelest', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(344, 'Relatório - Valor do Estoque', 334, '', 'formrelvalorestoque', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(345, 'Relatório - Saldo de Produto de Armazenagem', 334, '', 'formrelsaldoprodarmaz', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(346, 'Relatório - Controle de Armazenagem', 334, '', 'formrelcontrolearmaz', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(347, 'Relatório - Posição de Estoque - Novo', 334, '', 'posicaoestoque', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(348, 'Utilitários', 346, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(349, 'Backup', 346, '2101', 'formbckup', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(350, 'Força de Vendas', 346, '2102', 'ipedi', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(351, 'Mala Direta', 346, '2103', 'frmmaladireta', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(352, 'Exportar Carteira', 346, '2104', 'frmexportcart', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(353, 'Configurar Etiqueta Zebra', 346, '2108', 'formlayetiqzebra', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(354, 'Imprimir Etiqueta Zebra', 346, '2109', 'formimpretiq', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(355, 'Imprimir Código de Barras', 346, '2106', 'frmimprcodbarras', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(356, 'Atualização Thunder', 346, '2106', 'atualizathunder', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(357, 'Produção', 355, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(358, 'Composição de Produtos', 355, '2504', 'formcomppro', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(359, 'Ítens de Custo de Produção', 355, '2503', 'formicustoprod', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(360, 'Ordem de Produção', 355, '2502', 'formop', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(361, 'Entrada de Produção', 355, '2501', 'formnfep', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(362, 'Consulta Ordem de Produçao', 355, '2505', 'formconsultaop', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(363, 'Conversão de Estoque', 355, '', 'formproconvert', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(364, 'Relatório - Conversão de Estoque', 355, '', 'FormRelProConvert', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(365, 'Relatório - Consumo de Matéria-Prima', 355, '', 'Formrelconsumomateriaprima', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(366, 'Relatório - Perda por Produção', 355, '', 'formrelperdaproducao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(367, 'Relatório - Produção Realizada', 355, '', 'formrelentradaproducao', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(368, 'Frotas', 366, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(369, 'Tipos de Serviços', 366, '2601', 'formtiposervico', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(370, 'Lançamento de Serviços', 366, '2602', 'formservico', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(371, 'Comodato', 369, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(372, 'Equipamento', 369, '', 'formcomodequip', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(373, 'Contrato', 369, '', 'formcomodcontrato', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(374, 'Remessa de Equipamento', 369, '', 'formcomodremessaequip', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(375, 'Relatório - Relação de Contratos', 369, '', 'formrelListaclientecomodato', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(376, 'Gerencial', 374, '0', '', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(377, 'Gerencial', 374, '2700', 'formgerencial', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(378, 'ExportarPDV', 374, '', 'exportarpdv', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(379, 'Valida Query', 374, '', 'formvalidaquery', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(380, 'Régua de Cobrança', 263, '', 'reguacob', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(381, 'CST', 24, '', 'formcadcst', 'S', 'N'); INSERT INTO public.menu (menucod, menudes, menugrupo, menuatalho, menuform, menuativo, menu_secreto) VALUES(382, 'Relatório de Frete', 76, '', 'formrelfrete', 'S', 'N');