20250108@141316.7163 j4tkeqtqig4f81m5nbp41cc04g Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400468300a'
20250108@141316.7181 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.7199 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.7216 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e815763677e87fcaf','aut677e855720677e87fc71' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141316.7245 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.7265 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.7298 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e815763677e87fcaf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut677e855720677e87fc71' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250108@141316.7547 j4tkeqtqig4f81m5nbp41cc04g Query : use flama_phc
20250108@141316.7551 j4tkeqtqig4f81m5nbp41cc04g Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20250108@141316.7573 j4tkeqtqig4f81m5nbp41cc04g 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.1642.00.2'
20250108@141316.7588 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.7605 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.7632 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.7651 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.7674 j4tkeqtqig4f81m5nbp41cc04g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141316.7687 j4tkeqtqig4f81m5nbp41cc04g Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20250108@141316.7701 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.7720 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.7734 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e836951677e87fcbc','aut677e855720677e87fc71' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141316.7739 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.7756 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.7792 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e836951677e87fcbc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut677e855720677e87fc71' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20250108@141316.8075 j4tkeqtqig4f81m5nbp41cc04g Query : use flama_phc
20250108@141316.8079 j4tkeqtqig4f81m5nbp41cc04g Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20250108@141316.8103 j4tkeqtqig4f81m5nbp41cc04g 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 = '327.8261.00.1'
20250108@141316.8246 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8263 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.8292 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8310 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.8320 j4tkeqtqig4f81m5nbp41cc04g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141316.8333 j4tkeqtqig4f81m5nbp41cc04g Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2401098200a'
20250108@141316.8347 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8362 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.8375 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e834109677e87fccb','aut677e855720677e87fc71' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141316.8379 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8395 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.8428 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e834109677e87fccb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut677e855720677e87fc71' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20250108@141316.8686 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8704 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.8731 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8745 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.8753 j4tkeqtqig4f81m5nbp41cc04g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141316.8765 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8782 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.8794 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e844197677e87fcd6','aut677e855720677e87fc71' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141316.8798 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.8815 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.8847 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut677e844197677e87fcd6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut677e855720677e87fc71' ,0,0 ,2,23.00,50000,?,?,?)
20250108@141316.9131 j4tkeqtqig4f81m5nbp41cc04g Query : use flama_phc
20250108@141316.9136 j4tkeqtqig4f81m5nbp41cc04g Query : select st.usalote valor from st where st.ref = '328.9902.00.1'
20250108@141316.9165 j4tkeqtqig4f81m5nbp41cc04g 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 = '328.9902.00.1'
20250108@141316.9326 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9349 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.9383 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9399 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.9408 j4tkeqtqig4f81m5nbp41cc04g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141316.9421 j4tkeqtqig4f81m5nbp41cc04g Query : select sestamp valor from se where ref ='328.9902.00.1' and lote = 'r2300777100a'
20250108@141316.9437 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9454 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.9467 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e860529677e87fce6','aut677e855720677e87fc71' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141316.9472 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9489 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.9521 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e860529677e87fce6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut677e855720677e87fc71' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20250108@141316.9834 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9854 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141316.9883 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9899 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.9909 j4tkeqtqig4f81m5nbp41cc04g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141316.9923 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9940 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141316.9954 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e828055677e87fcf2','aut677e855720677e87fc71' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141316.9960 j4tkeqtqig4f81m5nbp41cc04g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141316.9976 j4tkeqtqig4f81m5nbp41cc04g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.1000 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut677e828055677e87fcf2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut677e855720677e87fc71' ,0,0 ,2,23.00,80000,?,?,?)
20250108@141317.4370 j4tkeqtqig4f81m5nbp41cc04g Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677e855720677e87fc71','2500177','wait',39,'adm09112754980.682000002')
20250108@141317.5220 j4tkeqtqig4f81m5nbp41cc04g Query : use flama_phc
20250108@141317.5250 j4tkeqtqig4f81m5nbp41cc04g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@141317.5980 j4tkeqtqig4f81m5nbp41cc04g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4397';
20250108@141317.6480 j4tkeqtqig4f81m5nbp41cc04g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4397';
20250108@141317.7040 j4tkeqtqig4f81m5nbp41cc04g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4397';
20250108@141317.7380 j4tkeqtqig4f81m5nbp41cc04g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4397';
20250108@141317.1473 d9472h1s4rbbbtdduimg5sev5t Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250108@141317.1485 d9472h1s4rbbbtdduimg5sev5t Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250108@141317.1654 d9472h1s4rbbbtdduimg5sev5t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4398';
20250108@141317.1745 d9472h1s4rbbbtdduimg5sev5t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4398';
20250108@141317.1842 d9472h1s4rbbbtdduimg5sev5t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4398';
20250108@141317.1892 d9472h1s4rbbbtdduimg5sev5t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4398';
20250108@141317.1963 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.1967 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250108@141317.2067 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.2071 d9472h1s4rbbbtdduimg5sev5t Query : select no, estab,szadrsdesc from szadrs where u_coddest=6600
20250108@141317.2178 d9472h1s4rbbbtdduimg5sev5t 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'
20250108@141317.2198 d9472h1s4rbbbtdduimg5sev5t 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 = 2500178 and bi.ref ='324.2335.00.1' and bi.lordem =1
20250108@141317.2672 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20250108@141317.2697 d9472h1s4rbbbtdduimg5sev5t 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 = 2500178 and bi.ref ='324.1642.00.2' and bi.lordem =2
20250108@141317.3045 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9902.00.1'
20250108@141317.3162 d9472h1s4rbbbtdduimg5sev5t 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 = 2500178 and bi.ref ='328.9902.00.1' and bi.lordem =3
20250108@141317.3539 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9902.00.1'
20250108@141317.3574 d9472h1s4rbbbtdduimg5sev5t 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 = 2500178 and bi.ref ='328.9902.00.1' and bi.lordem =3
20250108@141317.3601 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.3605 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250108@141317.3653 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.3658 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 1 valor from td where td.ndoc = 39
20250108@141317.3726 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.3751 d9472h1s4rbbbtdduimg5sev5t 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')
20250108@141317.3786 d9472h1s4rbbbtdduimg5sev5t 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
20250108@141317.3828 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.3832 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20250108@141317.3918 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.3921 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250108@141317.3956 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.3959 d9472h1s4rbbbtdduimg5sev5t Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250108@141317.4004 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.4007 d9472h1s4rbbbtdduimg5sev5t Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. braga retail'
20250108@141317.4124 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.4128 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from td where ndoc = 39
20250108@141317.4143 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250108@141317.4157 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.4201 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141317.4223 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.4247 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141317.4298 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.4318 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141317.4331 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141317.4452 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141317.4465 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.4495 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141317.4513 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677e899001677e87fd69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250108@141317.4695 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.4716 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141317.4748 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250108@141317.4762 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250108@141317.4777 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250108@141317.4789 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250108@141317.4801 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250108@141317.4816 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250108@141317.4829 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677e899001677e87fd69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250108@141317.5101 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 fno valor from wsftdata order by fno desc
20250108@141317.5137 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.5153 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141317.5175 d9472h1s4rbbbtdduimg5sev5t Query : select 'normal' from dummy
20250108@141317.5190 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677e899001677e87fd69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2839,101621,0,'2025-01-08',39,'euro',0,0,2025 ,?,?)
20250108@141317.6367 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.6652 d9472h1s4rbbbtdduimg5sev5t Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20250108@141317.6680 d9472h1s4rbbbtdduimg5sev5t 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'
20250108@141317.6695 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.6712 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.6741 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.6757 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.6766 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141317.6779 d9472h1s4rbbbtdduimg5sev5t Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400468300a'
20250108@141317.6792 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.6808 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.6820 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e839786677e87fda5','aut677e899001677e87fd69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141317.6825 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.6841 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.6869 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e839786677e87fda5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut677e899001677e87fd69' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250108@141317.7126 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.7130 d9472h1s4rbbbtdduimg5sev5t Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20250108@141317.7150 d9472h1s4rbbbtdduimg5sev5t 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.1642.00.2'
20250108@141317.7163 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7179 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.7202 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7217 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.7226 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141317.7238 d9472h1s4rbbbtdduimg5sev5t Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20250108@141317.7250 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7264 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.7275 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e872560677e87fdb1','aut677e899001677e87fd69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141317.7280 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7293 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.7322 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e872560677e87fdb1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut677e899001677e87fd69' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250108@141317.7570 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.7573 d9472h1s4rbbbtdduimg5sev5t Query : select st.usalote valor from st where st.ref = '328.9902.00.1'
20250108@141317.7593 d9472h1s4rbbbtdduimg5sev5t 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 = '328.9902.00.1'
20250108@141317.7607 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7623 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.7649 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7664 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.7672 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141317.7684 d9472h1s4rbbbtdduimg5sev5t Query : select sestamp valor from se where ref ='328.9902.00.1' and lote = 'r2300777100a'
20250108@141317.7697 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7712 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.7724 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e882772677e87fdbb','aut677e899001677e87fd69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141317.7728 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.7744 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.7776 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e882772677e87fdbb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut677e899001677e87fd69' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20250108@141317.8163 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8179 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.8203 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8219 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.8230 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141317.8245 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8261 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.8273 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e869157677e87fdc9','aut677e899001677e87fd69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141317.8277 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8292 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.8321 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut677e869157677e87fdc9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut677e899001677e87fd69' ,0,0 ,2,23.00,40000,?,?,?)
20250108@141317.8561 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.8564 d9472h1s4rbbbtdduimg5sev5t Query : select st.usalote valor from st where st.ref = '328.9902.00.1'
20250108@141317.8584 d9472h1s4rbbbtdduimg5sev5t 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 = '328.9902.00.1'
20250108@141317.8597 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8613 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.8640 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8656 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.8665 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141317.8678 d9472h1s4rbbbtdduimg5sev5t Query : select sestamp valor from se where ref ='328.9902.00.1' and lote = 'r2300777100a'
20250108@141317.8692 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8781 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.8792 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e854471677e87fdd4','aut677e899001677e87fd69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141317.8797 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.8812 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.8859 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e854471677e87fdd4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut677e899001677e87fd69' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20250108@141317.9183 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.9199 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.9224 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.9242 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.9251 d9472h1s4rbbbtdduimg5sev5t Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141317.9264 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.9279 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141317.9291 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e839879677e87fde2','aut677e899001677e87fd69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141317.9295 d9472h1s4rbbbtdduimg5sev5t Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141317.9309 d9472h1s4rbbbtdduimg5sev5t Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141317.9338 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut677e839879677e87fde2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut677e899001677e87fd69' ,0,0 ,2,23.00,70000,?,?,?)
20250108@141317.9597 d9472h1s4rbbbtdduimg5sev5t Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677e899001677e87fd69','2500178','wait',39,'adm09112754980.682000002')
20250108@141317.9683 d9472h1s4rbbbtdduimg5sev5t Query : use flama_phc
20250108@141317.9687 d9472h1s4rbbbtdduimg5sev5t Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@141317.9717 d9472h1s4rbbbtdduimg5sev5t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4398';
20250108@141317.9760 d9472h1s4rbbbtdduimg5sev5t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4398';
20250108@141317.9813 d9472h1s4rbbbtdduimg5sev5t Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4398';
20250108@141317.9849 d9472h1s4rbbbtdduimg5sev5t Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4398';
20250108@141318.4950 0mhcogpa0uikhnn22h6itqfnae Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250108@141318.5050 0mhcogpa0uikhnn22h6itqfnae Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250108@141318.5710 0mhcogpa0uikhnn22h6itqfnae Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4399';
20250108@141318.6320 0mhcogpa0uikhnn22h6itqfnae Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4399';
20250108@141318.6990 0mhcogpa0uikhnn22h6itqfnae Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4399';
20250108@141318.7360 0mhcogpa0uikhnn22h6itqfnae Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4399';
20250108@141318.8040 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.8070 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250108@141318.8840 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.8870 0mhcogpa0uikhnn22h6itqfnae Query : select no, estab,szadrsdesc from szadrs where u_coddest=1453
20250108@141318.9750 0mhcogpa0uikhnn22h6itqfnae 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'
20250108@141318.1002 0mhcogpa0uikhnn22h6itqfnae 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 = 2500179 and bi.ref ='324.2335.00.1' and bi.lordem =1
20250108@141318.1352 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1356 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250108@141318.1390 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1393 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 1 valor from td where td.ndoc = 39
20250108@141318.1424 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1426 0mhcogpa0uikhnn22h6itqfnae 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')
20250108@141318.1458 0mhcogpa0uikhnn22h6itqfnae 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
20250108@141318.1496 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1499 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20250108@141318.1530 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1533 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250108@141318.1563 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1566 0mhcogpa0uikhnn22h6itqfnae Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250108@141318.1605 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1608 0mhcogpa0uikhnn22h6itqfnae Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - batalha'
20250108@141318.1653 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.1656 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from td where ndoc = 39
20250108@141318.1669 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250108@141318.1685 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.1702 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141318.1722 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.1739 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141318.1768 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.1788 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141318.1801 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141318.1911 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141318.1926 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.1942 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141318.1960 0mhcogpa0uikhnn22h6itqfnae Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677e862162677e87fe2b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250108@141318.2196 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.2215 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141318.2249 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250108@141318.2261 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250108@141318.2273 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250108@141318.2285 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250108@141318.2296 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250108@141318.2307 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250108@141318.2318 0mhcogpa0uikhnn22h6itqfnae Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677e862162677e87fe2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250108@141318.2561 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 fno valor from wsftdata order by fno desc
20250108@141318.2595 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.2612 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141318.2640 0mhcogpa0uikhnn22h6itqfnae Query : select 'normal' from dummy
20250108@141318.2686 0mhcogpa0uikhnn22h6itqfnae Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677e862162677e87fe2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2840,101621,0,'2025-01-08',39,'euro',0,0,2025 ,?,?)
20250108@141318.2988 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.2992 0mhcogpa0uikhnn22h6itqfnae Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20250108@141318.3015 0mhcogpa0uikhnn22h6itqfnae 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'
20250108@141318.3029 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.3045 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141318.3071 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.3087 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141318.3097 0mhcogpa0uikhnn22h6itqfnae Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141318.3111 0mhcogpa0uikhnn22h6itqfnae Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400468300a'
20250108@141318.3124 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.3139 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141318.3151 0mhcogpa0uikhnn22h6itqfnae Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e898924677e87fe4c','aut677e862162677e87fe2b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141318.3156 0mhcogpa0uikhnn22h6itqfnae Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.3176 0mhcogpa0uikhnn22h6itqfnae Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141318.3207 0mhcogpa0uikhnn22h6itqfnae Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e898924677e87fe4c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut677e862162677e87fe2b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250108@141318.3523 0mhcogpa0uikhnn22h6itqfnae Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677e862162677e87fe2b','2500179','wait',39,'adm09112754980.682000002')
20250108@141318.3637 0mhcogpa0uikhnn22h6itqfnae Query : use flama_phc
20250108@141318.3644 0mhcogpa0uikhnn22h6itqfnae Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@141318.3678 0mhcogpa0uikhnn22h6itqfnae Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4399';
20250108@141318.3721 0mhcogpa0uikhnn22h6itqfnae Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4399';
20250108@141318.3774 0mhcogpa0uikhnn22h6itqfnae Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4399';
20250108@141318.3830 0mhcogpa0uikhnn22h6itqfnae Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4399';
20250108@141318.4404 57cdi9uqovdu858id403ogn97e Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250108@141318.4415 57cdi9uqovdu858id403ogn97e Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250108@141318.4503 57cdi9uqovdu858id403ogn97e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4400';
20250108@141318.4574 57cdi9uqovdu858id403ogn97e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4400';
20250108@141318.4638 57cdi9uqovdu858id403ogn97e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4400';
20250108@141318.4675 57cdi9uqovdu858id403ogn97e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4400';
20250108@141318.4770 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.4774 57cdi9uqovdu858id403ogn97e Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250108@141318.4926 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.4929 57cdi9uqovdu858id403ogn97e Query : select no, estab,szadrsdesc from szadrs where u_coddest=233
20250108@141318.5110 57cdi9uqovdu858id403ogn97e 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'
20250108@141318.5130 57cdi9uqovdu858id403ogn97e 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 = 2500180 and bi.ref ='324.2335.00.1' and bi.lordem =1
20250108@141318.5465 57cdi9uqovdu858id403ogn97e Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20250108@141318.5487 57cdi9uqovdu858id403ogn97e 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 = 2500180 and bi.ref ='324.1642.00.2' and bi.lordem =2
20250108@141318.6340 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.6458 57cdi9uqovdu858id403ogn97e Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250108@141318.7023 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.7027 57cdi9uqovdu858id403ogn97e Query : select top 1 1 valor from td where td.ndoc = 39
20250108@141318.7058 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.7061 57cdi9uqovdu858id403ogn97e 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')
20250108@141318.7090 57cdi9uqovdu858id403ogn97e 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
20250108@141318.7236 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.7278 57cdi9uqovdu858id403ogn97e Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20250108@141318.7678 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.7702 57cdi9uqovdu858id403ogn97e Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250108@141318.8084 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.8127 57cdi9uqovdu858id403ogn97e Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250108@141318.8251 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.8254 57cdi9uqovdu858id403ogn97e Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - tudo para o seu lar'
20250108@141318.8301 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.8304 57cdi9uqovdu858id403ogn97e Query : select 1 valor from td where ndoc = 39
20250108@141318.8317 57cdi9uqovdu858id403ogn97e Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250108@141318.8332 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.8349 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141318.8370 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.8385 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141318.8413 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.8427 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141318.8441 57cdi9uqovdu858id403ogn97e Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141318.8545 57cdi9uqovdu858id403ogn97e Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141318.8559 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.8574 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141318.8590 57cdi9uqovdu858id403ogn97e Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677e887765677e87fece' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250108@141318.8753 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.8770 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141318.8801 57cdi9uqovdu858id403ogn97e Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250108@141318.8814 57cdi9uqovdu858id403ogn97e Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250108@141318.8826 57cdi9uqovdu858id403ogn97e Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250108@141318.8838 57cdi9uqovdu858id403ogn97e Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250108@141318.8850 57cdi9uqovdu858id403ogn97e Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250108@141318.8863 57cdi9uqovdu858id403ogn97e Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250108@141318.8875 57cdi9uqovdu858id403ogn97e Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677e887765677e87fece',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250108@141318.9105 57cdi9uqovdu858id403ogn97e Query : select top 1 fno valor from wsftdata order by fno desc
20250108@141318.9138 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.9154 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141318.9176 57cdi9uqovdu858id403ogn97e Query : select 'normal' from dummy
20250108@141318.9191 57cdi9uqovdu858id403ogn97e Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677e887765677e87fece',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2841,101621,0,'2025-01-08',39,'euro',0,0,2025 ,?,?)
20250108@141318.9556 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141318.9559 57cdi9uqovdu858id403ogn97e Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20250108@141318.9582 57cdi9uqovdu858id403ogn97e 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'
20250108@141318.9595 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.9611 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141318.9636 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.9651 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141318.9659 57cdi9uqovdu858id403ogn97e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141318.9671 57cdi9uqovdu858id403ogn97e Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400468300a'
20250108@141318.9683 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.9698 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141318.9709 57cdi9uqovdu858id403ogn97e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e842930677e87feec','aut677e887765677e87fece' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141318.9713 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141318.9727 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141318.9755 57cdi9uqovdu858id403ogn97e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e842930677e87feec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut677e887765677e87fece' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250108@141319.5500 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141319.5800 57cdi9uqovdu858id403ogn97e Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20250108@141319.8000 57cdi9uqovdu858id403ogn97e 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.1642.00.2'
20250108@141319.9500 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.2040 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141319.2390 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.2600 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141319.2710 57cdi9uqovdu858id403ogn97e Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141319.2860 57cdi9uqovdu858id403ogn97e Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20250108@141319.3010 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.3170 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141319.3290 57cdi9uqovdu858id403ogn97e Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e824319677e87ff07','aut677e887765677e87fece' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141319.3340 57cdi9uqovdu858id403ogn97e Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.3490 57cdi9uqovdu858id403ogn97e Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141319.3810 57cdi9uqovdu858id403ogn97e Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e824319677e87ff07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut677e887765677e87fece' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250108@141319.7100 57cdi9uqovdu858id403ogn97e Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677e887765677e87fece','2500180','wait',39,'adm09112754980.682000002')
20250108@141319.8320 57cdi9uqovdu858id403ogn97e Query : use flama_phc
20250108@141319.8360 57cdi9uqovdu858id403ogn97e Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@141319.8850 57cdi9uqovdu858id403ogn97e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4400';
20250108@141319.9480 57cdi9uqovdu858id403ogn97e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4400';
20250108@141319.1015 57cdi9uqovdu858id403ogn97e Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4400';
20250108@141319.1056 57cdi9uqovdu858id403ogn97e Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4400';
20250108@141319.1588 gjjupdepng7hko346c153bjh61 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250108@141319.1604 gjjupdepng7hko346c153bjh61 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250108@141319.1691 gjjupdepng7hko346c153bjh61 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4401';
20250108@141319.1765 gjjupdepng7hko346c153bjh61 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4401';
20250108@141319.1848 gjjupdepng7hko346c153bjh61 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4401';
20250108@141319.1890 gjjupdepng7hko346c153bjh61 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4401';
20250108@141319.1968 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.1972 gjjupdepng7hko346c153bjh61 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250108@141319.2064 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.2068 gjjupdepng7hko346c153bjh61 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2014
20250108@141319.2170 gjjupdepng7hko346c153bjh61 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'
20250108@141319.2196 gjjupdepng7hko346c153bjh61 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 = 2500181 and bi.ref ='324.2335.00.1' and bi.lordem =1
20250108@141319.2530 gjjupdepng7hko346c153bjh61 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20250108@141319.2562 gjjupdepng7hko346c153bjh61 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 = 2500181 and bi.ref ='324.1642.00.2' and bi.lordem =2
20250108@141319.3011 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3016 gjjupdepng7hko346c153bjh61 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250108@141319.3061 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3066 gjjupdepng7hko346c153bjh61 Query : select top 1 1 valor from td where td.ndoc = 39
20250108@141319.3152 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3156 gjjupdepng7hko346c153bjh61 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')
20250108@141319.3194 gjjupdepng7hko346c153bjh61 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
20250108@141319.3241 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3245 gjjupdepng7hko346c153bjh61 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20250108@141319.3282 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3286 gjjupdepng7hko346c153bjh61 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250108@141319.3330 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3334 gjjupdepng7hko346c153bjh61 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250108@141319.3386 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3389 gjjupdepng7hko346c153bjh61 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - guarda'
20250108@141319.3455 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.3459 gjjupdepng7hko346c153bjh61 Query : select 1 valor from td where ndoc = 39
20250108@141319.3472 gjjupdepng7hko346c153bjh61 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250108@141319.3488 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.3505 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141319.3525 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.3544 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141319.3576 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.3591 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141319.3604 gjjupdepng7hko346c153bjh61 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141319.3714 gjjupdepng7hko346c153bjh61 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141319.3728 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.3744 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141319.3760 gjjupdepng7hko346c153bjh61 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677e895623677e87ff58' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250108@141319.4053 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.5034 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141319.5251 gjjupdepng7hko346c153bjh61 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250108@141319.5264 gjjupdepng7hko346c153bjh61 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250108@141319.5276 gjjupdepng7hko346c153bjh61 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250108@141319.5288 gjjupdepng7hko346c153bjh61 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250108@141319.5301 gjjupdepng7hko346c153bjh61 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250108@141319.5313 gjjupdepng7hko346c153bjh61 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250108@141319.5324 gjjupdepng7hko346c153bjh61 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677e895623677e87ff58',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250108@141319.5572 gjjupdepng7hko346c153bjh61 Query : select top 1 fno valor from wsftdata order by fno desc
20250108@141319.5607 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.5623 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141319.5648 gjjupdepng7hko346c153bjh61 Query : select 'normal' from dummy
20250108@141319.5665 gjjupdepng7hko346c153bjh61 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677e895623677e87ff58',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2842,101621,0,'2025-01-08',39,'euro',0,0,2025 ,?,?)
20250108@141319.6062 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.6066 gjjupdepng7hko346c153bjh61 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20250108@141319.6094 gjjupdepng7hko346c153bjh61 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'
20250108@141319.6111 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6129 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141319.6156 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6172 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141319.6181 gjjupdepng7hko346c153bjh61 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141319.6194 gjjupdepng7hko346c153bjh61 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400468300a'
20250108@141319.6207 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6222 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141319.6234 gjjupdepng7hko346c153bjh61 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e867221677e87ff97','aut677e895623677e87ff58' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141319.6239 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6254 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141319.6283 gjjupdepng7hko346c153bjh61 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e867221677e87ff97',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut677e895623677e87ff58' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250108@141319.6536 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.6539 gjjupdepng7hko346c153bjh61 Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20250108@141319.6560 gjjupdepng7hko346c153bjh61 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.1642.00.2'
20250108@141319.6573 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6591 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141319.6616 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6632 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141319.6640 gjjupdepng7hko346c153bjh61 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141319.6651 gjjupdepng7hko346c153bjh61 Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20250108@141319.6664 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6680 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141319.6692 gjjupdepng7hko346c153bjh61 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e895653677e87ffa2','aut677e895623677e87ff58' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141319.6696 gjjupdepng7hko346c153bjh61 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141319.6711 gjjupdepng7hko346c153bjh61 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141319.6746 gjjupdepng7hko346c153bjh61 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e895653677e87ffa2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut677e895623677e87ff58' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250108@141319.6994 gjjupdepng7hko346c153bjh61 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677e895623677e87ff58','2500181','wait',39,'adm09112754980.682000002')
20250108@141319.7075 gjjupdepng7hko346c153bjh61 Query : use flama_phc
20250108@141319.7079 gjjupdepng7hko346c153bjh61 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@141319.7110 gjjupdepng7hko346c153bjh61 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4401';
20250108@141319.7151 gjjupdepng7hko346c153bjh61 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4401';
20250108@141319.7202 gjjupdepng7hko346c153bjh61 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4401';
20250108@141319.7239 gjjupdepng7hko346c153bjh61 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4401';
20250108@141319.7761 iav9uqntv87cjk77l1rs67p888 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250108@141319.7772 iav9uqntv87cjk77l1rs67p888 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250108@141319.7842 iav9uqntv87cjk77l1rs67p888 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4402';
20250108@141319.7910 iav9uqntv87cjk77l1rs67p888 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4402';
20250108@141319.7972 iav9uqntv87cjk77l1rs67p888 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4402';
20250108@141319.8009 iav9uqntv87cjk77l1rs67p888 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4402';
20250108@141319.8067 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.8070 iav9uqntv87cjk77l1rs67p888 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250108@141319.8130 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.8133 iav9uqntv87cjk77l1rs67p888 Query : select no, estab,szadrsdesc from szadrs where u_coddest=3304
20250108@141319.8221 iav9uqntv87cjk77l1rs67p888 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'
20250108@141319.8275 iav9uqntv87cjk77l1rs67p888 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 = 2500182 and bi.ref ='324.2335.00.1' and bi.lordem =1
20250108@141319.8661 iav9uqntv87cjk77l1rs67p888 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20250108@141319.8682 iav9uqntv87cjk77l1rs67p888 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 = 2500182 and bi.ref ='324.1642.00.2' and bi.lordem =2
20250108@141319.9186 iav9uqntv87cjk77l1rs67p888 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9902.00.1'
20250108@141319.9263 iav9uqntv87cjk77l1rs67p888 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 = 2500182 and bi.ref ='328.9902.00.1' and bi.lordem =3
20250108@141319.9596 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.9600 iav9uqntv87cjk77l1rs67p888 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250108@141319.9751 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.9755 iav9uqntv87cjk77l1rs67p888 Query : select top 1 1 valor from td where td.ndoc = 39
20250108@141319.9786 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.9789 iav9uqntv87cjk77l1rs67p888 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')
20250108@141319.9815 iav9uqntv87cjk77l1rs67p888 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
20250108@141319.9849 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.9852 iav9uqntv87cjk77l1rs67p888 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20250108@141319.9881 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.9884 iav9uqntv87cjk77l1rs67p888 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250108@141319.9912 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.9915 iav9uqntv87cjk77l1rs67p888 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250108@141319.9953 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141319.9956 iav9uqntv87cjk77l1rs67p888 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. - chaves'
20250108@141320.2000 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141320.5000 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from td where ndoc = 39
20250108@141320.1800 iav9uqntv87cjk77l1rs67p888 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250108@141320.3200 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.4900 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141320.6700 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.8300 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141320.1400 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1580 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141320.1710 iav9uqntv87cjk77l1rs67p888 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141320.2800 iav9uqntv87cjk77l1rs67p888 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@141320.2960 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.3120 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@141320.3260 iav9uqntv87cjk77l1rs67p888 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677e841626677e880004' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250108@141320.5030 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.5320 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@141320.5640 iav9uqntv87cjk77l1rs67p888 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250108@141320.5760 iav9uqntv87cjk77l1rs67p888 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250108@141320.5880 iav9uqntv87cjk77l1rs67p888 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250108@141320.5990 iav9uqntv87cjk77l1rs67p888 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250108@141320.6350 iav9uqntv87cjk77l1rs67p888 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250108@141320.6470 iav9uqntv87cjk77l1rs67p888 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250108@141320.6580 iav9uqntv87cjk77l1rs67p888 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677e841626677e880004',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250108@141320.9710 iav9uqntv87cjk77l1rs67p888 Query : select top 1 fno valor from wsftdata order by fno desc
20250108@141320.1005 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1021 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@141320.1044 iav9uqntv87cjk77l1rs67p888 Query : select 'normal' from dummy
20250108@141320.1060 iav9uqntv87cjk77l1rs67p888 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677e841626677e880004',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2843,101621,0,'2025-01-08',39,'euro',0,0,2025 ,?,?)
20250108@141320.1354 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141320.1357 iav9uqntv87cjk77l1rs67p888 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20250108@141320.1378 iav9uqntv87cjk77l1rs67p888 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'
20250108@141320.1392 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1408 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.1433 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1447 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.1455 iav9uqntv87cjk77l1rs67p888 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141320.1467 iav9uqntv87cjk77l1rs67p888 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400468300a'
20250108@141320.1480 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1496 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.1511 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e822425677e880024','aut677e841626677e880004' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141320.1515 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1530 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.1565 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e822425677e880024',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut677e841626677e880004' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20250108@141320.1834 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141320.1839 iav9uqntv87cjk77l1rs67p888 Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20250108@141320.1867 iav9uqntv87cjk77l1rs67p888 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.1642.00.2'
20250108@141320.1883 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1901 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.1932 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.1950 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.1960 iav9uqntv87cjk77l1rs67p888 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141320.1975 iav9uqntv87cjk77l1rs67p888 Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20250108@141320.1990 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2008 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.2032 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e838252677e880030','aut677e841626677e880004' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141320.2041 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2060 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.2094 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e838252677e880030',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut677e841626677e880004' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20250108@141320.2369 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141320.2373 iav9uqntv87cjk77l1rs67p888 Query : select st.usalote valor from st where st.ref = '328.9902.00.1'
20250108@141320.2395 iav9uqntv87cjk77l1rs67p888 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 = '328.9902.00.1'
20250108@141320.2413 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2430 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.2459 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2475 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.2484 iav9uqntv87cjk77l1rs67p888 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141320.2496 iav9uqntv87cjk77l1rs67p888 Query : select sestamp valor from se where ref ='328.9902.00.1' and lote = 'r2300777100a'
20250108@141320.2508 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2522 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.2534 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e823138677e88003d','aut677e841626677e880004' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141320.2538 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2551 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.2577 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut677e823138677e88003d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut677e841626677e880004' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20250108@141320.2829 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2846 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.2874 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.2993 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.3006 iav9uqntv87cjk77l1rs67p888 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@141320.3024 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.3045 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@141320.3060 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e877103677e880049','aut677e841626677e880004' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@141320.3065 iav9uqntv87cjk77l1rs67p888 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@141320.3082 iav9uqntv87cjk77l1rs67p888 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@141320.3113 iav9uqntv87cjk77l1rs67p888 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut677e877103677e880049',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut677e841626677e880004' ,0,0 ,2,23.00,40000,?,?,?)
20250108@141320.3480 iav9uqntv87cjk77l1rs67p888 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677e841626677e880004','2500182','wait',39,'adm09112754980.682000002')
20250108@141320.3671 iav9uqntv87cjk77l1rs67p888 Query : use flama_phc
20250108@141320.3675 iav9uqntv87cjk77l1rs67p888 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@141320.3707 iav9uqntv87cjk77l1rs67p888 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4402';
20250108@141320.3778 iav9uqntv87cjk77l1rs67p888 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4402';
20250108@141320.3930 iav9uqntv87cjk77l1rs67p888 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4402';
20250108@141320.3974 iav9uqntv87cjk77l1rs67p888 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4402';
20250108@141909.2706 0lf40p7k04r69egbbjj2u6q6nj Query : use flama_phc
20250108@141909.2710 0lf40p7k04r69egbbjj2u6q6nj Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250108@141909.2880 0lf40p7k04r69egbbjj2u6q6nj Query : use flama_phc
20250108@141909.2883 0lf40p7k04r69egbbjj2u6q6nj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@143019.9332 sh86j14rr640ln4114ffb2vij3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250108@143019.9367 sh86j14rr640ln4114ffb2vij3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250108@143019.9529 sh86j14rr640ln4114ffb2vij3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4403';
20250108@143019.9641 sh86j14rr640ln4114ffb2vij3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4403';
20250108@143019.9770 sh86j14rr640ln4114ffb2vij3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4403';
20250108@143019.9837 sh86j14rr640ln4114ffb2vij3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4403';
20250108@143019.9951 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143019.9960 sh86j14rr640ln4114ffb2vij3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250108@143020.9800 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.1030 sh86j14rr640ln4114ffb2vij3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20250108@143020.1840 sh86j14rr640ln4114ffb2vij3 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'
20250108@143020.2190 sh86j14rr640ln4114ffb2vij3 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'
20250108@143020.2540 sh86j14rr640ln4114ffb2vij3 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'
20250108@143020.2870 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.2920 sh86j14rr640ln4114ffb2vij3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20250108@143020.3680 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.3740 sh86j14rr640ln4114ffb2vij3 Query : select top 1 1 valor from td where td.ndoc = 39
20250108@143020.4370 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.4420 sh86j14rr640ln4114ffb2vij3 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')
20250108@143020.5020 sh86j14rr640ln4114ffb2vij3 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
20250108@143020.5730 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.5780 sh86j14rr640ln4114ffb2vij3 Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20250108@143020.6280 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.6350 sh86j14rr640ln4114ffb2vij3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20250108@143020.7020 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.7080 sh86j14rr640ln4114ffb2vij3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250108@143020.8070 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.8120 sh86j14rr640ln4114ffb2vij3 Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20250108@143020.9040 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.9080 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from td where ndoc = 39
20250108@143020.9270 sh86j14rr640ln4114ffb2vij3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20250108@143020.9470 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.9710 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@143020.1013 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.1054 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@143020.1632 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.1944 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@143020.2229 sh86j14rr640ln4114ffb2vij3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@143020.2749 sh86j14rr640ln4114ffb2vij3 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2025 order by fno desc
20250108@143020.2844 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.2869 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20250108@143020.2892 sh86j14rr640ln4114ffb2vij3 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut677e864564677e8bfc36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20250108@143020.3120 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.3144 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20250108@143020.3197 sh86j14rr640ln4114ffb2vij3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20250108@143020.3213 sh86j14rr640ln4114ffb2vij3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20250108@143020.3240 sh86j14rr640ln4114ffb2vij3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20250108@143020.3262 sh86j14rr640ln4114ffb2vij3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20250108@143020.3276 sh86j14rr640ln4114ffb2vij3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20250108@143020.3298 sh86j14rr640ln4114ffb2vij3 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20250108@143020.3311 sh86j14rr640ln4114ffb2vij3 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut677e864564677e8bfc36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20250108@143020.3626 sh86j14rr640ln4114ffb2vij3 Query : select top 1 fno valor from wsftdata order by fno desc
20250108@143020.3679 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.3702 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20250108@143020.3738 sh86j14rr640ln4114ffb2vij3 Query : select 'normal' from dummy
20250108@143020.3757 sh86j14rr640ln4114ffb2vij3 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut677e864564677e8bfc36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2844,102943,0,'2025-01-08',39,'euro',0,0,2025 ,?,?)
20250108@143020.4192 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.4200 sh86j14rr640ln4114ffb2vij3 Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20250108@143020.4254 sh86j14rr640ln4114ffb2vij3 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'
20250108@143020.4297 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.4353 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@143020.4411 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.4439 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@143020.4460 sh86j14rr640ln4114ffb2vij3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@143020.4475 sh86j14rr640ln4114ffb2vij3 Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20250108@143020.4495 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.4518 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@143020.4539 sh86j14rr640ln4114ffb2vij3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e832460677e8bfc6d','aut677e864564677e8bfc36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@143020.4545 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.4570 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@143020.4614 sh86j14rr640ln4114ffb2vij3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut677e832460677e8bfc6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',15.000 ,'aut677e864564677e8bfc36' ,0,0 ,2,23.00,10000,?,?,?,?)
20250108@143020.5072 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.5123 sh86j14rr640ln4114ffb2vij3 Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20250108@143020.5311 sh86j14rr640ln4114ffb2vij3 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'
20250108@143020.5340 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.5371 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@143020.5418 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.5465 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@143020.5477 sh86j14rr640ln4114ffb2vij3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@143020.5501 sh86j14rr640ln4114ffb2vij3 Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20250108@143020.5524 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.5547 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@143020.5562 sh86j14rr640ln4114ffb2vij3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e846445677e8bfc86','aut677e864564677e8bfc36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@143020.5567 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.5594 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@143020.5636 sh86j14rr640ln4114ffb2vij3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut677e846445677e8bfc86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',22.000 ,'aut677e864564677e8bfc36' ,0,0 ,2,23.00,20000,?,?,?,?)
20250108@143020.5966 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.5971 sh86j14rr640ln4114ffb2vij3 Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20250108@143020.6014 sh86j14rr640ln4114ffb2vij3 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'
20250108@143020.6034 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.6055 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@143020.6097 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.6120 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@143020.6132 sh86j14rr640ln4114ffb2vij3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250108@143020.6156 sh86j14rr640ln4114ffb2vij3 Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20250108@143020.6174 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.6195 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20250108@143020.6210 sh86j14rr640ln4114ffb2vij3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677e874444677e8bfc96','aut677e864564677e8bfc36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20250108@143020.6216 sh86j14rr640ln4114ffb2vij3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@143020.6253 sh86j14rr640ln4114ffb2vij3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20250108@143020.6302 sh86j14rr640ln4114ffb2vij3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut677e874444677e8bfc96',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',22.000 ,'aut677e864564677e8bfc36' ,0,0 ,2,23.00,30000,?,?,?,?)
20250108@143020.6660 sh86j14rr640ln4114ffb2vij3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut677e864564677e8bfc36','2500203','wait',39,'adm09112754980.682000002')
20250108@143020.6819 sh86j14rr640ln4114ffb2vij3 Query : use flama_phc
20250108@143020.6824 sh86j14rr640ln4114ffb2vij3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@143020.6902 sh86j14rr640ln4114ffb2vij3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4403';
20250108@143020.7016 sh86j14rr640ln4114ffb2vij3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4403';
20250108@143020.7125 sh86j14rr640ln4114ffb2vij3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4403';
20250108@143020.7183 sh86j14rr640ln4114ffb2vij3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4403';
20250108@143609.3032 qkrkcrsgtfsbni2ccos3i9c8gs Query : use flama_phc
20250108@143609.3036 qkrkcrsgtfsbni2ccos3i9c8gs Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250108@143609.3205 qkrkcrsgtfsbni2ccos3i9c8gs Query : use flama_phc
20250108@143609.3208 qkrkcrsgtfsbni2ccos3i9c8gs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@151909.2807 qm6chamkrgopk3gk206b3ej22k Query : use flama_phc
20250108@151909.2811 qm6chamkrgopk3gk206b3ej22k Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250108@151909.2929 qm6chamkrgopk3gk206b3ej22k Query : use flama_phc
20250108@151909.2932 qm6chamkrgopk3gk206b3ej22k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@153609.5636 ae5v62jb5ujb0pba37agcpmnul Query : use flama_phc
20250108@153609.5640 ae5v62jb5ujb0pba37agcpmnul Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20250108@153609.5722 ae5v62jb5ujb0pba37agcpmnul Query : use flama_phc
20250108@153609.5725 ae5v62jb5ujb0pba37agcpmnul Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250108@161510.3127 rrj046e668j3t5q9hs3l4npacp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250108@161510.3193 rrj046e668j3t5q9hs3l4npacp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250108@161510.3605 rrj046e668j3t5q9hs3l4npacp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4404';
20250108@161510.3729 rrj046e668j3t5q9hs3l4npacp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4404';
20250108@161510.3852 rrj046e668j3t5q9hs3l4npacp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4404';
20250108@161510.3939 rrj046e668j3t5q9hs3l4npacp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4404';
20250108@161510.4027 rrj046e668j3t5q9hs3l4npacp Query : use flama_phc
20250108@161510.4031 rrj046e668j3t5q9hs3l4npacp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250108@161510.4164 rrj046e668j3t5q9hs3l4npacp Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4980.00.1'
20250108@161510.4396 rrj046e668j3t5q9hs3l4npacp Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2401064 and bi.ref ='324.4980.00.1' and bi.lordem =20000
20250108@161510.4883 rrj046e668j3t5q9hs3l4npacp Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24090942654,283000002 ' 
20250108@161510.5381 rrj046e668j3t5q9hs3l4npacp Query : use flama_phc
20250108@161510.5384 rrj046e668j3t5q9hs3l4npacp Query : select top 1 1 valor from ts where ts.ndos = 61
20250108@161510.5467 rrj046e668j3t5q9hs3l4npacp Query : use flama_phc
20250108@161510.5471 rrj046e668j3t5q9hs3l4npacp 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')
20250108@161510.5559 rrj046e668j3t5q9hs3l4npacp Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =61
20250108@161510.5633 rrj046e668j3t5q9hs3l4npacp Query : use flama_phc
20250108@161510.5637 rrj046e668j3t5q9hs3l4npacp Query : select top 1 ~inactivo valor from fl where no = '202121' and estab = 00 order by inactivo desc
20250108@161510.5888 rrj046e668j3t5q9hs3l4npacp Query : use flama_phc
20250108@161510.5969 rrj046e668j3t5q9hs3l4npacp Query : select 1 valor from ts where ndos = 61
20250108@161510.6115 rrj046e668j3t5q9hs3l4npacp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@161510.6661 rrj046e668j3t5q9hs3l4npacp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20250108@161510.6778 rrj046e668j3t5q9hs3l4npacp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@161510.6802 rrj046e668j3t5q9hs3l4npacp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20250108@161510.6814 rrj046e668j3t5q9hs3l4npacp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@161510.6859 rrj046e668j3t5q9hs3l4npacp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20250108@161510.6870 rrj046e668j3t5q9hs3l4npacp Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 61
20250108@161510.7031 rrj046e668j3t5q9hs3l4npacp Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250108@161510.7182 rrj046e668j3t5q9hs3l4npacp Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2025 order by obrano desc
20250108@161510.7238 rrj046e668j3t5q9hs3l4npacp Query : use flama_phc
20250108@161510.7246 rrj046e668j3t5q9hs3l4npacp Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202121' and estab=00
20250108@161510.7391 rrj046e668j3t5q9hs3l4npacp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@161510.7411 rrj046e668j3t5q9hs3l4npacp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20250108@161510.7505 rrj046e668j3t5q9hs3l4npacp Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut677ea48822677ea48eb0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20250108@161510.7625 rrj046e668j3t5q9hs3l4npacp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250108@161510.7648 rrj046e668j3t5q9hs3l4npacp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
