20241014@182849.2099 o7giu8llfgm4biel2m3cf1379i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.2113 o7giu8llfgm4biel2m3cf1379i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182849.2137 o7giu8llfgm4biel2m3cf1379i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d570960670d54d133','aut670d553372670d54d0da' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182849.2140 o7giu8llfgm4biel2m3cf1379i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.2155 o7giu8llfgm4biel2m3cf1379i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182849.2184 o7giu8llfgm4biel2m3cf1379i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d570960670d54d133',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',66.000 ,'aut670d553372670d54d0da' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241014@182849.2399 o7giu8llfgm4biel2m3cf1379i Query : use flama_phc
20241014@182849.2402 o7giu8llfgm4biel2m3cf1379i Query : select st.usalote valor from st where st.ref = '324.1329.00.1'
20241014@182849.2422 o7giu8llfgm4biel2m3cf1379i 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.1329.00.1'
20241014@182849.2535 o7giu8llfgm4biel2m3cf1379i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.2562 o7giu8llfgm4biel2m3cf1379i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182849.2587 o7giu8llfgm4biel2m3cf1379i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.2601 o7giu8llfgm4biel2m3cf1379i Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182849.2609 o7giu8llfgm4biel2m3cf1379i Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182849.2621 o7giu8llfgm4biel2m3cf1379i Query : select sestamp valor from se where ref ='324.1329.00.1' and lote = 'r2400496300a'
20241014@182849.2634 o7giu8llfgm4biel2m3cf1379i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.2649 o7giu8llfgm4biel2m3cf1379i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182849.2660 o7giu8llfgm4biel2m3cf1379i Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d579405670d54d140','aut670d553372670d54d0da' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182849.2663 o7giu8llfgm4biel2m3cf1379i Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.2679 o7giu8llfgm4biel2m3cf1379i Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182849.2707 o7giu8llfgm4biel2m3cf1379i Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d579405670d54d140',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut670d553372670d54d0da' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241014@182849.2908 o7giu8llfgm4biel2m3cf1379i Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670d553372670d54d0da','2406686','wait',39,'adm09112754980.682000002')
20241014@182849.2974 o7giu8llfgm4biel2m3cf1379i Query : use flama_phc
20241014@182849.2977 o7giu8llfgm4biel2m3cf1379i Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241014@182849.3008 o7giu8llfgm4biel2m3cf1379i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2638';
20241014@182849.3038 o7giu8llfgm4biel2m3cf1379i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2638';
20241014@182849.3699 o7giu8llfgm4biel2m3cf1379i Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2638';
20241014@182849.3735 o7giu8llfgm4biel2m3cf1379i Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2638';
20241014@182849.6014 kc9nuub52rh7vhqo5pvfj3inip Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241014@182849.6025 kc9nuub52rh7vhqo5pvfj3inip Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241014@182849.6083 kc9nuub52rh7vhqo5pvfj3inip Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2639';
20241014@182849.6136 kc9nuub52rh7vhqo5pvfj3inip Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2639';
20241014@182849.6192 kc9nuub52rh7vhqo5pvfj3inip Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2639';
20241014@182849.6218 kc9nuub52rh7vhqo5pvfj3inip Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2639';
20241014@182849.6272 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.6275 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241014@182849.6339 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.6342 kc9nuub52rh7vhqo5pvfj3inip Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241014@182849.6978 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '326.595.00.01'
20241014@182849.7112 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406703 and bi.ref ='326.595.00.01' and bi.lordem =1
20241014@182849.7411 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7414 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241014@182849.7446 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7449 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 1 valor from td where td.ndoc = 39
20241014@182849.7477 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7480 kc9nuub52rh7vhqo5pvfj3inip 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')
20241014@182849.7508 kc9nuub52rh7vhqo5pvfj3inip 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
20241014@182849.7542 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7545 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241014@182849.7574 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7577 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241014@182849.7605 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7608 kc9nuub52rh7vhqo5pvfj3inip Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241014@182849.7646 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7649 kc9nuub52rh7vhqo5pvfj3inip Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241014@182849.7691 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.7694 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from td where ndoc = 39
20241014@182849.7705 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241014@182849.7718 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.7733 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182849.7755 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.7769 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182849.7795 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.7809 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182849.7822 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182849.7885 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182849.7897 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.7912 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182849.7927 kc9nuub52rh7vhqo5pvfj3inip Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670d527844670d54d1be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241014@182849.8071 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.8090 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182849.8122 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241014@182849.8133 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241014@182849.8146 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241014@182849.8158 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241014@182849.8170 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241014@182849.8182 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241014@182849.8195 kc9nuub52rh7vhqo5pvfj3inip Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670d527844670d54d1be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241014@182849.8394 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 fno valor from wsftdata order by fno desc
20241014@182849.9025 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.9041 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182849.9064 kc9nuub52rh7vhqo5pvfj3inip Query : select 'normal' from dummy
20241014@182849.9078 kc9nuub52rh7vhqo5pvfj3inip Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670d527844670d54d1be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1262,100810,0,'2024-10-14',39,'euro',0,0,2024 ,?,?)
20241014@182849.9317 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.9320 kc9nuub52rh7vhqo5pvfj3inip Query : select st.usalote valor from st where st.ref = '326.595.00.01'
20241014@182849.9340 kc9nuub52rh7vhqo5pvfj3inip 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 = '326.595.00.01'
20241014@182849.9450 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.9465 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182849.9492 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.9508 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182849.9517 kc9nuub52rh7vhqo5pvfj3inip Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182849.9530 kc9nuub52rh7vhqo5pvfj3inip Query : select sestamp valor from se where ref ='326.595.00.01' and lote = 'r2400411200a'
20241014@182849.9550 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.9564 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182849.9575 kc9nuub52rh7vhqo5pvfj3inip Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d579497670d54d1e9','aut670d527844670d54d1be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182849.9579 kc9nuub52rh7vhqo5pvfj3inip Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182849.9593 kc9nuub52rh7vhqo5pvfj3inip Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182849.9625 kc9nuub52rh7vhqo5pvfj3inip Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d579497670d54d1e9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut670d527844670d54d1be' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241014@182849.9834 kc9nuub52rh7vhqo5pvfj3inip Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670d527844670d54d1be','2406703','wait',39,'adm09112754980.682000002')
20241014@182849.9904 kc9nuub52rh7vhqo5pvfj3inip Query : use flama_phc
20241014@182849.9907 kc9nuub52rh7vhqo5pvfj3inip Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241014@182849.9937 kc9nuub52rh7vhqo5pvfj3inip Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2639';
20241014@182849.9969 kc9nuub52rh7vhqo5pvfj3inip Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2639';
20241014@182850.1300 kc9nuub52rh7vhqo5pvfj3inip Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2639';
20241014@182850.4100 kc9nuub52rh7vhqo5pvfj3inip Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2639';
20241014@182850.6710 k8hi4rc9mun0menu3f1q4gro44 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241014@182850.6840 k8hi4rc9mun0menu3f1q4gro44 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241014@182850.7410 k8hi4rc9mun0menu3f1q4gro44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2640';
20241014@182850.7950 k8hi4rc9mun0menu3f1q4gro44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2640';
20241014@182850.8520 k8hi4rc9mun0menu3f1q4gro44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2640';
20241014@182850.8790 k8hi4rc9mun0menu3f1q4gro44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2640';
20241014@182850.9300 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.9330 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241014@182850.1004 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.1007 k8hi4rc9mun0menu3f1q4gro44 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241014@182850.1048 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.698.00.01'
20241014@182850.1168 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406706 and bi.ref ='324.698.00.01' and bi.lordem =1
20241014@182850.1443 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20241014@182850.1544 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406706 and bi.ref ='324.1676.00.1' and bi.lordem =2
20241014@182850.1808 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.1811 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241014@182850.1842 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.1845 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 1 valor from td where td.ndoc = 39
20241014@182850.1875 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.1878 k8hi4rc9mun0menu3f1q4gro44 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')
20241014@182850.1906 k8hi4rc9mun0menu3f1q4gro44 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
20241014@182850.1943 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.1946 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241014@182850.1975 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.1979 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241014@182850.2008 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.2011 k8hi4rc9mun0menu3f1q4gro44 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241014@182850.2054 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.2057 k8hi4rc9mun0menu3f1q4gro44 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241014@182850.2104 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.2107 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from td where ndoc = 39
20241014@182850.2119 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241014@182850.2134 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.2149 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182850.2167 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.2182 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182850.2211 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.2225 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182850.2238 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182850.2302 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182850.2318 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.2342 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182850.2359 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670d516455670d54d236' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241014@182850.2511 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.2527 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182850.2561 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241014@182850.2574 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241014@182850.2592 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241014@182850.2605 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241014@182850.2618 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241014@182850.2630 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241014@182850.2641 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670d516455670d54d236',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241014@182850.2835 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 fno valor from wsftdata order by fno desc
20241014@182850.2858 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.2874 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182850.2896 k8hi4rc9mun0menu3f1q4gro44 Query : select 'normal' from dummy
20241014@182850.2910 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670d516455670d54d236',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1263,100810,0,'2024-10-14',39,'euro',0,0,2024 ,?,?)
20241014@182850.3136 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.3139 k8hi4rc9mun0menu3f1q4gro44 Query : select st.usalote valor from st where st.ref = '324.698.00.01'
20241014@182850.3160 k8hi4rc9mun0menu3f1q4gro44 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.698.00.01'
20241014@182850.3271 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3287 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.3312 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3326 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.3335 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182850.3346 k8hi4rc9mun0menu3f1q4gro44 Query : select sestamp valor from se where ref ='324.698.00.01' and lote = 'r2400061200a'
20241014@182850.3359 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3373 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.3385 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d508292670d54d252','aut670d516455670d54d236' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182850.3389 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3403 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.3432 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d508292670d54d252',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut670d516455670d54d236' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241014@182850.3640 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3655 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.3679 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3694 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.3703 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182850.3715 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3731 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.3745 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d506459670d54d25a','aut670d516455670d54d236' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182850.3749 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.3764 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.3793 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670d506459670d54d25a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670d516455670d54d236' ,0,0 ,2,23.00,20000,?,?,?)
20241014@182850.3997 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.4000 k8hi4rc9mun0menu3f1q4gro44 Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20241014@182850.4020 k8hi4rc9mun0menu3f1q4gro44 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.1676.00.1'
20241014@182850.4131 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.4146 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.4171 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.4185 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.4194 k8hi4rc9mun0menu3f1q4gro44 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182850.4205 k8hi4rc9mun0menu3f1q4gro44 Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20241014@182850.4218 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.4232 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.4244 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d567490670d54d266','aut670d516455670d54d236' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182850.4248 k8hi4rc9mun0menu3f1q4gro44 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.4263 k8hi4rc9mun0menu3f1q4gro44 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.4292 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d567490670d54d266',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut670d516455670d54d236' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241014@182850.4508 k8hi4rc9mun0menu3f1q4gro44 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670d516455670d54d236','2406706','wait',39,'adm09112754980.682000002')
20241014@182850.4579 k8hi4rc9mun0menu3f1q4gro44 Query : use flama_phc
20241014@182850.4583 k8hi4rc9mun0menu3f1q4gro44 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241014@182850.4618 k8hi4rc9mun0menu3f1q4gro44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2640';
20241014@182850.4651 k8hi4rc9mun0menu3f1q4gro44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2640';
20241014@182850.4696 k8hi4rc9mun0menu3f1q4gro44 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2640';
20241014@182850.4726 k8hi4rc9mun0menu3f1q4gro44 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2640';
20241014@182850.5376 q60ufq5gatjep3999tcigqjj07 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241014@182850.5387 q60ufq5gatjep3999tcigqjj07 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241014@182850.5450 q60ufq5gatjep3999tcigqjj07 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2641';
20241014@182850.5509 q60ufq5gatjep3999tcigqjj07 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2641';
20241014@182850.5567 q60ufq5gatjep3999tcigqjj07 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2641';
20241014@182850.5595 q60ufq5gatjep3999tcigqjj07 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2641';
20241014@182850.5645 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.5648 q60ufq5gatjep3999tcigqjj07 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241014@182850.5712 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.5715 q60ufq5gatjep3999tcigqjj07 Query : select no, estab,szadrsdesc from szadrs where u_coddest=8748
20241014@182850.5791 q60ufq5gatjep3999tcigqjj07 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241014@182850.5903 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406709 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241014@182850.6183 q60ufq5gatjep3999tcigqjj07 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241014@182850.6207 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406709 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241014@182850.6224 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6228 q60ufq5gatjep3999tcigqjj07 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241014@182850.6260 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6263 q60ufq5gatjep3999tcigqjj07 Query : select top 1 1 valor from td where td.ndoc = 39
20241014@182850.6294 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6297 q60ufq5gatjep3999tcigqjj07 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')
20241014@182850.6328 q60ufq5gatjep3999tcigqjj07 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
20241014@182850.6368 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6371 q60ufq5gatjep3999tcigqjj07 Query : select top 1 ~inactivo valor from cl where no = '102253' and estab = 0 order by inactivo desc
20241014@182850.6461 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6464 q60ufq5gatjep3999tcigqjj07 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241014@182850.6497 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6501 q60ufq5gatjep3999tcigqjj07 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241014@182850.6541 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6544 q60ufq5gatjep3999tcigqjj07 Query : select szadrsstamp valor from szadrs where szadrsdesc='fnac - entrega'
20241014@182850.6591 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.6594 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from td where ndoc = 39
20241014@182850.6614 q60ufq5gatjep3999tcigqjj07 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241014@182850.6630 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.6647 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182850.6667 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.6683 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182850.6715 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.6730 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182850.6744 q60ufq5gatjep3999tcigqjj07 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182850.7959 q60ufq5gatjep3999tcigqjj07 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182850.7973 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.7993 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182850.8010 q60ufq5gatjep3999tcigqjj07 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670d571420670d54d2a4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241014@182850.8148 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.8164 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182850.8199 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241014@182850.8213 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241014@182850.8229 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241014@182850.8243 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241014@182850.8256 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241014@182850.8268 q60ufq5gatjep3999tcigqjj07 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241014@182850.8280 q60ufq5gatjep3999tcigqjj07 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670d571420670d54d2a4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241014@182850.8473 q60ufq5gatjep3999tcigqjj07 Query : select top 1 fno valor from wsftdata order by fno desc
20241014@182850.8495 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.8510 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182850.8532 q60ufq5gatjep3999tcigqjj07 Query : select 'normal' from dummy
20241014@182850.8548 q60ufq5gatjep3999tcigqjj07 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670d571420670d54d2a4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1264,102253,0,'2024-10-14',39,'euro',0,0,2024 ,?,?)
20241014@182850.8770 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.8773 q60ufq5gatjep3999tcigqjj07 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241014@182850.8795 q60ufq5gatjep3999tcigqjj07 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.1834.00.1'
20241014@182850.8908 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.8924 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.8951 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.8966 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.8975 q60ufq5gatjep3999tcigqjj07 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182850.8987 q60ufq5gatjep3999tcigqjj07 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241014@182850.9001 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9017 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.9029 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d508959670d54d2db','aut670d571420670d54d2a4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182850.9033 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9048 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.9076 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d508959670d54d2db',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut670d571420670d54d2a4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241014@182850.9283 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9297 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.9322 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9337 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.9345 q60ufq5gatjep3999tcigqjj07 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182850.9356 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9370 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.9381 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d572407670d54d2e4','aut670d571420670d54d2a4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182850.9385 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9399 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.9427 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670d572407670d54d2e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670d571420670d54d2a4' ,0,0 ,2,23.00,20000,?,?,?)
20241014@182850.9618 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182850.9621 q60ufq5gatjep3999tcigqjj07 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241014@182850.9640 q60ufq5gatjep3999tcigqjj07 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.1834.00.1'
20241014@182850.9655 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9671 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.9696 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9710 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.9718 q60ufq5gatjep3999tcigqjj07 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182850.9730 q60ufq5gatjep3999tcigqjj07 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241014@182850.9743 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9756 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182850.9767 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d508369670d54d2ed','aut670d571420670d54d2a4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182850.9771 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182850.9786 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182850.9817 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d508369670d54d2ed',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut670d571420670d54d2a4' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241014@182851.3200 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.4900 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.7400 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8900 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.9800 q60ufq5gatjep3999tcigqjj07 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.1100 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.1260 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.1380 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d562459670d54d302','aut670d571420670d54d2a4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.1410 q60ufq5gatjep3999tcigqjj07 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.1570 q60ufq5gatjep3999tcigqjj07 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.1850 q60ufq5gatjep3999tcigqjj07 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670d562459670d54d302',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670d571420670d54d2a4' ,0,0 ,2,23.00,50000,?,?,?)
20241014@182851.3840 q60ufq5gatjep3999tcigqjj07 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670d571420670d54d2a4','2406709','wait',39,'adm09112754980.682000002')
20241014@182851.4530 q60ufq5gatjep3999tcigqjj07 Query : use flama_phc
20241014@182851.4580 q60ufq5gatjep3999tcigqjj07 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241014@182851.4890 q60ufq5gatjep3999tcigqjj07 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2641';
20241014@182851.5230 q60ufq5gatjep3999tcigqjj07 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2641';
20241014@182851.5670 q60ufq5gatjep3999tcigqjj07 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2641';
20241014@182851.5940 q60ufq5gatjep3999tcigqjj07 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2641';
20241014@182851.1174 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241014@182851.1186 7ulhqoeg3j4jacct3ecpk5k33h Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241014@182851.1243 7ulhqoeg3j4jacct3ecpk5k33h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2642';
20241014@182851.1294 7ulhqoeg3j4jacct3ecpk5k33h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2642';
20241014@182851.1350 7ulhqoeg3j4jacct3ecpk5k33h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2642';
20241014@182851.1376 7ulhqoeg3j4jacct3ecpk5k33h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2642';
20241014@182851.1424 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.1427 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241014@182851.1492 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.1495 7ulhqoeg3j4jacct3ecpk5k33h Query : select no, estab,szadrsdesc from szadrs where u_coddest=1086
20241014@182851.1569 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.1683 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241014@182851.1977 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.1999 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241014@182851.2020 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.2127 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.2330.00.1' and bi.lordem =2
20241014@182851.2424 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.2445 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.2330.00.1' and bi.lordem =2
20241014@182851.2467 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2340.00.1'
20241014@182851.2573 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.2340.00.1' and bi.lordem =3
20241014@182851.2852 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1317.00.1'
20241014@182851.2951 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.1317.00.1' and bi.lordem =4
20241014@182851.3226 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241014@182851.3327 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.1321.00.1' and bi.lordem =5
20241014@182851.3595 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241014@182851.3614 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406711 and bi.ref ='324.1321.00.1' and bi.lordem =5
20241014@182851.3630 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3633 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241014@182851.3664 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3667 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 1 valor from td where td.ndoc = 39
20241014@182851.3695 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3698 7ulhqoeg3j4jacct3ecpk5k33h 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')
20241014@182851.3724 7ulhqoeg3j4jacct3ecpk5k33h 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
20241014@182851.3757 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3760 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 ~inactivo valor from cl where no = '101648' and estab = 0 order by inactivo desc
20241014@182851.3850 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3853 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241014@182851.3882 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3885 7ulhqoeg3j4jacct3ecpk5k33h Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241014@182851.3927 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3930 7ulhqoeg3j4jacct3ecpk5k33h Query : select szadrsstamp valor from szadrs where szadrsdesc='adÃo moveis electrodomesticos,lda'
20241014@182851.3979 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.3983 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from td where ndoc = 39
20241014@182851.3997 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241014@182851.4012 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.4029 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182851.4051 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.4067 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182851.4098 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.4114 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182851.4128 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182851.4192 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182851.4204 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.4219 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182851.4234 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241014@182851.4377 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.4394 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182851.4428 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241014@182851.4441 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241014@182851.4454 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241014@182851.4468 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241014@182851.4483 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241014@182851.4496 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241014@182851.4509 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670d572317670d54d364',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241014@182851.4706 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 fno valor from wsftdata order by fno desc
20241014@182851.4729 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.4746 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182851.4770 7ulhqoeg3j4jacct3ecpk5k33h Query : select 'normal' from dummy
20241014@182851.4787 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670d572317670d54d364',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1265,101648,0,'2024-10-14',39,'euro',0,0,2024 ,?,?)
20241014@182851.6354 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.6358 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241014@182851.6380 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.6491 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.6506 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.6532 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.6547 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.6555 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.6566 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2100585500a'
20241014@182851.6593 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.6606 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.6618 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d581719670d54d3a0','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.6622 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.6635 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.6662 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d581719670d54d3a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241014@182851.6865 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.6867 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241014@182851.6887 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.6900 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.6916 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.6940 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.6955 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.6965 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.6979 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2300509100a'
20241014@182851.6991 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7006 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.7016 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d542395670d54d3aa','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.7021 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7035 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.7064 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d542395670d54d3aa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241014@182851.7274 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.7277 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241014@182851.7298 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.7407 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7424 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.7448 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7462 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.7470 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.7481 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100585300a'
20241014@182851.7493 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7507 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.7519 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d585834670d54d3b6','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.7523 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7537 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.7566 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d585834670d54d3b6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241014@182851.7772 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.7775 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241014@182851.7794 7ulhqoeg3j4jacct3ecpk5k33h 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'
20241014@182851.7806 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7820 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.7844 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7858 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.7867 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.7878 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241014@182851.7890 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7906 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.7918 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d519904670d54d3c0','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.7921 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.7936 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.7965 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d519904670d54d3c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241014@182851.8185 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.8188 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241014@182851.8208 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2340.00.1'
20241014@182851.8319 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8334 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.8362 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8376 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.8384 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.8396 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241014@182851.8409 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8423 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.8435 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d545050670d54d3cd','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.8439 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8454 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.8481 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d545050670d54d3cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241014@182851.8686 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.8689 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241014@182851.8710 7ulhqoeg3j4jacct3ecpk5k33h 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.1317.00.1'
20241014@182851.8823 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8838 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.8864 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8879 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.8888 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.8900 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400458200a'
20241014@182851.8913 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8928 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.8940 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d549712670d54d3d9','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.8943 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.8959 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.8986 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d549712670d54d3d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241014@182851.9185 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.9188 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241014@182851.9208 7ulhqoeg3j4jacct3ecpk5k33h 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.1321.00.1'
20241014@182851.9558 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.9575 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.9599 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.9617 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.9626 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182851.9638 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241014@182851.9651 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.9668 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182851.9679 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d575926670d54d3eb','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182851.9684 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.9699 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182851.9727 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d575926670d54d3eb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241014@182851.9945 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182851.9948 7ulhqoeg3j4jacct3ecpk5k33h Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241014@182851.9969 7ulhqoeg3j4jacct3ecpk5k33h 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.1321.00.1'
20241014@182851.9983 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182851.9999 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182852.2500 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.4100 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182852.4900 7ulhqoeg3j4jacct3ecpk5k33h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182852.6100 7ulhqoeg3j4jacct3ecpk5k33h Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241014@182852.7400 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.8800 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182852.1000 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d558592670d54d401','aut670d572317670d54d364' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182852.1050 7ulhqoeg3j4jacct3ecpk5k33h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.1190 7ulhqoeg3j4jacct3ecpk5k33h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182852.1470 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d558592670d54d401',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut670d572317670d54d364' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241014@182852.3500 7ulhqoeg3j4jacct3ecpk5k33h Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670d572317670d54d364','2406711','wait',39,'adm09112754980.682000002')
20241014@182852.4210 7ulhqoeg3j4jacct3ecpk5k33h Query : use flama_phc
20241014@182852.4240 7ulhqoeg3j4jacct3ecpk5k33h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241014@182852.4530 7ulhqoeg3j4jacct3ecpk5k33h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2642';
20241014@182852.4860 7ulhqoeg3j4jacct3ecpk5k33h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2642';
20241014@182852.5310 7ulhqoeg3j4jacct3ecpk5k33h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2642';
20241014@182852.5580 7ulhqoeg3j4jacct3ecpk5k33h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2642';
20241014@182852.2565 114mtugcn9sv79scm5blv89df4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241014@182852.2577 114mtugcn9sv79scm5blv89df4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241014@182852.2635 114mtugcn9sv79scm5blv89df4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2643';
20241014@182852.2695 114mtugcn9sv79scm5blv89df4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2643';
20241014@182852.2747 114mtugcn9sv79scm5blv89df4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2643';
20241014@182852.2771 114mtugcn9sv79scm5blv89df4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2643';
20241014@182852.2826 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.2829 114mtugcn9sv79scm5blv89df4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241014@182852.2890 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.2893 114mtugcn9sv79scm5blv89df4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=416
20241014@182852.2972 114mtugcn9sv79scm5blv89df4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4970.00.1'
20241014@182852.2991 114mtugcn9sv79scm5blv89df4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406719 and bi.ref ='324.4970.00.1' and bi.lordem =1
20241014@182852.3279 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3282 114mtugcn9sv79scm5blv89df4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241014@182852.3315 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3318 114mtugcn9sv79scm5blv89df4 Query : select top 1 1 valor from td where td.ndoc = 39
20241014@182852.3351 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3354 114mtugcn9sv79scm5blv89df4 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')
20241014@182852.3382 114mtugcn9sv79scm5blv89df4 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
20241014@182852.3416 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3419 114mtugcn9sv79scm5blv89df4 Query : select top 1 ~inactivo valor from cl where no = '102079' and estab = 0 order by inactivo desc
20241014@182852.3518 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3520 114mtugcn9sv79scm5blv89df4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241014@182852.3550 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3553 114mtugcn9sv79scm5blv89df4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241014@182852.3595 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3598 114mtugcn9sv79scm5blv89df4 Query : select szadrsstamp valor from szadrs where szadrsdesc='bragajav, lda.'
20241014@182852.3645 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.3648 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from td where ndoc = 39
20241014@182852.3660 114mtugcn9sv79scm5blv89df4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241014@182852.3674 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.3690 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182852.3710 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.3726 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182852.3754 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.3768 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182852.3780 114mtugcn9sv79scm5blv89df4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182852.3844 114mtugcn9sv79scm5blv89df4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182852.3857 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.3872 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182852.3888 114mtugcn9sv79scm5blv89df4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670d538246670d54d45c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241014@182852.4030 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.4046 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182852.4078 114mtugcn9sv79scm5blv89df4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241014@182852.4090 114mtugcn9sv79scm5blv89df4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241014@182852.4101 114mtugcn9sv79scm5blv89df4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241014@182852.4114 114mtugcn9sv79scm5blv89df4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241014@182852.4125 114mtugcn9sv79scm5blv89df4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241014@182852.4136 114mtugcn9sv79scm5blv89df4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241014@182852.4147 114mtugcn9sv79scm5blv89df4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670d538246670d54d45c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241014@182852.4352 114mtugcn9sv79scm5blv89df4 Query : select top 1 fno valor from wsftdata order by fno desc
20241014@182852.4376 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.4398 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182852.4420 114mtugcn9sv79scm5blv89df4 Query : select 'normal' from dummy
20241014@182852.4435 114mtugcn9sv79scm5blv89df4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670d538246670d54d45c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1266,102079,0,'2024-10-14',39,'euro',0,0,2024 ,?,?)
20241014@182852.4688 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.4691 114mtugcn9sv79scm5blv89df4 Query : select st.usalote valor from st where st.ref = '324.4970.00.1'
20241014@182852.4714 114mtugcn9sv79scm5blv89df4 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.4970.00.1'
20241014@182852.4729 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.4744 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182852.4767 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.4781 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182852.4790 114mtugcn9sv79scm5blv89df4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182852.4801 114mtugcn9sv79scm5blv89df4 Query : select sestamp valor from se where ref ='324.4970.00.1' and lote = 'r2400205200a'
20241014@182852.4813 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.4826 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182852.4838 114mtugcn9sv79scm5blv89df4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d594182670d54d475','aut670d538246670d54d45c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182852.4841 114mtugcn9sv79scm5blv89df4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182852.4855 114mtugcn9sv79scm5blv89df4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182852.4882 114mtugcn9sv79scm5blv89df4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d594182670d54d475',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut670d538246670d54d45c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241014@182852.5102 114mtugcn9sv79scm5blv89df4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut670d538246670d54d45c','2406719','wait',39,'adm09112754980.682000002')
20241014@182852.5181 114mtugcn9sv79scm5blv89df4 Query : use flama_phc
20241014@182852.5185 114mtugcn9sv79scm5blv89df4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241014@182852.5221 114mtugcn9sv79scm5blv89df4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2643';
20241014@182852.5252 114mtugcn9sv79scm5blv89df4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2643';
20241014@182852.5294 114mtugcn9sv79scm5blv89df4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2643';
20241014@182852.5319 114mtugcn9sv79scm5blv89df4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2643';
20241014@182852.5931 kg65f9rd25k5s0gpmiunob9l0s Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241014@182852.5941 kg65f9rd25k5s0gpmiunob9l0s Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241014@182852.6002 kg65f9rd25k5s0gpmiunob9l0s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2644';
20241014@182852.6058 kg65f9rd25k5s0gpmiunob9l0s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2644';
20241014@182852.6112 kg65f9rd25k5s0gpmiunob9l0s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2644';
20241014@182852.6139 kg65f9rd25k5s0gpmiunob9l0s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2644';
20241014@182852.6189 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182852.6192 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241014@182852.6259 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182852.6262 kg65f9rd25k5s0gpmiunob9l0s Query : select no, estab,szadrsdesc from szadrs where u_coddest=410
20241014@182852.6340 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2317.00.1'
20241014@182852.6478 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='324.2317.00.1' and bi.lordem =1
20241014@182852.6764 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.2315.00.1'
20241014@182852.6868 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='304.2315.00.1' and bi.lordem =2
20241014@182852.7150 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2318.00.1'
20241014@182852.7259 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='324.2318.00.1' and bi.lordem =3
20241014@182852.7549 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2362.00.1'
20241014@182852.7666 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='324.2362.00.1' and bi.lordem =4
20241014@182852.8025 kg65f9rd25k5s0gpmiunob9l0s 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'
20241014@182852.8054 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='324.2335.00.1' and bi.lordem =5
20241014@182852.8346 kg65f9rd25k5s0gpmiunob9l0s 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'
20241014@182852.8368 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='324.2335.00.1' and bi.lordem =5
20241014@182852.8386 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241014@182852.8494 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='324.1332.00.1' and bi.lordem =6
20241014@182852.9859 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1329.00.1'
20241014@182852.9885 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2067 and bo.obrano = 2406721 and bi.ref ='324.1329.00.1' and bi.lordem =7
20241014@182853.1820 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.1860 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241014@182853.2770 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.2810 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 1 valor from td where td.ndoc = 39
20241014@182853.3180 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.3290 kg65f9rd25k5s0gpmiunob9l0s 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')
20241014@182853.3620 kg65f9rd25k5s0gpmiunob9l0s 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
20241014@182853.4000 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.4030 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 ~inactivo valor from cl where no = '102212' and estab = 0 order by inactivo desc
20241014@182853.5020 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.5070 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241014@182853.5410 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.5450 kg65f9rd25k5s0gpmiunob9l0s Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241014@182853.5880 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.5920 kg65f9rd25k5s0gpmiunob9l0s Query : select szadrsstamp valor from szadrs where szadrsdesc='tomarel-soc.tecnica electricidade, lda.'
20241014@182853.6430 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.6460 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from td where ndoc = 39
20241014@182853.6600 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241014@182853.6780 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.6970 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182853.7210 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.7390 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182853.7700 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.7850 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182853.7990 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182853.8620 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241014@182853.8770 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.8940 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241014@182853.9100 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241014@182853.1059 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.1077 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241014@182853.1115 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241014@182853.1129 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241014@182853.1143 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241014@182853.1157 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241014@182853.1171 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241014@182853.1184 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241014@182853.1197 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut670d584929670d54d513',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241014@182853.1408 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 fno valor from wsftdata order by fno desc
20241014@182853.1432 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.1450 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241014@182853.1476 kg65f9rd25k5s0gpmiunob9l0s Query : select 'normal' from dummy
20241014@182853.1493 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut670d584929670d54d513',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1267,102212,0,'2024-10-14',39,'euro',0,0,2024 ,?,?)
20241014@182853.1758 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.1761 kg65f9rd25k5s0gpmiunob9l0s Query : select st.usalote valor from st where st.ref = '324.2317.00.1'
20241014@182853.1785 kg65f9rd25k5s0gpmiunob9l0s 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.2317.00.1'
20241014@182853.1896 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.1913 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.1941 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.1957 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.1965 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182853.1982 kg65f9rd25k5s0gpmiunob9l0s Query : select sestamp valor from se where ref ='324.2317.00.1' and lote = 'r2100576500a'
20241014@182853.2002 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2019 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.2030 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d558919670d54d530','aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182853.2034 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2048 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.2075 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d558919670d54d530',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut670d584929670d54d513' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241014@182853.2293 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2321 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.2352 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2369 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.2379 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182853.2393 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2409 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.2421 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d541830670d54d53a','aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182853.2426 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2442 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.2473 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670d541830670d54d53a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670d584929670d54d513' ,0,0 ,2,23.00,20000,?,?,?)
20241014@182853.2682 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.2685 kg65f9rd25k5s0gpmiunob9l0s Query : select st.usalote valor from st where st.ref = '304.2315.00.1'
20241014@182853.2707 kg65f9rd25k5s0gpmiunob9l0s 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 = '304.2315.00.1'
20241014@182853.2817 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2835 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.2865 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2882 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.2892 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182853.2906 kg65f9rd25k5s0gpmiunob9l0s Query : select sestamp valor from se where ref ='304.2315.00.1' and lote = 's2300276100a'
20241014@182853.2928 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2949 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.2963 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d578750670d54d547','aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182853.2967 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.2983 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.3015 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d578750670d54d547',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut670d584929670d54d513' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241014@182853.3234 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3251 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.3281 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3298 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.3308 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182853.3324 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3341 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.3355 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d573735670d54d551','aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182853.3360 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3377 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.3410 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670d573735670d54d551',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670d584929670d54d513' ,0,0 ,2,23.00,50000,?,?,?)
20241014@182853.3621 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.3624 kg65f9rd25k5s0gpmiunob9l0s Query : select st.usalote valor from st where st.ref = '324.2318.00.1'
20241014@182853.3646 kg65f9rd25k5s0gpmiunob9l0s 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.2318.00.1'
20241014@182853.3759 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3777 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.3807 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3822 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.3832 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182853.3845 kg65f9rd25k5s0gpmiunob9l0s Query : select sestamp valor from se where ref ='324.2318.00.1' and lote = 'r2100669100a'
20241014@182853.3867 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3884 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.3898 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d502343670d54d55e','aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182853.3903 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.3918 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.3951 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut670d502343670d54d55e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut670d584929670d54d513' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241014@182853.4169 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.4186 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.4217 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.4233 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.4243 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182853.4256 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.4272 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.4518 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d508044670d54d567','aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182853.4560 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.5423 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.5456 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut670d508044670d54d567',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut670d584929670d54d513' ,0,0 ,2,23.00,80000,?,?,?)
20241014@182853.5686 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.5689 kg65f9rd25k5s0gpmiunob9l0s Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20241014@182853.5709 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2362.00.1'
20241014@182853.5823 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.5838 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241014@182853.5863 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.5876 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.5884 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241014@182853.5897 kg65f9rd25k5s0gpmiunob9l0s Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = '324.2362.00.1'
20241014@182853.5907 kg65f9rd25k5s0gpmiunob9l0s Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241014@182853.5922 kg65f9rd25k5s0gpmiunob9l0s Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241014@182853.5936 kg65f9rd25k5s0gpmiunob9l0s Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut670d531344670d54d590','aut670d584929670d54d513' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241014@182853.5955 kg65f9rd25k5s0gpmiunob9l0s Query : use flama_phc
20241014@182853.5957 kg65f9rd25k5s0gpmiunob9l0s Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241014@182853.5989 kg65f9rd25k5s0gpmiunob9l0s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2644';
20241014@182853.6019 kg65f9rd25k5s0gpmiunob9l0s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2644';
