20240909@073346.1554 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.1572 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.1684 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.1700 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.1709 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.1723 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.1739 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.1752 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de96715666de96ca2a','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.1757 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.1771 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.1800 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de96715666de96ca2a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,230000,?,?,?)
20240909@073346.2073 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.2076 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240909@073346.2097 kstg2b876ehqaohc6k6do0h605 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.642.00.01'
20240909@073346.2112 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2129 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.2166 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2181 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.2190 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.2201 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240909@073346.2214 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2228 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.2240 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de92719066de96ca36','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.2245 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2259 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.2289 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de92719066de96ca36',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',4.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,250000,?,?,?,?,?)
20240909@073346.2559 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.2562 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.642.00.01'
20240909@073346.2582 kstg2b876ehqaohc6k6do0h605 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.642.00.01'
20240909@073346.2597 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2613 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.2638 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2653 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.2662 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.2675 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.642.00.01' and lote = 'r2100892200a'
20240909@073346.2688 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2702 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.2714 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de95952966de96ca41','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.2718 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.2734 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.2764 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de95952966de96ca41',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,260000,?,?,?,?,?)
20240909@073346.3055 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.3058 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240909@073346.3080 kstg2b876ehqaohc6k6do0h605 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.4521.00.1'
20240909@073346.3094 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3112 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.3138 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3153 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.3161 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.3174 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240909@073346.3187 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3201 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.3213 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de93133166de96ca4d','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.3217 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3236 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.3264 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de93133166de96ca4d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',12.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,270000,?,?,?,?,?)
20240909@073346.3543 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.3546 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.4521.00.1'
20240909@073346.3566 kstg2b876ehqaohc6k6do0h605 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.4521.00.1'
20240909@073346.3580 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3595 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.3621 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3636 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.3644 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.3656 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.4521.00.1' and lote = 'r2400052200a'
20240909@073346.3668 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3682 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.3693 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de91391266de96ca59','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.3697 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.3710 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.3739 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de91391266de96ca59',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,280000,?,?,?,?,?)
20240909@073346.4011 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.4014 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.719.00.01'
20240909@073346.4036 kstg2b876ehqaohc6k6do0h605 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.719.00.01'
20240909@073346.4358 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4376 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.4404 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4420 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.4430 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.4442 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.719.00.01' and lote = 'r2300383300a'
20240909@073346.4499 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4514 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.4526 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de94317166de96ca6d','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.4530 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4546 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.4593 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de94317166de96ca6d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',8.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,290000,?,?,?,?,?)
20240909@073346.4874 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4890 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.4915 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4930 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.4939 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.4951 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4965 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.4976 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de95293566de96ca78','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.4980 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.4995 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.5024 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de95293566de96ca78',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,300000,?,?,?)
20240909@073346.5290 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.5293 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.1528.00.1'
20240909@073346.5315 kstg2b876ehqaohc6k6do0h605 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.1528.00.1'
20240909@073346.5330 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5345 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.5370 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5384 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.5392 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.5405 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.1528.00.1' and lote = 'r2200263100a'
20240909@073346.5417 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5431 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.5443 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de94742366de96ca84','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.5448 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5462 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.5490 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de94742366de96ca84',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',3.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,320000,?,?,?,?,?)
20240909@073346.5784 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.5787 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.1528.00.1'
20240909@073346.5807 kstg2b876ehqaohc6k6do0h605 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.1528.00.1'
20240909@073346.5821 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5838 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.5862 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5877 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.5885 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.5897 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.1528.00.1' and lote = 'r2200263100a'
20240909@073346.5913 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5927 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.5938 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de90333166de96ca90','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.5942 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.5956 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.6002 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de90333166de96ca90',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,330000,?,?,?,?,?)
20240909@073346.6275 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.6280 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.1578.00.1'
20240909@073346.6301 kstg2b876ehqaohc6k6do0h605 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.1578.00.1'
20240909@073346.6455 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.6472 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.6497 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.6511 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.6519 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.6531 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.1578.00.1' and lote = 'r2101115200a'
20240909@073346.6563 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.6578 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.6590 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de98665566de96caa0','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.6594 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.6608 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.6647 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de98665566de96caa0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,340000,?,?,?,?,?)
20240909@073346.6917 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.6920 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240909@073346.6941 kstg2b876ehqaohc6k6do0h605 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20240909@073346.6955 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.6977 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.7005 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7020 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.7029 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.7041 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2301282200a'
20240909@073346.7054 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7068 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.7081 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de91528466de96caac','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.7085 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7100 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.7129 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de91528466de96caac',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,350000,?,?,?,?,?)
20240909@073346.7436 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7453 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.7478 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7493 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.7502 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.7514 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7528 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.7540 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de95718266de96cab7','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.7544 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7559 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.7587 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de95718266de96cab7',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,360000,?,?,?)
20240909@073346.7874 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.7877 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240909@073346.7896 kstg2b876ehqaohc6k6do0h605 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20240909@073346.7910 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7925 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.7960 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.7974 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.7983 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.7999 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2301282200a'
20240909@073346.8012 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8027 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.8039 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de91853966de96cac3','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.8043 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8057 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.8085 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de91853966de96cac3',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,380000,?,?,?,?,?)
20240909@073346.8357 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8373 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.8400 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8427 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.8436 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.8448 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8462 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.8474 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de94619866de96cace','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.8478 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8493 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.8520 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de94619866de96cace',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,390000,?,?,?)
20240909@073346.8786 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.8789 kstg2b876ehqaohc6k6do0h605 Query : select st.usalote valor from st where st.ref = '324.958.00.01'
20240909@073346.8809 kstg2b876ehqaohc6k6do0h605 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'
20240909@073346.8823 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8838 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.8863 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8878 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.8886 kstg2b876ehqaohc6k6do0h605 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073346.8898 kstg2b876ehqaohc6k6do0h605 Query : select sestamp valor from se where ref ='324.958.00.01' and lote = 'r2400240200a'
20240909@073346.8910 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8924 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073346.8936 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de98180066de96cad9','aut66de97799066de96c8f1' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073346.8940 kstg2b876ehqaohc6k6do0h605 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073346.8954 kstg2b876ehqaohc6k6do0h605 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073346.8982 kstg2b876ehqaohc6k6do0h605 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de98180066de96cad9',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',20.000 ,'aut66de97799066de96c8f1' ,0,0 ,2,23.00,410000,?,?,?,?,?)
20240909@073346.9248 kstg2b876ehqaohc6k6do0h605 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66de97799066de96c8f1','2405765','wait',39,'adm09112754980.682000002')
20240909@073346.9322 kstg2b876ehqaohc6k6do0h605 Query : use flama_phc
20240909@073346.9325 kstg2b876ehqaohc6k6do0h605 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@073346.9359 kstg2b876ehqaohc6k6do0h605 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1863';
20240909@073346.9388 kstg2b876ehqaohc6k6do0h605 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1863';
20240909@073346.9427 kstg2b876ehqaohc6k6do0h605 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1863';
20240909@073346.9451 kstg2b876ehqaohc6k6do0h605 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1863';
20240909@073346.9997 ia04uicdvea2e2lpnb3b23tush Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@073347.9000 ia04uicdvea2e2lpnb3b23tush Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@073347.6900 ia04uicdvea2e2lpnb3b23tush Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1864';
20240909@073347.1268 ia04uicdvea2e2lpnb3b23tush Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1864';
20240909@073347.1323 ia04uicdvea2e2lpnb3b23tush Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1864';
20240909@073347.1350 ia04uicdvea2e2lpnb3b23tush Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1864';
20240909@073347.1397 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.1401 ia04uicdvea2e2lpnb3b23tush Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@073347.1478 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.1481 ia04uicdvea2e2lpnb3b23tush Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240909@073347.1563 ia04uicdvea2e2lpnb3b23tush Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1643.00.1'
20240909@073347.1729 ia04uicdvea2e2lpnb3b23tush Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405767 and bi.ref ='324.1643.00.1' and bi.lordem =1
20240909@073347.2070 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2074 ia04uicdvea2e2lpnb3b23tush Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@073347.2107 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2110 ia04uicdvea2e2lpnb3b23tush Query : select top 1 1 valor from td where td.ndoc = 39
20240909@073347.2141 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2143 ia04uicdvea2e2lpnb3b23tush 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')
20240909@073347.2178 ia04uicdvea2e2lpnb3b23tush 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
20240909@073347.2216 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2219 ia04uicdvea2e2lpnb3b23tush Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@073347.2357 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2360 ia04uicdvea2e2lpnb3b23tush Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@073347.2389 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2393 ia04uicdvea2e2lpnb3b23tush Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@073347.2436 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2439 ia04uicdvea2e2lpnb3b23tush Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240909@073347.2488 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.2491 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from td where ndoc = 39
20240909@073347.2504 ia04uicdvea2e2lpnb3b23tush Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@073347.2517 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.2533 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073347.2553 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.2567 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073347.2599 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.2614 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073347.2627 ia04uicdvea2e2lpnb3b23tush Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073347.2705 ia04uicdvea2e2lpnb3b23tush Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073347.2718 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.2734 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073347.2751 ia04uicdvea2e2lpnb3b23tush Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66de98884866de96cb40' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@073347.2943 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.2963 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073347.3000 ia04uicdvea2e2lpnb3b23tush Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@073347.3015 ia04uicdvea2e2lpnb3b23tush Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@073347.3027 ia04uicdvea2e2lpnb3b23tush Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@073347.3040 ia04uicdvea2e2lpnb3b23tush Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@073347.3051 ia04uicdvea2e2lpnb3b23tush Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@073347.3062 ia04uicdvea2e2lpnb3b23tush Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@073347.3073 ia04uicdvea2e2lpnb3b23tush Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66de98884866de96cb40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@073347.3708 ia04uicdvea2e2lpnb3b23tush Query : select top 1 fno valor from wsftdata order by fno desc
20240909@073347.3732 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.3750 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073347.3773 ia04uicdvea2e2lpnb3b23tush Query : select 'normal' from dummy
20240909@073347.3788 ia04uicdvea2e2lpnb3b23tush Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66de98884866de96cb40',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',630,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@073347.4114 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.4117 ia04uicdvea2e2lpnb3b23tush Query : select st.usalote valor from st where st.ref = '324.1643.00.1'
20240909@073347.4142 ia04uicdvea2e2lpnb3b23tush Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1643.00.1'
20240909@073347.4300 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.4317 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073347.4344 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.4438 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073347.4549 ia04uicdvea2e2lpnb3b23tush Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073347.4562 ia04uicdvea2e2lpnb3b23tush Query : select sestamp valor from se where ref ='324.1643.00.1' and lote = 'r2101218200a'
20240909@073347.4591 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.4610 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073347.4622 ia04uicdvea2e2lpnb3b23tush Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de91526166de96cb70','aut66de98884866de96cb40' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073347.4627 ia04uicdvea2e2lpnb3b23tush Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.4642 ia04uicdvea2e2lpnb3b23tush Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073347.4676 ia04uicdvea2e2lpnb3b23tush Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de91526166de96cb70',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66de98884866de96cb40' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@073347.4960 ia04uicdvea2e2lpnb3b23tush Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66de98884866de96cb40','2405767','wait',39,'adm09112754980.682000002')
20240909@073347.5051 ia04uicdvea2e2lpnb3b23tush Query : use flama_phc
20240909@073347.5054 ia04uicdvea2e2lpnb3b23tush Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@073347.5085 ia04uicdvea2e2lpnb3b23tush Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1864';
20240909@073347.5115 ia04uicdvea2e2lpnb3b23tush Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1864';
20240909@073347.5154 ia04uicdvea2e2lpnb3b23tush Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1864';
20240909@073347.5180 ia04uicdvea2e2lpnb3b23tush Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1864';
20240909@073347.5676 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@073347.5687 5vs3hdaaguer0ruo4equ9ipen2 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@073347.5743 5vs3hdaaguer0ruo4equ9ipen2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1865';
20240909@073347.5800 5vs3hdaaguer0ruo4equ9ipen2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1865';
20240909@073347.5851 5vs3hdaaguer0ruo4equ9ipen2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1865';
20240909@073347.5877 5vs3hdaaguer0ruo4equ9ipen2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1865';
20240909@073347.5927 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.5930 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@073347.5997 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.6000 5vs3hdaaguer0ruo4equ9ipen2 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2150
20240909@073347.6094 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.1879.00.1'
20240909@073347.6261 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405776 and bi.ref ='324.1879.00.1' and bi.lordem =1
20240909@073347.7616 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2031.00.1'
20240909@073347.7803 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405776 and bi.ref ='324.2031.00.1' and bi.lordem =2
20240909@073347.8125 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.2232.00.1'
20240909@073347.8283 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405776 and bi.ref ='324.2232.00.1' and bi.lordem =3
20240909@073347.8621 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.8624 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@073347.8657 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.8660 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 1 valor from td where td.ndoc = 39
20240909@073347.8702 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.8705 5vs3hdaaguer0ruo4equ9ipen2 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')
20240909@073347.8733 5vs3hdaaguer0ruo4equ9ipen2 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
20240909@073347.8768 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.8772 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 ~inactivo valor from cl where no = '101345' and estab = 0 order by inactivo desc
20240909@073347.8906 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.8909 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@073347.8941 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.8952 5vs3hdaaguer0ruo4equ9ipen2 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@073347.8992 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.8995 5vs3hdaaguer0ruo4equ9ipen2 Query : select szadrsstamp valor from szadrs where szadrsdesc='celestino fÉlix silvestre herdºs.'
20240909@073347.9041 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073347.9044 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from td where ndoc = 39
20240909@073347.9056 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@073347.9072 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.9088 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073347.9109 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.9124 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073347.9166 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.9181 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073347.9194 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073347.9264 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073347.9277 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.9295 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073347.9311 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66de99620966de96cbe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@073347.9508 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.9527 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073347.9571 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@073347.9584 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@073347.9597 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@073347.9608 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@073347.9620 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@073347.9632 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@073347.9644 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66de99620966de96cbe0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@073347.9921 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 fno valor from wsftdata order by fno desc
20240909@073347.9943 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073347.9959 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073348.1000 5vs3hdaaguer0ruo4equ9ipen2 Query : select 'normal' from dummy
20240909@073348.1600 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66de99620966de96cbe0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',631,101345,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@073348.3430 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073348.3460 5vs3hdaaguer0ruo4equ9ipen2 Query : select st.usalote valor from st where st.ref = '324.1879.00.1'
20240909@073348.3700 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1879.00.1'
20240909@073348.5320 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.5490 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.5780 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.5930 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.6020 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073348.6140 5vs3hdaaguer0ruo4equ9ipen2 Query : select sestamp valor from se where ref ='324.1879.00.1' and lote = 'r2300643200a'
20240909@073348.6430 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.6600 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.6720 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de93017866de96cc0f','aut66de99620966de96cbe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073348.6770 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.6920 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.7230 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de93017866de96cc0f',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66de99620966de96cbe0' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@073348.1013 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1031 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.1057 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1072 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.1106 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073348.1119 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1135 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.1161 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de92758066de96cc1b','aut66de99620966de96cbe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073348.1165 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1181 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.1210 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de92758066de96cc1b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de99620966de96cbe0' ,0,0 ,2,23.00,20000,?,?,?)
20240909@073348.1493 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073348.1496 5vs3hdaaguer0ruo4equ9ipen2 Query : select st.usalote valor from st where st.ref = '324.2031.00.1'
20240909@073348.1518 5vs3hdaaguer0ruo4equ9ipen2 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.2031.00.1'
20240909@073348.1678 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1696 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.1732 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1747 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.1756 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073348.1768 5vs3hdaaguer0ruo4equ9ipen2 Query : select sestamp valor from se where ref ='324.2031.00.1' and lote = 'r2100232100a'
20240909@073348.1795 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1813 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.1874 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de99434366de96cc2b','aut66de99620966de96cbe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073348.1883 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.1955 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.2001 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de99434366de96cc2b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',6.000 ,'aut66de99620966de96cbe0' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240909@073348.2346 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.2364 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.2392 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.2408 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.2416 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073348.2430 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.2445 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.2458 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de92822766de96cc3b','aut66de99620966de96cbe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073348.2462 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.2477 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.2506 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de92822766de96cc3b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de99620966de96cbe0' ,0,0 ,2,23.00,50000,?,?,?)
20240909@073348.2802 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073348.2806 5vs3hdaaguer0ruo4equ9ipen2 Query : select st.usalote valor from st where st.ref = '324.2232.00.1'
20240909@073348.2827 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2232.00.1'
20240909@073348.2988 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.3005 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.3033 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.3053 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.3062 5vs3hdaaguer0ruo4equ9ipen2 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073348.3075 5vs3hdaaguer0ruo4equ9ipen2 Query : select sestamp valor from se where ref ='324.2232.00.1' and lote = 'r2400241100a'
20240909@073348.3089 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.3104 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.3116 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de93023066de96cc4b','aut66de99620966de96cbe0' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073348.3120 5vs3hdaaguer0ruo4equ9ipen2 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.3135 5vs3hdaaguer0ruo4equ9ipen2 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.3165 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de93023066de96cc4b',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66de99620966de96cbe0' ,0,0 ,2,23.00,70000,?,?,?,?,?)
20240909@073348.4732 5vs3hdaaguer0ruo4equ9ipen2 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66de99620966de96cbe0','2405776','wait',39,'adm09112754980.682000002')
20240909@073348.4914 5vs3hdaaguer0ruo4equ9ipen2 Query : use flama_phc
20240909@073348.4917 5vs3hdaaguer0ruo4equ9ipen2 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@073348.4948 5vs3hdaaguer0ruo4equ9ipen2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1865';
20240909@073348.4978 5vs3hdaaguer0ruo4equ9ipen2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1865';
20240909@073348.5018 5vs3hdaaguer0ruo4equ9ipen2 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1865';
20240909@073348.5043 5vs3hdaaguer0ruo4equ9ipen2 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1865';
20240909@073348.5642 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@073348.5654 aroob4mn0h04vcr1ov5ccmgpm4 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@073348.5709 aroob4mn0h04vcr1ov5ccmgpm4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1866';
20240909@073348.5781 aroob4mn0h04vcr1ov5ccmgpm4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1866';
20240909@073348.5850 aroob4mn0h04vcr1ov5ccmgpm4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1866';
20240909@073348.5877 aroob4mn0h04vcr1ov5ccmgpm4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1866';
20240909@073348.5930 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.5934 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@073348.6002 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.6005 aroob4mn0h04vcr1ov5ccmgpm4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=4740
20240909@073348.6048 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5540.00.1'
20240909@073348.6216 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405777 and bi.ref ='324.5540.00.1' and bi.lordem =1
20240909@073348.6545 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5342.00.1'
20240909@073348.6566 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405777 and bi.ref ='324.5342.00.1' and bi.lordem =2
20240909@073348.6891 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '324.5396.00.1'
20240909@073348.7050 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405777 and bi.ref ='324.5396.00.1' and bi.lordem =3
20240909@073348.7383 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7387 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@073348.7421 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7424 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 1 valor from td where td.ndoc = 39
20240909@073348.7454 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7456 aroob4mn0h04vcr1ov5ccmgpm4 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')
20240909@073348.7484 aroob4mn0h04vcr1ov5ccmgpm4 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
20240909@073348.7518 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7521 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@073348.7551 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7554 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@073348.7590 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7592 aroob4mn0h04vcr1ov5ccmgpm4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@073348.7634 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7636 aroob4mn0h04vcr1ov5ccmgpm4 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-equipamentos para o lar,sa.'
20240909@073348.7681 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.7684 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from td where ndoc = 39
20240909@073348.7696 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@073348.7709 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.7726 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073348.7744 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.7758 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073348.7786 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.7800 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073348.7812 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073348.7881 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073348.7894 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.7908 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073348.7923 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66de92051666de96ccbe' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@073348.8114 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.8131 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073348.8163 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@073348.8176 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@073348.8187 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@073348.8199 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@073348.8211 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@073348.8222 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@073348.8234 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66de92051666de96ccbe',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@073348.8543 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 fno valor from wsftdata order by fno desc
20240909@073348.8564 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.8579 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073348.8601 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 'normal' from dummy
20240909@073348.8616 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66de92051666de96ccbe',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',632,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@073348.8924 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.8928 aroob4mn0h04vcr1ov5ccmgpm4 Query : select st.usalote valor from st where st.ref = '324.5540.00.1'
20240909@073348.8950 aroob4mn0h04vcr1ov5ccmgpm4 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.5540.00.1'
20240909@073348.9104 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9120 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.9145 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9160 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.9168 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073348.9180 aroob4mn0h04vcr1ov5ccmgpm4 Query : select sestamp valor from se where ref ='324.5540.00.1' and lote = 'r2300830100a'
20240909@073348.9205 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9223 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.9234 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de93592066de96cce0','aut66de92051666de96ccbe' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073348.9245 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9259 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.9291 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de93592066de96cce0',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',5.000 ,'aut66de92051666de96ccbe' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@073348.9574 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073348.9577 aroob4mn0h04vcr1ov5ccmgpm4 Query : select st.usalote valor from st where st.ref = '324.5342.00.1'
20240909@073348.9599 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.5342.00.1'
20240909@073348.9613 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9629 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.9655 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9673 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.9681 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073348.9693 aroob4mn0h04vcr1ov5ccmgpm4 Query : select sestamp valor from se where ref ='324.5342.00.1' and lote = 'r2301282200a'
20240909@073348.9705 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9719 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073348.9731 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de92973866de96ccec','aut66de92051666de96ccbe' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073348.9735 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073348.9750 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073348.9780 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de92973866de96ccec',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',42.000 ,'aut66de92051666de96ccbe' ,0,0 ,2,23.00,20000,?,?,?,?,?)
20240909@073349.5400 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7100 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.9600 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.1100 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.1180 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073349.1300 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.1440 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.1550 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de91731266de96cd03','aut66de92051666de96ccbe' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073349.1590 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.1750 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.2020 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de91731266de96cd03',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de92051666de96ccbe' ,0,0 ,2,23.00,30000,?,?,?)
20240909@073349.4760 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073349.4790 aroob4mn0h04vcr1ov5ccmgpm4 Query : select st.usalote valor from st where st.ref = '324.5396.00.1'
20240909@073349.5000 aroob4mn0h04vcr1ov5ccmgpm4 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.5396.00.1'
20240909@073349.6530 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.6690 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.6940 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7090 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.7170 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073349.7290 aroob4mn0h04vcr1ov5ccmgpm4 Query : select sestamp valor from se where ref ='324.5396.00.1' and lote = 'r2300840100a'
20240909@073349.7500 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7640 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.7770 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de91930666de96cd12','aut66de92051666de96ccbe' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073349.7810 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7960 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.8230 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de91930666de96cd12',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',30.000 ,'aut66de92051666de96ccbe' ,0,0 ,2,23.00,50000,?,?,?,?,?)
20240909@073349.1144 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.1162 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.1189 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.1204 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.1213 aroob4mn0h04vcr1ov5ccmgpm4 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073349.1226 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.1243 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.1256 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de92348266de96cd1d','aut66de92051666de96ccbe' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073349.1261 aroob4mn0h04vcr1ov5ccmgpm4 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.1277 aroob4mn0h04vcr1ov5ccmgpm4 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.1309 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de92348266de96cd1d',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de92051666de96ccbe' ,0,0 ,2,23.00,60000,?,?,?)
20240909@073349.1585 aroob4mn0h04vcr1ov5ccmgpm4 Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66de92051666de96ccbe','2405777','wait',39,'adm09112754980.682000002')
20240909@073349.1662 aroob4mn0h04vcr1ov5ccmgpm4 Query : use flama_phc
20240909@073349.1665 aroob4mn0h04vcr1ov5ccmgpm4 Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@073349.1695 aroob4mn0h04vcr1ov5ccmgpm4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1866';
20240909@073349.1724 aroob4mn0h04vcr1ov5ccmgpm4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1866';
20240909@073349.1763 aroob4mn0h04vcr1ov5ccmgpm4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1866';
20240909@073349.1786 aroob4mn0h04vcr1ov5ccmgpm4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1866';
20240909@073349.2258 frmqn7uu3n7jdpubbgo9bagnda Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@073349.2273 frmqn7uu3n7jdpubbgo9bagnda Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@073349.2327 frmqn7uu3n7jdpubbgo9bagnda Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1867';
20240909@073349.2381 frmqn7uu3n7jdpubbgo9bagnda Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1867';
20240909@073349.2433 frmqn7uu3n7jdpubbgo9bagnda Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1867';
20240909@073349.2460 frmqn7uu3n7jdpubbgo9bagnda Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1867';
20240909@073349.2527 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.2530 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@073349.2596 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.2599 frmqn7uu3n7jdpubbgo9bagnda Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240909@073349.2702 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9326.00.1'
20240909@073349.2865 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405778 and bi.ref ='328.9326.00.1' and bi.lordem =1
20240909@073349.3233 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '328.9345.00.1'
20240909@073349.3396 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405778 and bi.ref ='328.9345.00.1' and bi.lordem =2
20240909@073349.3726 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.3729 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@073349.3761 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.3764 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 1 valor from td where td.ndoc = 39
20240909@073349.3795 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.3798 frmqn7uu3n7jdpubbgo9bagnda 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')
20240909@073349.4597 frmqn7uu3n7jdpubbgo9bagnda 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
20240909@073349.5241 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.5244 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@073349.5276 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.5301 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@073349.5341 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.5344 frmqn7uu3n7jdpubbgo9bagnda Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@073349.5383 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.5386 frmqn7uu3n7jdpubbgo9bagnda Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20240909@073349.5432 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.5435 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from td where ndoc = 39
20240909@073349.5446 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@073349.5461 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.5478 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073349.5512 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.5528 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073349.5558 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.5574 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073349.5589 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073349.5666 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073349.5683 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.5698 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073349.5715 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66de91224466de96cd88' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@073349.5909 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.5931 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073349.5969 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@073349.5983 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@073349.5996 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@073349.6010 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@073349.6022 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@073349.6034 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@073349.6046 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66de91224466de96cd88',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@073349.6337 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 fno valor from wsftdata order by fno desc
20240909@073349.6363 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.6381 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073349.6404 frmqn7uu3n7jdpubbgo9bagnda Query : select 'normal' from dummy
20240909@073349.6421 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66de91224466de96cd88',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',633,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@073349.6724 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.6728 frmqn7uu3n7jdpubbgo9bagnda Query : select st.usalote valor from st where st.ref = '328.9326.00.1'
20240909@073349.6751 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9326.00.1'
20240909@073349.6902 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.6919 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.6948 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.6963 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.6972 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073349.6984 frmqn7uu3n7jdpubbgo9bagnda Query : select sestamp valor from se where ref ='328.9326.00.1' and lote = 'r2300691100a'
20240909@073349.7011 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7027 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.7041 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de95621166de96cdab','aut66de91224466de96cd88' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073349.7045 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7059 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.7088 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de95621166de96cdab',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66de91224466de96cd88' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@073349.7367 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7386 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.7413 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7428 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.7437 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073349.7450 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7464 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.7476 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de95071966de96cdb5','aut66de91224466de96cd88' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073349.7481 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7496 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.7526 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de95071966de96cdb5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de91224466de96cd88' ,0,0 ,2,23.00,20000,?,?,?)
20240909@073349.7794 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.7797 frmqn7uu3n7jdpubbgo9bagnda Query : select st.usalote valor from st where st.ref = '328.9345.00.1'
20240909@073349.7820 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '328.9345.00.1'
20240909@073349.7976 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.7994 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.8021 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.8037 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.8046 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073349.8058 frmqn7uu3n7jdpubbgo9bagnda Query : select sestamp valor from se where ref ='328.9345.00.1' and lote = 'r2101101300a'
20240909@073349.8080 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.8096 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.8108 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de92748066de96cdc5','aut66de91224466de96cd88' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073349.8113 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.8127 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.8155 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de92748066de96cdc5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',1.000 ,'aut66de91224466de96cd88' ,0,0 ,2,23.00,40000,?,?,?,?,?)
20240909@073349.8436 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.8452 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.8478 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.8493 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.8501 frmqn7uu3n7jdpubbgo9bagnda Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073349.8513 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.8528 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073349.8540 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de95864166de96cdcf','aut66de91224466de96cd88' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073349.8544 frmqn7uu3n7jdpubbgo9bagnda Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073349.8561 frmqn7uu3n7jdpubbgo9bagnda Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073349.8590 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,armazem) values ('aut66de95864166de96cdcf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',0 ,'aut66de91224466de96cd88' ,0,0 ,2,23.00,50000,?,?,?)
20240909@073349.8863 frmqn7uu3n7jdpubbgo9bagnda Query : insert into wsftcreationlog (initialftstamp,externalid,creationstatus,documenttypeid,idustamp) values ('aut66de91224466de96cd88','2405778','wait',39,'adm09112754980.682000002')
20240909@073349.8936 frmqn7uu3n7jdpubbgo9bagnda Query : use flama_phc
20240909@073349.8940 frmqn7uu3n7jdpubbgo9bagnda Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20240909@073349.8971 frmqn7uu3n7jdpubbgo9bagnda Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1867';
20240909@073349.9001 frmqn7uu3n7jdpubbgo9bagnda Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1867';
20240909@073349.9040 frmqn7uu3n7jdpubbgo9bagnda Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1867';
20240909@073349.9062 frmqn7uu3n7jdpubbgo9bagnda Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1867';
20240909@073349.9563 7n81cj5c6qugop913c4u0nq2e1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20240909@073349.9574 7n81cj5c6qugop913c4u0nq2e1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20240909@073349.9629 7n81cj5c6qugop913c4u0nq2e1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1868';
20240909@073349.9685 7n81cj5c6qugop913c4u0nq2e1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1868';
20240909@073349.9737 7n81cj5c6qugop913c4u0nq2e1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='1868';
20240909@073349.9762 7n81cj5c6qugop913c4u0nq2e1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='1868';
20240909@073349.9809 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073349.9812 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20240909@073349.9882 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073349.9885 7n81cj5c6qugop913c4u0nq2e1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=6737
20240909@073349.9927 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 isnull(design,'') valor from st (nolock) left join stobs (nolock) on st.ref = stobs.ref where st.ref = '327.8152.00.1'
20240909@073350.9700 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 bistamp valor from bi inner join bo on bo.bostamp=bi.bostamp where bo.ndos =240 and bo.boano =2057 and bo.obrano = 2405779 and bi.ref ='327.8152.00.1' and bi.lordem =1
20240909@073350.4590 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.4630 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 convert(date,fdata) valor from ft where ndoc = 39 and anulado= 0 and fno>0 order by fdata desc
20240909@073350.5010 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.5040 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 1 valor from td where td.ndoc = 39
20240909@073350.5350 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.5380 7n81cj5c6qugop913c4u0nq2e1 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')
20240909@073350.5690 7n81cj5c6qugop913c4u0nq2e1 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
20240909@073350.6070 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.6100 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 ~inactivo valor from cl where no = '100810' and estab = 0 order by inactivo desc
20240909@073350.6410 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.6440 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 tipodoc,regrd from td where ndoc = 39
20240909@073350.6750 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.6790 7n81cj5c6qugop913c4u0nq2e1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20240909@073350.7190 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.7220 7n81cj5c6qugop913c4u0nq2e1 Query : select szadrsstamp valor from szadrs where szadrsdesc='100810 - worten-plaza large formats rainha'
20240909@073350.7670 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.7700 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from td where ndoc = 39
20240909@073350.7830 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 manternumero, tiposaft, nmdos,td.assinadoc from td where td.ndoc = 39
20240909@073350.7990 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.8220 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073350.8430 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.8580 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073350.8870 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.9020 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073350.9180 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 ft.fno valor from ft ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073350.9870 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 ft.fno valor from wsftdata ft where ft.ndoc = 39 and ftano=2024 order by fno desc
20240909@073350.1001 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.1016 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft3' and documentnumber = 39
20240909@073350.1033 7n81cj5c6qugop913c4u0nq2e1 Query : insert into wsft3data (ft3stamp, ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis,taxpointdt ) values ('aut66de93689166de96ce16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?)
20240909@073350.1215 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.1232 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft2' and documentnumber = 39
20240909@073350.1265 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 bo.u_nomeenv valor from bo where bo.bostamp=''
20240909@073350.1277 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 bo.u_moradaen valor from bo where bo.bostamp=''
20240909@073350.1289 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 bo.u_codposen valor from bo where bo.bostamp=''
20240909@073350.1311 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 bo.u_localenv valor from bo where bo.bostamp=''
20240909@073350.2459 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 bo.trab5 valor from bo where bo.bostamp=''
20240909@073350.2474 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 bo.serie valor from bo where bo.bostamp=''
20240909@073350.2485 7n81cj5c6qugop913c4u0nq2e1 Query : insert into wsft2data (ft2stamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,u_nomeenv ,u_moradaen ,u_codposen ,u_localenv ,u_coddest ,u_codby ) values ('aut66de93689166de96ce16',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',?,?,?,?,?,?)
20240909@073350.2749 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 fno valor from wsftdata order by fno desc
20240909@073350.2773 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.2790 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'ft' and documentnumber = 39
20240909@073350.2813 7n81cj5c6qugop913c4u0nq2e1 Query : select 'normal' from dummy
20240909@073350.2828 7n81cj5c6qugop913c4u0nq2e1 Query : insert into wsftdata (ftstamp, ousrdata,ousrhora, usrdata,usrhora,ousrinis,usrinis,fno,no,estab,fdata,ndoc,moeda,cambio,cambiofixo,ftano,site ,classe ) values ('aut66de93689166de96ce16',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',634,100810,0,'2024-09-09',39,'euro',0,0,2024 ,?,?)
20240909@073350.3158 7n81cj5c6qugop913c4u0nq2e1 Query : use flama_phc
20240909@073350.3162 7n81cj5c6qugop913c4u0nq2e1 Query : select st.usalote valor from st where st.ref = '327.8152.00.1'
20240909@073350.3185 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '327.8152.00.1'
20240909@073350.3342 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.3364 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073350.3391 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.3406 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073350.3418 7n81cj5c6qugop913c4u0nq2e1 Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20240909@073350.3430 7n81cj5c6qugop913c4u0nq2e1 Query : select sestamp valor from se where ref ='327.8152.00.1' and lote = 'r2200712200a'
20240909@073350.3459 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.3474 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi2' and documentnumber = 39
20240909@073350.3487 7n81cj5c6qugop913c4u0nq2e1 Query : insert into wsfi2data (fi2stamp,ftstamp ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) values ('aut66de92003966de96ce54','aut66de93689166de96ce16' ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv')
20240909@073350.3492 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.3509 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'fi' and documentnumber = 39
20240909@073350.3540 7n81cj5c6qugop913c4u0nq2e1 Query : insert into wsfidata (fistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,qtt ,ftstamp ,epv,pvmoeda ,tabiva,iva,lordem ,ref, design ,lote,armazem,bistamp ) values ('aut66de92003966de96ce54',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'wsv','wsv',2.000 ,'aut66de93689166de96ce16' ,0,0 ,2,23.00,10000,?,?,?,?,?)
20240909@073350.3833 7n81cj5c6qugop913c4u0nq2e1 Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20240909@073350.3853 7n81cj5c6qugop913c4u0nq2e1 Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'fi' and documentnumber = 39
