20241002@182453.6235 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20241002@182453.6382 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.681.00.01'
20241002@182453.6401 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.422.00.07'
20241002@182453.6565 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20241002@182453.6717 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241002@182453.6859 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.4320.00.1'
20241002@182453.6880 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20241002@182453.7044 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1608.00.1'
20241002@182453.7063 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20241002@182453.7205 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241002@182453.7339 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20241002@182453.7463 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1405.00.1'
20241002@182453.7583 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1706.00.1'
20241002@182453.7741 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20241002@182453.7884 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.497.00.01'
20241002@182453.7904 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5540.00.1'
20241002@182453.8032 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5540.00.1'
20241002@182453.8053 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20241002@182453.8183 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1884.00.1'
20241002@182453.8518 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1884.00.1'
20241002@182453.8537 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1716.00.1'
20241002@182453.8703 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1256.00.1'
20241002@182453.8840 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1266.00.1'
20241002@182453.8999 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241002@182453.9136 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241002@182453.9155 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241002@182453.9175 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20241002@182453.9193 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1690.00.1'
20241002@182453.9212 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20241002@182453.9347 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4900.00.1'
20241002@182453.9492 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20241002@182453.9618 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1462.00.1'
20241002@182453.9638 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20241002@182453.9764 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20241002@182454.1035 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.642.00.01'
20241002@182454.1425 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1578.00.1'
20241002@182454.1595 h5pqois944s02j6p5speub21n8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4901.00.1'
20241002@182454.1737 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.1740 h5pqois944s02j6p5speub21n8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241002@182454.1774 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.1777 h5pqois944s02j6p5speub21n8 Query : select top 1 1 valor from td where td.ndoc = 39
20241002@182454.1807 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.1811 h5pqois944s02j6p5speub21n8 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')
20241002@182454.1838 h5pqois944s02j6p5speub21n8 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
20241002@182454.1874 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.1876 h5pqois944s02j6p5speub21n8 Query : select top 1 ~inactivo valor from cl where no = '101889' and estab = 0 order by inactivo desc
20241002@182454.2019 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.2021 h5pqois944s02j6p5speub21n8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241002@182454.2051 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.2053 h5pqois944s02j6p5speub21n8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241002@182454.2094 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.2097 h5pqois944s02j6p5speub21n8 Query : select szadrsstamp valor from szadrs where szadrsdesc='cooplecnorte,crl'
20241002@182454.2146 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.2149 h5pqois944s02j6p5speub21n8 Query : select 1 valor from td where ndoc = 39
20241002@182454.2160 h5pqois944s02j6p5speub21n8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241002@182454.2174 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.2192 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241002@182454.2211 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.2226 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241002@182454.2254 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.2268 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241002@182454.2280 h5pqois944s02j6p5speub21n8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241002@182454.2344 h5pqois944s02j6p5speub21n8 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241002@182454.2356 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.2371 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241002@182454.2386 h5pqois944s02j6p5speub21n8 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fd81983166fd81e637' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241002@182454.2561 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.2576 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241002@182454.2805 h5pqois944s02j6p5speub21n8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241002@182454.2817 h5pqois944s02j6p5speub21n8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241002@182454.2829 h5pqois944s02j6p5speub21n8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241002@182454.2842 h5pqois944s02j6p5speub21n8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241002@182454.2856 h5pqois944s02j6p5speub21n8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241002@182454.2868 h5pqois944s02j6p5speub21n8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241002@182454.2879 h5pqois944s02j6p5speub21n8 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fd81983166fd81e637',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241002@182454.3142 h5pqois944s02j6p5speub21n8 Query : select top 1 fno valor from wsftdata order by fno desc
20241002@182454.3163 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.3180 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241002@182454.3202 h5pqois944s02j6p5speub21n8 Query : select 'normal' from dummy
20241002@182454.3216 h5pqois944s02j6p5speub21n8 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fd81983166fd81e637',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1057,101889,0,'2024-10-02',39,'euro',0,0,2024 ,?,?)
20241002@182454.3514 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.3516 h5pqois944s02j6p5speub21n8 Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241002@182454.3540 h5pqois944s02j6p5speub21n8 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.969.00.01'
20241002@182454.3688 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.3704 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.3730 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.3745 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.3753 h5pqois944s02j6p5speub21n8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241002@182454.3766 h5pqois944s02j6p5speub21n8 Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241002@182454.4131 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.4149 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.4161 h5pqois944s02j6p5speub21n8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fd80047066fd81e664','aut66fd81983166fd81e637' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241002@182454.4165 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.4180 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.4208 h5pqois944s02j6p5speub21n8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fd80047066fd81e664',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66fd81983166fd81e637' ,0,0 ,2,23.00,10000,?,?,?,?)
20241002@182454.4469 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.4472 h5pqois944s02j6p5speub21n8 Query : select st.usalote valor from st where st.ref = '324.727.00.01'
20241002@182454.4493 h5pqois944s02j6p5speub21n8 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.727.00.01'
20241002@182454.4639 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.4655 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.4680 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.4697 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.4705 h5pqois944s02j6p5speub21n8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241002@182454.4717 h5pqois944s02j6p5speub21n8 Query : select sestamp valor from se where ref ='324.727.00.01' and lote = 'r230053420'
20241002@182454.4727 h5pqois944s02j6p5speub21n8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.4742 h5pqois944s02j6p5speub21n8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.4753 h5pqois944s02j6p5speub21n8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fd80835066fd81e673','aut66fd81983166fd81e637' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241002@182454.4770 h5pqois944s02j6p5speub21n8 Query : use flama_phc
20241002@182454.4773 h5pqois944s02j6p5speub21n8 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241002@182454.4847 h5pqois944s02j6p5speub21n8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2384';
20241002@182454.4878 h5pqois944s02j6p5speub21n8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2384';
20241002@182454.5403 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241002@182454.5414 3nf4eqgotrjus0j9tu7dkap3cn Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241002@182454.5466 3nf4eqgotrjus0j9tu7dkap3cn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2385';
20241002@182454.5522 3nf4eqgotrjus0j9tu7dkap3cn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2385';
20241002@182454.5576 3nf4eqgotrjus0j9tu7dkap3cn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2385';
20241002@182454.5602 3nf4eqgotrjus0j9tu7dkap3cn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2385';
20241002@182454.5660 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.5663 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241002@182454.5726 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.5729 3nf4eqgotrjus0j9tu7dkap3cn Query : select no, estab,szadrsdesc from szadrs where u_coddest=2448
20241002@182454.5770 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4980.00.1'
20241002@182454.5943 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20241002@182454.5965 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.969.00.01'
20241002@182454.5986 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.5989 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241002@182454.6023 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.6026 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 1 valor from td where td.ndoc = 39
20241002@182454.6058 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.6062 3nf4eqgotrjus0j9tu7dkap3cn 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')
20241002@182454.6094 3nf4eqgotrjus0j9tu7dkap3cn 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
20241002@182454.6127 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.6149 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 ~inactivo valor from cl where no = '101889' and estab = 0 order by inactivo desc
20241002@182454.6180 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.6183 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241002@182454.6211 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.6215 3nf4eqgotrjus0j9tu7dkap3cn Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241002@182454.6257 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.6259 3nf4eqgotrjus0j9tu7dkap3cn Query : select szadrsstamp valor from szadrs where szadrsdesc='cooplecnorte,crl'
20241002@182454.6305 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.6318 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from td where ndoc = 39
20241002@182454.6330 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241002@182454.6344 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.6362 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241002@182454.6381 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.6396 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241002@182454.6424 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.6439 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241002@182454.6452 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241002@182454.6519 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241002@182454.6533 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.6548 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241002@182454.6563 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fd81838766fd81e69d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241002@182454.6742 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.6757 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241002@182454.6790 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241002@182454.6801 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241002@182454.6813 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241002@182454.6824 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241002@182454.6835 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241002@182454.6846 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241002@182454.6858 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fd81838766fd81e69d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241002@182454.7112 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 fno valor from wsftdata order by fno desc
20241002@182454.7137 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.7153 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241002@182454.7176 3nf4eqgotrjus0j9tu7dkap3cn Query : select 'normal' from dummy
20241002@182454.7194 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fd81838766fd81e69d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1057,101889,0,'2024-10-02',39,'euro',0,0,2024 ,?,?)
20241002@182454.7496 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.7500 3nf4eqgotrjus0j9tu7dkap3cn Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241002@182454.7521 3nf4eqgotrjus0j9tu7dkap3cn 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.4980.00.1'
20241002@182454.7669 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.7685 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.7709 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.7724 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.7733 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241002@182454.7746 3nf4eqgotrjus0j9tu7dkap3cn Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r2301092100a'
20241002@182454.7759 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.7774 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.7785 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fd87580166fd81e6bd','aut66fd81838766fd81e69d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241002@182454.7790 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.7805 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.7834 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fd87580166fd81e6bd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fd81838766fd81e69d' ,0,0 ,2,23.00,10000,?,?,?,?)
20241002@182454.8087 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.8090 3nf4eqgotrjus0j9tu7dkap3cn Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241002@182454.8110 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.969.00.01'
20241002@182454.8123 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8138 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.8163 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8178 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.8186 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241002@182454.8219 3nf4eqgotrjus0j9tu7dkap3cn Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241002@182454.8233 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8248 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.8259 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fd86034266fd81e6c9','aut66fd81838766fd81e69d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241002@182454.8263 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8278 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.8307 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fd86034266fd81e6c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66fd81838766fd81e69d' ,0,0 ,2,23.00,20000,?,?,?,?)
20241002@182454.8572 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.8575 3nf4eqgotrjus0j9tu7dkap3cn Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241002@182454.8598 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.969.00.01'
20241002@182454.8612 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8629 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.8657 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8672 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.8680 3nf4eqgotrjus0j9tu7dkap3cn Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241002@182454.8694 3nf4eqgotrjus0j9tu7dkap3cn Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241002@182454.8707 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8721 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182454.8733 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fd82198366fd81e6d4','aut66fd81838766fd81e69d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241002@182454.8737 3nf4eqgotrjus0j9tu7dkap3cn Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182454.8752 3nf4eqgotrjus0j9tu7dkap3cn Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182454.8780 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fd82198366fd81e6d4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66fd81838766fd81e69d' ,0,0 ,2,23.00,30000,?,?,?,?)
20241002@182454.9049 3nf4eqgotrjus0j9tu7dkap3cn Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fd81838766fd81e69d','2406402','wait',39,'adm09112754980.682000002')
20241002@182454.9125 3nf4eqgotrjus0j9tu7dkap3cn Query : use flama_phc
20241002@182454.9128 3nf4eqgotrjus0j9tu7dkap3cn Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241002@182454.9160 3nf4eqgotrjus0j9tu7dkap3cn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2385';
20241002@182454.9193 3nf4eqgotrjus0j9tu7dkap3cn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2385';
20241002@182454.9236 3nf4eqgotrjus0j9tu7dkap3cn Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2385';
20241002@182454.9267 3nf4eqgotrjus0j9tu7dkap3cn Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2385';
20241002@182454.9802 aqnlrcmtgmr68thkpg658b5qua Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241002@182454.9815 aqnlrcmtgmr68thkpg658b5qua Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241002@182454.9874 aqnlrcmtgmr68thkpg658b5qua Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2386';
20241002@182454.9929 aqnlrcmtgmr68thkpg658b5qua Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2386';
20241002@182454.9984 aqnlrcmtgmr68thkpg658b5qua Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2386';
20241002@182455.9000 aqnlrcmtgmr68thkpg658b5qua Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2386';
20241002@182455.6100 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.6400 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241002@182455.1260 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.1290 aqnlrcmtgmr68thkpg658b5qua Query : select no, estab,szadrsdesc from szadrs where u_coddest=886
20241002@182455.2120 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9902.00.1'
20241002@182455.2330 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.2360 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241002@182455.2720 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.2750 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 1 valor from td where td.ndoc = 39
20241002@182455.3060 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.3090 aqnlrcmtgmr68thkpg658b5qua 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')
20241002@182455.3360 aqnlrcmtgmr68thkpg658b5qua 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
20241002@182455.3750 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.3780 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241002@182455.4070 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.4100 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241002@182455.4400 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.4430 aqnlrcmtgmr68thkpg658b5qua Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241002@182455.4830 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.4860 aqnlrcmtgmr68thkpg658b5qua Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda coimbra'
20241002@182455.5330 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.5350 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from td where ndoc = 39
20241002@182455.5480 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241002@182455.5620 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.5780 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241002@182455.5980 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.6120 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241002@182455.6410 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.6560 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241002@182455.6680 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241002@182455.7350 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241002@182455.7480 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.7620 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241002@182455.7780 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fd87934966fd81e710' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241002@182455.9640 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.9810 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241002@182455.1014 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241002@182455.1026 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241002@182455.1037 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241002@182455.1049 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241002@182455.1060 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241002@182455.1072 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241002@182455.1082 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fd87934966fd81e710',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241002@182455.1326 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 fno valor from wsftdata order by fno desc
20241002@182455.1348 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.1445 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241002@182455.1469 aqnlrcmtgmr68thkpg658b5qua Query : select 'normal' from dummy
20241002@182455.1483 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fd87934966fd81e710',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1058,101621,0,'2024-10-02',39,'euro',0,0,2024 ,?,?)
20241002@182455.2745 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.2748 aqnlrcmtgmr68thkpg658b5qua Query : select st.usalote valor from st where st.ref = '328.9902.00.1'
20241002@182455.2771 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9902.00.1'
20241002@182455.2785 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.2801 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182455.2827 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.2843 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182455.2853 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241002@182455.2866 aqnlrcmtgmr68thkpg658b5qua Query : select sestamp valor from se where ref ='328.9902.00.1' and lote = 'r2300777100a'
20241002@182455.2880 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.2897 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182455.2910 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fd89171266fd81e746','aut66fd87934966fd81e710' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241002@182455.2915 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.2931 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182455.2962 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fd89171266fd81e746',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66fd87934966fd81e710' ,0,0 ,2,23.00,10000,?,?,?,?)
20241002@182455.3467 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.3531 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182455.3556 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.3572 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182455.3580 aqnlrcmtgmr68thkpg658b5qua Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241002@182455.3595 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.3610 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241002@182455.3621 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fd85131266fd81e757','aut66fd87934966fd81e710' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241002@182455.3626 aqnlrcmtgmr68thkpg658b5qua Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241002@182455.3640 aqnlrcmtgmr68thkpg658b5qua Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241002@182455.3666 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66fd85131266fd81e757',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66fd87934966fd81e710' ,0,0 ,2,23.00,20000,?,?,?)
20241002@182455.3946 aqnlrcmtgmr68thkpg658b5qua Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fd87934966fd81e710','2406403','wait',39,'adm09112754980.682000002')
20241002@182455.4015 aqnlrcmtgmr68thkpg658b5qua Query : use flama_phc
20241002@182455.4018 aqnlrcmtgmr68thkpg658b5qua Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241002@182455.4047 aqnlrcmtgmr68thkpg658b5qua Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2386';
20241002@182455.4077 aqnlrcmtgmr68thkpg658b5qua Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2386';
20241002@182455.4120 aqnlrcmtgmr68thkpg658b5qua Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2386';
20241002@182455.4144 aqnlrcmtgmr68thkpg658b5qua Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2386';

