20241212@154229.7284 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.7295 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b076195675b0465b1','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154229.7300 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.7314 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.7342 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b076195675b0465b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675b090338675b046548' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241212@154229.7585 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.7602 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.7632 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.7648 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.7658 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154229.7672 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.7708 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.7720 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b011922675b0465bb','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154229.7724 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.7741 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.7771 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b011922675b0465bb',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b090338675b046548' ,0,0 ,2,23.00,110000,?,?,?)
20241212@154229.8033 l5m8nt5fsodjig5dvq05el3b4q Query : use flama_phc
20241212@154229.8036 l5m8nt5fsodjig5dvq05el3b4q Query : select st.usalote valor from st where st.ref = '324.686.00.01'
20241212@154229.8056 l5m8nt5fsodjig5dvq05el3b4q 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.686.00.01'
20241212@154229.8071 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8092 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.8117 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8132 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.8140 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154229.8152 l5m8nt5fsodjig5dvq05el3b4q Query : select sestamp valor from se where ref ='324.686.00.01' and lote = 'r2400127100a'
20241212@154229.8165 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8179 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.8192 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b068547675b0465c7','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154229.8197 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8211 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.8264 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b068547675b0465c7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675b090338675b046548' ,0,0 ,2,23.00,130000,?,?,?,?,?)
20241212@154229.8510 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8529 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.8556 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8573 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.8582 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154229.8594 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8609 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.8626 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b069008675b0465d1','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154229.8630 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.8644 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.8675 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b069008675b0465d1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b090338675b046548' ,0,0 ,2,23.00,140000,?,?,?)
20241212@154229.8977 l5m8nt5fsodjig5dvq05el3b4q Query : use flama_phc
20241212@154229.8981 l5m8nt5fsodjig5dvq05el3b4q Query : select st.usalote valor from st where st.ref = '324.686.00.01'
20241212@154229.9001 l5m8nt5fsodjig5dvq05el3b4q 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.686.00.01'
20241212@154229.9017 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9033 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.9059 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9075 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.9084 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154229.9096 l5m8nt5fsodjig5dvq05el3b4q Query : select sestamp valor from se where ref ='324.686.00.01' and lote = 'r2400127100a'
20241212@154229.9109 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9129 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.9145 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b037895675b0465de','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154229.9151 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9171 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.9206 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b037895675b0465de',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut675b090338675b046548' ,0,0 ,2,23.00,160000,?,?,?,?,?)
20241212@154229.9463 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9480 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.9506 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9521 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.9529 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154229.9543 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9586 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154229.9599 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b030983675b0465e9','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154229.9615 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9632 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154229.9661 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b030983675b0465e9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b090338675b046548' ,0,0 ,2,23.00,170000,?,?,?)
20241212@154229.9933 l5m8nt5fsodjig5dvq05el3b4q Query : use flama_phc
20241212@154229.9937 l5m8nt5fsodjig5dvq05el3b4q Query : select st.usalote valor from st where st.ref = '324.686.00.01'
20241212@154229.9961 l5m8nt5fsodjig5dvq05el3b4q 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.686.00.01'
20241212@154229.9978 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154229.9999 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.2900 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.4500 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.5600 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.7000 l5m8nt5fsodjig5dvq05el3b4q Query : select sestamp valor from se where ref ='324.686.00.01' and lote = 'r2400127100a'
20241212@154230.8400 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1000 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.1140 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b062103675b046602','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.1180 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1350 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.1660 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b062103675b046602',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut675b090338675b046548' ,0,0 ,2,23.00,190000,?,?,?,?,?)
20241212@154230.4060 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.4240 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.4500 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.4690 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.4780 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.4910 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.5070 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.5210 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b021016675b04660b','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.5250 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.5410 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.5710 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b021016675b04660b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b090338675b046548' ,0,0 ,2,23.00,200000,?,?,?)
20241212@154230.8330 l5m8nt5fsodjig5dvq05el3b4q Query : use flama_phc
20241212@154230.8360 l5m8nt5fsodjig5dvq05el3b4q Query : select st.usalote valor from st where st.ref = '324.686.00.01'
20241212@154230.8590 l5m8nt5fsodjig5dvq05el3b4q 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.686.00.01'
20241212@154230.8740 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.8960 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.9230 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.9390 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.9480 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.9610 l5m8nt5fsodjig5dvq05el3b4q Query : select sestamp valor from se where ref ='324.686.00.01' and lote = 'r2400127100a'
20241212@154230.9760 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1156 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.1172 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b010670675b046617','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.1179 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1198 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.1230 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b010670675b046617',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675b090338675b046548' ,0,0 ,2,23.00,220000,?,?,?,?,?)
20241212@154230.1505 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1527 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.1554 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1569 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.1578 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.1599 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1649 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.1665 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b012955675b046627','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.1671 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.1691 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.1724 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b012955675b046627',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b090338675b046548' ,0,0 ,2,23.00,230000,?,?,?)
20241212@154230.2017 l5m8nt5fsodjig5dvq05el3b4q Query : use flama_phc
20241212@154230.2021 l5m8nt5fsodjig5dvq05el3b4q Query : select st.usalote valor from st where st.ref = '324.686.00.01'
20241212@154230.2044 l5m8nt5fsodjig5dvq05el3b4q 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.686.00.01'
20241212@154230.2064 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2085 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.2113 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2129 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.2138 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.2151 l5m8nt5fsodjig5dvq05el3b4q Query : select sestamp valor from se where ref ='324.686.00.01' and lote = 'r2400127100a'
20241212@154230.2164 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2184 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.2200 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b096270675b046634','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.2204 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2220 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.2248 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b096270675b046634',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut675b090338675b046548' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20241212@154230.2514 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2538 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.2570 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2591 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.2601 l5m8nt5fsodjig5dvq05el3b4q Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.2614 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2658 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.2670 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b048885675b04663f','aut675b090338675b046548' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.2675 l5m8nt5fsodjig5dvq05el3b4q Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.2693 l5m8nt5fsodjig5dvq05el3b4q Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.2894 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b048885675b04663f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b090338675b046548' ,0,0 ,2,23.00,260000,?,?,?)
20241212@154230.3153 l5m8nt5fsodjig5dvq05el3b4q Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675b090338675b046548','2408542','wait',39,'adm09112754980.682000002')
20241212@154230.3228 l5m8nt5fsodjig5dvq05el3b4q Query : use flama_phc
20241212@154230.3231 l5m8nt5fsodjig5dvq05el3b4q Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@154230.3262 l5m8nt5fsodjig5dvq05el3b4q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3943';
20241212@154230.3305 l5m8nt5fsodjig5dvq05el3b4q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3943';
20241212@154230.3354 l5m8nt5fsodjig5dvq05el3b4q Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3943';
20241212@154230.3386 l5m8nt5fsodjig5dvq05el3b4q Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3943';
20241212@154230.3947 6oa4pclv1ania4puh3g8f5hq60 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@154230.3958 6oa4pclv1ania4puh3g8f5hq60 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@154230.4030 6oa4pclv1ania4puh3g8f5hq60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3944';
20241212@154230.4094 6oa4pclv1ania4puh3g8f5hq60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3944';
20241212@154230.4155 6oa4pclv1ania4puh3g8f5hq60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3944';
20241212@154230.4187 6oa4pclv1ania4puh3g8f5hq60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3944';
20241212@154230.4265 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.4269 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@154230.4337 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.4340 6oa4pclv1ania4puh3g8f5hq60 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20241212@154230.4389 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20241212@154230.4525 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408543 and bi.ref ='324.4421.00.1' and bi.lordem =1
20241212@154230.4891 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.4421.00.1'
20241212@154230.4913 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408543 and bi.ref ='324.4421.00.1' and bi.lordem =1
20241212@154230.4931 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.4934 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@154230.4967 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.4971 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 1 valor from td where td.ndoc = 39
20241212@154230.5003 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.5006 6oa4pclv1ania4puh3g8f5hq60 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')
20241212@154230.5038 6oa4pclv1ania4puh3g8f5hq60 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
20241212@154230.5076 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.5080 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20241212@154230.5113 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.5116 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@154230.5148 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.5151 6oa4pclv1ania4puh3g8f5hq60 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@154230.5190 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.5193 6oa4pclv1ania4puh3g8f5hq60 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20241212@154230.5239 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.5242 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from td where ndoc = 39
20241212@154230.5256 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@154230.5295 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.5312 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154230.5335 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.5353 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154230.5386 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.5401 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154230.5416 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154230.5478 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154230.5493 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.5509 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154230.5526 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675b040496675b046684' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@154230.5687 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.5731 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154230.5768 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@154230.5782 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@154230.5796 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@154230.5817 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@154230.5830 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@154230.5842 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@154230.5854 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675b040496675b046684',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@154230.6080 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 fno valor from wsftdata order by fno desc
20241212@154230.6131 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.6149 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154230.6172 6oa4pclv1ania4puh3g8f5hq60 Query : select 'normal' from dummy
20241212@154230.6189 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675b040496675b046684',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2430,100810,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@154230.6453 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.6457 6oa4pclv1ania4puh3g8f5hq60 Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20241212@154230.6479 6oa4pclv1ania4puh3g8f5hq60 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.4421.00.1'
20241212@154230.6607 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.6622 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.6647 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.6662 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.6670 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.6682 6oa4pclv1ania4puh3g8f5hq60 Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2400920200a'
20241212@154230.6696 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.6710 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.6733 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b070218675b0466a3','aut675b040496675b046684' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.6738 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.6752 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.6803 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b070218675b0466a3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',45.000 ,'aut675b040496675b046684' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@154230.7555 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.7718 6oa4pclv1ania4puh3g8f5hq60 Query : select st.usalote valor from st where st.ref = '324.4421.00.1'
20241212@154230.8114 6oa4pclv1ania4puh3g8f5hq60 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.4421.00.1'
20241212@154230.8128 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.8145 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.8169 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.8184 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.8192 6oa4pclv1ania4puh3g8f5hq60 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154230.8204 6oa4pclv1ania4puh3g8f5hq60 Query : select sestamp valor from se where ref ='324.4421.00.1' and lote = 'r2400920200a'
20241212@154230.8216 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.8392 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154230.8456 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b018844675b0466c8','aut675b040496675b046684' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154230.8461 6oa4pclv1ania4puh3g8f5hq60 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154230.8478 6oa4pclv1ania4puh3g8f5hq60 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154230.8514 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b018844675b0466c8',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut675b040496675b046684' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241212@154230.8752 6oa4pclv1ania4puh3g8f5hq60 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675b040496675b046684','2408543','wait',39,'adm09112754980.682000002')
20241212@154230.8845 6oa4pclv1ania4puh3g8f5hq60 Query : use flama_phc
20241212@154230.8849 6oa4pclv1ania4puh3g8f5hq60 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@154230.8882 6oa4pclv1ania4puh3g8f5hq60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3944';
20241212@154230.8925 6oa4pclv1ania4puh3g8f5hq60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3944';
20241212@154230.8983 6oa4pclv1ania4puh3g8f5hq60 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3944';
20241212@154230.9038 6oa4pclv1ania4puh3g8f5hq60 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3944';
20241212@154230.9544 spdbr0glnemcroj5lh5iq2rg8o Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@154230.9555 spdbr0glnemcroj5lh5iq2rg8o Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@154230.9628 spdbr0glnemcroj5lh5iq2rg8o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3945';
20241212@154230.9696 spdbr0glnemcroj5lh5iq2rg8o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3945';
20241212@154230.9760 spdbr0glnemcroj5lh5iq2rg8o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3945';
20241212@154230.9793 spdbr0glnemcroj5lh5iq2rg8o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3945';
20241212@154230.9870 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154230.9874 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@154230.9938 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154230.9942 spdbr0glnemcroj5lh5iq2rg8o Query : select no, estab,szadrsdesc from szadrs where u_coddest=1404
20241212@154231.3800 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241212@154231.1690 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408544 and bi.ref ='324.1824.00.1' and bi.lordem =1
20241212@154231.4930 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241212@154231.5140 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408544 and bi.ref ='324.1824.00.1' and bi.lordem =1
20241212@154231.5320 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1824.00.1'
20241212@154231.5510 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408544 and bi.ref ='324.1824.00.1' and bi.lordem =2
20241212@154231.8650 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.678.00.01'
20241212@154231.9840 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408544 and bi.ref ='324.678.00.01' and bi.lordem =3
20241212@154231.1315 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1319 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@154231.1355 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1361 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 1 valor from td where td.ndoc = 39
20241212@154231.1397 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1400 spdbr0glnemcroj5lh5iq2rg8o 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')
20241212@154231.1430 spdbr0glnemcroj5lh5iq2rg8o 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
20241212@154231.1491 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1495 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 ~inactivo valor from cl where no = '102206' and estab = 0 order by inactivo desc
20241212@154231.1611 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1615 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@154231.1649 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1652 spdbr0glnemcroj5lh5iq2rg8o Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@154231.1717 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1720 spdbr0glnemcroj5lh5iq2rg8o Query : select szadrsstamp valor from szadrs where szadrsdesc='manuel domingos cavaco & filhos, lda.'
20241212@154231.1769 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.1772 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from td where ndoc = 39
20241212@154231.1786 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@154231.1803 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.1821 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154231.1843 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.1859 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154231.1909 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.1926 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154231.1942 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154231.1998 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154231.2012 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.2028 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154231.2063 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@154231.2222 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.2240 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154231.3454 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@154231.3470 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@154231.3486 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@154231.3497 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@154231.3508 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@154231.3520 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@154231.3532 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675b058531675b04672f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@154231.3779 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 fno valor from wsftdata order by fno desc
20241212@154231.3810 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.3831 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154231.3854 spdbr0glnemcroj5lh5iq2rg8o Query : select 'normal' from dummy
20241212@154231.3890 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675b058531675b04672f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2431,102206,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@154231.4149 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.4152 spdbr0glnemcroj5lh5iq2rg8o Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241212@154231.4174 spdbr0glnemcroj5lh5iq2rg8o 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.1824.00.1'
20241212@154231.4304 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4320 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.4345 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4359 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.4368 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.4379 spdbr0glnemcroj5lh5iq2rg8o Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241212@154231.4394 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4408 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.4420 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b031655675b04676b','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.4424 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4438 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.4466 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b031655675b04676b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@154231.4791 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4809 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.4837 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4854 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.4864 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.4881 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4899 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.4912 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b058752675b046777','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.4918 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.4935 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.4971 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b058752675b046777',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,20000,?,?,?)
20241212@154231.5289 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.5293 spdbr0glnemcroj5lh5iq2rg8o Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241212@154231.5315 spdbr0glnemcroj5lh5iq2rg8o 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.1824.00.1'
20241212@154231.5332 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.5361 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.5385 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.5399 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.5407 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.5419 spdbr0glnemcroj5lh5iq2rg8o Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241212@154231.5431 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.5446 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.5497 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b005783675b046784','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.5543 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.5699 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.5740 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b005783675b046784',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241212@154231.5991 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6009 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.6038 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6055 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.6064 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.6077 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6114 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.6126 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b007208675b046794','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.6131 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6147 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.6178 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b007208675b046794',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,50000,?,?,?)
20241212@154231.6409 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.6412 spdbr0glnemcroj5lh5iq2rg8o Query : select st.usalote valor from st where st.ref = '324.1824.00.1'
20241212@154231.6432 spdbr0glnemcroj5lh5iq2rg8o 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.1824.00.1'
20241212@154231.6449 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6465 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.6491 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6506 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.6514 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.6527 spdbr0glnemcroj5lh5iq2rg8o Query : select sestamp valor from se where ref ='324.1824.00.1' and lote = 'r2400216200a'
20241212@154231.6540 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6578 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.6593 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b049635675b04679f','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.6598 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6616 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.6648 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b049635675b04679f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20241212@154231.6884 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6901 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.6926 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6941 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.6949 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.6962 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.6976 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.7010 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b007836675b0467a9','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.7014 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.7031 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.7073 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b007836675b0467a9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,80000,?,?,?)
20241212@154231.7309 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.7313 spdbr0glnemcroj5lh5iq2rg8o Query : select st.usalote valor from st where st.ref = '324.678.00.01'
20241212@154231.7355 spdbr0glnemcroj5lh5iq2rg8o 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.678.00.01'
20241212@154231.7491 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.7508 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.7536 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.7553 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.7562 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.7575 spdbr0glnemcroj5lh5iq2rg8o Query : select sestamp valor from se where ref ='324.678.00.01' and lote = 'r2400745200a'
20241212@154231.7604 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.7620 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.7632 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b043287675b0467b9','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.7637 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.7651 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.7682 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b043287675b0467b9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,100000,?,?,?,?,?)
20241212@154231.7944 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.7962 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.7990 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.8005 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.8013 spdbr0glnemcroj5lh5iq2rg8o Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154231.8025 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.8044 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154231.8056 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b019811675b0467c3','aut675b058531675b04672f' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154231.8060 spdbr0glnemcroj5lh5iq2rg8o Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154231.8076 spdbr0glnemcroj5lh5iq2rg8o Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154231.8104 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut675b019811675b0467c3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut675b058531675b04672f' ,0,0 ,2,23.00,110000,?,?,?)
20241212@154231.8357 spdbr0glnemcroj5lh5iq2rg8o Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675b058531675b04672f','2408544','wait',39,'adm09112754980.682000002')
20241212@154231.8428 spdbr0glnemcroj5lh5iq2rg8o Query : use flama_phc
20241212@154231.8431 spdbr0glnemcroj5lh5iq2rg8o Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@154231.8468 spdbr0glnemcroj5lh5iq2rg8o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3945';
20241212@154231.8510 spdbr0glnemcroj5lh5iq2rg8o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3945';
20241212@154231.8559 spdbr0glnemcroj5lh5iq2rg8o Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3945';
20241212@154231.8592 spdbr0glnemcroj5lh5iq2rg8o Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3945';
20241212@154231.9148 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@154231.9159 s30ntoil3ifms3osiqm5o3k9i9 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@154231.9244 s30ntoil3ifms3osiqm5o3k9i9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3946';
20241212@154231.9308 s30ntoil3ifms3osiqm5o3k9i9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3946';
20241212@154231.9372 s30ntoil3ifms3osiqm5o3k9i9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3946';
20241212@154231.9408 s30ntoil3ifms3osiqm5o3k9i9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3946';
20241212@154231.9468 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154231.9472 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@154231.9555 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154231.9559 s30ntoil3ifms3osiqm5o3k9i9 Query : select no, estab,szadrsdesc from szadrs where u_coddest=1760
20241212@154231.9652 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.966.00.01'
20241212@154231.9792 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408545 and bi.ref ='324.966.00.01' and bi.lordem =2
20241212@154232.1460 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20241212@154232.1660 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408545 and bi.ref ='324.1684.00.1' and bi.lordem =4
20241212@154232.5520 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1684.00.1'
20241212@154232.5770 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408545 and bi.ref ='324.1684.00.1' and bi.lordem =5
20241212@154232.9370 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20241212@154232.1102 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408545 and bi.ref ='324.958.00.01' and bi.lordem =6
20241212@154232.1450 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.958.00.01'
20241212@154232.1472 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408545 and bi.ref ='324.958.00.01' and bi.lordem =6
20241212@154232.1490 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1494 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@154232.1527 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1553 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 1 valor from td where td.ndoc = 39
20241212@154232.1583 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1586 s30ntoil3ifms3osiqm5o3k9i9 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')
20241212@154232.1615 s30ntoil3ifms3osiqm5o3k9i9 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
20241212@154232.1650 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1653 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 ~inactivo valor from cl where no = '102395' and estab = 0 order by inactivo desc
20241212@154232.1764 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1768 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@154232.1798 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1801 s30ntoil3ifms3osiqm5o3k9i9 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@154232.1842 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1850 s30ntoil3ifms3osiqm5o3k9i9 Query : select szadrsstamp valor from szadrs where szadrsdesc='evoracor - sociedade distribuidora, lda'
20241212@154232.1903 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.1906 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from td where ndoc = 39
20241212@154232.1919 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@154232.1934 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.1957 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154232.1978 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.1995 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154232.2025 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.2040 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154232.2080 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154232.2141 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154232.2156 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.2175 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154232.2192 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675b015771675b046832' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@154232.2345 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.2385 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154232.2419 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@154232.2650 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@154232.3865 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@154232.3881 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@154232.3894 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@154232.3907 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@154232.3919 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675b015771675b046832',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@154232.4385 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 fno valor from wsftdata order by fno desc
20241212@154232.4734 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.4991 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154232.5371 s30ntoil3ifms3osiqm5o3k9i9 Query : select 'normal' from dummy
20241212@154232.5582 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675b015771675b046832',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2432,102395,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@154232.5858 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.5861 s30ntoil3ifms3osiqm5o3k9i9 Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20241212@154232.5885 s30ntoil3ifms3osiqm5o3k9i9 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.966.00.01'
20241212@154232.6060 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6078 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.6106 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6127 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.6138 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154232.6153 s30ntoil3ifms3osiqm5o3k9i9 Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2400743200a'
20241212@154232.6172 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6214 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.6226 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b073815675b046896','aut675b015771675b046832' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154232.6231 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6245 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.6290 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b073815675b046896',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut675b015771675b046832' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@154232.6564 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.6568 s30ntoil3ifms3osiqm5o3k9i9 Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20241212@154232.6592 s30ntoil3ifms3osiqm5o3k9i9 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.1684.00.1'
20241212@154232.6608 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6625 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.6669 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6686 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.6697 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154232.6711 s30ntoil3ifms3osiqm5o3k9i9 Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2400208100a'
20241212@154232.6727 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6743 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.6757 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b060941675b0468a4','aut675b015771675b046832' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154232.6785 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.6802 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.6842 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b060941675b0468a4',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut675b015771675b046832' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20241212@154232.7101 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.7105 s30ntoil3ifms3osiqm5o3k9i9 Query : select st.usalote valor from st where st.ref = '324.1684.00.1'
20241212@154232.7127 s30ntoil3ifms3osiqm5o3k9i9 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.1684.00.1'
20241212@154232.7150 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7178 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.7209 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7227 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.7236 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154232.7248 s30ntoil3ifms3osiqm5o3k9i9 Query : select sestamp valor from se where ref ='324.1684.00.1' and lote = 'r2400208100a'
20241212@154232.7283 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7299 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.7313 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b090582675b0468b1','aut675b015771675b046832' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154232.7317 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7333 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.7365 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b090582675b0468b1',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut675b015771675b046832' ,0,0 ,2,23.00,30000,?,?,?,?,?)
20241212@154232.7634 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.7638 s30ntoil3ifms3osiqm5o3k9i9 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20241212@154232.7659 s30ntoil3ifms3osiqm5o3k9i9 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.958.00.01'
20241212@154232.7796 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7825 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.7853 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7869 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.7878 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154232.7890 s30ntoil3ifms3osiqm5o3k9i9 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400704200a'
20241212@154232.7904 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7920 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.7932 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b009809675b0468c0','aut675b015771675b046832' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154232.7937 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.7953 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.7986 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b009809675b0468c0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut675b015771675b046832' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20241212@154232.8237 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154232.8240 s30ntoil3ifms3osiqm5o3k9i9 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20241212@154232.8259 s30ntoil3ifms3osiqm5o3k9i9 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.958.00.01'
20241212@154232.8274 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.8290 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.8317 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.8332 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.8342 s30ntoil3ifms3osiqm5o3k9i9 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154232.8376 s30ntoil3ifms3osiqm5o3k9i9 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400704200a'
20241212@154232.8389 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.8405 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154232.8417 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b041893675b0468cc','aut675b015771675b046832' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154232.8422 s30ntoil3ifms3osiqm5o3k9i9 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154232.8438 s30ntoil3ifms3osiqm5o3k9i9 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154232.8471 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b041893675b0468cc',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut675b015771675b046832' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20241212@154232.8737 s30ntoil3ifms3osiqm5o3k9i9 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675b015771675b046832','2408545','wait',39,'adm09112754980.682000002')
20241212@154233.8420 s30ntoil3ifms3osiqm5o3k9i9 Query : use flama_phc
20241212@154233.8500 s30ntoil3ifms3osiqm5o3k9i9 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@154233.8830 s30ntoil3ifms3osiqm5o3k9i9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3946';
20241212@154233.9280 s30ntoil3ifms3osiqm5o3k9i9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3946';
20241212@154233.9790 s30ntoil3ifms3osiqm5o3k9i9 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3946';
20241212@154233.1015 s30ntoil3ifms3osiqm5o3k9i9 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3946';
20241212@154233.1598 0hem96ldmnm93kl8idmq7ruu3h Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@154233.1609 0hem96ldmnm93kl8idmq7ruu3h Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@154233.1678 0hem96ldmnm93kl8idmq7ruu3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3947';
20241212@154233.1781 0hem96ldmnm93kl8idmq7ruu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3947';
20241212@154233.1847 0hem96ldmnm93kl8idmq7ruu3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3947';
20241212@154233.1884 0hem96ldmnm93kl8idmq7ruu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3947';
20241212@154233.1941 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.1944 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@154233.2006 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.2009 0hem96ldmnm93kl8idmq7ruu3h Query : select no, estab,szadrsdesc from szadrs where u_coddest=2114
20241212@154233.2106 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1871.00.1'
20241212@154233.2244 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2085 and bo.obrano = 2408547 and bi.ref ='324.1871.00.1' and bi.lordem =1
20241212@154233.2610 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.2614 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20241212@154233.2660 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.2664 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 1 valor from td where td.ndoc = 39
20241212@154233.2695 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.2698 0hem96ldmnm93kl8idmq7ruu3h 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')
20241212@154233.2727 0hem96ldmnm93kl8idmq7ruu3h 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
20241212@154233.2763 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.2767 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 ~inactivo valor from cl where no = '101850' and estab = 0 order by inactivo desc
20241212@154233.3100 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.3104 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 tipodoc,regrd from td where ndoc = 39
20241212@154233.3138 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.3142 0hem96ldmnm93kl8idmq7ruu3h Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@154233.3183 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.3186 0hem96ldmnm93kl8idmq7ruu3h Query : select szadrsstamp valor from szadrs where szadrsdesc='os jerÓnimos-ind.e com.de mÓveis,lda.'
20241212@154233.3235 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.3238 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from td where ndoc = 39
20241212@154233.3252 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20241212@154233.3270 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.3289 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154233.3318 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.3335 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154233.3369 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.3390 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154233.3437 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154233.3501 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20241212@154233.3515 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.3536 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20241212@154233.3554 0hem96ldmnm93kl8idmq7ruu3h Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut675b004257675b046953' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20241212@154233.3732 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.3913 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20241212@154233.3971 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20241212@154233.3984 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20241212@154233.3997 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20241212@154233.4013 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20241212@154233.4028 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20241212@154233.4040 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20241212@154233.4053 0hem96ldmnm93kl8idmq7ruu3h Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut675b004257675b046953',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20241212@154233.4279 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 fno valor from wsftdata order by fno desc
20241212@154233.4330 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.4348 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20241212@154233.4375 0hem96ldmnm93kl8idmq7ruu3h Query : select 'normal' from dummy
20241212@154233.4390 0hem96ldmnm93kl8idmq7ruu3h Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut675b004257675b046953',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2433,101850,0,'2024-12-12',39,'euro',0,0,2024 ,?,?)
20241212@154233.4667 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.4671 0hem96ldmnm93kl8idmq7ruu3h Query : select st.usalote valor from st where st.ref = '324.1871.00.1'
20241212@154233.4696 0hem96ldmnm93kl8idmq7ruu3h 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.1871.00.1'
20241212@154233.4848 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.4869 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154233.4899 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.4917 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154233.4930 0hem96ldmnm93kl8idmq7ruu3h Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20241212@154233.4942 0hem96ldmnm93kl8idmq7ruu3h Query : select sestamp valor from se where ref ='324.1871.00.1' and lote = 'r2400437200a'
20241212@154233.4964 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.4979 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20241212@154233.4990 0hem96ldmnm93kl8idmq7ruu3h Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b087269675b046979','aut675b004257675b046953' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20241212@154233.4995 0hem96ldmnm93kl8idmq7ruu3h Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154233.5010 0hem96ldmnm93kl8idmq7ruu3h Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20241212@154233.5038 0hem96ldmnm93kl8idmq7ruu3h Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut675b087269675b046979',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut675b004257675b046953' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20241212@154233.5299 0hem96ldmnm93kl8idmq7ruu3h Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut675b004257675b046953','2408547','wait',39,'adm09112754980.682000002')
20241212@154233.5377 0hem96ldmnm93kl8idmq7ruu3h Query : use flama_phc
20241212@154233.5385 0hem96ldmnm93kl8idmq7ruu3h Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20241212@154233.5415 0hem96ldmnm93kl8idmq7ruu3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3947';
20241212@154233.5455 0hem96ldmnm93kl8idmq7ruu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3947';
20241212@154233.5506 0hem96ldmnm93kl8idmq7ruu3h Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3947';
20241212@154233.5558 0hem96ldmnm93kl8idmq7ruu3h Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3947';
20241212@154233.6055 abkoqv0t4d38svdbr93l9f6r5s Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@154233.6067 abkoqv0t4d38svdbr93l9f6r5s Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@154233.6136 abkoqv0t4d38svdbr93l9f6r5s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3948';
20241212@154233.6227 abkoqv0t4d38svdbr93l9f6r5s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3948';
20241212@154233.6289 abkoqv0t4d38svdbr93l9f6r5s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3948';
20241212@154233.6326 abkoqv0t4d38svdbr93l9f6r5s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3948';
20241212@154233.7279 et22ulf5bta5no513g90ikb9ic Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20241212@154233.7291 et22ulf5bta5no513g90ikb9ic Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20241212@154233.7361 et22ulf5bta5no513g90ikb9ic Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3949';
20241212@154233.7433 et22ulf5bta5no513g90ikb9ic Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3949';
20241212@154233.7500 et22ulf5bta5no513g90ikb9ic Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='3949';
20241212@154233.7548 et22ulf5bta5no513g90ikb9ic Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='3949';
20241212@154233.7607 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154233.7611 et22ulf5bta5no513g90ikb9ic Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20241212@154233.7679 et22ulf5bta5no513g90ikb9ic Query : select no, estab,szadrsdesc from szadrs where u_coddest=23
20241212@154233.7794 et22ulf5bta5no513g90ikb9ic Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.4970.00.1'
20241212@154233.9133 et22ulf5bta5no513g90ikb9ic Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000047 and bi.ref ='324.4970.00.1' and bi.lordem =10000
20241212@154233.9481 et22ulf5bta5no513g90ikb9ic Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24121149845,788000001 ' 
20241212@154233.9822 et22ulf5bta5no513g90ikb9ic Query : select top 1 isnull(design,'') valor from st (nolock) where st.ref = '324.1293.00.1'
20241212@154234.1150 et22ulf5bta5no513g90ikb9ic Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =054 and bo.boano =2024 and bo.obrano = 0000047 and bi.ref ='324.1293.00.1' and bi.lordem =20000
20241212@154234.4390 et22ulf5bta5no513g90ikb9ic Query : select bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.obranome ,bi.bostamp ,bo.moeda ,bi.vumoeda ,isnull(bi.vumoeda/nullif(bi.edebito,0),1) cambio ,bi.tabiva from bi inner join bo on bi.bostamp = bo.bostamp where bi.bistamp = 'pll24121149868,949000002 ' 
20241212@154234.7570 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154234.7600 et22ulf5bta5no513g90ikb9ic Query : select top 1 1 valor from ts where ts.ndos = 5
20241212@154234.7960 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154234.8000 et22ulf5bta5no513g90ikb9ic 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')
20241212@154234.8570 et22ulf5bta5no513g90ikb9ic Query : select top 1 assinadoc issigned ,ts.stocks ,ts.bdempresas origin ,case when (cmstocks between 1 and 50 or cm2stocks between 1 and 50 ) then 1 else 0 end entrada ,case when cmstocks>50 or (cm2stocks>50 and trfa =1) then 1 else 0 end saida ,stneg validatestock ,tiposaft ,veserie useserialnumber ,foserie assetin ,ftserie assetout ,veserie assets ,trfarm assetstransfer ,grelha usegridfields from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos =5
20241212@154234.9000 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154234.9030 et22ulf5bta5no513g90ikb9ic Query : select top 1 ~inactivo valor from fl where no = '100999' and estab = 0 order by inactivo desc
20241212@154234.1004 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154234.1008 et22ulf5bta5no513g90ikb9ic Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20241212@154234.1058 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154234.1067 et22ulf5bta5no513g90ikb9ic Query : select szadrsstamp valor from szadrs where szadrsdesc='flama-fab.louÇas e electrodomesticos,sa'
20241212@154234.1143 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154234.1146 et22ulf5bta5no513g90ikb9ic Query : select 1 valor from ts where ndos = 5
20241212@154234.1208 et22ulf5bta5no513g90ikb9ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154234.1227 et22ulf5bta5no513g90ikb9ic Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo' and documentnumber = 5
20241212@154234.1240 et22ulf5bta5no513g90ikb9ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154234.1256 et22ulf5bta5no513g90ikb9ic Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo2' and documentnumber = 5
20241212@154234.1265 et22ulf5bta5no513g90ikb9ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154234.1283 et22ulf5bta5no513g90ikb9ic Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bo3' and documentnumber = 5
20241212@154234.1300 et22ulf5bta5no513g90ikb9ic Query : select top 1 ts2.manternumero, ts.tiposaft, ts.idserie,ts.nmdos,ts.bdempresas from ts inner join ts2 on ts.tsstamp=ts2.ts2stamp where ts.ndos = 5
20241212@154234.1418 et22ulf5bta5no513g90ikb9ic Query : select top 1 bo.obrano valor from bo bo where bo.ndos = 5 and boano=2024 order by obrano desc
20241212@154234.1541 et22ulf5bta5no513g90ikb9ic Query : select top 1 bo.obrano valor from wsbodata bo where bo.ndos = 5 and boano=2024 order by obrano desc
20241212@154234.1616 et22ulf5bta5no513g90ikb9ic Query : use flama_phc
20241212@154234.1622 et22ulf5bta5no513g90ikb9ic Query : select top 1 no,estab,nome, morada, local,codpost,ncont,pncont,pais,inactivo,motiseimp,codmotiseimp from fl where no='100999' and estab=0
20241212@154234.1693 et22ulf5bta5no513g90ikb9ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154234.1733 et22ulf5bta5no513g90ikb9ic Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo3' and documentnumber = 5
20241212@154234.1748 et22ulf5bta5no513g90ikb9ic Query : insert into wsbo3data (bo3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut675b070446675b046a27',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut')
20241212@154234.1831 et22ulf5bta5no513g90ikb9ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154234.1848 et22ulf5bta5no513g90ikb9ic Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo2' and documentnumber = 5
20241212@154234.1861 et22ulf5bta5no513g90ikb9ic Query : insert into wsbo2data (bo2stamp, tiposaft, idserie,cambio,cambiofixo,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,xpddata,xpdhora,carga,descar) values ('aut675b070446675b046a27','ga','bo',0 ,0,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut','20241212','16:12',?,?)
20241212@154234.2460 et22ulf5bta5no513g90ikb9ic Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20241212@154234.2488 et22ulf5bta5no513g90ikb9ic Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bo' and documentnumber = 5
20241212@154234.2509 et22ulf5bta5no513g90ikb9ic Query : insert into wsbodata (bostamp, nmdos, dataobra, ndos, obrano, no, estab, nome, ncont, morada, local, codpost, moeda, boano, memissao,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,maquina ) values ('aut675b070446675b046a27','trf entre armazéns a','2024-12-12',5,599,?,?,?,?,?,?,?,?,2024, (select valor from para1 where descricao = 'ge_euro') ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',?)
