20241121@174656.7552 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174656.7560 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174656.7572 s0d716cniuiesp3f9l6o4k5kp6 Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241121@174656.7643 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.7660 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174656.7673 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f751706673f7210ba','aut673f760948673f721060' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174656.7684 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.7702 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174656.7732 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f751706673f7210ba',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673f760948673f721060' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241121@174656.8196 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.8213 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174656.8238 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.8253 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174656.8261 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174656.8274 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.8307 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174656.8319 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f756630673f7210ca','aut673f760948673f721060' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174656.8323 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.8338 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174656.8364 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673f756630673f7210ca',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673f760948673f721060' ,0,0 ,2,23.00,20000,?,?,?)
20241121@174656.9025 s0d716cniuiesp3f9l6o4k5kp6 Query : use flama_phc
20241121@174656.9099 s0d716cniuiesp3f9l6o4k5kp6 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241121@174656.9257 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20241121@174656.9471 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.9487 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174656.9524 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.9538 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174656.9546 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174656.9605 s0d716cniuiesp3f9l6o4k5kp6 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241121@174656.9618 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.9633 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174656.9645 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f708453673f7210ea','aut673f760948673f721060' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174656.9650 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174656.9664 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174656.9692 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f708453673f7210ea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut673f760948673f721060' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241121@174657.1450 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.1610 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.2240 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.2600 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.2680 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174657.2790 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.2930 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.3040 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f791236673f721106','aut673f760948673f721060' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174657.3090 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.3230 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.4090 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673f791236673f721106',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673f760948673f721060' ,0,0 ,2,23.00,50000,?,?,?)
20241121@174657.8370 s0d716cniuiesp3f9l6o4k5kp6 Query : use flama_phc
20241121@174657.8400 s0d716cniuiesp3f9l6o4k5kp6 Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241121@174657.8600 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1321.00.1'
20241121@174657.1101 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.1118 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.1143 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.1158 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.1166 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174657.1239 s0d716cniuiesp3f9l6o4k5kp6 Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241121@174657.1252 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.1266 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.1277 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f743492673f72111e','aut673f760948673f721060' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174657.1282 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.1296 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.1323 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f743492673f72111e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673f760948673f721060' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241121@174657.1712 s0d716cniuiesp3f9l6o4k5kp6 Query : use flama_phc
20241121@174657.1714 s0d716cniuiesp3f9l6o4k5kp6 Query : select st.usalote valor from st where st.ref = '324.1329.00.1'
20241121@174657.1735 s0d716cniuiesp3f9l6o4k5kp6 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'
20241121@174657.2573 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.2807 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.3326 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.3598 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.3698 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174657.3800 s0d716cniuiesp3f9l6o4k5kp6 Query : select sestamp valor from se where ref ='324.1329.00.1' and lote = 'r2400495100a'
20241121@174657.3814 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.3830 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.3842 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f789330673f72115d','aut673f760948673f721060' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174657.3846 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.3860 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.3887 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f789330673f72115d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut673f760948673f721060' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241121@174657.4293 s0d716cniuiesp3f9l6o4k5kp6 Query : use flama_phc
20241121@174657.4296 s0d716cniuiesp3f9l6o4k5kp6 Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241121@174657.4375 s0d716cniuiesp3f9l6o4k5kp6 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'
20241121@174657.4586 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.4602 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.4628 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.4644 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.4652 s0d716cniuiesp3f9l6o4k5kp6 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174657.4714 s0d716cniuiesp3f9l6o4k5kp6 Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241121@174657.4728 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.4743 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.4754 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f765337673f721173','aut673f760948673f721060' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174657.4759 s0d716cniuiesp3f9l6o4k5kp6 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.4773 s0d716cniuiesp3f9l6o4k5kp6 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.4800 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f765337673f721173',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut673f760948673f721060' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241121@174657.5213 s0d716cniuiesp3f9l6o4k5kp6 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673f760948673f721060','2407735','wait',39,'adm09112754980.682000002')
20241121@174657.5382 s0d716cniuiesp3f9l6o4k5kp6 Query : use flama_phc
20241121@174657.5385 s0d716cniuiesp3f9l6o4k5kp6 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241121@174657.5415 s0d716cniuiesp3f9l6o4k5kp6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3427';
20241121@174657.5517 s0d716cniuiesp3f9l6o4k5kp6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3427';
20241121@174657.5568 s0d716cniuiesp3f9l6o4k5kp6 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3427';
20241121@174657.5637 s0d716cniuiesp3f9l6o4k5kp6 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3427';
20241121@174657.6194 a3j51ib3ntgod83gd40k58hbl3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241121@174657.6205 a3j51ib3ntgod83gd40k58hbl3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241121@174657.6269 a3j51ib3ntgod83gd40k58hbl3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3428';
20241121@174657.6334 a3j51ib3ntgod83gd40k58hbl3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3428';
20241121@174657.6415 a3j51ib3ntgod83gd40k58hbl3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3428';
20241121@174657.6452 a3j51ib3ntgod83gd40k58hbl3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3428';
20241121@174657.6507 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.6510 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241121@174657.6570 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.6573 a3j51ib3ntgod83gd40k58hbl3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241121@174657.6674 a3j51ib3ntgod83gd40k58hbl3 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'
20241121@174657.6848 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407741 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241121@174657.7190 a3j51ib3ntgod83gd40k58hbl3 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'
20241121@174657.7214 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407741 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241121@174657.7231 a3j51ib3ntgod83gd40k58hbl3 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'
20241121@174657.7250 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407741 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241121@174657.7266 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7269 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241121@174657.7299 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7302 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 1 valor from td where td.ndoc = 39
20241121@174657.7331 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7334 a3j51ib3ntgod83gd40k58hbl3 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')
20241121@174657.7362 a3j51ib3ntgod83gd40k58hbl3 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
20241121@174657.7396 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7399 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241121@174657.7536 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7539 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241121@174657.7567 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7570 a3j51ib3ntgod83gd40k58hbl3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241121@174657.7615 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7618 a3j51ib3ntgod83gd40k58hbl3 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241121@174657.7662 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.7665 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from td where ndoc = 39
20241121@174657.7678 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241121@174657.7692 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.7709 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174657.7729 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.7744 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174657.7776 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.7790 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174657.7803 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174657.7862 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174657.7876 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.7891 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174657.7908 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673f790960673f7211be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241121@174657.8103 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.8122 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174657.8158 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241121@174657.8170 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241121@174657.8183 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241121@174657.8197 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241121@174657.8212 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241121@174657.8227 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241121@174657.8240 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673f790960673f7211be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241121@174657.8549 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 fno valor from wsftdata order by fno desc
20241121@174657.8577 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.8625 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174657.8648 a3j51ib3ntgod83gd40k58hbl3 Query : select 'normal' from dummy
20241121@174657.8663 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673f790960673f7211be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1967,100810,0,'2024-11-21',39,'euro',0,0,2024 ,?,?)
20241121@174657.9007 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174657.9010 a3j51ib3ntgod83gd40k58hbl3 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241121@174657.9041 a3j51ib3ntgod83gd40k58hbl3 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'
20241121@174657.9204 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.9221 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.9246 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.9260 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.9271 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174657.9283 a3j51ib3ntgod83gd40k58hbl3 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241121@174657.9297 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.9323 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174657.9870 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f770103673f7211e2','aut673f790960673f7211be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174657.9876 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174657.9897 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174657.9936 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f770103673f7211e2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut673f790960673f7211be' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241121@174658.2680 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174658.2720 a3j51ib3ntgod83gd40k58hbl3 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241121@174658.2930 a3j51ib3ntgod83gd40k58hbl3 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'
20241121@174658.1290 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.1909 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.1946 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.1967 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.1977 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174658.1992 a3j51ib3ntgod83gd40k58hbl3 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241121@174658.2172 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.2194 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.2209 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f721386673f721235','aut673f790960673f7211be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174658.2214 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.2229 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.2257 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f721386673f721235',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut673f790960673f7211be' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241121@174658.2623 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174658.2669 a3j51ib3ntgod83gd40k58hbl3 Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241121@174658.2780 a3j51ib3ntgod83gd40k58hbl3 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'
20241121@174658.2795 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.2813 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.2838 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.2853 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.2862 a3j51ib3ntgod83gd40k58hbl3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174658.2875 a3j51ib3ntgod83gd40k58hbl3 Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241121@174658.2920 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.2938 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.2951 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f732700673f721247','aut673f790960673f7211be' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174658.2957 a3j51ib3ntgod83gd40k58hbl3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.2973 a3j51ib3ntgod83gd40k58hbl3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.3013 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f732700673f721247',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut673f790960673f7211be' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241121@174658.3355 a3j51ib3ntgod83gd40k58hbl3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673f790960673f7211be','2407741','wait',39,'adm09112754980.682000002')
20241121@174658.3425 a3j51ib3ntgod83gd40k58hbl3 Query : use flama_phc
20241121@174658.3428 a3j51ib3ntgod83gd40k58hbl3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241121@174658.3467 a3j51ib3ntgod83gd40k58hbl3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3428';
20241121@174658.3508 a3j51ib3ntgod83gd40k58hbl3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3428';
20241121@174658.3554 a3j51ib3ntgod83gd40k58hbl3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3428';
20241121@174658.3582 a3j51ib3ntgod83gd40k58hbl3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3428';
20241121@174658.4192 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241121@174658.4255 ku1p8ftv30r7aqed6dumjd3cbt Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241121@174658.4323 ku1p8ftv30r7aqed6dumjd3cbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3429';
20241121@174658.4477 ku1p8ftv30r7aqed6dumjd3cbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3429';
20241121@174658.4539 ku1p8ftv30r7aqed6dumjd3cbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3429';
20241121@174658.4572 ku1p8ftv30r7aqed6dumjd3cbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3429';
20241121@174658.4624 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.4627 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241121@174658.4695 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.4701 ku1p8ftv30r7aqed6dumjd3cbt Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241121@174658.4754 ku1p8ftv30r7aqed6dumjd3cbt 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'
20241121@174658.4774 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407742 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241121@174658.5131 ku1p8ftv30r7aqed6dumjd3cbt 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'
20241121@174658.5154 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407742 and bi.ref ='324.2335.00.1' and bi.lordem =1
20241121@174658.5170 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5173 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241121@174658.5206 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5209 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 1 valor from td where td.ndoc = 39
20241121@174658.5237 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5240 ku1p8ftv30r7aqed6dumjd3cbt 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')
20241121@174658.5268 ku1p8ftv30r7aqed6dumjd3cbt 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
20241121@174658.5303 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5306 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241121@174658.5335 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5337 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241121@174658.5366 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5369 ku1p8ftv30r7aqed6dumjd3cbt Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241121@174658.5407 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5409 ku1p8ftv30r7aqed6dumjd3cbt Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241121@174658.5452 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.5455 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from td where ndoc = 39
20241121@174658.5467 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241121@174658.5482 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.5526 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174658.5549 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.5566 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174658.5597 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.5612 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174658.5624 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174658.5685 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174658.5697 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.5712 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174658.5727 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673f765968673f721289' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241121@174658.5930 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.5952 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174658.5982 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241121@174658.5993 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241121@174658.6003 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241121@174658.6015 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241121@174658.6025 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241121@174658.6037 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241121@174658.6048 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673f765968673f721289',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241121@174658.6432 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 fno valor from wsftdata order by fno desc
20241121@174658.6479 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.6497 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174658.6523 ku1p8ftv30r7aqed6dumjd3cbt Query : select 'normal' from dummy
20241121@174658.6541 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673f765968673f721289',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1968,100810,0,'2024-11-21',39,'euro',0,0,2024 ,?,?)
20241121@174658.6918 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.6925 ku1p8ftv30r7aqed6dumjd3cbt Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241121@174658.6976 ku1p8ftv30r7aqed6dumjd3cbt 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'
20241121@174658.6999 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7016 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.7049 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7064 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.7075 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174658.7102 ku1p8ftv30r7aqed6dumjd3cbt Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241121@174658.7127 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7162 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.7187 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f761632673f7212ae','aut673f765968673f721289' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174658.7192 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7212 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.7247 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f761632673f7212ae',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',7.000 ,'aut673f765968673f721289' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241121@174658.7626 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.7631 ku1p8ftv30r7aqed6dumjd3cbt Query : select st.usalote valor from st where st.ref = '324.2335.00.1'
20241121@174658.7686 ku1p8ftv30r7aqed6dumjd3cbt 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'
20241121@174658.7713 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7738 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.7765 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7779 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.7788 ku1p8ftv30r7aqed6dumjd3cbt Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174658.7799 ku1p8ftv30r7aqed6dumjd3cbt Query : select sestamp valor from se where ref ='324.2335.00.1' and lote = 'r2400467150a'
20241121@174658.7822 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7847 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174658.7865 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f742840673f7212be','aut673f765968673f721289' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174658.7876 ku1p8ftv30r7aqed6dumjd3cbt Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174658.7910 ku1p8ftv30r7aqed6dumjd3cbt Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174658.7938 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f742840673f7212be',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut673f765968673f721289' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241121@174658.8242 ku1p8ftv30r7aqed6dumjd3cbt Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673f765968673f721289','2407742','wait',39,'adm09112754980.682000002')
20241121@174658.8315 ku1p8ftv30r7aqed6dumjd3cbt Query : use flama_phc
20241121@174658.8318 ku1p8ftv30r7aqed6dumjd3cbt Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241121@174658.8346 ku1p8ftv30r7aqed6dumjd3cbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3429';
20241121@174658.8385 ku1p8ftv30r7aqed6dumjd3cbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3429';
20241121@174658.8433 ku1p8ftv30r7aqed6dumjd3cbt Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3429';
20241121@174658.8467 ku1p8ftv30r7aqed6dumjd3cbt Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3429';
20241121@174658.8979 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241121@174658.8990 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241121@174658.9103 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3430';
20241121@174658.9230 0ml4f1su2j4isi2e9q2nuoo5t9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3430';
20241121@174658.9289 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3430';
20241121@174658.9319 0ml4f1su2j4isi2e9q2nuoo5t9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3430';
20241121@174658.9370 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174658.9373 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241121@174658.9454 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174658.9457 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2881
20241121@174658.9553 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.691.00.01'
20241121@174658.9737 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407744 and bi.ref ='324.691.00.01' and bi.lordem =1
20241121@174659.3370 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.692.00.01'
20241121@174659.6780 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407744 and bi.ref ='324.692.00.01' and bi.lordem =2
20241121@174659.1092 0ml4f1su2j4isi2e9q2nuoo5t9 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'
20241121@174659.1288 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407744 and bi.ref ='324.958.00.01' and bi.lordem =3
20241121@174659.1629 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5501.00.1'
20241121@174659.1799 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407744 and bi.ref ='324.5501.00.1' and bi.lordem =4
20241121@174659.3694 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4990.00.1'
20241121@174659.3894 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407744 and bi.ref ='324.4990.00.1' and bi.lordem =5
20241121@174659.4234 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4238 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241121@174659.4267 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4270 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 1 valor from td where td.ndoc = 39
20241121@174659.4301 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4303 0ml4f1su2j4isi2e9q2nuoo5t9 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')
20241121@174659.4329 0ml4f1su2j4isi2e9q2nuoo5t9 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
20241121@174659.4368 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4370 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 ~inactivo valor from cl where no = '100312' and estab = 0 order by inactivo desc
20241121@174659.4504 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4507 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241121@174659.4536 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4539 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241121@174659.4577 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4580 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select szadrsstamp valor from szadrs where szadrsdesc='carlos manuel garcia joao'
20241121@174659.4623 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.4626 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from td where ndoc = 39
20241121@174659.4637 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241121@174659.4650 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.4667 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174659.4685 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.4701 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174659.4758 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.4773 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174659.4786 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174659.4846 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174659.4859 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.4874 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174659.4890 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241121@174659.5092 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.5111 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174659.5144 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241121@174659.5155 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241121@174659.5166 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241121@174659.5178 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241121@174659.5189 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241121@174659.5200 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241121@174659.5212 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673f705219673f721374',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241121@174659.5493 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 fno valor from wsftdata order by fno desc
20241121@174659.5521 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.5538 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174659.5682 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 'normal' from dummy
20241121@174659.5696 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673f705219673f721374',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1969,100312,0,'2024-11-21',39,'euro',0,0,2024 ,?,?)
20241121@174659.6053 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.6056 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select st.usalote valor from st where st.ref = '324.691.00.01'
20241121@174659.6187 0ml4f1su2j4isi2e9q2nuoo5t9 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.691.00.01'
20241121@174659.6411 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.6569 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.6594 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.6611 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.6619 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174659.6630 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select sestamp valor from se where ref ='324.691.00.01' and lote = 'r2400209200a'
20241121@174659.6646 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.6660 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.6672 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f761805673f7213a2','aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174659.6676 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.6690 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.6716 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f761805673f7213a2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut673f705219673f721374' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241121@174659.7018 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7036 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.7061 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7076 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.7086 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174659.7098 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7113 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.7125 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f754230673f7213ad','aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174659.7129 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7145 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.7172 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673f754230673f7213ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673f705219673f721374' ,0,0 ,2,23.00,20000,?,?,?)
20241121@174659.7467 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.7470 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select st.usalote valor from st where st.ref = '324.692.00.01'
20241121@174659.7490 0ml4f1su2j4isi2e9q2nuoo5t9 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.692.00.01'
20241121@174659.7650 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7666 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.7691 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7705 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.7714 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174659.7725 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select sestamp valor from se where ref ='324.692.00.01' and lote = 'r2400210100a'
20241121@174659.7738 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7752 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.7763 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f798310673f7213bc','aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174659.7767 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.7781 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.7807 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f798310673f7213bc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut673f705219673f721374' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241121@174659.8100 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8116 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.8140 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8156 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.8164 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174659.8175 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8190 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.8201 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f725219673f7213c7','aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174659.8206 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8220 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.8247 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut673f725219673f7213c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut673f705219673f721374' ,0,0 ,2,23.00,50000,?,?,?)
20241121@174659.8543 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.8546 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20241121@174659.8565 0ml4f1su2j4isi2e9q2nuoo5t9 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'
20241121@174659.8807 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8824 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.8849 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8864 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.8873 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174659.8885 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400704200a'
20241121@174659.8898 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8913 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.8924 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f714415673f7213d9','aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174659.8928 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.8943 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.8970 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f714415673f7213d9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut673f705219673f721374' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241121@174659.9263 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174659.9266 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select st.usalote valor from st where st.ref = '324.5501.00.1'
20241121@174659.9286 0ml4f1su2j4isi2e9q2nuoo5t9 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.5501.00.1'
20241121@174659.9547 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.9563 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.9587 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.9601 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.9609 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174659.9619 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select sestamp valor from se where ref ='324.5501.00.1' and lote = 'r2300908100a'
20241121@174659.9640 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.9655 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174659.9667 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f714449673f7213eb','aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174659.9671 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174659.9685 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174659.9715 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f714449673f7213eb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673f705219673f721374' ,0,0 ,2,23.00,80000,?,?,?,?,?)
20241121@174700.2000 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174700.5000 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select st.usalote valor from st where st.ref = '324.4990.00.1'
20241121@174700.2400 0ml4f1su2j4isi2e9q2nuoo5t9 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.4990.00.1'
20241121@174700.1800 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.1950 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174700.2210 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.2360 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174700.2450 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174700.2560 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select sestamp valor from se where ref ='324.4990.00.1' and lote = 'r2100189200a'
20241121@174700.2810 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.2950 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174700.3060 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f704435673f721406','aut673f705219673f721374' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174700.3100 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.3230 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174700.3490 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f704435673f721406',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut673f705219673f721374' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241121@174700.6400 0ml4f1su2j4isi2e9q2nuoo5t9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673f705219673f721374','2407744','wait',39,'adm09112754980.682000002')
20241121@174700.7080 0ml4f1su2j4isi2e9q2nuoo5t9 Query : use flama_phc
20241121@174700.7110 0ml4f1su2j4isi2e9q2nuoo5t9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241121@174700.7400 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3430';
20241121@174700.7770 0ml4f1su2j4isi2e9q2nuoo5t9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3430';
20241121@174700.8240 0ml4f1su2j4isi2e9q2nuoo5t9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3430';
20241121@174700.8540 0ml4f1su2j4isi2e9q2nuoo5t9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3430';
20241121@174700.1497 8anh42s8bgsock8bbojgkuq7gd Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241121@174700.1507 8anh42s8bgsock8bbojgkuq7gd Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241121@174700.1577 8anh42s8bgsock8bbojgkuq7gd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3431';
20241121@174700.1644 8anh42s8bgsock8bbojgkuq7gd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3431';
20241121@174700.1705 8anh42s8bgsock8bbojgkuq7gd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3431';
20241121@174700.1736 8anh42s8bgsock8bbojgkuq7gd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3431';
20241121@174700.1789 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.1792 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241121@174700.1890 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.2185 8anh42s8bgsock8bbojgkuq7gd Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241121@174700.2306 8anh42s8bgsock8bbojgkuq7gd 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'
20241121@174700.2658 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407745 and bi.ref ='324.2330.00.1' and bi.lordem =1
20241121@174700.3097 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3100 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241121@174700.3133 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3136 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 1 valor from td where td.ndoc = 39
20241121@174700.3166 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3170 8anh42s8bgsock8bbojgkuq7gd 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')
20241121@174700.3207 8anh42s8bgsock8bbojgkuq7gd 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
20241121@174700.3245 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3247 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241121@174700.3280 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3287 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241121@174700.3317 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3320 8anh42s8bgsock8bbojgkuq7gd Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241121@174700.3363 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3366 8anh42s8bgsock8bbojgkuq7gd Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241121@174700.3416 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.3420 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from td where ndoc = 39
20241121@174700.3436 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241121@174700.3458 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.3491 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174700.3521 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.3540 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174700.3578 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.3602 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174700.3618 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174700.3683 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174700.3700 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.3875 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174700.3898 8anh42s8bgsock8bbojgkuq7gd Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673f749753673f721458' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241121@174700.4100 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.4122 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174700.4166 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241121@174700.4184 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241121@174700.4199 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241121@174700.4221 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241121@174700.4234 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241121@174700.4247 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241121@174700.4271 8anh42s8bgsock8bbojgkuq7gd Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673f749753673f721458',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241121@174700.4577 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 fno valor from wsftdata order by fno desc
20241121@174700.4609 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.4633 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174700.4665 8anh42s8bgsock8bbojgkuq7gd Query : select 'normal' from dummy
20241121@174700.4687 8anh42s8bgsock8bbojgkuq7gd Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673f749753673f721458',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1970,100810,0,'2024-11-21',39,'euro',0,0,2024 ,?,?)
20241121@174700.5066 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.5070 8anh42s8bgsock8bbojgkuq7gd Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241121@174700.5118 8anh42s8bgsock8bbojgkuq7gd 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'
20241121@174700.5296 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.5325 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174700.5429 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.5457 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174700.5468 8anh42s8bgsock8bbojgkuq7gd Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174700.5486 8anh42s8bgsock8bbojgkuq7gd Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241121@174700.5553 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.5610 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174700.5623 8anh42s8bgsock8bbojgkuq7gd Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f739557673f721487','aut673f749753673f721458' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174700.5629 8anh42s8bgsock8bbojgkuq7gd Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.5676 8anh42s8bgsock8bbojgkuq7gd Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174700.5711 8anh42s8bgsock8bbojgkuq7gd Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f739557673f721487',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut673f749753673f721458' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241121@174700.6043 8anh42s8bgsock8bbojgkuq7gd Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut673f749753673f721458','2407745','wait',39,'adm09112754980.682000002')
20241121@174700.6119 8anh42s8bgsock8bbojgkuq7gd Query : use flama_phc
20241121@174700.6128 8anh42s8bgsock8bbojgkuq7gd Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241121@174700.6180 8anh42s8bgsock8bbojgkuq7gd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3431';
20241121@174700.6220 8anh42s8bgsock8bbojgkuq7gd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3431';
20241121@174700.6278 8anh42s8bgsock8bbojgkuq7gd Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3431';
20241121@174700.6355 8anh42s8bgsock8bbojgkuq7gd Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3431';
20241121@174700.7041 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241121@174700.7060 p3t999t1gkcts0nvbcdcrmtig5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241121@174700.7207 p3t999t1gkcts0nvbcdcrmtig5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3432';
20241121@174700.7365 p3t999t1gkcts0nvbcdcrmtig5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3432';
20241121@174700.7484 p3t999t1gkcts0nvbcdcrmtig5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3432';
20241121@174700.7557 p3t999t1gkcts0nvbcdcrmtig5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3432';
20241121@174700.7773 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.7777 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241121@174700.7894 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.7897 p3t999t1gkcts0nvbcdcrmtig5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241121@174700.7943 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174700.8038 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407746 and bi.ref ='324.2330.00.1' and bi.lordem =1
20241121@174700.8695 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174700.8715 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407746 and bi.ref ='324.2330.00.1' and bi.lordem =1
20241121@174700.8732 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174700.8751 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407746 and bi.ref ='324.2330.00.1' and bi.lordem =1
20241121@174700.8822 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174700.8841 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2077 and bo.obrano = 2407746 and bi.ref ='324.2330.00.1' and bi.lordem =2
20241121@174700.9273 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9276 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241121@174700.9307 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9310 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 1 valor from td where td.ndoc = 39
20241121@174700.9385 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9404 p3t999t1gkcts0nvbcdcrmtig5 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')
20241121@174700.9438 p3t999t1gkcts0nvbcdcrmtig5 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
20241121@174700.9475 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9517 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241121@174700.9560 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9563 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241121@174700.9612 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9615 p3t999t1gkcts0nvbcdcrmtig5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241121@174700.9684 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9686 p3t999t1gkcts0nvbcdcrmtig5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241121@174700.9800 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174700.9802 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from td where ndoc = 39
20241121@174700.9814 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241121@174700.9838 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.9854 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174700.9894 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174700.9979 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174701.1400 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.6900 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174701.8900 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174701.1500 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241121@174701.1650 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.2730 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241121@174701.3110 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut673f779151673f721502' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241121@174701.5730 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.6420 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241121@174701.6740 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241121@174701.7600 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241121@174701.7730 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241121@174701.7850 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241121@174701.8320 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241121@174701.8950 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241121@174701.9270 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut673f779151673f721502',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241121@174701.1273 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 fno valor from wsftdata order by fno desc
20241121@174701.1367 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.1384 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241121@174701.1410 p3t999t1gkcts0nvbcdcrmtig5 Query : select 'normal' from dummy
20241121@174701.1430 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut673f779151673f721502',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1971,100810,0,'2024-11-21',39,'euro',0,0,2024 ,?,?)
20241121@174701.2153 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174701.2162 p3t999t1gkcts0nvbcdcrmtig5 Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241121@174701.2184 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174701.2206 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.2222 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174701.2283 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.2298 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174701.2306 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174701.2329 p3t999t1gkcts0nvbcdcrmtig5 Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241121@174701.2342 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.2358 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174701.2414 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f761713673f721539','aut673f779151673f721502' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174701.2430 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.2479 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174701.2523 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f761713673f721539',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut673f779151673f721502' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241121@174701.2885 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174701.2907 p3t999t1gkcts0nvbcdcrmtig5 Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241121@174701.2967 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174701.2982 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.2998 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174701.3033 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.3067 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174701.3080 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174701.3125 p3t999t1gkcts0nvbcdcrmtig5 Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241121@174701.3153 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.3311 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174701.3323 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f784009673f72154c','aut673f779151673f721502' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174701.3327 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.3343 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174701.3373 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f784009673f72154c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut673f779151673f721502' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241121@174701.3835 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174701.3839 p3t999t1gkcts0nvbcdcrmtig5 Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241121@174701.3858 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174701.3871 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.4064 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174701.4089 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.4105 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174701.4113 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174701.4190 p3t999t1gkcts0nvbcdcrmtig5 Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
20241121@174701.4202 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.4217 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174701.4228 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut673f767923673f721566','aut673f779151673f721502' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241121@174701.4233 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.4247 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174701.4275 p3t999t1gkcts0nvbcdcrmtig5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut673f767923673f721566',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut673f779151673f721502' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241121@174701.4882 p3t999t1gkcts0nvbcdcrmtig5 Query : use flama_phc
20241121@174701.4924 p3t999t1gkcts0nvbcdcrmtig5 Query : select st.usalote valor from st where st.ref = '324.2330.00.1'
20241121@174701.4966 p3t999t1gkcts0nvbcdcrmtig5 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'
20241121@174701.4979 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.4994 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241121@174701.5019 p3t999t1gkcts0nvbcdcrmtig5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241121@174701.5034 p3t999t1gkcts0nvbcdcrmtig5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241121@174701.5043 p3t999t1gkcts0nvbcdcrmtig5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241121@174701.5055 p3t999t1gkcts0nvbcdcrmtig5 Query : select sestamp valor from se where ref ='324.2330.00.1' and lote = 'r2100584800a'
