20250225@154526.1730 7fat50idq1f0if9lvbl7g4a62e Query : use flama_phc
20250225@154526.1770 7fat50idq1f0if9lvbl7g4a62e Query : select 1 valor from bo where bo.bostamp = 'aut67bde4552467bde57231'
20250225@154526.2000 7fat50idq1f0if9lvbl7g4a62e Query : declare @errno int ,@errmsg varchar(255) ,@prod bit ,@nrdec numeric(10, 0) ,@totaldeb numeric(18, 5) ,@etotaldeb numeric(19, 6) ,@total numeric(18, 5) ,@etotal numeric(19, 6) ,@custo numeric(18, 5) ,@ecusto numeric(19, 6) ,@bo_1iliq numeric(19, 6) ,@bo_2iliq numeric(19, 6) ,@base1 numeric(19, 6) ,@base2 numeric(19, 6) ,@moetotal numeric(13, 3) ,@smoe1 numeric(13, 3) ,@smoe2 numeric(13, 3) ,@smoe3 numeric(13, 3) ,@smoe4 numeric(13, 3) ,@bo11_bins numeric(18, 5) ,@bo21_bins numeric(18, 5) ,@bo31_bins numeric(18, 5) ,@bo41_bins numeric(18, 5) ,@bo51_bins numeric(18, 5) ,@bo61_bins numeric(18, 5) ,@bo71_bins numeric(18, 5) ,@bo81_bins numeric(18, 5) ,@bo91_bins numeric(18, 5) ,@bo12_bins numeric(18, 5) ,@bo22_bins numeric(18, 5) ,@bo32_bins numeric(18, 5) ,@bo42_bins numeric(18, 5) ,@bo52_bins numeric(18, 5) ,@bo62_bins numeric(18, 5) ,@bo72_bins numeric(18, 5) ,@bo82_bins numeric(18, 5) ,@bo92_bins numeric(18, 5) ,@ebo11_bins numeric(19, 6) ,@ebo21_bins numeric(19, 6) ,@ebo31_bins numeric(19, 6) ,@ebo41_bins numeric(19, 6) ,@ebo51_bins numeric(19, 6) ,@ebo61_bins numeric(19, 6) ,@ebo71_bins numeric(18, 5) ,@ebo81_bins numeric(18, 5) ,@ebo91_bins numeric(18, 5) ,@ebo12_bins numeric(19, 6) ,@ebo22_bins numeric(19, 6) ,@ebo32_bins numeric(19, 6) ,@ebo42_bins numeric(19, 6) ,@ebo52_bins numeric(19, 6) ,@ebo62_bins numeric(19, 6) ,@ebo72_bins numeric(18, 5) ,@ebo82_bins numeric(18, 5) ,@ebo92_bins numeric(18, 5) ,@bo11_iva numeric(18, 5) ,@bo21_iva numeric(18, 5) ,@bo31_iva numeric(18, 5) ,@bo41_iva numeric(18, 5) ,@bo51_iva numeric(18, 5) ,@bo61_iva numeric(18, 5) ,@bo71_iva numeric(18, 5) ,@bo81_iva numeric(18, 5) ,@bo91_iva numeric(18, 5) ,@bo12_iva numeric(18, 5) ,@bo22_iva numeric(18, 5) ,@bo32_iva numeric(18, 5) ,@bo42_iva numeric(18, 5) ,@bo52_iva numeric(18, 5) ,@bo62_iva numeric(18, 5) ,@bo72_iva numeric(18, 5) ,@bo82_iva numeric(18, 5) ,@bo92_iva numeric(18, 5) ,@ebo11_iva numeric(19, 6) ,@ebo21_iva numeric(19, 6) ,@ebo31_iva numeric(19, 6) ,@ebo41_iva numeric(19, 6) ,@ebo51_iva numeric(19, 6) ,@ebo61_iva numeric(19, 6) ,@ebo71_iva numeric(18, 5) ,@ebo81_iva numeric(18, 5) ,@ebo91_iva numeric(18, 5) ,@ebo12_iva numeric(19, 6) ,@ebo22_iva numeric(19, 6) ,@ebo32_iva numeric(19, 6) ,@ebo42_iva numeric(19, 6) ,@ebo52_iva numeric(19, 6) ,@ebo62_iva numeric(19, 6) ,@ebo72_iva numeric(18, 5) ,@ebo82_iva numeric(18, 5) ,@ebo92_iva numeric(18, 5) ,@esdeb1 numeric(19, 6) ,@esdeb2 numeric(19, 6) ,@esdeb3 numeric(19, 6) ,@esdeb4 numeric(19, 6) ,@sdeb1 numeric(18, 5) ,@sdeb2 numeric(18, 5) ,@sdeb3 numeric(18, 5) ,@sdeb4 numeric(18, 5) ,@estot1 numeric(19, 6) ,@estot2 numeric(19, 6) ,@estot3 numeric(19, 6) ,@estot4 numeric(19, 6) ,@stot1 numeric(18, 5) ,@stot2 numeric(18, 5) ,@stot3 numeric(18, 5) ,@stot4 numeric(18, 5) ,@ebo_1tvall numeric(19, 6) ,@ebo_2tvall numeric(19, 6) ,@bo_1tvall numeric(18, 5) ,@bo_2tvall numeric(18, 5) ,@ebo_totp1 numeric(19, 6) ,@ebo_totp2 numeric(19, 6) ,@bo_totp1 numeric(18, 5) ,@bo_totp2 numeric(18, 5) ,@sqtt11 numeric(13, 3) ,@sqtt21 numeric(13, 3) ,@sqtt12 numeric(13, 3) ,@sqtt22 numeric(13, 3) ,@sqtt13 numeric(13, 3) ,@sqtt23 numeric(13, 3) ,@sqtt14 numeric(13, 3) ,@sqtt24 numeric(13, 3) ,@userinis varchar (30) ,@mybostamp char(25) = 'aut67bde4552467bde57231' declare @totaisiva table ( bostamp varchar (25), codigo numeric(1), taxa numeric (5,2), ebaseinc numeric (19,6), baseinc numeric (18,5), evalor numeric (19,6), valor numeric (18,5) ) set @prod = ( select ts.producao from bo(nolock) inner join ts(nolock) on bo.ndos = ts.ndos and bo.bostamp = @mybostamp ) set @nrdec = ( select convert(numeric(10, 0), valor) from para1(nolock) where descricao = 'de_euro' ) --set @prod = 0 --set @nrdec = 2 select @ecusto = sum(bi.epcusto * bi.qtt) ,@custo = sum(bi.pcusto * bi.qtt) ,@bo11_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo21_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo31_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo41_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo51_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo61_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo71_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo81_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo91_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.qtt * bi.pu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo12_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo22_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo32_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo42_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo52_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo62_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo72_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo82_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo92_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo11_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo21_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo31_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo41_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo51_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo61_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo71_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo81_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo91_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo12_bins = sum(case when bi.tabiva = 1 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo22_bins = sum(case when bi.tabiva = 2 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo32_bins = sum(case when bi.tabiva = 3 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo42_bins = sum(case when bi.tabiva = 4 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo52_bins = sum(case when bi.tabiva = 5 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo62_bins = sum(case when bi.tabiva = 6 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo72_bins = sum(case when bi.tabiva = 7 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo82_bins = sum(case when bi.tabiva = 8 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@ebo92_bins = sum(case when bi.tabiva = 9 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@bo_1iliq = round(sum(bi.qtt * bi.epu), @nrdec) ,@bo_2iliq = round(sum(bi.ettdeb), @nrdec) ,@bo11_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo12_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo21_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo22_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo31_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo32_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo41_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo42_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo51_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo52_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo61_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo62_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo71_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo72_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo81_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo82_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo91_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.pu) * (bi.iva / 100) else (bi.qtt * bi.pu) - ((bi.qtt * bi.pu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@bo92_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then bi.ttdeb * (bi.iva / 100) else bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo11_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo12_iva = sum(case when bi.tabiva = 1 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo21_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo22_iva = sum(case when bi.tabiva = 2 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo31_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo32_iva = sum(case when bi.tabiva = 3 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo41_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo42_iva = sum(case when bi.tabiva = 4 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo51_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo52_iva = sum(case when bi.tabiva = 5 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo61_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo62_iva = sum(case when bi.tabiva = 6 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo71_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo72_iva = sum(case when bi.tabiva = 7 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo81_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else (bi.qtt * bi.epu) - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo82_iva = sum(case when bi.tabiva = 8 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo91_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then (bi.qtt * bi.epu) * (bi.iva / 100) else bi.ettdeb - ((bi.qtt * bi.epu) / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@ebo92_iva = sum(case when bi.tabiva = 9 then round(case when bi.ivaincl = 0 then bi.ettdeb * (bi.iva / 100) else bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) end, @nrdec) else 0 end) ,@esdeb1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ettdeb else bi.ettdeb - round(bi.ettdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@esdeb4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ettdeb else round(bi.ettdeb - (bi.ettdeb / (1 + bi.iva / 100)) * bi.iva / 100, @nrdec) end else 0 end) ,@sdeb1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ttdeb else bi.ttdeb - round(bi.ttdeb / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@sdeb4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ttdeb else round(bi.ttdeb - (bi.ttdeb / (1 + bi.iva / 100)) * bi.iva / 100, @nrdec) end else 0 end) ,@smoe1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@smoe4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.ttmoeda else round(bi.ttmoeda / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@estot4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.epu else round((bi.qtt * bi.epu) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot1 = sum(case when bi.stipo <= 1 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot2 = sum(case when bi.stipo = 2 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot3 = sum(case when bi.stipo = 3 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@stot4 = sum(case when bi.stipo = 4 then case when bi.ivaincl = 0 then bi.qtt * bi.pu else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end else 0 end) ,@total = @stot1 + @stot2 + @stot3 + @stot4 ,@etotal = @estot1 + @estot2 + @estot3 + @estot4 ,@totaldeb = @sdeb1 + @sdeb2 + @sdeb3 + @sdeb4 ,@etotaldeb = @esdeb1 + @esdeb2 + @esdeb3 + @esdeb4 ,@moetotal = @smoe1 + @smoe2 + @smoe3 + @smoe4 ,@ebo_1tvall = @ebo11_bins + @ebo21_bins + @ebo31_bins + @ebo41_bins + @ebo51_bins + @ebo61_bins + @ebo71_bins + @ebo81_bins + @ebo91_bins ,@ebo_2tvall = @ebo12_bins + @ebo22_bins + @ebo32_bins + @ebo42_bins + @ebo52_bins + @ebo62_bins + @ebo72_bins + @ebo82_bins + @ebo92_bins ,@bo_1tvall = @bo11_bins + @bo21_bins + @bo31_bins + @bo41_bins + @bo51_bins + @bo61_bins + @bo71_bins + @bo81_bins + @bo91_bins ,@bo_2tvall = @bo12_bins + @bo22_bins + @bo32_bins + @bo42_bins + @bo52_bins + @bo62_bins + @bo72_bins + @bo82_bins + @bo92_bins ,@ebo_totp1 = sum(case when bi.ivaincl = 0 then (bi.epu * bi.qtt) else round((bi.epu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@ebo_totp2 = sum(case when bi.ivaincl = 0 then (bi.edebito * bi.qtt) else round((bi.edebito * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@bo_totp1 = sum(case when bi.ivaincl = 0 then (bi.pu * bi.qtt) else round((bi.pu * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@bo_totp2 = sum(case when bi.ivaincl = 0 then (bi.debito * bi.qtt) else round((bi.debito * bi.qtt) / (1 + bi.iva / 100), @nrdec) end) ,@sqtt11 = sum(case when bi.stipo = 1 then bi.qtt else 0 end) ,@sqtt21 = sum(case when bi.stipo = 1 then bi.qtt else 0 end) ,@sqtt12 = sum(case when bi.stipo = 2 then bi.qtt else 0 end) ,@sqtt22 = sum(case when bi.stipo = 2 then bi.qtt else 0 end) ,@sqtt13 = sum(case when bi.stipo = 3 then bi.qtt else 0 end) ,@sqtt23 = sum(case when bi.stipo = 3 then bi.qtt else 0 end) ,@sqtt14 = sum(case when bi.stipo = 4 then bi.qtt else 0 end) ,@sqtt24 = sum(case when bi.stipo = 5 then bi.qtt else 0 end) from bi(nolock) where bi.bostamp = @mybostamp and bi.producao = case when @prod = 1 then 1 else bi.producao end and bi.composto = 0 and bi.qtt <> 0 update bo set bo.totaldeb = isnull(@totaldeb, 0) ,bo.total = isnull(@total, 0) ,bo.etotaldeb = isnull(@etotaldeb, 0) ,bo.moetotal = isnull(@moetotal, 0) ,bo.etotal = isnull(@etotal, 0) ,bo.ecusto = isnull(@ecusto, 0) ,bo.custo = isnull(@custo, 0) ,bo.bo11_bins = isnull(@bo11_bins, 0) ,bo.bo12_bins = isnull(@bo12_bins, 0) ,bo.bo21_bins = isnull(@bo21_bins, 0) ,bo.bo22_bins = isnull(@bo22_bins, 0) ,bo.bo31_bins = isnull(@bo31_bins, 0) ,bo.bo32_bins = isnull(@bo32_bins, 0) ,bo.bo41_bins = isnull(@bo41_bins, 0) ,bo.bo42_bins = isnull(@bo42_bins, 0) ,bo.bo51_bins = isnull(@bo51_bins, 0) ,bo.bo52_bins = isnull(@bo52_bins, 0) ,bo.bo61_bins = isnull(@bo61_bins, 0) ,bo.bo62_bins = isnull(@bo62_bins, 0) ,bo.ebo11_bins = isnull(@ebo11_bins, 0) ,bo.ebo12_bins = isnull(@ebo12_bins, 0) ,bo.ebo21_bins = isnull(@ebo21_bins, 0) ,bo.ebo22_bins = isnull(@ebo22_bins, 0) ,bo.ebo31_bins = isnull(@ebo31_bins, 0) ,bo.ebo32_bins = isnull(@ebo32_bins, 0) ,bo.ebo41_bins = isnull(@ebo41_bins, 0) ,bo.ebo42_bins = isnull(@ebo42_bins, 0) ,bo.ebo51_bins = isnull(@ebo51_bins, 0) ,bo.ebo52_bins = isnull(@ebo52_bins, 0) ,bo.ebo61_bins = isnull(@ebo61_bins, 0) ,bo.ebo62_bins = isnull(@ebo62_bins, 0) ,bo.bo11_iva = isnull(@bo11_iva, 0) ,bo.bo12_iva = isnull(@bo12_iva, 0) ,bo.bo21_iva = isnull(@bo21_iva, 0) ,bo.bo22_iva = isnull(@bo22_iva, 0) ,bo.bo31_iva = isnull(@bo31_iva, 0) ,bo.bo32_iva = isnull(@bo32_iva, 0) ,bo.bo41_iva = isnull(@bo41_iva, 0) ,bo.bo42_iva = isnull(@bo42_iva, 0) ,bo.bo51_iva = isnull(@bo51_iva, 0) ,bo.bo52_iva = isnull(@bo52_iva, 0) ,bo.bo61_iva = isnull(@bo61_iva, 0) ,bo.bo62_iva = isnull(@bo62_iva, 0) ,bo.ebo11_iva = isnull(@ebo11_iva, 0) ,bo.ebo12_iva = isnull(@ebo12_iva, 0) ,bo.ebo21_iva = isnull(@ebo21_iva, 0) ,bo.ebo22_iva = isnull(@ebo22_iva, 0) ,bo.ebo31_iva = isnull(@ebo31_iva, 0) ,bo.ebo32_iva = isnull(@ebo32_iva, 0) ,bo.ebo41_iva = isnull(@ebo41_iva, 0) ,bo.ebo42_iva = isnull(@ebo42_iva, 0) ,bo.ebo51_iva = isnull(@ebo51_iva, 0) ,bo.ebo52_iva = isnull(@ebo52_iva, 0) ,bo.ebo61_iva = isnull(@ebo61_iva, 0) ,bo.ebo62_iva = isnull(@ebo62_iva, 0) ,bo.esdeb1 = isnull(@esdeb1, 0) ,bo.esdeb2 = isnull(@esdeb2, 0) ,bo.esdeb3 = isnull(@esdeb3, 0) ,bo.esdeb4 = isnull(@esdeb4, 0) ,bo.sdeb1 = isnull(@sdeb1, 0) ,bo.sdeb2 = isnull(@sdeb2, 0) ,bo.sdeb3 = isnull(@sdeb3, 0) ,bo.sdeb4 = isnull(@sdeb4, 0) ,bo.smoe1 = isnull(@smoe1, 0) ,bo.smoe2 = isnull(@smoe2, 0) ,bo.smoe3 = isnull(@smoe3, 0) ,bo.smoe4 = isnull(@smoe4, 0) ,bo.estot1 = isnull(@estot1, 0) ,bo.estot2 = isnull(@estot2, 0) ,bo.estot3 = isnull(@estot3, 0) ,bo.estot4 = isnull(@estot4, 0) ,bo.stot1 = isnull(@stot1, 0) ,bo.stot2 = isnull(@stot2, 0) ,bo.stot3 = isnull(@stot3, 0) ,bo.stot4 = isnull(@stot4, 0) ,bo.ebo_1tvall = isnull(@ebo_1tvall, 0) ,bo.ebo_2tvall = isnull(@ebo_2tvall, 0) ,bo.bo_1tvall = isnull(@bo_1tvall, 0) ,bo.bo_2tvall = isnull(@bo_2tvall, 0) ,bo.ebo_totp1 = isnull(@ebo_totp1, 0) ,bo.ebo_totp2 = isnull(@ebo_totp2, 0) ,bo.bo_totp1 = isnull(@bo_totp1, 0) ,bo.bo_totp2 = isnull(@bo_totp2, 0) ,bo.sqtt11 = isnull(@sqtt11, 0) ,bo.sqtt21 = isnull(@sqtt21, 0) ,bo.sqtt12 = isnull(@sqtt12, 0) ,bo.sqtt22 = isnull(@sqtt22, 0) ,bo.sqtt13 = isnull(@sqtt13, 0) ,bo.sqtt23 = isnull(@sqtt23, 0) ,bo.sqtt14 = isnull(@sqtt14, 0) ,bo.sqtt24 = isnull(@sqtt24, 0) where bostamp = @mybostamp update bo2 set bo2.bo71_bins = isnull(@bo71_bins, 0) ,bo2.bo72_bins = isnull(@bo72_bins, 0) ,bo2.bo81_bins = isnull(@bo81_bins, 0) ,bo2.bo82_bins = isnull(@bo82_bins, 0) ,bo2.bo91_bins = isnull(@bo91_bins, 0) ,bo2.bo92_bins = isnull(@bo92_bins, 0) ,bo2.ebo71_bins = isnull(@ebo71_bins, 0) ,bo2.ebo72_bins = isnull(@ebo72_bins, 0) ,bo2.ebo81_bins = isnull(@ebo81_bins, 0) ,bo2.ebo82_bins = isnull(@ebo82_bins, 0) ,bo2.ebo91_bins = isnull(@ebo91_bins, 0) ,bo2.ebo92_bins = isnull(@ebo92_bins, 0) ,bo2.bo71_iva = isnull(@bo71_iva, 0) ,bo2.bo72_iva = isnull(@bo72_iva, 0) ,bo2.bo81_iva = isnull(@bo81_iva, 0) ,bo2.bo82_iva = isnull(@bo82_iva, 0) ,bo2.bo91_iva = isnull(@bo91_iva, 0) ,bo2.bo92_iva = isnull(@bo92_iva, 0) ,bo2.ebo71_iva = isnull(@ebo71_iva, 0) ,bo2.ebo72_iva = isnull(@ebo72_iva, 0) ,bo2.ebo81_iva = isnull(@ebo81_iva, 0) ,bo2.ebo82_iva = isnull(@ebo82_iva, 0) ,bo2.ebo91_iva = isnull(@ebo91_iva, 0) ,bo2.ebo92_iva = isnull(@ebo92_iva, 0) ,bo2.etotalciva = isnull(@etotaldeb, 0) + isnull(@ebo12_iva, 0) +isnull(@ebo22_iva, 0) +isnull(@ebo32_iva, 0) +isnull(@ebo42_iva, 0) +isnull(@ebo52_iva, 0) +isnull(@ebo62_iva, 0) +isnull(@ebo72_iva, 0) +isnull(@ebo82_iva, 0) +isnull(@ebo92_iva, 0) --,bo2.mtotalciva =isnull(@moetotal, 0) where bo2stamp = @mybostamp -- trata os bot select @userinis = usrinis from bo where bo.bostamp=@mybostamp insert into @totaisiva ( bostamp, codigo, taxa, ebaseinc, baseinc, evalor, valor ) select @mybostamp,codigo,taxa ,case when (@ebo11_bins <>0) then @ebo11_bins else @ebo12_bins end ,case when (@ebo11_bins <>0) then @bo11_bins else @bo12_bins end ,case when (@ebo11_bins <>0) then @ebo11_iva else @ebo12_iva end ,case when (@ebo11_bins <>0) then @bo11_iva else @bo12_iva end from taxasiva where codigo = 1 union all select @mybostamp,codigo,taxa ,case when (@ebo21_bins <>0) then @ebo21_bins else @ebo22_bins end ,case when (@ebo21_bins <>0) then @bo21_bins else @bo22_bins end ,case when (@ebo21_bins <>0) then @ebo21_iva else @ebo22_iva end ,case when (@ebo21_bins <>0) then @bo21_iva else @bo22_iva end from taxasiva where codigo = 2 union all select @mybostamp,codigo,taxa ,case when (@ebo31_bins <>0) then @ebo31_bins else @ebo32_bins end ,case when (@ebo31_bins <>0) then @bo31_bins else @bo32_bins end ,case when (@ebo31_bins <>0) then @ebo31_iva else @ebo32_iva end ,case when (@ebo31_bins <>0) then @bo31_iva else @bo32_iva end from taxasiva where codigo = 3 union all select @mybostamp,codigo,taxa ,case when (@ebo41_bins <>0) then @ebo41_bins else @ebo42_bins end ,case when (@ebo41_bins <>0) then @bo41_bins else @bo42_bins end ,case when (@ebo41_bins <>0) then @ebo41_iva else @ebo42_iva end ,case when (@ebo41_bins <>0) then @bo41_iva else @bo42_iva end from taxasiva where codigo = 4 union all select @mybostamp,codigo,taxa ,case when (@ebo51_bins <>0) then @ebo51_bins else @ebo52_bins end ,case when (@ebo51_bins <>0) then @bo51_bins else @bo52_bins end ,case when (@ebo51_bins <>0) then @ebo51_iva else @ebo52_iva end ,case when (@ebo51_bins <>0) then @bo51_iva else @bo52_iva end from taxasiva where codigo = 5 union all select @mybostamp,codigo,taxa ,case when (@ebo61_bins <>0) then @ebo61_bins else @ebo62_bins end ,case when (@ebo61_bins <>0) then @bo61_bins else @bo62_bins end ,case when (@ebo61_bins <>0) then @ebo61_iva else @ebo62_iva end ,case when (@ebo61_bins <>0) then @bo61_iva else @bo62_iva end from taxasiva where codigo = 6 union all select @mybostamp,codigo,taxa ,case when (@ebo71_bins <>0) then @ebo71_bins else @ebo72_bins end ,case when (@ebo71_bins <>0) then @bo71_bins else @bo72_bins end ,case when (@ebo71_bins <>0) then @ebo71_iva else @ebo72_iva end ,case when (@ebo71_bins <>0) then @bo71_iva else @bo72_iva end from taxasiva where codigo = 7 union all select @mybostamp,codigo,taxa ,case when (@ebo81_bins <>0) then @ebo81_bins else @ebo82_bins end ,case when (@ebo81_bins <>0) then @bo81_bins else @bo82_bins end ,case when (@ebo81_bins <>0) then @ebo81_iva else @ebo82_iva end ,case when (@ebo81_bins <>0) then @bo81_iva else @bo82_iva end from taxasiva where codigo = 8 union all select @mybostamp,codigo,taxa ,case when (@ebo91_bins <>0) then @ebo91_bins else @ebo92_bins end ,case when (@ebo91_bins <>0) then @bo91_bins else @bo92_bins end ,case when (@ebo91_bins <>0) then @ebo91_iva else @ebo92_iva end ,case when (@ebo91_bins <>0) then @bo91_iva else @bo92_iva end from taxasiva where codigo = 9 update bot set ebaseinc = totiva.ebaseinc, baseinc = totiva.baseinc, evalor = totiva.evalor, valor = totiva.valor, usrinis = @userinis, usrdata = convert (date,getdate()), usrhora = convert (time,getdate()) from @totaisiva totiva inner join bot on totiva.bostamp = bot.bostamp and totiva.codigo = bot.codigo insert into bot ( botstamp ,bostamp ,codigo ,taxa ,ebaseinc ,baseinc ,evalor ,valor ,ousrinis ,ousrdata ,ousrhora ,usrinis ,usrdata ,usrhora ) select ( left(@userinis,3) + 'tt' + left(newid(),5) + right(newid(),5) + left(newid(),5) + right(newid(),5)) stamp ,@mybostamp stampbo ,totiva.codigo ,totiva.taxa ,totiva.ebaseinc ,totiva.baseinc ,totiva.evalor ,totiva.valor ,@userinis ,convert (date,getdate()) ,convert (time,getdate()) ,@userinis ,convert (date,getdate()) ,convert (time,getdate()) from @totaisiva totiva left join bot on totiva.bostamp = bot.bostamp and totiva.codigo = bot.codigo where bot.botstamp is null -- atualiza os campo bi.series e bi.series2, caso tenha equipamentos update bi set series = s1, series2=s2 from bi inner join ( select distinct bistamp,ser.s1, ser.s2 from boma cross apply (select stuff ( ( select ',' + rtrim(serie) from boma myboma where myboma.bistamp = boma.bistamp order by serie for xml path('') ), 1, 1, '' ) s1 , stuff ( ( select ',' + rtrim(serie2) from boma myboma where myboma.bistamp = boma.bistamp order by serie for xml path('') ), 1, 1, '' ) s2 ) ser where boma.bostamp = @mybostamp ) myboma on bi.bistamp = myboma.bistamp where bi.bostamp = @mybostamp 
20250225@154526.3951 7fat50idq1f0if9lvbl7g4a62e Query : use flama_phc
20250225@154526.3955 7fat50idq1f0if9lvbl7g4a62e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@154526.4014 7fat50idq1f0if9lvbl7g4a62e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5523';
20250225@154526.4066 7fat50idq1f0if9lvbl7g4a62e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5523';
20250225@161909.8098 9sp5lsqrsdani48mi0ihtdhi2g Query : use flama_phc
20250225@161909.8103 9sp5lsqrsdani48mi0ihtdhi2g Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@161909.8475 9sp5lsqrsdani48mi0ihtdhi2g Query : use flama_phc
20250225@161909.8478 9sp5lsqrsdani48mi0ihtdhi2g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@163609.5753 pnra4g8e326tbtc21ovfvhbsf7 Query : use flama_phc
20250225@163609.5758 pnra4g8e326tbtc21ovfvhbsf7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@163609.5923 pnra4g8e326tbtc21ovfvhbsf7 Query : use flama_phc
20250225@163609.5927 pnra4g8e326tbtc21ovfvhbsf7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@171911.1153 m76i70p7v0lct0tk7fpppunngb Query : use flama_phc
20250225@171911.1158 m76i70p7v0lct0tk7fpppunngb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@171911.1334 m76i70p7v0lct0tk7fpppunngb Query : use flama_phc
20250225@171911.1338 m76i70p7v0lct0tk7fpppunngb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@173610.9817 df0tnf1btortk4j7erndj9d0ra Query : use flama_phc
20250225@173610.9823 df0tnf1btortk4j7erndj9d0ra Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@173610.9915 df0tnf1btortk4j7erndj9d0ra Query : use flama_phc
20250225@173610.9919 df0tnf1btortk4j7erndj9d0ra Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@174059.1384 jjhv4bp8jg92fa56e1v7290knf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174059.1402 jjhv4bp8jg92fa56e1v7290knf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174059.1760 jjhv4bp8jg92fa56e1v7290knf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5524';
20250225@174059.1837 jjhv4bp8jg92fa56e1v7290knf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5524';
20250225@174059.1910 jjhv4bp8jg92fa56e1v7290knf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5524';
20250225@174059.1978 jjhv4bp8jg92fa56e1v7290knf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5524';
20250225@174059.2062 jjhv4bp8jg92fa56e1v7290knf Query : use flama_phc
20250225@174059.2066 jjhv4bp8jg92fa56e1v7290knf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174059.2169 jjhv4bp8jg92fa56e1v7290knf Query : use flama_phc
20250225@174059.2172 jjhv4bp8jg92fa56e1v7290knf Query : select no, estab,szadrsdesc from szadrs where u_coddest=3457
20250225@174059.2268 jjhv4bp8jg92fa56e1v7290knf Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2013 and bo.obrano = 2501397 
20250225@174059.2746 jjhv4bp8jg92fa56e1v7290knf Query : use flama_phc
20250225@174059.2749 jjhv4bp8jg92fa56e1v7290knf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174059.2826 jjhv4bp8jg92fa56e1v7290knf Query : use flama_phc
20250225@174059.2830 jjhv4bp8jg92fa56e1v7290knf Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174059.2896 jjhv4bp8jg92fa56e1v7290knf Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174059.2930 jjhv4bp8jg92fa56e1v7290knf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5524';
20250225@174059.2978 jjhv4bp8jg92fa56e1v7290knf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5524';
20250225@174059.4000 im6rbsfdc8m3eb2gio8vccns6k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174059.4014 im6rbsfdc8m3eb2gio8vccns6k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174059.4091 im6rbsfdc8m3eb2gio8vccns6k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5525';
20250225@174059.4163 im6rbsfdc8m3eb2gio8vccns6k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5525';
20250225@174059.4232 im6rbsfdc8m3eb2gio8vccns6k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5525';
20250225@174059.4271 im6rbsfdc8m3eb2gio8vccns6k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5525';
20250225@174059.4332 im6rbsfdc8m3eb2gio8vccns6k Query : use flama_phc
20250225@174059.4335 im6rbsfdc8m3eb2gio8vccns6k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174059.4395 im6rbsfdc8m3eb2gio8vccns6k Query : use flama_phc
20250225@174059.4398 im6rbsfdc8m3eb2gio8vccns6k Query : select no, estab,szadrsdesc from szadrs where u_coddest=864
20250225@174059.4490 im6rbsfdc8m3eb2gio8vccns6k Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2013 and bo.obrano = 2501398 
20250225@174059.5006 im6rbsfdc8m3eb2gio8vccns6k Query : use flama_phc
20250225@174059.5010 im6rbsfdc8m3eb2gio8vccns6k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174059.5092 im6rbsfdc8m3eb2gio8vccns6k Query : use flama_phc
20250225@174059.5097 im6rbsfdc8m3eb2gio8vccns6k Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174059.5119 im6rbsfdc8m3eb2gio8vccns6k Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174059.5149 im6rbsfdc8m3eb2gio8vccns6k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5525';
20250225@174059.5416 im6rbsfdc8m3eb2gio8vccns6k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5525';
20250225@174059.6108 rvcgguul45kn8sldeg32fr614i Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174059.6147 rvcgguul45kn8sldeg32fr614i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174059.6257 rvcgguul45kn8sldeg32fr614i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5526';
20250225@174059.6332 rvcgguul45kn8sldeg32fr614i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5526';
20250225@174059.6547 rvcgguul45kn8sldeg32fr614i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5526';
20250225@174059.6633 rvcgguul45kn8sldeg32fr614i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5526';
20250225@174059.6705 rvcgguul45kn8sldeg32fr614i Query : use flama_phc
20250225@174059.6708 rvcgguul45kn8sldeg32fr614i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174059.8035 rvcgguul45kn8sldeg32fr614i Query : use flama_phc
20250225@174059.8039 rvcgguul45kn8sldeg32fr614i Query : select no, estab,szadrsdesc from szadrs where u_coddest=375
20250225@174059.8146 rvcgguul45kn8sldeg32fr614i Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2013 and bo.obrano = 2501399 
20250225@174059.8793 rvcgguul45kn8sldeg32fr614i Query : use flama_phc
20250225@174059.8799 rvcgguul45kn8sldeg32fr614i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174059.8835 rvcgguul45kn8sldeg32fr614i Query : use flama_phc
20250225@174059.8838 rvcgguul45kn8sldeg32fr614i Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174059.8857 rvcgguul45kn8sldeg32fr614i Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174059.8879 rvcgguul45kn8sldeg32fr614i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5526';
20250225@174059.8927 rvcgguul45kn8sldeg32fr614i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5526';
20250225@174059.9635 rdgau4rip9qti14rqubj8qlr4c Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174059.9647 rdgau4rip9qti14rqubj8qlr4c Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174059.9754 rdgau4rip9qti14rqubj8qlr4c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5527';
20250225@174059.9826 rdgau4rip9qti14rqubj8qlr4c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5527';
20250225@174059.9940 rdgau4rip9qti14rqubj8qlr4c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5527';
20250225@174100.2000 rdgau4rip9qti14rqubj8qlr4c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5527';
20250225@174100.1310 rdgau4rip9qti14rqubj8qlr4c Query : use flama_phc
20250225@174100.1370 rdgau4rip9qti14rqubj8qlr4c Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174100.4800 rdgau4rip9qti14rqubj8qlr4c Query : use flama_phc
20250225@174100.4840 rdgau4rip9qti14rqubj8qlr4c Query : select no, estab,szadrsdesc from szadrs where u_coddest=886
20250225@174100.7900 rdgau4rip9qti14rqubj8qlr4c Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501402 
20250225@174100.1718 rdgau4rip9qti14rqubj8qlr4c Query : use flama_phc
20250225@174100.1721 rdgau4rip9qti14rqubj8qlr4c Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174100.1824 rdgau4rip9qti14rqubj8qlr4c Query : use flama_phc
20250225@174100.1828 rdgau4rip9qti14rqubj8qlr4c Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174100.1845 rdgau4rip9qti14rqubj8qlr4c Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174100.1876 rdgau4rip9qti14rqubj8qlr4c Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5527';
20250225@174100.1933 rdgau4rip9qti14rqubj8qlr4c Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5527';
20250225@174100.2516 c6k5eh1il1sq8tuigrejasb580 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174100.2529 c6k5eh1il1sq8tuigrejasb580 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174100.2610 c6k5eh1il1sq8tuigrejasb580 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5528';
20250225@174100.2708 c6k5eh1il1sq8tuigrejasb580 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5528';
20250225@174100.2791 c6k5eh1il1sq8tuigrejasb580 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5528';
20250225@174100.2846 c6k5eh1il1sq8tuigrejasb580 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5528';
20250225@174100.2942 c6k5eh1il1sq8tuigrejasb580 Query : use flama_phc
20250225@174100.2955 c6k5eh1il1sq8tuigrejasb580 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174100.3033 c6k5eh1il1sq8tuigrejasb580 Query : use flama_phc
20250225@174100.3063 c6k5eh1il1sq8tuigrejasb580 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250225@174100.3198 c6k5eh1il1sq8tuigrejasb580 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501406 
20250225@174100.3680 c6k5eh1il1sq8tuigrejasb580 Query : use flama_phc
20250225@174100.3684 c6k5eh1il1sq8tuigrejasb580 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174100.3720 c6k5eh1il1sq8tuigrejasb580 Query : use flama_phc
20250225@174100.3724 c6k5eh1il1sq8tuigrejasb580 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174100.3743 c6k5eh1il1sq8tuigrejasb580 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174100.3768 c6k5eh1il1sq8tuigrejasb580 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5528';
20250225@174100.3824 c6k5eh1il1sq8tuigrejasb580 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5528';
20250225@174100.4446 8g239kk3oj5udnvl77bkvspi3h Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174100.4456 8g239kk3oj5udnvl77bkvspi3h Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174100.4533 8g239kk3oj5udnvl77bkvspi3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5529';
20250225@174100.4604 8g239kk3oj5udnvl77bkvspi3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5529';
20250225@174100.4677 8g239kk3oj5udnvl77bkvspi3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5529';
20250225@174100.4741 8g239kk3oj5udnvl77bkvspi3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5529';
20250225@174100.4815 8g239kk3oj5udnvl77bkvspi3h Query : use flama_phc
20250225@174100.4819 8g239kk3oj5udnvl77bkvspi3h Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174100.4891 8g239kk3oj5udnvl77bkvspi3h Query : use flama_phc
20250225@174100.4894 8g239kk3oj5udnvl77bkvspi3h Query : select no, estab,szadrsdesc from szadrs where u_coddest=1152
20250225@174100.4984 8g239kk3oj5udnvl77bkvspi3h Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501407 
20250225@174100.5586 8g239kk3oj5udnvl77bkvspi3h Query : use flama_phc
20250225@174100.5589 8g239kk3oj5udnvl77bkvspi3h Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174100.5620 8g239kk3oj5udnvl77bkvspi3h Query : use flama_phc
20250225@174100.5623 8g239kk3oj5udnvl77bkvspi3h Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174100.5640 8g239kk3oj5udnvl77bkvspi3h Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174100.5686 8g239kk3oj5udnvl77bkvspi3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5529';
20250225@174100.5758 8g239kk3oj5udnvl77bkvspi3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5529';
20250225@174100.6398 t3d7ln00d0pqd8fs0sr49098c3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174100.6409 t3d7ln00d0pqd8fs0sr49098c3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174100.6525 t3d7ln00d0pqd8fs0sr49098c3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5530';
20250225@174100.6774 t3d7ln00d0pqd8fs0sr49098c3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5530';
20250225@174100.6849 t3d7ln00d0pqd8fs0sr49098c3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5530';
20250225@174100.6904 t3d7ln00d0pqd8fs0sr49098c3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5530';
20250225@174100.6992 t3d7ln00d0pqd8fs0sr49098c3 Query : use flama_phc
20250225@174100.6996 t3d7ln00d0pqd8fs0sr49098c3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174100.7090 t3d7ln00d0pqd8fs0sr49098c3 Query : use flama_phc
20250225@174100.7094 t3d7ln00d0pqd8fs0sr49098c3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6917
20250225@174100.7190 t3d7ln00d0pqd8fs0sr49098c3 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501410 
20250225@174100.7768 t3d7ln00d0pqd8fs0sr49098c3 Query : use flama_phc
20250225@174100.7772 t3d7ln00d0pqd8fs0sr49098c3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174100.7849 t3d7ln00d0pqd8fs0sr49098c3 Query : use flama_phc
20250225@174100.7853 t3d7ln00d0pqd8fs0sr49098c3 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174100.7873 t3d7ln00d0pqd8fs0sr49098c3 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174100.7906 t3d7ln00d0pqd8fs0sr49098c3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5530';
20250225@174100.7953 t3d7ln00d0pqd8fs0sr49098c3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5530';
20250225@174100.8594 ecvh43l08k7o4v5uvdokfbl1j4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174100.8606 ecvh43l08k7o4v5uvdokfbl1j4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174100.8682 ecvh43l08k7o4v5uvdokfbl1j4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5531';
20250225@174100.8754 ecvh43l08k7o4v5uvdokfbl1j4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5531';
20250225@174100.8823 ecvh43l08k7o4v5uvdokfbl1j4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5531';
20250225@174100.8865 ecvh43l08k7o4v5uvdokfbl1j4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5531';
20250225@174100.8935 ecvh43l08k7o4v5uvdokfbl1j4 Query : use flama_phc
20250225@174100.8938 ecvh43l08k7o4v5uvdokfbl1j4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174100.9045 ecvh43l08k7o4v5uvdokfbl1j4 Query : use flama_phc
20250225@174100.9079 ecvh43l08k7o4v5uvdokfbl1j4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4779
20250225@174100.9211 ecvh43l08k7o4v5uvdokfbl1j4 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501411 
20250225@174100.9972 ecvh43l08k7o4v5uvdokfbl1j4 Query : use flama_phc
20250225@174100.9976 ecvh43l08k7o4v5uvdokfbl1j4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174101.1920 ecvh43l08k7o4v5uvdokfbl1j4 Query : use flama_phc
20250225@174101.1960 ecvh43l08k7o4v5uvdokfbl1j4 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174101.3300 ecvh43l08k7o4v5uvdokfbl1j4 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174101.3510 ecvh43l08k7o4v5uvdokfbl1j4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5531';
20250225@174101.4310 ecvh43l08k7o4v5uvdokfbl1j4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5531';
20250225@174101.1041 k45ivbjv3ictelkpln2vqh7dsc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174101.1062 k45ivbjv3ictelkpln2vqh7dsc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174101.1206 k45ivbjv3ictelkpln2vqh7dsc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5532';
20250225@174101.1305 k45ivbjv3ictelkpln2vqh7dsc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5532';
20250225@174101.1408 k45ivbjv3ictelkpln2vqh7dsc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5532';
20250225@174101.1451 k45ivbjv3ictelkpln2vqh7dsc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5532';
20250225@174101.1515 k45ivbjv3ictelkpln2vqh7dsc Query : use flama_phc
20250225@174101.1518 k45ivbjv3ictelkpln2vqh7dsc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174101.1650 k45ivbjv3ictelkpln2vqh7dsc Query : use flama_phc
20250225@174101.1653 k45ivbjv3ictelkpln2vqh7dsc Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250225@174101.1701 k45ivbjv3ictelkpln2vqh7dsc Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501412 
20250225@174101.2146 k45ivbjv3ictelkpln2vqh7dsc Query : use flama_phc
20250225@174101.2149 k45ivbjv3ictelkpln2vqh7dsc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174101.2181 k45ivbjv3ictelkpln2vqh7dsc Query : use flama_phc
20250225@174101.2184 k45ivbjv3ictelkpln2vqh7dsc Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174101.2202 k45ivbjv3ictelkpln2vqh7dsc Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174101.2224 k45ivbjv3ictelkpln2vqh7dsc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5532';
20250225@174101.2270 k45ivbjv3ictelkpln2vqh7dsc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5532';
20250225@174101.2932 uldjgjucsq9biuaj8l44b1u688 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174101.2943 uldjgjucsq9biuaj8l44b1u688 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174101.3077 uldjgjucsq9biuaj8l44b1u688 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5533';
20250225@174101.3186 uldjgjucsq9biuaj8l44b1u688 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5533';
20250225@174101.3334 uldjgjucsq9biuaj8l44b1u688 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5533';
20250225@174101.3388 uldjgjucsq9biuaj8l44b1u688 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5533';
20250225@174101.3468 uldjgjucsq9biuaj8l44b1u688 Query : use flama_phc
20250225@174101.3472 uldjgjucsq9biuaj8l44b1u688 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174101.3536 uldjgjucsq9biuaj8l44b1u688 Query : use flama_phc
20250225@174101.3547 uldjgjucsq9biuaj8l44b1u688 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250225@174101.3629 uldjgjucsq9biuaj8l44b1u688 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501414 
20250225@174101.4157 uldjgjucsq9biuaj8l44b1u688 Query : use flama_phc
20250225@174101.4162 uldjgjucsq9biuaj8l44b1u688 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174101.4220 uldjgjucsq9biuaj8l44b1u688 Query : use flama_phc
20250225@174101.4225 uldjgjucsq9biuaj8l44b1u688 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174101.4244 uldjgjucsq9biuaj8l44b1u688 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174101.4270 uldjgjucsq9biuaj8l44b1u688 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5533';
20250225@174101.4341 uldjgjucsq9biuaj8l44b1u688 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5533';
20250225@174101.5097 r6kesg1ncaktsfbokd468l4vi4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174101.5110 r6kesg1ncaktsfbokd468l4vi4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174101.5205 r6kesg1ncaktsfbokd468l4vi4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5534';
20250225@174101.5368 r6kesg1ncaktsfbokd468l4vi4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5534';
20250225@174101.5457 r6kesg1ncaktsfbokd468l4vi4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5534';
20250225@174101.5517 r6kesg1ncaktsfbokd468l4vi4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5534';
20250225@174101.5607 r6kesg1ncaktsfbokd468l4vi4 Query : use flama_phc
20250225@174101.5612 r6kesg1ncaktsfbokd468l4vi4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174101.5683 r6kesg1ncaktsfbokd468l4vi4 Query : use flama_phc
20250225@174101.5687 r6kesg1ncaktsfbokd468l4vi4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20250225@174101.5868 r6kesg1ncaktsfbokd468l4vi4 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501415 
20250225@174101.6891 r6kesg1ncaktsfbokd468l4vi4 Query : use flama_phc
20250225@174101.6969 r6kesg1ncaktsfbokd468l4vi4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174101.7114 r6kesg1ncaktsfbokd468l4vi4 Query : use flama_phc
20250225@174101.7119 r6kesg1ncaktsfbokd468l4vi4 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174101.7225 r6kesg1ncaktsfbokd468l4vi4 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174101.7260 r6kesg1ncaktsfbokd468l4vi4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5534';
20250225@174101.7323 r6kesg1ncaktsfbokd468l4vi4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5534';
20250225@174101.7953 m2f5ffstq0srrrjt15hkn4ab70 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174101.7989 m2f5ffstq0srrrjt15hkn4ab70 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174101.8070 m2f5ffstq0srrrjt15hkn4ab70 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5535';
20250225@174101.8155 m2f5ffstq0srrrjt15hkn4ab70 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5535';
20250225@174101.8241 m2f5ffstq0srrrjt15hkn4ab70 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5535';
20250225@174101.8302 m2f5ffstq0srrrjt15hkn4ab70 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5535';
20250225@174101.9699 m2f5ffstq0srrrjt15hkn4ab70 Query : use flama_phc
20250225@174101.9703 m2f5ffstq0srrrjt15hkn4ab70 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174101.9837 m2f5ffstq0srrrjt15hkn4ab70 Query : use flama_phc
20250225@174101.9841 m2f5ffstq0srrrjt15hkn4ab70 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3155
20250225@174102.1000 m2f5ffstq0srrrjt15hkn4ab70 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501416 
20250225@174102.6570 m2f5ffstq0srrrjt15hkn4ab70 Query : use flama_phc
20250225@174102.6620 m2f5ffstq0srrrjt15hkn4ab70 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174102.6990 m2f5ffstq0srrrjt15hkn4ab70 Query : use flama_phc
20250225@174102.7030 m2f5ffstq0srrrjt15hkn4ab70 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174102.7220 m2f5ffstq0srrrjt15hkn4ab70 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174102.7800 m2f5ffstq0srrrjt15hkn4ab70 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5535';
20250225@174102.8510 m2f5ffstq0srrrjt15hkn4ab70 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5535';
20250225@174102.1489 j0dimhiqju4tnkehbnirbvdo18 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174102.1522 j0dimhiqju4tnkehbnirbvdo18 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174102.1673 j0dimhiqju4tnkehbnirbvdo18 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5536';
20250225@174102.1764 j0dimhiqju4tnkehbnirbvdo18 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5536';
20250225@174102.1855 j0dimhiqju4tnkehbnirbvdo18 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5536';
20250225@174102.1904 j0dimhiqju4tnkehbnirbvdo18 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5536';
20250225@174102.1980 j0dimhiqju4tnkehbnirbvdo18 Query : use flama_phc
20250225@174102.1984 j0dimhiqju4tnkehbnirbvdo18 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174102.2078 j0dimhiqju4tnkehbnirbvdo18 Query : use flama_phc
20250225@174102.2082 j0dimhiqju4tnkehbnirbvdo18 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1023
20250225@174102.2197 j0dimhiqju4tnkehbnirbvdo18 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501417 
20250225@174102.2777 j0dimhiqju4tnkehbnirbvdo18 Query : use flama_phc
20250225@174102.2780 j0dimhiqju4tnkehbnirbvdo18 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174102.2813 j0dimhiqju4tnkehbnirbvdo18 Query : use flama_phc
20250225@174102.2816 j0dimhiqju4tnkehbnirbvdo18 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174102.2834 j0dimhiqju4tnkehbnirbvdo18 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174102.2855 j0dimhiqju4tnkehbnirbvdo18 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5536';
20250225@174102.2922 j0dimhiqju4tnkehbnirbvdo18 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5536';
20250225@174102.3715 7krt3500vgfoj6nb40jdnbbhbh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@174102.3727 7krt3500vgfoj6nb40jdnbbhbh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@174102.3810 7krt3500vgfoj6nb40jdnbbhbh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5537';
20250225@174102.3909 7krt3500vgfoj6nb40jdnbbhbh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5537';
20250225@174102.4001 7krt3500vgfoj6nb40jdnbbhbh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5537';
20250225@174102.4064 7krt3500vgfoj6nb40jdnbbhbh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5537';
20250225@174102.4143 7krt3500vgfoj6nb40jdnbbhbh Query : use flama_phc
20250225@174102.4148 7krt3500vgfoj6nb40jdnbbhbh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@174102.4213 7krt3500vgfoj6nb40jdnbbhbh Query : use flama_phc
20250225@174102.4217 7krt3500vgfoj6nb40jdnbbhbh Query : select no, estab,szadrsdesc from szadrs where u_coddest=2679
20250225@174102.4320 7krt3500vgfoj6nb40jdnbbhbh Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501419 
20250225@174102.4783 7krt3500vgfoj6nb40jdnbbhbh Query : use flama_phc
20250225@174102.4787 7krt3500vgfoj6nb40jdnbbhbh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@174102.4816 7krt3500vgfoj6nb40jdnbbhbh Query : use flama_phc
20250225@174102.4819 7krt3500vgfoj6nb40jdnbbhbh Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@174102.4835 7krt3500vgfoj6nb40jdnbbhbh Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@174102.4856 7krt3500vgfoj6nb40jdnbbhbh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5537';
20250225@174102.4907 7krt3500vgfoj6nb40jdnbbhbh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5537';
20250225@175549.4878 fjg6rsq26f08uq3nrearasp1hj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@175549.4904 fjg6rsq26f08uq3nrearasp1hj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@175549.4981 fjg6rsq26f08uq3nrearasp1hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5538';
20250225@175549.5049 fjg6rsq26f08uq3nrearasp1hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5538';
20250225@175549.5121 fjg6rsq26f08uq3nrearasp1hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5538';
20250225@175549.5162 fjg6rsq26f08uq3nrearasp1hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5538';
20250225@175549.5243 fjg6rsq26f08uq3nrearasp1hj Query : use flama_phc
20250225@175549.5246 fjg6rsq26f08uq3nrearasp1hj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@175549.5314 fjg6rsq26f08uq3nrearasp1hj Query : use flama_phc
20250225@175549.5317 fjg6rsq26f08uq3nrearasp1hj Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250225@175549.5368 fjg6rsq26f08uq3nrearasp1hj Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501413 
20250225@175549.5819 fjg6rsq26f08uq3nrearasp1hj Query : use flama_phc
20250225@175549.5822 fjg6rsq26f08uq3nrearasp1hj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@175549.5857 fjg6rsq26f08uq3nrearasp1hj Query : use flama_phc
20250225@175549.5861 fjg6rsq26f08uq3nrearasp1hj Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@175549.5878 fjg6rsq26f08uq3nrearasp1hj Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@175549.5902 fjg6rsq26f08uq3nrearasp1hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5538';
20250225@175549.5953 fjg6rsq26f08uq3nrearasp1hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5538';
20250225@175549.6504 747cm68upqu87luesl58iq0e89 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250225@175549.6515 747cm68upqu87luesl58iq0e89 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250225@175549.6592 747cm68upqu87luesl58iq0e89 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5539';
20250225@175549.6662 747cm68upqu87luesl58iq0e89 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5539';
20250225@175549.6740 747cm68upqu87luesl58iq0e89 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5539';
20250225@175549.6780 747cm68upqu87luesl58iq0e89 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5539';
20250225@175549.6889 747cm68upqu87luesl58iq0e89 Query : use flama_phc
20250225@175549.6892 747cm68upqu87luesl58iq0e89 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250225@175549.6961 747cm68upqu87luesl58iq0e89 Query : use flama_phc
20250225@175549.6965 747cm68upqu87luesl58iq0e89 Query : select no, estab,szadrsdesc from szadrs where u_coddest=315
20250225@175549.7081 747cm68upqu87luesl58iq0e89 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2014 and bo.obrano = 2501418 
20250225@175549.7521 747cm68upqu87luesl58iq0e89 Query : use flama_phc
20250225@175549.7526 747cm68upqu87luesl58iq0e89 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250225@175549.7561 747cm68upqu87luesl58iq0e89 Query : use flama_phc
20250225@175549.7565 747cm68upqu87luesl58iq0e89 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250225@175549.7586 747cm68upqu87luesl58iq0e89 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250225@175549.7651 747cm68upqu87luesl58iq0e89 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5539';
20250225@175549.7704 747cm68upqu87luesl58iq0e89 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5539';
20250225@181908.5701 07o4vmmsvdklkoegam2qom8dnp Query : use flama_phc
20250225@181908.5744 07o4vmmsvdklkoegam2qom8dnp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@181908.5870 07o4vmmsvdklkoegam2qom8dnp Query : use flama_phc
20250225@181908.5874 07o4vmmsvdklkoegam2qom8dnp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@183608.9418 ijq5sbvt3gngcrnkbajq26aa0t Query : use flama_phc
20250225@183608.9424 ijq5sbvt3gngcrnkbajq26aa0t Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@183608.9518 ijq5sbvt3gngcrnkbajq26aa0t Query : use flama_phc
20250225@183608.9523 ijq5sbvt3gngcrnkbajq26aa0t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@191933.4901 8hcfktpskofb5nl17q87t5ec0m Query : use flama_phc
20250225@191933.4905 8hcfktpskofb5nl17q87t5ec0m Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@191933.4993 8hcfktpskofb5nl17q87t5ec0m Query : use flama_phc
20250225@191933.4997 8hcfktpskofb5nl17q87t5ec0m Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@191933.5756 ijepp84q3gtq618hj00u3ans16 Query : use flama_phc
20250225@191933.5760 ijepp84q3gtq618hj00u3ans16 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@191933.5849 ijepp84q3gtq618hj00u3ans16 Query : use flama_phc
20250225@191933.5852 ijepp84q3gtq618hj00u3ans16 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@193610.3783 irdg0bcc21vefm4p5oq3mnahbs Query : use flama_phc
20250225@193610.3818 irdg0bcc21vefm4p5oq3mnahbs Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@193610.3906 irdg0bcc21vefm4p5oq3mnahbs Query : use flama_phc
20250225@193610.3909 irdg0bcc21vefm4p5oq3mnahbs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@201909.8927 5lejkiedhpaal3phvq1mvs6ufn Query : use flama_phc
20250225@201909.8931 5lejkiedhpaal3phvq1mvs6ufn Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@201909.9033 5lejkiedhpaal3phvq1mvs6ufn Query : use flama_phc
20250225@201909.9036 5lejkiedhpaal3phvq1mvs6ufn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@203609.4607 j1pccbuei10c8bnjf55dtrsicd Query : use flama_phc
20250225@203609.4638 j1pccbuei10c8bnjf55dtrsicd Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@203609.4814 j1pccbuei10c8bnjf55dtrsicd Query : use flama_phc
20250225@203609.4817 j1pccbuei10c8bnjf55dtrsicd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@211909.1371 970acemkt6ck20jsi6brdsmlsc Query : use flama_phc
20250225@211909.1405 970acemkt6ck20jsi6brdsmlsc Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@211909.1734 970acemkt6ck20jsi6brdsmlsc Query : use flama_phc
20250225@211909.1738 970acemkt6ck20jsi6brdsmlsc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@213609.1552 0uciu2qr2t69dg94vf84vo26tl Query : use flama_phc
20250225@213609.1557 0uciu2qr2t69dg94vf84vo26tl Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@213609.1649 0uciu2qr2t69dg94vf84vo26tl Query : use flama_phc
20250225@213609.1653 0uciu2qr2t69dg94vf84vo26tl Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@221911.3045 706k2f3j251mjq7qbk7qcdq6jg Query : use flama_phc
20250225@221911.3049 706k2f3j251mjq7qbk7qcdq6jg Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@221911.3147 706k2f3j251mjq7qbk7qcdq6jg Query : use flama_phc
20250225@221911.3151 706k2f3j251mjq7qbk7qcdq6jg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@223611.8015 p0bunmuqi5mt8jp22vj6rbfk4a Query : use flama_phc
20250225@223611.8019 p0bunmuqi5mt8jp22vj6rbfk4a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@223611.8165 p0bunmuqi5mt8jp22vj6rbfk4a Query : use flama_phc
20250225@223611.8169 p0bunmuqi5mt8jp22vj6rbfk4a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@231908.6761 8h6moek49e2nucahur9hf7cp18 Query : use flama_phc
20250225@231908.6767 8h6moek49e2nucahur9hf7cp18 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@231908.6863 8h6moek49e2nucahur9hf7cp18 Query : use flama_phc
20250225@231908.6867 8h6moek49e2nucahur9hf7cp18 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250225@233608.1934 o0rpv5iq9c53r8lpt5c0c99a91 Query : use flama_phc
20250225@233608.1939 o0rpv5iq9c53r8lpt5c0c99a91 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250225@233608.2072 o0rpv5iq9c53r8lpt5c0c99a91 Query : use flama_phc
20250225@233608.2076 o0rpv5iq9c53r8lpt5c0c99a91 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@071908.2648 tr33av6oiceo11n9dbsl9sq1ut Query : use flama_phc
20250226@071908.2653 tr33av6oiceo11n9dbsl9sq1ut Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@071908.2804 tr33av6oiceo11n9dbsl9sq1ut Query : use flama_phc
20250226@071908.2808 tr33av6oiceo11n9dbsl9sq1ut Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@073616.7641 jks56e33eidlnl7d12g2dsvt7r Query : use flama_phc
20250226@073616.7685 jks56e33eidlnl7d12g2dsvt7r Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@073616.8401 jks56e33eidlnl7d12g2dsvt7r Query : use flama_phc
20250226@073616.8405 jks56e33eidlnl7d12g2dsvt7r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@081908.6397 ekkvuroqkdjjgegvlgpkh7vauh Query : use flama_phc
20250226@081908.6402 ekkvuroqkdjjgegvlgpkh7vauh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@081908.6536 ekkvuroqkdjjgegvlgpkh7vauh Query : use flama_phc
20250226@081908.6539 ekkvuroqkdjjgegvlgpkh7vauh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@083608.4693 sscprdh7088np8461ovhod3l6l Query : use flama_phc
20250226@083608.4697 sscprdh7088np8461ovhod3l6l Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@083608.4800 sscprdh7088np8461ovhod3l6l Query : use flama_phc
20250226@083608.4803 sscprdh7088np8461ovhod3l6l Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@091908.1768 cq8h6qrbqh750im4kbkr3sdi6g Query : use flama_phc
20250226@091908.1774 cq8h6qrbqh750im4kbkr3sdi6g Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@091908.1891 cq8h6qrbqh750im4kbkr3sdi6g Query : use flama_phc
20250226@091908.1895 cq8h6qrbqh750im4kbkr3sdi6g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@093608.4300 oefagsh2o90nk7lhd4r60n35qo Query : use flama_phc
20250226@093608.4345 oefagsh2o90nk7lhd4r60n35qo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@093608.5162 oefagsh2o90nk7lhd4r60n35qo Query : use flama_phc
20250226@093608.5207 oefagsh2o90nk7lhd4r60n35qo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@101908.4169 gurp343qvcpd3q1ua4jelk113n Query : use flama_phc
20250226@101908.4175 gurp343qvcpd3q1ua4jelk113n Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@101908.4283 gurp343qvcpd3q1ua4jelk113n Query : use flama_phc
20250226@101908.4288 gurp343qvcpd3q1ua4jelk113n Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@103608.3360 5armnrnt29l5n856qetbkb9u32 Query : use flama_phc
20250226@103608.3364 5armnrnt29l5n856qetbkb9u32 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@103608.3454 5armnrnt29l5n856qetbkb9u32 Query : use flama_phc
20250226@103608.3459 5armnrnt29l5n856qetbkb9u32 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@111907.9816 5jg8iskv6lghdf086h1st51lms Query : use flama_phc
20250226@111907.9974 5jg8iskv6lghdf086h1st51lms Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@111908.2542 5jg8iskv6lghdf086h1st51lms Query : use flama_phc
20250226@111908.2637 5jg8iskv6lghdf086h1st51lms Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@113608.7310 bu7f7nladi85s7i1f5d5o6689f Query : use flama_phc
20250226@113608.7360 bu7f7nladi85s7i1f5d5o6689f Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@113608.8300 bu7f7nladi85s7i1f5d5o6689f Query : use flama_phc
20250226@113608.8390 bu7f7nladi85s7i1f5d5o6689f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@121335.4921 g7j1lapkkev72p20r94ugsf4sl Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250226@121335.4943 g7j1lapkkev72p20r94ugsf4sl Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250226@121335.5290 g7j1lapkkev72p20r94ugsf4sl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5540';
20250226@121335.5371 g7j1lapkkev72p20r94ugsf4sl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5540';
20250226@121335.5451 g7j1lapkkev72p20r94ugsf4sl Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5540';
20250226@121335.5491 g7j1lapkkev72p20r94ugsf4sl Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5540';
20250226@121335.6365 btmv15pucmtedca9ro44c93g2g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250226@121335.6394 btmv15pucmtedca9ro44c93g2g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250226@121335.6468 btmv15pucmtedca9ro44c93g2g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5541';
20250226@121335.6540 btmv15pucmtedca9ro44c93g2g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5541';
20250226@121335.6614 btmv15pucmtedca9ro44c93g2g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5541';
20250226@121335.6674 btmv15pucmtedca9ro44c93g2g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5541';
20250226@121335.6728 btmv15pucmtedca9ro44c93g2g Query : use flama_phc
20250226@121335.6731 btmv15pucmtedca9ro44c93g2g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250226@121335.6874 btmv15pucmtedca9ro44c93g2g Query : select no, estab,szadrsdesc from szadrs where u_coddest=00000001
20250226@121335.6966 btmv15pucmtedca9ro44c93g2g Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2237.00.1'
20250226@121335.7098 btmv15pucmtedca9ro44c93g2g Query : use flama_phc
20250226@121335.7101 btmv15pucmtedca9ro44c93g2g Query : select top 1 1 valor from ts where ts.ndos = 5
20250226@121335.7261 btmv15pucmtedca9ro44c93g2g Query : use flama_phc
20250226@121335.7264 btmv15pucmtedca9ro44c93g2g Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20250226@121335.7351 btmv15pucmtedca9ro44c93g2g Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20250226@121335.7521 btmv15pucmtedca9ro44c93g2g Query : use flama_phc
20250226@121335.7524 btmv15pucmtedca9ro44c93g2g Query : select top 1 ~inactivo valor from fl where no = '102245' and estab = 0 order by inactivo desc
20250226@121335.7627 btmv15pucmtedca9ro44c93g2g Query : use flama_phc
20250226@121335.7630 btmv15pucmtedca9ro44c93g2g Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20250226@121335.7721 btmv15pucmtedca9ro44c93g2g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5541';
20250226@121335.7773 btmv15pucmtedca9ro44c93g2g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5541';
20250226@121909.6049 2mdnu4as4kafto0s4kvpdtn5ib Query : use flama_phc
20250226@121909.6057 2mdnu4as4kafto0s4kvpdtn5ib Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@121909.6308 2mdnu4as4kafto0s4kvpdtn5ib Query : use flama_phc
20250226@121909.6474 2mdnu4as4kafto0s4kvpdtn5ib Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@123609.6437 r13q50s0utteg8d3fb3711avil Query : use flama_phc
20250226@123609.6442 r13q50s0utteg8d3fb3711avil Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@123609.6534 r13q50s0utteg8d3fb3711avil Query : use flama_phc
20250226@123609.6538 r13q50s0utteg8d3fb3711avil Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@131909.7904 i0hff5nbbclipfv2sbc29r6cub Query : use flama_phc
20250226@131909.7908 i0hff5nbbclipfv2sbc29r6cub Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250226@131909.8001 i0hff5nbbclipfv2sbc29r6cub Query : use flama_phc
20250226@131909.8006 i0hff5nbbclipfv2sbc29r6cub Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@132245.8170 n4ua849ulmh60vq17ubcm3om1v Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250226@132245.8254 n4ua849ulmh60vq17ubcm3om1v Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250226@132245.8437 n4ua849ulmh60vq17ubcm3om1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5542';
20250226@132245.8522 n4ua849ulmh60vq17ubcm3om1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5542';
20250226@132245.8597 n4ua849ulmh60vq17ubcm3om1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5542';
20250226@132245.8641 n4ua849ulmh60vq17ubcm3om1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5542';
20250226@132245.8714 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132245.8718 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250226@132245.8790 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132245.8794 n4ua849ulmh60vq17ubcm3om1v Query : select no, estab,szadrsdesc from szadrs where u_coddest=3168
20250226@132245.8933 n4ua849ulmh60vq17ubcm3om1v Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 119 and bo.boano = 2025 and bo.obrano = 0000359 
20250226@132245.9481 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20250226@132245.9674 n4ua849ulmh60vq17ubcm3om1v Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc25022644866,5070000-2 ' 
20250226@132246.6800 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2032.00.1'
20250226@132246.2400 n4ua849ulmh60vq17ubcm3om1v Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc25022644866,5770000-3 ' 
20250226@132246.6240 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 tpdesc, tpstamp from bo where bostamp ='evc25022634755.908000002 '
20250226@132246.9230 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.9270 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250226@132246.1113 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.1117 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 1 valor from td where td.ndoc = 39
20250226@132246.1253 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.1257 n4ua849ulmh60vq17ubcm3om1v Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20250226@132246.1335 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields ,temserie useserialnumber from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20250226@132246.1519 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.1523 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 ~inactivo valor from cl where no = '101045' and estab = 0 order by inactivo desc
20250226@132246.1664 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.1667 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250226@132246.1783 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.1787 n4ua849ulmh60vq17ubcm3om1v Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250226@132246.1872 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.1876 n4ua849ulmh60vq17ubcm3om1v Query : select szadrsstamp valor from szadrs where szadrsdesc='electro chico - electrodomÉsticos, lda.'
20250226@132246.1925 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.1928 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from td where ndoc = 39
20250226@132246.2022 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250226@132246.2094 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.2426 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250226@132246.2521 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.2537 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250226@132246.2574 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.2590 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250226@132246.2683 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250226@132246.2920 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250226@132246.3075 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.3080 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 clstamp valor from cl where no = '101045' and estab = 0 order by inactivo desc
20250226@132246.3205 n4ua849ulmh60vq17ubcm3om1v Query : select diames,mesesnaopag,formapag,descricao,dias,vencimento from tp where tpstamp = 'ris18061563245,327599831 '
20250226@132246.3256 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.3277 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250226@132246.3325 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67bf11967767bf15a641' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250226@132246.3730 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.3758 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250226@132246.3807 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc25022634755.908000002 '
20250226@132246.3927 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc25022634755.908000002 '
20250226@132246.4046 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc25022634755.908000002 '
20250226@132246.4153 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc25022634755.908000002 '
20250226@132246.4252 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc25022634755.908000002 '
20250226@132246.4345 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 bo.serie valor from bo where bo.bostamp='evc25022634755.908000002 '
20250226@132246.4442 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,formapag,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ,dataentrega ) values ('aut67bf11967767bf15a641',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?,?,?)
20250226@132246.6476 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 fno valor from wsftdata order by fno desc
20250226@132246.6577 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.6596 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250226@132246.6632 n4ua849ulmh60vq17ubcm3om1v Query : select 'normal' from dummy
20250226@132246.6686 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,pdata,tpdesc,tpstamp,cdata,chora,carga,descar,site ,classe ,encomenda ,u_hdesc ,u_ddesc ) values ('aut67bf11967767bf15a641',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3101,101045,0,'2025-02-26',39,'euro',0,0,2025 ,'2025-04-27',?,'ris18061563245,327599831 ','20250226','1352',?,?,?,?,?,?,?)
20250226@132246.7206 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.7209 n4ua849ulmh60vq17ubcm3om1v Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20250226@132246.7353 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.7356 n4ua849ulmh60vq17ubcm3om1v Query : select st.stns valor from st where st.ref = '324.4990.00.1'
20250226@132246.7473 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.7477 n4ua849ulmh60vq17ubcm3om1v Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.4990.00.1' and sa.armazem = 133 
20250226@132246.7550 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.7554 n4ua849ulmh60vq17ubcm3om1v Query : select st.stns valor from st where st.ref = '324.4990.00.1'
20250226@132246.7572 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.7576 n4ua849ulmh60vq17ubcm3om1v Query : select st.stns valor from st where st.ref = '324.4990.00.1'
20250226@132246.7599 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4990.00.1'
20250226@132246.7768 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.7790 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132246.7830 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.7847 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132246.7859 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250226@132246.7905 n4ua849ulmh60vq17ubcm3om1v Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20250226@132246.7969 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.7985 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132246.7998 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67bf12551767bf15a6c2','aut67bf11967767bf15a641' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250226@132246.8097 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.8119 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132246.8155 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut67bf12551767bf15a6c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.0000 ,'aut67bf11967767bf15a641' ,28.800000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20250226@132246.8862 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.8865 n4ua849ulmh60vq17ubcm3om1v Query : select st.usalote valor from st where st.ref = '324.2032.00.1'
20250226@132246.8944 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.8948 n4ua849ulmh60vq17ubcm3om1v Query : select st.stns valor from st where st.ref = '324.2032.00.1'
20250226@132246.8968 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.8972 n4ua849ulmh60vq17ubcm3om1v Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.2032.00.1' and sa.armazem = 133 
20250226@132246.9121 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.9125 n4ua849ulmh60vq17ubcm3om1v Query : select st.stns valor from st where st.ref = '324.2032.00.1'
20250226@132246.9141 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.9144 n4ua849ulmh60vq17ubcm3om1v Query : select st.stns valor from st where st.ref = '324.2032.00.1'
20250226@132246.9165 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2032.00.1'
20250226@132246.9350 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.9369 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132246.9398 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.9415 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132246.9431 n4ua849ulmh60vq17ubcm3om1v Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250226@132246.9443 n4ua849ulmh60vq17ubcm3om1v Query : select sestamp valor from se where ref ='324.2032.00.1' and lote = 'r2401110100a'
20250226@132246.9457 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.9481 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132246.9505 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67bf12765267bf15a6e6','aut67bf11967767bf15a641' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250226@132246.9510 n4ua849ulmh60vq17ubcm3om1v Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132246.9543 n4ua849ulmh60vq17ubcm3om1v Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132246.9584 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut67bf12765267bf15a6e6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.0000 ,'aut67bf11967767bf15a641' ,18.900000,0 ,2,23.00,20000,?,?,?,?,?,?,?,?,?)
20250226@132246.9847 n4ua849ulmh60vq17ubcm3om1v Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67bf11967767bf15a641','','wait',39,'adm09112754980.682000002')
20250226@132246.9966 n4ua849ulmh60vq17ubcm3om1v Query : use flama_phc
20250226@132246.9971 n4ua849ulmh60vq17ubcm3om1v Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@132247.4000 n4ua849ulmh60vq17ubcm3om1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5542';
20250226@132247.6200 n4ua849ulmh60vq17ubcm3om1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5542';
20250226@132247.1260 n4ua849ulmh60vq17ubcm3om1v Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5542';
20250226@132247.1650 n4ua849ulmh60vq17ubcm3om1v Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5542';
20250226@132247.7550 u5nel4t5tvjirprthfi3grpqrr Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250226@132247.7670 u5nel4t5tvjirprthfi3grpqrr Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250226@132247.8690 u5nel4t5tvjirprthfi3grpqrr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5543';
20250226@132247.9570 u5nel4t5tvjirprthfi3grpqrr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5543';
20250226@132247.1208 u5nel4t5tvjirprthfi3grpqrr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5543';
20250226@132247.1282 u5nel4t5tvjirprthfi3grpqrr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5543';
20250226@132247.1379 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.1382 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250226@132247.1468 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.1472 u5nel4t5tvjirprthfi3grpqrr Query : select no, estab,szadrsdesc from szadrs where u_coddest=2064
20250226@132247.1577 u5nel4t5tvjirprthfi3grpqrr Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 119 and bo.boano = 2025 and bo.obrano = 0000360 
20250226@132247.2082 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4743.00.1'
20250226@132247.2268 u5nel4t5tvjirprthfi3grpqrr Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc25022644896,7980000-2 ' 
20250226@132247.2643 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20250226@132247.2832 u5nel4t5tvjirprthfi3grpqrr Query : select bie.edebito ,bie.desconto ,bie.desc2 ,bie.desc3 ,bie.desc4 ,bie.obranome ,bie.bostamp from bi bio inner join bi bie on bio.oobistamp=bie.bistamp where bio.bistamp = 'evc25022644896,8270000-3 ' 
20250226@132247.3208 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 tpdesc, tpstamp from bo where bostamp ='evc25022634113.237000002 '
20250226@132247.3331 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3334 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250226@132247.3372 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3375 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 1 valor from td where td.ndoc = 39
20250226@132247.3405 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3420 u5nel4t5tvjirprthfi3grpqrr Query : select lower(descricao) descricao ,case when valor='s' then 1 else 0 end valor from para1 where descricao in ('st_lote','st_usalogifunc', 'st_grelha')
20250226@132247.3455 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields ,temserie useserialnumber from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20250226@132247.3493 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3495 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 ~inactivo valor from cl where no = '101645' and estab = 0 order by inactivo desc
20250226@132247.3650 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3653 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250226@132247.3689 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3693 u5nel4t5tvjirprthfi3grpqrr Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250226@132247.3792 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3796 u5nel4t5tvjirprthfi3grpqrr Query : select szadrsstamp valor from szadrs where szadrsdesc='macorlux - electrodomÉsticos, s.a.'
20250226@132247.3867 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.3870 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from td where ndoc = 39
20250226@132247.3894 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250226@132247.3908 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.3926 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250226@132247.3953 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.3969 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250226@132247.4000 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.4016 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250226@132247.4034 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250226@132247.4138 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250226@132247.4153 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.4156 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 clstamp valor from cl where no = '101645' and estab = 0 order by inactivo desc
20250226@132247.4278 u5nel4t5tvjirprthfi3grpqrr Query : select diames,mesesnaopag,formapag,descricao,dias,vencimento from tp where tpstamp = 'ris18062265070,900914145 '
20250226@132247.4303 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.5525 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250226@132247.5545 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67bf13371267bf15a762' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250226@132247.5738 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.5756 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250226@132247.5797 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp='evc25022634113.237000002 '
20250226@132247.5972 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp='evc25022634113.237000002 '
20250226@132247.6311 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 bo.u_codposen valor from bo where bo.bostamp='evc25022634113.237000002 '
20250226@132247.6495 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 bo.u_localenv valor from bo where bo.bostamp='evc25022634113.237000002 '
20250226@132247.6721 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 bo.trab5 valor from bo where bo.bostamp='evc25022634113.237000002 '
20250226@132247.7027 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 bo.serie valor from bo where bo.bostamp='evc25022634113.237000002 '
20250226@132247.7305 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,formapag,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ,dataentrega ) values ('aut67bf13371267bf15a762',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?,?,?)
20250226@132247.7660 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 fno valor from wsftdata order by fno desc
20250226@132247.7696 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.7714 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250226@132247.7748 u5nel4t5tvjirprthfi3grpqrr Query : select 'normal' from dummy
20250226@132247.7765 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,pdata,tpdesc,tpstamp,cdata,chora,carga,descar,site ,classe ,encomenda ,u_hdesc ,u_ddesc ) values ('aut67bf13371267bf15a762',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3102,101645,0,'2025-02-26',39,'euro',0,0,2025 ,'2025-04-27',?,'ris18062265070,900914145 ','20250226','1352',?,?,?,?,?,?,?)
20250226@132247.8105 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.8109 u5nel4t5tvjirprthfi3grpqrr Query : select st.usalote valor from st where st.ref = '324.4743.00.1'
20250226@132247.8180 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.8187 u5nel4t5tvjirprthfi3grpqrr Query : select st.stns valor from st where st.ref = '324.4743.00.1'
20250226@132247.8206 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.8209 u5nel4t5tvjirprthfi3grpqrr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.4743.00.1' and sa.armazem = 133 
20250226@132247.8388 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.8391 u5nel4t5tvjirprthfi3grpqrr Query : select st.stns valor from st where st.ref = '324.4743.00.1'
20250226@132247.8405 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.8409 u5nel4t5tvjirprthfi3grpqrr Query : select st.stns valor from st where st.ref = '324.4743.00.1'
20250226@132247.8430 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4743.00.1'
20250226@132247.8610 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.8640 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132247.8700 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.8716 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132247.8727 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250226@132247.8742 u5nel4t5tvjirprthfi3grpqrr Query : select sestamp valor from se where ref ='324.4743.00.1' and lote = 'r2200085100a'
20250226@132247.8782 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.8800 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132247.8817 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67bf14768667bf15a7d6','aut67bf13371267bf15a762' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250226@132247.8834 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.8851 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132247.8902 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut67bf14768667bf15a7d6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.0000 ,'aut67bf13371267bf15a762' ,38.500000,0 ,2,23.00,10000,?,?,?,?,?,?,?,?,?)
20250226@132247.9184 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.9188 u5nel4t5tvjirprthfi3grpqrr Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20250226@132247.9208 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.9211 u5nel4t5tvjirprthfi3grpqrr Query : select st.stns valor from st where st.ref = '324.2066.00.1'
20250226@132247.9233 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.9236 u5nel4t5tvjirprthfi3grpqrr Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.2066.00.1' and sa.armazem = 133 
20250226@132247.9339 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.9342 u5nel4t5tvjirprthfi3grpqrr Query : select st.stns valor from st where st.ref = '324.2066.00.1'
20250226@132247.9357 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132247.9393 u5nel4t5tvjirprthfi3grpqrr Query : select st.stns valor from st where st.ref = '324.2066.00.1'
20250226@132247.9427 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2066.00.1'
20250226@132247.9611 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.9642 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132247.9677 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.9693 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132247.9703 u5nel4t5tvjirprthfi3grpqrr Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250226@132247.9727 u5nel4t5tvjirprthfi3grpqrr Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20250226@132247.9752 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.9788 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250226@132247.9801 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67bf15190167bf15a7ee','aut67bf13371267bf15a762' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250226@132247.9806 u5nel4t5tvjirprthfi3grpqrr Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250226@132247.9824 u5nel4t5tvjirprthfi3grpqrr Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250226@132247.9921 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ,desconto ,desc2 ,desc3 ,desc4 ) values ('aut67bf15190167bf15a7ee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',18.0000 ,'aut67bf13371267bf15a762' ,35.000000,0 ,2,23.00,20000,?,?,?,?,?,?,?,?,?)
20250226@132248.1750 u5nel4t5tvjirprthfi3grpqrr Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67bf13371267bf15a762','','wait',39,'adm09112754980.682000002')
20250226@132248.2640 u5nel4t5tvjirprthfi3grpqrr Query : use flama_phc
20250226@132248.2670 u5nel4t5tvjirprthfi3grpqrr Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250226@132248.2980 u5nel4t5tvjirprthfi3grpqrr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5543';
20250226@132248.3640 u5nel4t5tvjirprthfi3grpqrr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5543';
20250226@132248.4590 u5nel4t5tvjirprthfi3grpqrr Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5543';
20250226@132248.5030 u5nel4t5tvjirprthfi3grpqrr Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5543';
20250226@132248.1233 ve7kpvi7pev47sf986787fl9hn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250226@132248.1256 ve7kpvi7pev47sf986787fl9hn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250226@132248.1362 ve7kpvi7pev47sf986787fl9hn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5544';
20250226@132248.1443 ve7kpvi7pev47sf986787fl9hn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5544';
20250226@132248.1533 ve7kpvi7pev47sf986787fl9hn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5544';
