20241202@135547.8275 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db10977674dbc63bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',44.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,140000,?,?,?,?,?)
20241202@135547.8582 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.8602 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135547.8635 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.8657 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135547.8666 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135547.8679 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.8694 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135547.8706 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db99651674dbc63d3','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135547.8711 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.8928 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135547.8960 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db99651674dbc63d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,150000,?,?,?)
20241202@135547.9261 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135547.9266 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.2066.00.1'
20241202@135547.9295 vdera1rpjk5ieqi09ln3p7k8as 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.2066.00.1'
20241202@135547.9460 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.9479 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135547.9507 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.9524 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135547.9532 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135547.9546 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.2066.00.1' and lote = 'r2400051100a'
20241202@135547.9570 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.9585 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135547.9597 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db59059674dbc63e9','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135547.9601 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.9616 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135547.9642 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db59059674dbc63e9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',204.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,170000,?,?,?,?,?)
20241202@135547.9931 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.9949 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135547.9976 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135547.9992 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.0000 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.1300 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.2900 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.4000 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db69216674dbc6400','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.4400 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6000 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.8500 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db69216674dbc6400',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,180000,?,?,?)
20241202@135548.3680 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.3710 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241202@135548.3910 vdera1rpjk5ieqi09ln3p7k8as 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.969.00.01'
20241202@135548.5490 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.5660 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.6170 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6310 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.6390 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.6640 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241202@135548.6790 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6950 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.7060 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db43019674dbc6410','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.7120 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.7260 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.7550 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db43019674dbc6410',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,200000,?,?,?,?,?)
20241202@135548.1054 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.1057 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241202@135548.1078 vdera1rpjk5ieqi09ln3p7k8as 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.969.00.01'
20241202@135548.1091 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1106 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.1132 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1146 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.1155 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.1168 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241202@135548.1181 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1195 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.1208 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db86063674dbc641c','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.1214 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1229 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.1255 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db86063674dbc641c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',22.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,210000,?,?,?,?,?)
20241202@135548.1554 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.1557 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.969.00.01'
20241202@135548.1577 vdera1rpjk5ieqi09ln3p7k8as 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.969.00.01'
20241202@135548.1591 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1607 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.1690 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1705 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.1715 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.1728 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.969.00.01' and lote = 'r2100601100a'
20241202@135548.1740 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1755 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.1767 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db63869674dbc642a','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.1771 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.1786 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.1818 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db63869674dbc642a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241202@135548.2126 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.2129 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.4964.00.1'
20241202@135548.2150 vdera1rpjk5ieqi09ln3p7k8as 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.4964.00.1'
20241202@135548.2318 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.2337 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.2362 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.2377 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.2385 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.2397 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.4964.00.1' and lote = 'r2300717100a'
20241202@135548.2429 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.2442 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.2459 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db15329674dbc643b','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.2463 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.2478 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.2505 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db15329674dbc643b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,230000,?,?,?,?,?)
20241202@135548.3227 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.3270 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.4963.00.1'
20241202@135548.3708 vdera1rpjk5ieqi09ln3p7k8as 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.4963.00.1'
20241202@135548.3894 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.3913 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.3944 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.3961 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.3972 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.3984 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.4963.00.1' and lote = 'r2300717200a'
20241202@135548.3997 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.4016 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.4027 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db09659674dbc6461','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.4031 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.4045 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.4074 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db09659674dbc6461',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,240000,?,?,?,?,?)
20241202@135548.4369 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.4372 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20241202@135548.4396 vdera1rpjk5ieqi09ln3p7k8as 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.2221.00.1'
20241202@135548.4578 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.4595 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.4621 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.4636 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.4645 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.4659 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20241202@135548.4677 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.4695 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.4711 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db74173674dbc6472','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.4716 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.4734 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.4766 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db74173674dbc6472',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20241202@135548.5113 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.5117 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.2221.00.1'
20241202@135548.5139 vdera1rpjk5ieqi09ln3p7k8as 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.2221.00.1'
20241202@135548.5155 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.5172 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.5204 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.5222 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.5232 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.5247 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.2221.00.1' and lote = 'r2301280100a'
20241202@135548.5287 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.5305 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.5323 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db12799674dbc6481','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.5328 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.5349 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.5384 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db12799674dbc6481',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,260000,?,?,?,?,?)
20241202@135548.5719 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.5723 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.4961.00.1'
20241202@135548.5749 vdera1rpjk5ieqi09ln3p7k8as 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.4961.00.1'
20241202@135548.5931 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.5950 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.5981 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6001 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.6013 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.6027 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.4961.00.1' and lote = 'r2101092200a'
20241202@135548.6048 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6067 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.6079 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db70308674dbc6493','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.6083 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6098 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.6128 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db70308674dbc6493',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',40.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,270000,?,?,?,?,?)
20241202@135548.6446 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.6450 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.2223.00.1'
20241202@135548.6471 vdera1rpjk5ieqi09ln3p7k8as 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.2223.00.1'
20241202@135548.6635 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6655 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.6684 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6700 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.6710 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.6724 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.2223.00.1' and lote = 'r2301280100a'
20241202@135548.6745 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6762 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.6776 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db31503674dbc64a4','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.6781 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.6799 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.6830 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db31503674dbc64a4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,280000,?,?,?,?,?)
20241202@135548.7382 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.7386 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.2222.00.1'
20241202@135548.7408 vdera1rpjk5ieqi09ln3p7k8as 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.2222.00.1'
20241202@135548.7578 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.7599 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.7630 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.7647 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.7656 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.7671 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.2222.00.1' and lote = 'r2301280100a'
20241202@135548.7686 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.7703 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.7716 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db92491674dbc64bb','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.7722 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.7737 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.7777 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db92491674dbc64bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,290000,?,?,?,?,?)
20241202@135548.8079 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.8083 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20241202@135548.8108 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2224.00.1'
20241202@135548.8318 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.8503 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.8535 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.8557 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.8568 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.8582 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20241202@135548.8599 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.8617 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.8631 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db20666674dbc64d1','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.8636 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.8654 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.8686 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db20666674dbc64d1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,300000,?,?,?,?,?)
20241202@135548.8986 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.8990 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.2224.00.1'
20241202@135548.9023 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2224.00.1'
20241202@135548.9040 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.9061 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.9100 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.9130 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.9141 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135548.9154 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.2224.00.1' and lote = 'r2301280100a'
20241202@135548.9170 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.9186 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135548.9199 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db35803674dbc64df','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135548.9204 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135548.9223 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135548.9257 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db35803674dbc64df',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',16.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,310000,?,?,?,?,?)
20241202@135548.9551 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135548.9555 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.1426.00.1'
20241202@135548.9581 vdera1rpjk5ieqi09ln3p7k8as 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.1426.00.1'
20241202@135549.8090 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.8400 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.9050 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.9540 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.9810 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135549.9950 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.1426.00.1' and lote = 'r2100465200a'
20241202@135549.1010 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.1044 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.1057 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db42947674dbc6518','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135549.1062 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.1097 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.1129 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db42947674dbc6518',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',28.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,320000,?,?,?,?,?)
20241202@135549.1686 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.1739 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.1768 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.1784 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.1793 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135549.1807 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.1824 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.1837 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db84867674dbc652c','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135549.1842 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.1860 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.1890 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db84867674dbc652c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,330000,?,?,?)
20241202@135549.2223 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135549.2227 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.1426.00.1'
20241202@135549.2251 vdera1rpjk5ieqi09ln3p7k8as 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.1426.00.1'
20241202@135549.2277 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.2297 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.2327 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.2342 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.2350 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135549.2375 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.1426.00.1' and lote = 'r2100465200a'
20241202@135549.2388 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.2404 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.2417 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db50469674dbc653a','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135549.2422 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.2437 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.2473 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db50469674dbc653a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,350000,?,?,?,?,?)
20241202@135549.2907 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.2928 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.2955 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.2971 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.2981 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135549.2993 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.3013 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.3026 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db17117674dbc6549','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135549.3030 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.3045 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.3080 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db17117674dbc6549',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db07419674dbc627a' ,0,0 ,2,23.00,360000,?,?,?)
20241202@135549.3413 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135549.3416 vdera1rpjk5ieqi09ln3p7k8as Query : select st.usalote valor from st where st.ref = '324.4980.00.1'
20241202@135549.3486 vdera1rpjk5ieqi09ln3p7k8as 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.4980.00.1'
20241202@135549.3770 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.3874 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135549.4088 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.4186 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.4243 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135549.4284 vdera1rpjk5ieqi09ln3p7k8as Query : select sestamp valor from se where ref ='324.4980.00.1' and lote = 'r230109210'
20241202@135549.4311 vdera1rpjk5ieqi09ln3p7k8as Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.4417 vdera1rpjk5ieqi09ln3p7k8as Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135549.4492 vdera1rpjk5ieqi09ln3p7k8as Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db62239674dbc6569','aut674db07419674dbc627a' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135549.4570 vdera1rpjk5ieqi09ln3p7k8as Query : use flama_phc
20241202@135549.4586 vdera1rpjk5ieqi09ln3p7k8as Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -116
20241202@135549.4708 vdera1rpjk5ieqi09ln3p7k8as Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3604';
20241202@135549.4756 vdera1rpjk5ieqi09ln3p7k8as Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3604';
20241202@135549.5416 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241202@135549.5427 ohvklsudbk30p1mqjvlr3b97s5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241202@135549.5544 ohvklsudbk30p1mqjvlr3b97s5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3605';
20241202@135549.5850 ohvklsudbk30p1mqjvlr3b97s5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3605';
20241202@135549.6017 ohvklsudbk30p1mqjvlr3b97s5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3605';
20241202@135549.6117 ohvklsudbk30p1mqjvlr3b97s5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3605';
20241202@135549.6180 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.6183 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241202@135549.6340 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.6346 ohvklsudbk30p1mqjvlr3b97s5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4790
20241202@135549.6442 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20241202@135549.6728 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407988 and bi.ref ='324.2232.00.1' and bi.lordem =1
20241202@135549.7157 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20241202@135549.7221 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407988 and bi.ref ='324.2232.00.1' and bi.lordem =2
20241202@135549.7781 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.7785 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241202@135549.7945 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.7969 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 1 valor from td where td.ndoc = 39
20241202@135549.8058 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.8084 ohvklsudbk30p1mqjvlr3b97s5 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')
20241202@135549.8234 ohvklsudbk30p1mqjvlr3b97s5 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
20241202@135549.8389 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.8409 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 ~inactivo valor from cl where no = '199510' and estab = 0 order by inactivo desc
20241202@135549.8496 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.8538 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241202@135549.8613 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.8623 ohvklsudbk30p1mqjvlr3b97s5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241202@135549.8740 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.8749 ohvklsudbk30p1mqjvlr3b97s5 Query : select szadrsstamp valor from szadrs where szadrsdesc='199510 - cdnogueira regedoura'
20241202@135549.8898 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135549.8902 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from td where ndoc = 39
20241202@135549.8983 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241202@135549.9034 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.9095 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241202@135549.9208 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.9284 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241202@135549.9435 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135549.9537 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241202@135549.9607 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241202@135549.9770 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241202@135549.9927 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.6700 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241202@135550.1840 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674db46620674dbc65ea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241202@135550.4660 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.5150 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241202@135550.6710 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241202@135550.6940 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241202@135550.7680 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241202@135550.8050 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241202@135550.8350 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241202@135550.9080 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241202@135550.9730 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674db46620674dbc65ea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241202@135550.1387 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 fno valor from wsftdata order by fno desc
20241202@135550.1776 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.2155 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241202@135550.2708 ohvklsudbk30p1mqjvlr3b97s5 Query : select 'normal' from dummy
20241202@135550.2772 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674db46620674dbc65ea',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2128,199510,0,'2024-12-02',39,'euro',0,0,2024 ,?,?)
20241202@135550.3160 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135550.3168 ohvklsudbk30p1mqjvlr3b97s5 Query : select st.usalote valor from st where st.ref = '324.2232.00.1'
20241202@135550.3221 ohvklsudbk30p1mqjvlr3b97s5 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.2232.00.1'
20241202@135550.3396 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.3432 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135550.3462 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.3478 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135550.3487 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135550.3499 ohvklsudbk30p1mqjvlr3b97s5 Query : select sestamp valor from se where ref ='324.2232.00.1' and lote = 'r2400241100a'
20241202@135550.3518 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.3534 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135550.3547 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db06003674dbc6655','aut674db46620674dbc65ea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135550.3558 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.3574 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135550.3615 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db06003674dbc6655',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut674db46620674dbc65ea' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241202@135550.3933 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135550.3936 ohvklsudbk30p1mqjvlr3b97s5 Query : select st.usalote valor from st where st.ref = '324.2232.00.1'
20241202@135550.3958 ohvklsudbk30p1mqjvlr3b97s5 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.2232.00.1'
20241202@135550.3972 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.3988 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135550.4042 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.4060 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135550.4070 ohvklsudbk30p1mqjvlr3b97s5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135550.4085 ohvklsudbk30p1mqjvlr3b97s5 Query : select sestamp valor from se where ref ='324.2232.00.1' and lote = 'r2400241100a'
20241202@135550.4101 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.4120 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135550.4135 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db81658674dbc6664','aut674db46620674dbc65ea' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135550.4140 ohvklsudbk30p1mqjvlr3b97s5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.4158 ohvklsudbk30p1mqjvlr3b97s5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135550.4200 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db81658674dbc6664',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut674db46620674dbc65ea' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241202@135550.4489 ohvklsudbk30p1mqjvlr3b97s5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674db46620674dbc65ea','2407988','wait',39,'adm09112754980.682000002')
20241202@135550.4601 ohvklsudbk30p1mqjvlr3b97s5 Query : use flama_phc
20241202@135550.4605 ohvklsudbk30p1mqjvlr3b97s5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241202@135550.4637 ohvklsudbk30p1mqjvlr3b97s5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3605';
20241202@135550.4681 ohvklsudbk30p1mqjvlr3b97s5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3605';
20241202@135550.4730 ohvklsudbk30p1mqjvlr3b97s5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3605';
20241202@135550.4772 ohvklsudbk30p1mqjvlr3b97s5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3605';
20241202@135550.5271 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241202@135550.5281 6mer8b7mm8ahdgcfrsfukibtqj Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241202@135550.5455 6mer8b7mm8ahdgcfrsfukibtqj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3606';
20241202@135550.5613 6mer8b7mm8ahdgcfrsfukibtqj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3606';
20241202@135550.5677 6mer8b7mm8ahdgcfrsfukibtqj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3606';
20241202@135550.5712 6mer8b7mm8ahdgcfrsfukibtqj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3606';
20241202@135550.5771 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.5775 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241202@135550.5869 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.5872 6mer8b7mm8ahdgcfrsfukibtqj Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241202@135550.5980 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20241202@135550.6167 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407993 and bi.ref ='324.1805.00.1' and bi.lordem =1
20241202@135550.6954 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20241202@135550.7397 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407993 and bi.ref ='324.1805.00.1' and bi.lordem =1
20241202@135550.7613 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20241202@135550.7917 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407993 and bi.ref ='324.1805.00.1' and bi.lordem =1
20241202@135550.7939 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20241202@135550.7963 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407993 and bi.ref ='324.1805.00.1' and bi.lordem =1
20241202@135550.7983 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1805.00.1'
20241202@135550.8009 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407993 and bi.ref ='324.1805.00.1' and bi.lordem =1
20241202@135550.8030 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8033 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241202@135550.8069 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8072 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 1 valor from td where td.ndoc = 39
20241202@135550.8103 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8107 6mer8b7mm8ahdgcfrsfukibtqj 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')
20241202@135550.8140 6mer8b7mm8ahdgcfrsfukibtqj 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
20241202@135550.8183 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8185 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241202@135550.8340 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8343 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241202@135550.8381 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8386 6mer8b7mm8ahdgcfrsfukibtqj Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241202@135550.8433 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8436 6mer8b7mm8ahdgcfrsfukibtqj Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241202@135550.8486 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135550.8489 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from td where ndoc = 39
20241202@135550.8504 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241202@135550.8523 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.8544 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241202@135550.8566 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.8583 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241202@135550.8618 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.8634 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241202@135550.8648 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241202@135550.8725 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241202@135550.8742 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.8761 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241202@135550.8779 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674db81752674dbc66d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241202@135550.9017 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.9044 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241202@135550.9147 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241202@135550.9161 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241202@135550.9176 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241202@135550.9189 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241202@135550.9201 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241202@135550.9214 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241202@135550.9226 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674db81752674dbc66d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241202@135550.9800 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 fno valor from wsftdata order by fno desc
20241202@135550.9830 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135550.9847 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241202@135550.9871 6mer8b7mm8ahdgcfrsfukibtqj Query : select 'normal' from dummy
20241202@135550.9892 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674db81752674dbc66d3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2129,100810,0,'2024-12-02',39,'euro',0,0,2024 ,?,?)
20241202@135551.2790 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135551.2830 6mer8b7mm8ahdgcfrsfukibtqj Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20241202@135551.3060 6mer8b7mm8ahdgcfrsfukibtqj 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.1805.00.1'
20241202@135551.7250 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.7460 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.7740 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.7910 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.8000 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135551.8150 6mer8b7mm8ahdgcfrsfukibtqj Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400291200a'
20241202@135551.8350 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.8570 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.8700 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db36535674dbc6714','aut674db81752674dbc66d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135551.8750 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.8900 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.9250 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db36535674dbc6714',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut674db81752674dbc66d3' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241202@135551.1248 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135551.1253 6mer8b7mm8ahdgcfrsfukibtqj Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20241202@135551.1278 6mer8b7mm8ahdgcfrsfukibtqj 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.1805.00.1'
20241202@135551.1296 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.1316 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.1367 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.1386 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.1396 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135551.1412 6mer8b7mm8ahdgcfrsfukibtqj Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400291200a'
20241202@135551.1427 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.1442 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.1463 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db76712674dbc6722','aut674db81752674dbc66d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135551.1468 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.1486 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.1521 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db76712674dbc6722',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut674db81752674dbc66d3' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241202@135551.1898 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135551.1903 6mer8b7mm8ahdgcfrsfukibtqj Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20241202@135551.1945 6mer8b7mm8ahdgcfrsfukibtqj 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.1805.00.1'
20241202@135551.1968 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.1986 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.2019 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.2041 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.2050 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135551.2064 6mer8b7mm8ahdgcfrsfukibtqj Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400291200a'
20241202@135551.2078 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.2096 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.2110 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db00050674dbc6732','aut674db81752674dbc66d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135551.2115 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.2132 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.2165 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db00050674dbc6732',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut674db81752674dbc66d3' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241202@135551.2485 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135551.2489 6mer8b7mm8ahdgcfrsfukibtqj Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20241202@135551.2513 6mer8b7mm8ahdgcfrsfukibtqj 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.1805.00.1'
20241202@135551.2529 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.2547 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.2576 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.2592 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.2602 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135551.2621 6mer8b7mm8ahdgcfrsfukibtqj Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400291200a'
20241202@135551.2635 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.2652 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.2666 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db76810674dbc6740','aut674db81752674dbc66d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135551.2671 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.2686 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.2718 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db76810674dbc6740',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut674db81752674dbc66d3' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241202@135551.4606 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135551.4611 6mer8b7mm8ahdgcfrsfukibtqj Query : select st.usalote valor from st where st.ref = '324.1805.00.1'
20241202@135551.4636 6mer8b7mm8ahdgcfrsfukibtqj 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.1805.00.1'
20241202@135551.4652 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.4673 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.4703 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.4726 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.4740 6mer8b7mm8ahdgcfrsfukibtqj Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135551.4757 6mer8b7mm8ahdgcfrsfukibtqj Query : select sestamp valor from se where ref ='324.1805.00.1' and lote = 'r2400291200a'
20241202@135551.4797 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.4818 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135551.4832 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db14063674dbc6775','aut674db81752674dbc66d3' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135551.4858 6mer8b7mm8ahdgcfrsfukibtqj Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.4874 6mer8b7mm8ahdgcfrsfukibtqj Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135551.4914 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db14063674dbc6775',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',14.000 ,'aut674db81752674dbc66d3' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241202@135551.5229 6mer8b7mm8ahdgcfrsfukibtqj Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674db81752674dbc66d3','2407993','wait',39,'adm09112754980.682000002')
20241202@135551.5306 6mer8b7mm8ahdgcfrsfukibtqj Query : use flama_phc
20241202@135551.5320 6mer8b7mm8ahdgcfrsfukibtqj Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241202@135551.5352 6mer8b7mm8ahdgcfrsfukibtqj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3606';
20241202@135551.5396 6mer8b7mm8ahdgcfrsfukibtqj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3606';
20241202@135551.5452 6mer8b7mm8ahdgcfrsfukibtqj Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3606';
20241202@135551.5495 6mer8b7mm8ahdgcfrsfukibtqj Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3606';
20241202@135551.6137 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241202@135551.6159 46vf5eqk3hdrjq8qougpb4fue5 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241202@135551.6277 46vf5eqk3hdrjq8qougpb4fue5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3607';
20241202@135551.6347 46vf5eqk3hdrjq8qougpb4fue5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3607';
20241202@135551.6448 46vf5eqk3hdrjq8qougpb4fue5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3607';
20241202@135551.6502 46vf5eqk3hdrjq8qougpb4fue5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3607';
20241202@135551.6612 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.6616 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241202@135551.6716 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.6720 46vf5eqk3hdrjq8qougpb4fue5 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241202@135551.7069 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241202@135551.7250 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407995 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241202@135551.7624 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241202@135551.7650 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407995 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241202@135551.7668 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241202@135551.7687 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407995 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241202@135551.7705 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1834.00.1'
20241202@135551.7727 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407995 and bi.ref ='324.1834.00.1' and bi.lordem =1
20241202@135551.7753 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.7759 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241202@135551.7806 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.7811 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 1 valor from td where td.ndoc = 39
20241202@135551.7842 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.7846 46vf5eqk3hdrjq8qougpb4fue5 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')
20241202@135551.7879 46vf5eqk3hdrjq8qougpb4fue5 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
20241202@135551.7989 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.8031 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241202@135551.8111 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.8114 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241202@135551.8147 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.8151 46vf5eqk3hdrjq8qougpb4fue5 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241202@135551.8194 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.8198 46vf5eqk3hdrjq8qougpb4fue5 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241202@135551.8246 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.8249 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from td where ndoc = 39
20241202@135551.8264 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241202@135551.8278 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.8297 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241202@135551.8324 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.8344 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241202@135551.8391 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.8415 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241202@135551.8432 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241202@135551.8493 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241202@135551.8506 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.8527 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241202@135551.8545 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241202@135551.8785 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.8827 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241202@135551.8862 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241202@135551.8876 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241202@135551.8896 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241202@135551.8910 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241202@135551.8931 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241202@135551.8948 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241202@135551.8961 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut674db86464674dbc67cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241202@135551.9279 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 fno valor from wsftdata order by fno desc
20241202@135551.9347 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135551.9370 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241202@135551.9396 46vf5eqk3hdrjq8qougpb4fue5 Query : select 'normal' from dummy
20241202@135551.9412 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut674db86464674dbc67cd',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2130,100810,0,'2024-12-02',39,'euro',0,0,2024 ,?,?)
20241202@135551.9782 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135551.9785 46vf5eqk3hdrjq8qougpb4fue5 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241202@135551.9810 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20241202@135551.9984 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1000 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.3000 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.5200 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.6300 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.7800 46vf5eqk3hdrjq8qougpb4fue5 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241202@135552.9300 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1090 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.1210 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db82022674dbc6802','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.1250 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1410 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.1700 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db82022674dbc6802',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241202@135552.5190 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.5390 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.5700 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.6240 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.6350 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.6520 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.6760 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.6900 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db63216674dbc680f','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.6950 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.7180 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.7510 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db63216674dbc680f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,20000,?,?,?)
20241202@135552.1090 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135552.1095 46vf5eqk3hdrjq8qougpb4fue5 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241202@135552.1122 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20241202@135552.1143 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1170 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.1202 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1222 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.1232 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.1248 46vf5eqk3hdrjq8qougpb4fue5 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241202@135552.1263 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1282 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.1296 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db82718674dbc681e','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.1301 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1319 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.1349 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db82718674dbc681e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241202@135552.1665 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1687 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.1719 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.1964 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.1975 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.1988 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.2006 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.2023 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db01303674dbc6830','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.2029 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.2046 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.2089 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db01303674dbc6830',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,50000,?,?,?)
20241202@135552.2414 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135552.2418 46vf5eqk3hdrjq8qougpb4fue5 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241202@135552.2444 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20241202@135552.2465 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.2484 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.2514 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.2531 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.2540 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.2556 46vf5eqk3hdrjq8qougpb4fue5 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241202@135552.2573 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.2591 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.2604 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db34428674dbc683e','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.2608 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.2627 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.2661 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db34428674dbc683e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241202@135552.3033 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3056 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.3159 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3181 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.3189 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.3202 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3217 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.3229 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db32756674dbc684e','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.3234 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3249 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.3282 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db32756674dbc684e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,80000,?,?,?)
20241202@135552.3654 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135552.3658 46vf5eqk3hdrjq8qougpb4fue5 Query : select st.usalote valor from st where st.ref = '324.1834.00.1'
20241202@135552.3681 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1834.00.1'
20241202@135552.3696 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3728 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.3759 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3781 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.3790 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.3803 46vf5eqk3hdrjq8qougpb4fue5 Query : select sestamp valor from se where ref ='324.1834.00.1' and lote = 'r2400214200a'
20241202@135552.3818 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3834 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.3847 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db94675674dbc685d','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.3852 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.3874 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.3905 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut674db94675674dbc685d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241202@135552.4344 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.4611 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.4816 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.4835 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.4855 46vf5eqk3hdrjq8qougpb4fue5 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241202@135552.4868 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.4886 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241202@135552.4899 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut674db98829674dbc6876','aut674db86464674dbc67cd' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241202@135552.4904 46vf5eqk3hdrjq8qougpb4fue5 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.4918 46vf5eqk3hdrjq8qougpb4fue5 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241202@135552.4946 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut674db98829674dbc6876',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut674db86464674dbc67cd' ,0,0 ,2,23.00,110000,?,?,?)
20241202@135552.5232 46vf5eqk3hdrjq8qougpb4fue5 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut674db86464674dbc67cd','2407995','wait',39,'adm09112754980.682000002')
20241202@135552.5307 46vf5eqk3hdrjq8qougpb4fue5 Query : use flama_phc
20241202@135552.5311 46vf5eqk3hdrjq8qougpb4fue5 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241202@135552.5340 46vf5eqk3hdrjq8qougpb4fue5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3607';
20241202@135552.5381 46vf5eqk3hdrjq8qougpb4fue5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3607';
20241202@135552.5436 46vf5eqk3hdrjq8qougpb4fue5 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3607';
20241202@135552.5469 46vf5eqk3hdrjq8qougpb4fue5 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3607';
20241202@135552.6053 v9t774ack6gbvvbsk9pjk109ie Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241202@135552.6064 v9t774ack6gbvvbsk9pjk109ie Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241202@135552.6135 v9t774ack6gbvvbsk9pjk109ie Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3608';
20241202@135552.6215 v9t774ack6gbvvbsk9pjk109ie Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3608';
20241202@135552.6295 v9t774ack6gbvvbsk9pjk109ie Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3608';
20241202@135552.6364 v9t774ack6gbvvbsk9pjk109ie Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3608';
20241202@135552.6442 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.6447 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241202@135552.6539 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.6542 v9t774ack6gbvvbsk9pjk109ie Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241202@135552.6602 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1406.00.1'
20241202@135552.6810 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407996 and bi.ref ='324.1406.00.1' and bi.lordem =1
20241202@135552.7193 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1406.00.1'
20241202@135552.7231 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2079 and bo.obrano = 2407996 and bi.ref ='324.1406.00.1' and bi.lordem =1
20241202@135552.7258 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7271 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241202@135552.7563 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7567 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 1 valor from td where td.ndoc = 39
20241202@135552.7603 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7607 v9t774ack6gbvvbsk9pjk109ie 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')
20241202@135552.7644 v9t774ack6gbvvbsk9pjk109ie 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
20241202@135552.7682 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7685 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241202@135552.7717 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7720 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241202@135552.7751 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7754 v9t774ack6gbvvbsk9pjk109ie Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241202@135552.7799 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7802 v9t774ack6gbvvbsk9pjk109ie Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241202@135552.7856 v9t774ack6gbvvbsk9pjk109ie Query : use flama_phc
20241202@135552.7859 v9t774ack6gbvvbsk9pjk109ie Query : select 1 valor from td where ndoc = 39
20241202@135552.7872 v9t774ack6gbvvbsk9pjk109ie Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241202@135552.7887 v9t774ack6gbvvbsk9pjk109ie Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241202@135552.7904 v9t774ack6gbvvbsk9pjk109ie Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
