20241022@174424.2370 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2520 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.2820 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d081296717d66805',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,400000,?,?,?,?,?)
20241022@174424.5490 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5660 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.5910 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6050 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6140 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.6280 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6430 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6610 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d435246717d6680f','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.6660 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6810 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.7100 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d435246717d6680f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,410000,?,?,?)
20241022@174424.9600 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.9650 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.9860 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.9990 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1017 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.1041 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1056 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.1064 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.1076 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.1089 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1104 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.1123 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d245866717d6681a','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.1127 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1142 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.1169 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d245866717d6681a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,430000,?,?,?,?,?)
20241022@174424.1419 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1437 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.1461 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1475 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.1489 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.1500 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1514 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.1525 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d432126717d66824','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.1529 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.1544 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.1571 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d432126717d66824',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,440000,?,?,?)
20241022@174424.1960 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.1963 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.1984 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.1997 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2014 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.2041 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2056 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.2065 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.2079 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.2097 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2112 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.2125 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d140786717d66833','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.2129 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2144 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.2173 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d140786717d66833',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,460000,?,?,?,?,?)
20241022@174424.2420 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2437 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.2477 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2491 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.2500 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.2513 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2528 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.2541 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d388276717d6683d','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.2546 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2567 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.2595 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d388276717d6683d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,470000,?,?,?)
20241022@174424.2838 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.2842 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.2862 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.2878 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2893 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.2933 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2948 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.2956 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.2967 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.2979 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.2993 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.3004 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d652716717d66848','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.3009 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3022 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.3056 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d652716717d66848',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,490000,?,?,?,?,?)
20241022@174424.3317 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3333 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.3358 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3372 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.3380 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.3392 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3405 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.3416 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d597806717d66852','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.3420 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3440 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.3468 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d597806717d66852',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,500000,?,?,?)
20241022@174424.3713 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.3715 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.3734 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.3747 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3762 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.3788 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3804 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.3811 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.3822 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.3839 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3854 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.3866 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d198326717d6685d','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.3870 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.3884 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.3914 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d198326717d6685d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,520000,?,?,?,?,?)
20241022@174424.4167 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4183 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.4208 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4222 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.4231 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.4243 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4261 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.4272 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d618686717d66867','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.4276 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4290 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.4315 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d618686717d66867',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,530000,?,?,?)
20241022@174424.4557 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.4560 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.4579 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.4595 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4609 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.4632 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4645 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.4653 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.4664 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.4676 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4690 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.4701 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d810896717d66872','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.4705 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.4718 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.4744 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d810896717d66872',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,550000,?,?,?,?,?)
20241022@174424.5104 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5128 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.5154 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5169 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.5183 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.5195 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5211 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.5221 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d101926717d6687e','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.5226 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5239 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.5264 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d101926717d6687e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,560000,?,?,?)
20241022@174424.5552 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.5555 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.5575 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.5590 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5608 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.5633 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5648 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.5657 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.5669 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.5681 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5695 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.5706 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d685556717d6688a','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.5711 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.5725 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.5752 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d685556717d6688a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,580000,?,?,?,?,?)
20241022@174424.6032 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6049 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.6074 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6088 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6097 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.6109 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6123 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6135 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d014866717d66895','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.6139 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6159 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.6187 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d014866717d66895',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,590000,?,?,?)
20241022@174424.6425 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.6434 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.6456 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.6469 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6484 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.6508 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6521 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6529 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.6540 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.6557 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6571 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6582 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d769746717d668a0','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.6586 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6600 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.6627 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d769746717d668a0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,610000,?,?,?,?,?)
20241022@174424.6874 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6891 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.6916 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6929 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6938 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.6949 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6963 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.6973 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d576266717d668a9','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.6977 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.6991 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.7037 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d576266717d668a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,620000,?,?,?)
20241022@174424.7285 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.7289 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.7308 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.7321 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7343 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.7369 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7383 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.7391 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.7403 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.7415 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7429 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.7440 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d484036717d668b5','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.7444 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7458 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.7492 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d484036717d668b5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,640000,?,?,?,?,?)
20241022@174424.7747 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7762 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.7789 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7804 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.7812 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.7823 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7842 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.7853 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d871106717d668bf','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.7857 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.7871 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.7897 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d871106717d668bf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,650000,?,?,?)
20241022@174424.8143 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174424.8147 04r3hcglsdmv5b9s010egciuge Query : select st.usalote valor from st where st.ref = '324.1847.00.1'
20241022@174424.8168 04r3hcglsdmv5b9s010egciuge Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1847.00.1'
20241022@174424.8202 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.8217 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.9045 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.9507 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.9515 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.9527 04r3hcglsdmv5b9s010egciuge Query : select sestamp valor from se where ref ='324.1847.00.1' and lote = 'r2400482200a'
20241022@174424.9539 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.9554 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.9565 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d177336717d668e8','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.9569 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.9583 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.9609 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d177336717d668e8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',10.000 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,670000,?,?,?,?,?)
20241022@174424.9859 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.9875 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174424.9901 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.9914 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.9922 04r3hcglsdmv5b9s010egciuge Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174424.9934 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.9948 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174424.9959 04r3hcglsdmv5b9s010egciuge Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d511166717d668f2','aut6717d071396717d66671' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174424.9963 04r3hcglsdmv5b9s010egciuge Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174424.9977 04r3hcglsdmv5b9s010egciuge Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174425.5000 04r3hcglsdmv5b9s010egciuge Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d511166717d668f2',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d071396717d66671' ,0,0 ,2,23.00,680000,?,?,?)
20241022@174425.2530 04r3hcglsdmv5b9s010egciuge Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6717d071396717d66671','2406893','wait',39,'adm09112754980.682000002')
20241022@174425.3430 04r3hcglsdmv5b9s010egciuge Query : use flama_phc
20241022@174425.3460 04r3hcglsdmv5b9s010egciuge Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241022@174425.3750 04r3hcglsdmv5b9s010egciuge Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2847';
20241022@174425.4070 04r3hcglsdmv5b9s010egciuge Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2847';
20241022@174425.4530 04r3hcglsdmv5b9s010egciuge Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2847';
20241022@174425.4810 04r3hcglsdmv5b9s010egciuge Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2847';
20241022@174425.1140 8kfcjn27v8g4oeloah5hgono63 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241022@174425.1152 8kfcjn27v8g4oeloah5hgono63 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241022@174425.1215 8kfcjn27v8g4oeloah5hgono63 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2848';
20241022@174425.1278 8kfcjn27v8g4oeloah5hgono63 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2848';
20241022@174425.1334 8kfcjn27v8g4oeloah5hgono63 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2848';
20241022@174425.1367 8kfcjn27v8g4oeloah5hgono63 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2848';
20241022@174425.1419 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.1422 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241022@174425.1489 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.1494 8kfcjn27v8g4oeloah5hgono63 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241022@174425.1541 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.1681 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.2130 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.2150 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.2166 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.2184 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.2200 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.2217 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.2232 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.2262 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.2280 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.4265 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.4289 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.4311 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.4329 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.4347 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.4362 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.4381 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.4396 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20241022@174425.4414 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2068 and bo.obrano = 2406895 and bi.ref ='324.1879.00.1' and bi.lordem =1
20241022@174425.4430 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4433 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241022@174425.4463 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4465 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 1 valor from td where td.ndoc = 39
20241022@174425.4496 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4499 8kfcjn27v8g4oeloah5hgono63 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')
20241022@174425.4539 8kfcjn27v8g4oeloah5hgono63 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
20241022@174425.4572 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4576 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241022@174425.4610 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4613 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241022@174425.4641 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4644 8kfcjn27v8g4oeloah5hgono63 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241022@174425.4686 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4689 8kfcjn27v8g4oeloah5hgono63 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241022@174425.4731 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.4734 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from td where ndoc = 39
20241022@174425.4745 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241022@174425.4757 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.4775 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174425.4794 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.4808 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174425.4835 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.4849 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174425.4861 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174425.4923 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174425.4936 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.4951 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174425.4965 8kfcjn27v8g4oeloah5hgono63 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6717d513366717d66976' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241022@174425.5129 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.5151 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174425.5185 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241022@174425.5197 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241022@174425.5209 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241022@174425.5220 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241022@174425.5231 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241022@174425.5242 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241022@174425.5254 8kfcjn27v8g4oeloah5hgono63 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6717d513366717d66976',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241022@174425.5485 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 fno valor from wsftdata order by fno desc
20241022@174425.5513 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.5528 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174425.5551 8kfcjn27v8g4oeloah5hgono63 Query : select 'normal' from dummy
20241022@174425.5565 8kfcjn27v8g4oeloah5hgono63 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6717d513366717d66976',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1437,100810,0,'2024-10-22',39,'euro',0,0,2024 ,?,?)
20241022@174425.5862 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.5865 8kfcjn27v8g4oeloah5hgono63 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20241022@174425.5888 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20241022@174425.6020 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.6035 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174425.6066 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.6083 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174425.6092 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174425.6104 8kfcjn27v8g4oeloah5hgono63 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2301097100b'
20241022@174425.6113 8kfcjn27v8g4oeloah5hgono63 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.6129 8kfcjn27v8g4oeloah5hgono63 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174425.6141 8kfcjn27v8g4oeloah5hgono63 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d320416717d66995','aut6717d513366717d66976' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174425.6157 8kfcjn27v8g4oeloah5hgono63 Query : use flama_phc
20241022@174425.6160 8kfcjn27v8g4oeloah5hgono63 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241022@174425.6189 8kfcjn27v8g4oeloah5hgono63 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2848';
20241022@174425.6220 8kfcjn27v8g4oeloah5hgono63 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2848';
20241022@174425.6791 h6nckott93k9onv7n1lb1s7tji Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241022@174425.6802 h6nckott93k9onv7n1lb1s7tji Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241022@174425.6862 h6nckott93k9onv7n1lb1s7tji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2849';
20241022@174425.6932 h6nckott93k9onv7n1lb1s7tji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2849';
20241022@174425.6991 h6nckott93k9onv7n1lb1s7tji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2849';
20241022@174425.7023 h6nckott93k9onv7n1lb1s7tji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2849';
20241022@174425.7073 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7077 h6nckott93k9onv7n1lb1s7tji Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241022@174425.7157 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7160 h6nckott93k9onv7n1lb1s7tji Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20241022@174425.7243 h6nckott93k9onv7n1lb1s7tji Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9326.00.1'
20241022@174425.7374 h6nckott93k9onv7n1lb1s7tji Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406912 and bi.ref ='328.9326.00.1' and bi.lordem =1
20241022@174425.7703 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7706 h6nckott93k9onv7n1lb1s7tji Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241022@174425.7738 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7742 h6nckott93k9onv7n1lb1s7tji Query : select top 1 1 valor from td where td.ndoc = 39
20241022@174425.7769 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7773 h6nckott93k9onv7n1lb1s7tji 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')
20241022@174425.7801 h6nckott93k9onv7n1lb1s7tji 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
20241022@174425.7835 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7838 h6nckott93k9onv7n1lb1s7tji Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241022@174425.7867 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7871 h6nckott93k9onv7n1lb1s7tji Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241022@174425.7899 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7902 h6nckott93k9onv7n1lb1s7tji Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241022@174425.7940 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7943 h6nckott93k9onv7n1lb1s7tji Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20241022@174425.7987 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174425.7989 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from td where ndoc = 39
20241022@174425.8002 h6nckott93k9onv7n1lb1s7tji Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241022@174425.8022 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.8038 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174425.8056 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.8071 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174425.8099 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.8113 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174425.8126 h6nckott93k9onv7n1lb1s7tji Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174425.8190 h6nckott93k9onv7n1lb1s7tji Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174425.8203 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.8217 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174425.8239 h6nckott93k9onv7n1lb1s7tji Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6717d371456717d669c6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241022@174425.8551 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174425.9021 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174425.9645 h6nckott93k9onv7n1lb1s7tji Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241022@174425.9657 h6nckott93k9onv7n1lb1s7tji Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241022@174425.9670 h6nckott93k9onv7n1lb1s7tji Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241022@174425.9682 h6nckott93k9onv7n1lb1s7tji Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241022@174425.9694 h6nckott93k9onv7n1lb1s7tji Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241022@174425.9706 h6nckott93k9onv7n1lb1s7tji Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241022@174425.9717 h6nckott93k9onv7n1lb1s7tji Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6717d371456717d669c6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241022@174425.9959 h6nckott93k9onv7n1lb1s7tji Query : select top 1 fno valor from wsftdata order by fno desc
20241022@174425.9985 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.5000 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174426.2700 h6nckott93k9onv7n1lb1s7tji Query : select 'normal' from dummy
20241022@174426.4100 h6nckott93k9onv7n1lb1s7tji Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6717d371456717d669c6',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1437,100810,0,'2024-10-22',39,'euro',0,0,2024 ,?,?)
20241022@174426.6740 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174426.6780 h6nckott93k9onv7n1lb1s7tji Query : select st.usalote valor from st where st.ref = '328.9326.00.1'
20241022@174426.7040 h6nckott93k9onv7n1lb1s7tji 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.9326.00.1'
20241022@174426.8790 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.8970 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.1013 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.1031 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.1039 h6nckott93k9onv7n1lb1s7tji Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174426.1052 h6nckott93k9onv7n1lb1s7tji Query : select sestamp valor from se where ref ='328.9326.00.1' and lote = 'r2300691100a'
20241022@174426.1072 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.1089 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.1100 h6nckott93k9onv7n1lb1s7tji Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d738716717d66a1a','aut6717d371456717d669c6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174426.1104 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.1118 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.1144 h6nckott93k9onv7n1lb1s7tji Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d738716717d66a1a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut6717d371456717d669c6' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241022@174426.1400 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.1416 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.1440 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.1454 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.1462 h6nckott93k9onv7n1lb1s7tji Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174426.1479 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.1493 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.1506 h6nckott93k9onv7n1lb1s7tji Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d823656717d66a24','aut6717d371456717d669c6' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174426.1510 h6nckott93k9onv7n1lb1s7tji Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.1524 h6nckott93k9onv7n1lb1s7tji Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.1551 h6nckott93k9onv7n1lb1s7tji Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d823656717d66a24',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d371456717d669c6' ,0,0 ,2,23.00,20000,?,?,?)
20241022@174426.1795 h6nckott93k9onv7n1lb1s7tji Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6717d371456717d669c6','2406912','wait',39,'adm09112754980.682000002')
20241022@174426.1860 h6nckott93k9onv7n1lb1s7tji Query : use flama_phc
20241022@174426.1863 h6nckott93k9onv7n1lb1s7tji Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241022@174426.1909 h6nckott93k9onv7n1lb1s7tji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2849';
20241022@174426.1942 h6nckott93k9onv7n1lb1s7tji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2849';
20241022@174426.1987 h6nckott93k9onv7n1lb1s7tji Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2849';
20241022@174426.2015 h6nckott93k9onv7n1lb1s7tji Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2849';
20241022@174426.2882 mo80i0bsb1504rl6a87oovt275 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241022@174426.2893 mo80i0bsb1504rl6a87oovt275 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241022@174426.2950 mo80i0bsb1504rl6a87oovt275 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2850';
20241022@174426.3012 mo80i0bsb1504rl6a87oovt275 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2850';
20241022@174426.3066 mo80i0bsb1504rl6a87oovt275 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2850';
20241022@174426.3099 mo80i0bsb1504rl6a87oovt275 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2850';
20241022@174426.3149 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.3152 mo80i0bsb1504rl6a87oovt275 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241022@174426.3211 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.3214 mo80i0bsb1504rl6a87oovt275 Query : select no, estab,szadrsdesc from szadrs where u_coddest=16
20241022@174426.3295 mo80i0bsb1504rl6a87oovt275 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241022@174426.3429 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406913 and bi.ref ='324.1321.00.1' and bi.lordem =1
20241022@174426.3862 mo80i0bsb1504rl6a87oovt275 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1321.00.1'
20241022@174426.3884 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406913 and bi.ref ='324.1321.00.1' and bi.lordem =1
20241022@174426.4019 mo80i0bsb1504rl6a87oovt275 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1329.00.1'
20241022@174426.4159 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406913 and bi.ref ='324.1329.00.1' and bi.lordem =2
20241022@174426.4502 mo80i0bsb1504rl6a87oovt275 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1332.00.1'
20241022@174426.4649 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406913 and bi.ref ='324.1332.00.1' and bi.lordem =3
20241022@174426.4977 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.4980 mo80i0bsb1504rl6a87oovt275 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241022@174426.5010 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.5013 mo80i0bsb1504rl6a87oovt275 Query : select top 1 1 valor from td where td.ndoc = 39
20241022@174426.5042 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.5045 mo80i0bsb1504rl6a87oovt275 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')
20241022@174426.5073 mo80i0bsb1504rl6a87oovt275 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
20241022@174426.5106 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.5109 mo80i0bsb1504rl6a87oovt275 Query : select top 1 ~inactivo valor from cl where no = '100327' and estab = 0 order by inactivo desc
20241022@174426.5223 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.5226 mo80i0bsb1504rl6a87oovt275 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241022@174426.5257 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.5260 mo80i0bsb1504rl6a87oovt275 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241022@174426.5298 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.5301 mo80i0bsb1504rl6a87oovt275 Query : select szadrsstamp valor from szadrs where szadrsdesc='discoteca juvenil, lda.'
20241022@174426.5349 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.5352 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from td where ndoc = 39
20241022@174426.5365 mo80i0bsb1504rl6a87oovt275 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241022@174426.5379 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.5396 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174426.5416 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.5431 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174426.5460 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.5476 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174426.5508 mo80i0bsb1504rl6a87oovt275 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174426.5571 mo80i0bsb1504rl6a87oovt275 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174426.5584 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.5600 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174426.5615 mo80i0bsb1504rl6a87oovt275 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6717d504876717d66a86' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241022@174426.5796 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.5814 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174426.5847 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241022@174426.5859 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241022@174426.5870 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241022@174426.5882 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241022@174426.5895 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241022@174426.5907 mo80i0bsb1504rl6a87oovt275 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241022@174426.5919 mo80i0bsb1504rl6a87oovt275 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6717d504876717d66a86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241022@174426.6158 mo80i0bsb1504rl6a87oovt275 Query : select top 1 fno valor from wsftdata order by fno desc
20241022@174426.6183 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.6200 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174426.6222 mo80i0bsb1504rl6a87oovt275 Query : select 'normal' from dummy
20241022@174426.6238 mo80i0bsb1504rl6a87oovt275 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6717d504876717d66a86',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1438,100327,0,'2024-10-22',39,'euro',0,0,2024 ,?,?)
20241022@174426.6517 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.6520 mo80i0bsb1504rl6a87oovt275 Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241022@174426.6544 mo80i0bsb1504rl6a87oovt275 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1321.00.1'
20241022@174426.6679 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.6695 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.6721 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.6736 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.6744 mo80i0bsb1504rl6a87oovt275 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174426.6756 mo80i0bsb1504rl6a87oovt275 Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241022@174426.6777 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.6792 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.6805 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d567016717d66aa5','aut6717d504876717d66a86' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174426.6809 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.6823 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.6853 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d567016717d66aa5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',11.000 ,'aut6717d504876717d66a86' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241022@174426.7094 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.7097 mo80i0bsb1504rl6a87oovt275 Query : select st.usalote valor from st where st.ref = '324.1321.00.1'
20241022@174426.7117 mo80i0bsb1504rl6a87oovt275 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1321.00.1'
20241022@174426.7133 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.7150 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.7179 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.7194 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.7203 mo80i0bsb1504rl6a87oovt275 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174426.7215 mo80i0bsb1504rl6a87oovt275 Query : select sestamp valor from se where ref ='324.1321.00.1' and lote = 'r2400495200a'
20241022@174426.7228 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.7243 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.7255 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d197586717d66ab0','aut6717d504876717d66a86' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174426.7259 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.7277 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.7310 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d197586717d66ab0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',13.000 ,'aut6717d504876717d66a86' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241022@174426.7762 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.8007 mo80i0bsb1504rl6a87oovt275 Query : select st.usalote valor from st where st.ref = '324.1329.00.1'
20241022@174426.8594 mo80i0bsb1504rl6a87oovt275 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1329.00.1'
20241022@174426.8909 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.8926 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.8951 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.8966 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.8974 mo80i0bsb1504rl6a87oovt275 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174426.8986 mo80i0bsb1504rl6a87oovt275 Query : select sestamp valor from se where ref ='324.1329.00.1' and lote = 'r2400496300a'
20241022@174426.8999 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.9016 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.9029 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d353896717d66adb','aut6717d504876717d66a86' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174426.9034 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.9049 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.9079 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d353896717d66adb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6717d504876717d66a86' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241022@174426.9317 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.9320 mo80i0bsb1504rl6a87oovt275 Query : select st.usalote valor from st where st.ref = '324.1332.00.1'
20241022@174426.9341 mo80i0bsb1504rl6a87oovt275 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1332.00.1'
20241022@174426.9475 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.9492 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.9517 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.9533 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.9542 mo80i0bsb1504rl6a87oovt275 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174426.9559 mo80i0bsb1504rl6a87oovt275 Query : select sestamp valor from se where ref ='324.1332.00.1' and lote = 'r2400759200a'
20241022@174426.9584 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.9599 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174426.9612 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d439126717d66ae9','aut6717d504876717d66a86' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174426.9617 mo80i0bsb1504rl6a87oovt275 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174426.9632 mo80i0bsb1504rl6a87oovt275 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174426.9660 mo80i0bsb1504rl6a87oovt275 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d439126717d66ae9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',24.000 ,'aut6717d504876717d66a86' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241022@174426.9905 mo80i0bsb1504rl6a87oovt275 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6717d504876717d66a86','2406913','wait',39,'adm09112754980.682000002')
20241022@174426.9972 mo80i0bsb1504rl6a87oovt275 Query : use flama_phc
20241022@174426.9975 mo80i0bsb1504rl6a87oovt275 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241022@174427.4000 mo80i0bsb1504rl6a87oovt275 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2850';
20241022@174427.3700 mo80i0bsb1504rl6a87oovt275 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2850';
20241022@174427.8000 mo80i0bsb1504rl6a87oovt275 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2850';
20241022@174427.1080 mo80i0bsb1504rl6a87oovt275 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2850';
20241022@174427.6190 tanih5a34989ulnvt7sb5oipo2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241022@174427.6300 tanih5a34989ulnvt7sb5oipo2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241022@174427.6870 tanih5a34989ulnvt7sb5oipo2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2851';
20241022@174427.8320 tanih5a34989ulnvt7sb5oipo2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2851';
20241022@174427.8870 tanih5a34989ulnvt7sb5oipo2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2851';
20241022@174427.9160 tanih5a34989ulnvt7sb5oipo2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2851';
20241022@174427.9650 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.9690 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241022@174427.1147 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.1160 tanih5a34989ulnvt7sb5oipo2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4790
20241022@174427.1249 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '304.421.00.04'
20241022@174427.1384 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406935 and bi.ref ='304.421.00.04' and bi.lordem =1
20241022@174427.1704 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.1708 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241022@174427.1746 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.1750 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 1 valor from td where td.ndoc = 39
20241022@174427.1782 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.1785 tanih5a34989ulnvt7sb5oipo2 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')
20241022@174427.1815 tanih5a34989ulnvt7sb5oipo2 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
20241022@174427.1857 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.1861 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 ~inactivo valor from cl where no = '199510' and estab = 0 order by inactivo desc
20241022@174427.1990 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.1994 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241022@174427.2025 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.2028 tanih5a34989ulnvt7sb5oipo2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241022@174427.2066 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.2068 tanih5a34989ulnvt7sb5oipo2 Query : select szadrsstamp valor from szadrs where szadrsdesc='199510 - cdnogueira regedoura'
20241022@174427.2112 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.2115 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from td where ndoc = 39
20241022@174427.2126 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241022@174427.2140 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.2156 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174427.2174 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.2187 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174427.2214 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.2229 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174427.2241 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174427.2441 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174427.2453 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.2469 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174427.2484 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6717d414436717d66b36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241022@174427.2662 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.2683 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174427.2718 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241022@174427.2729 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241022@174427.2740 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241022@174427.2751 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241022@174427.2762 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241022@174427.2773 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241022@174427.2783 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6717d414436717d66b36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241022@174427.3017 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 fno valor from wsftdata order by fno desc
20241022@174427.3040 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.3056 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174427.3079 tanih5a34989ulnvt7sb5oipo2 Query : select 'normal' from dummy
20241022@174427.3096 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6717d414436717d66b36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1439,199510,0,'2024-10-22',39,'euro',0,0,2024 ,?,?)
20241022@174427.3372 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.3375 tanih5a34989ulnvt7sb5oipo2 Query : select st.usalote valor from st where st.ref = '304.421.00.04'
20241022@174427.3396 tanih5a34989ulnvt7sb5oipo2 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 = '304.421.00.04'
20241022@174427.3529 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.3544 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174427.3581 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.3597 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174427.3605 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174427.3617 tanih5a34989ulnvt7sb5oipo2 Query : select sestamp valor from se where ref ='304.421.00.04' and lote = '241002'
20241022@174427.3631 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.3647 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174427.3659 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d814476717d66b58','aut6717d414436717d66b36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174427.3663 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.3678 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174427.3706 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d814476717d66b58',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut6717d414436717d66b36' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241022@174427.3952 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.3969 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174427.3993 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.4008 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174427.4016 tanih5a34989ulnvt7sb5oipo2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174427.4028 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.4043 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174427.4060 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d879856717d66b62','aut6717d414436717d66b36' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174427.4064 tanih5a34989ulnvt7sb5oipo2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174427.4080 tanih5a34989ulnvt7sb5oipo2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174427.4108 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut6717d879856717d66b62',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut6717d414436717d66b36' ,0,0 ,2,23.00,20000,?,?,?)
20241022@174427.4349 tanih5a34989ulnvt7sb5oipo2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut6717d414436717d66b36','2406935','wait',39,'adm09112754980.682000002')
20241022@174427.4416 tanih5a34989ulnvt7sb5oipo2 Query : use flama_phc
20241022@174427.4419 tanih5a34989ulnvt7sb5oipo2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241022@174427.4448 tanih5a34989ulnvt7sb5oipo2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2851';
20241022@174427.4483 tanih5a34989ulnvt7sb5oipo2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2851';
20241022@174427.4564 tanih5a34989ulnvt7sb5oipo2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2851';
20241022@174427.4645 tanih5a34989ulnvt7sb5oipo2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2851';
20241022@174427.5208 fv3os1vsv4rp9dgjavhuimvmq8 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241022@174427.5218 fv3os1vsv4rp9dgjavhuimvmq8 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241022@174427.5278 fv3os1vsv4rp9dgjavhuimvmq8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2852';
20241022@174427.5334 fv3os1vsv4rp9dgjavhuimvmq8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2852';
20241022@174427.5393 fv3os1vsv4rp9dgjavhuimvmq8 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='2852';
20241022@174427.5422 fv3os1vsv4rp9dgjavhuimvmq8 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='2852';
20241022@174427.5473 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174427.5476 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241022@174427.5535 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174427.5538 fv3os1vsv4rp9dgjavhuimvmq8 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2679
20241022@174427.5619 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.945.00.01'
20241022@174427.5772 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.945.00.01' and bi.lordem =2
20241022@174427.6093 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20241022@174427.6221 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.946.00.01' and bi.lordem =4
20241022@174427.6539 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.946.00.01'
20241022@174427.6559 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.946.00.01' and bi.lordem =4
20241022@174427.6579 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20241022@174427.6719 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.1407.00.1' and bi.lordem =6
20241022@174427.7037 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1407.00.1'
20241022@174427.7057 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.1407.00.1' and bi.lordem =6
20241022@174427.7073 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4901.00.1'
20241022@174427.7207 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.4901.00.1' and bi.lordem =8
20241022@174427.7535 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4906.00.1'
20241022@174427.7891 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.4906.00.1' and bi.lordem =9
20241022@174427.9217 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5343.00.1'
20241022@174427.9403 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='324.5343.00.1' and bi.lordem =10
20241022@174427.9721 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20241022@174427.9860 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='323.318.09.00' and bi.lordem =12
20241022@174428.1720 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '323.318.09.00'
20241022@174428.1920 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2069 and bo.obrano = 2406939 and bi.ref ='323.318.09.00' and bi.lordem =12
20241022@174428.2090 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.2120 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241022@174428.2490 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.2530 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 1 valor from td where td.ndoc = 39
20241022@174428.2810 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.2840 fv3os1vsv4rp9dgjavhuimvmq8 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')
20241022@174428.3110 fv3os1vsv4rp9dgjavhuimvmq8 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
20241022@174428.3450 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.3490 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 ~inactivo valor from cl where no = '199525' and estab = 0 order by inactivo desc
20241022@174428.4610 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.4630 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241022@174428.4960 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.4990 fv3os1vsv4rp9dgjavhuimvmq8 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241022@174428.5360 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.5390 fv3os1vsv4rp9dgjavhuimvmq8 Query : select szadrsstamp valor from szadrs where szadrsdesc='euroilhas - soc.com.representaÇÕes,lda'
20241022@174428.5890 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.5910 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from td where ndoc = 39
20241022@174428.6030 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241022@174428.6170 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.6340 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174428.6530 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.6670 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174428.6960 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.7130 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174428.7250 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174428.8140 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241022@174428.8270 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.8430 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241022@174428.8580 fv3os1vsv4rp9dgjavhuimvmq8 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut6717d235186717d66c11' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241022@174428.1043 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.1063 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241022@174428.1102 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241022@174428.1114 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241022@174428.1126 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241022@174428.1142 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241022@174428.1154 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241022@174428.1165 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241022@174428.1177 fv3os1vsv4rp9dgjavhuimvmq8 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut6717d235186717d66c11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241022@174428.1450 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 fno valor from wsftdata order by fno desc
20241022@174428.1474 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.1491 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241022@174428.1514 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 'normal' from dummy
20241022@174428.1530 fv3os1vsv4rp9dgjavhuimvmq8 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut6717d235186717d66c11',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1440,199525,0,'2024-10-22',39,'euro',0,0,2024 ,?,?)
20241022@174428.1820 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.1823 fv3os1vsv4rp9dgjavhuimvmq8 Query : select st.usalote valor from st where st.ref = '324.945.00.01'
20241022@174428.1846 fv3os1vsv4rp9dgjavhuimvmq8 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.945.00.01'
20241022@174428.1975 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.1991 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174428.2016 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.2050 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174428.2059 fv3os1vsv4rp9dgjavhuimvmq8 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241022@174428.2071 fv3os1vsv4rp9dgjavhuimvmq8 Query : select sestamp valor from se where ref ='324.945.00.01' and lote = 'r2400091100a'
20241022@174428.2093 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.2114 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241022@174428.2126 fv3os1vsv4rp9dgjavhuimvmq8 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut6717d632016717d66c33','aut6717d235186717d66c11' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241022@174428.2137 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.2152 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174428.2179 fv3os1vsv4rp9dgjavhuimvmq8 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut6717d632016717d66c33',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut6717d235186717d66c11' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241022@174428.2432 fv3os1vsv4rp9dgjavhuimvmq8 Query : use flama_phc
20241022@174428.2436 fv3os1vsv4rp9dgjavhuimvmq8 Query : select st.usalote valor from st where st.ref = '324.946.00.01'
20241022@174428.2589 fv3os1vsv4rp9dgjavhuimvmq8 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.946.00.01'
20241022@174428.2722 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.2738 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241022@174428.2761 fv3os1vsv4rp9dgjavhuimvmq8 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241022@174428.2776 fv3os1vsv4rp9dgjavhuimvmq8 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
