20250127@161617.1180 gfu8bj36secikc6h6sao6gsv60 Query : insert into bo (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6797b181066797b150a7','guia r. fornecedor','2025-01-27',61,2500310,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250127@161625.5868 gfu8bj36secikc6h6sao6gsv60 Query : use flama_phc
20250127@161625.5910 gfu8bj36secikc6h6sao6gsv60 Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20250127@161625.6332 gfu8bj36secikc6h6sao6gsv60 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.4521.00.1'
20250127@161625.7028 gfu8bj36secikc6h6sao6gsv60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250127@161625.7745 gfu8bj36secikc6h6sao6gsv60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 61
20250127@161625.8643 gfu8bj36secikc6h6sao6gsv60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250127@161625.9439 gfu8bj36secikc6h6sao6gsv60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 61
20250127@161625.9909 gfu8bj36secikc6h6sao6gsv60 Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400955200a'
20250127@161626.3740 gfu8bj36secikc6h6sao6gsv60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250127@161626.9140 gfu8bj36secikc6h6sao6gsv60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'se' and documentnumber = 0
20250127@161626.1327 gfu8bj36secikc6h6sao6gsv60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250127@161626.3247 gfu8bj36secikc6h6sao6gsv60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'se' and documentnumber = 0
20250127@161626.3757 gfu8bj36secikc6h6sao6gsv60 Query : insert into se (sestamp,ref, lote, data,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6797b468396797b15a20',?,?,'20250127',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut;','aut;')
20250127@161626.5946 gfu8bj36secikc6h6sao6gsv60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250127@161626.6474 gfu8bj36secikc6h6sao6gsv60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250127@161626.7068 gfu8bj36secikc6h6sao6gsv60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 61
20250127@161626.7641 gfu8bj36secikc6h6sao6gsv60 Query : insert into bi2 (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6797b534826797b15a9e','aut6797b181066797b150a7',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from bo bo where bo.bostamp = 'aut6797b181066797b150a7'
20250127@161626.8135 gfu8bj36secikc6h6sao6gsv60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250127@161626.8833 gfu8bj36secikc6h6sao6gsv60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 61
20250127@161626.9594 gfu8bj36secikc6h6sao6gsv60 Query : insert into bi (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,obistamp ,stipo) select 'aut6797b534826797b15a9e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2700, 2700*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,14.35,14.35*200.48,14.35,14.35*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,14.35*2700,14.35*2700*200.48 ,15.785000,15.785000*200.48 ,15.785000,15.785000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,14.35,14.35*200.48,14.35*2700,14.35*2700*200.48,'cps24080142608,114000002 ',15.4,15.4*2700,15.4,15.4*2700,?,?,?,4 from bo bo where bo.bostamp = 'aut6797b181066797b150a7'
20250127@161656.1836 gfu8bj36secikc6h6sao6gsv60 Query : use flama_phc
20250127@161656.1874 gfu8bj36secikc6h6sao6gsv60 Query : declare @bostamp varchar(25) = 'aut6797b181066797b150a7' ,@bistamp varchar(25) = '' update bi set tecoval = qtt * ecoval ,etecoval = qtt * eecoval ,tecoval2 = qtt * ecoval2 ,etecoval2 = qtt * eecoval2 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end -- se tiver classificação e não for normal, não calcula nada update bi set ttdeb = 0 ,ettdeb = 0 ,ttmoeda = 0 where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and bi.classifc <> '' and bi.classifc <> 'normal' -- no caso normal com moeda euro if exists ( select 1 from bo cross apply ( select valor moeda from para1 where descricao = 'ge_pteoueuro' ) par where bo.bostamp = @bostamp and bo.moeda = par.moeda ) begin -- sem ecovalores update bi set ettdeb = round(bi.qtt * ((bi.edebito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttdeb = round(bi.qtt * ((bi.debito * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100))), 6) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 1 -- com ecovalores update bi set ettdeb = round(bi.qtt * ( ( bi.edebito + ( iif(p.st_econotdesc = 1, - bi.eecoval2, bi.eecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.eecoval + bi.eecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttdeb = round(bi.qtt * ( ( bi.debito + ( iif(p.st_econotdesc = 1, - bi.ecoval2, bi.ecoval) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ) ) ) * (1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) ), 6) + ( bi.qtt * iif(p.st_econotdesc = 1, (bi.ecoval + bi.ecoval2) * ( 1 + iif(bi.ivaincl = 1 and tiva.taxa <> 0, tiva.taxa / 100, 0) ), 0) ) ,ttmoeda = 0 from bi inner join bo on bi.bostamp = bo.bostamp left join st on bi.ref = st.ref left join taxasiva tiva on bi.tabiva = tiva.codigo cross apply ( select max(valor) st_econotdesc from ( select case when valor = 's' then 1 else 0 end valor from para1 where descricao = 'st_econotdesc' union all select 0 ) a ) p where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.econotcalc = 0 --acrescenta os descontos em valor, caso existam: update bi set ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 2) ,ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ttmoeda = 0 from bi where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end else begin update bi set ttmoeda = round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2) ,ettdeb = case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ,edebito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end ,debito = case when bi.qtt = 0 then 0 else round(abs(( case when bo2.cambio <> 0 then round((round((1 - bi.desconto / 100) * (1 - bi.desc2 / 100) * (1 - bi.desc3 / 100) * (1 - bi.desc4 / 100) * (1 - bi.desc5 / 100) * (1 - bi.desc6 / 100) * bi.qtt * bi.vumoeda, 2)) / bo2.cambio, 2) else 0 end ) / (1 - bi.desconto / 100) / (1 - bi.desc2 / 100) / (1 - bi.desc3 / 100) / (1 - bi.desc4 / 100) / (1 - bi.desc5 / 100) / (1 - bi.desc6 / 100) / bi.qtt), 2) end * 200.482 from bi inner join bo2 on bi.bostamp = bo2.bo2stamp where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) update bi set ttdeb = round(bi.ttdeb - (bi.qtt * bi.valdesc), 2) ,ettdeb = round(bi.ettdeb - (bi.qtt * bi.evaldesc), 0) ,debito = round(bi.debito - (bi.qtt * bi.valdesc), 2) ,edebito = round(bi.edebito - (bi.qtt * bi.evaldesc), 2) where bi.bostamp = @bostamp and bi.bistamp = case when @bistamp <> '' then @bistamp else bi.bistamp end and ( bi.classifc = '' or bi.classifc = 'normal' ) and bi.valdesc <> 0 end 
20250127@161716.2195 gfu8bj36secikc6h6sao6gsv60 Query : use flama_phc
20250127@161716.2200 gfu8bj36secikc6h6sao6gsv60 Query : select 1 valor from bo where bo.bostamp = 'aut6797b181066797b150a7'
20250127@161716.2218 gfu8bj36secikc6h6sao6gsv60 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) = 'aut6797b181066797b150a7' 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 
20250127@161718.5351 gfu8bj36secikc6h6sao6gsv60 Query : use flama_phc
20250127@161718.5357 gfu8bj36secikc6h6sao6gsv60 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@161718.5413 gfu8bj36secikc6h6sao6gsv60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4954';
20250127@161718.5464 gfu8bj36secikc6h6sao6gsv60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4954';
20250127@161910.1615 eqnhs8aan8df6sdi54aiar70sd Query : use flama_phc
20250127@161910.1657 eqnhs8aan8df6sdi54aiar70sd Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@161910.2433 eqnhs8aan8df6sdi54aiar70sd Query : use flama_phc
20250127@161910.2477 eqnhs8aan8df6sdi54aiar70sd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@163609.9069 p0o9lbsngcprd5i3t4nk3j1uoq Query : use flama_phc
20250127@163609.9076 p0o9lbsngcprd5i3t4nk3j1uoq Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@163609.9428 p0o9lbsngcprd5i3t4nk3j1uoq Query : use flama_phc
20250127@163609.9432 p0o9lbsngcprd5i3t4nk3j1uoq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@171910.9648 fihmvt604h12p1vhl23a2jgvrv Query : use flama_phc
20250127@171910.9653 fihmvt604h12p1vhl23a2jgvrv Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@171910.9929 fihmvt604h12p1vhl23a2jgvrv Query : use flama_phc
20250127@171910.9934 fihmvt604h12p1vhl23a2jgvrv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@173611.1280 d1qli3h0tkbocfbla6em7lqppb Query : use flama_phc
20250127@173611.1320 d1qli3h0tkbocfbla6em7lqppb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@173611.2160 d1qli3h0tkbocfbla6em7lqppb Query : use flama_phc
20250127@173611.2190 d1qli3h0tkbocfbla6em7lqppb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@181909.5010 fvgk4c3atgpcbtjqk8dkqigf40 Query : use flama_phc
20250127@181909.5015 fvgk4c3atgpcbtjqk8dkqigf40 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@181909.5505 fvgk4c3atgpcbtjqk8dkqigf40 Query : use flama_phc
20250127@181909.5509 fvgk4c3atgpcbtjqk8dkqigf40 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@183609.5074 7v8r49qgv4bpsgsc08cfrgf8gs Query : use flama_phc
20250127@183609.5079 7v8r49qgv4bpsgsc08cfrgf8gs Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@183609.5180 7v8r49qgv4bpsgsc08cfrgf8gs Query : use flama_phc
20250127@183609.5184 7v8r49qgv4bpsgsc08cfrgf8gs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@191910.7461 bhfuv0afhqbj8cosjidnggh9ke Query : use flama_phc
20250127@191910.7466 bhfuv0afhqbj8cosjidnggh9ke Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@191910.7559 bhfuv0afhqbj8cosjidnggh9ke Query : use flama_phc
20250127@191910.7563 bhfuv0afhqbj8cosjidnggh9ke Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@193610.7012 hda8dlb3h15crup2gvgee8d1fo Query : use flama_phc
20250127@193610.7017 hda8dlb3h15crup2gvgee8d1fo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@193610.7117 hda8dlb3h15crup2gvgee8d1fo Query : use flama_phc
20250127@193610.7121 hda8dlb3h15crup2gvgee8d1fo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@201913.4688 fd0ikgtiqtsb0t9or76qe6mfj0 Query : use flama_phc
20250127@201913.4693 fd0ikgtiqtsb0t9or76qe6mfj0 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@201913.5845 fd0ikgtiqtsb0t9or76qe6mfj0 Query : use flama_phc
20250127@201913.5849 fd0ikgtiqtsb0t9or76qe6mfj0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@203613.8893 l0c97ok5mio4tqg272a197bsg3 Query : use flama_phc
20250127@203613.8898 l0c97ok5mio4tqg272a197bsg3 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@203613.9129 l0c97ok5mio4tqg272a197bsg3 Query : use flama_phc
20250127@203613.9135 l0c97ok5mio4tqg272a197bsg3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@211909.4847 p8r0sbv9rphdaq7af8d2gggihe Query : use flama_phc
20250127@211909.4851 p8r0sbv9rphdaq7af8d2gggihe Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@211909.4944 p8r0sbv9rphdaq7af8d2gggihe Query : use flama_phc
20250127@211909.4947 p8r0sbv9rphdaq7af8d2gggihe Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@213609.6768 pinl6tpu3k2p4ovd5uiaa21nmg Query : use flama_phc
20250127@213609.6774 pinl6tpu3k2p4ovd5uiaa21nmg Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@213609.6867 pinl6tpu3k2p4ovd5uiaa21nmg Query : use flama_phc
20250127@213609.6871 pinl6tpu3k2p4ovd5uiaa21nmg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@221910.5920 520684tv4s6ftvegmeuacc1k74 Query : use flama_phc
20250127@221910.5924 520684tv4s6ftvegmeuacc1k74 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@221910.6027 520684tv4s6ftvegmeuacc1k74 Query : use flama_phc
20250127@221910.6031 520684tv4s6ftvegmeuacc1k74 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@223610.7743 h5g0h9hhqsu05ma2tur8t07c57 Query : use flama_phc
20250127@223610.7749 h5g0h9hhqsu05ma2tur8t07c57 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@223610.7958 h5g0h9hhqsu05ma2tur8t07c57 Query : use flama_phc
20250127@223610.8002 h5g0h9hhqsu05ma2tur8t07c57 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@231910.4213 luu6g2chkauln7hieoi1hgjn5u Query : use flama_phc
20250127@231910.4217 luu6g2chkauln7hieoi1hgjn5u Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@231910.4341 luu6g2chkauln7hieoi1hgjn5u Query : use flama_phc
20250127@231910.4345 luu6g2chkauln7hieoi1hgjn5u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250127@232537.9982 1g9cr12qe9ctm6dvv6h0vq145u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232538.2700 1g9cr12qe9ctm6dvv6h0vq145u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232538.3910 1g9cr12qe9ctm6dvv6h0vq145u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4957';
20250127@232538.4830 1g9cr12qe9ctm6dvv6h0vq145u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4957';
20250127@232538.5680 1g9cr12qe9ctm6dvv6h0vq145u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4957';
20250127@232538.6110 1g9cr12qe9ctm6dvv6h0vq145u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4957';
20250127@232538.7000 1g9cr12qe9ctm6dvv6h0vq145u Query : use flama_phc
20250127@232538.7030 1g9cr12qe9ctm6dvv6h0vq145u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232538.2379 1g9cr12qe9ctm6dvv6h0vq145u Query : use flama_phc
20250127@232538.2384 1g9cr12qe9ctm6dvv6h0vq145u Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20250127@232538.2730 1g9cr12qe9ctm6dvv6h0vq145u 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2006 and bo.obrano = 2500698 
20250127@232538.3163 1g9cr12qe9ctm6dvv6h0vq145u Query : use flama_phc
20250127@232538.3166 1g9cr12qe9ctm6dvv6h0vq145u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232538.3244 1g9cr12qe9ctm6dvv6h0vq145u Query : use flama_phc
20250127@232538.3247 1g9cr12qe9ctm6dvv6h0vq145u Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232538.3342 1g9cr12qe9ctm6dvv6h0vq145u Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232538.3395 1g9cr12qe9ctm6dvv6h0vq145u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4957';
20250127@232538.3443 1g9cr12qe9ctm6dvv6h0vq145u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4957';
20250127@232538.4062 2obh1vpb53h2peh5o5t9v8h6lb Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232538.4074 2obh1vpb53h2peh5o5t9v8h6lb Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232538.4153 2obh1vpb53h2peh5o5t9v8h6lb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4958';
20250127@232538.4229 2obh1vpb53h2peh5o5t9v8h6lb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4958';
20250127@232538.4306 2obh1vpb53h2peh5o5t9v8h6lb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4958';
20250127@232538.4343 2obh1vpb53h2peh5o5t9v8h6lb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4958';
20250127@232538.4438 2obh1vpb53h2peh5o5t9v8h6lb Query : use flama_phc
20250127@232538.4441 2obh1vpb53h2peh5o5t9v8h6lb Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232538.4510 2obh1vpb53h2peh5o5t9v8h6lb Query : use flama_phc
20250127@232538.4513 2obh1vpb53h2peh5o5t9v8h6lb Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20250127@232538.4627 2obh1vpb53h2peh5o5t9v8h6lb 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500702 
20250127@232538.4947 2obh1vpb53h2peh5o5t9v8h6lb Query : use flama_phc
20250127@232538.4952 2obh1vpb53h2peh5o5t9v8h6lb Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232538.5177 2obh1vpb53h2peh5o5t9v8h6lb Query : use flama_phc
20250127@232538.5193 2obh1vpb53h2peh5o5t9v8h6lb Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232538.5215 2obh1vpb53h2peh5o5t9v8h6lb Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232538.5251 2obh1vpb53h2peh5o5t9v8h6lb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4958';
20250127@232538.5301 2obh1vpb53h2peh5o5t9v8h6lb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4958';
20250127@232538.5905 fjf60r3j18dlb46sn8cckd71dj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232538.5916 fjf60r3j18dlb46sn8cckd71dj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232538.5993 fjf60r3j18dlb46sn8cckd71dj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4959';
20250127@232538.6067 fjf60r3j18dlb46sn8cckd71dj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4959';
20250127@232538.6139 fjf60r3j18dlb46sn8cckd71dj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4959';
20250127@232538.6190 fjf60r3j18dlb46sn8cckd71dj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4959';
20250127@232538.6254 fjf60r3j18dlb46sn8cckd71dj Query : use flama_phc
20250127@232538.6258 fjf60r3j18dlb46sn8cckd71dj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232538.6331 fjf60r3j18dlb46sn8cckd71dj Query : use flama_phc
20250127@232538.6334 fjf60r3j18dlb46sn8cckd71dj Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20250127@232538.6396 fjf60r3j18dlb46sn8cckd71dj 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500703 
20250127@232538.6705 fjf60r3j18dlb46sn8cckd71dj Query : use flama_phc
20250127@232538.6710 fjf60r3j18dlb46sn8cckd71dj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232538.6757 fjf60r3j18dlb46sn8cckd71dj Query : use flama_phc
20250127@232538.6760 fjf60r3j18dlb46sn8cckd71dj Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232538.6779 fjf60r3j18dlb46sn8cckd71dj Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232538.6802 fjf60r3j18dlb46sn8cckd71dj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4959';
20250127@232538.6852 fjf60r3j18dlb46sn8cckd71dj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4959';
20250127@232538.7519 gh39njfkiin8u9r0f0nihtgr2t Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232538.7531 gh39njfkiin8u9r0f0nihtgr2t Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232538.7605 gh39njfkiin8u9r0f0nihtgr2t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4960';
20250127@232538.7711 gh39njfkiin8u9r0f0nihtgr2t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4960';
20250127@232538.7806 gh39njfkiin8u9r0f0nihtgr2t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4960';
20250127@232538.7846 gh39njfkiin8u9r0f0nihtgr2t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4960';
20250127@232538.7909 gh39njfkiin8u9r0f0nihtgr2t Query : use flama_phc
20250127@232538.7913 gh39njfkiin8u9r0f0nihtgr2t Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232538.7980 gh39njfkiin8u9r0f0nihtgr2t Query : use flama_phc
20250127@232538.7983 gh39njfkiin8u9r0f0nihtgr2t Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20250127@232538.8101 gh39njfkiin8u9r0f0nihtgr2t 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500704 
20250127@232538.8413 gh39njfkiin8u9r0f0nihtgr2t Query : use flama_phc
20250127@232538.8417 gh39njfkiin8u9r0f0nihtgr2t Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232538.8463 gh39njfkiin8u9r0f0nihtgr2t Query : use flama_phc
20250127@232538.8468 gh39njfkiin8u9r0f0nihtgr2t Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232538.8489 gh39njfkiin8u9r0f0nihtgr2t Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232538.8521 gh39njfkiin8u9r0f0nihtgr2t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4960';
20250127@232538.8585 gh39njfkiin8u9r0f0nihtgr2t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4960';
20250127@232538.9259 l5c0e2t45i4e2qf56e4064m3rt Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232538.9272 l5c0e2t45i4e2qf56e4064m3rt Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232538.9350 l5c0e2t45i4e2qf56e4064m3rt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4961';
20250127@232538.9418 l5c0e2t45i4e2qf56e4064m3rt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4961';
20250127@232538.9488 l5c0e2t45i4e2qf56e4064m3rt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4961';
20250127@232538.9532 l5c0e2t45i4e2qf56e4064m3rt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4961';
20250127@232538.9609 l5c0e2t45i4e2qf56e4064m3rt Query : use flama_phc
20250127@232538.9614 l5c0e2t45i4e2qf56e4064m3rt Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232538.9683 l5c0e2t45i4e2qf56e4064m3rt Query : use flama_phc
20250127@232538.9686 l5c0e2t45i4e2qf56e4064m3rt Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20250127@232538.9737 l5c0e2t45i4e2qf56e4064m3rt 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500705 
20250127@232539.7800 l5c0e2t45i4e2qf56e4064m3rt Query : use flama_phc
20250127@232539.8200 l5c0e2t45i4e2qf56e4064m3rt Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232539.1180 l5c0e2t45i4e2qf56e4064m3rt Query : use flama_phc
20250127@232539.1210 l5c0e2t45i4e2qf56e4064m3rt Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232539.1390 l5c0e2t45i4e2qf56e4064m3rt Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232539.1700 l5c0e2t45i4e2qf56e4064m3rt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4961';
20250127@232539.3130 l5c0e2t45i4e2qf56e4064m3rt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4961';
20250127@232539.8820 64gl0fr4494qq07ladciekesre Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232539.8950 64gl0fr4494qq07ladciekesre Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232539.1003 64gl0fr4494qq07ladciekesre Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4962';
20250127@232539.2328 64gl0fr4494qq07ladciekesre Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4962';
20250127@232539.2606 64gl0fr4494qq07ladciekesre Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4962';
20250127@232539.2653 64gl0fr4494qq07ladciekesre Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4962';
20250127@232539.2720 64gl0fr4494qq07ladciekesre Query : use flama_phc
20250127@232539.2724 64gl0fr4494qq07ladciekesre Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232539.2806 64gl0fr4494qq07ladciekesre Query : use flama_phc
20250127@232539.2809 64gl0fr4494qq07ladciekesre Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20250127@232539.2859 64gl0fr4494qq07ladciekesre 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500706 
20250127@232539.3174 64gl0fr4494qq07ladciekesre Query : use flama_phc
20250127@232539.3177 64gl0fr4494qq07ladciekesre Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232539.3261 64gl0fr4494qq07ladciekesre Query : use flama_phc
20250127@232539.3265 64gl0fr4494qq07ladciekesre Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232539.3283 64gl0fr4494qq07ladciekesre Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232539.3320 64gl0fr4494qq07ladciekesre Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4962';
20250127@232539.3365 64gl0fr4494qq07ladciekesre Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4962';
20250127@232539.3904 43vne1v9du6p7kf9m99gbqoi8i Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232539.3917 43vne1v9du6p7kf9m99gbqoi8i Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232539.4013 43vne1v9du6p7kf9m99gbqoi8i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4963';
20250127@232539.4102 43vne1v9du6p7kf9m99gbqoi8i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4963';
20250127@232539.4175 43vne1v9du6p7kf9m99gbqoi8i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4963';
20250127@232539.4218 43vne1v9du6p7kf9m99gbqoi8i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4963';
20250127@232539.4285 43vne1v9du6p7kf9m99gbqoi8i Query : use flama_phc
20250127@232539.4292 43vne1v9du6p7kf9m99gbqoi8i Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232539.4366 43vne1v9du6p7kf9m99gbqoi8i Query : use flama_phc
20250127@232539.4369 43vne1v9du6p7kf9m99gbqoi8i Query : select no, estab,szadrsdesc from szadrs where u_coddest=2211
20250127@232539.4476 43vne1v9du6p7kf9m99gbqoi8i 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500708 
20250127@232539.4818 43vne1v9du6p7kf9m99gbqoi8i Query : use flama_phc
20250127@232539.4825 43vne1v9du6p7kf9m99gbqoi8i Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232539.4860 43vne1v9du6p7kf9m99gbqoi8i Query : use flama_phc
20250127@232539.4863 43vne1v9du6p7kf9m99gbqoi8i Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232539.4891 43vne1v9du6p7kf9m99gbqoi8i Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232539.4914 43vne1v9du6p7kf9m99gbqoi8i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4963';
20250127@232539.4963 43vne1v9du6p7kf9m99gbqoi8i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4963';
20250127@232539.5809 honupr4fc1f1ajo7d449j40roq Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232539.5820 honupr4fc1f1ajo7d449j40roq Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232539.5903 honupr4fc1f1ajo7d449j40roq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4964';
20250127@232539.5991 honupr4fc1f1ajo7d449j40roq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4964';
20250127@232539.6079 honupr4fc1f1ajo7d449j40roq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4964';
20250127@232539.6120 honupr4fc1f1ajo7d449j40roq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4964';
20250127@232539.6199 honupr4fc1f1ajo7d449j40roq Query : use flama_phc
20250127@232539.6204 honupr4fc1f1ajo7d449j40roq Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232539.6279 honupr4fc1f1ajo7d449j40roq Query : use flama_phc
20250127@232539.6283 honupr4fc1f1ajo7d449j40roq Query : select no, estab,szadrsdesc from szadrs where u_coddest=210
20250127@232539.6395 honupr4fc1f1ajo7d449j40roq 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500709 
20250127@232539.6775 honupr4fc1f1ajo7d449j40roq Query : use flama_phc
20250127@232539.6779 honupr4fc1f1ajo7d449j40roq Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232539.6815 honupr4fc1f1ajo7d449j40roq Query : use flama_phc
20250127@232539.6820 honupr4fc1f1ajo7d449j40roq Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232539.6838 honupr4fc1f1ajo7d449j40roq Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232539.6896 honupr4fc1f1ajo7d449j40roq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4964';
20250127@232539.6962 honupr4fc1f1ajo7d449j40roq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4964';
20250127@232539.7714 dldmrr7foifdtfabs5njuk93s5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232539.7729 dldmrr7foifdtfabs5njuk93s5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232539.7809 dldmrr7foifdtfabs5njuk93s5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4965';
20250127@232539.7881 dldmrr7foifdtfabs5njuk93s5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4965';
20250127@232539.7953 dldmrr7foifdtfabs5njuk93s5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4965';
20250127@232539.7994 dldmrr7foifdtfabs5njuk93s5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4965';
20250127@232539.8138 dldmrr7foifdtfabs5njuk93s5 Query : use flama_phc
20250127@232539.8143 dldmrr7foifdtfabs5njuk93s5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232539.8215 dldmrr7foifdtfabs5njuk93s5 Query : use flama_phc
20250127@232539.8218 dldmrr7foifdtfabs5njuk93s5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6258
20250127@232539.8355 dldmrr7foifdtfabs5njuk93s5 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500710 
20250127@232539.8714 dldmrr7foifdtfabs5njuk93s5 Query : use flama_phc
20250127@232539.8718 dldmrr7foifdtfabs5njuk93s5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232539.8752 dldmrr7foifdtfabs5njuk93s5 Query : use flama_phc
20250127@232539.8758 dldmrr7foifdtfabs5njuk93s5 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232539.8775 dldmrr7foifdtfabs5njuk93s5 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232539.8809 dldmrr7foifdtfabs5njuk93s5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4965';
20250127@232539.8856 dldmrr7foifdtfabs5njuk93s5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4965';
20250127@232539.9402 cvbc12ic9vpvaeq4as43785q3n Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232539.9414 cvbc12ic9vpvaeq4as43785q3n Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232539.9509 cvbc12ic9vpvaeq4as43785q3n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4966';
20250127@232539.9664 cvbc12ic9vpvaeq4as43785q3n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4966';
20250127@232539.9733 cvbc12ic9vpvaeq4as43785q3n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4966';
20250127@232539.9782 cvbc12ic9vpvaeq4as43785q3n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4966';
20250127@232539.9850 cvbc12ic9vpvaeq4as43785q3n Query : use flama_phc
20250127@232539.9854 cvbc12ic9vpvaeq4as43785q3n Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232539.9935 cvbc12ic9vpvaeq4as43785q3n Query : use flama_phc
20250127@232539.9938 cvbc12ic9vpvaeq4as43785q3n Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250127@232540.3600 cvbc12ic9vpvaeq4as43785q3n 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500711 
20250127@232540.4100 cvbc12ic9vpvaeq4as43785q3n Query : use flama_phc
20250127@232540.4140 cvbc12ic9vpvaeq4as43785q3n Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232540.4590 cvbc12ic9vpvaeq4as43785q3n Query : use flama_phc
20250127@232540.4620 cvbc12ic9vpvaeq4as43785q3n Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232540.4810 cvbc12ic9vpvaeq4as43785q3n Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232540.5150 cvbc12ic9vpvaeq4as43785q3n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4966';
20250127@232540.5730 cvbc12ic9vpvaeq4as43785q3n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4966';
20250127@232540.2670 ogmjhvh5pr05h6ptcvqivdn7pa Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232540.2688 ogmjhvh5pr05h6ptcvqivdn7pa Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232540.2836 ogmjhvh5pr05h6ptcvqivdn7pa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4967';
20250127@232540.2987 ogmjhvh5pr05h6ptcvqivdn7pa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4967';
20250127@232540.3093 ogmjhvh5pr05h6ptcvqivdn7pa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4967';
20250127@232540.3160 ogmjhvh5pr05h6ptcvqivdn7pa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4967';
20250127@232540.3245 ogmjhvh5pr05h6ptcvqivdn7pa Query : use flama_phc
20250127@232540.3249 ogmjhvh5pr05h6ptcvqivdn7pa Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232540.3621 ogmjhvh5pr05h6ptcvqivdn7pa Query : use flama_phc
20250127@232540.3683 ogmjhvh5pr05h6ptcvqivdn7pa Query : select no, estab,szadrsdesc from szadrs where u_coddest=2196
20250127@232540.3876 ogmjhvh5pr05h6ptcvqivdn7pa 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500712 
20250127@232540.5232 ogmjhvh5pr05h6ptcvqivdn7pa Query : use flama_phc
20250127@232540.5237 ogmjhvh5pr05h6ptcvqivdn7pa Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232540.5339 ogmjhvh5pr05h6ptcvqivdn7pa Query : use flama_phc
20250127@232540.5343 ogmjhvh5pr05h6ptcvqivdn7pa Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232540.5362 ogmjhvh5pr05h6ptcvqivdn7pa Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232540.5386 ogmjhvh5pr05h6ptcvqivdn7pa Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4967';
20250127@232540.5435 ogmjhvh5pr05h6ptcvqivdn7pa Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4967';
20250127@232540.6050 qqqaqts7ams2n83073h1t2mu0n Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250127@232540.6061 qqqaqts7ams2n83073h1t2mu0n Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250127@232540.6152 qqqaqts7ams2n83073h1t2mu0n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4968';
20250127@232540.6223 qqqaqts7ams2n83073h1t2mu0n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4968';
20250127@232540.6304 qqqaqts7ams2n83073h1t2mu0n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4968';
20250127@232540.6350 qqqaqts7ams2n83073h1t2mu0n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4968';
20250127@232540.6427 qqqaqts7ams2n83073h1t2mu0n Query : use flama_phc
20250127@232540.6431 qqqaqts7ams2n83073h1t2mu0n Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250127@232540.6503 qqqaqts7ams2n83073h1t2mu0n Query : use flama_phc
20250127@232540.6506 qqqaqts7ams2n83073h1t2mu0n Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20250127@232540.6636 qqqaqts7ams2n83073h1t2mu0n 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 ,sum(qtt) over (partition by bi.ref) qtt_total 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 = 2007 and bo.obrano = 2500713 
20250127@232540.6998 qqqaqts7ams2n83073h1t2mu0n Query : use flama_phc
20250127@232540.7002 qqqaqts7ams2n83073h1t2mu0n Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250127@232540.7055 qqqaqts7ams2n83073h1t2mu0n Query : use flama_phc
20250127@232540.7059 qqqaqts7ams2n83073h1t2mu0n Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250127@232540.7079 qqqaqts7ams2n83073h1t2mu0n Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250127@232540.7116 qqqaqts7ams2n83073h1t2mu0n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4968';
20250127@232540.7164 qqqaqts7ams2n83073h1t2mu0n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4968';
20250127@233610.1837 deppuh5cg1jmnubelqcpnj96n2 Query : use flama_phc
20250127@233610.1842 deppuh5cg1jmnubelqcpnj96n2 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250127@233610.1935 deppuh5cg1jmnubelqcpnj96n2 Query : use flama_phc
20250127@233610.1939 deppuh5cg1jmnubelqcpnj96n2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250128@071910.6010 eq32bfh0kpfln7pvc84pdif007 Query : use flama_phc
20250128@071910.6060 eq32bfh0kpfln7pvc84pdif007 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250128@071910.7710 eq32bfh0kpfln7pvc84pdif007 Query : use flama_phc
20250128@071910.7760 eq32bfh0kpfln7pvc84pdif007 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250128@073613.4656 d3nv8qmtdqmfvqblspfcqq3ct6 Query : use flama_phc
20250128@073613.4661 d3nv8qmtdqmfvqblspfcqq3ct6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250128@073613.4832 d3nv8qmtdqmfvqblspfcqq3ct6 Query : use flama_phc
20250128@073613.4836 d3nv8qmtdqmfvqblspfcqq3ct6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250128@081909.9221 mnfvo0n3lo8ff67r7uecdjq7ke Query : use flama_phc
20250128@081909.9227 mnfvo0n3lo8ff67r7uecdjq7ke Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250128@081909.9363 mnfvo0n3lo8ff67r7uecdjq7ke Query : use flama_phc
20250128@081909.9367 mnfvo0n3lo8ff67r7uecdjq7ke Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250128@083428.3226 771uvft7hosl7qtj483450obe3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250128@083428.3253 771uvft7hosl7qtj483450obe3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250128@083428.3999 771uvft7hosl7qtj483450obe3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4969';
20250128@083428.4186 771uvft7hosl7qtj483450obe3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4969';
20250128@083428.4310 771uvft7hosl7qtj483450obe3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4969';
20250128@083428.4386 771uvft7hosl7qtj483450obe3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4969';
20250128@083428.5675 uo8fcf02hpqp1ecb1jig553qdc Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250128@083428.5687 uo8fcf02hpqp1ecb1jig553qdc Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250128@083428.5763 uo8fcf02hpqp1ecb1jig553qdc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4970';
20250128@083428.5831 uo8fcf02hpqp1ecb1jig553qdc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4970';
20250128@083428.5905 uo8fcf02hpqp1ecb1jig553qdc Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4970';
20250128@083428.5949 uo8fcf02hpqp1ecb1jig553qdc Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4970';
20250128@083428.6002 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083428.6006 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250128@083428.6124 uo8fcf02hpqp1ecb1jig553qdc Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20250128@083428.6430 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4421.00.1'
20250128@083428.6554 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.4421.00.1' and bi.lordem =20000
20250128@083428.7006 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431344,278000002 ' 
20250128@083428.7371 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4961.00.1'
20250128@083428.7487 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.4961.00.1' and bi.lordem =30000
20250128@083428.7823 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431349,285000003 ' 
20250128@083428.8140 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.497.00.01'
20250128@083428.8260 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.497.00.01' and bi.lordem =40000
20250128@083428.8685 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431357,886000004 ' 
20250128@083428.9044 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4990.00.1'
20250128@083428.9167 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.4990.00.1' and bi.lordem =50000
20250128@083428.9617 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431362,399000005 ' 
20250128@083429.1630 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.727.00.01'
20250128@083429.3350 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.727.00.01' and bi.lordem =70000
20250128@083429.2478 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431377,005000007 ' 
20250128@083429.2960 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.958.00.01'
20250128@083429.3085 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.958.00.01' and bi.lordem =80000
20250128@083429.3530 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431523,168000008 ' 
20250128@083429.4287 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.969.00.01'
20250128@083429.4725 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.969.00.01' and bi.lordem =90000
20250128@083429.5262 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431533,493000009 ' 
20250128@083429.6054 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.969.00.01'
20250128@083429.6084 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.969.00.01' and bi.lordem =90000
20250128@083429.6114 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431533,493000009 ' 
20250128@083429.6144 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.938.00.01'
20250128@083429.6278 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.938.00.01' and bi.lordem =100000
20250128@083429.6644 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431539,060000010 ' 
20250128@083429.7324 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.948.00.01'
20250128@083429.7471 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.948.00.01' and bi.lordem =110000
20250128@083429.7832 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431545,639000011 ' 
20250128@083429.8175 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.988.00.01'
20250128@083429.8298 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.988.00.01' and bi.lordem =120000
20250128@083429.8660 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431551,006000012 ' 
20250128@083429.9048 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.988.00.01'
20250128@083429.9075 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.988.00.01' and bi.lordem =120000
20250128@083429.9100 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431551,006000012 ' 
20250128@083429.9155 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.681.00.01'
20250128@083429.9280 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.681.00.01' and bi.lordem =140000
20250128@083429.9969 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431562,239000014 ' 
20250128@083430.4360 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.682.00.01'
20250128@083430.6400 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.682.00.01' and bi.lordem =150000
20250128@083430.1617 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431568,432000015 ' 
20250128@083430.2032 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.682.00.01'
20250128@083430.2055 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.682.00.01' and bi.lordem =150000
20250128@083430.2079 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431568,432000015 ' 
20250128@083430.2103 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2300.00.1'
20250128@083430.2221 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.2300.00.1' and bi.lordem =160000
20250128@083430.2561 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431577,595000016 ' 
20250128@083430.2901 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1405.00.1'
20250128@083430.3008 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.1405.00.1' and bi.lordem =170000
20250128@083430.3332 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431582,608000017 ' 
20250128@083430.3678 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1406.00.1'
20250128@083430.3789 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.1406.00.1' and bi.lordem =180000
20250128@083430.4133 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431592,820000018 ' 
20250128@083430.4465 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1461.00.1'
20250128@083430.4642 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.1461.00.1' and bi.lordem =190000
20250128@083430.5068 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431598,400000019 ' 
20250128@083430.5397 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1462.00.1'
20250128@083430.5514 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.1462.00.1' and bi.lordem =200000
20250128@083430.6044 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431611,689000020 ' 
20250128@083430.6545 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2301.00.3'
20250128@083430.6668 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.2301.00.3' and bi.lordem =210000
20250128@083430.7004 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431624,461000021 ' 
20250128@083430.7335 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2301.00.3'
20250128@083430.7357 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.2301.00.3' and bi.lordem =210000
20250128@083430.7379 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431624,461000021 ' 
20250128@083430.7401 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5396.00.1'
20250128@083430.7520 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.5396.00.1' and bi.lordem =220000
20250128@083430.7879 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431631,362000022 ' 
20250128@083430.8200 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5365.00.1'
20250128@083430.8319 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.5365.00.1' and bi.lordem =230000
20250128@083430.8651 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431644,834000023 ' 
20250128@083430.8973 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2066.00.1'
20250128@083430.9093 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.2066.00.1' and bi.lordem =240000
20250128@083430.9466 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431653,218000024 ' 
20250128@083430.9841 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5501.00.1'
20250128@083430.9967 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.5501.00.1' and bi.lordem =250000
20250128@083431.3410 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431665,190000025 ' 
20250128@083431.6880 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5501.00.1'
20250128@083431.7100 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.5501.00.1' and bi.lordem =250000
20250128@083431.7330 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431665,190000025 ' 
20250128@083431.7550 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.5501.00.1'
20250128@083431.7750 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.5501.00.1' and bi.lordem =250000
20250128@083431.7980 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431665,190000025 ' 
20250128@083431.8200 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2028.00.2'
20250128@083431.9460 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.2028.00.2' and bi.lordem =260000
20250128@083431.1275 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431673,043000026 ' 
20250128@083431.1616 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2907.00.1'
20250128@083431.1735 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.2907.00.1' and bi.lordem =270000
20250128@083431.2435 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431680,531000027 ' 
20250128@083431.2911 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.2231.00.2'
20250128@083431.4494 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =001 and bo.boano =2025 and bo.obrano = 0000241 and bi.ref ='324.2231.00.2' and bi.lordem =280000
20250128@083431.5178 uo8fcf02hpqp1ecb1jig553qdc Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'av25012431693,081000028 ' 
20250128@083431.5610 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.5614 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 1 valor from ts where ts.ndos = 5
20250128@083431.5785 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.5788 uo8fcf02hpqp1ecb1jig553qdc 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')
20250128@083431.5875 uo8fcf02hpqp1ecb1jig553qdc 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
20250128@083431.6044 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.6048 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20250128@083431.6161 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.6164 uo8fcf02hpqp1ecb1jig553qdc Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250128@083431.6239 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.6242 uo8fcf02hpqp1ecb1jig553qdc Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20250128@083431.6482 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.6485 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from ts where ndos = 5
20250128@083431.6569 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.6881 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20250128@083431.7155 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.7253 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20250128@083431.7265 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.7283 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20250128@083431.7294 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20250128@083431.7417 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250128@083431.7569 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2025 order by obrano desc
20250128@083431.7763 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.7770 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20250128@083431.7863 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.7881 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20250128@083431.7921 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut679891025667989697bd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250128@083431.8011 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.8030 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20250128@083431.8045 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut679891025667989697bd','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20250128','09:04',?,?)
20250128@083431.8437 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.8459 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20250128@083431.8479 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut679891025667989697bd','trf entre armazéns a','2025-01-28',5,32,?,?,?,?,?,?,?,?,2025, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20250128@083431.9147 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.9151 uo8fcf02hpqp1ecb1jig553qdc Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20250128@083431.9305 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.9310 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.4421.00.1'
20250128@083431.9439 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.9442 uo8fcf02hpqp1ecb1jig553qdc 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.4421.00.1' and sa.armazem = 133 
20250128@083431.9517 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083431.9520 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.4421.00.1'
20250128@083431.9549 uo8fcf02hpqp1ecb1jig553qdc 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.4421.00.1'
20250128@083431.9707 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.9725 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083431.9742 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.9762 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083431.9785 uo8fcf02hpqp1ecb1jig553qdc Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2400920200a'
20250128@083431.9859 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250128@083431.9901 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083431.9920 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083431.9936 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut679897982167989697f1','aut679891025667989697bd',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.2960 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.3170 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083432.3390 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut679897982167989697f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 12.000, 12.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,10000 ,30.1,30.1*200.48,30.1,30.1*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,30.1*12.000,30.1*12.000*200.48 ,11.969000,11.969000*200.48 ,11.969000,11.969000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,30.1,30.1*200.48,30.1*12.000,30.1*12.000*200.48,'av25012431344,278000002 ',30.1,30.1*12.000,30.1,30.1*12.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.1073 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.1077 uo8fcf02hpqp1ecb1jig553qdc Query : select st.usalote valor from st where st.ref = '324.4961.00.1'
20250128@083432.1095 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.1098 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.4961.00.1'
20250128@083432.1119 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.1123 uo8fcf02hpqp1ecb1jig553qdc 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.4961.00.1' and sa.armazem = 133 
20250128@083432.1246 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.1250 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.4961.00.1'
20250128@083432.1282 uo8fcf02hpqp1ecb1jig553qdc 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.4961.00.1'
20250128@083432.1436 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.1488 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083432.1506 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.1558 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083432.1570 uo8fcf02hpqp1ecb1jig553qdc Query : select sestamp valor from se where ref ='324.4961.00.1' and lote = 'r2101092200a'
20250128@083432.1635 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250128@083432.1677 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.1730 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083432.1744 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67989008286798969828','aut679891025667989697bd',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.1906 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.1926 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083432.1944 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67989008286798969828',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 8.000, 8.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,20000 ,32,32*200.48,32,32*200.48 ,0,0,'un ','' ,bo.marcada,1 ,32*8.000,32*8.000*200.48 ,13.698000,13.698000*200.48 ,13.698000,13.698000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,32,32*200.48,32*8.000,32*8.000*200.48,'av25012431349,285000003 ',32,32*8.000,32,32*8.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.2240 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.2244 uo8fcf02hpqp1ecb1jig553qdc Query : select st.usalote valor from st where st.ref = '324.497.00.01'
20250128@083432.2264 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.2267 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.497.00.01'
20250128@083432.2286 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.2290 uo8fcf02hpqp1ecb1jig553qdc 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.497.00.01' and sa.armazem = 133 
20250128@083432.2371 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.2375 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.497.00.01'
20250128@083432.2398 uo8fcf02hpqp1ecb1jig553qdc 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.497.00.01'
20250128@083432.2555 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.2575 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083432.2591 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.2608 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083432.2618 uo8fcf02hpqp1ecb1jig553qdc Query : select sestamp valor from se where ref ='324.497.00.01' and lote = 'r2300024300a'
20250128@083432.2646 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250128@083432.2662 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.2682 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083432.2697 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67989607066798969841','aut679891025667989697bd',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.2879 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.2900 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083432.2918 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67989607066798969841',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 8.000, 8.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,30000 ,19.2,19.2*200.48,19.2,19.2*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,19.2*8.000,19.2*8.000*200.48 ,8.279000,8.279000*200.48 ,8.279000,8.279000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,19.2,19.2*200.48,19.2*8.000,19.2*8.000*200.48,'av25012431357,886000004 ',19.2,19.2*8.000,19.2,19.2*8.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.3291 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.3297 uo8fcf02hpqp1ecb1jig553qdc Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20250128@083432.3325 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.3329 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.4990.00.1'
20250128@083432.3431 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.3435 uo8fcf02hpqp1ecb1jig553qdc 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 
20250128@083432.3510 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.3514 uo8fcf02hpqp1ecb1jig553qdc Query : select st.stns valor from st where st.ref = '324.4990.00.1'
20250128@083432.3540 uo8fcf02hpqp1ecb1jig553qdc 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'
20250128@083432.3685 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.3704 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083432.3726 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.3750 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083432.3760 uo8fcf02hpqp1ecb1jig553qdc Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20250128@083432.3789 uo8fcf02hpqp1ecb1jig553qdc Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250128@083432.3808 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.3893 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250128@083432.3930 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6798956349679896985c','aut679891025667989697bd',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.4112 uo8fcf02hpqp1ecb1jig553qdc Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250128@083432.4133 uo8fcf02hpqp1ecb1jig553qdc Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250128@083432.4153 uo8fcf02hpqp1ecb1jig553qdc Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut6798956349679896985c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,40000 ,28.8,28.8*200.48,28.8,28.8*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,28.8*6.000,28.8*6.000*200.48 ,12.265000,12.265000*200.48 ,12.265000,12.265000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,28.8,28.8*200.48,28.8*6.000,28.8*6.000*200.48,'av25012431362,399000005 ',28.8,28.8*6.000,28.8,28.8*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut679891025667989697bd'
20250128@083432.4454 uo8fcf02hpqp1ecb1jig553qdc Query : use flama_phc
20250128@083432.4460 uo8fcf02hpqp1ecb1jig553qdc Query : select st.usalote valor from st where st.ref = '324.727.00.01'
