20241104@174532.7480 vsgr63qg54ni019f5f8uu339uf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174532.7499 vsgr63qg54ni019f5f8uu339uf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174532.7525 vsgr63qg54ni019f5f8uu339uf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174532.7540 vsgr63qg54ni019f5f8uu339uf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174532.7549 vsgr63qg54ni019f5f8uu339uf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174532.7563 vsgr63qg54ni019f5f8uu339uf Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400526200a'
20241104@174532.7577 vsgr63qg54ni019f5f8uu339uf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174532.7591 vsgr63qg54ni019f5f8uu339uf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174532.7604 vsgr63qg54ni019f5f8uu339uf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290866586729083cb8','aut67290531666729083c9a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174532.7608 vsgr63qg54ni019f5f8uu339uf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174532.7624 vsgr63qg54ni019f5f8uu339uf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174532.7653 vsgr63qg54ni019f5f8uu339uf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290866586729083cb8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut67290531666729083c9a' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174532.7945 vsgr63qg54ni019f5f8uu339uf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67290531666729083c9a','2407208','wait',39,'adm09112754980.682000002')
20241104@174532.8025 vsgr63qg54ni019f5f8uu339uf Query : use flama_phc
20241104@174532.8028 vsgr63qg54ni019f5f8uu339uf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174532.8057 vsgr63qg54ni019f5f8uu339uf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3069';
20241104@174532.8102 vsgr63qg54ni019f5f8uu339uf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3069';
20241104@174532.8148 vsgr63qg54ni019f5f8uu339uf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3069';
20241104@174532.8176 vsgr63qg54ni019f5f8uu339uf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3069';
20241104@174532.8709 93fupj8pollcjqpjos32hd1kq2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174532.8720 93fupj8pollcjqpjos32hd1kq2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174532.8782 93fupj8pollcjqpjos32hd1kq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3070';
20241104@174532.8850 93fupj8pollcjqpjos32hd1kq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3070';
20241104@174532.8909 93fupj8pollcjqpjos32hd1kq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3070';
20241104@174532.8939 93fupj8pollcjqpjos32hd1kq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3070';
20241104@174532.8989 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.8992 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174532.9052 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9055 93fupj8pollcjqpjos32hd1kq2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=323
20241104@174532.9147 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20241104@174532.9167 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407209 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241104@174532.9530 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1642.00.2'
20241104@174532.9550 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407209 and bi.ref ='324.1642.00.2' and bi.lordem =1
20241104@174532.9567 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9571 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174532.9604 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9607 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174532.9638 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9640 93fupj8pollcjqpjos32hd1kq2 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')
20241104@174532.9668 93fupj8pollcjqpjos32hd1kq2 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
20241104@174532.9702 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9705 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241104@174532.9735 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9738 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174532.9767 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9770 93fupj8pollcjqpjos32hd1kq2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174532.9807 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9810 93fupj8pollcjqpjos32hd1kq2 Query : select szadrsstamp valor from szadrs where szadrsdesc='joaquim oliveira mendes,lda jom- brg retail'
20241104@174532.9855 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174532.9858 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from td where ndoc = 39
20241104@174532.9871 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174532.9884 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174532.9901 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174532.9920 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174532.9935 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174532.9964 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174532.9979 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174532.9992 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174533.5400 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174533.6700 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.8200 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174533.9700 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67290977026729083cf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174533.2930 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.3120 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174533.5670 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174533.5800 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174533.5930 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174533.6150 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174533.6270 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174533.6390 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174533.6510 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67290977026729083cf3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174533.1002 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174533.1031 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.1049 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174533.1071 93fupj8pollcjqpjos32hd1kq2 Query : select 'normal' from dummy
20241104@174533.1086 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67290977026729083cf3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1643,101621,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174533.1446 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174533.1449 93fupj8pollcjqpjos32hd1kq2 Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241104@174533.1472 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1642.00.2'
20241104@174533.1485 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.1501 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174533.1526 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.1541 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174533.1550 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174533.1562 93fupj8pollcjqpjos32hd1kq2 Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241104@174533.1595 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.1610 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174533.1622 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290499876729083d26','aut67290977026729083cf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174533.1626 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.1640 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174533.1670 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290499876729083d26',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67290977026729083cf3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174533.1983 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174533.1986 93fupj8pollcjqpjos32hd1kq2 Query : select st.usalote valor from st where st.ref = '324.1642.00.2'
20241104@174533.2006 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1642.00.2'
20241104@174533.2022 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.2040 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174533.2066 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.2081 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174533.2090 93fupj8pollcjqpjos32hd1kq2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174533.2103 93fupj8pollcjqpjos32hd1kq2 Query : select sestamp valor from se where ref ='324.1642.00.2' and lote = 'r2400725200a'
20241104@174533.2116 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.2130 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174533.2142 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290560466729083d33','aut67290977026729083cf3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174533.2147 93fupj8pollcjqpjos32hd1kq2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.2161 93fupj8pollcjqpjos32hd1kq2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174533.2191 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290560466729083d33',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67290977026729083cf3' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241104@174533.2498 93fupj8pollcjqpjos32hd1kq2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67290977026729083cf3','2407209','wait',39,'adm09112754980.682000002')
20241104@174533.2567 93fupj8pollcjqpjos32hd1kq2 Query : use flama_phc
20241104@174533.2570 93fupj8pollcjqpjos32hd1kq2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174533.2614 93fupj8pollcjqpjos32hd1kq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3070';
20241104@174533.2653 93fupj8pollcjqpjos32hd1kq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3070';
20241104@174533.2699 93fupj8pollcjqpjos32hd1kq2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3070';
20241104@174533.2727 93fupj8pollcjqpjos32hd1kq2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3070';
20241104@174533.3343 lckpdcu9jcffrqgj304uth8g1k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174533.3353 lckpdcu9jcffrqgj304uth8g1k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174533.3416 lckpdcu9jcffrqgj304uth8g1k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3071';
20241104@174533.3479 lckpdcu9jcffrqgj304uth8g1k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3071';
20241104@174533.3535 lckpdcu9jcffrqgj304uth8g1k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3071';
20241104@174533.3564 lckpdcu9jcffrqgj304uth8g1k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3071';
20241104@174533.3615 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.3619 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174533.3678 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.3681 lckpdcu9jcffrqgj304uth8g1k Query : select no, estab,szadrsdesc from szadrs where u_coddest=548
20241104@174533.3776 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.678.00.01'
20241104@174533.3795 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.678.00.01' and bi.lordem =1
20241104@174533.4155 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.678.00.01'
20241104@174533.4176 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.678.00.01' and bi.lordem =1
20241104@174533.4191 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.644.00.01'
20241104@174533.4379 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.644.00.01' and bi.lordem =2
20241104@174533.4733 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174533.4752 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.1329.00.1' and bi.lordem =3
20241104@174533.5109 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174533.5128 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.1317.00.1' and bi.lordem =4
20241104@174533.5485 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174533.5610 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.2330.00.1' and bi.lordem =5
20241104@174533.6570 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174533.6592 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.2335.00.1' and bi.lordem =6
20241104@174533.7001 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174533.7023 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.2340.00.1' and bi.lordem =7
20241104@174533.7387 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2357.00.1'
20241104@174533.7406 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.2357.00.1' and bi.lordem =8
20241104@174533.7835 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174533.7858 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.2362.00.1' and bi.lordem =9
20241104@174533.8219 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2366.00.1'
20241104@174533.8242 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.2366.00.1' and bi.lordem =10
20241104@174533.8598 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174533.8618 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407210 and bi.ref ='324.2318.00.1' and bi.lordem =11
20241104@174533.8985 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.8989 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174533.9020 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.9023 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174533.9051 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.9053 lckpdcu9jcffrqgj304uth8g1k 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')
20241104@174533.9081 lckpdcu9jcffrqgj304uth8g1k 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
20241104@174533.9113 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.9116 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 ~inactivo valor from cl where no = '101488' and estab = 0 order by inactivo desc
20241104@174533.9266 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.9269 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174533.9297 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.9300 lckpdcu9jcffrqgj304uth8g1k Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174533.9342 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.9344 lckpdcu9jcffrqgj304uth8g1k Query : select szadrsstamp valor from szadrs where szadrsdesc='electro ferreira leite,lda'
20241104@174533.9388 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174533.9391 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from td where ndoc = 39
20241104@174533.9402 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174533.9415 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.9432 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174533.9449 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.9463 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174533.9492 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.9507 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174533.9519 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174533.9589 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174533.9603 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.9622 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174533.9639 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174533.9856 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174533.9875 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174533.9908 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174533.9920 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174533.9931 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174533.9943 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174533.9954 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174533.9966 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174533.9976 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67290513426729083de8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174534.2500 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174534.2760 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2920 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174534.3130 lckpdcu9jcffrqgj304uth8g1k Query : select 'normal' from dummy
20241104@174534.3270 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67290513426729083de8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1644,101488,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174534.9460 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.9490 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.678.00.01'
20241104@174534.9700 lckpdcu9jcffrqgj304uth8g1k 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.678.00.01'
20241104@174534.9840 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1000 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.1024 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1038 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.1046 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.1057 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.678.00.01' and lote = 'r2400745200a'
20241104@174534.1189 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1319 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.1331 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290313706729083e1d','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.1336 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1351 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.1377 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290313706729083e1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174534.1694 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1711 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.1735 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1749 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.1757 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.1768 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1782 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.1793 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290041306729083e2b','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.1797 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.1811 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.1837 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67290041306729083e2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67290513426729083de8' ,0,0 ,2,23.00,20000,?,?,?)
20241104@174534.2146 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.2149 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.678.00.01'
20241104@174534.2169 lckpdcu9jcffrqgj304uth8g1k 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.678.00.01'
20241104@174534.2182 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2198 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.2223 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2238 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.2246 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.2258 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.678.00.01' and lote = 'r2400745200a'
20241104@174534.2271 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2285 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.2298 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290203076729083e37','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.2303 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2319 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.2347 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290203076729083e37',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241104@174534.2630 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2645 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.2669 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2682 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.2690 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.2701 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2716 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.2726 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290898526729083e41','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.2731 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.2744 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.2771 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67290898526729083e41',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67290513426729083de8' ,0,0 ,2,23.00,50000,?,?,?)
20241104@174534.3059 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.3062 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.644.00.01'
20241104@174534.3082 lckpdcu9jcffrqgj304uth8g1k 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.644.00.01'
20241104@174534.3244 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3260 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.3283 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3297 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.3306 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.3318 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.644.00.01' and lote = 'r2400749200a'
20241104@174534.3331 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3345 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.3357 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290699106729083e51','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.3361 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3375 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.3402 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290699106729083e51',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241104@174534.3668 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.3671 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.1329.00.1'
20241104@174534.3689 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174534.3702 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3717 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.3741 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3756 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.3764 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.3776 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.1329.00.1' and lote = 'r2400496300a'
20241104@174534.3787 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3801 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.3813 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290548826729083e5c','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.3817 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.3831 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.3856 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290548826729083e5c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241104@174534.4142 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.4145 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.1317.00.1'
20241104@174534.4164 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174534.4200 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4217 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.4241 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4255 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.4264 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.4275 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.1317.00.1' and lote = 'r2400459200a'
20241104@174534.4287 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4302 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.4314 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290475836729083e68','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.4318 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4331 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.4357 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290475836729083e68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241104@174534.4642 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.4645 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241104@174534.4666 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174534.4679 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4695 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.4719 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4732 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.4741 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.4752 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241104@174534.4764 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4778 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.4789 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290046546729083e74','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.4793 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.4807 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.4834 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290046546729083e74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241104@174534.5148 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.5151 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241104@174534.5170 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174534.5183 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5199 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.5224 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5238 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.5246 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.5257 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241104@174534.5269 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5282 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.5294 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290067596729083e80','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.5299 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5314 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.5340 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290067596729083e80',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,110000,?,?,?,?,?)
20241104@174534.5631 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.5634 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.2340.00.1'
20241104@174534.5652 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174534.5666 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5682 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.5705 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5719 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.5729 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.5741 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.2340.00.1' and lote = 'r2100584120a'
20241104@174534.5753 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5768 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.5779 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290396066729083e8c','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.5784 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.5798 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.5824 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290396066729083e8c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20241104@174534.6109 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.6112 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.2357.00.1'
20241104@174534.6131 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2357.00.1'
20241104@174534.6145 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6162 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.6185 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6199 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.6207 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.6218 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.2357.00.1' and lote = 'r2200239100a'
20241104@174534.6229 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6243 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.6253 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290942416729083e98','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.6258 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6271 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.6297 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290942416729083e98',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241104@174534.6577 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.6580 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.2362.00.1'
20241104@174534.6599 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174534.6613 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6629 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.6653 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6667 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.6675 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.6686 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.2362.00.1' and lote = 'r2400498400a'
20241104@174534.6698 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6713 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.6724 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290837026729083ea3','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.6729 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.6742 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.6769 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290837026729083ea3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20241104@174534.7065 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.7068 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241104@174534.7088 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2366.00.1'
20241104@174534.7102 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7119 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.7143 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7158 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.7166 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.7202 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2400498100a'
20241104@174534.7214 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7235 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.7246 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290223056729083eb0','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.7251 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7265 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.7291 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290223056729083eb0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20241104@174534.7592 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174534.7596 lckpdcu9jcffrqgj304uth8g1k Query : select st.usalote valor from st where st.ref = '324.2318.00.1'
20241104@174534.7615 lckpdcu9jcffrqgj304uth8g1k 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'
20241104@174534.7628 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7643 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.7673 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7688 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.7696 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.7710 lckpdcu9jcffrqgj304uth8g1k Query : select sestamp valor from se where ref ='324.2318.00.1' and lote = 'r2100669100a'
20241104@174534.7724 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7739 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.7752 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290931296729083ebc','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174534.7785 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.7800 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.8115 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290931296729083ebc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut67290513426729083de8' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241104@174534.9054 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.9309 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174534.9837 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174534.9862 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174534.9877 lckpdcu9jcffrqgj304uth8g1k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174534.9896 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.1110 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174535.1630 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290123386729083ef1','aut67290513426729083de8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174535.1690 lckpdcu9jcffrqgj304uth8g1k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.6130 lckpdcu9jcffrqgj304uth8g1k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174535.1362 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut67290123386729083ef1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67290513426729083de8' ,0,0 ,2,23.00,170000,?,?,?)
20241104@174535.2073 lckpdcu9jcffrqgj304uth8g1k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67290513426729083de8','2407210','wait',39,'adm09112754980.682000002')
20241104@174535.3935 lckpdcu9jcffrqgj304uth8g1k Query : use flama_phc
20241104@174535.3977 lckpdcu9jcffrqgj304uth8g1k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174535.4223 lckpdcu9jcffrqgj304uth8g1k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3071';
20241104@174535.4530 lckpdcu9jcffrqgj304uth8g1k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3071';
20241104@174535.4921 lckpdcu9jcffrqgj304uth8g1k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3071';
20241104@174535.5264 lckpdcu9jcffrqgj304uth8g1k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3071';
20241104@174535.6428 u9693kne4lrp2dufgvk7635kbt Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174535.6439 u9693kne4lrp2dufgvk7635kbt Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174535.6502 u9693kne4lrp2dufgvk7635kbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3072';
20241104@174535.6564 u9693kne4lrp2dufgvk7635kbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3072';
20241104@174535.6619 u9693kne4lrp2dufgvk7635kbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3072';
20241104@174535.6648 u9693kne4lrp2dufgvk7635kbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3072';
20241104@174535.6697 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.6700 u9693kne4lrp2dufgvk7635kbt Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174535.6758 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.6761 u9693kne4lrp2dufgvk7635kbt Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174535.6854 u9693kne4lrp2dufgvk7635kbt Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.367.09.00'
20241104@174535.7034 u9693kne4lrp2dufgvk7635kbt Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407213 and bi.ref ='323.367.09.00' and bi.lordem =1
20241104@174535.7391 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7394 u9693kne4lrp2dufgvk7635kbt Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174535.7428 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7430 u9693kne4lrp2dufgvk7635kbt Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174535.7493 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7496 u9693kne4lrp2dufgvk7635kbt 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')
20241104@174535.7539 u9693kne4lrp2dufgvk7635kbt 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
20241104@174535.7578 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7581 u9693kne4lrp2dufgvk7635kbt Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174535.7723 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7726 u9693kne4lrp2dufgvk7635kbt Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174535.7755 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7758 u9693kne4lrp2dufgvk7635kbt Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174535.7799 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7802 u9693kne4lrp2dufgvk7635kbt Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241104@174535.7849 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.7852 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from td where ndoc = 39
20241104@174535.7865 u9693kne4lrp2dufgvk7635kbt Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174535.7878 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.7895 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174535.7914 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.7927 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174535.7953 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.7972 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174535.7984 u9693kne4lrp2dufgvk7635kbt Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174535.8047 u9693kne4lrp2dufgvk7635kbt Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174535.8059 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.8072 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174535.8087 u9693kne4lrp2dufgvk7635kbt Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67290600646729083fc2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174535.8302 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.8341 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174535.8370 u9693kne4lrp2dufgvk7635kbt Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174535.8402 u9693kne4lrp2dufgvk7635kbt Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174535.8428 u9693kne4lrp2dufgvk7635kbt Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174535.8439 u9693kne4lrp2dufgvk7635kbt Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174535.8449 u9693kne4lrp2dufgvk7635kbt Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174535.8461 u9693kne4lrp2dufgvk7635kbt Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174535.8472 u9693kne4lrp2dufgvk7635kbt Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67290600646729083fc2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174535.8762 u9693kne4lrp2dufgvk7635kbt Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174535.8789 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.8820 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174535.8841 u9693kne4lrp2dufgvk7635kbt Query : select 'normal' from dummy
20241104@174535.8855 u9693kne4lrp2dufgvk7635kbt Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67290600646729083fc2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1645,100810,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174535.9195 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174535.9198 u9693kne4lrp2dufgvk7635kbt Query : select st.usalote valor from st where st.ref = '323.367.09.00'
20241104@174535.9221 u9693kne4lrp2dufgvk7635kbt 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 = '323.367.09.00'
20241104@174535.9411 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.9427 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174535.9451 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.9466 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174535.9474 u9693kne4lrp2dufgvk7635kbt Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174535.9489 u9693kne4lrp2dufgvk7635kbt Query : select sestamp valor from se where ref ='323.367.09.00' and lote = 'r2400053200a'
20241104@174535.9509 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.9523 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174535.9534 u9693kne4lrp2dufgvk7635kbt Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut67290885576729083fe8','aut67290600646729083fc2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174535.9539 u9693kne4lrp2dufgvk7635kbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174535.9552 u9693kne4lrp2dufgvk7635kbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174535.9579 u9693kne4lrp2dufgvk7635kbt Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut67290885576729083fe8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67290600646729083fc2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174535.9945 u9693kne4lrp2dufgvk7635kbt Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67290600646729083fc2','2407213','wait',39,'adm09112754980.682000002')
20241104@174536.1300 u9693kne4lrp2dufgvk7635kbt Query : use flama_phc
20241104@174536.1600 u9693kne4lrp2dufgvk7635kbt Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174536.5600 u9693kne4lrp2dufgvk7635kbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3072';
20241104@174536.9400 u9693kne4lrp2dufgvk7635kbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3072';
20241104@174536.1390 u9693kne4lrp2dufgvk7635kbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3072';
20241104@174536.1650 u9693kne4lrp2dufgvk7635kbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3072';
20241104@174536.9430 lldtaog30liub4a9a88deerfeo Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174536.9550 lldtaog30liub4a9a88deerfeo Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174536.1019 lldtaog30liub4a9a88deerfeo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3073';
20241104@174536.1098 lldtaog30liub4a9a88deerfeo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3073';
20241104@174536.1176 lldtaog30liub4a9a88deerfeo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3073';
20241104@174536.1205 lldtaog30liub4a9a88deerfeo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3073';
20241104@174536.1256 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.1259 lldtaog30liub4a9a88deerfeo Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174536.1320 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.1323 lldtaog30liub4a9a88deerfeo Query : select no, estab,szadrsdesc from szadrs where u_coddest=5187
20241104@174536.1423 lldtaog30liub4a9a88deerfeo 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'
20241104@174536.1443 lldtaog30liub4a9a88deerfeo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407215 and bi.ref ='324.1332.00.1' and bi.lordem =1
20241104@174536.1813 lldtaog30liub4a9a88deerfeo 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'
20241104@174536.1834 lldtaog30liub4a9a88deerfeo Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407215 and bi.ref ='324.1332.00.1' and bi.lordem =1
20241104@174536.1851 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.1854 lldtaog30liub4a9a88deerfeo Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174536.1887 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.1890 lldtaog30liub4a9a88deerfeo Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174536.1921 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.1924 lldtaog30liub4a9a88deerfeo 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')
20241104@174536.1954 lldtaog30liub4a9a88deerfeo 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
20241104@174536.2004 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.2010 lldtaog30liub4a9a88deerfeo Query : select top 1 ~inactivo valor from cl where no = '200500' and estab = 0 order by inactivo desc
20241104@174536.2158 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.2162 lldtaog30liub4a9a88deerfeo Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174536.2216 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.2219 lldtaog30liub4a9a88deerfeo Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174536.2258 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.2262 lldtaog30liub4a9a88deerfeo Query : select szadrsstamp valor from szadrs where szadrsdesc='eldisser, s.a. - grucoga'
20241104@174536.2354 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.2357 lldtaog30liub4a9a88deerfeo Query : select 1 valor from td where ndoc = 39
20241104@174536.2369 lldtaog30liub4a9a88deerfeo Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174536.2383 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.2399 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174536.2426 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.2441 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174536.2469 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.2484 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174536.2496 lldtaog30liub4a9a88deerfeo Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174536.2560 lldtaog30liub4a9a88deerfeo Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174536.2573 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.2588 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174536.2604 lldtaog30liub4a9a88deerfeo Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6729073244672908403c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174536.2822 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.2842 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174536.2876 lldtaog30liub4a9a88deerfeo Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174536.2888 lldtaog30liub4a9a88deerfeo Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174536.2901 lldtaog30liub4a9a88deerfeo Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174536.2913 lldtaog30liub4a9a88deerfeo Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174536.2925 lldtaog30liub4a9a88deerfeo Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174536.2937 lldtaog30liub4a9a88deerfeo Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174536.2948 lldtaog30liub4a9a88deerfeo Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6729073244672908403c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174536.3247 lldtaog30liub4a9a88deerfeo Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174536.3276 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.3292 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174536.3315 lldtaog30liub4a9a88deerfeo Query : select 'normal' from dummy
20241104@174536.3330 lldtaog30liub4a9a88deerfeo Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6729073244672908403c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1646,200500,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174536.3677 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.3680 lldtaog30liub4a9a88deerfeo Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241104@174536.3701 lldtaog30liub4a9a88deerfeo 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.1332.00.1'
20241104@174536.3716 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.3732 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174536.3757 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.3771 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174536.3780 lldtaog30liub4a9a88deerfeo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174536.3791 lldtaog30liub4a9a88deerfeo Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241104@174536.3803 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.3818 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174536.3829 lldtaog30liub4a9a88deerfeo Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729050013672908405c','aut6729073244672908403c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174536.3833 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.3847 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174536.3875 lldtaog30liub4a9a88deerfeo Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729050013672908405c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut6729073244672908403c' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174536.4153 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.4156 lldtaog30liub4a9a88deerfeo Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241104@174536.4176 lldtaog30liub4a9a88deerfeo 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.1332.00.1'
20241104@174536.4189 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.4205 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174536.4460 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.4481 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174536.4490 lldtaog30liub4a9a88deerfeo Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174536.4501 lldtaog30liub4a9a88deerfeo Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241104@174536.4514 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.4528 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174536.4540 lldtaog30liub4a9a88deerfeo Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729046954672908406e','aut6729073244672908403c' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174536.4546 lldtaog30liub4a9a88deerfeo Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.4561 lldtaog30liub4a9a88deerfeo Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174536.4589 lldtaog30liub4a9a88deerfeo Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6729046954672908406e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut6729073244672908403c' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241104@174536.4876 lldtaog30liub4a9a88deerfeo Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6729073244672908403c','2407215','wait',39,'adm09112754980.682000002')
20241104@174536.4943 lldtaog30liub4a9a88deerfeo Query : use flama_phc
20241104@174536.4946 lldtaog30liub4a9a88deerfeo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174536.4975 lldtaog30liub4a9a88deerfeo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3073';
20241104@174536.5014 lldtaog30liub4a9a88deerfeo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3073';
20241104@174536.5059 lldtaog30liub4a9a88deerfeo Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3073';
20241104@174536.5085 lldtaog30liub4a9a88deerfeo Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3073';
20241104@174536.5650 itgutk7i3j27in31jf19labjpi Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174536.5661 itgutk7i3j27in31jf19labjpi Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174536.5723 itgutk7i3j27in31jf19labjpi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3074';
20241104@174536.5784 itgutk7i3j27in31jf19labjpi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3074';
20241104@174536.5839 itgutk7i3j27in31jf19labjpi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3074';
20241104@174536.5867 itgutk7i3j27in31jf19labjpi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3074';
20241104@174536.5916 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.5919 itgutk7i3j27in31jf19labjpi Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174536.5978 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.5981 itgutk7i3j27in31jf19labjpi Query : select no, estab,szadrsdesc from szadrs where u_coddest=1452
20241104@174536.6028 itgutk7i3j27in31jf19labjpi Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20241104@174536.6211 itgutk7i3j27in31jf19labjpi Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407218 and bi.ref ='324.958.00.01' and bi.lordem =1
20241104@174536.6556 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6560 itgutk7i3j27in31jf19labjpi Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174536.6591 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6594 itgutk7i3j27in31jf19labjpi Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174536.6623 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6626 itgutk7i3j27in31jf19labjpi 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')
20241104@174536.6653 itgutk7i3j27in31jf19labjpi 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
20241104@174536.6687 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6690 itgutk7i3j27in31jf19labjpi Query : select top 1 ~inactivo valor from cl where no = '101621' and estab = 0 order by inactivo desc
20241104@174536.6718 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6721 itgutk7i3j27in31jf19labjpi Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174536.6750 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6752 itgutk7i3j27in31jf19labjpi Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174536.6790 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6793 itgutk7i3j27in31jf19labjpi Query : select szadrsstamp valor from szadrs where szadrsdesc='j.o.m. - castelo branco'
20241104@174536.6835 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.6838 itgutk7i3j27in31jf19labjpi Query : select 1 valor from td where ndoc = 39
20241104@174536.6851 itgutk7i3j27in31jf19labjpi Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174536.6864 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.6880 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174536.6900 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.6914 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174536.6940 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.6954 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174536.6967 itgutk7i3j27in31jf19labjpi Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174536.7034 itgutk7i3j27in31jf19labjpi Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174536.7065 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.7080 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174536.7095 itgutk7i3j27in31jf19labjpi Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut672904891667290840aa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174536.7288 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.7304 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174536.7335 itgutk7i3j27in31jf19labjpi Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174536.7347 itgutk7i3j27in31jf19labjpi Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174536.7359 itgutk7i3j27in31jf19labjpi Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174536.7370 itgutk7i3j27in31jf19labjpi Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174536.7381 itgutk7i3j27in31jf19labjpi Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174536.7391 itgutk7i3j27in31jf19labjpi Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174536.7402 itgutk7i3j27in31jf19labjpi Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut672904891667290840aa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174536.7700 itgutk7i3j27in31jf19labjpi Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174536.7729 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.7746 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174536.7767 itgutk7i3j27in31jf19labjpi Query : select 'normal' from dummy
20241104@174536.7781 itgutk7i3j27in31jf19labjpi Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut672904891667290840aa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1647,101621,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174536.8156 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.8159 itgutk7i3j27in31jf19labjpi Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20241104@174536.8181 itgutk7i3j27in31jf19labjpi 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.958.00.01'
20241104@174536.8345 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.8361 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174536.8384 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.8398 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174536.8406 itgutk7i3j27in31jf19labjpi Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174536.8418 itgutk7i3j27in31jf19labjpi Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20241104@174536.8432 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.8446 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174536.8458 itgutk7i3j27in31jf19labjpi Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672908056367290840cd','aut672904891667290840aa' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174536.8462 itgutk7i3j27in31jf19labjpi Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174536.8476 itgutk7i3j27in31jf19labjpi Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174536.8503 itgutk7i3j27in31jf19labjpi Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672908056367290840cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut672904891667290840aa' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174536.8790 itgutk7i3j27in31jf19labjpi Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut672904891667290840aa','2407218','wait',39,'adm09112754980.682000002')
20241104@174536.8856 itgutk7i3j27in31jf19labjpi Query : use flama_phc
20241104@174536.8859 itgutk7i3j27in31jf19labjpi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174536.8887 itgutk7i3j27in31jf19labjpi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3074';
20241104@174536.8925 itgutk7i3j27in31jf19labjpi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3074';
20241104@174536.8971 itgutk7i3j27in31jf19labjpi Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3074';
20241104@174536.8999 itgutk7i3j27in31jf19labjpi Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3074';
20241104@174537.1230 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174537.1940 m9l1c611e0f3kql4omqgcbjqb9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174537.6740 m9l1c611e0f3kql4omqgcbjqb9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3075';
20241104@174537.1328 m9l1c611e0f3kql4omqgcbjqb9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3075';
20241104@174537.1789 m9l1c611e0f3kql4omqgcbjqb9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3075';
20241104@174537.2099 m9l1c611e0f3kql4omqgcbjqb9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3075';
20241104@174537.2448 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.2489 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174537.3113 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.3156 m9l1c611e0f3kql4omqgcbjqb9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241104@174537.3563 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9005.00.1'
20241104@174537.4241 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407219 and bi.ref ='328.9005.00.1' and bi.lordem =1
20241104@174537.5662 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.5744 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174537.6140 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.6181 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174537.6553 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.6595 m9l1c611e0f3kql4omqgcbjqb9 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')
20241104@174537.7049 m9l1c611e0f3kql4omqgcbjqb9 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
20241104@174537.7755 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.7797 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241104@174537.8368 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.8410 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241104@174537.8789 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.8830 m9l1c611e0f3kql4omqgcbjqb9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241104@174537.9288 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.9330 m9l1c611e0f3kql4omqgcbjqb9 Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241104@174537.9913 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174537.9975 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from td where ndoc = 39
20241104@174538.3510 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241104@174538.9070 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174538.1426 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174538.1849 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174538.2107 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174538.4117 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174538.4499 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174538.4750 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174538.5089 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241104@174538.5348 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174538.5600 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241104@174538.5890 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut67290075056729084273' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241104@174538.6384 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174538.6825 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241104@174538.7528 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241104@174538.7736 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241104@174538.7943 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241104@174538.8149 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241104@174538.8356 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241104@174538.8562 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241104@174538.8769 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut67290075056729084273',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241104@174538.9421 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 fno valor from wsftdata order by fno desc
20241104@174538.9754 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174539.1120 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241104@174539.9170 m9l1c611e0f3kql4omqgcbjqb9 Query : select 'normal' from dummy
20241104@174539.1414 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut67290075056729084273',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1648,102943,0,'2024-11-04',39,'euro',0,0,2024 ,?,?)
20241104@174539.2256 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174539.2297 m9l1c611e0f3kql4omqgcbjqb9 Query : select st.usalote valor from st where st.ref = '328.9005.00.1'
20241104@174539.2794 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9005.00.1'
20241104@174539.5169 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174539.5421 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174539.5998 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174539.6252 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174539.6417 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174539.6664 m9l1c611e0f3kql4omqgcbjqb9 Query : select sestamp valor from se where ref ='328.9005.00.1' and lote = 'r2400092600a'
20241104@174539.7116 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174539.7394 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174539.7601 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut672905281267290843ad','aut67290075056729084273' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174539.7645 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174539.7903 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174539.8523 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut672905281267290843ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut67290075056729084273' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241104@174539.9273 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174539.9525 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174540.1030 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174540.4320 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174540.5980 m9l1c611e0f3kql4omqgcbjqb9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241104@174540.1144 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174540.1397 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241104@174540.1605 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6729055233672908441b','aut67290075056729084273' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241104@174540.1649 m9l1c611e0f3kql4omqgcbjqb9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241104@174540.2064 m9l1c611e0f3kql4omqgcbjqb9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241104@174540.2769 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6729055233672908441b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut67290075056729084273' ,0,0 ,2,23.00,20000,?,?,?)
20241104@174540.3452 m9l1c611e0f3kql4omqgcbjqb9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut67290075056729084273','2407219','wait',39,'adm09112754980.682000002')
20241104@174540.4070 m9l1c611e0f3kql4omqgcbjqb9 Query : use flama_phc
20241104@174540.4111 m9l1c611e0f3kql4omqgcbjqb9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241104@174540.4357 m9l1c611e0f3kql4omqgcbjqb9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3075';
20241104@174540.4664 m9l1c611e0f3kql4omqgcbjqb9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3075';
20241104@174540.4934 m9l1c611e0f3kql4omqgcbjqb9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3075';
20241104@174540.5600 m9l1c611e0f3kql4omqgcbjqb9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3075';
20241104@174540.6795 ejbviakf3ukqu58rs7n5un0c1k Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241104@174540.6806 ejbviakf3ukqu58rs7n5un0c1k Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241104@174540.6882 ejbviakf3ukqu58rs7n5un0c1k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3076';
20241104@174540.6981 ejbviakf3ukqu58rs7n5un0c1k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3076';
20241104@174540.8329 ejbviakf3ukqu58rs7n5un0c1k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3076';
20241104@174540.8371 ejbviakf3ukqu58rs7n5un0c1k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3076';
20241104@174540.8427 ejbviakf3ukqu58rs7n5un0c1k Query : use flama_phc
20241104@174540.8430 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241104@174540.8490 ejbviakf3ukqu58rs7n5un0c1k Query : use flama_phc
20241104@174540.8493 ejbviakf3ukqu58rs7n5un0c1k Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241104@174540.8540 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241104@174540.8719 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407222 and bi.ref ='324.966.00.01' and bi.lordem =1
20241104@174540.9877 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241104@174541.2650 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2072 and bo.obrano = 2407222 and bi.ref ='324.966.00.01' and bi.lordem =1
20241104@174541.2850 ejbviakf3ukqu58rs7n5un0c1k Query : use flama_phc
20241104@174541.2890 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241104@174541.3200 ejbviakf3ukqu58rs7n5un0c1k Query : use flama_phc
20241104@174541.3230 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 1 valor from td where td.ndoc = 39
20241104@174541.3500 ejbviakf3ukqu58rs7n5un0c1k Query : use flama_phc
20241104@174541.3530 ejbviakf3ukqu58rs7n5un0c1k 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')
20241104@174541.3810 ejbviakf3ukqu58rs7n5un0c1k 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
20241104@174541.4140 ejbviakf3ukqu58rs7n5un0c1k Query : use flama_phc
20241104@174541.4170 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241104@174541.4460 ejbviakf3ukqu58rs7n5un0c1k Query : use flama_phc
20241104@174541.4490 ejbviakf3ukqu58rs7n5un0c1k Query : select top 1 tipodoc,regrd from td where ndoc = 39
