20241227@192833.4030 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef89238676effe109','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.4070 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4210 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.4480 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef89238676effe109',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241227@192833.6640 9qsvfs405aocmh1ae01h6htc0k Query : use flama_phc
20241227@192833.6670 9qsvfs405aocmh1ae01h6htc0k Query : select st.usalote valor from st where st.ref = '324.2366.00.1'
20241227@192833.6860 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2366.00.1'
20241227@192833.7030 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.7170 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.7430 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.7580 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.7660 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.7770 9qsvfs405aocmh1ae01h6htc0k Query : select sestamp valor from se where ref ='324.2366.00.1' and lote = 'r2400498100a'
20241227@192833.7900 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.8040 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.8150 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef41033676effe113','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.8190 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.8330 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.8600 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef41033676effe113',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241227@192833.1081 9qsvfs405aocmh1ae01h6htc0k Query : use flama_phc
20241227@192833.1084 9qsvfs405aocmh1ae01h6htc0k Query : select st.usalote valor from st where st.ref = '324.1608.00.1'
20241227@192833.1104 9qsvfs405aocmh1ae01h6htc0k 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.1608.00.1'
20241227@192833.1118 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.1133 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.1157 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.1171 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.1180 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.1192 9qsvfs405aocmh1ae01h6htc0k Query : select sestamp valor from se where ref ='324.1608.00.1' and lote = 'r2400237100a'
20241227@192833.1204 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.1221 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.1232 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef20945676effe11d','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.1236 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.1264 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.1292 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef20945676effe11d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241227@192833.1513 9qsvfs405aocmh1ae01h6htc0k Query : use flama_phc
20241227@192833.1516 9qsvfs405aocmh1ae01h6htc0k Query : select st.usalote valor from st where st.ref = '324.1837.00.1'
20241227@192833.1536 9qsvfs405aocmh1ae01h6htc0k 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.1837.00.1'
20241227@192833.1859 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.1876 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.1902 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.1917 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.1926 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.1938 9qsvfs405aocmh1ae01h6htc0k Query : select sestamp valor from se where ref ='324.1837.00.1' and lote = 'r2301207300a'
20241227@192833.1951 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.1968 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.1982 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef76079676effe12f','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.1986 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.2000 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.2029 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef76079676effe12f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241227@192833.2266 9qsvfs405aocmh1ae01h6htc0k Query : use flama_phc
20241227@192833.2269 9qsvfs405aocmh1ae01h6htc0k Query : select st.usalote valor from st where st.ref = '324.1816.00.1'
20241227@192833.2288 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1816.00.1'
20241227@192833.2302 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.2318 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.2343 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.2357 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.2365 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.2377 9qsvfs405aocmh1ae01h6htc0k Query : select sestamp valor from se where ref ='324.1816.00.1' and lote = 'r2400284200a'
20241227@192833.2389 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.2403 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.2414 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef77038676effe13a','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.2419 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.2440 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.2474 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef77038676effe13a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,60000,?,?,?,?,?)
20241227@192833.2706 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.2721 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.2746 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.2760 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.2768 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.2859 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.3517 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.3895 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef66691676effe145','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.3900 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.3916 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.3944 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef66691676effe145',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,70000,?,?,?)
20241227@192833.4182 9qsvfs405aocmh1ae01h6htc0k Query : use flama_phc
20241227@192833.4185 9qsvfs405aocmh1ae01h6htc0k Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241227@192833.4204 9qsvfs405aocmh1ae01h6htc0k 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.1643.00.1'
20241227@192833.4217 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4235 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.4261 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4276 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.4433 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.4448 9qsvfs405aocmh1ae01h6htc0k Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241227@192833.4461 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4477 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.4489 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef40645676effe16c','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.4493 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4507 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.4535 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef40645676effe16c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,90000,?,?,?,?,?)
20241227@192833.4757 9qsvfs405aocmh1ae01h6htc0k Query : use flama_phc
20241227@192833.4760 9qsvfs405aocmh1ae01h6htc0k Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241227@192833.4779 9qsvfs405aocmh1ae01h6htc0k 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.1643.00.1'
20241227@192833.4792 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4808 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.4833 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4847 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.4857 9qsvfs405aocmh1ae01h6htc0k Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.4869 9qsvfs405aocmh1ae01h6htc0k Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241227@192833.4882 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4896 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.4907 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef21614676effe177','aut676ef99717676effe0bc' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.4911 9qsvfs405aocmh1ae01h6htc0k Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.4926 9qsvfs405aocmh1ae01h6htc0k Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.4953 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef21614676effe177',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut676ef99717676effe0bc' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241227@192833.5409 9qsvfs405aocmh1ae01h6htc0k Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676ef99717676effe0bc','2408867','wait',39,'adm09112754980.682000002')
20241227@192833.5486 9qsvfs405aocmh1ae01h6htc0k Query : use flama_phc
20241227@192833.5489 9qsvfs405aocmh1ae01h6htc0k Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241227@192833.5520 9qsvfs405aocmh1ae01h6htc0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4201';
20241227@192833.5559 9qsvfs405aocmh1ae01h6htc0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4201';
20241227@192833.5609 9qsvfs405aocmh1ae01h6htc0k Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4201';
20241227@192833.5643 9qsvfs405aocmh1ae01h6htc0k Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4201';
20241227@192833.6185 mdgruq7489hqkt9nu8cr10masp Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241227@192833.6196 mdgruq7489hqkt9nu8cr10masp Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241227@192833.6266 mdgruq7489hqkt9nu8cr10masp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4202';
20241227@192833.6328 mdgruq7489hqkt9nu8cr10masp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4202';
20241227@192833.6392 mdgruq7489hqkt9nu8cr10masp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4202';
20241227@192833.6423 mdgruq7489hqkt9nu8cr10masp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4202';
20241227@192833.6481 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.6485 mdgruq7489hqkt9nu8cr10masp Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241227@192833.6556 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.6559 mdgruq7489hqkt9nu8cr10masp Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241227@192833.6605 mdgruq7489hqkt9nu8cr10masp Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9335.00.1'
20241227@192833.6630 mdgruq7489hqkt9nu8cr10masp Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408872 and bi.ref ='328.9335.00.1' and bi.lordem =1
20241227@192833.6929 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.6933 mdgruq7489hqkt9nu8cr10masp Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241227@192833.6968 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.6971 mdgruq7489hqkt9nu8cr10masp Query : select top 1 1 valor from td where td.ndoc = 39
20241227@192833.7001 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.7004 mdgruq7489hqkt9nu8cr10masp 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')
20241227@192833.7032 mdgruq7489hqkt9nu8cr10masp 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
20241227@192833.7067 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.7070 mdgruq7489hqkt9nu8cr10masp Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241227@192833.7103 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.7106 mdgruq7489hqkt9nu8cr10masp Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241227@192833.7139 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.7142 mdgruq7489hqkt9nu8cr10masp Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241227@192833.7181 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.7183 mdgruq7489hqkt9nu8cr10masp Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241227@192833.7229 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.7232 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from td where ndoc = 39
20241227@192833.7245 mdgruq7489hqkt9nu8cr10masp Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241227@192833.7259 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.7276 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192833.7297 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.7314 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192833.7345 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.7359 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192833.7372 mdgruq7489hqkt9nu8cr10masp Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192833.7427 mdgruq7489hqkt9nu8cr10masp Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192833.7441 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.7461 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192833.7476 mdgruq7489hqkt9nu8cr10masp Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676ef86030676effe1b4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241227@192833.7632 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.7648 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192833.7683 mdgruq7489hqkt9nu8cr10masp Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241227@192833.7700 mdgruq7489hqkt9nu8cr10masp Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241227@192833.7716 mdgruq7489hqkt9nu8cr10masp Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241227@192833.7728 mdgruq7489hqkt9nu8cr10masp Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241227@192833.7740 mdgruq7489hqkt9nu8cr10masp Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241227@192833.7753 mdgruq7489hqkt9nu8cr10masp Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241227@192833.7764 mdgruq7489hqkt9nu8cr10masp Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676ef86030676effe1b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241227@192833.7974 mdgruq7489hqkt9nu8cr10masp Query : select top 1 fno valor from wsftdata order by fno desc
20241227@192833.8002 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.8018 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192833.8041 mdgruq7489hqkt9nu8cr10masp Query : select 'normal' from dummy
20241227@192833.8060 mdgruq7489hqkt9nu8cr10masp Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676ef86030676effe1b4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2646,100810,0,'2024-12-27',39,'euro',0,0,2024 ,?,?)
20241227@192833.8318 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192833.8321 mdgruq7489hqkt9nu8cr10masp Query : select st.usalote valor from st where st.ref = '328.9335.00.1'
20241227@192833.9360 mdgruq7489hqkt9nu8cr10masp Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9335.00.1'
20241227@192833.9469 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9487 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.9512 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9527 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.9536 mdgruq7489hqkt9nu8cr10masp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.9549 mdgruq7489hqkt9nu8cr10masp Query : select sestamp valor from se where ref ='328.9335.00.1' and lote = 'r2001448100a'
20241227@192833.9561 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9577 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.9589 mdgruq7489hqkt9nu8cr10masp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef10324676effe1e9','aut676ef86030676effe1b4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.9594 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9608 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.9638 mdgruq7489hqkt9nu8cr10masp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef10324676effe1e9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef86030676effe1b4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241227@192833.9866 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9882 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192833.9907 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9924 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.9932 mdgruq7489hqkt9nu8cr10masp Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192833.9945 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9962 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192833.9974 mdgruq7489hqkt9nu8cr10masp Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef48998676effe1f2','aut676ef86030676effe1b4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192833.9978 mdgruq7489hqkt9nu8cr10masp Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192833.9993 mdgruq7489hqkt9nu8cr10masp Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.3000 mdgruq7489hqkt9nu8cr10masp Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef48998676effe1f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef86030676effe1b4' ,0,0 ,2,23.00,20000,?,?,?)
20241227@192834.2490 mdgruq7489hqkt9nu8cr10masp Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676ef86030676effe1b4','2408872','wait',39,'adm09112754980.682000002')
20241227@192834.3220 mdgruq7489hqkt9nu8cr10masp Query : use flama_phc
20241227@192834.3250 mdgruq7489hqkt9nu8cr10masp Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241227@192834.3590 mdgruq7489hqkt9nu8cr10masp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4202';
20241227@192834.4000 mdgruq7489hqkt9nu8cr10masp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4202';
20241227@192834.4510 mdgruq7489hqkt9nu8cr10masp Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4202';
20241227@192834.4830 mdgruq7489hqkt9nu8cr10masp Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4202';
20241227@192834.9850 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241227@192834.9970 v48maevhgh5oo7gpcmtihh8dh7 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241227@192834.1066 v48maevhgh5oo7gpcmtihh8dh7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4203';
20241227@192834.1130 v48maevhgh5oo7gpcmtihh8dh7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4203';
20241227@192834.1191 v48maevhgh5oo7gpcmtihh8dh7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4203';
20241227@192834.1223 v48maevhgh5oo7gpcmtihh8dh7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4203';
20241227@192834.1277 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.1281 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241227@192834.1351 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.1354 v48maevhgh5oo7gpcmtihh8dh7 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241227@192834.1399 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1685.00.1'
20241227@192834.1419 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408874 and bi.ref ='324.1685.00.1' and bi.lordem =1
20241227@192834.1722 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1676.00.1'
20241227@192834.1838 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408874 and bi.ref ='324.1676.00.1' and bi.lordem =2
20241227@192834.2129 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1837.00.1'
20241227@192834.2150 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408874 and bi.ref ='324.1837.00.1' and bi.lordem =3
20241227@192834.2444 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20241227@192834.2466 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408874 and bi.ref ='324.1643.00.1' and bi.lordem =4
20241227@192834.2937 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.2956 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241227@192834.3050 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.3054 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 1 valor from td where td.ndoc = 39
20241227@192834.3083 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.3086 v48maevhgh5oo7gpcmtihh8dh7 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')
20241227@192834.3113 v48maevhgh5oo7gpcmtihh8dh7 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
20241227@192834.3148 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.3152 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241227@192834.3191 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.3194 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241227@192834.3428 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.3479 v48maevhgh5oo7gpcmtihh8dh7 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241227@192834.3629 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.3633 v48maevhgh5oo7gpcmtihh8dh7 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241227@192834.3713 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.3717 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from td where ndoc = 39
20241227@192834.3729 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241227@192834.3743 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.3760 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192834.3780 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.3796 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192834.3823 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.3837 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192834.3850 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192834.3904 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192834.3917 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.3932 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192834.3948 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676ef40030676effe25e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241227@192834.4109 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.4125 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192834.4158 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241227@192834.4173 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241227@192834.4185 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241227@192834.4198 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241227@192834.4209 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241227@192834.4221 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241227@192834.4233 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676ef40030676effe25e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241227@192834.4447 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 fno valor from wsftdata order by fno desc
20241227@192834.4625 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.4642 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192834.4664 v48maevhgh5oo7gpcmtihh8dh7 Query : select 'normal' from dummy
20241227@192834.4684 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676ef40030676effe25e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2647,100810,0,'2024-12-27',39,'euro',0,0,2024 ,?,?)
20241227@192834.4960 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.4963 v48maevhgh5oo7gpcmtihh8dh7 Query : select st.usalote valor from st where st.ref = '324.1685.00.1'
20241227@192834.4985 v48maevhgh5oo7gpcmtihh8dh7 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.1685.00.1'
20241227@192834.4999 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5016 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.5043 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5058 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.5067 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192834.5084 v48maevhgh5oo7gpcmtihh8dh7 Query : select sestamp valor from se where ref ='324.1685.00.1' and lote = 'r2400173100a'
20241227@192834.5097 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5113 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.5125 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef71290676effe27c','aut676ef40030676effe25e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192834.5130 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5145 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.5174 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef71290676effe27c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef40030676effe25e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241227@192834.5415 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.5421 v48maevhgh5oo7gpcmtihh8dh7 Query : select st.usalote valor from st where st.ref = '324.1676.00.1'
20241227@192834.5442 v48maevhgh5oo7gpcmtihh8dh7 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.1676.00.1'
20241227@192834.5597 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5638 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.5664 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5680 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.5689 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192834.5702 v48maevhgh5oo7gpcmtihh8dh7 Query : select sestamp valor from se where ref ='324.1676.00.1' and lote = 'r2400173900a'
20241227@192834.5717 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5733 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.5745 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef33289676effe28b','aut676ef40030676effe25e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192834.5749 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.5765 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.5801 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef33289676effe28b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef40030676effe25e' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241227@192834.6039 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.6043 v48maevhgh5oo7gpcmtihh8dh7 Query : select st.usalote valor from st where st.ref = '324.1837.00.1'
20241227@192834.6063 v48maevhgh5oo7gpcmtihh8dh7 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.1837.00.1'
20241227@192834.6078 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.6095 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.6408 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.6429 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.6439 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192834.6454 v48maevhgh5oo7gpcmtihh8dh7 Query : select sestamp valor from se where ref ='324.1837.00.1' and lote = 'r2301207300a'
20241227@192834.6467 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.6482 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.6494 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef03298676effe29d','aut676ef40030676effe25e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192834.6498 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.6512 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.6550 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef03298676effe29d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut676ef40030676effe25e' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241227@192834.6777 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.6780 v48maevhgh5oo7gpcmtihh8dh7 Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20241227@192834.6800 v48maevhgh5oo7gpcmtihh8dh7 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.1643.00.1'
20241227@192834.6814 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.6830 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.6859 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.6875 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.6884 v48maevhgh5oo7gpcmtihh8dh7 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192834.7016 v48maevhgh5oo7gpcmtihh8dh7 Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20241227@192834.7119 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.7136 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192834.7147 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef98159676effe2ad','aut676ef40030676effe25e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192834.7152 v48maevhgh5oo7gpcmtihh8dh7 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.7166 v48maevhgh5oo7gpcmtihh8dh7 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192834.7196 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef98159676effe2ad',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef40030676effe25e' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241227@192834.7432 v48maevhgh5oo7gpcmtihh8dh7 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676ef40030676effe25e','2408874','wait',39,'adm09112754980.682000002')
20241227@192834.7504 v48maevhgh5oo7gpcmtihh8dh7 Query : use flama_phc
20241227@192834.7508 v48maevhgh5oo7gpcmtihh8dh7 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241227@192834.7538 v48maevhgh5oo7gpcmtihh8dh7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4203';
20241227@192834.7579 v48maevhgh5oo7gpcmtihh8dh7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4203';
20241227@192834.7630 v48maevhgh5oo7gpcmtihh8dh7 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4203';
20241227@192834.7664 v48maevhgh5oo7gpcmtihh8dh7 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4203';
20241227@192834.8187 do29psk73s295n14r2t52a38hj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241227@192834.8200 do29psk73s295n14r2t52a38hj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241227@192834.8268 do29psk73s295n14r2t52a38hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4204';
20241227@192834.8327 do29psk73s295n14r2t52a38hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4204';
20241227@192834.8390 do29psk73s295n14r2t52a38hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4204';
20241227@192834.8421 do29psk73s295n14r2t52a38hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4204';
20241227@192834.8476 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.8479 do29psk73s295n14r2t52a38hj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241227@192834.8540 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.8545 do29psk73s295n14r2t52a38hj Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241227@192834.8591 do29psk73s295n14r2t52a38hj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9005.00.1'
20241227@192834.8611 do29psk73s295n14r2t52a38hj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408876 and bi.ref ='328.9005.00.1' and bi.lordem =1
20241227@192834.8919 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.8922 do29psk73s295n14r2t52a38hj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241227@192834.8957 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.8961 do29psk73s295n14r2t52a38hj Query : select top 1 1 valor from td where td.ndoc = 39
20241227@192834.8992 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.8994 do29psk73s295n14r2t52a38hj 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')
20241227@192834.9023 do29psk73s295n14r2t52a38hj 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
20241227@192834.9059 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.9062 do29psk73s295n14r2t52a38hj Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241227@192834.9093 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.9096 do29psk73s295n14r2t52a38hj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241227@192834.9129 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.9132 do29psk73s295n14r2t52a38hj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241227@192834.9172 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.9175 do29psk73s295n14r2t52a38hj Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241227@192834.9221 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192834.9224 do29psk73s295n14r2t52a38hj Query : select 1 valor from td where ndoc = 39
20241227@192834.9236 do29psk73s295n14r2t52a38hj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241227@192834.9249 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.9265 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192834.9284 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.9299 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192834.9326 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.9344 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192834.9355 do29psk73s295n14r2t52a38hj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192834.9412 do29psk73s295n14r2t52a38hj Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192834.9424 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.9439 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192834.9455 do29psk73s295n14r2t52a38hj Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676ef11505676effe2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241227@192834.9618 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192834.9634 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192834.9665 do29psk73s295n14r2t52a38hj Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241227@192834.9678 do29psk73s295n14r2t52a38hj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241227@192834.9690 do29psk73s295n14r2t52a38hj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241227@192834.9702 do29psk73s295n14r2t52a38hj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241227@192834.9716 do29psk73s295n14r2t52a38hj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241227@192834.9729 do29psk73s295n14r2t52a38hj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241227@192834.9741 do29psk73s295n14r2t52a38hj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676ef11505676effe2e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241227@192834.9969 do29psk73s295n14r2t52a38hj Query : select top 1 fno valor from wsftdata order by fno desc
20241227@192834.9999 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.1700 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192835.4000 do29psk73s295n14r2t52a38hj Query : select 'normal' from dummy
20241227@192835.5500 do29psk73s295n14r2t52a38hj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676ef11505676effe2e4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2648,100810,0,'2024-12-27',39,'euro',0,0,2024 ,?,?)
20241227@192835.4520 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192835.4870 do29psk73s295n14r2t52a38hj Query : select st.usalote valor from st where st.ref = '328.9005.00.1'
20241227@192835.6130 do29psk73s295n14r2t52a38hj Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9005.00.1'
20241227@192835.6280 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6440 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.6690 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6840 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.6920 do29psk73s295n14r2t52a38hj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192835.7040 do29psk73s295n14r2t52a38hj Query : select sestamp valor from se where ref ='328.9005.00.1' and lote = 'r2400092600a'
20241227@192835.7160 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.7300 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.7420 do29psk73s295n14r2t52a38hj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef31183676effe311','aut676ef11505676effe2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192835.7460 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.7600 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.1077 do29psk73s295n14r2t52a38hj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef31183676effe311',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef11505676effe2e4' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241227@192835.1373 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.1391 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.1417 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.1432 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.1441 do29psk73s295n14r2t52a38hj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192835.1453 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.1467 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.1479 do29psk73s295n14r2t52a38hj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef53431676effe323','aut676ef11505676effe2e4' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192835.1483 do29psk73s295n14r2t52a38hj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.1499 do29psk73s295n14r2t52a38hj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.1527 do29psk73s295n14r2t52a38hj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef53431676effe323',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef11505676effe2e4' ,0,0 ,2,23.00,20000,?,?,?)
20241227@192835.1757 do29psk73s295n14r2t52a38hj Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676ef11505676effe2e4','2408876','wait',39,'adm09112754980.682000002')
20241227@192835.1836 do29psk73s295n14r2t52a38hj Query : use flama_phc
20241227@192835.1839 do29psk73s295n14r2t52a38hj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241227@192835.1872 do29psk73s295n14r2t52a38hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4204';
20241227@192835.1913 do29psk73s295n14r2t52a38hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4204';
20241227@192835.1967 do29psk73s295n14r2t52a38hj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4204';
20241227@192835.2000 do29psk73s295n14r2t52a38hj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4204';
20241227@192835.3337 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241227@192835.3354 2m9eb2rr8gp5s8uvkhochjqqjf Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241227@192835.3435 2m9eb2rr8gp5s8uvkhochjqqjf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4205';
20241227@192835.3495 2m9eb2rr8gp5s8uvkhochjqqjf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4205';
20241227@192835.3555 2m9eb2rr8gp5s8uvkhochjqqjf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4205';
20241227@192835.3587 2m9eb2rr8gp5s8uvkhochjqqjf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4205';
20241227@192835.3640 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.3643 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241227@192835.3703 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.3708 2m9eb2rr8gp5s8uvkhochjqqjf Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241227@192835.3751 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1667.00.1'
20241227@192835.3770 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408877 and bi.ref ='324.1667.00.1' and bi.lordem =1
20241227@192835.4080 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4083 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241227@192835.4116 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4118 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 1 valor from td where td.ndoc = 39
20241227@192835.4148 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4151 2m9eb2rr8gp5s8uvkhochjqqjf 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')
20241227@192835.4178 2m9eb2rr8gp5s8uvkhochjqqjf 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
20241227@192835.4212 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4215 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241227@192835.4245 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4248 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241227@192835.4278 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4280 2m9eb2rr8gp5s8uvkhochjqqjf Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241227@192835.4320 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4323 2m9eb2rr8gp5s8uvkhochjqqjf Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241227@192835.4370 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.4373 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from td where ndoc = 39
20241227@192835.4387 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241227@192835.4401 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.4417 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192835.4437 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.4452 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192835.4481 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.4496 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192835.4509 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192835.4563 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192835.4577 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.4593 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192835.4608 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676ef43178676effe36e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241227@192835.4892 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.4947 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192835.4982 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241227@192835.4994 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241227@192835.5006 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241227@192835.5017 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241227@192835.5029 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241227@192835.5041 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241227@192835.5053 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676ef43178676effe36e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241227@192835.5280 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 fno valor from wsftdata order by fno desc
20241227@192835.5310 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.5328 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192835.5350 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 'normal' from dummy
20241227@192835.5364 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676ef43178676effe36e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2649,100810,0,'2024-12-27',39,'euro',0,0,2024 ,?,?)
20241227@192835.5804 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.5836 2m9eb2rr8gp5s8uvkhochjqqjf Query : select st.usalote valor from st where st.ref = '324.1667.00.1'
20241227@192835.5861 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1667.00.1'
20241227@192835.5876 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.5892 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.5919 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.5935 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.5968 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192835.5981 2m9eb2rr8gp5s8uvkhochjqqjf Query : select sestamp valor from se where ref ='324.1667.00.1' and lote = 'r2400923100a'
20241227@192835.5994 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6011 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.6025 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef49131676effe392','aut676ef43178676effe36e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192835.6029 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6045 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.6075 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef49131676effe392',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef43178676effe36e' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241227@192835.6328 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6345 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.6372 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6388 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.6397 2m9eb2rr8gp5s8uvkhochjqqjf Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192835.6410 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6425 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192835.6436 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef58923676effe39c','aut676ef43178676effe36e' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192835.6441 2m9eb2rr8gp5s8uvkhochjqqjf Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.6455 2m9eb2rr8gp5s8uvkhochjqqjf Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192835.6483 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef58923676effe39c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef43178676effe36e' ,0,0 ,2,23.00,20000,?,?,?)
20241227@192835.6716 2m9eb2rr8gp5s8uvkhochjqqjf Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676ef43178676effe36e','2408877','wait',39,'adm09112754980.682000002')
20241227@192835.6785 2m9eb2rr8gp5s8uvkhochjqqjf Query : use flama_phc
20241227@192835.6788 2m9eb2rr8gp5s8uvkhochjqqjf Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241227@192835.6816 2m9eb2rr8gp5s8uvkhochjqqjf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4205';
20241227@192835.6858 2m9eb2rr8gp5s8uvkhochjqqjf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4205';
20241227@192835.6910 2m9eb2rr8gp5s8uvkhochjqqjf Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4205';
20241227@192835.6952 2m9eb2rr8gp5s8uvkhochjqqjf Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4205';
20241227@192835.7548 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241227@192835.7569 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241227@192835.7675 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4206';
20241227@192835.7774 ta3m28b6p2g9gh7dt7ts0u6dpg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4206';
20241227@192835.7885 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4206';
20241227@192835.7936 ta3m28b6p2g9gh7dt7ts0u6dpg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4206';
20241227@192835.8033 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8036 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241227@192835.8108 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8111 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241227@192835.8158 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8253.00.1'
20241227@192835.8308 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408878 and bi.ref ='327.8253.00.1' and bi.lordem =1
20241227@192835.8621 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8624 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241227@192835.8658 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8661 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 1 valor from td where td.ndoc = 39
20241227@192835.8692 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8695 ta3m28b6p2g9gh7dt7ts0u6dpg 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')
20241227@192835.8725 ta3m28b6p2g9gh7dt7ts0u6dpg 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
20241227@192835.8761 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8764 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241227@192835.8794 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8797 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241227@192835.8826 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8829 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241227@192835.8867 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8870 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241227@192835.8915 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192835.8918 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from td where ndoc = 39
20241227@192835.8930 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241227@192835.8944 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.8961 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192835.8981 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.8995 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192835.9025 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.9040 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192835.9053 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192835.9108 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192835.9122 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.9138 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192835.9154 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676ef50497676effe3dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241227@192835.9319 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.9336 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192835.9368 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241227@192835.9381 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241227@192835.9392 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241227@192835.9404 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241227@192835.9416 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241227@192835.9428 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241227@192835.9440 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676ef50497676effe3dd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241227@192835.9662 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 fno valor from wsftdata order by fno desc
20241227@192835.9695 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192835.9713 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192835.9735 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 'normal' from dummy
20241227@192835.9752 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676ef50497676effe3dd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2650,100810,0,'2024-12-27',39,'euro',0,0,2024 ,?,?)
20241227@192836.3400 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192836.3800 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select st.usalote valor from st where st.ref = '327.8253.00.1'
20241227@192836.6100 ta3m28b6p2g9gh7dt7ts0u6dpg 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 = '327.8253.00.1'
20241227@192836.2700 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.2870 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.3130 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.3280 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.3370 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.3490 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select sestamp valor from se where ref ='327.8253.00.1' and lote = 'r2400073100b'
20241227@192836.3640 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.3790 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.3910 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef82815676effe408','aut676ef50497676effe3dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.3950 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.4100 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.4390 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef82815676effe408',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef50497676effe3dd' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241227@192836.6850 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7020 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.7280 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7420 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.7510 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.7640 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7780 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.7900 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef34074676effe412','aut676ef50497676effe3dd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.7950 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8090 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.8380 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef34074676effe412',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef50497676effe3dd' ,0,0 ,2,23.00,20000,?,?,?)
20241227@192836.1075 ta3m28b6p2g9gh7dt7ts0u6dpg Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676ef50497676effe3dd','2408878','wait',39,'adm09112754980.682000002')
20241227@192836.1173 ta3m28b6p2g9gh7dt7ts0u6dpg Query : use flama_phc
20241227@192836.1176 ta3m28b6p2g9gh7dt7ts0u6dpg Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241227@192836.1205 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4206';
20241227@192836.1251 ta3m28b6p2g9gh7dt7ts0u6dpg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4206';
20241227@192836.1302 ta3m28b6p2g9gh7dt7ts0u6dpg Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4206';
20241227@192836.1334 ta3m28b6p2g9gh7dt7ts0u6dpg Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4206';
20241227@192836.1857 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241227@192836.1868 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241227@192836.1938 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4207';
20241227@192836.2004 c30smbvaf3fqhr8l9n6e6c6lt3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4207';
20241227@192836.2069 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4207';
20241227@192836.2100 c30smbvaf3fqhr8l9n6e6c6lt3 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='4207';
20241227@192836.2156 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.2159 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241227@192836.2224 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.2227 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select no, estab,szadrsdesc from szadrs where u_coddest=9159
20241227@192836.2281 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20241227@192836.2422 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408880 and bi.ref ='327.8261.00.1' and bi.lordem =1
20241227@192836.2790 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20241227@192836.2933 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408880 and bi.ref ='327.8261.00.1' and bi.lordem =1
20241227@192836.3012 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20241227@192836.3035 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408880 and bi.ref ='327.8261.00.1' and bi.lordem =1
20241227@192836.3054 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8261.00.1'
20241227@192836.3076 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2088 and bo.obrano = 2408880 and bi.ref ='327.8261.00.1' and bi.lordem =1
20241227@192836.3094 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3098 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241227@192836.3131 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3135 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 1 valor from td where td.ndoc = 39
20241227@192836.3166 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3169 c30smbvaf3fqhr8l9n6e6c6lt3 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')
20241227@192836.3198 c30smbvaf3fqhr8l9n6e6c6lt3 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
20241227@192836.3235 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3238 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 ~inactivo valor from cl where no = '102943' and estab = 0 order by inactivo desc
20241227@192836.3296 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3299 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241227@192836.3329 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3332 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241227@192836.3373 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3376 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select szadrsstamp valor from szadrs where szadrsdesc='pll-plataformalogistica lisboa norte'
20241227@192836.3421 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.3424 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from td where ndoc = 39
20241227@192836.3437 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241227@192836.3452 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.3470 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192836.3491 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.3506 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192836.3535 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.3550 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192836.3564 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192836.3619 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241227@192836.3634 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.3650 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241227@192836.3666 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241227@192836.3829 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.3846 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241227@192836.3880 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241227@192836.3893 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241227@192836.3906 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241227@192836.3919 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241227@192836.3933 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241227@192836.3946 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241227@192836.3959 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut676ef71611676effe457',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241227@192836.4224 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 fno valor from wsftdata order by fno desc
20241227@192836.4936 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.5351 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241227@192836.5373 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 'normal' from dummy
20241227@192836.5388 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut676ef71611676effe457',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2651,102943,0,'2024-12-27',39,'euro',0,0,2024 ,?,?)
20241227@192836.5693 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.5696 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20241227@192836.5719 c30smbvaf3fqhr8l9n6e6c6lt3 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 = '327.8261.00.1'
20241227@192836.5850 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.5866 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.5892 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.5908 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.5917 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.5936 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2401098200a'
20241227@192836.5950 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.5964 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.5976 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef51114676effe491','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.5980 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.5994 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.6022 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef51114676effe491',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241227@192836.6269 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6285 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.6312 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6326 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.6335 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.6347 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6363 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.6375 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef74715676effe49a','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.6379 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6393 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.6422 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef74715676effe49a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,20000,?,?,?)
20241227@192836.6776 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.6779 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20241227@192836.6805 c30smbvaf3fqhr8l9n6e6c6lt3 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 = '327.8261.00.1'
20241227@192836.6819 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6836 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.6861 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6876 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.6884 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.6896 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2401098200a'
20241227@192836.6908 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6923 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.6935 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef58048676effe4a8','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.6940 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.6954 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.6986 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef58048676effe4a8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241227@192836.7252 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7268 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.7295 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7309 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.7318 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.7331 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7345 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.7357 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef15398676effe4b2','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.7361 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7376 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.7404 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef15398676effe4b2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,50000,?,?,?)
20241227@192836.7641 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.7644 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20241227@192836.7664 c30smbvaf3fqhr8l9n6e6c6lt3 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 = '327.8261.00.1'
20241227@192836.7678 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7695 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.7721 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7736 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.7744 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.7756 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2401098200a'
20241227@192836.7768 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7783 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.7795 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef05520676effe4bd','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.7800 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.7815 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.7846 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef05520676effe4bd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241227@192836.8092 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8109 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.8141 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8156 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.8165 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.8178 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8192 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.8204 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef75368676effe4c7','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.8208 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8223 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.8253 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef75368676effe4c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,80000,?,?,?)
20241227@192836.8488 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.8491 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select st.usalote valor from st where st.ref = '327.8261.00.1'
20241227@192836.8510 c30smbvaf3fqhr8l9n6e6c6lt3 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 = '327.8261.00.1'
20241227@192836.8530 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8546 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.8571 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8586 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.8594 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.8606 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select sestamp valor from se where ref ='327.8261.00.1' and lote = 'r2401098200a'
20241227@192836.8619 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8636 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.8647 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef95954676effe4d2','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.8652 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8667 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.8695 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut676ef95954676effe4d2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241227@192836.8934 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8952 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.8979 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.8993 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.9001 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241227@192836.9014 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.9029 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241227@192836.9041 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut676ef05485676effe4dc','aut676ef71611676effe457' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241227@192836.9046 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241227@192836.9060 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241227@192836.9089 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut676ef05485676effe4dc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut676ef71611676effe457' ,0,0 ,2,23.00,110000,?,?,?)
20241227@192836.9332 c30smbvaf3fqhr8l9n6e6c6lt3 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut676ef71611676effe457','2408880','wait',39,'adm09112754980.682000002')
20241227@192836.9401 c30smbvaf3fqhr8l9n6e6c6lt3 Query : use flama_phc
20241227@192836.9404 c30smbvaf3fqhr8l9n6e6c6lt3 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241227@192836.9436 c30smbvaf3fqhr8l9n6e6c6lt3 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='4207';
