20241001@181848.9725 4s9hncvn562dmqvu0modjc7oo0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181848.9743 4s9hncvn562dmqvu0modjc7oo0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181848.9772 4s9hncvn562dmqvu0modjc7oo0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181848.9788 4s9hncvn562dmqvu0modjc7oo0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181848.9798 4s9hncvn562dmqvu0modjc7oo0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181848.9811 4s9hncvn562dmqvu0modjc7oo0 Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2300567100a'
20241001@181848.9826 4s9hncvn562dmqvu0modjc7oo0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181848.9841 4s9hncvn562dmqvu0modjc7oo0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181848.9853 4s9hncvn562dmqvu0modjc7oo0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc22342366fc2ef8ef','aut66fc24893666fc2ef8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181848.9858 4s9hncvn562dmqvu0modjc7oo0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181848.9876 4s9hncvn562dmqvu0modjc7oo0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181848.9907 4s9hncvn562dmqvu0modjc7oo0 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc22342366fc2ef8ef',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc24893666fc2ef8ba' ,0,0 ,2,23.00,30000,?,?,?,?)
20241001@181849.1700 4s9hncvn562dmqvu0modjc7oo0 Query : use flama_phc
20241001@181849.1740 4s9hncvn562dmqvu0modjc7oo0 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241001@181849.1970 4s9hncvn562dmqvu0modjc7oo0 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241001@181849.2110 4s9hncvn562dmqvu0modjc7oo0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.2280 4s9hncvn562dmqvu0modjc7oo0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.2570 4s9hncvn562dmqvu0modjc7oo0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.2740 4s9hncvn562dmqvu0modjc7oo0 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.2840 4s9hncvn562dmqvu0modjc7oo0 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.2980 4s9hncvn562dmqvu0modjc7oo0 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r230050910'
20241001@181849.3080 4s9hncvn562dmqvu0modjc7oo0 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3270 4s9hncvn562dmqvu0modjc7oo0 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.3410 4s9hncvn562dmqvu0modjc7oo0 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc28147466fc2ef907','aut66fc24893666fc2ef8ba' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.3600 4s9hncvn562dmqvu0modjc7oo0 Query : use flama_phc
20241001@181849.3630 4s9hncvn562dmqvu0modjc7oo0 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241001@181849.3970 4s9hncvn562dmqvu0modjc7oo0 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2335';
20241001@181849.4290 4s9hncvn562dmqvu0modjc7oo0 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2335';
20241001@181849.9730 d86c79u3mvlef7fq4g56qagp89 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241001@181849.9850 d86c79u3mvlef7fq4g56qagp89 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241001@181849.1045 d86c79u3mvlef7fq4g56qagp89 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2336';
20241001@181849.1102 d86c79u3mvlef7fq4g56qagp89 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2336';
20241001@181849.1156 d86c79u3mvlef7fq4g56qagp89 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2336';
20241001@181849.1180 d86c79u3mvlef7fq4g56qagp89 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2336';
20241001@181849.1231 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1235 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241001@181849.1295 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1298 d86c79u3mvlef7fq4g56qagp89 Query : select no, estab,szadrsdesc from szadrs where u_coddest=634
20241001@181849.1383 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241001@181849.1402 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241001@181849.1421 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241001@181849.1439 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241001@181849.1458 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241001@181849.1476 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1480 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241001@181849.1510 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1513 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 1 valor from td where td.ndoc = 39
20241001@181849.1543 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1546 d86c79u3mvlef7fq4g56qagp89 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')
20241001@181849.1575 d86c79u3mvlef7fq4g56qagp89 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
20241001@181849.1610 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1613 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241001@181849.1643 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1646 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241001@181849.1675 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1678 d86c79u3mvlef7fq4g56qagp89 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241001@181849.1716 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1719 d86c79u3mvlef7fq4g56qagp89 Query : select szadrsstamp valor from szadrs where szadrsdesc='joaquim oliveira mendes,lda jom - covilhã'
20241001@181849.1765 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.1767 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from td where ndoc = 39
20241001@181849.1779 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241001@181849.1793 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.1810 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181849.1829 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.1844 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181849.1871 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.1885 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181849.1898 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181849.1963 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181849.1977 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.1993 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181849.2035 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fc21577466fc2ef92e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241001@181849.2218 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.2235 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181849.2268 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241001@181849.2280 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241001@181849.2292 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241001@181849.2303 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241001@181849.2315 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241001@181849.2326 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241001@181849.2337 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fc21577466fc2ef92e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241001@181849.2574 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 fno valor from wsftdata order by fno desc
20241001@181849.2594 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.2608 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181849.2632 d86c79u3mvlef7fq4g56qagp89 Query : select 'normal' from dummy
20241001@181849.2646 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fc21577466fc2ef92e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1027,101621,0,'2024-10-01',39,'euro',0,0,2024 ,?,?)
20241001@181849.2929 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.2933 d86c79u3mvlef7fq4g56qagp89 Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241001@181849.2953 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241001@181849.2970 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.2986 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.3013 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3028 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.3044 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.3056 d86c79u3mvlef7fq4g56qagp89 Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2300612200a'
20241001@181849.3087 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3104 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.3118 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc26116366fc2ef94b','aut66fc21577466fc2ef92e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.3122 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3136 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.3164 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc26116366fc2ef94b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66fc21577466fc2ef92e' ,0,0 ,2,23.00,10000,?,?,?,?)
20241001@181849.3430 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.3433 d86c79u3mvlef7fq4g56qagp89 Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241001@181849.3456 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2330.00.1'
20241001@181849.3474 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3494 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.3524 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3542 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.3550 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.3562 d86c79u3mvlef7fq4g56qagp89 Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241001@181849.3574 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3590 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.3601 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc23127366fc2ef957','aut66fc21577466fc2ef92e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.3606 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3621 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.3649 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc23127366fc2ef957',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc21577466fc2ef92e' ,0,0 ,2,23.00,20000,?,?,?,?)
20241001@181849.3907 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.3911 d86c79u3mvlef7fq4g56qagp89 Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241001@181849.3931 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241001@181849.3945 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.3961 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.3988 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.4004 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.4013 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.4030 d86c79u3mvlef7fq4g56qagp89 Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2300567100a'
20241001@181849.4044 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.4059 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.4071 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc27895966fc2ef962','aut66fc21577466fc2ef92e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.4078 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.4093 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.4132 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc27895966fc2ef962',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc21577466fc2ef92e' ,0,0 ,2,23.00,30000,?,?,?,?)
20241001@181849.4389 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.4392 d86c79u3mvlef7fq4g56qagp89 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241001@181849.4413 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241001@181849.4428 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.4445 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.4471 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.4487 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.4496 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.4508 d86c79u3mvlef7fq4g56qagp89 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r230050910'
20241001@181849.4517 d86c79u3mvlef7fq4g56qagp89 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.4532 d86c79u3mvlef7fq4g56qagp89 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.4544 d86c79u3mvlef7fq4g56qagp89 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc29792566fc2ef96e','aut66fc21577466fc2ef92e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.4562 d86c79u3mvlef7fq4g56qagp89 Query : use flama_phc
20241001@181849.4565 d86c79u3mvlef7fq4g56qagp89 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241001@181849.4599 d86c79u3mvlef7fq4g56qagp89 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2336';
20241001@181849.4630 d86c79u3mvlef7fq4g56qagp89 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2336';
20241001@181849.5723 s59bmm74iappe0pknapi88lklg Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241001@181849.5736 s59bmm74iappe0pknapi88lklg Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241001@181849.5791 s59bmm74iappe0pknapi88lklg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2337';
20241001@181849.5848 s59bmm74iappe0pknapi88lklg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2337';
20241001@181849.5901 s59bmm74iappe0pknapi88lklg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2337';
20241001@181849.5930 s59bmm74iappe0pknapi88lklg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2337';
20241001@181849.5978 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.5982 s59bmm74iappe0pknapi88lklg Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241001@181849.6050 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6053 s59bmm74iappe0pknapi88lklg Query : select no, estab,szadrsdesc from szadrs where u_coddest=8548
20241001@181849.6136 s59bmm74iappe0pknapi88lklg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241001@181849.6157 s59bmm74iappe0pknapi88lklg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241001@181849.6177 s59bmm74iappe0pknapi88lklg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241001@181849.6196 s59bmm74iappe0pknapi88lklg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241001@181849.6217 s59bmm74iappe0pknapi88lklg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241001@181849.6238 s59bmm74iappe0pknapi88lklg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241001@181849.6258 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6261 s59bmm74iappe0pknapi88lklg Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241001@181849.6294 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6298 s59bmm74iappe0pknapi88lklg Query : select top 1 1 valor from td where td.ndoc = 39
20241001@181849.6329 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6333 s59bmm74iappe0pknapi88lklg 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')
20241001@181849.6362 s59bmm74iappe0pknapi88lklg 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
20241001@181849.6399 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6402 s59bmm74iappe0pknapi88lklg Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241001@181849.6442 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6460 s59bmm74iappe0pknapi88lklg Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241001@181849.6493 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6496 s59bmm74iappe0pknapi88lklg Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241001@181849.6806 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6813 s59bmm74iappe0pknapi88lklg Query : select szadrsstamp valor from szadrs where szadrsdesc='jom- maia ( nova loja)'
20241001@181849.6894 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.6898 s59bmm74iappe0pknapi88lklg Query : select 1 valor from td where ndoc = 39
20241001@181849.6912 s59bmm74iappe0pknapi88lklg Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241001@181849.6933 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.6958 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181849.6979 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.6994 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181849.7023 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.7038 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181849.7085 s59bmm74iappe0pknapi88lklg Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181849.7150 s59bmm74iappe0pknapi88lklg Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181849.7163 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.7180 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181849.7198 s59bmm74iappe0pknapi88lklg Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fc25706366fc2ef9ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241001@181849.7378 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.7395 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181849.7430 s59bmm74iappe0pknapi88lklg Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241001@181849.7443 s59bmm74iappe0pknapi88lklg Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241001@181849.7456 s59bmm74iappe0pknapi88lklg Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241001@181849.7468 s59bmm74iappe0pknapi88lklg Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241001@181849.7481 s59bmm74iappe0pknapi88lklg Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241001@181849.7493 s59bmm74iappe0pknapi88lklg Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241001@181849.7505 s59bmm74iappe0pknapi88lklg Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fc25706366fc2ef9ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241001@181849.7752 s59bmm74iappe0pknapi88lklg Query : select top 1 fno valor from wsftdata order by fno desc
20241001@181849.7774 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.7792 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181849.7815 s59bmm74iappe0pknapi88lklg Query : select 'normal' from dummy
20241001@181849.7834 s59bmm74iappe0pknapi88lklg Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fc25706366fc2ef9ac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1027,101621,0,'2024-10-01',39,'euro',0,0,2024 ,?,?)
20241001@181849.8120 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.8123 s59bmm74iappe0pknapi88lklg Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241001@181849.8145 s59bmm74iappe0pknapi88lklg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241001@181849.8163 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8182 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.8209 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8224 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.8233 s59bmm74iappe0pknapi88lklg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.8245 s59bmm74iappe0pknapi88lklg Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2300612200a'
20241001@181849.8258 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8274 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.8287 s59bmm74iappe0pknapi88lklg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc28614366fc2ef9c9','aut66fc25706366fc2ef9ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.8291 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8306 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.8343 s59bmm74iappe0pknapi88lklg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc28614366fc2ef9c9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc25706366fc2ef9ac' ,0,0 ,2,23.00,10000,?,?,?,?)
20241001@181849.8600 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.8603 s59bmm74iappe0pknapi88lklg Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241001@181849.8622 s59bmm74iappe0pknapi88lklg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241001@181849.8635 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8650 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.8674 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8688 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.8696 s59bmm74iappe0pknapi88lklg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.8707 s59bmm74iappe0pknapi88lklg Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2300612200a'
20241001@181849.8719 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8733 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.8744 s59bmm74iappe0pknapi88lklg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc22871466fc2ef9d4','aut66fc25706366fc2ef9ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.8748 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.8762 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.8789 s59bmm74iappe0pknapi88lklg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc22871466fc2ef9d4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc25706366fc2ef9ac' ,0,0 ,2,23.00,20000,?,?,?,?)
20241001@181849.9049 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.9052 s59bmm74iappe0pknapi88lklg Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241001@181849.9072 s59bmm74iappe0pknapi88lklg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2330.00.1'
20241001@181849.9088 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9106 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.9133 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9149 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.9160 s59bmm74iappe0pknapi88lklg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.9172 s59bmm74iappe0pknapi88lklg Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241001@181849.9185 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9200 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.9212 s59bmm74iappe0pknapi88lklg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc21815966fc2ef9e0','aut66fc25706366fc2ef9ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.9216 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9231 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.9258 s59bmm74iappe0pknapi88lklg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc21815966fc2ef9e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc25706366fc2ef9ac' ,0,0 ,2,23.00,30000,?,?,?,?)
20241001@181849.9518 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181849.9521 s59bmm74iappe0pknapi88lklg Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241001@181849.9747 s59bmm74iappe0pknapi88lklg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241001@181849.9762 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9778 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.9802 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9816 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.9824 s59bmm74iappe0pknapi88lklg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181849.9835 s59bmm74iappe0pknapi88lklg Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2300567100a'
20241001@181849.9846 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9860 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181849.9871 s59bmm74iappe0pknapi88lklg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc24993766fc2ef9f0','aut66fc25706366fc2ef9ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181849.9876 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181849.9890 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181849.9916 s59bmm74iappe0pknapi88lklg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc24993766fc2ef9f0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc25706366fc2ef9ac' ,0,0 ,2,23.00,40000,?,?,?,?)
20241001@181850.1710 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181850.1740 s59bmm74iappe0pknapi88lklg Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241001@181850.1930 s59bmm74iappe0pknapi88lklg Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241001@181850.2070 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.2220 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.2460 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.2600 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.2680 s59bmm74iappe0pknapi88lklg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181850.2800 s59bmm74iappe0pknapi88lklg Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r230050910'
20241001@181850.2890 s59bmm74iappe0pknapi88lklg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.3030 s59bmm74iappe0pknapi88lklg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.3140 s59bmm74iappe0pknapi88lklg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc26196566fc2efa07','aut66fc25706366fc2ef9ac' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181850.3330 s59bmm74iappe0pknapi88lklg Query : use flama_phc
20241001@181850.3360 s59bmm74iappe0pknapi88lklg Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241001@181850.3680 s59bmm74iappe0pknapi88lklg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2337';
20241001@181850.3970 s59bmm74iappe0pknapi88lklg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2337';
20241001@181850.2617 k0ctf2fejtmimuoohgf661i3qp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241001@181850.2629 k0ctf2fejtmimuoohgf661i3qp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241001@181850.2684 k0ctf2fejtmimuoohgf661i3qp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2338';
20241001@181850.2740 k0ctf2fejtmimuoohgf661i3qp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2338';
20241001@181850.2792 k0ctf2fejtmimuoohgf661i3qp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2338';
20241001@181850.2816 k0ctf2fejtmimuoohgf661i3qp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2338';
20241001@181850.2866 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.2869 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241001@181850.2931 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.2934 k0ctf2fejtmimuoohgf661i3qp Query : select no, estab,szadrsdesc from szadrs where u_coddest=6855
20241001@181850.3014 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241001@181850.3034 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241001@181850.3053 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241001@181850.3072 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241001@181850.3095 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241001@181850.3114 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241001@181850.3134 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3137 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241001@181850.3168 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3171 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 1 valor from td where td.ndoc = 39
20241001@181850.3200 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3203 k0ctf2fejtmimuoohgf661i3qp 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')
20241001@181850.3230 k0ctf2fejtmimuoohgf661i3qp 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
20241001@181850.3264 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3266 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241001@181850.3299 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3302 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241001@181850.3331 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3334 k0ctf2fejtmimuoohgf661i3qp Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241001@181850.3373 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3376 k0ctf2fejtmimuoohgf661i3qp Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - montijo nova'
20241001@181850.3422 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.3425 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from td where ndoc = 39
20241001@181850.3437 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241001@181850.3451 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.3468 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181850.3486 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.3500 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181850.3529 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.3544 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181850.3557 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181850.3622 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181850.3635 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.3650 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181850.3665 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fc28803566fc2efa56' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241001@181850.3846 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.3862 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181850.3894 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241001@181850.3905 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241001@181850.3917 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241001@181850.3929 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241001@181850.3941 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241001@181850.3953 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241001@181850.3964 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fc28803566fc2efa56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241001@181850.4225 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 fno valor from wsftdata order by fno desc
20241001@181850.4248 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.4264 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181850.4286 k0ctf2fejtmimuoohgf661i3qp Query : select 'normal' from dummy
20241001@181850.4302 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fc28803566fc2efa56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1027,101621,0,'2024-10-01',39,'euro',0,0,2024 ,?,?)
20241001@181850.4596 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.4599 k0ctf2fejtmimuoohgf661i3qp Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241001@181850.4621 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241001@181850.4635 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.4651 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.4676 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.4690 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.4698 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181850.4710 k0ctf2fejtmimuoohgf661i3qp Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2300612200a'
20241001@181850.4722 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.4735 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.4747 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc21535466fc2efa73','aut66fc28803566fc2efa56' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181850.4751 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.4765 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.4793 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc21535466fc2efa73',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66fc28803566fc2efa56' ,0,0 ,2,23.00,10000,?,?,?,?)
20241001@181850.5039 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.5042 k0ctf2fejtmimuoohgf661i3qp Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241001@181850.5061 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2330.00.1'
20241001@181850.5075 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5089 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.5114 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5128 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.5137 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181850.5149 k0ctf2fejtmimuoohgf661i3qp Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241001@181850.5161 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5176 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.5187 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc24535366fc2efa7e','aut66fc28803566fc2efa56' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181850.5192 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5206 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.5234 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc24535366fc2efa7e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc28803566fc2efa56' ,0,0 ,2,23.00,20000,?,?,?,?)
20241001@181850.5488 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.5491 k0ctf2fejtmimuoohgf661i3qp Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241001@181850.5512 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241001@181850.5527 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5543 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.5568 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5582 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.5592 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181850.5604 k0ctf2fejtmimuoohgf661i3qp Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2300567100a'
20241001@181850.5617 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5632 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.5644 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc20082366fc2efa89','aut66fc28803566fc2efa56' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181850.5648 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.5663 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.5692 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc20082366fc2efa89',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc28803566fc2efa56' ,0,0 ,2,23.00,30000,?,?,?,?)
20241001@181850.5979 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.5983 k0ctf2fejtmimuoohgf661i3qp Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241001@181850.6004 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241001@181850.6017 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6052 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.6080 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6095 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.6104 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181850.6115 k0ctf2fejtmimuoohgf661i3qp Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241001@181850.6130 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6145 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.6157 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc23343566fc2efa95','aut66fc28803566fc2efa56' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181850.6161 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6176 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.6205 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc23343566fc2efa95',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc28803566fc2efa56' ,0,0 ,2,23.00,40000,?,?,?,?)
20241001@181850.6469 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.6473 k0ctf2fejtmimuoohgf661i3qp Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241001@181850.6495 k0ctf2fejtmimuoohgf661i3qp 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.2366.00.1'
20241001@181850.6657 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6674 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.6699 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6721 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.6731 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181850.6764 k0ctf2fejtmimuoohgf661i3qp Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2300548100a'
20241001@181850.6785 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6800 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.6813 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc21935966fc2efaa5','aut66fc28803566fc2efa56' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181850.6817 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.6832 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.6862 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc21935966fc2efaa5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fc28803566fc2efa56' ,0,0 ,2,23.00,50000,?,?,?,?)
20241001@181850.7122 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.7125 k0ctf2fejtmimuoohgf661i3qp Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20241001@181850.7146 k0ctf2fejtmimuoohgf661i3qp 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.966.00.01'
20241001@181850.7300 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.7315 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.7339 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.7353 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.7361 k0ctf2fejtmimuoohgf661i3qp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181850.7371 k0ctf2fejtmimuoohgf661i3qp Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20241001@181850.7389 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.7403 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181850.7413 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc29393266fc2efab4','aut66fc28803566fc2efa56' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181850.7417 k0ctf2fejtmimuoohgf661i3qp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.7432 k0ctf2fejtmimuoohgf661i3qp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181850.7458 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc29393266fc2efab4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fc28803566fc2efa56' ,0,0 ,2,23.00,60000,?,?,?,?)
20241001@181850.7725 k0ctf2fejtmimuoohgf661i3qp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fc28803566fc2efa56','2406341','wait',39,'adm09112754980.682000002')
20241001@181850.7797 k0ctf2fejtmimuoohgf661i3qp Query : use flama_phc
20241001@181850.7800 k0ctf2fejtmimuoohgf661i3qp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241001@181850.7833 k0ctf2fejtmimuoohgf661i3qp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2338';
20241001@181850.7863 k0ctf2fejtmimuoohgf661i3qp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2338';
20241001@181850.7904 k0ctf2fejtmimuoohgf661i3qp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2338';
20241001@181850.7929 k0ctf2fejtmimuoohgf661i3qp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2338';
20241001@181850.8487 4oru6b0u4e3ledlov3ttchuagi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241001@181850.8498 4oru6b0u4e3ledlov3ttchuagi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241001@181850.8554 4oru6b0u4e3ledlov3ttchuagi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2339';
20241001@181850.8610 4oru6b0u4e3ledlov3ttchuagi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2339';
20241001@181850.8663 4oru6b0u4e3ledlov3ttchuagi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2339';
20241001@181850.8690 4oru6b0u4e3ledlov3ttchuagi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2339';
20241001@181850.8738 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.8741 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241001@181850.8806 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.8808 4oru6b0u4e3ledlov3ttchuagi Query : select no, estab,szadrsdesc from szadrs where u_coddest=812
20241001@181850.8890 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241001@181850.8910 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241001@181850.8932 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241001@181850.8952 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241001@181850.8971 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241001@181850.8990 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.8993 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241001@181850.9025 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.9027 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 1 valor from td where td.ndoc = 39
20241001@181850.9057 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.9060 4oru6b0u4e3ledlov3ttchuagi 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')
20241001@181850.9089 4oru6b0u4e3ledlov3ttchuagi 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
20241001@181850.9123 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.9126 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241001@181850.9252 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.9256 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241001@181850.9286 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.9289 4oru6b0u4e3ledlov3ttchuagi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241001@181850.9330 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.9333 4oru6b0u4e3ledlov3ttchuagi Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda - santarem'
20241001@181850.9378 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181850.9381 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from td where ndoc = 39
20241001@181850.9393 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241001@181850.9407 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.9423 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181850.9444 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.9458 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181850.9488 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.9502 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181850.9515 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181850.9579 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181850.9591 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.9607 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181850.9624 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fc23150566fc2efae8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241001@181850.9798 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181850.9814 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181850.9845 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241001@181850.9857 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241001@181850.9869 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241001@181850.9959 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241001@181851.1900 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241001@181851.3100 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241001@181851.4100 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fc23150566fc2efae8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241001@181851.2780 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 fno valor from wsftdata order by fno desc
20241001@181851.2980 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.3140 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181851.3370 4oru6b0u4e3ledlov3ttchuagi Query : select 'normal' from dummy
20241001@181851.3520 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fc23150566fc2efae8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1028,101621,0,'2024-10-01',39,'euro',0,0,2024 ,?,?)
20241001@181851.6280 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181851.6310 4oru6b0u4e3ledlov3ttchuagi Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241001@181851.6510 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241001@181851.6640 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.6830 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.7080 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.7230 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.7310 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181851.7440 4oru6b0u4e3ledlov3ttchuagi Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2300612200a'
20241001@181851.7560 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.7700 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.7820 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc29231166fc2efb12','aut66fc23150566fc2efae8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181851.7860 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.8000 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.8260 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc29231166fc2efb12',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66fc23150566fc2efae8' ,0,0 ,2,23.00,10000,?,?,?,?)
20241001@181851.1087 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181851.1090 4oru6b0u4e3ledlov3ttchuagi Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241001@181851.1115 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2330.00.1'
20241001@181851.1130 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1147 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.1173 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1188 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.1197 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181851.1209 4oru6b0u4e3ledlov3ttchuagi Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241001@181851.1222 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1237 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.1249 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc27655066fc2efb1d','aut66fc23150566fc2efae8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181851.1253 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1267 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.1298 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc27655066fc2efb1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc23150566fc2efae8' ,0,0 ,2,23.00,20000,?,?,?,?)
20241001@181851.1544 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181851.1547 4oru6b0u4e3ledlov3ttchuagi Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241001@181851.1566 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241001@181851.1581 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1599 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.1628 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1645 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.1656 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181851.1670 4oru6b0u4e3ledlov3ttchuagi Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2300567100a'
20241001@181851.1803 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1915 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.1928 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc22781866fc2efb2c','aut66fc23150566fc2efae8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181851.1933 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.1948 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.1977 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc22781866fc2efb2c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc23150566fc2efae8' ,0,0 ,2,23.00,30000,?,?,?,?)
20241001@181851.2230 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181851.2233 4oru6b0u4e3ledlov3ttchuagi Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241001@181851.2257 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241001@181851.2273 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2290 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.2319 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2334 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.2343 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181851.2354 4oru6b0u4e3ledlov3ttchuagi Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241001@181851.2366 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2383 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.2396 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc26311566fc2efb39','aut66fc23150566fc2efae8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181851.2401 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2417 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.2449 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc26311566fc2efb39',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc23150566fc2efae8' ,0,0 ,2,23.00,40000,?,?,?,?)
20241001@181851.2692 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181851.2696 4oru6b0u4e3ledlov3ttchuagi Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20241001@181851.2718 4oru6b0u4e3ledlov3ttchuagi 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.966.00.01'
20241001@181851.2733 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2748 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.2772 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2786 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.2795 4oru6b0u4e3ledlov3ttchuagi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181851.2806 4oru6b0u4e3ledlov3ttchuagi Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20241001@181851.2820 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2839 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181851.2853 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc25392066fc2efb44','aut66fc23150566fc2efae8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181851.2870 4oru6b0u4e3ledlov3ttchuagi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181851.2887 4oru6b0u4e3ledlov3ttchuagi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181851.2920 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc25392066fc2efb44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fc23150566fc2efae8' ,0,0 ,2,23.00,50000,?,?,?,?)
20241001@181851.3190 4oru6b0u4e3ledlov3ttchuagi Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fc23150566fc2efae8','2406342','wait',39,'adm09112754980.682000002')
20241001@181851.3266 4oru6b0u4e3ledlov3ttchuagi Query : use flama_phc
20241001@181851.3269 4oru6b0u4e3ledlov3ttchuagi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241001@181851.3301 4oru6b0u4e3ledlov3ttchuagi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2339';
20241001@181851.3334 4oru6b0u4e3ledlov3ttchuagi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2339';
20241001@181851.3376 4oru6b0u4e3ledlov3ttchuagi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2339';
20241001@181851.3402 4oru6b0u4e3ledlov3ttchuagi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2339';
20241001@181851.4001 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241001@181851.4084 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241001@181851.4584 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2340';
20241001@181851.4912 r5vdnk2nnupmn6v1nhkaf3vcrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2340';
20241001@181851.5256 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2340';
20241001@181851.5553 r5vdnk2nnupmn6v1nhkaf3vcrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2340';
20241001@181851.5894 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181851.5935 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241001@181851.6754 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181851.6835 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select no, estab,szadrsdesc from szadrs where u_coddest=1453
20241001@181851.7271 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241001@181851.7441 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241001@181851.7617 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241001@181851.7907 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241001@181851.7977 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241001@181851.8204 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181851.8245 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241001@181851.8618 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181851.8802 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 1 valor from td where td.ndoc = 39
20241001@181852.1000 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181852.4500 r5vdnk2nnupmn6v1nhkaf3vcrh 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')
20241001@181852.5290 r5vdnk2nnupmn6v1nhkaf3vcrh 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
20241001@181852.9820 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181852.1023 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241001@181852.1394 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181852.1435 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241001@181852.1806 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181852.1848 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241001@181852.2953 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181852.3035 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select szadrsstamp valor from szadrs where szadrsdesc='jom - batalha'
20241001@181852.3754 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181852.3796 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from td where ndoc = 39
20241001@181852.4047 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241001@181852.4338 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181852.4590 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181852.5004 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181852.5283 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181852.5948 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181852.6200 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181852.6565 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181852.6908 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181852.7156 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181852.7409 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181852.7698 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fc24086166fc2efca0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241001@181852.8083 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181852.8375 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181852.9258 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241001@181852.9331 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241001@181852.9346 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241001@181852.9514 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241001@181852.9721 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241001@181852.9928 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241001@181853.1610 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fc24086166fc2efca0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241001@181853.6330 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 fno valor from wsftdata order by fno desc
20241001@181853.8890 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181853.1141 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181853.1434 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 'normal' from dummy
20241001@181853.1453 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66fc24086166fc2efca0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1029,101621,0,'2024-10-01',39,'euro',0,0,2024 ,?,?)
20241001@181853.2024 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181853.2029 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select st.usalote valor from st where st.ref = '324.2301.00.3'
20241001@181853.3026 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2301.00.3'
20241001@181853.3275 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181853.3648 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181853.4329 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181853.4581 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181853.4746 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181853.5444 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select sestamp valor from se where ref ='324.2301.00.3' and lote = 'r2300612200a'
20241001@181853.6384 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181853.6745 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181853.6994 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc20251566fc2efd9b','aut66fc24086166fc2efca0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181853.7037 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181853.7289 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181853.7910 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc20251566fc2efd9b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66fc24086166fc2efca0' ,0,0 ,2,23.00,10000,?,?,?,?)
20241001@181853.8492 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181853.8533 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241001@181853.8867 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2330.00.1'
20241001@181853.9114 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181853.9367 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181854.1680 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181854.4220 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181854.5880 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181854.8360 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2200210200a'
20241001@181854.1084 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181854.1335 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181854.1612 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc25758966fc2efe1a','aut66fc24086166fc2efca0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181854.1655 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181854.1907 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181854.2526 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc25758966fc2efe1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc24086166fc2efca0' ,0,0 ,2,23.00,20000,?,?,?,?)
20241001@181854.3100 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181854.3141 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select st.usalote valor from st where st.ref = '324.2326.00.1'
20241001@181854.3474 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2326.00.1'
20241001@181854.4417 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181854.4671 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181854.5470 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181854.5725 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181854.5892 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181854.6142 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select sestamp valor from se where ref ='324.2326.00.1' and lote = 'r2300567100a'
20241001@181854.7630 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181854.7883 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181854.8089 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc20781966fc2efeba','aut66fc24086166fc2efca0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181854.8132 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181854.8454 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181854.9077 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc20781966fc2efeba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66fc24086166fc2efca0' ,0,0 ,2,23.00,30000,?,?,?,?)
20241001@181854.9671 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181854.9713 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241001@181855.4500 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2335.00.1'
20241001@181855.2940 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.5450 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181855.1380 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.1635 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181855.1802 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181855.2049 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241001@181855.2324 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.2576 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181855.2782 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc22573666fc2eff38','aut66fc24086166fc2efca0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181855.2829 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.3080 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181855.4368 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc22573666fc2eff38',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66fc24086166fc2efca0' ,0,0 ,2,23.00,40000,?,?,?,?)
20241001@181855.5184 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181855.5226 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20241001@181855.5521 r5vdnk2nnupmn6v1nhkaf3vcrh 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.966.00.01'
20241001@181855.5542 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.5718 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181855.7670 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.7953 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181855.8118 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241001@181855.8366 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20241001@181855.8461 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.8482 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241001@181855.8534 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66fc26127266fc2effce','aut66fc24086166fc2efca0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241001@181855.8577 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181855.8758 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241001@181855.9355 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem) values ('aut66fc26127266fc2effce',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66fc24086166fc2efca0' ,0,0 ,2,23.00,50000,?,?,?,?)
20241001@181855.9943 r5vdnk2nnupmn6v1nhkaf3vcrh Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66fc24086166fc2efca0','2406343','wait',39,'adm09112754980.682000002')
20241001@181856.5700 r5vdnk2nnupmn6v1nhkaf3vcrh Query : use flama_phc
20241001@181856.6110 r5vdnk2nnupmn6v1nhkaf3vcrh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241001@181856.8590 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2340';
20241001@181856.1158 r5vdnk2nnupmn6v1nhkaf3vcrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2340';
20241001@181856.1445 r5vdnk2nnupmn6v1nhkaf3vcrh Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2340';
20241001@181856.1743 r5vdnk2nnupmn6v1nhkaf3vcrh Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2340';
20241001@181856.2618 gpngc1eidvbt1fdq8kddkqp984 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241001@181856.2630 gpngc1eidvbt1fdq8kddkqp984 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241001@181856.2691 gpngc1eidvbt1fdq8kddkqp984 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2341';
20241001@181856.2750 gpngc1eidvbt1fdq8kddkqp984 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2341';
20241001@181856.2809 gpngc1eidvbt1fdq8kddkqp984 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2341';
20241001@181856.2836 gpngc1eidvbt1fdq8kddkqp984 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2341';
20241001@181856.2926 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.2930 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241001@181856.3900 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.3904 gpngc1eidvbt1fdq8kddkqp984 Query : select no, estab,szadrsdesc from szadrs where u_coddest=908
20241001@181856.3989 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2301.00.3'
20241001@181856.4009 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2330.00.1'
20241001@181856.4028 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2326.00.1'
20241001@181856.4049 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2335.00.1'
20241001@181856.4068 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241001@181856.4091 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4095 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241001@181856.4128 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4132 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 1 valor from td where td.ndoc = 39
20241001@181856.4162 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4165 gpngc1eidvbt1fdq8kddkqp984 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')
20241001@181856.4195 gpngc1eidvbt1fdq8kddkqp984 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
20241001@181856.4231 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4235 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241001@181856.4265 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4268 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241001@181856.4301 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4304 gpngc1eidvbt1fdq8kddkqp984 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241001@181856.4387 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4391 gpngc1eidvbt1fdq8kddkqp984 Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m.,lda-aveiro'
20241001@181856.4441 gpngc1eidvbt1fdq8kddkqp984 Query : use flama_phc
20241001@181856.4444 gpngc1eidvbt1fdq8kddkqp984 Query : select 1 valor from td where ndoc = 39
20241001@181856.4458 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241001@181856.4474 gpngc1eidvbt1fdq8kddkqp984 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181856.4492 gpngc1eidvbt1fdq8kddkqp984 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241001@181856.4514 gpngc1eidvbt1fdq8kddkqp984 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181856.4530 gpngc1eidvbt1fdq8kddkqp984 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181856.4561 gpngc1eidvbt1fdq8kddkqp984 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181856.4577 gpngc1eidvbt1fdq8kddkqp984 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181856.4591 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181856.4657 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241001@181856.4673 gpngc1eidvbt1fdq8kddkqp984 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181856.4690 gpngc1eidvbt1fdq8kddkqp984 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241001@181856.4708 gpngc1eidvbt1fdq8kddkqp984 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66fc29412666fc2f0070' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241001@181856.4884 gpngc1eidvbt1fdq8kddkqp984 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241001@181856.4902 gpngc1eidvbt1fdq8kddkqp984 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241001@181856.4938 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241001@181856.4952 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241001@181856.4971 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241001@181856.4984 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241001@181856.4998 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241001@181856.5012 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241001@181856.5025 gpngc1eidvbt1fdq8kddkqp984 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66fc29412666fc2f0070',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241001@181856.5273 gpngc1eidvbt1fdq8kddkqp984 Query : select top 1 fno valor from wsftdata order by fno desc
20241001@181856.5295 gpngc1eidvbt1fdq8kddkqp984 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