20241003@102015.6983 q98tndihdo92m0vhn8kd3p9aqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2387';
20241003@102015.7047 q98tndihdo92m0vhn8kd3p9aqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2387';
20241003@102015.7076 q98tndihdo92m0vhn8kd3p9aqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2387';
20241003@102015.7129 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.7133 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241003@102015.7256 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.7266 q98tndihdo92m0vhn8kd3p9aqk Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241003@102015.7358 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2224.00.1'
20241003@102015.7533 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.7536 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241003@102015.7743 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.7746 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 1 valor from td where td.ndoc = 39
20241003@102015.7846 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.7850 q98tndihdo92m0vhn8kd3p9aqk 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')
20241003@102015.7924 q98tndihdo92m0vhn8kd3p9aqk 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
20241003@102015.8120 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.8123 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241003@102015.8263 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.8267 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241003@102015.8367 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.8370 q98tndihdo92m0vhn8kd3p9aqk Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241003@102015.8444 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.8447 q98tndihdo92m0vhn8kd3p9aqk Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241003@102015.8493 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102015.8496 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from td where ndoc = 39
20241003@102015.8573 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241003@102015.8711 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102015.9024 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102015.9108 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102015.9124 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102015.9154 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102015.9168 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102015.9182 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102015.9382 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102015.9479 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102015.9495 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102015.9541 q98tndihdo92m0vhn8kd3p9aqk Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fe62698266fe61cfe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241003@102016.9140 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.9360 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102016.9740 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241003@102016.1080 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241003@102016.1173 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241003@102016.1259 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241003@102016.1339 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241003@102016.1413 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241003@102016.1482 q98tndihdo92m0vhn8kd3p9aqk Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fe62698266fe61cfe0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241003@102016.2162 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 fno valor from wsftdata order by fno desc
20241003@102016.2288 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.2305 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102016.2330 q98tndihdo92m0vhn8kd3p9aqk Query : select 'normal' from dummy
20241003@102016.2382 q98tndihdo92m0vhn8kd3p9aqk Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fe62698266fe61cfe0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1059,102943,0,'2024-10-03',39,'euro',0,0,2024 ,?,?)
20241003@102016.3552 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102016.3556 q98tndihdo92m0vhn8kd3p9aqk Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20241003@102016.3711 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2224.00.1'
20241003@102016.3861 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.3878 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102016.3904 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.3919 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102016.3928 q98tndihdo92m0vhn8kd3p9aqk Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241003@102016.3971 q98tndihdo92m0vhn8kd3p9aqk Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20241003@102016.4031 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.4046 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102016.4059 q98tndihdo92m0vhn8kd3p9aqk Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fe63122466fe61d062','aut66fe62698266fe61cfe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241003@102016.4120 q98tndihdo92m0vhn8kd3p9aqk Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.4138 q98tndihdo92m0vhn8kd3p9aqk Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102016.4170 q98tndihdo92m0vhn8kd3p9aqk Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fe63122466fe61d062',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66fe62698266fe61cfe0' ,0,0 ,2,23.00,10000,?,?,?,?)
20241003@102016.4742 q98tndihdo92m0vhn8kd3p9aqk Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fe62698266fe61cfe0','2406407','wait',39,'adm09112754980.682000002')
20241003@102016.4830 q98tndihdo92m0vhn8kd3p9aqk Query : use flama_phc
20241003@102016.4833 q98tndihdo92m0vhn8kd3p9aqk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241003@102016.4863 q98tndihdo92m0vhn8kd3p9aqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2387';
20241003@102016.4895 q98tndihdo92m0vhn8kd3p9aqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2387';
20241003@102016.4936 q98tndihdo92m0vhn8kd3p9aqk Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2387';
20241003@102016.4962 q98tndihdo92m0vhn8kd3p9aqk Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2387';
20241003@102016.5610 h8cagcufgjdf16sab45qefk22r Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241003@102016.5622 h8cagcufgjdf16sab45qefk22r Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241003@102016.5679 h8cagcufgjdf16sab45qefk22r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2388';
20241003@102016.5743 h8cagcufgjdf16sab45qefk22r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2388';
20241003@102016.5797 h8cagcufgjdf16sab45qefk22r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2388';
20241003@102016.5826 h8cagcufgjdf16sab45qefk22r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2388';
20241003@102016.5884 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.5887 h8cagcufgjdf16sab45qefk22r Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241003@102016.5952 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.5955 h8cagcufgjdf16sab45qefk22r Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241003@102016.5996 h8cagcufgjdf16sab45qefk22r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2223.00.1'
20241003@102016.6156 h8cagcufgjdf16sab45qefk22r Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2223.00.1'
20241003@102016.6178 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.6182 h8cagcufgjdf16sab45qefk22r Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241003@102016.6218 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.6221 h8cagcufgjdf16sab45qefk22r Query : select top 1 1 valor from td where td.ndoc = 39
20241003@102016.6254 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.6257 h8cagcufgjdf16sab45qefk22r 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')
20241003@102016.7517 h8cagcufgjdf16sab45qefk22r 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
20241003@102016.7558 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.7563 h8cagcufgjdf16sab45qefk22r Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241003@102016.7593 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.7596 h8cagcufgjdf16sab45qefk22r Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241003@102016.7627 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.7631 h8cagcufgjdf16sab45qefk22r Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241003@102016.7678 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.7681 h8cagcufgjdf16sab45qefk22r Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241003@102016.7731 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.7734 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from td where ndoc = 39
20241003@102016.7747 h8cagcufgjdf16sab45qefk22r Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241003@102016.7762 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.7778 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102016.7797 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.7812 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102016.7841 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.7856 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102016.7868 h8cagcufgjdf16sab45qefk22r Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102016.7941 h8cagcufgjdf16sab45qefk22r Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102016.7954 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.7971 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102016.7988 h8cagcufgjdf16sab45qefk22r Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fe61644166fe61d0c0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241003@102016.8182 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.8202 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102016.8242 h8cagcufgjdf16sab45qefk22r Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241003@102016.8255 h8cagcufgjdf16sab45qefk22r Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241003@102016.8268 h8cagcufgjdf16sab45qefk22r Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241003@102016.8281 h8cagcufgjdf16sab45qefk22r Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241003@102016.8294 h8cagcufgjdf16sab45qefk22r Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241003@102016.8306 h8cagcufgjdf16sab45qefk22r Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241003@102016.8322 h8cagcufgjdf16sab45qefk22r Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fe61644166fe61d0c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241003@102016.8576 h8cagcufgjdf16sab45qefk22r Query : select top 1 fno valor from wsftdata order by fno desc
20241003@102016.8626 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.8649 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102016.8675 h8cagcufgjdf16sab45qefk22r Query : select 'normal' from dummy
20241003@102016.8692 h8cagcufgjdf16sab45qefk22r Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fe61644166fe61d0c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1060,102943,0,'2024-10-03',39,'euro',0,0,2024 ,?,?)
20241003@102016.8996 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102016.9000 h8cagcufgjdf16sab45qefk22r Query : select st.usalote valor from st where st.ref = '324.2223.00.1'
20241003@102016.9026 h8cagcufgjdf16sab45qefk22r 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.2223.00.1'
20241003@102016.9179 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.9195 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102016.9222 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.9236 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102016.9246 h8cagcufgjdf16sab45qefk22r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241003@102016.9258 h8cagcufgjdf16sab45qefk22r Query : select sestamp valor from se where ref ='324.2223.00.1' and lote = 'r2301281500a'
20241003@102016.9273 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102016.9346 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102016.9359 h8cagcufgjdf16sab45qefk22r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fe61967566fe61d0e2','aut66fe61644166fe61d0c0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241003@102016.9364 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.2100 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102017.3270 h8cagcufgjdf16sab45qefk22r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fe61967566fe61d0e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fe61644166fe61d0c0' ,0,0 ,2,23.00,10000,?,?,?,?)
20241003@102017.5890 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102017.5930 h8cagcufgjdf16sab45qefk22r Query : select st.usalote valor from st where st.ref = '324.2223.00.1'
20241003@102017.6210 h8cagcufgjdf16sab45qefk22r 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.2223.00.1'
20241003@102017.6370 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.6550 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102017.6820 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.6970 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102017.7060 h8cagcufgjdf16sab45qefk22r Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241003@102017.7290 h8cagcufgjdf16sab45qefk22r Query : select sestamp valor from se where ref ='324.2223.00.1' and lote = 'r2301281500a'
20241003@102017.7420 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.7590 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102017.7710 h8cagcufgjdf16sab45qefk22r Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fe69518766fe61d112','aut66fe61644166fe61d0c0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241003@102017.7760 h8cagcufgjdf16sab45qefk22r Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.7920 h8cagcufgjdf16sab45qefk22r Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102017.8240 h8cagcufgjdf16sab45qefk22r Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fe69518766fe61d112',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66fe61644166fe61d0c0' ,0,0 ,2,23.00,20000,?,?,?,?)
20241003@102017.1085 h8cagcufgjdf16sab45qefk22r Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fe61644166fe61d0c0','2406408','wait',39,'adm09112754980.682000002')
20241003@102017.1157 h8cagcufgjdf16sab45qefk22r Query : use flama_phc
20241003@102017.1161 h8cagcufgjdf16sab45qefk22r Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241003@102017.1193 h8cagcufgjdf16sab45qefk22r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2388';
20241003@102017.1225 h8cagcufgjdf16sab45qefk22r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2388';
20241003@102017.1268 h8cagcufgjdf16sab45qefk22r Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2388';
20241003@102017.1295 h8cagcufgjdf16sab45qefk22r Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2388';
20241003@102017.1878 t325ivtgbg91ej88tooa755dab Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241003@102017.1889 t325ivtgbg91ej88tooa755dab Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241003@102017.1942 t325ivtgbg91ej88tooa755dab Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2389';
20241003@102017.1999 t325ivtgbg91ej88tooa755dab Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2389';
20241003@102017.2053 t325ivtgbg91ej88tooa755dab Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2389';
20241003@102017.2081 t325ivtgbg91ej88tooa755dab Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2389';
20241003@102017.2130 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2134 t325ivtgbg91ej88tooa755dab Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241003@102017.2195 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2198 t325ivtgbg91ej88tooa755dab Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241003@102017.2240 t325ivtgbg91ej88tooa755dab Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20241003@102017.2408 t325ivtgbg91ej88tooa755dab Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2222.00.1'
20241003@102017.2430 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2433 t325ivtgbg91ej88tooa755dab Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241003@102017.2466 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2469 t325ivtgbg91ej88tooa755dab Query : select top 1 1 valor from td where td.ndoc = 39
20241003@102017.2498 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2501 t325ivtgbg91ej88tooa755dab 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')
20241003@102017.2528 t325ivtgbg91ej88tooa755dab 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
20241003@102017.2565 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2569 t325ivtgbg91ej88tooa755dab Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241003@102017.2603 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2606 t325ivtgbg91ej88tooa755dab Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241003@102017.2639 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2642 t325ivtgbg91ej88tooa755dab Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241003@102017.2684 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2687 t325ivtgbg91ej88tooa755dab Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241003@102017.2738 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.2741 t325ivtgbg91ej88tooa755dab Query : select 1 valor from td where ndoc = 39
20241003@102017.2752 t325ivtgbg91ej88tooa755dab Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241003@102017.2766 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.2781 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102017.2799 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.2814 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102017.2840 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.2855 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102017.2868 t325ivtgbg91ej88tooa755dab Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102017.2934 t325ivtgbg91ej88tooa755dab Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102017.2947 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.2962 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102017.2977 t325ivtgbg91ej88tooa755dab Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fe64542366fe61d146' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241003@102017.3179 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.3197 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102017.3229 t325ivtgbg91ej88tooa755dab Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241003@102017.3241 t325ivtgbg91ej88tooa755dab Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241003@102017.3253 t325ivtgbg91ej88tooa755dab Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241003@102017.3264 t325ivtgbg91ej88tooa755dab Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241003@102017.3276 t325ivtgbg91ej88tooa755dab Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241003@102017.3287 t325ivtgbg91ej88tooa755dab Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241003@102017.3301 t325ivtgbg91ej88tooa755dab Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fe64542366fe61d146',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241003@102017.3551 t325ivtgbg91ej88tooa755dab Query : select top 1 fno valor from wsftdata order by fno desc
20241003@102017.3572 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.3587 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102017.3609 t325ivtgbg91ej88tooa755dab Query : select 'normal' from dummy
20241003@102017.3624 t325ivtgbg91ej88tooa755dab Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fe64542366fe61d146',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1061,102943,0,'2024-10-03',39,'euro',0,0,2024 ,?,?)
20241003@102017.4373 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.4378 t325ivtgbg91ej88tooa755dab Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20241003@102017.4401 t325ivtgbg91ej88tooa755dab Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2222.00.1'
20241003@102017.4565 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.4581 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102017.4606 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.4620 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102017.4629 t325ivtgbg91ej88tooa755dab Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241003@102017.4640 t325ivtgbg91ej88tooa755dab Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301281400a'
20241003@102017.4653 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.4667 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102017.4677 t325ivtgbg91ej88tooa755dab Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fe66059066fe61d171','aut66fe64542366fe61d146' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241003@102017.4681 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.4695 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102017.5858 t325ivtgbg91ej88tooa755dab Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fe66059066fe61d171',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66fe64542366fe61d146' ,0,0 ,2,23.00,10000,?,?,?,?)
20241003@102017.6118 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.6120 t325ivtgbg91ej88tooa755dab Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20241003@102017.6140 t325ivtgbg91ej88tooa755dab Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2222.00.1'
20241003@102017.6155 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.6171 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102017.6196 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.6210 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102017.6219 t325ivtgbg91ej88tooa755dab Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241003@102017.6230 t325ivtgbg91ej88tooa755dab Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301281400a'
20241003@102017.6242 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.6256 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102017.6267 t325ivtgbg91ej88tooa755dab Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fe68617566fe61d198','aut66fe64542366fe61d146' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241003@102017.6271 t325ivtgbg91ej88tooa755dab Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.6285 t325ivtgbg91ej88tooa755dab Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102017.6314 t325ivtgbg91ej88tooa755dab Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fe68617566fe61d198',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fe64542366fe61d146' ,0,0 ,2,23.00,20000,?,?,?,?)
20241003@102017.7101 t325ivtgbg91ej88tooa755dab Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fe64542366fe61d146','2406409','wait',39,'adm09112754980.682000002')
20241003@102017.7672 t325ivtgbg91ej88tooa755dab Query : use flama_phc
20241003@102017.7675 t325ivtgbg91ej88tooa755dab Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241003@102017.7704 t325ivtgbg91ej88tooa755dab Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2389';
20241003@102017.7738 t325ivtgbg91ej88tooa755dab Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2389';
20241003@102017.7778 t325ivtgbg91ej88tooa755dab Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2389';
20241003@102017.7803 t325ivtgbg91ej88tooa755dab Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2389';
20241003@102017.8890 bq1qgmqisrk1noeckfmqhihkjp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241003@102017.8901 bq1qgmqisrk1noeckfmqhihkjp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241003@102017.8965 bq1qgmqisrk1noeckfmqhihkjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2390';
20241003@102017.9027 bq1qgmqisrk1noeckfmqhihkjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2390';
20241003@102017.9079 bq1qgmqisrk1noeckfmqhihkjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2390';
20241003@102017.9105 bq1qgmqisrk1noeckfmqhihkjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2390';
20241003@102017.9154 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9157 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241003@102017.9225 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9228 bq1qgmqisrk1noeckfmqhihkjp Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241003@102017.9271 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2221.00.1'
20241003@102017.9435 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9438 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241003@102017.9477 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9480 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 1 valor from td where td.ndoc = 39
20241003@102017.9509 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9512 bq1qgmqisrk1noeckfmqhihkjp 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')
20241003@102017.9542 bq1qgmqisrk1noeckfmqhihkjp 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
20241003@102017.9580 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9583 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241003@102017.9613 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9616 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241003@102017.9647 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9650 bq1qgmqisrk1noeckfmqhihkjp Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241003@102017.9691 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9694 bq1qgmqisrk1noeckfmqhihkjp Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241003@102017.9742 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102017.9745 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from td where ndoc = 39
20241003@102017.9758 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241003@102017.9775 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.9791 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102017.9811 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.9826 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102017.9855 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.9871 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102017.9883 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102017.9948 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241003@102017.9961 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102017.9975 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241003@102017.9994 bq1qgmqisrk1noeckfmqhihkjp Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fe62212966fe61d1f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241003@102018.3460 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102018.7930 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241003@102018.8310 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241003@102018.8460 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241003@102018.8610 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241003@102018.8740 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241003@102018.8870 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241003@102018.8990 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241003@102018.9110 bq1qgmqisrk1noeckfmqhihkjp Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fe62212966fe61d1f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241003@102018.1212 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 fno valor from wsftdata order by fno desc
20241003@102018.1237 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102018.1256 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241003@102018.1278 bq1qgmqisrk1noeckfmqhihkjp Query : select 'normal' from dummy
20241003@102018.1294 bq1qgmqisrk1noeckfmqhihkjp Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fe62212966fe61d1f1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1062,102943,0,'2024-10-03',39,'euro',0,0,2024 ,?,?)
20241003@102018.1618 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102018.1621 bq1qgmqisrk1noeckfmqhihkjp Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20241003@102018.1646 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2221.00.1'
20241003@102018.1795 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102018.1812 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102018.1845 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102018.1864 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102018.1873 bq1qgmqisrk1noeckfmqhihkjp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241003@102018.1885 bq1qgmqisrk1noeckfmqhihkjp Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20241003@102018.1903 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102018.1918 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241003@102018.1930 bq1qgmqisrk1noeckfmqhihkjp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fe66138966fe61d22e','aut66fe62212966fe61d1f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241003@102018.1935 bq1qgmqisrk1noeckfmqhihkjp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241003@102018.1951 bq1qgmqisrk1noeckfmqhihkjp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241003@102018.1998 bq1qgmqisrk1noeckfmqhihkjp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fe66138966fe61d22e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66fe62212966fe61d1f1' ,0,0 ,2,23.00,10000,?,?,?,?)
20241003@102018.2262 bq1qgmqisrk1noeckfmqhihkjp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fe62212966fe61d1f1','2406410','wait',39,'adm09112754980.682000002')
20241003@102018.2335 bq1qgmqisrk1noeckfmqhihkjp Query : use flama_phc
20241003@102018.2339 bq1qgmqisrk1noeckfmqhihkjp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241003@102018.2372 bq1qgmqisrk1noeckfmqhihkjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2390';
20241003@102018.2404 bq1qgmqisrk1noeckfmqhihkjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2390';
20241003@102018.2447 bq1qgmqisrk1noeckfmqhihkjp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2390';
20241003@102018.2472 bq1qgmqisrk1noeckfmqhihkjp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2390';
