20240819@112058.3244 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.3263 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.3275 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.3291 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112058.3307 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.3324 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.3339 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c310668766c31c8a50','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.3345 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.3363 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.3399 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c310668766c31c8a50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,550000,?,?,?,?,?)
20240819@112058.3690 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.3713 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.4932 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.4954 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.4967 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.4984 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.5034 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.5051 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c319828166c31c8a79','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.5057 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.5077 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.5117 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c319828166c31c8a79',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,560000,?,?,?)
20240819@112058.5395 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112058.5399 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112058.5427 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112058.5452 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.5473 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.5506 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.5526 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.5537 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.5553 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112058.5568 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.5585 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.5598 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c312791466c31c8a87','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.5603 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.5622 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.5659 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c312791466c31c8a87',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,580000,?,?,?,?,?)
20240819@112058.5962 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.5986 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.6022 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.6042 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.6071 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.6088 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.6105 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.6122 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c316909266c31c8a94','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.6127 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.6145 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.6181 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c316909266c31c8a94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,590000,?,?,?)
20240819@112058.6526 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112058.6570 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112058.6632 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112058.6648 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.6669 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.6733 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.6754 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.6763 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.6780 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112058.6797 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.6817 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.6830 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c316565066c31c8aa5','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.6835 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.6851 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.6883 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c316565066c31c8aa5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,610000,?,?,?,?,?)
20240819@112058.7181 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7200 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.7238 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7257 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.7267 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.7281 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7299 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.7316 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c313715666c31c8ab1','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.7320 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7337 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.7371 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c313715666c31c8ab1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,620000,?,?,?)
20240819@112058.7666 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112058.7669 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112058.7691 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112058.7707 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7726 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.7758 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7778 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.7823 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.7836 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112058.7855 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7877 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.7900 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c316422366c31c8abf','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.7905 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.7924 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.7977 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c316422366c31c8abf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,640000,?,?,?,?,?)
20240819@112058.8254 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8273 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.8306 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8331 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.8345 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.8360 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8376 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.8391 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c313561466c31c8acc','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.8395 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8412 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.8451 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c313561466c31c8acc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,650000,?,?,?)
20240819@112058.8773 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112058.8777 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112058.8801 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112058.8821 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8844 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.8881 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8899 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.8908 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.8923 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112058.8937 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8953 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.8967 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c319809066c31c8ada','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.8974 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.8990 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.9028 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c319809066c31c8ada',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,670000,?,?,?,?,?)
20240819@112058.9312 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.9333 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.9379 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.9398 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.9410 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.9425 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.9441 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.9455 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c311831966c31c8ae6','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.9460 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.9480 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.9516 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c311831966c31c8ae6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,680000,?,?,?)
20240819@112058.9794 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112058.9799 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112058.9827 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112058.9845 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.9871 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112058.9902 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.9919 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.9929 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112058.9943 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112058.9958 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112058.9978 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112058.9993 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c315966266c31c8af3','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112058.9999 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1800 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.6000 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c315966266c31c8af3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,700000,?,?,?,?,?)
20240819@112059.3370 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.3560 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.3950 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.4120 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.4220 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.4370 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.4670 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.4820 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c317799666c31c8b0a','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.4870 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5040 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.5370 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c317799666c31c8b0a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,710000,?,?,?)
20240819@112059.7990 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112059.8030 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112059.8270 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112059.8430 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.9190 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.9490 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.9760 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.9860 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.1001 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112059.1016 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1032 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.1046 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c313009666c31c8b18','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.1052 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1073 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.1110 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c313009666c31c8b18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,730000,?,?,?,?,?)
20240819@112059.1403 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1424 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.1461 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1478 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.1490 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.1507 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1535 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.1550 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c315447166c31c8b24','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.1555 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1572 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.1607 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c315447166c31c8b24',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,740000,?,?,?)
20240819@112059.1881 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112059.1886 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112059.1910 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112059.1939 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.1958 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.1991 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2008 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.2018 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.2032 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112059.2049 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2068 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.2082 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c316934566c31c8b32','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.2087 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2112 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.2145 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c316934566c31c8b32',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,760000,?,?,?,?,?)
20240819@112059.2433 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2455 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.2486 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2512 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.2523 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.2539 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2557 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.2572 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c312884866c31c8b3d','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.2578 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2597 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.2632 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c312884866c31c8b3d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,770000,?,?,?)
20240819@112059.2911 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112059.2916 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112059.2941 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112059.2964 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.2983 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.3024 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.3040 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.3050 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.3065 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112059.3081 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.3100 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.3115 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c314382666c31c8b4b','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.3120 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.3140 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.3207 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c314382666c31c8b4b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,790000,?,?,?,?,?)
20240819@112059.3498 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.3518 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.4691 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.4712 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.4734 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.4756 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.4775 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.4788 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c313194866c31c8b74','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.4794 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.4811 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.4871 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c313194866c31c8b74',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,800000,?,?,?)
20240819@112059.5167 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112059.5170 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112059.5196 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112059.5215 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5235 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.5270 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5289 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.5299 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.5323 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112059.5338 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5358 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.5375 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c318055566c31c8b82','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.5380 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5396 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.5433 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c318055566c31c8b82',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,820000,?,?,?,?,?)
20240819@112059.5740 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5759 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.5802 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5826 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.5835 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.5851 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5869 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.5884 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c314443566c31c8b8e','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.5890 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.5909 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.5945 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c314443566c31c8b8e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,830000,?,?,?)
20240819@112059.6223 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112059.6228 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112059.6256 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112059.6273 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.6292 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.6360 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.6380 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.6391 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.6407 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112059.6423 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.6443 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.6461 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c315679466c31c8b9c','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.6466 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.6484 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.6527 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c315679466c31c8b9c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,850000,?,?,?,?,?)
20240819@112059.6998 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7018 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.7062 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7080 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.7090 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.7105 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7123 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.7137 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c311132066c31c8bad','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.7144 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7162 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.7194 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c311132066c31c8bad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,860000,?,?,?)
20240819@112059.7512 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112059.7516 rq757h3len7mfe4mc61pfcgbju Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20240819@112059.7538 rq757h3len7mfe4mc61pfcgbju 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.1847.00.1'
20240819@112059.7558 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7579 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.7621 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7638 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.7647 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.7662 rq757h3len7mfe4mc61pfcgbju Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400463200a'
20240819@112059.7679 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7695 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.7710 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c310337166c31c8bbb','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.7716 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.7733 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.7790 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c310337166c31c8bbb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,880000,?,?,?,?,?)
20240819@112059.8143 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.8163 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.8194 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.8210 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.8220 rq757h3len7mfe4mc61pfcgbju Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112059.8237 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.8255 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112059.8269 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c316142766c31c8bc9','aut66c313920366c31c87d2' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112059.8274 rq757h3len7mfe4mc61pfcgbju Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112059.8303 rq757h3len7mfe4mc61pfcgbju Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112059.8340 rq757h3len7mfe4mc61pfcgbju Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66c316142766c31c8bc9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66c313920366c31c87d2' ,0,0 ,2,23.00,890000,?,?,?)
20240819@112059.8627 rq757h3len7mfe4mc61pfcgbju Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66c313920366c31c87d2','2405466','wait',39,'adm09112754980.682000002')
20240819@112059.8716 rq757h3len7mfe4mc61pfcgbju Query : use flama_phc
20240819@112059.8720 rq757h3len7mfe4mc61pfcgbju Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@112059.8754 rq757h3len7mfe4mc61pfcgbju Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1605';
20240819@112059.8783 rq757h3len7mfe4mc61pfcgbju Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1605';
20240819@112059.8824 rq757h3len7mfe4mc61pfcgbju Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1605';
20240819@112059.8851 rq757h3len7mfe4mc61pfcgbju Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1605';
20240819@112059.9515 sp0gen6os1m1ta8q35r8dv6t2u Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240819@112059.9534 sp0gen6os1m1ta8q35r8dv6t2u Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240819@112059.9590 sp0gen6os1m1ta8q35r8dv6t2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1606';
20240819@112059.9643 sp0gen6os1m1ta8q35r8dv6t2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1606';
20240819@112059.9717 sp0gen6os1m1ta8q35r8dv6t2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1606';
20240819@112059.9745 sp0gen6os1m1ta8q35r8dv6t2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1606';
20240819@112059.9802 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112059.9806 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240819@112059.9879 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112059.9884 sp0gen6os1m1ta8q35r8dv6t2u Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240819@112059.9931 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4723.00.2'
20240819@112100.1160 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2054 and bo.obrano = 2405467 and bi.ref ='324.4723.00.2' and bi.lordem =1
20240819@112100.4410 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.4450 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240819@112100.4880 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.5030 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 1 valor from td where td.ndoc = 39
20240819@112100.5450 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.5490 sp0gen6os1m1ta8q35r8dv6t2u 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')
20240819@112100.5800 sp0gen6os1m1ta8q35r8dv6t2u 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
20240819@112100.6220 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.6250 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240819@112100.6670 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.6730 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240819@112100.7070 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.7100 sp0gen6os1m1ta8q35r8dv6t2u Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240819@112100.7570 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.7610 sp0gen6os1m1ta8q35r8dv6t2u Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240819@112100.8220 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.8260 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from td where ndoc = 39
20240819@112100.8410 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240819@112100.8590 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.8800 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240819@112100.9050 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.9240 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240819@112100.9620 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.9900 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240819@112100.1006 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240819@112100.1079 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240819@112100.1097 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.1114 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240819@112100.1135 sp0gen6os1m1ta8q35r8dv6t2u Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66c310658366c31c8c18' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240819@112100.1350 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.1371 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240819@112100.1410 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240819@112100.1426 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240819@112100.1440 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240819@112100.1454 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240819@112100.1468 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240819@112100.1507 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240819@112100.1522 sp0gen6os1m1ta8q35r8dv6t2u Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66c310658366c31c8c18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240819@112100.1808 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 fno valor from wsftdata order by fno desc
20240819@112100.1829 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.1847 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240819@112100.1875 sp0gen6os1m1ta8q35r8dv6t2u Query : select 'normal' from dummy
20240819@112100.1896 sp0gen6os1m1ta8q35r8dv6t2u Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66c310658366c31c8c18',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',416,100810,0,'2024-08-19',39,'euro',0,0,2024 ,?,?)
20240819@112100.2638 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.3228 sp0gen6os1m1ta8q35r8dv6t2u Query : select st.usalote valor from st where st.ref = '324.4723.00.2'
20240819@112100.3258 sp0gen6os1m1ta8q35r8dv6t2u 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.4723.00.2'
20240819@112100.3437 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.3456 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.3488 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.3504 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.3514 sp0gen6os1m1ta8q35r8dv6t2u Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112100.3529 sp0gen6os1m1ta8q35r8dv6t2u Query : select sestamp valor from se where ref ='324.4723.00.2' and lote = 'r2200682200a'
20240819@112100.3557 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.3576 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.3589 sp0gen6os1m1ta8q35r8dv6t2u Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c316271366c31c8c56','aut66c310658366c31c8c18' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112100.3595 sp0gen6os1m1ta8q35r8dv6t2u Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.3610 sp0gen6os1m1ta8q35r8dv6t2u Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.3647 sp0gen6os1m1ta8q35r8dv6t2u Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c316271366c31c8c56',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',39.000 ,'aut66c310658366c31c8c18' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240819@112100.3934 sp0gen6os1m1ta8q35r8dv6t2u Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66c310658366c31c8c18','2405467','wait',39,'adm09112754980.682000002')
20240819@112100.4010 sp0gen6os1m1ta8q35r8dv6t2u Query : use flama_phc
20240819@112100.4014 sp0gen6os1m1ta8q35r8dv6t2u Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@112100.4047 sp0gen6os1m1ta8q35r8dv6t2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1606';
20240819@112100.4076 sp0gen6os1m1ta8q35r8dv6t2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1606';
20240819@112100.4121 sp0gen6os1m1ta8q35r8dv6t2u Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1606';
20240819@112100.4146 sp0gen6os1m1ta8q35r8dv6t2u Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1606';
20240819@112100.4808 fr5ptr86nnmprv2ikeug285hgu Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240819@112100.4820 fr5ptr86nnmprv2ikeug285hgu Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240819@112100.4871 fr5ptr86nnmprv2ikeug285hgu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1607';
20240819@112100.4939 fr5ptr86nnmprv2ikeug285hgu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1607';
20240819@112100.4993 fr5ptr86nnmprv2ikeug285hgu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1607';
20240819@112100.5021 fr5ptr86nnmprv2ikeug285hgu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1607';
20240819@112100.5091 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.5095 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240819@112100.5181 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.5186 fr5ptr86nnmprv2ikeug285hgu Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240819@112100.5232 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240819@112100.5404 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2054 and bo.obrano = 2405468 and bi.ref ='324.948.00.01' and bi.lordem =1
20240819@112100.5744 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240819@112100.5767 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2054 and bo.obrano = 2405468 and bi.ref ='324.948.00.01' and bi.lordem =1
20240819@112100.5785 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.948.00.01'
20240819@112100.5806 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2054 and bo.obrano = 2405468 and bi.ref ='324.948.00.01' and bi.lordem =1
20240819@112100.5829 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.5832 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240819@112100.5869 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.5873 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 1 valor from td where td.ndoc = 39
20240819@112100.5921 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.5924 fr5ptr86nnmprv2ikeug285hgu 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')
20240819@112100.5964 fr5ptr86nnmprv2ikeug285hgu 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
20240819@112100.6003 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.6006 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240819@112100.6044 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.6047 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240819@112100.6079 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.6083 fr5ptr86nnmprv2ikeug285hgu Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240819@112100.6154 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.6158 fr5ptr86nnmprv2ikeug285hgu Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240819@112100.6208 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.6211 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from td where ndoc = 39
20240819@112100.6226 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240819@112100.6243 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.6268 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240819@112100.6290 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.6306 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240819@112100.6338 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.6356 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240819@112100.6373 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240819@112100.6446 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240819@112100.6461 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.6476 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240819@112100.6494 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66c311083066c31c8c9b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240819@112100.6683 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.6707 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240819@112100.6743 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240819@112100.6757 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240819@112100.6770 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240819@112100.6785 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240819@112100.6798 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240819@112100.6812 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240819@112100.6825 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66c311083066c31c8c9b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240819@112100.7165 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 fno valor from wsftdata order by fno desc
20240819@112100.7255 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.7274 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240819@112100.7300 fr5ptr86nnmprv2ikeug285hgu Query : select 'normal' from dummy
20240819@112100.7322 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66c311083066c31c8c9b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',417,100810,0,'2024-08-19',39,'euro',0,0,2024 ,?,?)
20240819@112100.7637 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.7641 fr5ptr86nnmprv2ikeug285hgu Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240819@112100.7665 fr5ptr86nnmprv2ikeug285hgu 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.948.00.01'
20240819@112100.7824 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.7843 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.7877 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.7897 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.7908 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112100.7922 fr5ptr86nnmprv2ikeug285hgu Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240819@112100.7939 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.7969 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.7984 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c311076966c31c8cc1','aut66c311083066c31c8c9b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112100.7989 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.8008 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.8043 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c311076966c31c8cc1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66c311083066c31c8c9b' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240819@112100.8317 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.8321 fr5ptr86nnmprv2ikeug285hgu Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240819@112100.8345 fr5ptr86nnmprv2ikeug285hgu 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.948.00.01'
20240819@112100.8381 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.8401 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.8443 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.8463 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.8473 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112100.8488 fr5ptr86nnmprv2ikeug285hgu Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240819@112100.8504 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.8525 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.8540 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c319085266c31c8ccf','aut66c311083066c31c8c9b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112100.8546 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.8588 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.8623 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c319085266c31c8ccf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',30.000 ,'aut66c311083066c31c8c9b' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240819@112100.8906 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.8909 fr5ptr86nnmprv2ikeug285hgu Query : select st.usalote valor from st where st.ref = '324.948.00.01'
20240819@112100.8938 fr5ptr86nnmprv2ikeug285hgu 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.948.00.01'
20240819@112100.8957 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.8980 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.9011 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.9035 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.9047 fr5ptr86nnmprv2ikeug285hgu Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112100.9061 fr5ptr86nnmprv2ikeug285hgu Query : select sestamp valor from se where ref ='324.948.00.01' and lote = 'r2301091200a'
20240819@112100.9075 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.9092 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112100.9106 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c316536666c31c8cdd','aut66c311083066c31c8c9b' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112100.9110 fr5ptr86nnmprv2ikeug285hgu Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112100.9128 fr5ptr86nnmprv2ikeug285hgu Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112100.9161 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c316536666c31c8cdd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66c311083066c31c8c9b' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240819@112100.9443 fr5ptr86nnmprv2ikeug285hgu Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66c311083066c31c8c9b','2405468','wait',39,'adm09112754980.682000002')
20240819@112100.9532 fr5ptr86nnmprv2ikeug285hgu Query : use flama_phc
20240819@112100.9546 fr5ptr86nnmprv2ikeug285hgu Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@112100.9616 fr5ptr86nnmprv2ikeug285hgu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1607';
20240819@112100.9650 fr5ptr86nnmprv2ikeug285hgu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1607';
20240819@112100.9693 fr5ptr86nnmprv2ikeug285hgu Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1607';
20240819@112100.9724 fr5ptr86nnmprv2ikeug285hgu Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1607';
20240819@112101.2760 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240819@112101.2870 91kl6pfbi6ck8qp91pnfemg7uq Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240819@112101.3630 91kl6pfbi6ck8qp91pnfemg7uq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1608';
20240819@112101.4200 91kl6pfbi6ck8qp91pnfemg7uq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1608';
20240819@112101.4710 91kl6pfbi6ck8qp91pnfemg7uq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1608';
20240819@112101.5010 91kl6pfbi6ck8qp91pnfemg7uq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1608';
20240819@112101.5720 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.5750 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240819@112101.6550 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.6600 91kl6pfbi6ck8qp91pnfemg7uq Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240819@112101.7060 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '326.595.00.01'
20240819@112101.8790 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2054 and bo.obrano = 2405473 and bi.ref ='326.595.00.01' and bi.lordem =1
20240819@112101.2180 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '326.595.00.01'
20240819@112101.2205 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2054 and bo.obrano = 2405473 and bi.ref ='326.595.00.01' and bi.lordem =1
20240819@112101.2226 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2230 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240819@112101.2275 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2279 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 1 valor from td where td.ndoc = 39
20240819@112101.2313 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2317 91kl6pfbi6ck8qp91pnfemg7uq 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')
20240819@112101.2347 91kl6pfbi6ck8qp91pnfemg7uq 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
20240819@112101.2387 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2391 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240819@112101.2431 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2434 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240819@112101.2468 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2472 91kl6pfbi6ck8qp91pnfemg7uq Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240819@112101.2516 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2520 91kl6pfbi6ck8qp91pnfemg7uq Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240819@112101.2571 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.2575 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from td where ndoc = 39
20240819@112101.2592 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240819@112101.2610 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.2629 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240819@112101.2652 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.2675 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240819@112101.2711 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.2728 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240819@112101.2744 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240819@112101.2818 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240819@112101.2834 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.2854 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240819@112101.2874 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66c314472966c31c8d42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240819@112101.3071 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.3089 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240819@112101.3130 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240819@112101.3145 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240819@112101.3160 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240819@112101.3178 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240819@112101.3192 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240819@112101.3205 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240819@112101.3221 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66c314472966c31c8d42',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240819@112101.3485 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 fno valor from wsftdata order by fno desc
20240819@112101.3505 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.3523 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240819@112101.3550 91kl6pfbi6ck8qp91pnfemg7uq Query : select 'normal' from dummy
20240819@112101.3631 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66c314472966c31c8d42',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',418,100810,0,'2024-08-19',39,'euro',0,0,2024 ,?,?)
20240819@112101.3964 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.3968 91kl6pfbi6ck8qp91pnfemg7uq Query : select st.usalote valor from st where st.ref = '326.595.00.01'
20240819@112101.3995 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '326.595.00.01'
20240819@112101.4150 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4176 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112101.4218 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4238 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112101.4247 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112101.4261 91kl6pfbi6ck8qp91pnfemg7uq Query : select sestamp valor from se where ref ='326.595.00.01' and lote = 'r2301243100a'
20240819@112101.4276 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4293 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112101.4307 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c318248866c31c8d68','aut66c314472966c31c8d42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112101.4314 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4335 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112101.4369 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c318248866c31c8d68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66c314472966c31c8d42' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240819@112101.4702 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.4706 91kl6pfbi6ck8qp91pnfemg7uq Query : select st.usalote valor from st where st.ref = '326.595.00.01'
20240819@112101.4732 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '326.595.00.01'
20240819@112101.4749 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4767 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112101.4800 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4817 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112101.4828 91kl6pfbi6ck8qp91pnfemg7uq Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240819@112101.4844 91kl6pfbi6ck8qp91pnfemg7uq Query : select sestamp valor from se where ref ='326.595.00.01' and lote = 'r2301243100a'
20240819@112101.4863 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4881 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240819@112101.4896 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c314802866c31c8d76','aut66c314472966c31c8d42' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240819@112101.4901 91kl6pfbi6ck8qp91pnfemg7uq Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240819@112101.4944 91kl6pfbi6ck8qp91pnfemg7uq Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240819@112101.4977 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66c314802866c31c8d76',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66c314472966c31c8d42' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240819@112101.5266 91kl6pfbi6ck8qp91pnfemg7uq Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66c314472966c31c8d42','2405473','wait',39,'adm09112754980.682000002')
20240819@112101.5344 91kl6pfbi6ck8qp91pnfemg7uq Query : use flama_phc
20240819@112101.5348 91kl6pfbi6ck8qp91pnfemg7uq Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@112101.5381 91kl6pfbi6ck8qp91pnfemg7uq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1608';
20240819@112101.5411 91kl6pfbi6ck8qp91pnfemg7uq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1608';
20240819@112101.5462 91kl6pfbi6ck8qp91pnfemg7uq Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1608';
20240819@112101.5488 91kl6pfbi6ck8qp91pnfemg7uq Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1608';
20240819@112438.8806 h8pr961l9p0hv0scl760cbr07b Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240819@112438.8822 h8pr961l9p0hv0scl760cbr07b Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240819@112438.8955 h8pr961l9p0hv0scl760cbr07b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1609';
20240819@112438.9038 h8pr961l9p0hv0scl760cbr07b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1609';
20240819@112438.9108 h8pr961l9p0hv0scl760cbr07b Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1609';
20240819@112438.9140 h8pr961l9p0hv0scl760cbr07b Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1609';
20240819@112439.6400 78a2blb9bmc3bnbjm0m66hknoe Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240819@112439.7600 78a2blb9bmc3bnbjm0m66hknoe Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240819@112439.1460 78a2blb9bmc3bnbjm0m66hknoe Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1610';
20240819@112439.2100 78a2blb9bmc3bnbjm0m66hknoe Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1610';
20240819@112439.2770 78a2blb9bmc3bnbjm0m66hknoe Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1610';
20240819@112439.3060 78a2blb9bmc3bnbjm0m66hknoe Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1610';
20240819@112456.8097 35djfp0vkc70bujb9kv1oatbht Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240819@112456.8123 35djfp0vkc70bujb9kv1oatbht Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240819@112456.8204 35djfp0vkc70bujb9kv1oatbht Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1611';
20240819@112456.8266 35djfp0vkc70bujb9kv1oatbht Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1611';
20240819@112456.8363 35djfp0vkc70bujb9kv1oatbht Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1611';
20240819@112456.8397 35djfp0vkc70bujb9kv1oatbht Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1611';
20240819@113608.9626 3khb0r273uv5l9e7s1s9in4qaj Query : use flama_phc
20240819@113608.9630 3khb0r273uv5l9e7s1s9in4qaj Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@113608.9754 3khb0r273uv5l9e7s1s9in4qaj Query : use flama_phc
20240819@113608.9758 3khb0r273uv5l9e7s1s9in4qaj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@121916.8859 l0dtk6hlc5gmsnf8hj7kksqhc1 Query : use flama_phc
20240819@121916.8864 l0dtk6hlc5gmsnf8hj7kksqhc1 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@121916.8961 l0dtk6hlc5gmsnf8hj7kksqhc1 Query : use flama_phc
20240819@121916.8965 l0dtk6hlc5gmsnf8hj7kksqhc1 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@123617.2733 sc3423tp4mur63rc9kprn7n5ml Query : use flama_phc
20240819@123617.2800 sc3423tp4mur63rc9kprn7n5ml Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@123617.3443 sc3423tp4mur63rc9kprn7n5ml Query : use flama_phc
20240819@123617.3496 sc3423tp4mur63rc9kprn7n5ml Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@131912.1794 ohdjkg3vo7mpaqi8alk6r96lnh Query : use flama_phc
20240819@131912.1798 ohdjkg3vo7mpaqi8alk6r96lnh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@131912.1924 ohdjkg3vo7mpaqi8alk6r96lnh Query : use flama_phc
20240819@131912.1928 ohdjkg3vo7mpaqi8alk6r96lnh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@133612.2806 8ujf19uk2beqefhgkj6h8aomp8 Query : use flama_phc
20240819@133612.2812 8ujf19uk2beqefhgkj6h8aomp8 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@133612.2958 8ujf19uk2beqefhgkj6h8aomp8 Query : use flama_phc
20240819@133612.2962 8ujf19uk2beqefhgkj6h8aomp8 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@141911.7172 ndf4gp1cqle9lm12n5upoe7s15 Query : use flama_phc
20240819@141911.7178 ndf4gp1cqle9lm12n5upoe7s15 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@141911.7286 ndf4gp1cqle9lm12n5upoe7s15 Query : use flama_phc
20240819@141911.7290 ndf4gp1cqle9lm12n5upoe7s15 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@143611.9677 othbp150t84lb67opir1qcvgjo Query : use flama_phc
20240819@143611.9682 othbp150t84lb67opir1qcvgjo Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@143611.9791 othbp150t84lb67opir1qcvgjo Query : use flama_phc
20240819@143611.9796 othbp150t84lb67opir1qcvgjo Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@151910.2796 sms3orkifqo12rajs718dck2vk Query : use flama_phc
20240819@151910.2800 sms3orkifqo12rajs718dck2vk Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@151910.2892 sms3orkifqo12rajs718dck2vk Query : use flama_phc
20240819@151910.2895 sms3orkifqo12rajs718dck2vk Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@153610.5156 c5333vq30l066oj4lcrlpmpisb Query : use flama_phc
20240819@153610.5160 c5333vq30l066oj4lcrlpmpisb Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@153610.5268 c5333vq30l066oj4lcrlpmpisb Query : use flama_phc
20240819@153610.5273 c5333vq30l066oj4lcrlpmpisb Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@161917.9295 2u12415ommues56s03d06hp491 Query : use flama_phc
20240819@161917.9301 2u12415ommues56s03d06hp491 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@161917.9412 2u12415ommues56s03d06hp491 Query : use flama_phc
20240819@161917.9416 2u12415ommues56s03d06hp491 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@163618.2709 fsl9jbhuo928qgtp03er8u07r7 Query : use flama_phc
20240819@163618.2714 fsl9jbhuo928qgtp03er8u07r7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@163618.2823 fsl9jbhuo928qgtp03er8u07r7 Query : use flama_phc
20240819@163618.2828 fsl9jbhuo928qgtp03er8u07r7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@171912.2000 iq9bb64035k2f7losm2untgr2a Query : use flama_phc
20240819@171912.7000 iq9bb64035k2f7losm2untgr2a Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@171912.1010 iq9bb64035k2f7losm2untgr2a Query : use flama_phc
20240819@171912.1050 iq9bb64035k2f7losm2untgr2a Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@173611.8518 ijpcl3e4rhduln60u1tedvk3hc Query : use flama_phc
20240819@173611.8524 ijpcl3e4rhduln60u1tedvk3hc Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@173611.8628 ijpcl3e4rhduln60u1tedvk3hc Query : use flama_phc
20240819@173611.8632 ijpcl3e4rhduln60u1tedvk3hc Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@181909.6650 519l2pivboeog6uf1bdpq2n6m7 Query : use flama_phc
20240819@181909.6654 519l2pivboeog6uf1bdpq2n6m7 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@181909.6755 519l2pivboeog6uf1bdpq2n6m7 Query : use flama_phc
20240819@181909.6760 519l2pivboeog6uf1bdpq2n6m7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@183609.7607 83a9rfq59mduv3ia6jfqppd03g Query : use flama_phc
20240819@183609.7612 83a9rfq59mduv3ia6jfqppd03g Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@183609.8884 83a9rfq59mduv3ia6jfqppd03g Query : use flama_phc
20240819@183609.8889 83a9rfq59mduv3ia6jfqppd03g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@191910.5380 roib14vlnvit5flf6i2ah5v83b Query : use flama_phc
20240819@191910.5440 roib14vlnvit5flf6i2ah5v83b Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@191910.6390 roib14vlnvit5flf6i2ah5v83b Query : use flama_phc
20240819@191910.6430 roib14vlnvit5flf6i2ah5v83b Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@193609.8834 f5e01v63qdq06hlnh7gi0irnjv Query : use flama_phc
20240819@193609.8841 f5e01v63qdq06hlnh7gi0irnjv Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@193609.8948 f5e01v63qdq06hlnh7gi0irnjv Query : use flama_phc
20240819@193609.8953 f5e01v63qdq06hlnh7gi0irnjv Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@201913.2100 rr8kmka85dap70julsp75ihuh2 Query : use flama_phc
20240819@201913.2160 rr8kmka85dap70julsp75ihuh2 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@201913.3140 rr8kmka85dap70julsp75ihuh2 Query : use flama_phc
20240819@201913.3180 rr8kmka85dap70julsp75ihuh2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@203613.1668 j2bff7eeojd6egcg45mqfmc5vh Query : use flama_phc
20240819@203613.1673 j2bff7eeojd6egcg45mqfmc5vh Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@203613.1879 j2bff7eeojd6egcg45mqfmc5vh Query : use flama_phc
20240819@203613.1883 j2bff7eeojd6egcg45mqfmc5vh Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@211910.2908 vd3r0vn6gt2tsi1o175cqkm4e0 Query : use flama_phc
20240819@211910.2914 vd3r0vn6gt2tsi1o175cqkm4e0 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@211910.3008 vd3r0vn6gt2tsi1o175cqkm4e0 Query : use flama_phc
20240819@211910.3013 vd3r0vn6gt2tsi1o175cqkm4e0 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@213610.4417 dckdf04uim27u0psfbcsrbph50 Query : use flama_phc
20240819@213610.4422 dckdf04uim27u0psfbcsrbph50 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@213610.4517 dckdf04uim27u0psfbcsrbph50 Query : use flama_phc
20240819@213610.4521 dckdf04uim27u0psfbcsrbph50 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@221912.1748 kti984njg5kl9fjft2rk1kjtbs Query : use flama_phc
20240819@221912.1753 kti984njg5kl9fjft2rk1kjtbs Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@221912.1864 kti984njg5kl9fjft2rk1kjtbs Query : use flama_phc
20240819@221912.1868 kti984njg5kl9fjft2rk1kjtbs Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@223611.7785 h772ap1u0quut4jarakohq0541 Query : use flama_phc
20240819@223611.7790 h772ap1u0quut4jarakohq0541 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@223611.7898 h772ap1u0quut4jarakohq0541 Query : use flama_phc
20240819@223611.7902 h772ap1u0quut4jarakohq0541 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@231911.2263 kt9m98djtpvbd83qptg4di5tt4 Query : use flama_phc
20240819@231911.2268 kt9m98djtpvbd83qptg4di5tt4 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@231911.2368 kt9m98djtpvbd83qptg4di5tt4 Query : use flama_phc
20240819@231911.2372 kt9m98djtpvbd83qptg4di5tt4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240819@233611.1885 1ba7sitkejatl2tltkdni1mlda Query : use flama_phc
20240819@233611.1891 1ba7sitkejatl2tltkdni1mlda Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240819@233611.2000 1ba7sitkejatl2tltkdni1mlda Query : use flama_phc
20240819@233611.2005 1ba7sitkejatl2tltkdni1mlda Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@071910.5404 pubkfbsb51f5cm716o2ca3ukpi Query : use flama_phc
20240820@071910.5409 pubkfbsb51f5cm716o2ca3ukpi Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@071910.5551 pubkfbsb51f5cm716o2ca3ukpi Query : use flama_phc
20240820@071910.5555 pubkfbsb51f5cm716o2ca3ukpi Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@073643.2951 o3q7ojko1dnj8cbb8luk470277 Query : use flama_phc
20240820@073643.2957 o3q7ojko1dnj8cbb8luk470277 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@073643.3054 o3q7ojko1dnj8cbb8luk470277 Query : use flama_phc
20240820@073643.3059 o3q7ojko1dnj8cbb8luk470277 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@081910.9711 0d4l1901o63pl5oargvblcs8st Query : use flama_phc
20240820@081910.9717 0d4l1901o63pl5oargvblcs8st Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@081910.9846 0d4l1901o63pl5oargvblcs8st Query : use flama_phc
20240820@081910.9851 0d4l1901o63pl5oargvblcs8st Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@083610.9696 afvn6sel716srmt24cp26l2sej Query : use flama_phc
20240820@083610.9701 afvn6sel716srmt24cp26l2sej Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@083610.9835 afvn6sel716srmt24cp26l2sej Query : use flama_phc
20240820@083610.9839 afvn6sel716srmt24cp26l2sej Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@091908.5079 j2enfpqao5hfq1n8nbl93cthsg Query : use flama_phc
20240820@091908.5085 j2enfpqao5hfq1n8nbl93cthsg Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@091908.5185 j2enfpqao5hfq1n8nbl93cthsg Query : use flama_phc
20240820@091908.5215 j2enfpqao5hfq1n8nbl93cthsg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@093608.8673 socjh5i4498or40fuf22gi2vaa Query : use flama_phc
20240820@093608.8678 socjh5i4498or40fuf22gi2vaa Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@093608.8774 socjh5i4498or40fuf22gi2vaa Query : use flama_phc
20240820@093608.8784 socjh5i4498or40fuf22gi2vaa Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@101911.5267 a1gt9a6teav5du079a1a58dfc3 Query : use flama_phc
20240820@101911.5272 a1gt9a6teav5du079a1a58dfc3 Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@101911.5370 a1gt9a6teav5du079a1a58dfc3 Query : use flama_phc
20240820@101911.5374 a1gt9a6teav5du079a1a58dfc3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@103611.6202 9ads594piup149tmkp55o72q2m Query : use flama_phc
20240820@103611.6267 9ads594piup149tmkp55o72q2m Query : select secretkey valor from u_wsusers u where u.userid = ? and u.username=? and u.password=? and u.inactivo=0
20240820@103611.7249 9ads594piup149tmkp55o72q2m Query : use flama_phc
20240820@103611.7292 9ads594piup149tmkp55o72q2m Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240820@110619.3395 02ftfegeb5tnfaf110d54d3aum Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240820@110619.3422 02ftfegeb5tnfaf110d54d3aum Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240820@110619.3574 02ftfegeb5tnfaf110d54d3aum Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1612';
20240820@110619.3640 02ftfegeb5tnfaf110d54d3aum Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1612';
20240820@110619.3723 02ftfegeb5tnfaf110d54d3aum Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1612';
20240820@110619.3754 02ftfegeb5tnfaf110d54d3aum Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1612';
20240820@110619.3799 02ftfegeb5tnfaf110d54d3aum Query : use flama_phc
20240820@110619.3803 02ftfegeb5tnfaf110d54d3aum Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240820@110619.3936 02ftfegeb5tnfaf110d54d3aum Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '327.8460.00.2'
20240820@110619.5494 02ftfegeb5tnfaf110d54d3aum Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =002 and bo.boano =2024 and bo.obrano = 2400400 and bi.ref ='327.8460.00.2' and bi.lordem =10000
20240820@110619.5928 02ftfegeb5tnfaf110d54d3aum Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'cps24042431855,500000003 ' 
20240820@110619.6280 02ftfegeb5tnfaf110d54d3aum Query : use flama_phc
20240820@110619.6285 02ftfegeb5tnfaf110d54d3aum Query : select top 1 1 valor from ts where ts.ndos = 61
20240820@110619.6407 02ftfegeb5tnfaf110d54d3aum Query : use flama_phc
20240820@110619.6411 02ftfegeb5tnfaf110d54d3aum 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')
20240820@110619.6488 02ftfegeb5tnfaf110d54d3aum Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =61
20240820@110619.6657 02ftfegeb5tnfaf110d54d3aum Query : use flama_phc
20240820@110619.6661 02ftfegeb5tnfaf110d54d3aum Query : select top 1 ~inactivo valor from fl where no = '202542' and estab = 00 order by inactivo desc
20240820@110619.6801 02ftfegeb5tnfaf110d54d3aum Query : use flama_phc
20240820@110619.6804 02ftfegeb5tnfaf110d54d3aum Query : select 1 valor from ts where ndos = 61
20240820@110619.6884 02ftfegeb5tnfaf110d54d3aum Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240820@110619.7164 02ftfegeb5tnfaf110d54d3aum Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 61
20240820@110619.7208 02ftfegeb5tnfaf110d54d3aum Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240820@110619.7225 02ftfegeb5tnfaf110d54d3aum Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 61
20240820@110619.7238 02ftfegeb5tnfaf110d54d3aum Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240820@110619.7255 02ftfegeb5tnfaf110d54d3aum Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 61
20240820@110619.7266 02ftfegeb5tnfaf110d54d3aum Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 61
20240820@110619.7395 02ftfegeb5tnfaf110d54d3aum Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240820@110619.7558 02ftfegeb5tnfaf110d54d3aum Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 61 and boano=2024 order by obrano desc
20240820@110619.7582 02ftfegeb5tnfaf110d54d3aum Query : use flama_phc
20240820@110619.7590 02ftfegeb5tnfaf110d54d3aum Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='202542' and estab=00
20240820@110619.7688 02ftfegeb5tnfaf110d54d3aum Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240820@110619.7709 02ftfegeb5tnfaf110d54d3aum Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 61
20240820@110619.7748 02ftfegeb5tnfaf110d54d3aum Query : insert into bo3 (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c461040766c46a9bb9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240820@110619.7822 02ftfegeb5tnfaf110d54d3aum Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240820@110619.7839 02ftfegeb5tnfaf110d54d3aum Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 61
20240820@110619.7854 02ftfegeb5tnfaf110d54d3aum Query : insert into bo2 (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c461040766c46a9bb9','--','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240820@110619.8068 02ftfegeb5tnfaf110d54d3aum Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240820@110619.8089 02ftfegeb5tnfaf110d54d3aum Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 61
20240820@110619.8105 02ftfegeb5tnfaf110d54d3aum Query : insert into bo (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66c461040766c46a9bb9','guia r. fornecedor','2024-08-20',61,2402310,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20240820@110619.9417 02ftfegeb5tnfaf110d54d3aum Query : use flama_phc
20240820@110619.9421 02ftfegeb5tnfaf110d54d3aum Query : select st.usalote valor from st where st.ref = '327.8460.00.2'
