20240729@182944.6828 013ujp74tlelbg3ld2am6g90sj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240729@182944.6842 013ujp74tlelbg3ld2am6g90sj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240729@182944.6857 013ujp74tlelbg3ld2am6g90sj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240729@182944.6874 013ujp74tlelbg3ld2am6g90sj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240729@182944.6888 013ujp74tlelbg3ld2am6g90sj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240729@182944.6903 013ujp74tlelbg3ld2am6g90sj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a7d1084066a7d1889d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240729@182944.7185 013ujp74tlelbg3ld2am6g90sj Query : select top 1 fno valor from wsftdata order by fno desc
20240729@182944.7209 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.7228 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240729@182944.7254 013ujp74tlelbg3ld2am6g90sj Query : select 'normal' from dummy
20240729@182944.7272 013ujp74tlelbg3ld2am6g90sj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a7d1084066a7d1889d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',78,200500,0,'2024-07-29',39,'euro',0,0,2024 ,?,?)
20240729@182944.7617 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182944.7621 013ujp74tlelbg3ld2am6g90sj Query : select st.usalote valor from st where st.ref = '324.4840.00.1'
20240729@182944.7653 013ujp74tlelbg3ld2am6g90sj 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.4840.00.1'
20240729@182944.8630 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.8648 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182944.8674 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.8691 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182944.8700 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182944.8713 013ujp74tlelbg3ld2am6g90sj Query : select sestamp valor from se where ref ='324.4840.00.1' and lote = 'r2400064200a'
20240729@182944.8725 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.8740 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182944.8752 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d2136066a7d188d5','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182944.8756 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.8772 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182944.8803 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d2136066a7d188d5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240729@182944.9075 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182944.9078 013ujp74tlelbg3ld2am6g90sj Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20240729@182944.9100 013ujp74tlelbg3ld2am6g90sj 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.2224.00.1'
20240729@182944.9116 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9132 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182944.9161 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9176 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182944.9185 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182944.9198 013ujp74tlelbg3ld2am6g90sj Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301281600a'
20240729@182944.9212 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9227 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182944.9240 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d3224566a7d188e0','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182944.9245 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9260 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182944.9291 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d3224566a7d188e0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240729@182944.9548 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182944.9551 013ujp74tlelbg3ld2am6g90sj Query : select st.usalote valor from st where st.ref = '324.645.00.01'
20240729@182944.9574 013ujp74tlelbg3ld2am6g90sj 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.645.00.01'
20240729@182944.9590 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9608 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182944.9656 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9672 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182944.9682 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182944.9700 013ujp74tlelbg3ld2am6g90sj Query : select sestamp valor from se where ref ='324.645.00.01' and lote = 'r2400055200a'
20240729@182944.9715 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9739 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182944.9752 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d9198466a7d188ed','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182944.9757 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182944.9773 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182944.9805 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d9198466a7d188ed',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240729@182945.8700 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1060 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.1340 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1500 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.1590 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.1720 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1890 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.2070 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d1393866a7d18904','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.2120 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.2320 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.2670 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d1393866a7d18904',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,40000,?,?,?)
20240729@182945.5330 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182945.5370 013ujp74tlelbg3ld2am6g90sj Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240729@182945.5600 013ujp74tlelbg3ld2am6g90sj 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.646.00.01'
20240729@182945.5760 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.5930 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.6200 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.6360 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.6450 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.6580 013ujp74tlelbg3ld2am6g90sj Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240729@182945.6720 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.6870 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.7000 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d2195766a7d18910','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.7040 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.7190 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.7510 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d2195766a7d18910',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240729@182945.1043 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1060 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.1090 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1106 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.1115 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.1128 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1145 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.1159 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d3566166a7d1891b','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.1164 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1181 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.1213 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d3566166a7d1891b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,70000,?,?,?)
20240729@182945.1472 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182945.1477 013ujp74tlelbg3ld2am6g90sj Query : select st.usalote valor from st where st.ref = '324.646.00.01'
20240729@182945.1497 013ujp74tlelbg3ld2am6g90sj 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.646.00.01'
20240729@182945.1511 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1527 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.1555 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1570 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.1579 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.1592 013ujp74tlelbg3ld2am6g90sj Query : select sestamp valor from se where ref ='324.646.00.01' and lote = 'r2400055100a'
20240729@182945.1606 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1621 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.1633 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d8657266a7d18927','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.1638 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1653 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.1682 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d8657266a7d18927',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',9.000 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20240729@182945.1940 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1955 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.1981 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.1995 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.2004 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.2016 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.2032 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.2063 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d1289466a7d18931','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.2068 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.2082 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.2142 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d1289466a7d18931',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,100000,?,?,?)
20240729@182945.2413 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182945.2417 013ujp74tlelbg3ld2am6g90sj Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240729@182945.2438 013ujp74tlelbg3ld2am6g90sj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20240729@182945.2453 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.2471 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.2499 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.2514 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.2522 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.2534 013ujp74tlelbg3ld2am6g90sj Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2300915100a'
20240729@182945.2548 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.2564 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.2575 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d2334766a7d1893e','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.2580 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.2594 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.2622 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d2334766a7d1893e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,120000,?,?,?,?,?)
20240729@182945.4023 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.4041 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.4067 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.4082 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.4090 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.4103 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.4117 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.4129 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d8470466a7d18964','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.4133 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.4148 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.4179 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d8470466a7d18964',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,130000,?,?,?)
20240729@182945.4467 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182945.4470 013ujp74tlelbg3ld2am6g90sj Query : select st.usalote valor from st where st.ref = '324.4930.00.1'
20240729@182945.4489 013ujp74tlelbg3ld2am6g90sj 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.4930.00.1'
20240729@182945.4505 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.5078 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.5154 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.5173 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.5182 013ujp74tlelbg3ld2am6g90sj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.5194 013ujp74tlelbg3ld2am6g90sj Query : select sestamp valor from se where ref ='324.4930.00.1' and lote = 'r2400066200a'
20240729@182945.5207 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.5222 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.5236 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d8478266a7d1897f','aut66a7d1084066a7d1889d' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182945.5240 013ujp74tlelbg3ld2am6g90sj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.5255 013ujp74tlelbg3ld2am6g90sj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.5286 013ujp74tlelbg3ld2am6g90sj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d8478266a7d1897f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a7d1084066a7d1889d' ,0,0 ,2,23.00,150000,?,?,?,?,?)
20240729@182945.5618 013ujp74tlelbg3ld2am6g90sj Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a7d1084066a7d1889d','2405044','wait',39,'adm09112754980.682000002')
20240729@182945.5694 013ujp74tlelbg3ld2am6g90sj Query : use flama_phc
20240729@182945.5697 013ujp74tlelbg3ld2am6g90sj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240729@182945.5728 013ujp74tlelbg3ld2am6g90sj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1234';
20240729@182945.5754 013ujp74tlelbg3ld2am6g90sj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1234';
20240729@182945.5791 013ujp74tlelbg3ld2am6g90sj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1234';
20240729@182945.5813 013ujp74tlelbg3ld2am6g90sj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1234';
20240729@182945.6481 b3vfgi7vlc2mj5sanam4gclmit Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240729@182945.6493 b3vfgi7vlc2mj5sanam4gclmit Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240729@182945.6550 b3vfgi7vlc2mj5sanam4gclmit Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1235';
20240729@182945.6608 b3vfgi7vlc2mj5sanam4gclmit Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1235';
20240729@182945.6653 b3vfgi7vlc2mj5sanam4gclmit Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1235';
20240729@182945.6675 b3vfgi7vlc2mj5sanam4gclmit Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1235';
20240729@182945.6718 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.6721 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240729@182945.6781 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.6784 b3vfgi7vlc2mj5sanam4gclmit Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240729@182945.6822 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240729@182945.7203 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405046 and bi.ref ='324.1803.00.1' and bi.lordem =1
20240729@182945.7550 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240729@182945.7572 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405046 and bi.ref ='324.1803.00.1' and bi.lordem =1
20240729@182945.7592 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240729@182945.7613 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405046 and bi.ref ='324.1803.00.1' and bi.lordem =1
20240729@182945.7629 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240729@182945.7649 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405046 and bi.ref ='324.1803.00.1' and bi.lordem =1
20240729@182945.7665 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240729@182945.7686 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405046 and bi.ref ='324.1803.00.1' and bi.lordem =1
20240729@182945.7702 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1803.00.1'
20240729@182945.7721 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405046 and bi.ref ='324.1803.00.1' and bi.lordem =1
20240729@182945.7743 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.7746 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240729@182945.7778 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.7781 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 1 valor from td where td.ndoc = 39
20240729@182945.7811 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.7814 b3vfgi7vlc2mj5sanam4gclmit 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')
20240729@182945.7841 b3vfgi7vlc2mj5sanam4gclmit 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
20240729@182945.7875 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.7878 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240729@182945.7908 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.7911 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240729@182945.7941 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.7943 b3vfgi7vlc2mj5sanam4gclmit Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240729@182945.7984 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.7987 b3vfgi7vlc2mj5sanam4gclmit Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240729@182945.8031 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.8034 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from td where ndoc = 39
20240729@182945.8046 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240729@182945.8060 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.8077 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240729@182945.8097 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.8124 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240729@182945.8369 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.8384 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240729@182945.8398 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240729@182945.8471 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240729@182945.8485 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.8501 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240729@182945.8516 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a7d9834966a7d189cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240729@182945.8739 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.8758 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240729@182945.8791 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240729@182945.8803 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240729@182945.8815 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240729@182945.8827 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240729@182945.8839 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240729@182945.8851 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240729@182945.8863 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a7d9834966a7d189cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240729@182945.9173 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 fno valor from wsftdata order by fno desc
20240729@182945.9196 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.9221 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240729@182945.9246 b3vfgi7vlc2mj5sanam4gclmit Query : select 'normal' from dummy
20240729@182945.9267 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a7d9834966a7d189cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',79,100810,0,'2024-07-29',39,'euro',0,0,2024 ,?,?)
20240729@182945.9650 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182945.9654 b3vfgi7vlc2mj5sanam4gclmit Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20240729@182945.9679 b3vfgi7vlc2mj5sanam4gclmit 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.1803.00.1'
20240729@182945.9894 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.9913 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182945.9946 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182945.9963 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182945.9973 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182945.9987 b3vfgi7vlc2mj5sanam4gclmit Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2300883200a'
20240729@182946.1000 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.2700 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.4200 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d5134566a7d18a00','aut66a7d9834966a7d189cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.4600 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.6400 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.3440 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d5134566a7d18a00',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66a7d9834966a7d189cd' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240729@182946.1413 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182946.1419 b3vfgi7vlc2mj5sanam4gclmit Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20240729@182946.1445 b3vfgi7vlc2mj5sanam4gclmit 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.1803.00.1'
20240729@182946.1460 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.1480 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.1508 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.1522 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.1530 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182946.1541 b3vfgi7vlc2mj5sanam4gclmit Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301207200a'
20240729@182946.1555 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.1569 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.1580 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d8398366a7d18a25','aut66a7d9834966a7d189cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.1584 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.1598 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.1625 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d8398366a7d18a25',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66a7d9834966a7d189cd' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240729@182946.2628 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182946.2633 b3vfgi7vlc2mj5sanam4gclmit Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20240729@182946.2653 b3vfgi7vlc2mj5sanam4gclmit 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.1803.00.1'
20240729@182946.2667 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.2683 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.2707 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.2722 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.2734 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182946.2746 b3vfgi7vlc2mj5sanam4gclmit Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2300883200a'
20240729@182946.2759 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.2773 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.2784 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d5813866a7d18a43','aut66a7d9834966a7d189cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.2789 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.2803 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.2831 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d5813866a7d18a43',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d9834966a7d189cd' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240729@182946.3091 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182946.3094 b3vfgi7vlc2mj5sanam4gclmit Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20240729@182946.3115 b3vfgi7vlc2mj5sanam4gclmit 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.1803.00.1'
20240729@182946.3129 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3211 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.3238 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3255 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.3265 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182946.3278 b3vfgi7vlc2mj5sanam4gclmit Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301207200a'
20240729@182946.3291 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3306 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.3318 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d9461966a7d18a50','aut66a7d9834966a7d189cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.3323 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3338 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.3375 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d9461966a7d18a50',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d9834966a7d189cd' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240729@182946.3636 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182946.3639 b3vfgi7vlc2mj5sanam4gclmit Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20240729@182946.3661 b3vfgi7vlc2mj5sanam4gclmit 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.1803.00.1'
20240729@182946.3676 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3693 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.3722 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3738 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.3746 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182946.3759 b3vfgi7vlc2mj5sanam4gclmit Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301207200a'
20240729@182946.3771 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3786 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.3800 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d1666566a7d18a5c','aut66a7d9834966a7d189cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.3804 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.3819 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.3849 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d1666566a7d18a5c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d9834966a7d189cd' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240729@182946.4111 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182946.4114 b3vfgi7vlc2mj5sanam4gclmit Query : select st.usalote valor from st where st.ref = '324.1803.00.1'
20240729@182946.4134 b3vfgi7vlc2mj5sanam4gclmit 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.1803.00.1'
20240729@182946.4149 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.4168 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.4199 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.4216 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.4226 b3vfgi7vlc2mj5sanam4gclmit Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182946.4246 b3vfgi7vlc2mj5sanam4gclmit Query : select sestamp valor from se where ref ='324.1803.00.1' and lote = 'r2301207200a'
20240729@182946.4262 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.4280 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.4294 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d9733366a7d18a68','aut66a7d9834966a7d189cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.4299 b3vfgi7vlc2mj5sanam4gclmit Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.4314 b3vfgi7vlc2mj5sanam4gclmit Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.4344 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d9733366a7d18a68',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d9834966a7d189cd' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20240729@182946.4621 b3vfgi7vlc2mj5sanam4gclmit Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a7d9834966a7d189cd','2405046','wait',39,'adm09112754980.682000002')
20240729@182946.4702 b3vfgi7vlc2mj5sanam4gclmit Query : use flama_phc
20240729@182946.4705 b3vfgi7vlc2mj5sanam4gclmit Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240729@182946.4746 b3vfgi7vlc2mj5sanam4gclmit Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1235';
20240729@182946.4777 b3vfgi7vlc2mj5sanam4gclmit Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1235';
20240729@182946.4821 b3vfgi7vlc2mj5sanam4gclmit Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1235';
20240729@182946.4852 b3vfgi7vlc2mj5sanam4gclmit Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1235';
20240729@182946.5376 tvsk8qnga50d9834s1i26uacg5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240729@182946.5399 tvsk8qnga50d9834s1i26uacg5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240729@182946.5453 tvsk8qnga50d9834s1i26uacg5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1236';
20240729@182946.5507 tvsk8qnga50d9834s1i26uacg5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1236';
20240729@182946.5561 tvsk8qnga50d9834s1i26uacg5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1236';
20240729@182946.5586 tvsk8qnga50d9834s1i26uacg5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1236';
20240729@182946.5638 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.5643 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240729@182946.5717 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.5721 tvsk8qnga50d9834s1i26uacg5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240729@182946.5767 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240729@182946.5949 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405047 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240729@182946.6279 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240729@182946.6304 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405047 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240729@182946.6321 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240729@182946.6343 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405047 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240729@182946.6363 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1833.00.2'
20240729@182946.6386 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405047 and bi.ref ='324.1833.00.2' and bi.lordem =1
20240729@182946.6405 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6408 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240729@182946.6444 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6448 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 1 valor from td where td.ndoc = 39
20240729@182946.6482 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6485 tvsk8qnga50d9834s1i26uacg5 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')
20240729@182946.6516 tvsk8qnga50d9834s1i26uacg5 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
20240729@182946.6555 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6558 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240729@182946.6594 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6598 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240729@182946.6633 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6636 tvsk8qnga50d9834s1i26uacg5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240729@182946.6681 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6685 tvsk8qnga50d9834s1i26uacg5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240729@182946.6737 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.6741 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from td where ndoc = 39
20240729@182946.6754 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240729@182946.6770 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.6788 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240729@182946.6811 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.6827 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240729@182946.6859 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.6874 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240729@182946.6888 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240729@182946.6987 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240729@182946.7001 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.7016 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240729@182946.7032 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a7d8252066a7d18aa8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240729@182946.7244 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.7262 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240729@182946.7301 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240729@182946.7314 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240729@182946.7326 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240729@182946.7340 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240729@182946.7353 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240729@182946.7364 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240729@182946.7378 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a7d8252066a7d18aa8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240729@182946.7624 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 fno valor from wsftdata order by fno desc
20240729@182946.8329 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.8350 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240729@182946.8374 tvsk8qnga50d9834s1i26uacg5 Query : select 'normal' from dummy
20240729@182946.8391 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a7d8252066a7d18aa8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',80,100810,0,'2024-07-29',39,'euro',0,0,2024 ,?,?)
20240729@182946.8696 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.8699 tvsk8qnga50d9834s1i26uacg5 Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240729@182946.8721 tvsk8qnga50d9834s1i26uacg5 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.1833.00.2'
20240729@182946.9035 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9053 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.9080 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9095 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.9104 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182946.9117 tvsk8qnga50d9834s1i26uacg5 Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240729@182946.9135 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9151 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.9163 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d0118266a7d18adf','aut66a7d8252066a7d18aa8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.9167 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9182 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.9212 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d0118266a7d18adf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8252066a7d18aa8' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240729@182946.9491 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.9494 tvsk8qnga50d9834s1i26uacg5 Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240729@182946.9515 tvsk8qnga50d9834s1i26uacg5 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.1833.00.2'
20240729@182946.9528 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9546 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.9572 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9587 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.9596 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182946.9609 tvsk8qnga50d9834s1i26uacg5 Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240729@182946.9622 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9638 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182946.9650 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d0222466a7d18aea','aut66a7d8252066a7d18aa8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182946.9654 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182946.9668 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182946.9699 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d0222466a7d18aea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8252066a7d18aa8' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240729@182946.9977 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182946.9980 tvsk8qnga50d9834s1i26uacg5 Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240729@182947.0000 tvsk8qnga50d9834s1i26uacg5 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.1833.00.2'
20240729@182947.1300 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.2800 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.5300 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6700 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.7500 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.8600 tvsk8qnga50d9834s1i26uacg5 Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240729@182947.9900 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.1390 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.1520 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d2649966a7d18b02','aut66a7d8252066a7d18aa8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.1550 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.1690 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.1980 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d2649966a7d18b02',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8252066a7d18aa8' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20240729@182947.7910 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182947.1002 tvsk8qnga50d9834s1i26uacg5 Query : select st.usalote valor from st where st.ref = '324.1833.00.2'
20240729@182947.1613 tvsk8qnga50d9834s1i26uacg5 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.1833.00.2'
20240729@182947.1627 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.1644 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.1670 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.1684 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.1693 tvsk8qnga50d9834s1i26uacg5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.1705 tvsk8qnga50d9834s1i26uacg5 Query : select sestamp valor from se where ref ='324.1833.00.2' and lote = 'r2301257100a'
20240729@182947.1718 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.1733 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.1746 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d3496566a7d18b29','aut66a7d8252066a7d18aa8' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.1751 tvsk8qnga50d9834s1i26uacg5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.1765 tvsk8qnga50d9834s1i26uacg5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.1795 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d3496566a7d18b29',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8252066a7d18aa8' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240729@182947.2066 tvsk8qnga50d9834s1i26uacg5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a7d8252066a7d18aa8','2405047','wait',39,'adm09112754980.682000002')
20240729@182947.2142 tvsk8qnga50d9834s1i26uacg5 Query : use flama_phc
20240729@182947.2145 tvsk8qnga50d9834s1i26uacg5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240729@182947.2175 tvsk8qnga50d9834s1i26uacg5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1236';
20240729@182947.2199 tvsk8qnga50d9834s1i26uacg5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1236';
20240729@182947.2234 tvsk8qnga50d9834s1i26uacg5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1236';
20240729@182947.2255 tvsk8qnga50d9834s1i26uacg5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1236';
20240729@182947.2786 caistbio7gcss29l3of2cbhe8g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240729@182947.2797 caistbio7gcss29l3of2cbhe8g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240729@182947.2846 caistbio7gcss29l3of2cbhe8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1237';
20240729@182947.2896 caistbio7gcss29l3of2cbhe8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1237';
20240729@182947.2953 caistbio7gcss29l3of2cbhe8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1237';
20240729@182947.2977 caistbio7gcss29l3of2cbhe8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1237';
20240729@182947.3033 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.3035 caistbio7gcss29l3of2cbhe8g Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240729@182947.3104 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.3107 caistbio7gcss29l3of2cbhe8g Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240729@182947.3146 caistbio7gcss29l3of2cbhe8g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240729@182947.3338 caistbio7gcss29l3of2cbhe8g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405048 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240729@182947.3662 caistbio7gcss29l3of2cbhe8g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240729@182947.3684 caistbio7gcss29l3of2cbhe8g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405048 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240729@182947.3703 caistbio7gcss29l3of2cbhe8g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240729@182947.3726 caistbio7gcss29l3of2cbhe8g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405048 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240729@182947.3744 caistbio7gcss29l3of2cbhe8g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240729@182947.3766 caistbio7gcss29l3of2cbhe8g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405048 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240729@182947.3782 caistbio7gcss29l3of2cbhe8g Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1831.00.2'
20240729@182947.3803 caistbio7gcss29l3of2cbhe8g Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2050 and bo.obrano = 2405048 and bi.ref ='324.1831.00.2' and bi.lordem =1
20240729@182947.3822 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.3825 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240729@182947.3862 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.3865 caistbio7gcss29l3of2cbhe8g Query : select top 1 1 valor from td where td.ndoc = 39
20240729@182947.3898 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.3901 caistbio7gcss29l3of2cbhe8g 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')
20240729@182947.3930 caistbio7gcss29l3of2cbhe8g 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
20240729@182947.3969 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.3971 caistbio7gcss29l3of2cbhe8g Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240729@182947.4041 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.4045 caistbio7gcss29l3of2cbhe8g Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240729@182947.4075 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.4078 caistbio7gcss29l3of2cbhe8g Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240729@182947.4118 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.4121 caistbio7gcss29l3of2cbhe8g Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240729@182947.4168 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.4171 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from td where ndoc = 39
20240729@182947.4183 caistbio7gcss29l3of2cbhe8g Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240729@182947.4199 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.4215 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240729@182947.4235 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.4251 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240729@182947.4280 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.4294 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240729@182947.4306 caistbio7gcss29l3of2cbhe8g Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240729@182947.4377 caistbio7gcss29l3of2cbhe8g Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240729@182947.4391 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.4406 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240729@182947.4423 caistbio7gcss29l3of2cbhe8g Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240729@182947.4605 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.4621 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240729@182947.4654 caistbio7gcss29l3of2cbhe8g Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240729@182947.4666 caistbio7gcss29l3of2cbhe8g Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240729@182947.4679 caistbio7gcss29l3of2cbhe8g Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240729@182947.4691 caistbio7gcss29l3of2cbhe8g Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240729@182947.4703 caistbio7gcss29l3of2cbhe8g Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240729@182947.4714 caistbio7gcss29l3of2cbhe8g Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240729@182947.4725 caistbio7gcss29l3of2cbhe8g Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66a7d8656266a7d18b69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240729@182947.4980 caistbio7gcss29l3of2cbhe8g Query : select top 1 fno valor from wsftdata order by fno desc
20240729@182947.4995 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.5014 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240729@182947.5038 caistbio7gcss29l3of2cbhe8g Query : select 'normal' from dummy
20240729@182947.5053 caistbio7gcss29l3of2cbhe8g Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66a7d8656266a7d18b69',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',81,100810,0,'2024-07-29',39,'euro',0,0,2024 ,?,?)
20240729@182947.5363 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.5366 caistbio7gcss29l3of2cbhe8g Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240729@182947.5390 caistbio7gcss29l3of2cbhe8g 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.1831.00.2'
20240729@182947.5543 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.5560 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.5588 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.5604 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.5613 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.5625 caistbio7gcss29l3of2cbhe8g Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240729@182947.5639 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.5654 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.5665 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d2077066a7d18b89','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.5669 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.5689 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.5718 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d2077066a7d18b89',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240729@182947.5995 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6012 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.6038 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6053 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.6061 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.6074 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6089 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.6102 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d0064666a7d18b94','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.6106 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6122 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.6151 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d0064666a7d18b94',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,20000,?,?,?)
20240729@182947.6445 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.6448 caistbio7gcss29l3of2cbhe8g Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240729@182947.6469 caistbio7gcss29l3of2cbhe8g 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.1831.00.2'
20240729@182947.6487 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6502 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.6528 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6542 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.6551 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.6563 caistbio7gcss29l3of2cbhe8g Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240729@182947.6575 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6590 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.6601 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d1126366a7d18ba0','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.6605 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.6619 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.7808 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d1126366a7d18ba0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240729@182947.8090 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8131 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.8156 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8170 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.8178 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.8190 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8204 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.8215 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d1797966a7d18bc7','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.8219 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8232 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.8266 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d1797966a7d18bc7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,50000,?,?,?)
20240729@182947.8595 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.8598 caistbio7gcss29l3of2cbhe8g Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240729@182947.8616 caistbio7gcss29l3of2cbhe8g 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.1831.00.2'
20240729@182947.8635 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8653 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.8678 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8693 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.8702 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.8714 caistbio7gcss29l3of2cbhe8g Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240729@182947.8727 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8742 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.8760 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d2008666a7d18bd5','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.8764 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.8781 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.8809 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d2008666a7d18bd5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240729@182947.9261 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9279 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.9309 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9325 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.9336 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.9350 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9366 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.9380 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d2133766a7d18be4','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.9385 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9399 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.9428 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d2133766a7d18be4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,80000,?,?,?)
20240729@182947.9725 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182947.9729 caistbio7gcss29l3of2cbhe8g Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240729@182947.9749 caistbio7gcss29l3of2cbhe8g 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.1831.00.2'
20240729@182947.9763 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9779 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.9809 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9826 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.9835 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182947.9849 caistbio7gcss29l3of2cbhe8g Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240729@182947.9863 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9879 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182947.9893 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d4116166a7d18bf0','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182947.9897 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182947.9912 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182947.9947 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d4116166a7d18bf0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20240729@182948.2090 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.2290 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182948.2600 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.2770 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182948.2880 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182948.3020 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.3170 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182948.3300 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d7528066a7d18c07','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182948.3350 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.3500 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182948.3790 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d7528066a7d18c07',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,110000,?,?,?)
20240729@182948.6300 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182948.6330 caistbio7gcss29l3of2cbhe8g Query : select st.usalote valor from st where st.ref = '324.1831.00.2'
20240729@182948.6530 caistbio7gcss29l3of2cbhe8g 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.1831.00.2'
20240729@182948.6680 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.6840 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182948.7130 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.7280 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182948.7370 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182948.7500 caistbio7gcss29l3of2cbhe8g Query : select sestamp valor from se where ref ='324.1831.00.2' and lote = 'r2301271200a'
20240729@182948.7630 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.7780 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182948.7900 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d8284466a7d18c12','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182948.7950 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.8100 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182948.8430 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66a7d8284466a7d18c12',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20240729@182948.1110 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.1127 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182948.1158 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.1174 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182948.1186 caistbio7gcss29l3of2cbhe8g Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240729@182948.1201 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.1217 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240729@182948.1231 caistbio7gcss29l3of2cbhe8g Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66a7d9850266a7d18c1d','aut66a7d8656266a7d18b69' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240729@182948.1235 caistbio7gcss29l3of2cbhe8g Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240729@182948.1251 caistbio7gcss29l3of2cbhe8g Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240729@182948.1283 caistbio7gcss29l3of2cbhe8g Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66a7d9850266a7d18c1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66a7d8656266a7d18b69' ,0,0 ,2,23.00,140000,?,?,?)
20240729@182948.1542 caistbio7gcss29l3of2cbhe8g Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66a7d8656266a7d18b69','2405048','wait',39,'adm09112754980.682000002')
20240729@182948.1623 caistbio7gcss29l3of2cbhe8g Query : use flama_phc
20240729@182948.1627 caistbio7gcss29l3of2cbhe8g Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240729@182948.1659 caistbio7gcss29l3of2cbhe8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1237';
20240729@182948.1682 caistbio7gcss29l3of2cbhe8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1237';
20240729@182948.1740 caistbio7gcss29l3of2cbhe8g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1237';
20240729@182948.1761 caistbio7gcss29l3of2cbhe8g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1237';
20240729@182948.2429 2hsn3uluojmci3aek37bgedg3g Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240729@182948.2441 2hsn3uluojmci3aek37bgedg3g Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240729@182948.2490 2hsn3uluojmci3aek37bgedg3g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1238';
20240729@182948.2544 2hsn3uluojmci3aek37bgedg3g Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1238';
20240729@182948.2598 2hsn3uluojmci3aek37bgedg3g Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1238';
