20250107@142644.7620 vloh97n5jmnmr6e6l53253tptu Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250107@142644.7632 vloh97n5jmnmr6e6l53253tptu Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250107@142644.7644 vloh97n5jmnmr6e6l53253tptu Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250107@142644.7656 vloh97n5jmnmr6e6l53253tptu Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250107@142644.7667 vloh97n5jmnmr6e6l53253tptu Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677d369758677d39a4ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250107@142644.7929 vloh97n5jmnmr6e6l53253tptu Query : select top 1 fno valor from wsftdata order by fno desc
20250107@142644.7962 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142644.7978 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142644.8000 vloh97n5jmnmr6e6l53253tptu Query : select 'normal' from dummy
20250107@142644.8055 vloh97n5jmnmr6e6l53253tptu Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677d369758677d39a4ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2796,102439,0,'2025-01-07',39,'euro',0,0,2025 ,?,?)
20250107@142644.9520 vloh97n5jmnmr6e6l53253tptu Query : use flama_phc
20250107@142644.9523 vloh97n5jmnmr6e6l53253tptu Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20250107@142644.9545 vloh97n5jmnmr6e6l53253tptu 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.1824.00.1'
20250107@142644.9684 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142644.9700 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142644.9724 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142644.9740 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142644.9748 vloh97n5jmnmr6e6l53253tptu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142644.9760 vloh97n5jmnmr6e6l53253tptu Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400217200a'
20250107@142644.9776 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142644.9809 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142644.9821 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d322355677d39a4ee','aut677d369758677d39a4ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142644.9825 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142644.9839 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142644.9868 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d322355677d39a4ee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut677d369758677d39a4ae' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250107@142645.1270 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1450 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.1710 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1860 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.1960 vloh97n5jmnmr6e6l53253tptu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142645.2080 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.2250 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.2370 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d379768677d39a505','aut677d369758677d39a4ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142645.2420 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.2560 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.2850 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut677d379768677d39a505',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut677d369758677d39a4ae' ,0,0 ,2,23.00,20000,?,?,?)
20250107@142645.5420 vloh97n5jmnmr6e6l53253tptu Query : use flama_phc
20250107@142645.5440 vloh97n5jmnmr6e6l53253tptu Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20250107@142645.5630 vloh97n5jmnmr6e6l53253tptu 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.1824.00.1'
20250107@142645.5770 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.5920 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.6170 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.6310 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.6400 vloh97n5jmnmr6e6l53253tptu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142645.6520 vloh97n5jmnmr6e6l53253tptu Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400217200a'
20250107@142645.6640 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.6780 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.6900 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d377150677d39a510','aut677d369758677d39a4ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142645.6940 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.7090 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.7360 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d377150677d39a510',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut677d369758677d39a4ae' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20250107@142645.1169 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1378 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.1409 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1425 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.1433 vloh97n5jmnmr6e6l53253tptu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142645.1445 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1459 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.1470 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d374736677d39a523','aut677d369758677d39a4ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142645.1474 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1488 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.1514 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut677d374736677d39a523',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut677d369758677d39a4ae' ,0,0 ,2,23.00,50000,?,?,?)
20250107@142645.1754 vloh97n5jmnmr6e6l53253tptu Query : use flama_phc
20250107@142645.1757 vloh97n5jmnmr6e6l53253tptu Query : select st.usalote valor from st where st.ref = '322.227.28.01'
20250107@142645.1778 vloh97n5jmnmr6e6l53253tptu 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 = '322.227.28.01'
20250107@142645.1911 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1928 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.1954 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.1970 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.1979 vloh97n5jmnmr6e6l53253tptu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142645.1991 vloh97n5jmnmr6e6l53253tptu Query : select sestamp valor from se where ref ='322.227.28.01' and lote = 'r2200095100a'
20250107@142645.2005 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.2021 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.2032 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d363097677d39a530','aut677d369758677d39a4ae' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142645.2036 vloh97n5jmnmr6e6l53253tptu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.2051 vloh97n5jmnmr6e6l53253tptu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.2080 vloh97n5jmnmr6e6l53253tptu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d363097677d39a530',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut677d369758677d39a4ae' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20250107@142645.2331 vloh97n5jmnmr6e6l53253tptu Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677d369758677d39a4ae','2500116','wait',39,'adm09112754980.682000002')
20250107@142645.2594 vloh97n5jmnmr6e6l53253tptu Query : use flama_phc
20250107@142645.2617 vloh97n5jmnmr6e6l53253tptu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250107@142645.2649 vloh97n5jmnmr6e6l53253tptu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4354';
20250107@142645.2691 vloh97n5jmnmr6e6l53253tptu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4354';
20250107@142645.2746 vloh97n5jmnmr6e6l53253tptu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4354';
20250107@142645.2794 vloh97n5jmnmr6e6l53253tptu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4354';
20250107@142645.3389 7j3hkekgk9hobj6731huolc59q Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250107@142645.3401 7j3hkekgk9hobj6731huolc59q Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250107@142645.3475 7j3hkekgk9hobj6731huolc59q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4355';
20250107@142645.3541 7j3hkekgk9hobj6731huolc59q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4355';
20250107@142645.3605 7j3hkekgk9hobj6731huolc59q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4355';
20250107@142645.3639 7j3hkekgk9hobj6731huolc59q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4355';
20250107@142645.3701 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.3710 7j3hkekgk9hobj6731huolc59q Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250107@142645.3774 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.3777 7j3hkekgk9hobj6731huolc59q Query : select no, estab,szadrsdesc from szadrs where u_coddest=410
20250107@142645.3871 7j3hkekgk9hobj6731huolc59q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20250107@142645.4023 7j3hkekgk9hobj6731huolc59q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500117 and bi.ref ='324.2335.00.1' and bi.lordem =1
20250107@142645.4344 7j3hkekgk9hobj6731huolc59q Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20250107@142645.4368 7j3hkekgk9hobj6731huolc59q Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500117 and bi.ref ='324.2362.00.1' and bi.lordem =2
20250107@142645.4695 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.4698 7j3hkekgk9hobj6731huolc59q Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250107@142645.4750 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.4754 7j3hkekgk9hobj6731huolc59q Query : select top 1 1 valor from td where td.ndoc = 39
20250107@142645.4786 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.4788 7j3hkekgk9hobj6731huolc59q 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')
20250107@142645.4816 7j3hkekgk9hobj6731huolc59q 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
20250107@142645.4850 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.4853 7j3hkekgk9hobj6731huolc59q Query : select top 1 ~inactivo valor from cl where no = '102212' and estab = 0 order by inactivo desc
20250107@142645.4971 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.4975 7j3hkekgk9hobj6731huolc59q Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250107@142645.5004 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.5007 7j3hkekgk9hobj6731huolc59q Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250107@142645.5046 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.5049 7j3hkekgk9hobj6731huolc59q Query : select szadrsstamp valor from szadrs where szadrsdesc='tomarel-soc.tecnica electricidade, lda.'
20250107@142645.5093 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.5096 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from td where ndoc = 39
20250107@142645.5108 7j3hkekgk9hobj6731huolc59q Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250107@142645.5122 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.5140 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142645.5159 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.5173 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142645.5200 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.5215 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142645.5229 7j3hkekgk9hobj6731huolc59q Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142645.5338 7j3hkekgk9hobj6731huolc59q Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142645.5351 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.5369 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142645.5385 7j3hkekgk9hobj6731huolc59q Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677d365016677d39a57f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250107@142645.5555 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.5575 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142645.5608 7j3hkekgk9hobj6731huolc59q Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250107@142645.5621 7j3hkekgk9hobj6731huolc59q Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250107@142645.5632 7j3hkekgk9hobj6731huolc59q Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250107@142645.5644 7j3hkekgk9hobj6731huolc59q Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250107@142645.5655 7j3hkekgk9hobj6731huolc59q Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250107@142645.5667 7j3hkekgk9hobj6731huolc59q Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250107@142645.5678 7j3hkekgk9hobj6731huolc59q Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677d365016677d39a57f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250107@142645.5932 7j3hkekgk9hobj6731huolc59q Query : select top 1 fno valor from wsftdata order by fno desc
20250107@142645.5966 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.5984 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142645.6009 7j3hkekgk9hobj6731huolc59q Query : select 'normal' from dummy
20250107@142645.6028 7j3hkekgk9hobj6731huolc59q Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677d365016677d39a57f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2797,102212,0,'2025-01-07',39,'euro',0,0,2025 ,?,?)
20250107@142645.6329 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.6333 7j3hkekgk9hobj6731huolc59q Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20250107@142645.6358 7j3hkekgk9hobj6731huolc59q 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.2335.00.1'
20250107@142645.6518 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.6536 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.6562 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.6578 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.6587 7j3hkekgk9hobj6731huolc59q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142645.6600 7j3hkekgk9hobj6731huolc59q Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400468300a'
20250107@142645.6614 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.6630 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.6643 7j3hkekgk9hobj6731huolc59q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d347189677d39a5a1','aut677d365016677d39a57f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142645.6648 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.6663 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.6693 7j3hkekgk9hobj6731huolc59q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d347189677d39a5a1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut677d365016677d39a57f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250107@142645.6958 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.6963 7j3hkekgk9hobj6731huolc59q Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20250107@142645.6986 7j3hkekgk9hobj6731huolc59q 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.2362.00.1'
20250107@142645.7000 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.7017 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.7047 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.7065 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.7075 7j3hkekgk9hobj6731huolc59q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142645.7089 7j3hkekgk9hobj6731huolc59q Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20250107@142645.7102 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.7119 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142645.7131 7j3hkekgk9hobj6731huolc59q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d362107677d39a5ad','aut677d365016677d39a57f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142645.7143 7j3hkekgk9hobj6731huolc59q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142645.7158 7j3hkekgk9hobj6731huolc59q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142645.7188 7j3hkekgk9hobj6731huolc59q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d362107677d39a5ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut677d365016677d39a57f' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250107@142645.7484 7j3hkekgk9hobj6731huolc59q Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677d365016677d39a57f','2500117','wait',39,'adm09112754980.682000002')
20250107@142645.7562 7j3hkekgk9hobj6731huolc59q Query : use flama_phc
20250107@142645.7567 7j3hkekgk9hobj6731huolc59q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250107@142645.7598 7j3hkekgk9hobj6731huolc59q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4355';
20250107@142645.7644 7j3hkekgk9hobj6731huolc59q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4355';
20250107@142645.7700 7j3hkekgk9hobj6731huolc59q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4355';
20250107@142645.7738 7j3hkekgk9hobj6731huolc59q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4355';
20250107@142645.8277 h3h67hq18ohjl8vuplumrkk03f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250107@142645.8288 h3h67hq18ohjl8vuplumrkk03f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250107@142645.8360 h3h67hq18ohjl8vuplumrkk03f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4356';
20250107@142645.8429 h3h67hq18ohjl8vuplumrkk03f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4356';
20250107@142645.8493 h3h67hq18ohjl8vuplumrkk03f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4356';
20250107@142645.8548 h3h67hq18ohjl8vuplumrkk03f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4356';
20250107@142645.8615 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.8619 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250107@142645.8688 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.8691 h3h67hq18ohjl8vuplumrkk03f Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250107@142645.8742 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142645.8905 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500118 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142645.9583 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142645.9607 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500118 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142645.9626 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142645.9648 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500118 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142645.9666 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142645.9687 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500118 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142645.9706 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.9709 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250107@142645.9747 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.9751 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 1 valor from td where td.ndoc = 39
20250107@142645.9793 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.9797 h3h67hq18ohjl8vuplumrkk03f 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')
20250107@142645.9830 h3h67hq18ohjl8vuplumrkk03f 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
20250107@142645.9867 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.9870 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20250107@142645.9902 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.9905 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250107@142645.9937 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.9940 h3h67hq18ohjl8vuplumrkk03f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250107@142645.9980 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142645.9983 h3h67hq18ohjl8vuplumrkk03f Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20250107@142646.3200 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142646.3500 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from td where ndoc = 39
20250107@142646.4900 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250107@142646.6300 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8100 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142646.1000 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.1160 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142646.1460 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.1630 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142646.1760 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142646.2860 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142646.3000 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.3190 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142646.3360 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677d374400677d39a604' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250107@142646.5260 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.5460 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142646.5800 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250107@142646.5920 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250107@142646.6030 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250107@142646.6150 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250107@142646.6270 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250107@142646.6380 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250107@142646.6480 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677d374400677d39a604',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250107@142646.9240 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 fno valor from wsftdata order by fno desc
20250107@142646.9540 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.9700 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142646.9910 h3h67hq18ohjl8vuplumrkk03f Query : select 'normal' from dummy
20250107@142646.1005 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677d374400677d39a604',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2798,100810,0,'2025-01-07',39,'euro',0,0,2025 ,?,?)
20250107@142646.1304 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142646.1307 h3h67hq18ohjl8vuplumrkk03f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.1331 h3h67hq18ohjl8vuplumrkk03f 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.2388.00.1'
20250107@142646.1479 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.1495 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.1523 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.1538 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.1547 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142646.1558 h3h67hq18ohjl8vuplumrkk03f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142646.1572 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.1587 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.1599 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d354461677d39a626','aut677d374400677d39a604' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142646.1603 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.1619 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.1647 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d354461677d39a626',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut677d374400677d39a604' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250107@142646.1921 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142646.1924 h3h67hq18ohjl8vuplumrkk03f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.1946 h3h67hq18ohjl8vuplumrkk03f 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.2388.00.1'
20250107@142646.1962 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.1982 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.2019 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.2034 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.2043 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142646.2055 h3h67hq18ohjl8vuplumrkk03f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142646.2069 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.2084 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.2095 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d334897677d39a632','aut677d374400677d39a604' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142646.2100 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.2120 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.2150 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d334897677d39a632',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d374400677d39a604' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250107@142646.2419 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142646.2423 h3h67hq18ohjl8vuplumrkk03f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.2444 h3h67hq18ohjl8vuplumrkk03f 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.2388.00.1'
20250107@142646.2459 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.2476 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.2503 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.2518 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.2528 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142646.2541 h3h67hq18ohjl8vuplumrkk03f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142646.2563 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.2581 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.2593 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d362760677d39a63e','aut677d374400677d39a604' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142646.2597 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.2611 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.2640 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d362760677d39a63e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d374400677d39a604' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20250107@142646.2952 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142646.2959 h3h67hq18ohjl8vuplumrkk03f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.2981 h3h67hq18ohjl8vuplumrkk03f 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.2388.00.1'
20250107@142646.3004 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.3038 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.3066 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.3084 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.3092 h3h67hq18ohjl8vuplumrkk03f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142646.3106 h3h67hq18ohjl8vuplumrkk03f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142646.3120 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.3142 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.3155 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d357951677d39a64c','aut677d374400677d39a604' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142646.3162 h3h67hq18ohjl8vuplumrkk03f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.3183 h3h67hq18ohjl8vuplumrkk03f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.3213 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d357951677d39a64c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d374400677d39a604' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20250107@142646.3582 h3h67hq18ohjl8vuplumrkk03f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677d374400677d39a604','2500118','wait',39,'adm09112754980.682000002')
20250107@142646.3661 h3h67hq18ohjl8vuplumrkk03f Query : use flama_phc
20250107@142646.3664 h3h67hq18ohjl8vuplumrkk03f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250107@142646.3699 h3h67hq18ohjl8vuplumrkk03f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4356';
20250107@142646.3762 h3h67hq18ohjl8vuplumrkk03f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4356';
20250107@142646.3819 h3h67hq18ohjl8vuplumrkk03f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4356';
20250107@142646.3859 h3h67hq18ohjl8vuplumrkk03f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4356';
20250107@142646.5662 p6dsm3f2gg26bfc7rekm3e541f Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250107@142646.5678 p6dsm3f2gg26bfc7rekm3e541f Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250107@142646.5750 p6dsm3f2gg26bfc7rekm3e541f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4357';
20250107@142646.5824 p6dsm3f2gg26bfc7rekm3e541f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4357';
20250107@142646.5899 p6dsm3f2gg26bfc7rekm3e541f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4357';
20250107@142646.5934 p6dsm3f2gg26bfc7rekm3e541f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4357';
20250107@142646.6004 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6007 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250107@142646.6074 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6077 p6dsm3f2gg26bfc7rekm3e541f Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250107@142646.6124 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142646.6144 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500119 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142646.6477 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142646.6501 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500119 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142646.6519 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142646.6539 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500119 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142646.6556 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142646.6577 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500119 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142646.6594 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142646.6614 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500119 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142646.6632 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6636 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250107@142646.6686 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6689 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 1 valor from td where td.ndoc = 39
20250107@142646.6718 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6721 p6dsm3f2gg26bfc7rekm3e541f 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')
20250107@142646.6750 p6dsm3f2gg26bfc7rekm3e541f 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
20250107@142646.6789 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6792 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20250107@142646.6821 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6824 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250107@142646.6853 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6857 p6dsm3f2gg26bfc7rekm3e541f Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250107@142646.6899 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6902 p6dsm3f2gg26bfc7rekm3e541f Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20250107@142646.6954 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.6958 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from td where ndoc = 39
20250107@142646.6990 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250107@142646.7005 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.7023 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142646.7042 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.7058 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142646.7092 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.7107 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142646.7121 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142646.7232 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142646.7246 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.7267 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142646.7285 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677d331367677d39a6ad' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250107@142646.7454 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.7473 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142646.7510 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250107@142646.7524 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250107@142646.7536 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250107@142646.7548 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250107@142646.7560 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250107@142646.7572 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250107@142646.7583 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677d331367677d39a6ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250107@142646.7850 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 fno valor from wsftdata order by fno desc
20250107@142646.7884 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.7901 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142646.7926 p6dsm3f2gg26bfc7rekm3e541f Query : select 'normal' from dummy
20250107@142646.7943 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677d331367677d39a6ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2799,100810,0,'2025-01-07',39,'euro',0,0,2025 ,?,?)
20250107@142646.8246 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.8250 p6dsm3f2gg26bfc7rekm3e541f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.8278 p6dsm3f2gg26bfc7rekm3e541f 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.2388.00.1'
20250107@142646.8294 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8310 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.8337 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8351 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.8360 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142646.8373 p6dsm3f2gg26bfc7rekm3e541f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142646.8385 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8400 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.8412 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d311198677d39a6cc','aut677d331367677d39a6ad' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142646.8417 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8431 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.8460 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d311198677d39a6cc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut677d331367677d39a6ad' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250107@142646.8710 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.8714 p6dsm3f2gg26bfc7rekm3e541f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.8738 p6dsm3f2gg26bfc7rekm3e541f 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.2388.00.1'
20250107@142646.8754 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8774 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.8802 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8819 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.8828 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142646.8841 p6dsm3f2gg26bfc7rekm3e541f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142646.8853 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8869 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.8881 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d399472677d39a6d8','aut677d331367677d39a6ad' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142646.8885 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.8901 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.8931 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d399472677d39a6d8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut677d331367677d39a6ad' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250107@142646.9394 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.9399 p6dsm3f2gg26bfc7rekm3e541f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.9423 p6dsm3f2gg26bfc7rekm3e541f 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.2388.00.1'
20250107@142646.9438 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.9455 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.9482 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.9497 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.9506 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142646.9518 p6dsm3f2gg26bfc7rekm3e541f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142646.9531 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.9545 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.9557 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d312506677d39a6e8','aut677d331367677d39a6ad' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142646.9561 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.9577 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.9605 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d312506677d39a6e8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d331367677d39a6ad' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20250107@142646.9875 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142646.9879 p6dsm3f2gg26bfc7rekm3e541f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142646.9900 p6dsm3f2gg26bfc7rekm3e541f 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.2388.00.1'
20250107@142646.9915 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.9933 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142646.9961 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142646.9979 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142646.9989 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142647.1000 p6dsm3f2gg26bfc7rekm3e541f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142647.1400 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.3000 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.4300 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d363828677d39a700','aut677d331367677d39a6ad' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142647.4800 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6300 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.9300 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d363828677d39a700',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d331367677d39a6ad' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20250107@142647.3430 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142647.3460 p6dsm3f2gg26bfc7rekm3e541f Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142647.3670 p6dsm3f2gg26bfc7rekm3e541f 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.2388.00.1'
20250107@142647.3820 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.3970 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.4400 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.4550 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.4640 p6dsm3f2gg26bfc7rekm3e541f Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142647.4760 p6dsm3f2gg26bfc7rekm3e541f Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142647.4890 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.5050 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.5180 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d391331677d39a70b','aut677d331367677d39a6ad' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142647.5450 p6dsm3f2gg26bfc7rekm3e541f Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.5640 p6dsm3f2gg26bfc7rekm3e541f Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.5980 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d391331677d39a70b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d331367677d39a6ad' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20250107@142647.8510 p6dsm3f2gg26bfc7rekm3e541f Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677d331367677d39a6ad','2500119','wait',39,'adm09112754980.682000002')
20250107@142647.9260 p6dsm3f2gg26bfc7rekm3e541f Query : use flama_phc
20250107@142647.9300 p6dsm3f2gg26bfc7rekm3e541f Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250107@142647.9590 p6dsm3f2gg26bfc7rekm3e541f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4357';
20250107@142647.1002 p6dsm3f2gg26bfc7rekm3e541f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4357';
20250107@142647.1060 p6dsm3f2gg26bfc7rekm3e541f Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4357';
20250107@142647.1093 p6dsm3f2gg26bfc7rekm3e541f Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4357';
20250107@142647.1656 oav1p5tihn3bf4opdgmeir92d3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250107@142647.1668 oav1p5tihn3bf4opdgmeir92d3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250107@142647.1740 oav1p5tihn3bf4opdgmeir92d3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4358';
20250107@142647.1819 oav1p5tihn3bf4opdgmeir92d3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4358';
20250107@142647.1886 oav1p5tihn3bf4opdgmeir92d3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4358';
20250107@142647.1922 oav1p5tihn3bf4opdgmeir92d3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4358';
20250107@142647.1979 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.1982 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250107@142647.2046 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.2049 oav1p5tihn3bf4opdgmeir92d3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250107@142647.2098 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142647.2118 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500120 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142647.2492 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142647.2511 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500120 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142647.2528 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142647.2546 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500120 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142647.2562 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142647.2580 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500120 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142647.2635 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2388.00.1'
20250107@142647.3794 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500120 and bi.ref ='324.2388.00.1' and bi.lordem =1
20250107@142647.3816 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.3820 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250107@142647.3853 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.3856 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 1 valor from td where td.ndoc = 39
20250107@142647.3887 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.3890 oav1p5tihn3bf4opdgmeir92d3 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')
20250107@142647.3917 oav1p5tihn3bf4opdgmeir92d3 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
20250107@142647.3952 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.3955 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20250107@142647.3994 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.3998 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250107@142647.4031 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.4035 oav1p5tihn3bf4opdgmeir92d3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250107@142647.4076 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.4079 oav1p5tihn3bf4opdgmeir92d3 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20250107@142647.4124 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.4127 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from td where ndoc = 39
20250107@142647.4139 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250107@142647.4156 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.4175 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142647.4196 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.4213 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142647.4243 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.4258 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142647.4273 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142647.4388 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142647.4402 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.4420 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142647.4435 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677d358954677d39a768' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250107@142647.4609 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.4628 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142647.4661 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250107@142647.4674 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250107@142647.4685 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250107@142647.4696 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250107@142647.4707 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250107@142647.4726 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250107@142647.4738 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677d358954677d39a768',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250107@142647.5013 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 fno valor from wsftdata order by fno desc
20250107@142647.5047 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.5064 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142647.5086 oav1p5tihn3bf4opdgmeir92d3 Query : select 'normal' from dummy
20250107@142647.5101 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677d358954677d39a768',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2800,100810,0,'2025-01-07',39,'euro',0,0,2025 ,?,?)
20250107@142647.5565 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.5606 oav1p5tihn3bf4opdgmeir92d3 Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142647.5817 oav1p5tihn3bf4opdgmeir92d3 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.2388.00.1'
20250107@142647.5831 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.5848 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.5873 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.5888 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.5898 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142647.5912 oav1p5tihn3bf4opdgmeir92d3 Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142647.5926 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.5941 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.5952 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d328681677d39a790','aut677d358954677d39a768' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142647.5957 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.5973 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.6001 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d328681677d39a790',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut677d358954677d39a768' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250107@142647.6259 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.6262 oav1p5tihn3bf4opdgmeir92d3 Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142647.6284 oav1p5tihn3bf4opdgmeir92d3 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.2388.00.1'
20250107@142647.6299 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6316 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.6343 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6360 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.6371 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142647.6383 oav1p5tihn3bf4opdgmeir92d3 Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142647.6397 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6420 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.6431 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d317932677d39a79c','aut677d358954677d39a768' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142647.6436 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6450 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.6504 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d317932677d39a79c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut677d358954677d39a768' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250107@142647.6792 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.6795 oav1p5tihn3bf4opdgmeir92d3 Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142647.6817 oav1p5tihn3bf4opdgmeir92d3 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.2388.00.1'
20250107@142647.6833 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6849 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.6877 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6891 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.6899 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142647.6911 oav1p5tihn3bf4opdgmeir92d3 Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142647.6923 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6938 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.6949 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d378299677d39a7a9','aut677d358954677d39a768' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142647.6955 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.6973 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.7000 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d378299677d39a7a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d358954677d39a768' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20250107@142647.7256 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.7260 oav1p5tihn3bf4opdgmeir92d3 Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142647.7282 oav1p5tihn3bf4opdgmeir92d3 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.2388.00.1'
20250107@142647.7295 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.7310 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.7336 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.7350 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.7359 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142647.7370 oav1p5tihn3bf4opdgmeir92d3 Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142647.7383 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.7398 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.7409 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d346334677d39a7b4','aut677d358954677d39a768' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142647.7413 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.7428 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.7469 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d346334677d39a7b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d358954677d39a768' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20250107@142647.7758 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.7762 oav1p5tihn3bf4opdgmeir92d3 Query : select st.usalote valor from st where st.ref = '324.2388.00.1'
20250107@142647.7785 oav1p5tihn3bf4opdgmeir92d3 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.2388.00.1'
20250107@142647.7802 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.7821 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.7853 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.7873 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.7929 oav1p5tihn3bf4opdgmeir92d3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142647.7945 oav1p5tihn3bf4opdgmeir92d3 Query : select sestamp valor from se where ref ='324.2388.00.1' and lote = 'r2400490100a'
20250107@142647.7960 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.7980 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142647.7994 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d323559677d39a7c2','aut677d358954677d39a768' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142647.8000 oav1p5tihn3bf4opdgmeir92d3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142647.8019 oav1p5tihn3bf4opdgmeir92d3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142647.8080 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d323559677d39a7c2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677d358954677d39a768' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20250107@142647.8371 oav1p5tihn3bf4opdgmeir92d3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677d358954677d39a768','2500120','wait',39,'adm09112754980.682000002')
20250107@142647.8449 oav1p5tihn3bf4opdgmeir92d3 Query : use flama_phc
20250107@142647.8453 oav1p5tihn3bf4opdgmeir92d3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250107@142647.8485 oav1p5tihn3bf4opdgmeir92d3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4358';
20250107@142647.8533 oav1p5tihn3bf4opdgmeir92d3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4358';
20250107@142647.8587 oav1p5tihn3bf4opdgmeir92d3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4358';
20250107@142647.8624 oav1p5tihn3bf4opdgmeir92d3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4358';
20250107@142647.9444 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250107@142647.9456 o14bl1hj9j7p9ubji4gpdhono5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250107@142647.9527 o14bl1hj9j7p9ubji4gpdhono5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4359';
20250107@142647.9602 o14bl1hj9j7p9ubji4gpdhono5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4359';
20250107@142647.9670 o14bl1hj9j7p9ubji4gpdhono5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4359';
20250107@142647.9708 o14bl1hj9j7p9ubji4gpdhono5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4359';
20250107@142647.9777 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142647.9782 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250107@142647.9848 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142647.9852 o14bl1hj9j7p9ubji4gpdhono5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20250107@142647.9907 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20250107@142648.1130 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500122 and bi.ref ='324.2340.00.1' and bi.lordem =1
20250107@142648.5200 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20250107@142648.5450 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500122 and bi.ref ='324.2340.00.1' and bi.lordem =1
20250107@142648.5660 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.5710 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250107@142648.6070 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.6120 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 1 valor from td where td.ndoc = 39
20250107@142648.6500 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.6550 o14bl1hj9j7p9ubji4gpdhono5 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')
20250107@142648.6890 o14bl1hj9j7p9ubji4gpdhono5 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
20250107@142648.7330 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.7650 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20250107@142648.8000 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.8040 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250107@142648.8400 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.8440 o14bl1hj9j7p9ubji4gpdhono5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250107@142648.8940 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.8990 o14bl1hj9j7p9ubji4gpdhono5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20250107@142648.9570 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.9610 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from td where ndoc = 39
20250107@142648.9750 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250107@142648.9900 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.1007 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142648.1031 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.1048 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142648.1081 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.1098 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142648.1111 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142648.1518 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142648.2131 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.3193 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142648.3213 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677d364030677d39a81b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250107@142648.3397 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.3419 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142648.3463 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250107@142648.3478 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250107@142648.3493 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250107@142648.3505 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250107@142648.3522 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250107@142648.3535 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250107@142648.3547 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677d364030677d39a81b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250107@142648.3819 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 fno valor from wsftdata order by fno desc
20250107@142648.3856 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.3874 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142648.3898 o14bl1hj9j7p9ubji4gpdhono5 Query : select 'normal' from dummy
20250107@142648.3915 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677d364030677d39a81b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2801,100810,0,'2025-01-07',39,'euro',0,0,2025 ,?,?)
20250107@142648.4287 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.4291 o14bl1hj9j7p9ubji4gpdhono5 Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20250107@142648.4324 o14bl1hj9j7p9ubji4gpdhono5 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.2340.00.1'
20250107@142648.4480 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.4500 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142648.4526 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.4541 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142648.4550 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142648.4563 o14bl1hj9j7p9ubji4gpdhono5 Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20250107@142648.4578 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.4593 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142648.4606 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d349481677d39a86f','aut677d364030677d39a81b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142648.4610 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.4628 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142648.4657 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d349481677d39a86f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut677d364030677d39a81b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250107@142648.4955 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.4959 o14bl1hj9j7p9ubji4gpdhono5 Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20250107@142648.4981 o14bl1hj9j7p9ubji4gpdhono5 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.2340.00.1'
20250107@142648.4996 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.5012 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142648.5037 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.5052 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142648.5061 o14bl1hj9j7p9ubji4gpdhono5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142648.5074 o14bl1hj9j7p9ubji4gpdhono5 Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20250107@142648.5087 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.5101 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142648.5113 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d348876677d39a87c','aut677d364030677d39a81b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142648.5118 o14bl1hj9j7p9ubji4gpdhono5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.5135 o14bl1hj9j7p9ubji4gpdhono5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142648.5167 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d348876677d39a87c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut677d364030677d39a81b' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250107@142648.5466 o14bl1hj9j7p9ubji4gpdhono5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677d364030677d39a81b','2500122','wait',39,'adm09112754980.682000002')
20250107@142648.5544 o14bl1hj9j7p9ubji4gpdhono5 Query : use flama_phc
20250107@142648.5549 o14bl1hj9j7p9ubji4gpdhono5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250107@142648.5582 o14bl1hj9j7p9ubji4gpdhono5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4359';
20250107@142648.5632 o14bl1hj9j7p9ubji4gpdhono5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4359';
20250107@142648.5690 o14bl1hj9j7p9ubji4gpdhono5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4359';
20250107@142648.5732 o14bl1hj9j7p9ubji4gpdhono5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4359';
20250107@142648.6329 260uurf55loapgire2n2daqrv6 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250107@142648.6340 260uurf55loapgire2n2daqrv6 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250107@142648.6415 260uurf55loapgire2n2daqrv6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4360';
20250107@142648.6494 260uurf55loapgire2n2daqrv6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4360';
20250107@142648.6566 260uurf55loapgire2n2daqrv6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4360';
20250107@142648.6611 260uurf55loapgire2n2daqrv6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4360';
20250107@142648.6677 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.6681 260uurf55loapgire2n2daqrv6 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250107@142648.6750 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.6754 260uurf55loapgire2n2daqrv6 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20250107@142648.6853 260uurf55loapgire2n2daqrv6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20250107@142648.6879 260uurf55loapgire2n2daqrv6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500123 and bi.ref ='324.2362.00.1' and bi.lordem =1
20250107@142648.7256 260uurf55loapgire2n2daqrv6 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20250107@142648.7283 260uurf55loapgire2n2daqrv6 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =250 and bo.boano =2001 and bo.obrano = 2500123 and bi.ref ='324.2362.00.1' and bi.lordem =1
20250107@142648.7303 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7307 260uurf55loapgire2n2daqrv6 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250107@142648.7342 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7346 260uurf55loapgire2n2daqrv6 Query : select top 1 1 valor from td where td.ndoc = 39
20250107@142648.7379 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7383 260uurf55loapgire2n2daqrv6 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')
20250107@142648.7413 260uurf55loapgire2n2daqrv6 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
20250107@142648.7453 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7457 260uurf55loapgire2n2daqrv6 Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20250107@142648.7609 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7613 260uurf55loapgire2n2daqrv6 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250107@142648.7647 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7651 260uurf55loapgire2n2daqrv6 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250107@142648.7696 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7699 260uurf55loapgire2n2daqrv6 Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20250107@142648.7754 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142648.7757 260uurf55loapgire2n2daqrv6 Query : select 1 valor from td where ndoc = 39
20250107@142648.7805 260uurf55loapgire2n2daqrv6 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250107@142648.7823 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142648.7846 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142649.3280 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.3950 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142649.4270 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.4440 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142649.4590 260uurf55loapgire2n2daqrv6 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142649.5700 260uurf55loapgire2n2daqrv6 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250107@142649.5830 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.6000 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250107@142649.6160 260uurf55loapgire2n2daqrv6 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677d347138677d39a90b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250107@142649.7970 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.8170 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250107@142649.8770 260uurf55loapgire2n2daqrv6 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250107@142649.8900 260uurf55loapgire2n2daqrv6 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250107@142649.9020 260uurf55loapgire2n2daqrv6 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250107@142649.9140 260uurf55loapgire2n2daqrv6 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250107@142649.9270 260uurf55loapgire2n2daqrv6 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250107@142649.9390 260uurf55loapgire2n2daqrv6 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250107@142649.9510 260uurf55loapgire2n2daqrv6 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677d347138677d39a90b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250107@142649.1230 260uurf55loapgire2n2daqrv6 Query : select top 1 fno valor from wsftdata order by fno desc
20250107@142649.1264 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.1281 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250107@142649.1307 260uurf55loapgire2n2daqrv6 Query : select 'normal' from dummy
20250107@142649.1324 260uurf55loapgire2n2daqrv6 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677d347138677d39a90b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2802,102943,0,'2025-01-07',39,'euro',0,0,2025 ,?,?)
20250107@142649.1659 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142649.1663 260uurf55loapgire2n2daqrv6 Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20250107@142649.1690 260uurf55loapgire2n2daqrv6 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.2362.00.1'
20250107@142649.1861 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.1885 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142649.1916 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.1936 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142649.1947 260uurf55loapgire2n2daqrv6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250107@142649.1960 260uurf55loapgire2n2daqrv6 Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20250107@142649.2004 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.2027 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250107@142649.2042 260uurf55loapgire2n2daqrv6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677d399664677d39a930','aut677d347138677d39a90b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250107@142649.2046 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250107@142649.2062 260uurf55loapgire2n2daqrv6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250107@142649.2097 260uurf55loapgire2n2daqrv6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677d399664677d39a930',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',22.000 ,'aut677d347138677d39a90b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250107@142649.2377 260uurf55loapgire2n2daqrv6 Query : use flama_phc
20250107@142649.2381 260uurf55loapgire2n2daqrv6 Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20250107@142649.2403 260uurf55loapgire2n2daqrv6 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.2362.00.1'
20250107@142649.2418 260uurf55loapgire2n2daqrv6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
