20241104@174353.5237 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.5245 aaqf004oo3ogkcgdg96381229m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174353.5256 aaqf004oo3ogkcgdg96381229m Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241104@174353.5269 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.5283 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.5295 aaqf004oo3ogkcgdg96381229m Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729026379672907d980','aut6729067581672907d8d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174353.5299 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.5313 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174353.5341 aaqf004oo3ogkcgdg96381229m Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729026379672907d980',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6729067581672907d8d4' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241104@174353.6891 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.6909 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174353.6935 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.6949 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.6959 aaqf004oo3ogkcgdg96381229m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174353.6972 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.6985 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.6998 aaqf004oo3ogkcgdg96381229m Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729038376672907d9aa','aut6729067581672907d8d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174353.7003 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7019 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174353.7050 aaqf004oo3ogkcgdg96381229m Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729038376672907d9aa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729067581672907d8d4' ,0,0 ,2,23.00,170000,?,?,?)
20241104@174353.7323 aaqf004oo3ogkcgdg96381229m Query : use flama_phc
20241104@174353.7326 aaqf004oo3ogkcgdg96381229m Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241104@174353.7344 aaqf004oo3ogkcgdg96381229m 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.1847.00.1'
20241104@174353.7358 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7375 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174353.7399 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7413 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.7422 aaqf004oo3ogkcgdg96381229m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174353.7433 aaqf004oo3ogkcgdg96381229m Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241104@174353.7444 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7459 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.7470 aaqf004oo3ogkcgdg96381229m Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729082024672907d9b5','aut6729067581672907d8d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174353.7474 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7487 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174353.7516 aaqf004oo3ogkcgdg96381229m Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729082024672907d9b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6729067581672907d8d4' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241104@174353.7791 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7807 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174353.7831 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7845 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.7853 aaqf004oo3ogkcgdg96381229m Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174353.7864 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7879 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174353.7890 aaqf004oo3ogkcgdg96381229m Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729074628672907d9c0','aut6729067581672907d8d4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174353.7894 aaqf004oo3ogkcgdg96381229m Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174353.7908 aaqf004oo3ogkcgdg96381229m Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174353.7936 aaqf004oo3ogkcgdg96381229m Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729074628672907d9c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729067581672907d8d4' ,0,0 ,2,23.00,200000,?,?,?)
20241104@174353.8192 aaqf004oo3ogkcgdg96381229m Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6729067581672907d8d4','2407161','wait',39,'adm09112754980.682000002')
20241104@174353.8263 aaqf004oo3ogkcgdg96381229m Query : use flama_phc
20241104@174353.8266 aaqf004oo3ogkcgdg96381229m Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174353.8294 aaqf004oo3ogkcgdg96381229m Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3029';
20241104@174353.8330 aaqf004oo3ogkcgdg96381229m Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3029';
20241104@174353.8375 aaqf004oo3ogkcgdg96381229m Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3029';
20241104@174353.8402 aaqf004oo3ogkcgdg96381229m Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3029';
20241104@174353.9693 d19si4i8189mnhj26rrnds7ocm Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174353.9704 d19si4i8189mnhj26rrnds7ocm Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174353.9765 d19si4i8189mnhj26rrnds7ocm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3030';
20241104@174353.9827 d19si4i8189mnhj26rrnds7ocm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3030';
20241104@174353.9886 d19si4i8189mnhj26rrnds7ocm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3030';
20241104@174353.9914 d19si4i8189mnhj26rrnds7ocm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3030';
20241104@174353.9963 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174353.9966 d19si4i8189mnhj26rrnds7ocm Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174354.2600 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.2900 d19si4i8189mnhj26rrnds7ocm Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174354.7200 d19si4i8189mnhj26rrnds7ocm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20241104@174354.2480 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407162 and bi.ref ='324.2221.00.1' and bi.lordem =1
20241104@174354.5800 d19si4i8189mnhj26rrnds7ocm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20241104@174354.6000 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407162 and bi.ref ='324.2221.00.1' and bi.lordem =1
20241104@174354.6360 d19si4i8189mnhj26rrnds7ocm Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20241104@174354.8840 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407162 and bi.ref ='324.2221.00.1' and bi.lordem =1
20241104@174354.9020 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.9060 d19si4i8189mnhj26rrnds7ocm Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174354.9380 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.9410 d19si4i8189mnhj26rrnds7ocm Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174354.9700 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.9730 d19si4i8189mnhj26rrnds7ocm 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')
20241104@174354.1000 d19si4i8189mnhj26rrnds7ocm Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241104@174354.1034 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.1037 d19si4i8189mnhj26rrnds7ocm Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174354.1064 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.1068 d19si4i8189mnhj26rrnds7ocm Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174354.1098 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.1102 d19si4i8189mnhj26rrnds7ocm Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174354.1141 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.1144 d19si4i8189mnhj26rrnds7ocm Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241104@174354.1187 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.1190 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from td where ndoc = 39
20241104@174354.1202 d19si4i8189mnhj26rrnds7ocm Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174354.1216 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.1233 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174354.1252 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.1268 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174354.1295 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.1308 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174354.1321 d19si4i8189mnhj26rrnds7ocm Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174354.1383 d19si4i8189mnhj26rrnds7ocm Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174354.1396 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.1413 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174354.1428 d19si4i8189mnhj26rrnds7ocm Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6729070731672907da20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174354.1621 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.1637 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174354.1668 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174354.1681 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174354.1693 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174354.1705 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174354.1717 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174354.1729 d19si4i8189mnhj26rrnds7ocm Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174354.1740 d19si4i8189mnhj26rrnds7ocm Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6729070731672907da20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174354.1991 d19si4i8189mnhj26rrnds7ocm Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174354.2018 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.2035 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174354.2068 d19si4i8189mnhj26rrnds7ocm Query : select 'normal' from dummy
20241104@174354.2083 d19si4i8189mnhj26rrnds7ocm Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6729070731672907da20',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1603,100810,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174354.2402 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.2405 d19si4i8189mnhj26rrnds7ocm Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20241104@174354.2427 d19si4i8189mnhj26rrnds7ocm 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'
20241104@174354.2576 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.2593 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.2621 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.2636 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.2644 d19si4i8189mnhj26rrnds7ocm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174354.2655 d19si4i8189mnhj26rrnds7ocm Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20241104@174354.2669 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.2683 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.2695 d19si4i8189mnhj26rrnds7ocm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729063346672907da41','aut6729070731672907da20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174354.2699 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.2713 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.2741 d19si4i8189mnhj26rrnds7ocm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729063346672907da41',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut6729070731672907da20' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174354.3020 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.3023 d19si4i8189mnhj26rrnds7ocm Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20241104@174354.3043 d19si4i8189mnhj26rrnds7ocm 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'
20241104@174354.3056 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3072 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.3097 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3112 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.3120 d19si4i8189mnhj26rrnds7ocm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174354.3132 d19si4i8189mnhj26rrnds7ocm Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20241104@174354.3144 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3158 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.3170 d19si4i8189mnhj26rrnds7ocm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729079003672907da4c','aut6729070731672907da20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174354.3175 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3189 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.3219 d19si4i8189mnhj26rrnds7ocm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729079003672907da4c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut6729070731672907da20' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241104@174354.3495 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.3498 d19si4i8189mnhj26rrnds7ocm Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20241104@174354.3517 d19si4i8189mnhj26rrnds7ocm 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'
20241104@174354.3531 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3546 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.3571 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3585 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.3593 d19si4i8189mnhj26rrnds7ocm Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174354.3607 d19si4i8189mnhj26rrnds7ocm Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20241104@174354.3620 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3634 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.3646 d19si4i8189mnhj26rrnds7ocm Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729001800672907da58','aut6729070731672907da20' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174354.3650 d19si4i8189mnhj26rrnds7ocm Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.3665 d19si4i8189mnhj26rrnds7ocm Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.3692 d19si4i8189mnhj26rrnds7ocm Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729001800672907da58',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut6729070731672907da20' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241104@174354.3948 d19si4i8189mnhj26rrnds7ocm Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6729070731672907da20','2407162','wait',39,'adm09112754980.682000002')
20241104@174354.4015 d19si4i8189mnhj26rrnds7ocm Query : use flama_phc
20241104@174354.4018 d19si4i8189mnhj26rrnds7ocm Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174354.4048 d19si4i8189mnhj26rrnds7ocm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3030';
20241104@174354.4084 d19si4i8189mnhj26rrnds7ocm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3030';
20241104@174354.4128 d19si4i8189mnhj26rrnds7ocm Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3030';
20241104@174354.4154 d19si4i8189mnhj26rrnds7ocm Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3030';
20241104@174354.4614 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174354.4625 1qn9ogjqbfsjvlo8lku7tq26mb Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174354.4684 1qn9ogjqbfsjvlo8lku7tq26mb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3031';
20241104@174354.4742 1qn9ogjqbfsjvlo8lku7tq26mb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3031';
20241104@174354.4798 1qn9ogjqbfsjvlo8lku7tq26mb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3031';
20241104@174354.4827 1qn9ogjqbfsjvlo8lku7tq26mb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3031';
20241104@174354.4882 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.4886 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174354.4945 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.4948 1qn9ogjqbfsjvlo8lku7tq26mb Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174354.4991 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20241104@174354.5163 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407163 and bi.ref ='324.2222.00.1' and bi.lordem =1
20241104@174354.5495 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20241104@174354.5514 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407163 and bi.ref ='324.2222.00.1' and bi.lordem =1
20241104@174354.5531 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5534 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174354.5564 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5567 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174354.5595 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5598 1qn9ogjqbfsjvlo8lku7tq26mb 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')
20241104@174354.5625 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241104@174354.5660 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5662 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174354.5691 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5694 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174354.5723 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5726 1qn9ogjqbfsjvlo8lku7tq26mb Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174354.5764 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5766 1qn9ogjqbfsjvlo8lku7tq26mb Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241104@174354.5808 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.5811 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from td where ndoc = 39
20241104@174354.5823 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174354.5836 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.5852 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174354.5871 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.5885 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174354.5914 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.5930 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174354.5943 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174354.6010 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174354.6023 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.6038 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174354.6053 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6729017127672907da91' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174354.6247 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.6264 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174354.6297 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174354.6309 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174354.6321 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174354.6333 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174354.6345 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174354.6356 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174354.6367 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6729017127672907da91',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174354.6659 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174354.6685 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.6701 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174354.6724 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 'normal' from dummy
20241104@174354.6740 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6729017127672907da91',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1604,100810,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174354.7060 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.7064 1qn9ogjqbfsjvlo8lku7tq26mb Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20241104@174354.7087 1qn9ogjqbfsjvlo8lku7tq26mb 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'
20241104@174354.7249 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7265 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.7290 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7304 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.7313 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174354.7326 1qn9ogjqbfsjvlo8lku7tq26mb Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301281400a'
20241104@174354.7346 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7361 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.7373 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729086171672907dab3','aut6729017127672907da91' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174354.7377 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7391 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.7418 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729086171672907dab3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',56.000 ,'aut6729017127672907da91' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174354.7704 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.7708 1qn9ogjqbfsjvlo8lku7tq26mb Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20241104@174354.7729 1qn9ogjqbfsjvlo8lku7tq26mb 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'
20241104@174354.7743 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7759 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.7788 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7803 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.7811 1qn9ogjqbfsjvlo8lku7tq26mb Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174354.7825 1qn9ogjqbfsjvlo8lku7tq26mb Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301281400a'
20241104@174354.7838 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7852 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174354.7865 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729002150672907dabf','aut6729017127672907da91' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174354.7870 1qn9ogjqbfsjvlo8lku7tq26mb Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174354.7885 1qn9ogjqbfsjvlo8lku7tq26mb Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174354.7912 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729002150672907dabf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut6729017127672907da91' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241104@174354.8191 1qn9ogjqbfsjvlo8lku7tq26mb Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6729017127672907da91','2407163','wait',39,'adm09112754980.682000002')
20241104@174354.8261 1qn9ogjqbfsjvlo8lku7tq26mb Query : use flama_phc
20241104@174354.8264 1qn9ogjqbfsjvlo8lku7tq26mb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174354.8294 1qn9ogjqbfsjvlo8lku7tq26mb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3031';
20241104@174354.8330 1qn9ogjqbfsjvlo8lku7tq26mb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3031';
20241104@174354.8375 1qn9ogjqbfsjvlo8lku7tq26mb Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3031';
20241104@174354.8402 1qn9ogjqbfsjvlo8lku7tq26mb Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3031';
20241104@174354.8892 avkv179nkjeinseuugifo0dat9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174354.8903 avkv179nkjeinseuugifo0dat9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174354.8965 avkv179nkjeinseuugifo0dat9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3032';
20241104@174354.9029 avkv179nkjeinseuugifo0dat9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3032';
20241104@174354.9087 avkv179nkjeinseuugifo0dat9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3032';
20241104@174354.9116 avkv179nkjeinseuugifo0dat9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3032';
20241104@174354.9167 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174354.9170 avkv179nkjeinseuugifo0dat9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174354.9236 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174354.9240 avkv179nkjeinseuugifo0dat9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174354.9286 avkv179nkjeinseuugifo0dat9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20241104@174354.9460 avkv179nkjeinseuugifo0dat9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407164 and bi.ref ='324.2224.00.1' and bi.lordem =1
20241104@174354.9813 avkv179nkjeinseuugifo0dat9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20241104@174354.9834 avkv179nkjeinseuugifo0dat9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407164 and bi.ref ='324.2224.00.1' and bi.lordem =1
20241104@174354.9850 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174354.9854 avkv179nkjeinseuugifo0dat9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174354.9886 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174354.9889 avkv179nkjeinseuugifo0dat9 Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174354.9920 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174354.9923 avkv179nkjeinseuugifo0dat9 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')
20241104@174354.9951 avkv179nkjeinseuugifo0dat9 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241104@174354.9985 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174354.9988 avkv179nkjeinseuugifo0dat9 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174355.2000 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174355.2300 avkv179nkjeinseuugifo0dat9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174355.5200 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174355.5500 avkv179nkjeinseuugifo0dat9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174355.9500 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174355.9800 avkv179nkjeinseuugifo0dat9 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241104@174355.1450 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174355.1480 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from td where ndoc = 39
20241104@174355.1600 avkv179nkjeinseuugifo0dat9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174355.2030 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.2210 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174355.2410 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.2560 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174355.2860 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.3000 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174355.3130 avkv179nkjeinseuugifo0dat9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174355.3780 avkv179nkjeinseuugifo0dat9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174355.3920 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.4080 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174355.4240 avkv179nkjeinseuugifo0dat9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6729093489672907db07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174355.8970 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.1150 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174355.1868 avkv179nkjeinseuugifo0dat9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174355.2081 avkv179nkjeinseuugifo0dat9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174355.2288 avkv179nkjeinseuugifo0dat9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174355.2494 avkv179nkjeinseuugifo0dat9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174355.2705 avkv179nkjeinseuugifo0dat9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174355.3690 avkv179nkjeinseuugifo0dat9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174355.3982 avkv179nkjeinseuugifo0dat9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6729093489672907db07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174355.4444 avkv179nkjeinseuugifo0dat9 Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174355.4475 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.4491 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174355.4513 avkv179nkjeinseuugifo0dat9 Query : select 'normal' from dummy
20241104@174355.4528 avkv179nkjeinseuugifo0dat9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6729093489672907db07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1605,100810,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174355.4858 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174355.4861 avkv179nkjeinseuugifo0dat9 Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20241104@174355.4883 avkv179nkjeinseuugifo0dat9 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.2224.00.1'
20241104@174355.5044 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5061 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174355.5086 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5101 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174355.5109 avkv179nkjeinseuugifo0dat9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174355.5120 avkv179nkjeinseuugifo0dat9 Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20241104@174355.5133 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5147 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174355.5158 avkv179nkjeinseuugifo0dat9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729079142672907db7d','aut6729093489672907db07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174355.5162 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5178 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174355.5207 avkv179nkjeinseuugifo0dat9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729079142672907db7d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6729093489672907db07' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174355.5487 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174355.5490 avkv179nkjeinseuugifo0dat9 Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20241104@174355.5509 avkv179nkjeinseuugifo0dat9 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.2224.00.1'
20241104@174355.5523 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5539 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174355.5564 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5579 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174355.5587 avkv179nkjeinseuugifo0dat9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174355.5599 avkv179nkjeinseuugifo0dat9 Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20241104@174355.5612 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5627 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174355.5639 avkv179nkjeinseuugifo0dat9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729088252672907db89','aut6729093489672907db07' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174355.5643 avkv179nkjeinseuugifo0dat9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174355.5657 avkv179nkjeinseuugifo0dat9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174355.5685 avkv179nkjeinseuugifo0dat9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729088252672907db89',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',96.000 ,'aut6729093489672907db07' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241104@174355.5967 avkv179nkjeinseuugifo0dat9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6729093489672907db07','2407164','wait',39,'adm09112754980.682000002')
20241104@174355.6036 avkv179nkjeinseuugifo0dat9 Query : use flama_phc
20241104@174355.6039 avkv179nkjeinseuugifo0dat9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174355.6068 avkv179nkjeinseuugifo0dat9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3032';
20241104@174355.6104 avkv179nkjeinseuugifo0dat9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3032';
20241104@174355.6150 avkv179nkjeinseuugifo0dat9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3032';
20241104@174355.6180 avkv179nkjeinseuugifo0dat9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3032';
20241104@174355.7331 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174355.7414 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174355.8035 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3033';
20241104@174355.8411 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3033';
20241104@174355.8765 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3033';
20241104@174355.9070 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3033';
20241104@174355.9419 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174355.9461 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174356.2060 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.2470 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174356.5610 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241104@174356.2293 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407165 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241104@174356.3009 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241104@174356.3297 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407165 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241104@174356.3505 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241104@174356.3568 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407165 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241104@174356.3586 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241104@174356.4211 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407165 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241104@174356.4418 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20241104@174356.4707 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407165 and bi.ref ='324.1831.00.2' and bi.lordem =1
20241104@174356.4915 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.4957 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174356.5329 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.5371 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174356.5740 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.5781 nvkp7ubh4f7pp7ko7rfhjk72s2 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')
20241104@174356.6235 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241104@174356.6688 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.6729 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174356.8388 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.8430 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174356.8807 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.8849 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174356.9301 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.9342 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241104@174356.9877 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174356.9919 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from td where ndoc = 39
20241104@174357.1660 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174357.4530 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174357.9050 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174357.1317 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174357.1569 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174357.2228 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174357.2479 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174357.2731 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174357.3077 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174357.3325 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174357.3584 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174357.3872 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174357.4273 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174357.4525 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174357.6162 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174357.6674 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174357.6881 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174357.7088 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174357.7295 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174357.7502 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174357.7709 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6729039110672907dd42',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174357.8325 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174357.8744 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174357.8996 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174357.9448 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 'normal' from dummy
20241104@174358.9960 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6729039110672907dd42',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1606,100810,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174358.1800 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174358.1842 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241104@174358.2174 nvkp7ubh4f7pp7ko7rfhjk72s2 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.1831.00.2'
20241104@174358.2692 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.2943 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174358.3520 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.3773 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174358.3938 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174358.4187 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20241104@174358.4436 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.4688 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174358.5059 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729071370672907de6c','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174358.5186 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.6272 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174358.6890 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729071370672907de6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174358.7580 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.7831 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174358.8407 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.8659 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174358.8975 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174358.9222 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.9473 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174358.9547 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729072117672907dee1','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174358.9552 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174358.9569 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174358.9643 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729072117672907dee1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,20000,?,?,?)
20241104@174359.2360 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174359.2780 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241104@174359.6120 nvkp7ubh4f7pp7ko7rfhjk72s2 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.1831.00.2'
20241104@174359.1028 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.1279 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174359.1855 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.2107 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174359.2271 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174359.2519 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20241104@174359.2767 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.3019 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174359.3225 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729057362672907df43','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174359.3269 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.3521 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174359.4140 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729057362672907df43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241104@174359.4821 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.6333 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174359.6910 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.7162 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174359.7329 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174359.7577 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.7829 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174359.8035 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729029474672907dfb8','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174359.8078 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174359.8330 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174359.8948 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729029474672907dfb8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,50000,?,?,?)
20241104@174359.9777 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174359.9819 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241104@174400.1520 nvkp7ubh4f7pp7ko7rfhjk72s2 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.1831.00.2'
20241104@174400.4010 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.6570 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.1359 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.1612 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.1778 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174400.2030 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20241104@174400.2280 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.2306 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.2324 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729027061672907e037','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174400.2329 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.2349 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.2387 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729027061672907e037',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241104@174400.3890 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.3907 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.3932 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.3946 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.3953 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174400.3968 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.3986 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.3996 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729058455672907e060','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174400.4000 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.4015 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.4040 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729058455672907e060',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,80000,?,?,?)
20241104@174400.4557 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174400.4561 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241104@174400.4581 nvkp7ubh4f7pp7ko7rfhjk72s2 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.1831.00.2'
20241104@174400.4594 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.4610 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.4635 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.4648 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.4656 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174400.4668 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20241104@174400.4680 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.4694 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.4705 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729037038672907e072','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174400.4709 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.4723 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.4749 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729037038672907e072',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241104@174400.5038 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5053 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.5077 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5091 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.5099 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174400.5111 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5126 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.5138 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729064202672907e07c','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174400.5142 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5156 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.5184 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729064202672907e07c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,110000,?,?,?)
20241104@174400.5449 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174400.5452 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20241104@174400.5471 nvkp7ubh4f7pp7ko7rfhjk72s2 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.1831.00.2'
20241104@174400.5484 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5499 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.5524 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5538 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.5546 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174400.5558 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2400481200a'
20241104@174400.5570 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5584 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.5595 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729045651672907e087','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174400.5600 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5614 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.5642 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729045651672907e087',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241104@174400.5914 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5930 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.5954 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.5970 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.5978 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174400.5990 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.6004 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174400.6016 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729005651672907e092','aut6729039110672907dd42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174400.6021 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174400.6035 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174400.6063 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729005651672907e092',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729039110672907dd42' ,0,0 ,2,23.00,140000,?,?,?)
20241104@174400.6527 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6729039110672907dd42','2407165','wait',39,'adm09112754980.682000002')
20241104@174400.6608 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : use flama_phc
20241104@174400.6612 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174400.6642 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3033';
20241104@174400.6678 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3033';
20241104@174400.6722 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3033';
20241104@174400.6748 nvkp7ubh4f7pp7ko7rfhjk72s2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3033';
20241104@174400.7904 3dl7367a877iesrptjll0pibpu Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174400.7987 3dl7367a877iesrptjll0pibpu Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174400.8461 3dl7367a877iesrptjll0pibpu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3034';
20241104@174400.8846 3dl7367a877iesrptjll0pibpu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3034';
20241104@174400.9196 3dl7367a877iesrptjll0pibpu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3034';
20241104@174400.9507 3dl7367a877iesrptjll0pibpu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3034';
20241104@174400.9969 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.1100 3dl7367a877iesrptjll0pibpu Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174401.6320 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.6720 3dl7367a877iesrptjll0pibpu Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174401.1072 3dl7367a877iesrptjll0pibpu 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'
20241104@174401.1594 3dl7367a877iesrptjll0pibpu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407166 and bi.ref ='324.1889.00.1' and bi.lordem =1
20241104@174401.2429 3dl7367a877iesrptjll0pibpu 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'
20241104@174401.2718 3dl7367a877iesrptjll0pibpu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407166 and bi.ref ='324.1889.00.1' and bi.lordem =1
20241104@174401.2925 3dl7367a877iesrptjll0pibpu 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'
20241104@174401.3213 3dl7367a877iesrptjll0pibpu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407166 and bi.ref ='324.1889.00.1' and bi.lordem =1
20241104@174401.3420 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.3461 3dl7367a877iesrptjll0pibpu Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174401.3834 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.3876 3dl7367a877iesrptjll0pibpu Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174401.4248 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.4289 3dl7367a877iesrptjll0pibpu 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')
20241104@174401.4743 3dl7367a877iesrptjll0pibpu Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241104@174401.5195 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.5237 3dl7367a877iesrptjll0pibpu Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174401.5611 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.5653 3dl7367a877iesrptjll0pibpu Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174401.6033 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.6075 3dl7367a877iesrptjll0pibpu Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174401.6534 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.6576 3dl7367a877iesrptjll0pibpu Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241104@174401.7113 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174401.7156 3dl7367a877iesrptjll0pibpu Query : select 1 valor from td where ndoc = 39
20241104@174401.7405 3dl7367a877iesrptjll0pibpu Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174401.7696 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174401.9204 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174401.9790 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174402.1940 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174402.8560 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174402.1110 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174402.1358 3dl7367a877iesrptjll0pibpu Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174402.1697 3dl7367a877iesrptjll0pibpu Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174402.1945 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174402.2197 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174402.2486 3dl7367a877iesrptjll0pibpu Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6729046861672907e221' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174402.2929 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174402.3184 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174402.3886 3dl7367a877iesrptjll0pibpu Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174402.4093 3dl7367a877iesrptjll0pibpu Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174402.4302 3dl7367a877iesrptjll0pibpu Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174402.4508 3dl7367a877iesrptjll0pibpu Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174402.4715 3dl7367a877iesrptjll0pibpu Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174402.4921 3dl7367a877iesrptjll0pibpu Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174402.5129 3dl7367a877iesrptjll0pibpu Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6729046861672907e221',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174402.5883 3dl7367a877iesrptjll0pibpu Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174402.6279 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174402.6545 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174402.7091 3dl7367a877iesrptjll0pibpu Query : select 'normal' from dummy
20241104@174402.7383 3dl7367a877iesrptjll0pibpu Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6729046861672907e221',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1607,100810,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174402.8155 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174402.8196 3dl7367a877iesrptjll0pibpu Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20241104@174402.8527 3dl7367a877iesrptjll0pibpu 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.1889.00.1'
20241104@174403.1470 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.5550 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174403.1327 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.1580 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174403.1746 3dl7367a877iesrptjll0pibpu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174403.1994 3dl7367a877iesrptjll0pibpu Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20241104@174403.2243 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.2496 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174403.2703 3dl7367a877iesrptjll0pibpu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729070763672907e336','aut6729046861672907e221' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174403.2788 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.3083 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174403.3702 3dl7367a877iesrptjll0pibpu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729070763672907e336',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729046861672907e221' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174403.4426 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.4679 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174403.5255 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.5508 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174403.5718 3dl7367a877iesrptjll0pibpu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174403.6205 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.6696 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174403.6905 3dl7367a877iesrptjll0pibpu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729039290672907e397','aut6729046861672907e221' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174403.6948 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.7201 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174403.7818 3dl7367a877iesrptjll0pibpu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729039290672907e397',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729046861672907e221' ,0,0 ,2,23.00,20000,?,?,?)
20241104@174403.8483 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174403.8524 3dl7367a877iesrptjll0pibpu Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20241104@174403.8855 3dl7367a877iesrptjll0pibpu 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.1889.00.1'
20241104@174403.9105 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174403.9356 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174403.9933 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174404.1095 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174404.1499 3dl7367a877iesrptjll0pibpu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174404.1747 3dl7367a877iesrptjll0pibpu Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20241104@174404.1995 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174404.2248 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174404.2455 3dl7367a877iesrptjll0pibpu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729076878672907e430','aut6729046861672907e221' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174404.2499 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174404.3514 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174404.4364 3dl7367a877iesrptjll0pibpu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729076878672907e430',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729046861672907e221' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241104@174404.5382 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174404.5807 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174404.6383 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174404.6635 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174404.6799 3dl7367a877iesrptjll0pibpu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174404.7047 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174404.7299 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174404.7506 3dl7367a877iesrptjll0pibpu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729089967672907e4ac','aut6729046861672907e221' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174404.7549 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174404.7807 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174404.8434 3dl7367a877iesrptjll0pibpu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729089967672907e4ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729046861672907e221' ,0,0 ,2,23.00,50000,?,?,?)
20241104@174404.9041 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174404.9082 3dl7367a877iesrptjll0pibpu Query : select st.usalote valor from st where st.ref = '324.1889.00.1'
20241104@174404.9636 3dl7367a877iesrptjll0pibpu 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.1889.00.1'
20241104@174404.9885 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.1370 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174405.7150 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.1073 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174405.1238 3dl7367a877iesrptjll0pibpu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174405.1567 3dl7367a877iesrptjll0pibpu Query : select sestamp valor from se where ref ='324.1889.00.1' and lote = 'r2400289200a'
20241104@174405.1887 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.2140 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174405.2353 3dl7367a877iesrptjll0pibpu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729088029672907e52e','aut6729046861672907e221' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174405.2400 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.2649 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174405.3267 3dl7367a877iesrptjll0pibpu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729088029672907e52e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6729046861672907e221' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241104@174405.4019 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.4045 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174405.4089 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.4263 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174405.4429 3dl7367a877iesrptjll0pibpu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174405.4616 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.4635 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174405.4996 3dl7367a877iesrptjll0pibpu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729033923672907e570','aut6729046861672907e221' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174405.5039 3dl7367a877iesrptjll0pibpu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174405.6521 3dl7367a877iesrptjll0pibpu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174405.7138 3dl7367a877iesrptjll0pibpu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729033923672907e570',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6729046861672907e221' ,0,0 ,2,23.00,80000,?,?,?)
20241104@174405.7962 3dl7367a877iesrptjll0pibpu Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6729046861672907e221','2407166','wait',39,'adm09112754980.682000002')
20241104@174406.2500 3dl7367a877iesrptjll0pibpu Query : use flama_phc
20241104@174406.3170 3dl7367a877iesrptjll0pibpu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174406.5980 3dl7367a877iesrptjll0pibpu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3034';
20241104@174406.1106 3dl7367a877iesrptjll0pibpu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3034';
20241104@174406.1372 3dl7367a877iesrptjll0pibpu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3034';
20241104@174406.1675 3dl7367a877iesrptjll0pibpu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3034';
20241104@174406.3058 er366k60sg2lgfiiul9os0ee7b Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174406.3068 er366k60sg2lgfiiul9os0ee7b Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174406.3129 er366k60sg2lgfiiul9os0ee7b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3035';
20241104@174406.3189 er366k60sg2lgfiiul9os0ee7b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3035';
20241104@174406.3243 er366k60sg2lgfiiul9os0ee7b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3035';
20241104@174406.3270 er366k60sg2lgfiiul9os0ee7b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3035';
20241104@174406.3334 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.3338 er366k60sg2lgfiiul9os0ee7b Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174406.3407 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.3410 er366k60sg2lgfiiul9os0ee7b Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174406.3453 er366k60sg2lgfiiul9os0ee7b Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2907.00.1'
20241104@174406.3621 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407167 and bi.ref ='324.2907.00.1' and bi.lordem =1
20241104@174406.4248 er366k60sg2lgfiiul9os0ee7b Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2907.00.1'
20241104@174406.4269 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2071 and bo.obrano = 2407167 and bi.ref ='324.2907.00.1' and bi.lordem =1
20241104@174406.4287 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4290 er366k60sg2lgfiiul9os0ee7b Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174406.4321 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4324 er366k60sg2lgfiiul9os0ee7b Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174406.4354 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4358 er366k60sg2lgfiiul9os0ee7b 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')
20241104@174406.4384 er366k60sg2lgfiiul9os0ee7b Query : select top 1 manternumero ,assinadoc issigned ,tiposaft ,assinaimp ,nmdos ,td.assinadoc ,'cl' origin ,lancasl stocks ,case when cmsl<50 and td.lancasl=1 then 1 else 0 end entrada ,case when cmsl>50 and td.lancasl=1 then 1 else 0 end saida ,temserie assets ,~semgre usegridfields from td inner join td2 on td.tdstamp=td2.td2stamp where td.ndoc = 1
20241104@174406.4417 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4420 er366k60sg2lgfiiul9os0ee7b Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174406.4447 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4450 er366k60sg2lgfiiul9os0ee7b Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174406.4483 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4486 er366k60sg2lgfiiul9os0ee7b Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174406.4526 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4528 er366k60sg2lgfiiul9os0ee7b Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241104@174406.4570 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.4573 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from td where ndoc = 39
20241104@174406.4586 er366k60sg2lgfiiul9os0ee7b Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174406.4599 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174406.4617 er366k60sg2lgfiiul9os0ee7b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174406.4644 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174406.4666 er366k60sg2lgfiiul9os0ee7b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174406.4694 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174406.4708 er366k60sg2lgfiiul9os0ee7b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174406.4720 er366k60sg2lgfiiul9os0ee7b Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174406.4780 er366k60sg2lgfiiul9os0ee7b Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174406.4794 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174406.4808 er366k60sg2lgfiiul9os0ee7b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174406.4825 er366k60sg2lgfiiul9os0ee7b Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6729096614672907e673' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174406.5015 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174406.5033 er366k60sg2lgfiiul9os0ee7b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174406.5066 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174406.5079 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174406.5091 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174406.5103 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174406.5116 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174406.5128 er366k60sg2lgfiiul9os0ee7b Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174406.5141 er366k60sg2lgfiiul9os0ee7b Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6729096614672907e673',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174406.5428 er366k60sg2lgfiiul9os0ee7b Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174406.5454 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174406.5471 er366k60sg2lgfiiul9os0ee7b Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174406.5562 er366k60sg2lgfiiul9os0ee7b Query : select 'normal' from dummy
20241104@174406.5578 er366k60sg2lgfiiul9os0ee7b Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6729096614672907e673',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1608,100810,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174406.5892 er366k60sg2lgfiiul9os0ee7b Query : use flama_phc
20241104@174406.5895 er366k60sg2lgfiiul9os0ee7b Query : select st.usalote valor from st where st.ref = '324.2907.00.1'
20241104@174406.5922 er366k60sg2lgfiiul9os0ee7b 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.2907.00.1'
20241104@174406.6074 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174406.6090 er366k60sg2lgfiiul9os0ee7b Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174406.6115 er366k60sg2lgfiiul9os0ee7b Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
