20240728@233853.5357 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c5545366a6c87d81','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.5362 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5381 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.5419 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c5545366a6c87d81',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,200000,?,?,?)
20240728@233853.5766 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.5770 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.4906.00.1'
20240728@233853.5795 q1t70g6blm3gmatgpar55qt296 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.4906.00.1'
20240728@233853.5959 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.5978 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6013 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6032 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6042 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.6058 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.4906.00.1' and lote = 'r2300207200a'
20240728@233853.6089 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6116 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6130 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c0608266a6c87d94','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.6135 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6156 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6201 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c0608266a6c87d94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20240728@233853.6478 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6499 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6528 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6546 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6557 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.6573 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6592 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.6607 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c9916066a6c87da0','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.6613 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.6631 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.6667 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c9916066a6c87da0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,230000,?,?,?)
20240728@233853.6950 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.6954 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.1461.00.1'
20240728@233853.6979 q1t70g6blm3gmatgpar55qt296 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.1461.00.1'
20240728@233853.7143 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.7164 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9100 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9120 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9129 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.9142 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.1461.00.1' and lote = 'r2100463200a'
20240728@233853.9157 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9174 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9188 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c2921566a6c87ddf','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.9192 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9208 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9240 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c2921566a6c87ddf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20240728@233853.9516 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233853.9520 q1t70g6blm3gmatgpar55qt296 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240728@233853.9541 q1t70g6blm3gmatgpar55qt296 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'
20240728@233853.9694 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9711 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9741 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9758 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9768 q1t70g6blm3gmatgpar55qt296 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233853.9782 q1t70g6blm3gmatgpar55qt296 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240728@233853.9803 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9820 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233853.9834 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c8442266a6c87def','aut66a6c4347166a6c87c3f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233853.9838 q1t70g6blm3gmatgpar55qt296 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233853.9853 q1t70g6blm3gmatgpar55qt296 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233853.9884 q1t70g6blm3gmatgpar55qt296 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c8442266a6c87def',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66a6c4347166a6c87c3f' ,0,0 ,2,23.00,260000,?,?,?,?,?)
20240728@233854.1610 q1t70g6blm3gmatgpar55qt296 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a6c4347166a6c87c3f','2404974','wait',39,'adm09112754980.682000002')
20240728@233854.2360 q1t70g6blm3gmatgpar55qt296 Query : use flama_phc
20240728@233854.2400 q1t70g6blm3gmatgpar55qt296 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240728@233854.2750 q1t70g6blm3gmatgpar55qt296 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1193';
20240728@233854.3020 q1t70g6blm3gmatgpar55qt296 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1193';
20240728@233854.3390 q1t70g6blm3gmatgpar55qt296 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1193';
20240728@233854.3650 q1t70g6blm3gmatgpar55qt296 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1193';
20240728@233854.8620 he4ff5rok34opbfa2fbtrh947u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240728@233854.8730 he4ff5rok34opbfa2fbtrh947u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240728@233854.9270 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.9810 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.1029 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.1053 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.1171 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.1175 he4ff5rok34opbfa2fbtrh947u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240728@233854.1251 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.1254 he4ff5rok34opbfa2fbtrh947u Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240728@233854.1530 he4ff5rok34opbfa2fbtrh947u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20240728@233854.1718 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404981 and bi.ref ='324.1667.00.1' and bi.lordem =1
20240728@233854.2179 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2184 he4ff5rok34opbfa2fbtrh947u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240728@233854.2222 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2226 he4ff5rok34opbfa2fbtrh947u Query : select top 1 1 valor from td where td.ndoc = 39
20240728@233854.2260 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2264 he4ff5rok34opbfa2fbtrh947u 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')
20240728@233854.2299 he4ff5rok34opbfa2fbtrh947u 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
20240728@233854.2338 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2342 he4ff5rok34opbfa2fbtrh947u Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240728@233854.2483 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2487 he4ff5rok34opbfa2fbtrh947u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240728@233854.2521 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2525 he4ff5rok34opbfa2fbtrh947u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240728@233854.2572 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2576 he4ff5rok34opbfa2fbtrh947u Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240728@233854.2647 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.2651 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from td where ndoc = 39
20240728@233854.2666 he4ff5rok34opbfa2fbtrh947u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240728@233854.2684 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.2704 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.2727 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.2744 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.2778 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.2795 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.2810 he4ff5rok34opbfa2fbtrh947u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.2883 he4ff5rok34opbfa2fbtrh947u Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.2899 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.3952 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.4046 he4ff5rok34opbfa2fbtrh947u Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a6c5533066a6c87e44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240728@233854.4226 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.4246 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.4283 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240728@233854.4297 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240728@233854.4310 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240728@233854.4324 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240728@233854.4338 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240728@233854.4353 he4ff5rok34opbfa2fbtrh947u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240728@233854.4367 he4ff5rok34opbfa2fbtrh947u Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a6c5533066a6c87e44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240728@233854.4614 he4ff5rok34opbfa2fbtrh947u Query : select top 1 fno valor from wsftdata order by fno desc
20240728@233854.4631 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.4650 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.4675 he4ff5rok34opbfa2fbtrh947u Query : select 'normal' from dummy
20240728@233854.4693 he4ff5rok34opbfa2fbtrh947u Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a6c5533066a6c87e44',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',43,100810,0,'2024-07-28',39,'euro',0,0,2024 ,?,?)
20240728@233854.4985 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.4988 he4ff5rok34opbfa2fbtrh947u Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20240728@233854.5015 he4ff5rok34opbfa2fbtrh947u 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.1667.00.1'
20240728@233854.5173 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5192 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5226 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5246 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5256 he4ff5rok34opbfa2fbtrh947u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233854.5271 he4ff5rok34opbfa2fbtrh947u Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2400065200a'
20240728@233854.5288 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5305 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5321 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6102766a6c87e81','aut66a6c5533066a6c87e44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233854.5326 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5343 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5378 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c6102766a6c87e81',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66a6c5533066a6c87e44' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240728@233854.5651 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5673 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5703 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5719 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5729 he4ff5rok34opbfa2fbtrh947u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233854.5745 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5763 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233854.5778 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6330366a6c87e8c','aut66a6c5533066a6c87e44' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233854.5782 he4ff5rok34opbfa2fbtrh947u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.5798 he4ff5rok34opbfa2fbtrh947u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233854.5832 he4ff5rok34opbfa2fbtrh947u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c6330366a6c87e8c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c5533066a6c87e44' ,0,0 ,2,23.00,20000,?,?,?)
20240728@233854.6086 he4ff5rok34opbfa2fbtrh947u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a6c5533066a6c87e44','2404981','wait',39,'adm09112754980.682000002')
20240728@233854.6163 he4ff5rok34opbfa2fbtrh947u Query : use flama_phc
20240728@233854.6167 he4ff5rok34opbfa2fbtrh947u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240728@233854.6202 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.6229 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.6266 he4ff5rok34opbfa2fbtrh947u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1194';
20240728@233854.6288 he4ff5rok34opbfa2fbtrh947u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1194';
20240728@233854.6814 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240728@233854.6825 lb3ksk2ifc640h0nntv7gcmc93 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240728@233854.6878 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233854.6932 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233854.7061 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233854.7089 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233854.7142 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7146 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240728@233854.7215 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7218 lb3ksk2ifc640h0nntv7gcmc93 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240728@233854.7259 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20240728@233854.7443 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404982 and bi.ref ='324.1684.00.1' and bi.lordem =1
20240728@233854.7771 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7775 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240728@233854.7812 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7816 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 1 valor from td where td.ndoc = 39
20240728@233854.7849 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7852 lb3ksk2ifc640h0nntv7gcmc93 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')
20240728@233854.7884 lb3ksk2ifc640h0nntv7gcmc93 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
20240728@233854.7920 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.7923 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240728@233854.8099 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8103 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240728@233854.8253 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8256 lb3ksk2ifc640h0nntv7gcmc93 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240728@233854.8348 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8352 lb3ksk2ifc640h0nntv7gcmc93 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240728@233854.8397 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.8399 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from td where ndoc = 39
20240728@233854.8413 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240728@233854.8427 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8444 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.8465 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8564 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.8597 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8614 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.8630 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.8705 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233854.8718 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8735 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233854.8753 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a6c1221366a6c87ed2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240728@233854.8936 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.8959 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233854.8996 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240728@233854.9013 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240728@233854.9028 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240728@233854.9042 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240728@233854.9056 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240728@233854.9069 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240728@233854.9081 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a6c1221366a6c87ed2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240728@233854.9431 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 fno valor from wsftdata order by fno desc
20240728@233854.9458 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233854.9478 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233854.9502 lb3ksk2ifc640h0nntv7gcmc93 Query : select 'normal' from dummy
20240728@233854.9520 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a6c1221366a6c87ed2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',44,100810,0,'2024-07-28',39,'euro',0,0,2024 ,?,?)
20240728@233854.9823 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233854.9826 lb3ksk2ifc640h0nntv7gcmc93 Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20240728@233854.9850 lb3ksk2ifc640h0nntv7gcmc93 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.1684.00.1'
20240728@233855.1160 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.1370 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.1710 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.1900 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.2000 lb3ksk2ifc640h0nntv7gcmc93 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.2160 lb3ksk2ifc640h0nntv7gcmc93 Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2301217200a'
20240728@233855.2320 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.2500 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.2640 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c7361866a6c87f05','aut66a6c1221366a6c87ed2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233855.2690 lb3ksk2ifc640h0nntv7gcmc93 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.2880 lb3ksk2ifc640h0nntv7gcmc93 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.3260 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c7361866a6c87f05',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66a6c1221366a6c87ed2' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240728@233855.6150 lb3ksk2ifc640h0nntv7gcmc93 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a6c1221366a6c87ed2','2404982','wait',39,'adm09112754980.682000002')
20240728@233855.6960 lb3ksk2ifc640h0nntv7gcmc93 Query : use flama_phc
20240728@233855.6990 lb3ksk2ifc640h0nntv7gcmc93 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240728@233855.7320 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233855.7950 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233855.8920 lb3ksk2ifc640h0nntv7gcmc93 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1195';
20240728@233855.9170 lb3ksk2ifc640h0nntv7gcmc93 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1195';
20240728@233855.2634 243kb2n7bb7no0s70v2aeod25d Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240728@233855.2645 243kb2n7bb7no0s70v2aeod25d Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240728@233855.2694 243kb2n7bb7no0s70v2aeod25d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1196';
20240728@233855.2956 243kb2n7bb7no0s70v2aeod25d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1196';
20240728@233855.3004 243kb2n7bb7no0s70v2aeod25d Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1196';
20240728@233855.3027 243kb2n7bb7no0s70v2aeod25d Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1196';
20240728@233855.3169 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.3172 243kb2n7bb7no0s70v2aeod25d Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240728@233855.3239 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.3242 243kb2n7bb7no0s70v2aeod25d Query : select no, estab,szadrsdesc from szadrs where u_coddest=635
20240728@233855.3381 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240728@233855.3629 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.5342.00.1' and bi.lordem =1
20240728@233855.4131 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240728@233855.4154 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.5342.00.1' and bi.lordem =2
20240728@233855.4472 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1816.00.1'
20240728@233855.4620 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.1816.00.1' and bi.lordem =4
20240728@233855.4909 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240728@233855.5048 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.1879.00.1' and bi.lordem =5
20240728@233855.5336 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240728@233855.5465 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.2031.00.1' and bi.lordem =6
20240728@233855.5755 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240728@233855.5774 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.2066.00.1' and bi.lordem =7
20240728@233855.6057 243kb2n7bb7no0s70v2aeod25d Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2066.00.1'
20240728@233855.6079 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2049 and bo.obrano = 2404983 and bi.ref ='324.2066.00.1' and bi.lordem =7
20240728@233855.6097 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6100 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240728@233855.6131 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6134 243kb2n7bb7no0s70v2aeod25d Query : select top 1 1 valor from td where td.ndoc = 39
20240728@233855.6162 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6165 243kb2n7bb7no0s70v2aeod25d 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')
20240728@233855.6196 243kb2n7bb7no0s70v2aeod25d 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
20240728@233855.6232 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6235 243kb2n7bb7no0s70v2aeod25d Query : select top 1 ~inactivo valor from cl where no = '100053' and estab = 0 order by inactivo desc
20240728@233855.6358 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6361 243kb2n7bb7no0s70v2aeod25d Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240728@233855.6391 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6394 243kb2n7bb7no0s70v2aeod25d Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240728@233855.6434 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6437 243kb2n7bb7no0s70v2aeod25d Query : select szadrsstamp valor from szadrs where szadrsdesc='irmaos peixoto, s.a.'
20240728@233855.6484 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.6487 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from td where ndoc = 39
20240728@233855.6501 243kb2n7bb7no0s70v2aeod25d Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240728@233855.6515 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6530 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233855.6549 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6566 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233855.6600 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6616 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233855.6629 243kb2n7bb7no0s70v2aeod25d Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233855.6702 243kb2n7bb7no0s70v2aeod25d Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240728@233855.6716 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6732 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240728@233855.6747 243kb2n7bb7no0s70v2aeod25d Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240728@233855.6954 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.6970 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240728@233855.7001 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240728@233855.7013 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240728@233855.7024 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240728@233855.7035 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240728@233855.7046 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240728@233855.7058 243kb2n7bb7no0s70v2aeod25d Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240728@233855.7070 243kb2n7bb7no0s70v2aeod25d Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a6c3274466a6c87fa1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240728@233855.7354 243kb2n7bb7no0s70v2aeod25d Query : select top 1 fno valor from wsftdata order by fno desc
20240728@233855.8485 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.8504 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240728@233855.8526 243kb2n7bb7no0s70v2aeod25d Query : select 'normal' from dummy
20240728@233855.8541 243kb2n7bb7no0s70v2aeod25d Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a6c3274466a6c87fa1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',45,100053,0,'2024-07-28',39,'euro',0,0,2024 ,?,?)
20240728@233855.8874 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.8877 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240728@233855.8899 243kb2n7bb7no0s70v2aeod25d 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.5342.00.1'
20240728@233855.9050 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9067 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9091 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9105 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9113 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.9125 243kb2n7bb7no0s70v2aeod25d Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20240728@233855.9137 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9152 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9164 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c2133766a6c87fdf','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233855.9174 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9188 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9214 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c2133766a6c87fdf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240728@233855.9487 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9503 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9528 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9541 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9549 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.9561 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9575 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9586 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c0716866a6c87fe9','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233855.9590 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9604 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9632 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c0716866a6c87fe9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,20000,?,?,?)
20240728@233855.9875 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233855.9879 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240728@233855.9898 243kb2n7bb7no0s70v2aeod25d 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.5342.00.1'
20240728@233855.9912 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9929 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233855.9954 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233855.9970 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233855.9979 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233855.9991 243kb2n7bb7no0s70v2aeod25d Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20240728@233856.4000 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.2000 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.3300 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1830566a6c88000','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.3700 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.5200 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.7900 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c1830566a6c88000',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240728@233856.3420 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.3560 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.4060 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.4210 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.4290 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233856.4420 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.4560 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.4670 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c6602066a6c8800a','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.4710 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.4850 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.5120 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c6602066a6c8800a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,50000,?,?,?)
20240728@233856.7480 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233856.7510 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20240728@233856.7700 243kb2n7bb7no0s70v2aeod25d 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.1816.00.1'
20240728@233856.9120 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.9280 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.9530 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.9780 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.9860 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233856.9980 243kb2n7bb7no0s70v2aeod25d Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400198200a'
20240728@233856.1012 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1028 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.1040 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1070666a6c88018','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.1045 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1060 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.1088 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a6c1070666a6c88018',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240728@233856.1491 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1508 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.1535 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1551 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.1559 243kb2n7bb7no0s70v2aeod25d Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240728@233856.1572 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1587 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240728@233856.1599 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a6c1267566a6c88026','aut66a6c3274466a6c87fa1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240728@233856.1604 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.1619 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240728@233856.1651 243kb2n7bb7no0s70v2aeod25d Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a6c1267566a6c88026',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a6c3274466a6c87fa1' ,0,0 ,2,23.00,80000,?,?,?)
20240728@233856.1928 243kb2n7bb7no0s70v2aeod25d Query : use flama_phc
20240728@233856.1932 243kb2n7bb7no0s70v2aeod25d Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240728@233856.1953 243kb2n7bb7no0s70v2aeod25d 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.1879.00.1'
20240728@233856.2098 243kb2n7bb7no0s70v2aeod25d Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240728@233856.2114 243kb2n7bb7no0s70v2aeod25d Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
