20240611@092026.8064 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092026.8106 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 1 valor from ts where ts.ndos = 5
20240611@092026.8188 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092026.8191 gpq3bhrvbj3hrh9j0vsif67g8m 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')
20240611@092026.8327 gpq3bhrvbj3hrh9j0vsif67g8m 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
20240611@092026.8345 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092026.8348 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20240611@092026.8371 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092026.8374 gpq3bhrvbj3hrh9j0vsif67g8m Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240611@092026.8384 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092026.8387 gpq3bhrvbj3hrh9j0vsif67g8m Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20240611@092026.8411 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092026.8414 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from ts where ndos = 5
20240611@092026.8424 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092026.8650 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20240611@092026.8861 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092026.9500 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20240611@092026.9861 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.2420 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20240611@092027.4210 gpq3bhrvbj3hrh9j0vsif67g8m 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
20240611@092027.7690 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240611@092027.9920 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240611@092027.1333 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.1401 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20240611@092027.1735 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.1947 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20240611@092027.2579 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6668078349666808cb20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240611@092027.2740 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.3138 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20240611@092027.3263 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut6668078349666808cb20','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20240611','09:50',?,?)
20240611@092027.3700 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.3965 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20240611@092027.4175 gpq3bhrvbj3hrh9j0vsif67g8m 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 ('aut6668078349666808cb20','trf entre armazéns a','2024-06-11',5,311,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20240611@092027.5055 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.5209 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.497.00.01'
20240611@092027.5423 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.5466 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.497.00.01'
20240611@092027.5679 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.5720 gpq3bhrvbj3hrh9j0vsif67g8m 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 
20240611@092027.6021 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.6113 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.497.00.01'
20240611@092027.6331 gpq3bhrvbj3hrh9j0vsif67g8m 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'
20240611@092027.6853 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.6896 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092027.6906 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.6921 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092027.6929 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.497.00.01' and lote = 'r2300022100a'
20240611@092027.6941 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092027.6951 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.6965 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092027.6972 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668023932666808cba9','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092027.7199 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.7504 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092027.7534 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668023932666808cba9',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 ,0,0*200.48,0,0*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,0*12.000,0*12.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*200.48,0*12.000,0*12.000*200.48,0,0*12.000,0,0*12.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092027.8061 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.8282 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20240611@092027.8655 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.8710 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.969.00.01'
20240611@092027.8724 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.8727 gpq3bhrvbj3hrh9j0vsif67g8m 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.969.00.01' and sa.armazem = 133 
20240611@092027.9002 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092027.9049 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.969.00.01'
20240611@092027.9078 gpq3bhrvbj3hrh9j0vsif67g8m 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.969.00.01'
20240611@092027.9280 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.9336 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092027.9373 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092027.9387 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092027.9392 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20240611@092027.9406 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092027.9456 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.3130 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092028.4380 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668031597666808cbe6','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092028.7330 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.1019 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092028.1236 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668031597666808cbe6',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,20000 ,0,0*200.48,0,0*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,0*6.000,0*6.000*200.48 ,15.817000,15.817000*200.48 ,15.817000,15.817000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*6.000,0*6.000*200.48,0,0*6.000,0,0*6.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092028.2136 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.2177 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20240611@092028.2646 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.2729 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.969.00.01'
20240611@092028.3073 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.3115 gpq3bhrvbj3hrh9j0vsif67g8m 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.969.00.01' and sa.armazem = 133 
20240611@092028.4006 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.4124 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.969.00.01'
20240611@092028.4360 gpq3bhrvbj3hrh9j0vsif67g8m 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.969.00.01'
20240611@092028.4572 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.4867 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092028.5074 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.5285 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092028.5410 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20240611@092028.5854 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092028.6063 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.6279 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092028.6658 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668084805666808cc94','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092028.7128 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.7466 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092028.7762 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668084805666808cc94',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,30000 ,0,0*200.48,0,0*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,0*6.000,0*6.000*200.48 ,15.817000,15.817000*200.48 ,15.817000,15.817000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*6.000,0*6.000*200.48,0,0*6.000,0,0*6.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092028.8156 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.8205 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240611@092028.8373 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.8377 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4521.00.1'
20240611@092028.8390 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.8393 gpq3bhrvbj3hrh9j0vsif67g8m 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.4521.00.1' and sa.armazem = 133 
20240611@092028.8482 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092028.8485 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4521.00.1'
20240611@092028.8498 gpq3bhrvbj3hrh9j0vsif67g8m 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'
20240611@092028.8823 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.8838 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092028.8854 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092028.8868 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092028.8879 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240611@092028.9514 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092028.9877 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092029.9500 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092029.2230 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668012358666808ccf1','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092029.6010 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092029.8140 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092029.1025 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668012358666808ccf1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 16.000, 16.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 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*16.000,0*16.000*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*200.48,0*16.000,0*16.000*200.48,0,0*16.000,0,0*16.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092029.1758 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.1800 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20240611@092029.2010 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.2051 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5347.00.1'
20240611@092029.2731 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.2813 gpq3bhrvbj3hrh9j0vsif67g8m 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.5347.00.1' and sa.armazem = 133 
20240611@092029.3100 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.3141 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5347.00.1'
20240611@092029.3353 gpq3bhrvbj3hrh9j0vsif67g8m 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.5347.00.1'
20240611@092029.3652 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092029.3866 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092029.4164 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092029.4442 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092029.4568 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2300915100a'
20240611@092029.4814 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092029.5161 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092029.5426 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092029.5628 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668031412666808cd7e','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092029.5972 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092029.6408 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092029.6876 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668031412666808cd7e',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,50000 ,0,0*200.48,0,0*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,0*6.000,0*6.000*200.48 ,7.306000,7.306000*200.48 ,7.306000,7.306000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*6.000,0*6.000*200.48,0,0*6.000,0,0*6.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092029.8358 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.8625 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.5347.00.1'
20240611@092029.8877 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.8945 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5347.00.1'
20240611@092029.9259 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.9338 gpq3bhrvbj3hrh9j0vsif67g8m 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.5347.00.1' and sa.armazem = 133 
20240611@092029.9659 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092029.9724 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5347.00.1'
20240611@092029.9995 gpq3bhrvbj3hrh9j0vsif67g8m 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.5347.00.1'
20240611@092030.4190 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.8060 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092030.1121 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.1334 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092030.1511 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.5347.00.1' and lote = 'r2300915100a'
20240611@092030.1717 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092030.1729 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.1755 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092030.1761 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668015558666808ce2a','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092030.1896 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.1910 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092030.1935 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668015558666808ce2a',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,60000 ,0,0*200.48,0,0*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,0*12.000,0*12.000*200.48 ,7.306000,7.306000*200.48 ,7.306000,7.306000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*12.000,0*12.000*200.48,0,0*12.000,0,0*12.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092030.2218 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.2250 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20240611@092030.2262 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.2266 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5501.00.1'
20240611@092030.2286 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.2288 gpq3bhrvbj3hrh9j0vsif67g8m 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.5501.00.1' and sa.armazem = 133 
20240611@092030.2351 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.2354 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5501.00.1'
20240611@092030.2364 gpq3bhrvbj3hrh9j0vsif67g8m 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.5501.00.1'
20240611@092030.2537 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.2552 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092030.2563 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.2777 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092030.2923 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2300908100a'
20240611@092030.3133 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092030.3341 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.3554 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092030.3705 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668082531666808ce51','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092030.4000 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.4214 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092030.4423 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668082531666808ce51',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,70000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*12.000,0*12.000*200.48 ,18.137000,18.137000*200.48 ,18.137000,18.137000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*12.000,0*12.000*200.48,0,0*12.000,0,0*12.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092030.5006 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.5048 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.5500.00.1'
20240611@092030.5298 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.5353 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5500.00.1'
20240611@092030.5460 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.5473 gpq3bhrvbj3hrh9j0vsif67g8m 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.5500.00.1' and sa.armazem = 133 
20240611@092030.5643 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.5684 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.5500.00.1'
20240611@092030.5958 gpq3bhrvbj3hrh9j0vsif67g8m 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.5500.00.1'
20240611@092030.6168 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.6390 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092030.6599 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.6810 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092030.6935 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.5500.00.1' and lote = 'r2301223200a'
20240611@092030.7347 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092030.7628 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.7840 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092030.7968 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668058176666808ceba','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092030.8258 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092030.8470 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092030.8678 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668058176666808ceba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 10.000, 10.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,80000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*10.000,0*10.000*200.48 ,24.067000,24.067000*200.48 ,24.067000,24.067000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*10.000,0*10.000*200.48,0,0*10.000,0,0*10.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092030.9235 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.9276 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240611@092030.9488 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.9529 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.642.00.01'
20240611@092030.9744 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092030.9788 gpq3bhrvbj3hrh9j0vsif67g8m 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.642.00.01' and sa.armazem = 133 
20240611@092031.8000 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.1210 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.642.00.01'
20240611@092031.7040 gpq3bhrvbj3hrh9j0vsif67g8m 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.642.00.01'
20240611@092031.1721 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.1933 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092031.2148 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.2364 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092031.2490 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240611@092031.2700 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092031.2907 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.3164 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092031.3297 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668083005666808cf46','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092031.3757 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.3984 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092031.4232 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668083005666808cf46',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2.000, 2.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,90000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*2.000,0*2.000*200.48 ,18.573000,18.573000*200.48 ,18.573000,18.573000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*2.000,0*2.000*200.48,0,0*2.000,0,0*2.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092031.4975 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.5030 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.658.00.01'
20240611@092031.5240 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.5286 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.658.00.01'
20240611@092031.5497 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.5538 gpq3bhrvbj3hrh9j0vsif67g8m 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.658.00.01' and sa.armazem = 133 
20240611@092031.5838 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.5880 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.658.00.01'
20240611@092031.6093 gpq3bhrvbj3hrh9j0vsif67g8m 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.658.00.01'
20240611@092031.6567 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.6778 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092031.7018 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.7230 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092031.7357 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.658.00.01' and lote = 'r2300819200a'
20240611@092031.7609 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092031.7819 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.8030 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092031.8156 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668041002666808cfbe','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092031.8442 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092031.8657 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092031.8875 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668041002666808cfbe',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.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,100000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*4.000,0*4.000*200.48 ,18.765000,18.765000*200.48 ,18.765000,18.765000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*4.000,0*4.000*200.48,0,0*4.000,0,0*4.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092031.9414 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.9455 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.682.00.01'
20240611@092031.9521 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.9524 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.682.00.01'
20240611@092031.9657 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.9697 gpq3bhrvbj3hrh9j0vsif67g8m 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.682.00.01' and sa.armazem = 133 
20240611@092031.9922 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092031.9963 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.682.00.01'
20240611@092032.1740 gpq3bhrvbj3hrh9j0vsif67g8m 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.682.00.01'
20240611@092032.5580 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.8250 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092032.1096 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.1336 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092032.1485 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.682.00.01' and lote = 'r2400059200a'
20240611@092032.1694 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092032.1928 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.2139 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092032.2302 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668041211666808d02f','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092032.2600 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.2810 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092032.3019 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668041211666808d02f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 10.000, 10.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,110000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*10.000,0*10.000*200.48 ,23.221000,23.221000*200.48 ,23.221000,23.221000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*10.000,0*10.000*200.48,0,0*10.000,0,0*10.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092032.3594 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.3635 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.4585.00.1'
20240611@092032.3847 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.3889 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4585.00.1'
20240611@092032.4103 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.4146 gpq3bhrvbj3hrh9j0vsif67g8m 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.4585.00.1' and sa.armazem = 133 
20240611@092032.4449 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.4511 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4585.00.1'
20240611@092032.4720 gpq3bhrvbj3hrh9j0vsif67g8m 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.4585.00.1'
20240611@092032.5216 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.5627 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092032.5871 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.6110 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092032.6235 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.4585.00.1' and lote = 'r2300381200a'
20240611@092032.6505 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092032.6973 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.7495 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092032.7761 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668018935666808d0aa','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092032.8180 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092032.8394 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092032.8649 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668018935666808d0aa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.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,120000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*4.000,0*4.000*200.48 ,42.430000,42.430000*200.48 ,42.430000,42.430000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*4.000,0*4.000*200.48,0,0*4.000,0,0*4.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092032.9253 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.9296 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.4960.00.1'
20240611@092032.9401 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.9404 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4960.00.1'
20240611@092032.9416 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.9429 gpq3bhrvbj3hrh9j0vsif67g8m 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.4960.00.1' and sa.armazem = 133 
20240611@092032.9588 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092032.9650 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4960.00.1'
20240611@092032.9882 gpq3bhrvbj3hrh9j0vsif67g8m 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.4960.00.1'
20240611@092033.3670 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.4270 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092033.5360 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.7620 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092033.9020 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.4960.00.1' and lote = 'r2100754100a'
20240611@092033.1122 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092033.1351 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.1582 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092033.1710 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668088110666808d120','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092033.1993 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.2251 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092033.2534 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668088110666808d120',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,130000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*6.000,0*6.000*200.48 ,6.102000,6.102000*200.48 ,6.102000,6.102000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*6.000,0*6.000*200.48,0,0*6.000,0,0*6.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092033.3136 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092033.3178 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.4964.00.1'
20240611@092033.3420 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092033.3470 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4964.00.1'
20240611@092033.3689 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092033.3731 gpq3bhrvbj3hrh9j0vsif67g8m 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.4964.00.1' and sa.armazem = 133 
20240611@092033.3910 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092033.3956 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.4964.00.1'
20240611@092033.5161 gpq3bhrvbj3hrh9j0vsif67g8m 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.4964.00.1'
20240611@092033.6048 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.6765 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092033.6975 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.7216 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092033.7340 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.4964.00.1' and lote = 'r2300717100a'
20240611@092033.7715 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092033.7926 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.8176 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092033.8351 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668042555666808d1c1','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092033.8646 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092033.8878 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092033.9131 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668042555666808d1c1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.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,140000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*4.000,0*4.000*200.48 ,11.761000,11.761000*200.48 ,11.761000,11.761000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*4.000,0*4.000*200.48,0,0*4.000,0,0*4.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092033.9756 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092033.9868 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20240611@092034.1000 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092034.1420 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.2221.00.1'
20240611@092034.3840 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092034.3880 gpq3bhrvbj3hrh9j0vsif67g8m 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.2221.00.1' and sa.armazem = 133 
20240611@092034.1461 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092034.1544 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.2221.00.1'
20240611@092034.1787 gpq3bhrvbj3hrh9j0vsif67g8m 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.2221.00.1'
20240611@092034.2054 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092034.2311 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092034.2609 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092034.2850 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092034.3109 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301281300a'
20240611@092034.3991 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092034.4460 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092034.4677 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092034.4875 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668035200666808d26c','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092034.5231 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092034.5464 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092034.5684 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668035200666808d26c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.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,150000 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*4.000,0*4.000*200.48 ,9.892000,9.892000*200.48 ,9.892000,9.892000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*4.000,0*4.000*200.48,0,0*4.000,0,0*4.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092034.6264 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092034.6306 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20240611@092034.6573 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092034.6615 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.2222.00.1'
20240611@092034.6828 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092034.6873 gpq3bhrvbj3hrh9j0vsif67g8m 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.2222.00.1' and sa.armazem = 133 
20240611@092034.7208 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092034.7249 gpq3bhrvbj3hrh9j0vsif67g8m Query : select st.stns valor from st where st.ref = '324.2222.00.1'
20240611@092034.7483 gpq3bhrvbj3hrh9j0vsif67g8m 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.2222.00.1'
20240611@092034.7967 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092034.8184 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092034.8394 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092034.8693 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092034.8817 gpq3bhrvbj3hrh9j0vsif67g8m Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301281400a'
20240611@092034.9035 gpq3bhrvbj3hrh9j0vsif67g8m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@092034.9464 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092035.5050 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@092035.6400 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668030731666808d2e7','aut6668078349666808cb20',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 = 'aut6668078349666808cb20'
20240611@092035.9600 gpq3bhrvbj3hrh9j0vsif67g8m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@092035.1005 gpq3bhrvbj3hrh9j0vsif67g8m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@092035.1036 gpq3bhrvbj3hrh9j0vsif67g8m 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668030731666808d2e7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.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,160000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*4.000,0*4.000*200.48 ,9.687000,9.687000*200.48 ,9.687000,9.687000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*4.000,0*4.000*200.48,0,0*4.000,0,0*4.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668078349666808cb20'
20240611@092035.1499 gpq3bhrvbj3hrh9j0vsif67g8m Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut6668078349666808cb20','','wait',5,'','')
20240611@092035.1661 gpq3bhrvbj3hrh9j0vsif67g8m Query : use flama_phc
20240611@092035.1680 gpq3bhrvbj3hrh9j0vsif67g8m Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@092035.1692 gpq3bhrvbj3hrh9j0vsif67g8m Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='318';
20240611@092035.1707 gpq3bhrvbj3hrh9j0vsif67g8m Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='318';
20240611@093613.6794 oi5u460vvur2h4n7lpk90bnb32 Query : use flama_phc
20240611@093613.6799 oi5u460vvur2h4n7lpk90bnb32 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@093613.6817 oi5u460vvur2h4n7lpk90bnb32 Query : use flama_phc
20240611@093613.6820 oi5u460vvur2h4n7lpk90bnb32 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@101912.9925 q9hre9tcaqo2v8as901v08up4t Query : use flama_phc
20240611@101912.9931 q9hre9tcaqo2v8as901v08up4t Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@101912.9952 q9hre9tcaqo2v8as901v08up4t Query : use flama_phc
20240611@101912.9955 q9hre9tcaqo2v8as901v08up4t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@102126.2254 qktaq0uj0r67dovjgomlk8aeri Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240611@102126.2268 qktaq0uj0r67dovjgomlk8aeri Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240611@102126.2284 qktaq0uj0r67dovjgomlk8aeri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='319';
20240611@102126.2319 qktaq0uj0r67dovjgomlk8aeri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='319';
20240611@102126.2331 qktaq0uj0r67dovjgomlk8aeri Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='319';
20240611@102126.2342 qktaq0uj0r67dovjgomlk8aeri Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='319';
20240611@102126.2353 qktaq0uj0r67dovjgomlk8aeri Query : use flama_phc
20240611@102126.2356 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240611@102126.2370 qktaq0uj0r67dovjgomlk8aeri Query : use flama_phc
20240611@102126.2373 qktaq0uj0r67dovjgomlk8aeri Query : select no, estab,szadrsdesc from szadrs where u_coddest=227
20240611@102126.2442 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240611@102126.2592 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240611@102126.2602 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240611@102126.2761 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1406.00.1'
20240611@102126.2900 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20240611@102126.3037 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4160.00.1'
20240611@102126.3242 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4160.00.1'
20240611@102126.3251 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20240611@102126.3400 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20240611@102126.3409 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20240611@102126.3554 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2028.00.2'
20240611@102126.3692 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240611@102126.3827 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1889.00.1'
20240611@102126.3837 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20240611@102126.3969 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20240611@102126.3978 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1896.00.1'
20240611@102126.4110 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1896.00.1'
20240611@102126.4120 qktaq0uj0r67dovjgomlk8aeri Query : use flama_phc
20240611@102126.4123 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240611@102126.4289 qktaq0uj0r67dovjgomlk8aeri Query : use flama_phc
20240611@102126.4292 qktaq0uj0r67dovjgomlk8aeri Query : select top 1 1 valor from td where td.ndoc = 39
20240611@102126.4372 qktaq0uj0r67dovjgomlk8aeri Query : use flama_phc
20240611@102126.4375 qktaq0uj0r67dovjgomlk8aeri 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')
20240611@103612.7522 tlh2t7tnnhn4qp7et7ldc1409q Query : use flama_phc
20240611@103612.7529 tlh2t7tnnhn4qp7et7ldc1409q Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@103612.7547 tlh2t7tnnhn4qp7et7ldc1409q Query : use flama_phc
20240611@103612.7550 tlh2t7tnnhn4qp7et7ldc1409q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@111632.3427 sc4lqe0r1bgmo2qj5ff3bp7nkk Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240611@111632.3466 sc4lqe0r1bgmo2qj5ff3bp7nkk Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240611@111632.3504 sc4lqe0r1bgmo2qj5ff3bp7nkk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='320';
20240611@111632.3536 sc4lqe0r1bgmo2qj5ff3bp7nkk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='320';
20240611@111632.3549 sc4lqe0r1bgmo2qj5ff3bp7nkk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='320';
20240611@111632.3559 sc4lqe0r1bgmo2qj5ff3bp7nkk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='320';
20240611@111632.5536 4evihmh56psh3ngbuceobbkr33 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240611@111632.5557 4evihmh56psh3ngbuceobbkr33 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240611@111632.5571 4evihmh56psh3ngbuceobbkr33 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='321';
20240611@111632.5636 4evihmh56psh3ngbuceobbkr33 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='321';
20240611@111632.5649 4evihmh56psh3ngbuceobbkr33 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='321';
20240611@111632.5660 4evihmh56psh3ngbuceobbkr33 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='321';
20240611@111632.5672 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.5675 4evihmh56psh3ngbuceobbkr33 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240611@111632.5690 4evihmh56psh3ngbuceobbkr33 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20240611@111632.5720 4evihmh56psh3ngbuceobbkr33 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.682.00.01'
20240611@111632.5924 4evihmh56psh3ngbuceobbkr33 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.645.00.01'
20240611@111632.6226 4evihmh56psh3ngbuceobbkr33 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.645.00.01'
20240611@111632.6238 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.6271 4evihmh56psh3ngbuceobbkr33 Query : select top 1 1 valor from ts where ts.ndos = 5
20240611@111632.6281 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.6284 4evihmh56psh3ngbuceobbkr33 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')
20240611@111632.6303 4evihmh56psh3ngbuceobbkr33 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
20240611@111632.6319 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.6322 4evihmh56psh3ngbuceobbkr33 Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20240611@111632.6333 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.6336 4evihmh56psh3ngbuceobbkr33 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240611@111632.6346 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.6348 4evihmh56psh3ngbuceobbkr33 Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20240611@111632.6394 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.6401 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from ts where ndos = 5
20240611@111632.6473 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.6511 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20240611@111632.6529 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.6542 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20240611@111632.6547 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.6560 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20240611@111632.6657 4evihmh56psh3ngbuceobbkr33 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
20240611@111632.6708 4evihmh56psh3ngbuceobbkr33 Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240611@111632.6743 4evihmh56psh3ngbuceobbkr33 Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240611@111632.6754 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.6758 4evihmh56psh3ngbuceobbkr33 Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20240611@111632.6768 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.6783 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20240611@111632.6790 4evihmh56psh3ngbuceobbkr33 Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut666822254466682400a4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240611@111632.6794 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.6807 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20240611@111632.6813 4evihmh56psh3ngbuceobbkr33 Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut666822254466682400a4','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20240611','11:46',?,?)
20240611@111632.7147 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.7161 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20240611@111632.7171 4evihmh56psh3ngbuceobbkr33 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 ('aut666822254466682400a4','trf entre armazéns a','2024-06-11',5,312,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20240611@111632.7547 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.7553 4evihmh56psh3ngbuceobbkr33 Query : select st.usalote valor from st where st.ref = '324.682.00.01'
20240611@111632.7564 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.7566 4evihmh56psh3ngbuceobbkr33 Query : select st.stns valor from st where st.ref = '324.682.00.01'
20240611@111632.7577 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.7580 4evihmh56psh3ngbuceobbkr33 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.682.00.01' and sa.armazem = 133 
20240611@111632.7599 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.7602 4evihmh56psh3ngbuceobbkr33 Query : select st.stns valor from st where st.ref = '324.682.00.01'
20240611@111632.7616 4evihmh56psh3ngbuceobbkr33 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.682.00.01'
20240611@111632.7628 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.7641 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@111632.7651 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.7664 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@111632.7670 4evihmh56psh3ngbuceobbkr33 Query : select sestamp valor from se where ref ='324.682.00.01' and lote = 'r2400059200a'
20240611@111632.7680 4evihmh56psh3ngbuceobbkr33 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@111632.7690 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.7703 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@111632.7710 4evihmh56psh3ngbuceobbkr33 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut666823741966682400bb','aut666822254466682400a4',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 = 'aut666822254466682400a4'
20240611@111632.7836 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.7850 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@111632.7861 4evihmh56psh3ngbuceobbkr33 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut666823741966682400bb',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,10000 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*6.000,0*6.000*200.48 ,23.221000,23.221000*200.48 ,23.221000,23.221000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*6.000,0*6.000*200.48,0,0*6.000,0,0*6.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut666822254466682400a4'
20240611@111632.8131 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8135 4evihmh56psh3ngbuceobbkr33 Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20240611@111632.8146 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8149 4evihmh56psh3ngbuceobbkr33 Query : select st.stns valor from st where st.ref = '324.645.00.01'
20240611@111632.8160 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8163 4evihmh56psh3ngbuceobbkr33 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.645.00.01' and sa.armazem = 133 
20240611@111632.8223 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8226 4evihmh56psh3ngbuceobbkr33 Query : select st.stns valor from st where st.ref = '324.645.00.01'
20240611@111632.8236 4evihmh56psh3ngbuceobbkr33 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.645.00.01'
20240611@111632.8379 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.8393 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@111632.8403 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.8415 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@111632.8421 4evihmh56psh3ngbuceobbkr33 Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400054200a'
20240611@111632.8441 4evihmh56psh3ngbuceobbkr33 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@111632.8449 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.8461 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@111632.8467 4evihmh56psh3ngbuceobbkr33 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut666823819466682400ce','aut666822254466682400a4',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 = 'aut666822254466682400a4'
20240611@111632.8588 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.8602 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@111632.8612 4evihmh56psh3ngbuceobbkr33 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut666823819466682400ce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 5.000, 5.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 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*5.000,0*5.000*200.48 ,17.007000,17.007000*200.48 ,17.007000,17.007000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*5.000,0*5.000*200.48,0,0*5.000,0,0*5.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut666822254466682400a4'
20240611@111632.8874 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8877 4evihmh56psh3ngbuceobbkr33 Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20240611@111632.8889 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8892 4evihmh56psh3ngbuceobbkr33 Query : select st.stns valor from st where st.ref = '324.645.00.01'
20240611@111632.8901 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8904 4evihmh56psh3ngbuceobbkr33 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.645.00.01' and sa.armazem = 133 
20240611@111632.8916 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.8918 4evihmh56psh3ngbuceobbkr33 Query : select st.stns valor from st where st.ref = '324.645.00.01'
20240611@111632.8928 4evihmh56psh3ngbuceobbkr33 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.645.00.01'
20240611@111632.8939 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.8953 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@111632.8962 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.8974 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@111632.8980 4evihmh56psh3ngbuceobbkr33 Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400054200a'
20240611@111632.8992 4evihmh56psh3ngbuceobbkr33 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@111632.9001 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.9013 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@111632.9020 4evihmh56psh3ngbuceobbkr33 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut666821382666682400db','aut666822254466682400a4',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 = 'aut666822254466682400a4'
20240611@111632.9146 4evihmh56psh3ngbuceobbkr33 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@111632.9159 4evihmh56psh3ngbuceobbkr33 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@111632.9170 4evihmh56psh3ngbuceobbkr33 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut666821382666682400db',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 3.000, 3.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 ,0,0*200.48,0,0*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,0*3.000,0*3.000*200.48 ,17.007000,17.007000*200.48 ,17.007000,17.007000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*3.000,0*3.000*200.48,0,0*3.000,0,0*3.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut666822254466682400a4'
20240611@111632.9428 4evihmh56psh3ngbuceobbkr33 Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut666822254466682400a4','','wait',5,'','')
20240611@111632.9452 4evihmh56psh3ngbuceobbkr33 Query : use flama_phc
20240611@111632.9455 4evihmh56psh3ngbuceobbkr33 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@111632.9494 4evihmh56psh3ngbuceobbkr33 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='321';
20240611@111632.9508 4evihmh56psh3ngbuceobbkr33 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='321';
20240611@111915.1240 vjplif500i4qduoda9a2hn37pk Query : use flama_phc
20240611@111915.1245 vjplif500i4qduoda9a2hn37pk Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@111915.1308 vjplif500i4qduoda9a2hn37pk Query : use flama_phc
20240611@111915.1316 vjplif500i4qduoda9a2hn37pk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@113615.4875 kl49k4g5ie1v981dl58be7am2b Query : use flama_phc
20240611@113615.4881 kl49k4g5ie1v981dl58be7am2b Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@113615.4903 kl49k4g5ie1v981dl58be7am2b Query : use flama_phc
20240611@113615.4906 kl49k4g5ie1v981dl58be7am2b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@121917.7629 fjhetmkjq3h33spkk0mev6g0lu Query : use flama_phc
20240611@121917.7653 fjhetmkjq3h33spkk0mev6g0lu Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@121917.7712 fjhetmkjq3h33spkk0mev6g0lu Query : use flama_phc
20240611@121917.7715 fjhetmkjq3h33spkk0mev6g0lu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@123617.9360 fgdj5vmlqmocuovncm59jtp1rp Query : use flama_phc
20240611@123617.9368 fgdj5vmlqmocuovncm59jtp1rp Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@123617.9392 fgdj5vmlqmocuovncm59jtp1rp Query : use flama_phc
20240611@123617.9396 fgdj5vmlqmocuovncm59jtp1rp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@131921.8831 j4cbbio542pgt5pteimefqaf7o Query : use flama_phc
20240611@131921.8836 j4cbbio542pgt5pteimefqaf7o Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@131921.8858 j4cbbio542pgt5pteimefqaf7o Query : use flama_phc
20240611@131921.8862 j4cbbio542pgt5pteimefqaf7o Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@133207.2337 3kvs2qn3c800dlues5api8e5um Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240611@133207.2374 3kvs2qn3c800dlues5api8e5um Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240611@133207.2439 3kvs2qn3c800dlues5api8e5um Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='322';
20240611@133207.2473 3kvs2qn3c800dlues5api8e5um Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='322';
20240611@133207.2485 3kvs2qn3c800dlues5api8e5um Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='322';
20240611@133207.2499 3kvs2qn3c800dlues5api8e5um Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='322';
20240611@133207.3958 ieoc804sb782e89slam9r76po8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240611@133207.3971 ieoc804sb782e89slam9r76po8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240611@133207.3987 ieoc804sb782e89slam9r76po8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='323';
20240611@133207.4026 ieoc804sb782e89slam9r76po8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='323';
20240611@133207.4038 ieoc804sb782e89slam9r76po8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='323';
20240611@133207.4050 ieoc804sb782e89slam9r76po8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='323';
20240611@133207.4062 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.4065 ieoc804sb782e89slam9r76po8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240611@133207.4079 ieoc804sb782e89slam9r76po8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2
20240611@133207.4119 ieoc804sb782e89slam9r76po8 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.681.00.01'
20240611@133207.4230 ieoc804sb782e89slam9r76po8 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.675.00.01'
20240611@133207.4331 ieoc804sb782e89slam9r76po8 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.675.00.01'
20240611@133207.4340 ieoc804sb782e89slam9r76po8 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.649.00.01'
20240611@133207.4439 ieoc804sb782e89slam9r76po8 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.649.00.01'
20240611@133207.4449 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.4451 ieoc804sb782e89slam9r76po8 Query : select top 1 1 valor from ts where ts.ndos = 5
20240611@133207.4468 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.4470 ieoc804sb782e89slam9r76po8 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')
20240611@133207.4509 ieoc804sb782e89slam9r76po8 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
20240611@133207.4528 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.4531 ieoc804sb782e89slam9r76po8 Query : select top 1 ~inactivo valor from fl where no = '100500' and estab = 0 order by inactivo desc
20240611@133207.4546 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.4549 ieoc804sb782e89slam9r76po8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240611@133207.4567 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.4570 ieoc804sb782e89slam9r76po8 Query : select szadrsstamp valor from szadrs where szadrsdesc='n/instalaÇÕes sede'
20240611@133207.4585 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.4588 ieoc804sb782e89slam9r76po8 Query : select 1 valor from ts where ndos = 5
20240611@133207.4604 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.5742 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20240611@133207.5781 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.5795 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20240611@133207.5801 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.5813 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20240611@133207.5818 ieoc804sb782e89slam9r76po8 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
20240611@133207.5835 ieoc804sb782e89slam9r76po8 Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240611@133207.5933 ieoc804sb782e89slam9r76po8 Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20240611@133207.5975 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.5978 ieoc804sb782e89slam9r76po8 Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100500' and estab=0
20240611@133207.5996 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.6010 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20240611@133207.6022 ieoc804sb782e89slam9r76po8 Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6668474300666843c791',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240611@133207.6036 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.6050 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20240611@133207.6056 ieoc804sb782e89slam9r76po8 Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut6668474300666843c791','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20240611','14:02',?,?)
20240611@133207.6434 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.6449 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20240611@133207.6460 ieoc804sb782e89slam9r76po8 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 ('aut6668474300666843c791','trf entre armazéns a','2024-06-11',5,313,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
20240611@133207.7024 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.7028 ieoc804sb782e89slam9r76po8 Query : select st.usalote valor from st where st.ref = '324.681.00.01'
20240611@133207.7045 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.7048 ieoc804sb782e89slam9r76po8 Query : select st.stns valor from st where st.ref = '324.681.00.01'
20240611@133207.7066 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.7068 ieoc804sb782e89slam9r76po8 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.681.00.01' and sa.armazem = 133 
20240611@133207.7133 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.7136 ieoc804sb782e89slam9r76po8 Query : select st.stns valor from st where st.ref = '324.681.00.01'
20240611@133207.7153 ieoc804sb782e89slam9r76po8 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.681.00.01'
20240611@133207.7327 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.7342 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@133207.7353 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.7365 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@133207.7371 ieoc804sb782e89slam9r76po8 Query : select sestamp valor from se where ref ='324.681.00.01' and lote = 'r2400057200a'
20240611@133207.7388 ieoc804sb782e89slam9r76po8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240611@133207.7403 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.7416 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20240611@133207.7422 ieoc804sb782e89slam9r76po8 Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut6668432296666843c7b4','aut6668474300666843c791',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 = 'aut6668474300666843c791'
20240611@133207.7672 ieoc804sb782e89slam9r76po8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240611@133207.7686 ieoc804sb782e89slam9r76po8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20240611@133207.7697 ieoc804sb782e89slam9r76po8 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,eslvu,slvu,esltt,sltt,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,stipo) select 'aut6668432296666843c7b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 10.000, 10.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 ,0,0*200.48,0,0*200.48 ,0,0,'un ','' ,bo.marcada,1 ,0*10.000,0*10.000*200.48 ,20.243000,20.243000*200.48 ,20.243000,20.243000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0*200.48,0*10.000,0*10.000*200.48,0,0*10.000,0,0*10.000,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut6668474300666843c791'
20240611@133207.8053 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8058 ieoc804sb782e89slam9r76po8 Query : select st.usalote valor from st where st.ref = '324.675.00.01'
20240611@133207.8070 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8073 ieoc804sb782e89slam9r76po8 Query : select st.stns valor from st where st.ref = '324.675.00.01'
20240611@133207.8083 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8086 ieoc804sb782e89slam9r76po8 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.675.00.01' and sa.armazem = 133 
20240611@133207.8154 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8157 ieoc804sb782e89slam9r76po8 Query : select st.stns valor from st where st.ref = '324.675.00.01'
20240611@133207.8169 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8173 ieoc804sb782e89slam9r76po8 Query : select st.usalote valor from st where st.ref = '324.675.00.01'
20240611@133207.8183 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8185 ieoc804sb782e89slam9r76po8 Query : select st.usalote valor from st where st.ref = '324.649.00.01'
20240611@133207.8196 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8199 ieoc804sb782e89slam9r76po8 Query : select st.usalote valor from st where st.ref = '324.649.00.01'
20240611@133207.8214 ieoc804sb782e89slam9r76po8 Query : use flama_phc
20240611@133207.8217 ieoc804sb782e89slam9r76po8 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -1050
20240611@133207.8249 ieoc804sb782e89slam9r76po8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='323';
20240611@133207.8262 ieoc804sb782e89slam9r76po8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='323';
20240611@133621.7578 5dm424j5o3pvbkvbbq69gtmia6 Query : use flama_phc
20240611@133621.7586 5dm424j5o3pvbkvbbq69gtmia6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@133621.7664 5dm424j5o3pvbkvbbq69gtmia6 Query : use flama_phc
20240611@133621.7667 5dm424j5o3pvbkvbbq69gtmia6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@141914.4588 2f0cgardd7hj9ng542mvl3hipb Query : use flama_phc
20240611@141914.4605 2f0cgardd7hj9ng542mvl3hipb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@141914.4632 2f0cgardd7hj9ng542mvl3hipb Query : use flama_phc
20240611@141914.4636 2f0cgardd7hj9ng542mvl3hipb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@143614.6887 u5li528n72qgg6a5t52ed8d76u Query : use flama_phc
20240611@143614.6896 u5li528n72qgg6a5t52ed8d76u Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@143614.6923 u5li528n72qgg6a5t52ed8d76u Query : use flama_phc
20240611@143614.6926 u5li528n72qgg6a5t52ed8d76u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@151914.2759 nptn1gbrk9s0hggjblg716gulb Query : use flama_phc
20240611@151914.2764 nptn1gbrk9s0hggjblg716gulb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@151914.2813 nptn1gbrk9s0hggjblg716gulb Query : use flama_phc
20240611@151914.2816 nptn1gbrk9s0hggjblg716gulb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@153614.3853 g0btvdotb295hmb8dlb5c4geo6 Query : use flama_phc
20240611@153614.3887 g0btvdotb295hmb8dlb5c4geo6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@153614.4178 g0btvdotb295hmb8dlb5c4geo6 Query : use flama_phc
20240611@153614.4268 g0btvdotb295hmb8dlb5c4geo6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@161608.9083 sh8skt6qqrrfe4rl2pruch1kh7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240611@161608.9105 sh8skt6qqrrfe4rl2pruch1kh7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240611@161608.9146 sh8skt6qqrrfe4rl2pruch1kh7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='324';
20240611@161608.9204 sh8skt6qqrrfe4rl2pruch1kh7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='324';
20240611@161608.9216 sh8skt6qqrrfe4rl2pruch1kh7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='324';
20240611@161608.9228 sh8skt6qqrrfe4rl2pruch1kh7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='324';
20240611@161608.9240 sh8skt6qqrrfe4rl2pruch1kh7 Query : use flama_phc
20240611@161608.9243 sh8skt6qqrrfe4rl2pruch1kh7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240611@161608.9310 sh8skt6qqrrfe4rl2pruch1kh7 Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '304.4006.00.2'
20240611@161608.9423 sh8skt6qqrrfe4rl2pruch1kh7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =005 and bo.boano =2024 and bo.obrano = 0000312 and bi.ref ='304.4006.00.2' and bi.lordem =10000
20240611@161608.9809 sh8skt6qqrrfe4rl2pruch1kh7 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 = 'adm24061154434,635000001 ' 
20240611@161609.1700 sh8skt6qqrrfe4rl2pruch1kh7 Query : use flama_phc
20240611@161609.1740 sh8skt6qqrrfe4rl2pruch1kh7 Query : select top 1 1 valor from ts where ts.ndos = 61
20240611@161609.2700 sh8skt6qqrrfe4rl2pruch1kh7 Query : use flama_phc
20240611@161609.2730 sh8skt6qqrrfe4rl2pruch1kh7 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')
20240611@161609.3360 sh8skt6qqrrfe4rl2pruch1kh7 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 =61
20240611@161609.5140 sh8skt6qqrrfe4rl2pruch1kh7 Query : use flama_phc
20240611@161609.5180 sh8skt6qqrrfe4rl2pruch1kh7 Query : select top 1 ~inactivo valor from fl where no = '2' and estab = 2 order by inactivo desc
20240611@161609.5960 sh8skt6qqrrfe4rl2pruch1kh7 Query : use flama_phc
20240611@161609.6190 sh8skt6qqrrfe4rl2pruch1kh7 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -230
20240611@161609.8140 sh8skt6qqrrfe4rl2pruch1kh7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='324';
20240611@161609.8270 sh8skt6qqrrfe4rl2pruch1kh7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='324';
20240611@161917.7150 fkbjijrmf7if3al6uhlv9uljd6 Query : use flama_phc
20240611@161917.7210 fkbjijrmf7if3al6uhlv9uljd6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@161917.7380 fkbjijrmf7if3al6uhlv9uljd6 Query : use flama_phc
20240611@161917.7410 fkbjijrmf7if3al6uhlv9uljd6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@163617.4925 3o9eqa8lt7d84nma0lh1c4e9a7 Query : use flama_phc
20240611@163617.4930 3o9eqa8lt7d84nma0lh1c4e9a7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@163617.4948 3o9eqa8lt7d84nma0lh1c4e9a7 Query : use flama_phc
20240611@163617.4950 3o9eqa8lt7d84nma0lh1c4e9a7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@171913.8713 4mpktbojjs72o04l9pci9422u6 Query : use flama_phc
20240611@171913.8718 4mpktbojjs72o04l9pci9422u6 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240611@171913.8787 4mpktbojjs72o04l9pci9422u6 Query : use flama_phc
20240611@171913.8791 4mpktbojjs72o04l9pci9422u6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240611@173613.8614 ji231halgbvn4tabpmgtj6cuas Query : use flama_phc
20240611@173613.8624 ji231halgbvn4tabpmgtj6cuas Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
