20241216@180617.9885 apqgh182nuoj6acrt6bpfpmbne Query : select 'normal' from dummy
20241216@180617.9903 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676061494967606c19dd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2474,102068,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180618.2200 apqgh182nuoj6acrt6bpfpmbne Query : use flama_phc
20241216@180618.2230 apqgh182nuoj6acrt6bpfpmbne Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241216@180618.2450 apqgh182nuoj6acrt6bpfpmbne 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.2330.00.1'
20241216@180618.3680 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.3840 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.4110 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.4250 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.4360 apqgh182nuoj6acrt6bpfpmbne Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.4480 apqgh182nuoj6acrt6bpfpmbne Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241216@180618.5130 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.5270 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.5390 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676060928967606c1a0c','aut676061494967606c19dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.5430 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.5590 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.5860 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676060928967606c1a0c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut676061494967606c19dd' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180618.7900 apqgh182nuoj6acrt6bpfpmbne Query : use flama_phc
20241216@180618.7940 apqgh182nuoj6acrt6bpfpmbne Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241216@180618.8140 apqgh182nuoj6acrt6bpfpmbne Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2340.00.1'
20241216@180618.9490 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.9650 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.9900 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.1004 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.1013 apqgh182nuoj6acrt6bpfpmbne Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.1025 apqgh182nuoj6acrt6bpfpmbne Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241216@180618.1038 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.1053 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.1064 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676068214967606c1a19','aut676061494967606c19dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.1071 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.1088 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.1156 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676068214967606c1a19',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut676061494967606c19dd' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241216@180618.1377 apqgh182nuoj6acrt6bpfpmbne Query : use flama_phc
20241216@180618.1380 apqgh182nuoj6acrt6bpfpmbne Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241216@180618.1399 apqgh182nuoj6acrt6bpfpmbne Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2340.00.1'
20241216@180618.1413 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.1430 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.1672 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.1689 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.1698 apqgh182nuoj6acrt6bpfpmbne Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.1711 apqgh182nuoj6acrt6bpfpmbne Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241216@180618.1724 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.1739 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.1776 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676062715867606c1a2a','aut676061494967606c19dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.1783 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.1798 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.1826 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676062715867606c1a2a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut676061494967606c19dd' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241216@180618.2161 apqgh182nuoj6acrt6bpfpmbne Query : use flama_phc
20241216@180618.2182 apqgh182nuoj6acrt6bpfpmbne Query : select st.usalote valor from st where st.ref = '324.2357.00.1'
20241216@180618.2205 apqgh182nuoj6acrt6bpfpmbne 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.2357.00.1'
20241216@180618.2329 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.2365 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.2391 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.2406 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.2414 apqgh182nuoj6acrt6bpfpmbne Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.2426 apqgh182nuoj6acrt6bpfpmbne Query : select sestamp valor from se where ref ='324.2357.00.1' and lote = 'r2200239100a'
20241216@180618.2447 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.2461 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.2473 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676063110867606c1a3b','aut676061494967606c19dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.2477 apqgh182nuoj6acrt6bpfpmbne Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.2491 apqgh182nuoj6acrt6bpfpmbne Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.2519 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676063110867606c1a3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut676061494967606c19dd' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241216@180618.2726 apqgh182nuoj6acrt6bpfpmbne Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676061494967606c19dd','2408637','wait',39,'adm09112754980.682000002')
20241216@180618.2803 apqgh182nuoj6acrt6bpfpmbne Query : use flama_phc
20241216@180618.2806 apqgh182nuoj6acrt6bpfpmbne Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180618.2841 apqgh182nuoj6acrt6bpfpmbne Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4004';
20241216@180618.2881 apqgh182nuoj6acrt6bpfpmbne Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4004';
20241216@180618.2933 apqgh182nuoj6acrt6bpfpmbne Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4004';
20241216@180618.2964 apqgh182nuoj6acrt6bpfpmbne Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4004';
20241216@180618.3513 pus5h587pnsi9datq94bm3k1js Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180618.3524 pus5h587pnsi9datq94bm3k1js Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180618.3592 pus5h587pnsi9datq94bm3k1js Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4005';
20241216@180618.3656 pus5h587pnsi9datq94bm3k1js Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4005';
20241216@180618.3720 pus5h587pnsi9datq94bm3k1js Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4005';
20241216@180618.3749 pus5h587pnsi9datq94bm3k1js Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4005';
20241216@180618.3817 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.3820 pus5h587pnsi9datq94bm3k1js Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180618.3884 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.3887 pus5h587pnsi9datq94bm3k1js Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241216@180618.3974 pus5h587pnsi9datq94bm3k1js Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241216@180618.4001 pus5h587pnsi9datq94bm3k1js Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408638 and bi.ref ='324.2301.00.3' and bi.lordem =1
20241216@180618.4299 pus5h587pnsi9datq94bm3k1js Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241216@180618.4338 pus5h587pnsi9datq94bm3k1js Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408638 and bi.ref ='324.2301.00.3' and bi.lordem =1
20241216@180618.4355 pus5h587pnsi9datq94bm3k1js Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241216@180618.4374 pus5h587pnsi9datq94bm3k1js Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408638 and bi.ref ='324.2301.00.3' and bi.lordem =1
20241216@180618.4389 pus5h587pnsi9datq94bm3k1js Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241216@180618.4408 pus5h587pnsi9datq94bm3k1js Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408638 and bi.ref ='324.2301.00.3' and bi.lordem =1
20241216@180618.4425 pus5h587pnsi9datq94bm3k1js Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241216@180618.4560 pus5h587pnsi9datq94bm3k1js Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408638 and bi.ref ='324.2326.00.1' and bi.lordem =2
20241216@180618.4854 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.4857 pus5h587pnsi9datq94bm3k1js Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180618.4911 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.4915 pus5h587pnsi9datq94bm3k1js Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180618.4946 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.4948 pus5h587pnsi9datq94bm3k1js 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')
20241216@180618.4977 pus5h587pnsi9datq94bm3k1js 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
20241216@180618.5012 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.5015 pus5h587pnsi9datq94bm3k1js Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241216@180618.5141 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.5145 pus5h587pnsi9datq94bm3k1js Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180618.5174 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.5180 pus5h587pnsi9datq94bm3k1js Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180618.5221 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.5224 pus5h587pnsi9datq94bm3k1js Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241216@180618.5270 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.5273 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from td where ndoc = 39
20241216@180618.5286 pus5h587pnsi9datq94bm3k1js Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180618.5300 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.5324 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180618.5344 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.5360 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180618.5392 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.5406 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180618.5419 pus5h587pnsi9datq94bm3k1js Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180618.5474 pus5h587pnsi9datq94bm3k1js Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180618.5487 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.5501 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180618.5517 pus5h587pnsi9datq94bm3k1js Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676060746067606c1a84' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180618.5702 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.5718 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180618.5754 pus5h587pnsi9datq94bm3k1js Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180618.5766 pus5h587pnsi9datq94bm3k1js Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180618.5778 pus5h587pnsi9datq94bm3k1js Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180618.5790 pus5h587pnsi9datq94bm3k1js Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180618.5802 pus5h587pnsi9datq94bm3k1js Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180618.5814 pus5h587pnsi9datq94bm3k1js Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180618.5825 pus5h587pnsi9datq94bm3k1js Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676060746067606c1a84',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180618.6190 pus5h587pnsi9datq94bm3k1js Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180618.6899 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.6917 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180618.6939 pus5h587pnsi9datq94bm3k1js Query : select 'normal' from dummy
20241216@180618.6954 pus5h587pnsi9datq94bm3k1js Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676060746067606c1a84',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2475,102943,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180618.7197 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.7200 pus5h587pnsi9datq94bm3k1js Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241216@180618.7220 pus5h587pnsi9datq94bm3k1js 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.2301.00.3'
20241216@180618.7232 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.7247 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.7272 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.7286 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.7296 pus5h587pnsi9datq94bm3k1js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.7319 pus5h587pnsi9datq94bm3k1js Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241216@180618.7332 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.7347 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.7358 pus5h587pnsi9datq94bm3k1js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676067325167606c1ab3','aut676060746067606c1a84' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.7363 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.7378 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.7406 pus5h587pnsi9datq94bm3k1js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676067325167606c1ab3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676060746067606c1a84' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180618.7850 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.7853 pus5h587pnsi9datq94bm3k1js Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241216@180618.7873 pus5h587pnsi9datq94bm3k1js 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.2301.00.3'
20241216@180618.7887 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.7904 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.7951 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.7967 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.7975 pus5h587pnsi9datq94bm3k1js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.7987 pus5h587pnsi9datq94bm3k1js Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241216@180618.7999 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8014 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.8025 pus5h587pnsi9datq94bm3k1js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676064983167606c1ac3','aut676060746067606c1a84' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.8029 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8044 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.8072 pus5h587pnsi9datq94bm3k1js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676064983167606c1ac3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676060746067606c1a84' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241216@180618.8295 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.8298 pus5h587pnsi9datq94bm3k1js Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241216@180618.8319 pus5h587pnsi9datq94bm3k1js 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.2301.00.3'
20241216@180618.8334 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8350 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.8378 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8394 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.8404 pus5h587pnsi9datq94bm3k1js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.8423 pus5h587pnsi9datq94bm3k1js Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241216@180618.8437 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8455 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.8469 pus5h587pnsi9datq94bm3k1js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676063502567606c1ace','aut676060746067606c1a84' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.8473 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8489 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.8545 pus5h587pnsi9datq94bm3k1js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676063502567606c1ace',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676060746067606c1a84' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241216@180618.8765 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.8769 pus5h587pnsi9datq94bm3k1js Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241216@180618.8791 pus5h587pnsi9datq94bm3k1js 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.2301.00.3'
20241216@180618.8808 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8824 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.8853 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8869 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.8879 pus5h587pnsi9datq94bm3k1js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.8895 pus5h587pnsi9datq94bm3k1js Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2400474200a'
20241216@180618.8908 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8925 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.8940 pus5h587pnsi9datq94bm3k1js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676060470267606c1ad9','aut676060746067606c1a84' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.8944 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.8959 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.8991 pus5h587pnsi9datq94bm3k1js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676060470267606c1ad9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',72.000 ,'aut676060746067606c1a84' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241216@180618.9223 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180618.9226 pus5h587pnsi9datq94bm3k1js Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241216@180618.9248 pus5h587pnsi9datq94bm3k1js 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.2326.00.1'
20241216@180618.9364 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.9380 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.9409 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.9425 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.9433 pus5h587pnsi9datq94bm3k1js Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180618.9484 pus5h587pnsi9datq94bm3k1js Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2400475600a'
20241216@180618.9538 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.9728 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180618.9741 pus5h587pnsi9datq94bm3k1js Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676061957867606c1ae8','aut676060746067606c1a84' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180618.9746 pus5h587pnsi9datq94bm3k1js Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180618.9762 pus5h587pnsi9datq94bm3k1js Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180618.9813 pus5h587pnsi9datq94bm3k1js Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676061957867606c1ae8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',126.000 ,'aut676060746067606c1a84' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241216@180619.3200 pus5h587pnsi9datq94bm3k1js Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676060746067606c1a84','2408638','wait',39,'adm09112754980.682000002')
20241216@180619.1100 pus5h587pnsi9datq94bm3k1js Query : use flama_phc
20241216@180619.1140 pus5h587pnsi9datq94bm3k1js Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180619.1490 pus5h587pnsi9datq94bm3k1js Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4005';
20241216@180619.1920 pus5h587pnsi9datq94bm3k1js Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4005';
20241216@180619.2440 pus5h587pnsi9datq94bm3k1js Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4005';
20241216@180619.2760 pus5h587pnsi9datq94bm3k1js Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4005';
20241216@180619.7760 3ami5lq4e1cnjnban29337jp72 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180619.7870 3ami5lq4e1cnjnban29337jp72 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180619.8650 3ami5lq4e1cnjnban29337jp72 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4006';
20241216@180619.9330 3ami5lq4e1cnjnban29337jp72 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4006';
20241216@180619.9980 3ami5lq4e1cnjnban29337jp72 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4006';
20241216@180619.1044 3ami5lq4e1cnjnban29337jp72 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4006';
20241216@180619.1099 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1102 3ami5lq4e1cnjnban29337jp72 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180619.1163 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1166 3ami5lq4e1cnjnban29337jp72 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1086
20241216@180619.1248 3ami5lq4e1cnjnban29337jp72 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2387.00.1'
20241216@180619.1384 3ami5lq4e1cnjnban29337jp72 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408640 and bi.ref ='324.2387.00.1' and bi.lordem =1
20241216@180619.1690 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1693 3ami5lq4e1cnjnban29337jp72 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180619.1726 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1729 3ami5lq4e1cnjnban29337jp72 Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180619.1759 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1761 3ami5lq4e1cnjnban29337jp72 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')
20241216@180619.1791 3ami5lq4e1cnjnban29337jp72 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
20241216@180619.1847 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1850 3ami5lq4e1cnjnban29337jp72 Query : select top 1 ~inactivo valor from cl where no = '101648' and estab = 0 order by inactivo desc
20241216@180619.1943 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1946 3ami5lq4e1cnjnban29337jp72 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180619.1979 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.1982 3ami5lq4e1cnjnban29337jp72 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180619.2026 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.2030 3ami5lq4e1cnjnban29337jp72 Query : select szadrsstamp valor from szadrs where szadrsdesc='adÃo moveis electrodomesticos,lda'
20241216@180619.2082 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.2085 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from td where ndoc = 39
20241216@180619.2098 3ami5lq4e1cnjnban29337jp72 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180619.2112 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.2127 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180619.2147 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.2162 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180619.2351 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.2371 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180619.2386 3ami5lq4e1cnjnban29337jp72 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180619.2446 3ami5lq4e1cnjnban29337jp72 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180619.2459 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.2476 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180619.2492 3ami5lq4e1cnjnban29337jp72 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676067960767606c1b3a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180619.3017 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.3770 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180619.3807 3ami5lq4e1cnjnban29337jp72 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180619.3821 3ami5lq4e1cnjnban29337jp72 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180619.3833 3ami5lq4e1cnjnban29337jp72 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180619.3850 3ami5lq4e1cnjnban29337jp72 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180619.3883 3ami5lq4e1cnjnban29337jp72 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180619.3896 3ami5lq4e1cnjnban29337jp72 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180619.3907 3ami5lq4e1cnjnban29337jp72 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676067960767606c1b3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180619.4124 3ami5lq4e1cnjnban29337jp72 Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180619.4156 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.4173 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180619.4196 3ami5lq4e1cnjnban29337jp72 Query : select 'normal' from dummy
20241216@180619.4228 3ami5lq4e1cnjnban29337jp72 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676067960767606c1b3a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2476,101648,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180619.4479 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.4482 3ami5lq4e1cnjnban29337jp72 Query : select st.usalote valor from st where st.ref = '324.2387.00.1'
20241216@180619.4504 3ami5lq4e1cnjnban29337jp72 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.2387.00.1'
20241216@180619.4642 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.4659 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180619.4686 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.4702 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180619.4711 3ami5lq4e1cnjnban29337jp72 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180619.4725 3ami5lq4e1cnjnban29337jp72 Query : select sestamp valor from se where ref ='324.2387.00.1' and lote = 'r2400490200a'
20241216@180619.4745 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.4761 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180619.4773 3ami5lq4e1cnjnban29337jp72 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676064803267606c1b73','aut676067960767606c1b3a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180619.4777 3ami5lq4e1cnjnban29337jp72 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.4792 3ami5lq4e1cnjnban29337jp72 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180619.4820 3ami5lq4e1cnjnban29337jp72 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676064803267606c1b73',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut676067960767606c1b3a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180619.5112 3ami5lq4e1cnjnban29337jp72 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676067960767606c1b3a','2408640','wait',39,'adm09112754980.682000002')
20241216@180619.5358 3ami5lq4e1cnjnban29337jp72 Query : use flama_phc
20241216@180619.5362 3ami5lq4e1cnjnban29337jp72 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180619.5415 3ami5lq4e1cnjnban29337jp72 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4006';
20241216@180619.5455 3ami5lq4e1cnjnban29337jp72 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4006';
20241216@180619.5506 3ami5lq4e1cnjnban29337jp72 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4006';
20241216@180619.5540 3ami5lq4e1cnjnban29337jp72 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4006';
20241216@180619.6015 ftj1ihfmplliek2gh0h9d4vp1g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180619.6027 ftj1ihfmplliek2gh0h9d4vp1g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180619.6091 ftj1ihfmplliek2gh0h9d4vp1g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4007';
20241216@180619.6152 ftj1ihfmplliek2gh0h9d4vp1g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4007';
20241216@180619.6214 ftj1ihfmplliek2gh0h9d4vp1g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4007';
20241216@180619.6244 ftj1ihfmplliek2gh0h9d4vp1g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4007';
20241216@180619.6299 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.6302 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180619.6557 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.6562 ftj1ihfmplliek2gh0h9d4vp1g Query : select no, estab,szadrsdesc from szadrs where u_coddest=6600
20241216@180619.6671 ftj1ihfmplliek2gh0h9d4vp1g 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'
20241216@180619.6788 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408646 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241216@180619.7087 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7090 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180619.7126 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7129 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180619.7161 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7164 ftj1ihfmplliek2gh0h9d4vp1g 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')
20241216@180619.7213 ftj1ihfmplliek2gh0h9d4vp1g 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
20241216@180619.7248 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7251 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241216@180619.7346 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7349 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180619.7384 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7388 ftj1ihfmplliek2gh0h9d4vp1g Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180619.7430 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7432 ftj1ihfmplliek2gh0h9d4vp1g Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. braga retail'
20241216@180619.7489 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.7493 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from td where ndoc = 39
20241216@180619.7505 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180619.7519 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.7534 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180619.7553 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.7568 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180619.7596 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.7612 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180619.7625 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180619.7684 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180619.7696 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.7711 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180619.7727 ftj1ihfmplliek2gh0h9d4vp1g Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676063192067606c1bba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180619.7872 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.7888 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180619.7921 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180619.7933 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180619.7944 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180619.7956 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180619.7968 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180619.7979 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180619.7990 ftj1ihfmplliek2gh0h9d4vp1g Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676063192067606c1bba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180619.8216 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180619.8244 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.8260 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180619.8282 ftj1ihfmplliek2gh0h9d4vp1g Query : select 'normal' from dummy
20241216@180619.8301 ftj1ihfmplliek2gh0h9d4vp1g Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676063192067606c1bba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2477,101621,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180619.8569 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.8573 ftj1ihfmplliek2gh0h9d4vp1g Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241216@180619.8597 ftj1ihfmplliek2gh0h9d4vp1g 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'
20241216@180619.8716 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.8751 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180619.8780 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.8795 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180619.8804 ftj1ihfmplliek2gh0h9d4vp1g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180619.8816 ftj1ihfmplliek2gh0h9d4vp1g Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241216@180619.8830 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.8844 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180619.8856 ftj1ihfmplliek2gh0h9d4vp1g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676063244867606c1bd7','aut676063192067606c1bba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180619.8860 ftj1ihfmplliek2gh0h9d4vp1g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180619.8878 ftj1ihfmplliek2gh0h9d4vp1g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180619.8907 ftj1ihfmplliek2gh0h9d4vp1g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676063244867606c1bd7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut676063192067606c1bba' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180619.9125 ftj1ihfmplliek2gh0h9d4vp1g Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676063192067606c1bba','2408646','wait',39,'adm09112754980.682000002')
20241216@180619.9233 ftj1ihfmplliek2gh0h9d4vp1g Query : use flama_phc
20241216@180619.9236 ftj1ihfmplliek2gh0h9d4vp1g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180619.9268 ftj1ihfmplliek2gh0h9d4vp1g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4007';
20241216@180619.9309 ftj1ihfmplliek2gh0h9d4vp1g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4007';
20241216@180619.9361 ftj1ihfmplliek2gh0h9d4vp1g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4007';
20241216@180619.9392 ftj1ihfmplliek2gh0h9d4vp1g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4007';
20241216@180620.1567 7vuj2sih2hv2qjj4oetuhqod5u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180620.1612 7vuj2sih2hv2qjj4oetuhqod5u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180620.1719 7vuj2sih2hv2qjj4oetuhqod5u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4008';
20241216@180620.1794 7vuj2sih2hv2qjj4oetuhqod5u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4008';
20241216@180620.1874 7vuj2sih2hv2qjj4oetuhqod5u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4008';
20241216@180620.1907 7vuj2sih2hv2qjj4oetuhqod5u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4008';
20241216@180620.1993 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.1996 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180620.2066 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2069 7vuj2sih2hv2qjj4oetuhqod5u Query : select no, estab,szadrsdesc from szadrs where u_coddest=233
20241216@180620.2156 7vuj2sih2hv2qjj4oetuhqod5u 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'
20241216@180620.2176 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408648 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241216@180620.2669 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2673 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180620.2710 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2713 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180620.2748 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2751 7vuj2sih2hv2qjj4oetuhqod5u 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')
20241216@180620.2781 7vuj2sih2hv2qjj4oetuhqod5u 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
20241216@180620.2816 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2819 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241216@180620.2851 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2854 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180620.2890 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2893 7vuj2sih2hv2qjj4oetuhqod5u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180620.2942 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.2945 7vuj2sih2hv2qjj4oetuhqod5u Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - tudo para o seu lar'
20241216@180620.2997 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.3000 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from td where ndoc = 39
20241216@180620.3012 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180620.3026 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.3042 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180620.3061 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.3075 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180620.3127 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.3141 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180620.3154 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180620.3208 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180620.3221 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.3234 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180620.3253 7vuj2sih2hv2qjj4oetuhqod5u Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676061095467606c1c4d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180620.3411 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.3429 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180620.3466 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180620.3480 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180620.3492 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180620.3526 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180620.3537 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180620.3549 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180620.3560 7vuj2sih2hv2qjj4oetuhqod5u Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676061095467606c1c4d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180620.3783 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180620.3825 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.3848 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180620.4126 7vuj2sih2hv2qjj4oetuhqod5u Query : select 'normal' from dummy
20241216@180620.5523 7vuj2sih2hv2qjj4oetuhqod5u Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676061095467606c1c4d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2478,101621,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180620.5907 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.5911 7vuj2sih2hv2qjj4oetuhqod5u Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241216@180620.5939 7vuj2sih2hv2qjj4oetuhqod5u 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'
20241216@180620.5956 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.5974 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180620.6000 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.6015 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180620.6024 7vuj2sih2hv2qjj4oetuhqod5u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180620.6037 7vuj2sih2hv2qjj4oetuhqod5u Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241216@180620.6050 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.6065 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180620.6078 7vuj2sih2hv2qjj4oetuhqod5u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676068650367606c1c93','aut676061095467606c1c4d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180620.6083 7vuj2sih2hv2qjj4oetuhqod5u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.6122 7vuj2sih2hv2qjj4oetuhqod5u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180620.6152 7vuj2sih2hv2qjj4oetuhqod5u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676068650367606c1c93',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut676061095467606c1c4d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180620.6374 7vuj2sih2hv2qjj4oetuhqod5u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676061095467606c1c4d','2408648','wait',39,'adm09112754980.682000002')
20241216@180620.6495 7vuj2sih2hv2qjj4oetuhqod5u Query : use flama_phc
20241216@180620.6500 7vuj2sih2hv2qjj4oetuhqod5u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180620.6533 7vuj2sih2hv2qjj4oetuhqod5u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4008';
20241216@180620.6574 7vuj2sih2hv2qjj4oetuhqod5u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4008';
20241216@180620.6631 7vuj2sih2hv2qjj4oetuhqod5u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4008';
20241216@180620.6663 7vuj2sih2hv2qjj4oetuhqod5u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4008';
20241216@180620.7674 915dse8pjr1hik5ubl2luop3tj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180620.7702 915dse8pjr1hik5ubl2luop3tj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180620.7774 915dse8pjr1hik5ubl2luop3tj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4009';
20241216@180620.7837 915dse8pjr1hik5ubl2luop3tj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4009';
20241216@180620.7917 915dse8pjr1hik5ubl2luop3tj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4009';
20241216@180620.7949 915dse8pjr1hik5ubl2luop3tj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4009';
20241216@180620.8027 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8030 915dse8pjr1hik5ubl2luop3tj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180620.8098 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8102 915dse8pjr1hik5ubl2luop3tj Query : select no, estab,szadrsdesc from szadrs where u_coddest=3080
20241216@180620.8186 915dse8pjr1hik5ubl2luop3tj 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'
20241216@180620.8206 915dse8pjr1hik5ubl2luop3tj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408650 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241216@180620.8558 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8562 915dse8pjr1hik5ubl2luop3tj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180620.8596 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8599 915dse8pjr1hik5ubl2luop3tj Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180620.8633 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8636 915dse8pjr1hik5ubl2luop3tj 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')
20241216@180620.8670 915dse8pjr1hik5ubl2luop3tj 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
20241216@180620.8709 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8713 915dse8pjr1hik5ubl2luop3tj Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241216@180620.8747 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8750 915dse8pjr1hik5ubl2luop3tj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180620.8784 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8788 915dse8pjr1hik5ubl2luop3tj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180620.8834 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8838 915dse8pjr1hik5ubl2luop3tj Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda- barcelos entrega'
20241216@180620.8887 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180620.8890 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from td where ndoc = 39
20241216@180620.8929 915dse8pjr1hik5ubl2luop3tj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180620.8944 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.8963 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180620.8983 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.8998 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180620.9027 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.9041 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180620.9054 915dse8pjr1hik5ubl2luop3tj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180620.9112 915dse8pjr1hik5ubl2luop3tj Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180620.9126 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.9142 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180620.9157 915dse8pjr1hik5ubl2luop3tj Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676061491267606c1cdd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180620.9330 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.9349 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180620.9386 915dse8pjr1hik5ubl2luop3tj Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180620.9398 915dse8pjr1hik5ubl2luop3tj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180620.9605 915dse8pjr1hik5ubl2luop3tj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180620.9620 915dse8pjr1hik5ubl2luop3tj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180620.9632 915dse8pjr1hik5ubl2luop3tj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180620.9644 915dse8pjr1hik5ubl2luop3tj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180620.9657 915dse8pjr1hik5ubl2luop3tj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676061491267606c1cdd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180620.9890 915dse8pjr1hik5ubl2luop3tj Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180620.9924 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180620.9941 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180620.9965 915dse8pjr1hik5ubl2luop3tj Query : select 'normal' from dummy
20241216@180620.9980 915dse8pjr1hik5ubl2luop3tj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676061491267606c1cdd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2479,101621,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180621.2530 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180621.2570 915dse8pjr1hik5ubl2luop3tj Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241216@180621.2800 915dse8pjr1hik5ubl2luop3tj 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'
20241216@180621.2960 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.3150 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.3440 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.3590 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.3690 915dse8pjr1hik5ubl2luop3tj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180621.3990 915dse8pjr1hik5ubl2luop3tj Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241216@180621.4130 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.4280 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.4400 915dse8pjr1hik5ubl2luop3tj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676067559167606c1d0a','aut676061491267606c1cdd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180621.4440 915dse8pjr1hik5ubl2luop3tj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.4600 915dse8pjr1hik5ubl2luop3tj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.4890 915dse8pjr1hik5ubl2luop3tj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676067559167606c1d0a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut676061491267606c1cdd' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180621.7020 915dse8pjr1hik5ubl2luop3tj Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676061491267606c1cdd','2408650','wait',39,'adm09112754980.682000002')
20241216@180621.7800 915dse8pjr1hik5ubl2luop3tj Query : use flama_phc
20241216@180621.7840 915dse8pjr1hik5ubl2luop3tj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180621.8170 915dse8pjr1hik5ubl2luop3tj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4009';
20241216@180621.8590 915dse8pjr1hik5ubl2luop3tj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4009';
20241216@180621.9310 915dse8pjr1hik5ubl2luop3tj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4009';
20241216@180621.9660 915dse8pjr1hik5ubl2luop3tj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4009';
20241216@180621.1544 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180621.1555 9gssh8sbke4ic69d3m9a5i1ldh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180621.1637 9gssh8sbke4ic69d3m9a5i1ldh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4010';
20241216@180621.1711 9gssh8sbke4ic69d3m9a5i1ldh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4010';
20241216@180621.1795 9gssh8sbke4ic69d3m9a5i1ldh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4010';
20241216@180621.1829 9gssh8sbke4ic69d3m9a5i1ldh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4010';
20241216@180621.1888 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.1891 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180621.1971 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.1974 9gssh8sbke4ic69d3m9a5i1ldh Query : select no, estab,szadrsdesc from szadrs where u_coddest=8548
20241216@180621.2056 9gssh8sbke4ic69d3m9a5i1ldh 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'
20241216@180621.2077 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408651 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241216@180621.3533 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241216@180621.3561 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408651 and bi.ref ='324.2330.00.1' and bi.lordem =2
20241216@180621.3896 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.3900 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180621.3938 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.3942 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180621.3972 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.3975 9gssh8sbke4ic69d3m9a5i1ldh 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')
20241216@180621.4006 9gssh8sbke4ic69d3m9a5i1ldh 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
20241216@180621.4043 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.4046 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241216@180621.4097 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.4100 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180621.4133 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.4137 9gssh8sbke4ic69d3m9a5i1ldh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180621.4181 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.4184 9gssh8sbke4ic69d3m9a5i1ldh Query : select szadrsstamp valor from szadrs where szadrsdesc='jom- maia ( nova loja)'
20241216@180621.4236 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.4239 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from td where ndoc = 39
20241216@180621.4251 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180621.4266 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.4299 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180621.4319 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.4334 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180621.4364 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.4378 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180621.4391 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180621.4460 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180621.4473 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.4490 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180621.4506 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676066226167606c1d6b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180621.4746 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.4766 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180621.4799 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180621.4814 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180621.4829 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180621.4843 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180621.4856 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180621.4869 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180621.4881 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676066226167606c1d6b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180621.5136 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180621.5166 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.5185 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180621.5214 9gssh8sbke4ic69d3m9a5i1ldh Query : select 'normal' from dummy
20241216@180621.5232 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676066226167606c1d6b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2480,101621,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180621.5534 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.5537 9gssh8sbke4ic69d3m9a5i1ldh Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241216@180621.5560 9gssh8sbke4ic69d3m9a5i1ldh 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'
20241216@180621.5575 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.5592 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.5618 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.5634 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.5643 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180621.5656 9gssh8sbke4ic69d3m9a5i1ldh Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241216@180621.5669 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.5684 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.5695 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676068833167606c1d8a','aut676066226167606c1d6b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180621.5700 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.5715 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.5762 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676068833167606c1d8a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut676066226167606c1d6b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180621.5985 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.5988 9gssh8sbke4ic69d3m9a5i1ldh Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241216@180621.6009 9gssh8sbke4ic69d3m9a5i1ldh 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.2330.00.1'
20241216@180621.6024 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.6040 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.6068 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.6101 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.6110 9gssh8sbke4ic69d3m9a5i1ldh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180621.6122 9gssh8sbke4ic69d3m9a5i1ldh Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241216@180621.6135 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.6149 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.6161 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676062382667606c1d95','aut676066226167606c1d6b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180621.6166 9gssh8sbke4ic69d3m9a5i1ldh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.6180 9gssh8sbke4ic69d3m9a5i1ldh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.6207 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676062382667606c1d95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut676066226167606c1d6b' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241216@180621.6441 9gssh8sbke4ic69d3m9a5i1ldh Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676066226167606c1d6b','2408651','wait',39,'adm09112754980.682000002')
20241216@180621.6520 9gssh8sbke4ic69d3m9a5i1ldh Query : use flama_phc
20241216@180621.6523 9gssh8sbke4ic69d3m9a5i1ldh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180621.6555 9gssh8sbke4ic69d3m9a5i1ldh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4010';
20241216@180621.6596 9gssh8sbke4ic69d3m9a5i1ldh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4010';
20241216@180621.6661 9gssh8sbke4ic69d3m9a5i1ldh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4010';
20241216@180621.6696 9gssh8sbke4ic69d3m9a5i1ldh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4010';
20241216@180621.7210 m8shgacna2p9qkr59uep546k5a Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180621.7223 m8shgacna2p9qkr59uep546k5a Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180621.7289 m8shgacna2p9qkr59uep546k5a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4011';
20241216@180621.7355 m8shgacna2p9qkr59uep546k5a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4011';
20241216@180621.7423 m8shgacna2p9qkr59uep546k5a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4011';
20241216@180621.7456 m8shgacna2p9qkr59uep546k5a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4011';
20241216@180621.7515 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.7518 m8shgacna2p9qkr59uep546k5a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180621.7586 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.7589 m8shgacna2p9qkr59uep546k5a Query : select no, estab,szadrsdesc from szadrs where u_coddest=1474
20241216@180621.7698 m8shgacna2p9qkr59uep546k5a 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'
20241216@180621.7720 m8shgacna2p9qkr59uep546k5a Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408653 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241216@180621.8024 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8027 m8shgacna2p9qkr59uep546k5a Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180621.8064 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8067 m8shgacna2p9qkr59uep546k5a Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180621.8096 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8099 m8shgacna2p9qkr59uep546k5a 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')
20241216@180621.8130 m8shgacna2p9qkr59uep546k5a 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
20241216@180621.8166 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8169 m8shgacna2p9qkr59uep546k5a Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241216@180621.8200 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8203 m8shgacna2p9qkr59uep546k5a Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180621.8235 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8238 m8shgacna2p9qkr59uep546k5a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180621.8280 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8282 m8shgacna2p9qkr59uep546k5a Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - corroios'
20241216@180621.8330 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.8333 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from td where ndoc = 39
20241216@180621.8345 m8shgacna2p9qkr59uep546k5a Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180621.8377 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.8393 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180621.8413 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.8429 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180621.8459 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.8474 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180621.8487 m8shgacna2p9qkr59uep546k5a Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180621.8547 m8shgacna2p9qkr59uep546k5a Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180621.8560 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.8576 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180621.8591 m8shgacna2p9qkr59uep546k5a Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676061493367606c1dcf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180621.8747 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.8764 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180621.8801 m8shgacna2p9qkr59uep546k5a Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180621.8814 m8shgacna2p9qkr59uep546k5a Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180621.8826 m8shgacna2p9qkr59uep546k5a Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180621.8839 m8shgacna2p9qkr59uep546k5a Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180621.8853 m8shgacna2p9qkr59uep546k5a Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180621.8866 m8shgacna2p9qkr59uep546k5a Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180621.8877 m8shgacna2p9qkr59uep546k5a Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676061493367606c1dcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180621.9099 m8shgacna2p9qkr59uep546k5a Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180621.9148 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.9164 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180621.9186 m8shgacna2p9qkr59uep546k5a Query : select 'normal' from dummy
20241216@180621.9201 m8shgacna2p9qkr59uep546k5a Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676061493367606c1dcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2481,101621,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180621.9629 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180621.9632 m8shgacna2p9qkr59uep546k5a Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241216@180621.9655 m8shgacna2p9qkr59uep546k5a 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'
20241216@180621.9669 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.9685 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.9713 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.9729 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.9738 m8shgacna2p9qkr59uep546k5a Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180621.9751 m8shgacna2p9qkr59uep546k5a Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241216@180621.9765 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.9780 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180621.9793 m8shgacna2p9qkr59uep546k5a Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676065608167606c1dee','aut676061493367606c1dcf' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180621.9798 m8shgacna2p9qkr59uep546k5a Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180621.9813 m8shgacna2p9qkr59uep546k5a Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180621.9843 m8shgacna2p9qkr59uep546k5a Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676065608167606c1dee',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut676061493367606c1dcf' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180622.8800 m8shgacna2p9qkr59uep546k5a Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676061493367606c1dcf','2408653','wait',39,'adm09112754980.682000002')
20241216@180622.2960 m8shgacna2p9qkr59uep546k5a Query : use flama_phc
20241216@180622.3410 m8shgacna2p9qkr59uep546k5a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180622.4770 m8shgacna2p9qkr59uep546k5a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4011';
20241216@180622.6420 m8shgacna2p9qkr59uep546k5a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4011';
20241216@180622.7190 m8shgacna2p9qkr59uep546k5a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4011';
20241216@180622.7610 m8shgacna2p9qkr59uep546k5a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4011';
20241216@180622.1586 2i2tto5k1m5nlmcb7r01bqpgi4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180622.1597 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180622.1665 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4012';
20241216@180622.1730 2i2tto5k1m5nlmcb7r01bqpgi4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4012';
20241216@180622.1800 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4012';
20241216@180622.1853 2i2tto5k1m5nlmcb7r01bqpgi4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4012';
20241216@180622.1911 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.1915 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180622.1980 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.1983 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9128
20241216@180622.2070 2i2tto5k1m5nlmcb7r01bqpgi4 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'
20241216@180622.2093 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408657 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241216@180622.2437 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2440 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180622.2476 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2479 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180622.2508 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2511 2i2tto5k1m5nlmcb7r01bqpgi4 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')
20241216@180622.2538 2i2tto5k1m5nlmcb7r01bqpgi4 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
20241216@180622.2580 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2584 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241216@180622.2615 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2619 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180622.2649 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2651 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180622.2707 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2710 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - v. castelo (nova)'
20241216@180622.2764 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.2767 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from td where ndoc = 39
20241216@180622.2779 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180622.2793 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.2814 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180622.2833 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.2848 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180622.2898 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.2916 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180622.2929 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180622.3134 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241216@180622.3149 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.3168 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180622.3185 2i2tto5k1m5nlmcb7r01bqpgi4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676064007367606c1e47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241216@180622.3359 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.3377 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180622.3432 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241216@180622.3446 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241216@180622.3475 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241216@180622.3487 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241216@180622.3500 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241216@180622.3512 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241216@180622.3525 2i2tto5k1m5nlmcb7r01bqpgi4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676064007367606c1e47',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241216@180622.3784 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 fno valor from wsftdata order by fno desc
20241216@180622.3818 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.3834 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180622.3859 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 'normal' from dummy
20241216@180622.3874 2i2tto5k1m5nlmcb7r01bqpgi4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676064007367606c1e47',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2482,101621,0,'2024-12-16',39,'euro',0,0,2024 ,?,?)
20241216@180622.4149 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.4152 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241216@180622.4176 2i2tto5k1m5nlmcb7r01bqpgi4 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'
20241216@180622.4190 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.4207 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180622.4233 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.4249 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180622.4277 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241216@180622.4290 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241216@180622.4303 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.4318 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241216@180622.4330 2i2tto5k1m5nlmcb7r01bqpgi4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676068610267606c1e69','aut676064007367606c1e47' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241216@180622.4334 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.4348 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241216@180622.4377 2i2tto5k1m5nlmcb7r01bqpgi4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676068610267606c1e69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut676064007367606c1e47' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241216@180622.4598 2i2tto5k1m5nlmcb7r01bqpgi4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676064007367606c1e47','2408657','wait',39,'adm09112754980.682000002')
20241216@180622.4689 2i2tto5k1m5nlmcb7r01bqpgi4 Query : use flama_phc
20241216@180622.4692 2i2tto5k1m5nlmcb7r01bqpgi4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241216@180622.4727 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4012';
20241216@180622.4767 2i2tto5k1m5nlmcb7r01bqpgi4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4012';
20241216@180622.4821 2i2tto5k1m5nlmcb7r01bqpgi4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4012';
20241216@180622.4857 2i2tto5k1m5nlmcb7r01bqpgi4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4012';
20241216@180622.5491 s722ql0gfnsp3rmv7oqd38vtf9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241216@180622.5503 s722ql0gfnsp3rmv7oqd38vtf9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241216@180622.5570 s722ql0gfnsp3rmv7oqd38vtf9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4013';
20241216@180622.5632 s722ql0gfnsp3rmv7oqd38vtf9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4013';
20241216@180622.5701 s722ql0gfnsp3rmv7oqd38vtf9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4013';
20241216@180622.5753 s722ql0gfnsp3rmv7oqd38vtf9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4013';
20241216@180622.5813 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.5816 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241216@180622.5879 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.5882 s722ql0gfnsp3rmv7oqd38vtf9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2374
20241216@180622.5973 s722ql0gfnsp3rmv7oqd38vtf9 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'
20241216@180622.5994 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2086 and bo.obrano = 2408659 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241216@180622.6379 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6382 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241216@180622.6418 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6422 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 1 valor from td where td.ndoc = 39
20241216@180622.6456 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6459 s722ql0gfnsp3rmv7oqd38vtf9 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')
20241216@180622.6488 s722ql0gfnsp3rmv7oqd38vtf9 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
20241216@180622.6524 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6527 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241216@180622.6557 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6560 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241216@180622.6590 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6593 s722ql0gfnsp3rmv7oqd38vtf9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241216@180622.6635 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6638 s722ql0gfnsp3rmv7oqd38vtf9 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - vila real'
20241216@180622.6690 s722ql0gfnsp3rmv7oqd38vtf9 Query : use flama_phc
20241216@180622.6693 s722ql0gfnsp3rmv7oqd38vtf9 Query : select 1 valor from td where ndoc = 39
20241216@180622.6708 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241216@180622.6723 s722ql0gfnsp3rmv7oqd38vtf9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.6744 s722ql0gfnsp3rmv7oqd38vtf9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241216@180622.6788 s722ql0gfnsp3rmv7oqd38vtf9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.6807 s722ql0gfnsp3rmv7oqd38vtf9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241216@180622.7049 s722ql0gfnsp3rmv7oqd38vtf9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241216@180622.7267 s722ql0gfnsp3rmv7oqd38vtf9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241216@180622.7281 s722ql0gfnsp3rmv7oqd38vtf9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
